public function executeShowArchive(sfWebRequest $request) { $c = new Criteria(); $year = $request->getParameter('year'); $month = $request->getParameter('month'); $nextMonth = mktime(0, 0, 0, $month + 1, 0, $year); $thisMonth = mktime(0, 0, 0, $month, 0, $year); $c->add(ArticlePeer::CREATED_AT, $nextMonth, Criteria::LESS_THAN); $c->addAnd(ArticlePeer::CREATED_AT, $thisMonth, Criteria::GREATER_THAN); // $c->addAnd(ArticlePeer::CREATED_AT,$thisMonth,'GREATERTHAN'); $this->posts = ArticlePeer::doSelect($c); }
/** * Gets an array of Article 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 Book has previously been saved, it will retrieve * related Articles from storage. If this Book 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 Article[] * @throws PropelException */ public function getArticles($criteria = null, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(BookPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collArticles === null) { if ($this->isNew()) { $this->collArticles = array(); } else { $criteria->add(ArticlePeer::BOOK_ID, $this->id); ArticlePeer::addSelectColumns($criteria); $this->collArticles = ArticlePeer::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(ArticlePeer::BOOK_ID, $this->id); ArticlePeer::addSelectColumns($criteria); if (!isset($this->lastArticleCriteria) || !$this->lastArticleCriteria->equals($criteria)) { $this->collArticles = ArticlePeer::doSelect($criteria, $con); } } } $this->lastArticleCriteria = $criteria; return $this->collArticles; }
/** * 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(ArticlePeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(ArticlePeer::DATABASE_NAME); $criteria->add(ArticlePeer::ID, $pks, Criteria::IN); $objs = ArticlePeer::doSelect($criteria, $con); } return $objs; }
public function getArticles($criteria = null, $con = null) { include_once 'lib/model/om/BaseArticlePeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collArticles === null) { if ($this->isNew()) { $this->collArticles = array(); } else { $criteria->add(ArticlePeer::CATEGORY_ID, $this->getId()); ArticlePeer::addSelectColumns($criteria); $this->collArticles = ArticlePeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(ArticlePeer::CATEGORY_ID, $this->getId()); ArticlePeer::addSelectColumns($criteria); if (!isset($this->lastArticleCriteria) || !$this->lastArticleCriteria->equals($criteria)) { $this->collArticles = ArticlePeer::doSelect($criteria, $con); } } } $this->lastArticleCriteria = $criteria; return $this->collArticles; }
public function getArticles($criteria = null, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(CategoryPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collArticles === null) { if ($this->isNew()) { $this->collArticles = array(); } else { $criteria->add(ArticlePeer::CATEGORY_ID, $this->id); ArticlePeer::addSelectColumns($criteria); $this->collArticles = ArticlePeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(ArticlePeer::CATEGORY_ID, $this->id); ArticlePeer::addSelectColumns($criteria); if (!isset($this->lastArticleCriteria) || !$this->lastArticleCriteria->equals($criteria)) { $this->collArticles = ArticlePeer::doSelect($criteria, $con); } } } $this->lastArticleCriteria = $criteria; return $this->collArticles; }
/** * @WSMethod(name='getFixtureModel') * * @return Article[] All articles loaded from the database. */ public function executeGetFixtureModel(sfWebRequest $request) { $this->result = ArticlePeer::doSelect(new Criteria()); return sfView::SUCCESS; }
public function executeArchiveList() { $c = new Criteria(); $c->addDescendingOrderByColumn('created_at'); $this->posts = ArticlePeer::doSelect($c); }
public function executeShoppingCart2(sfWebRequest $request) { $this->categories = CategoryPeer::getActiveCategories(); $this->paths = array(); $promoter = $promoter = PromoterPeer::getPromoterByUserId($this->getUser()->getId()); $this->state = $promoter->getIdState(); $this->articles = ArticlePeer::doSelect(new Criteria()); if ($request->isMethod('post')) { $cart = $this->createCartIfNotExists(); foreach ($this->articles as $key => $article) { $value = $request->getParameter($article->getId()); if ($value > 0) { $this->createCartArticle($cart, $article, $value); } } } $cart = CartPeer::getCart($promoter->getClientId()); if (!isset($cart)) { $cart = new Cart(); } $this->cart_articles = $cart->getCartArticles(); //sacar articulos mayor a 1 mes en el carrito foreach ($this->cart_articles as $cart_article) { $fecha = $this->dateadd($cart_article->getUpdatedAt(), 0, 1, 0, 0, 0, 0); $date1 = new DateTime("now"); $date2 = new DateTime($fecha); if ($date1 > $date2) { $cart_article->delete(); $cart_article->save(); } } $this->total = 0; foreach ($this->cart_articles as $cart_article) { $this->total += $cart_article->getPrice() * $cart_article->getQuantity(); } }