public function joinRecord($joinDataObj, $joinName = "")
    {
        // get the maintable of the joindataobj
        $joinTable = $joinDataObj->mainTableName;
        $joinRecord = null;
        $returnRecord = array();

        // find the proper join according to join name and the maintable
        foreach ($this->tableJoins as $tableJoin) {
            if (($joinName == $tableJoin->objectName || $joinName == "") && $tableJoin->table == $joinTable) {
                // populate the column-fieldvalue to columnRef-fieldvalue
                // get the field mapping to the column, then get the field value
                $joinFieldName = $joinDataObj->bizRecord->getFieldByColumn($tableJoin->column); // joined-main table
                if (!$joinFieldName)
                    continue;
                if (!$joinRecord)
                    $joinRecord = $joinDataObj->getActiveRecord();
                $refFieldName = $this->bizRecord->getFieldByColumn($tableJoin->columnRef); // join table
                $returnRecord[$refFieldName] = $joinRecord[$joinFieldName];
                // populate joinRecord's field to current record
                foreach ($this->bizRecord as $fld) {
                    if ($fld->join == $tableJoin->objectName) {
                        // use join column to match joinRecord field's column
                        $jfldname = $joinDataObj->bizRecord->getFieldByColumn($fld->column); // joined-main table
                        $returnRecord[$fld->objectName] = $joinRecord[$jfldname];
                    }
                }
                break;
            }
        }
        // return a modified record with joined record data
        return $returnRecord;
    }
public function joinRecord($joinDataObj, $joinName = "")
    {
        // get the maintable of the joindataobj
        $joinTable = $joinDataObj->mainTableName;
        $joinRecord = null;
        $returnRecord = array();

        // find the proper join according to join name and the maintable
        foreach ($this->tableJoins as $tableJoin) {
            if (($joinName == $tableJoin->objectName || $joinName == "") && $tableJoin->table == $joinTable) {
                // populate the column-fieldvalue to columnRef-fieldvalue
                // get the field mapping to the column, then get the field value
                $joinFieldName = $joinDataObj->bizRecord->getFieldByColumn($tableJoin->column); // joined-main table
                if (!$joinFieldName)
                    continue;
                if (!$joinRecord)
                    $joinRecord = $joinDataObj->getActiveRecord();
                $refFieldName = $this->bizRecord->getFieldByColumn($tableJoin->columnRef); // join table
                $returnRecord[$refFieldName] = $joinRecord[$joinFieldName];
                // populate joinRecord's field to current record
                foreach ($this->bizRecord as $fld) {
                    if ($fld->join == $tableJoin->objectName) {
                        // use join column to match joinRecord field's column
                        $jfldname = $joinDataObj->bizRecord->getFieldByColumn($fld->column); // joined-main table
                        $returnRecord[$fld->objectName] = $joinRecord[$jfldname];
                    }
                }
                break;
            }
        }
        // return a modified record with joined record data
        return $returnRecord;
    }
public function joinRecord ( $ joinDataObj , $ joinName = "" ) { // get the maintable of the joindataobj $ joinTable = $ joinDataObj -> mainTableName ; $ joinRecord = null ; $ returnRecord = array ( ) ; // find the proper join according to join name and the maintable foreach ( $ this -> tableJoins as $ tableJoin ) { if ( ( $ joinName == $ tableJoin -> objectName || $ joinName == "" ) && $ tableJoin -> table == $ joinTable ) { // populate the column-fieldvalue to columnRef-fieldvalue // get the field mapping to the column, then get the field value $ joinFieldName = $ joinDataObj -> bizRecord -> getFieldByColumn ( $ tableJoin -> column ) ; // joined-main table if ( ! $ joinFieldName ) continue ; if ( ! $ joinRecord ) $ joinRecord = $ joinDataObj -> getActiveRecord ( ) ; $ refFieldName = $ this -> bizRecord -> getFieldByColumn ( $ tableJoin -> columnRef ) ; // join table $ returnRecord [ $ refFieldName ] = $ joinRecord [ $ joinFieldName ] ; // populate joinRecord's field to current record foreach ( $ this -> bizRecord as $ fld ) { if ( $ fld -> join == $ tableJoin -> objectName ) { // use join column to match joinRecord field's column $ jfldname = $ joinDataObj -> bizRecord -> getFieldByColumn ( $ fld -> column ) ; // joined-main table $ returnRecord [ $ fld -> objectName ] = $ joinRecord [ $ jfldname ] ; } } break ; } } // return a modified record with joined record data return $ returnRecord ; }
Pick the joined object's current record to the current record

@param BizDataObj $joinDataObj
@param string $joinName name of join (optional)
@return array return a modified record with joined record data
Pick the joined object s current record to the current record