public function executeActivities()
{
$this->page = $this->page ? $this->page : 1;
sfContext::getInstance()->getRequest()->setAttribute('page', $this->page);
$filter = array();
if (isset($this->sfReviewType)) {
$filter['type_id'] = $this->sfReviewType;
}
if (isset($this->entityId)) {
$filter['entity_id'] = $this->entityId;
}
if (isset($this->value)) {
$filter['value'] = $this->value;
}
if (isset($this->filter)) {
$filter['textFilter'] = $this->filter;
}
if (isset($this->userId)) {
$filter['userId'] = $this->userId;
}
if (isset($this->culture)) {
$filter['culture'] = $this->culture;
}
$sfr_status = sfContext::getInstance()->getRequest()->getAttribute('sfr_status', false);
$this->count = SfReviewManager::getActivitiesCount($filter);
$this->activities = SfReviewManager::getActivities($filter, $this->page, 20 * ($sfr_status && !$sfr_status['t'] ? $sfr_status['pag'] : 1));
}
public function executeIndex(sfWebRequest $request)
{
$culture = $this->getUser()->getCulture();
$cpos = new Criteria();
$cpos->add(SfReviewPeer::VALUE, 1);
$cpos->add(SfReviewPeer::IS_ACTIVE, 1);
//$cpos->add(SfReviewPeer::CULTURE, $culture);
$this->totalUpReviews = SfReviewPeer::doCount($cpos);
$cneg = new Criteria();
$cneg->add(SfReviewPeer::VALUE, -1);
$cneg->add(SfReviewPeer::IS_ACTIVE, 1);
//$cneg->add(SfReviewPeer::CULTURE, $culture);
$this->totalDownReviews = SfReviewPeer::doCount($cneg);
$exclude = "";
$this->reviewables = EntityManager::getTopEntities(6, $exclude, "WebEntity", true);
$c = new Criteria();
$c->addDescendingOrderByColumn(PoliticoPeer::SUMU);
$c->addAscendingOrderByColumn(PoliticoPeer::SUMD);
$c->setLimit(5);
$this->topPoliticos = PoliticoPeer::doSelect($c);
$c = new Criteria();
$c->addDescendingOrderByColumn(PartidoPeer::SUMU);
$c->addAscendingOrderByColumn(PartidoPeer::SUMD);
$c->setLimit(5);
$c->add(PartidoPeer::IS_ACTIVE, true);
$this->partidosMasVotados = PartidoPeer::doSelect($c);
$c = new Criteria();
$c->addDescendingOrderByColumn(PropuestaPeer::SUMU);
$c->addAscendingOrderByColumn(PropuestaPeer::SUMD);
$c->setLimit(5);
$c->add(PropuestaPeer::IS_ACTIVE, true);
$c->add(PropuestaPeer::CULTURE, $culture);
$this->propuestasMasVotadas = PropuestaPeer::doSelect($c);
//Totales
/*
$c = new Criteria();
$this->totalPoliticos = PoliticoPeer::doCount($c);
$c = new Criteria();
$c->add(PartidoPeer::IS_ACTIVE, true);
$this->totalPartidos = PartidoPeer::doCount($c);
$c = new Criteria();
$c->add(PropuestaPeer::IS_ACTIVE, true);
$c->add(PropuestaPeer::CULTURE, $culture);
$this->totalPropuestas = PropuestaPeer::doCount($c);
*/
$this->response->addMeta('Description', sfContext::getInstance()->getI18N()->__('Comparte opiniones sobre políticos y partidos de España. Ranking de los políticos y partidos más votados.'));
// Ultimos comentarios
$filter = array();
$filter['culture'] = $culture;
//$this->topReviews = SfReviewManager::getReviews($filter, 1, 5);
$this->activities = SfReviewManager::getActivities($filter, 1, 5);
// elecciones destacadas
$convocatoriaActiva = sfConfig::get('sf_convocatoria_activa');
$this->convocatoria = ConvocatoriaPeer::retrieveByPk($convocatoriaActiva);
}
