Subversion-Projekte lars-tiefland.prado

Revision

Blame | Letzte Änderung | Log anzeigen | RSS feed

<?php
/**
 * TActiveRecordHasMany class file.
 *
 * @author Wei Zhuo <weizhuo[at]gmail[dot]com>
 * @link http://www.pradosoft.com/
 * @copyright Copyright &copy; 2005-2008 PradoSoft
 * @license http://www.pradosoft.com/license/
 * @version $Id$
 * @package System.Data.ActiveRecord.Relations
 */

/**
 * Loads base active record relations class.
 */
Prado::using('System.Data.ActiveRecord.Relations.TActiveRecordRelation');

/**
 * Implements TActiveRecord::HAS_MANY relationship between the source object having zero or
 * more foreign objects. Consider the <b>entity</b> relationship between a Team and a Player.
 * <code>
 * +------+            +--------+
 * | Team | 1 <----- * | Player |
 * +------+            +--------+
 * </code>
 * Where one team may have 0 or more players and each player belongs to only
 * one team. We may model Team-Player <b>object</b> relationship as active record as follows.
 * <code>
 * class TeamRecord extends TActiveRecord
 * {
 *     const TABLE='team';
 *     public $name; //primary key
 *     public $location;
 *
 *     public $players=array(); //list of players
 *
 *     public static $RELATIONS=array
 *     (
 *         'players' => array(self::HAS_MANY, 'PlayerRecord')
 *     );
 *
 *         public static function finder($className=__CLASS__)
 *         {
 *                 return parent::finder($className);
 *         }
 * }
 * class PlayerRecord extends TActiveRecord
 * {
 *     // see TActiveRecordBelongsTo for detailed definition
 * }
 * </code>
 * The static <tt>$RELATIONS</tt> property of TeamRecord defines that the
 * property <tt>$players</tt> has many <tt>PlayerRecord</tt>s.
 *
 * The players list may be fetched as follows.
 * <code>
 * $team = TeamRecord::finder()->with_players()->findAll();
 * </code>
 * The method <tt>with_xxx()</tt> (where <tt>xxx</tt> is the relationship property
 * name, in this case, <tt>players</tt>) fetchs the corresponding PlayerRecords using
 * a second query (not by using a join). The <tt>with_xxx()</tt> accepts the same
 * arguments as other finder methods of TActiveRecord, e.g. <tt>with_players('age < ?', 35)</tt>.
 *
 * @author Wei Zhuo <weizho[at]gmail[dot]com>
 * @version $Id$
 * @package System.Data.ActiveRecord.Relations
 * @since 3.1
 */
class TActiveRecordHasMany extends TActiveRecordRelation
{
        /**
         * Get the foreign key index values from the results and make calls to the
         * database to find the corresponding foreign objects.
         * @param array original results.
         */
        protected function collectForeignObjects(&$results)
        {
                $fkeys = $this->getRelationForeignKeys();

                $properties = array_values($fkeys);
                $fields = array_keys($fkeys);

                $indexValues = $this->getIndexValues($properties, $results);
                $fkObjects = $this->findForeignObjects($fields,$indexValues);
                $this->populateResult($results,$properties,$fkObjects,$fields);
        }

        /**
         * @return array foreign key field names as key and object properties as value.
         * @since 3.1.2
         */
        public function getRelationForeignKeys()
        {
                $fkObject = $this->getContext()->getForeignRecordFinder();
                return $this->findForeignKeys($fkObject, $this->getSourceRecord());
        }

        /**
         * Updates the associated foreign objects.
         * @return boolean true if all update are success (including if no update was required), false otherwise .
         */
        public function updateAssociatedRecords()
        {
                $obj = $this->getContext()->getSourceRecord();
                $fkObjects = &$obj->{$this->getContext()->getProperty()};
                $success=true;
                if(($total = count($fkObjects))> 0)
                {
                        $source = $this->getSourceRecord();
                        $fkeys = $this->findForeignKeys($fkObjects[0], $source);
                        for($i=0;$i<$total;$i++)
                        {
                                foreach($fkeys as $fKey => $srcKey)
                                        $fkObjects[$i]->setColumnValue($fKey, $source->getColumnValue($srcKey));
                                $success = $fkObjects[$i]->save() && $success;
                        }
                }
                return $success;
        }
}