public function executeTags() { $c = new Criteria(); $sf_user = sfContext::getInstance()->getUser(); $c->addJoin(EtiquetaPoliticoPeer::ETIQUETA_ID, EtiquetaPeer::ID); if ($sf_user->isAuthenticated()) { $c->addJoin(EtiquetaSfGuardUserPeer::ETIQUETA_ID, EtiquetaPeer::ID, Criteria::LEFT_JOIN); } $c->add(EtiquetaPoliticoPeer::POLITICO_ID, $politicoId); $this->etiquetas = EtiquetaPeer::doSelect($c); }
public function executeTags(sfWebRequest $request) { $term = $request->getParameter('term'); $c = new Criteria(); $c->add(EtiquetaPeer::TEXTO, "%{$term}%", Criteria::LIKE); $etiquetas = EtiquetaPeer::doSelect($c); $res = '['; $idx = 0; foreach ($etiquetas as $etiqueta) { $idx++; $res .= ($idx > 1 ? ',' : '') . '{"id": "' . $etiqueta->getId() . '", "value": "' . $etiqueta . '"}'; } $res .= ']'; $response = $this->getResponse(); $response->setContentType('application/json'); echo $res; die; }
/** * Retrieve object using using composite pkey values. * @param int $id * @param string $culture * @param PropelPDO $con * @return Etiqueta */ public static function retrieveByPK($id, $culture, PropelPDO $con = null) { $key = serialize(array((string) $id, (string) $culture)); if (null !== ($obj = EtiquetaPeer::getInstanceFromPool($key))) { return $obj; } if ($con === null) { $con = Propel::getConnection(EtiquetaPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $criteria = new Criteria(EtiquetaPeer::DATABASE_NAME); $criteria->add(EtiquetaPeer::ID, $id); $criteria->add(EtiquetaPeer::CULTURE, $culture); $v = EtiquetaPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }