public static function getFiltersByName($name) { $data = array(); $user = sfContext::getInstance()->getUser()->getAppFlowerUser()->getId(); $title = $name; $c = new Criteria(); $c->add(afSaveFilterPeer::USER, $user); $c->add(afSaveFilterPeer::TITLE, $title); $c->addDescendingOrderByColumn(afSaveFilterPeer::ID); $objs = afSaveFilterPeer::doSelect($c); return $objs; }
/** * 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(afSaveFilterPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(afSaveFilterPeer::DATABASE_NAME); $criteria->add(afSaveFilterPeer::ID, $pks, Criteria::IN); $objs = afSaveFilterPeer::doSelect($criteria, $con); } return $objs; }
public function executeListFilter() { $success = false; $data = array(); if ($this->getRequest()->getMethod() == sfRequest::POST) { $user = $this->getUser()->getAppFlowerUser()->getId(); $title = $this->getRequestParameter("path"); $c = new Criteria(); $c->add(afSaveFilterPeer::USER, $user); $c->add(afSaveFilterPeer::TITLE, $title); $c->addAscendingOrderByColumn(afSaveFilterPeer::NAME); $objs = afSaveFilterPeer::doSelect($c); foreach ($objs as $obj) { $data[] = array("id" => $obj->getId(), "name" => "<a href='#' style='color:#0000ff' qtip='Apply this filter to grid' class='ux-grid-filter-apply'>" . $obj->getName() . "</a>", "filter" => $obj->getFilter()); } $success = true; } $result = array("success" => $success, "rows" => $data); return $this->renderText(json_encode($result)); }