PHP ArticlePeer::doSelect方法代码示例

 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();
     }
 }