Esempio n. 1
0
 /**
  * Retrieve multiple objects by pkey.
  *
  * @param      array $pks List of primary keys
  * @param      PropelPDO $con the connection to use
  * @throws     PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function retrieveByPKs($pks, PropelPDO $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(ItemRatingPeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     $objs = null;
     if (empty($pks)) {
         $objs = array();
     } else {
         $criteria = new Criteria(ItemRatingPeer::DATABASE_NAME);
         $criteria->add(ItemRatingPeer::ID, $pks, Criteria::IN);
         $objs = ItemRatingPeer::doSelect($criteria, $con);
     }
     return $objs;
 }
Esempio n. 2
0
 public function executeRate()
 {
     if ($this->getRequest()->isXmlHttpRequest()) {
         $rating = $this->getRequestParameter('rating');
         $item_id = $this->getRequestParameter('it');
         if ($rating > 5) {
             $rating = 5;
         }
         if ($rating < 0) {
             $rating = 0;
         }
         $this->user = $this->getUser()->getRaykuUser();
         $c = new Criteria();
         $c->add(ItemRatingPeer::ITEM_ID, $item_id);
         $c->add(ItemRatingPeer::USER_ID, $this->user->getId());
         $item_rating = ItemRatingPeer::doSelect($c);
         if ($item_rating) {
             return $this->renderText('already');
         } else {
             $item_rating = new ItemRating();
             $item_rating->setUserId($this->user->getId());
             $item_rating->setItemId($item_id);
             $item_rating->setRating($rating);
             $item_rating->save();
             return $this->renderText('success');
         }
         return $this->renderText('fail');
     }
 }
Esempio n. 3
0
 /**
  * Gets an array of ItemRating objects which contain a foreign key that references this object.
  *
  * If this collection has already been initialized with an identical Criteria, it returns the collection.
  * Otherwise if this User has previously been saved, it will retrieve
  * related ItemRatings from storage. If this User is new, it will return
  * an empty collection or the current collection, the criteria is ignored on a new object.
  *
  * @param      PropelPDO $con
  * @param      Criteria $criteria
  * @return     array ItemRating[]
  * @throws     PropelException
  */
 public function getItemRatings($criteria = null, PropelPDO $con = null)
 {
     if ($criteria === null) {
         $criteria = new Criteria(UserPeer::DATABASE_NAME);
     } elseif ($criteria instanceof Criteria) {
         $criteria = clone $criteria;
     }
     if ($this->collItemRatings === null) {
         if ($this->isNew()) {
             $this->collItemRatings = array();
         } else {
             $criteria->add(ItemRatingPeer::USER_ID, $this->id);
             ItemRatingPeer::addSelectColumns($criteria);
             $this->collItemRatings = ItemRatingPeer::doSelect($criteria, $con);
         }
     } else {
         // criteria has no effect for a new object
         if (!$this->isNew()) {
             // the following code is to determine if a new query is
             // called for.  If the criteria is the same as the last
             // one, just return the collection.
             $criteria->add(ItemRatingPeer::USER_ID, $this->id);
             ItemRatingPeer::addSelectColumns($criteria);
             if (!isset($this->lastItemRatingCriteria) || !$this->lastItemRatingCriteria->equals($criteria)) {
                 $this->collItemRatings = ItemRatingPeer::doSelect($criteria, $con);
             }
         }
     }
     $this->lastItemRatingCriteria = $criteria;
     return $this->collItemRatings;
 }