public function executeIndex(sfWebRequest $request) { $response = $this->getResponse(); $part_id = $request->getParameter('id'); $this->p = $part_id; $response->setTitle('Фото постеры. Купить фото постер. Каталог'); $response->addMeta('robots', 'Фото постеры. Купить фото постер. Каталог'); $response->addMeta('keywords', 'Фото постеры. Купить фото постер. Каталог'); $this->menu = MenuPeer::doSelect(new Criteria()); $c = new Criteria(); $c->add(PartsPeer::IS_ACTIVE, 1); $this->parts = PartsPeer::doSelect($c); unset($c); $c1 = new Criteria(); $this->items = PhotosPeer::doSelect($c1); if ($part_id) { $cc1 = new Criteria(); $cc1->add(PartsPeer::ID, $part_id); $cc1->add(PartsPeer::IS_ACTIVE, 1); $meta = PartsPeer::doSelect($cc1); $meta_id = $meta[0]->getMetaId(); unset($cc1); $m = new Criteria(); $m->add(MetaPeer::ID, $meta_id); $m->add(MetaPeer::IS_ACTIVE, 1); $meta = MetaPeer::doSelect($m); unset($m); $response = $this->getResponse(); $response->setTitle($meta[0]->getTitle()); $response->addMeta('robots', $meta[0]->getKeywords()); $response->addMeta('keywords', $meta[0]->getDescription()); $c1 = new Criteria(); $c1->add(PhotosPeer::PART_ID, $part_id); $c1->add(PhotosPeer::IS_ACTIVE, 1); $pager = new sfPropelPager('Photos', 5); $pager->setCriteria($c1); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); $this->pager = $pager; $c2 = new Criteria(); $c2->add(PartsPeer::ID, $part_id); $this->part = PartsPeer::doSelect($c2); } unset($c1); }
/** * 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(MetaPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(MetaPeer::DATABASE_NAME); $criteria->add(MetaPeer::ID, $pks, Criteria::IN); $objs = MetaPeer::doSelect($criteria, $con); } return $objs; }