public function executePartidoResult() { $this->quote = ''; if (SfVoUtil::matches($this->obj->getNombre(), $this->q)) { } else { if (SfVoUtil::matches($this->obj->getAbreviatura(), $this->q)) { } else { if (SfVoUtil::matches($this->obj->getPresentacion(), $this->q)) { $this->quote = $this->obj->getPresentacion(); } else { $c = new Criteria(); $c->add(SfReviewPeer::ENTITY_ID, $this->obj->getId()); $c->add(SfReviewPeer::SF_REVIEW_TYPE_ID, Partido::NUM_ENTITY); $c->add(SfReviewPeer::IS_ACTIVE, true); $c->add(SfReviewPeer::CULTURE, sfContext::getInstance()->getUser()->getCulture()); $reviews = SfReviewPeer::doSelect($c); foreach ($reviews as $review) { if (SfVoUtil::matches($review->getText(), $this->q)) { $this->quote = $review->getText(); } } if ($this->quote == '') { foreach ($reviews as $review) { if (SfVoUtil::matches($review->getText(), $this->q, true)) { $this->quote = $review->getText(); } } } } } } $this->quote = SfVoUtil::highlightWords($this->quote, $this->q); }
/** * Gets an array of SfReview 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 sfGuardUser has previously been saved, it will retrieve * related SfReviews from storage. If this sfGuardUser 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 SfReview[] * @throws PropelException */ public function getSfReviews($criteria = null, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(sfGuardUserPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collSfReviews === null) { if ($this->isNew()) { $this->collSfReviews = array(); } else { $criteria->add(SfReviewPeer::SF_GUARD_USER_ID, $this->id); SfReviewPeer::addSelectColumns($criteria); $this->collSfReviews = SfReviewPeer::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(SfReviewPeer::SF_GUARD_USER_ID, $this->id); SfReviewPeer::addSelectColumns($criteria); if (!isset($this->lastSfReviewCriteria) || !$this->lastSfReviewCriteria->equals($criteria)) { $this->collSfReviews = SfReviewPeer::doSelect($criteria, $con); } } } $this->lastSfReviewCriteria = $criteria; return $this->collSfReviews; }
public function executeInit(sfWebRequest $request) { $this->reviewEntityId = $request->getParameter("e"); $box = $request->getParameter("b"); $this->reviewType = $request->getParameter("t"); if ($box && $box != '') { $this->reviewBox = $box; } if ($this->getUser()->isAuthenticated()) { $criteria = new Criteria(); $criteria->add(SfReviewPeer::ENTITY_ID, $this->reviewEntityId); $criteria->add(SfReviewPeer::SF_GUARD_USER_ID, $this->getUser()->getGuardUser()->getId()); $criteria->add(SfReviewPeer::SF_REVIEW_TYPE_ID, $this->reviewType); $criteria->add(SfReviewPeer::IS_ACTIVE, true); $review = SfReviewPeer::doSelect($criteria); if ($review) { $this->forward('sfReviewFront', 'preview'); } } $t = $request->getParameter("t"); if ($t == '') { return "SimpleSuccess"; } }
/** * 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(SfReviewPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(SfReviewPeer::DATABASE_NAME); $criteria->add(SfReviewPeer::ID, $pks, Criteria::IN); $objs = SfReviewPeer::doSelect($criteria, $con); } return $objs; }
public static function deleteReviewById($id) { // Primero borrar sus opiniones $c = new Criteria(); $c->add(SfReviewPeer::SF_GUARD_USER_ID, $id); $reviews = SfReviewPeer::doSelect($c); foreach ($reviews as $review) { $c2 = new Criteria(); $c2->add(SfReviewPeer::SF_REVIEW_ID, $review->getId()); $c2->add(SfReviewPeer::SF_REVIEW_TYPE_ID, null); SfReviewPeer::doDelete($c2); } SfReviewPeer::doDelete($c); }