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