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);
}
/**
* Get the associated Convocatoria object
*
* @param PropelPDO Optional Connection object.
* @return Convocatoria The associated Convocatoria object.
* @throws PropelException
*/
public function getConvocatoria(PropelPDO $con = null)
{
if ($this->aConvocatoria === null && $this->id !== null) {
$this->aConvocatoria = ConvocatoriaPeer::retrieveByPk($this->id);
/* The following can be used additionally to
guarantee the related object contains a reference
to this object. This level of coupling may, however, be
undesirable since it could result in an only partially populated collection
in the referenced object.
$this->aConvocatoria->addConvocatoriaI18ns($this);
*/
}
return $this->aConvocatoria;
}
public function executeShow(sfWebRequest $request)
{
$abreviatura = $request->getParameter('id');
$culture = $this->getUser()->getCulture("es");
$this->institucion = $request->getParameter("institucion");
if ($this->institucion == '') {
$this->institucion = "0";
}
$c = new Criteria();
$c->add(PartidoPeer::ABREVIATURA, $abreviatura, Criteria::EQUAL);
$this->partido = PartidoPeer::doSelectOne($c);
$this->forward404Unless($this->partido);
$this->forward404Unless($this->partido->getIsActive());
if ($this->partido->getAbreviatura() != $abreviatura) {
$this->redirect('partido/show?id=' . $this->partido->getAbreviatura(), 301);
}
// Estabamos vootando antes del login ?
$sfr_status = $this->getUser()->getAttribute('sfr_status', false, 'sf_review');
if ($sfr_status) {
$aSfrStatus = array();
foreach ($sfr_status as $key => $value) {
$aSfrStatus[$key] = $value;
}
$this->sfr_status = $aSfrStatus;
$request->setAttribute('sfr_status', $aSfrStatus);
$this->getUser()->setAttribute('sfr_status', false, 'sf_review');
} else {
$this->getUser()->setAttribute('sfr_status', false, 'sf_review');
$this->sfr_status = false;
}
if ($this->partido->getImagen() != '') {
$imageFileName = $this->partido->getImagen();
} else {
$imageFileName = "p_unknown.png";
}
$this->image = "cc_{$imageFileName}";
$pu = $this->getUser()->getAttribute('pageU');
$pd = $this->getUser()->getAttribute('pageD');
$c = $this->getUser()->getAttribute('review_c');
if ($c != '' && $pu != '') {
$resU = BaseSfReviewManager::NUM_REVIEWS * ($pu - 1);
$this->pageU = $pu;
} else {
$resU = BaseSfReviewManager::NUM_REVIEWS;
$this->pageU = 2;
}
if ($c != '' && $pd != '') {
$resD = BaseSfReviewManager::NUM_REVIEWS * ($pd - 1);
$this->pageD = $pd;
} else {
$resD = BaseSfReviewManager::NUM_REVIEWS;
$this->pageD = 2;
}
$id = $this->partido->getId();
$this->positives = SfReviewManager::getReviewsByEntityAndValue($request, Partido::NUM_ENTITY, $id, 1, $resU);
$this->negatives = SfReviewManager::getReviewsByEntityAndValue($request, Partido::NUM_ENTITY, $id, -1, $resD);
$positiveCount = $this->positives->getNbResults();
$negativeCount = $this->negatives->getNbResults();
$this->getUser()->setAttribute('pageU', '');
$this->getUser()->setAttribute('pageD', '');
$this->totalCount = $positiveCount + $negativeCount;
if ($this->totalCount > 0) {
$this->positivePerc = intval($positiveCount * 100 / $this->totalCount);
$this->negativePerc = 100 - $this->positivePerc;
} else {
$this->positivePerc = 0;
$this->negativePerc = 0;
}
// Enlaces
$c = new Criteria();
$rCriterion = $c->getNewCriterion(EnlacePeer::CULTURE, null, Criteria::ISNULL);
$rCriterion->addOr($c->getNewCriterion(EnlacePeer::CULTURE, $this->getUser()->getCulture()));
$rCriterion->addOr($c->getNewCriterion(EnlacePeer::CULTURE, ''));
$c->add($rCriterion);
$c->add(EnlacePeer::PARTIDO_ID, $id);
$c->addAscendingOrderByColumn(EnlacePeer::ORDEN);
$this->activeEnlaces = EnlacePeer::doSelect($c);
$this->twitterUser = FALSE;
foreach ($this->activeEnlaces as $enlace) {
if (preg_match("/twitter\\.com\\/#!\\/(.*)\$/is", $enlace->getUrl(), $matches)) {
$this->twitterUser = $matches[1];
break;
}
if (preg_match("/twitter\\.com\\/(.*)\$/is", $enlace->getUrl(), $matches)) {
$this->twitterUser = $matches[1];
break;
}
}
// Politicos mas votados
$c = new Criteria();
$c->addJoin(array(PoliticoPeer::ID, PoliticoI18nPeer::CULTURE), array(PoliticoI18nPeer::ID, "'{$culture}'"), Criteria::LEFT_JOIN);
$c->add(PoliticoPeer::VANITY, null, Criteria::ISNOTNULL);
$c->add(PoliticoPeer::PARTIDO_ID, $this->partido->getId());
$c->addDescendingOrderByColumn(PoliticoPeer::SUMU);
$c->addAscendingOrderByColumn(PoliticoPeer::SUMD);
$this->politicos = new sfPropelPager('Politico', 6);
$this->politicos->setCriteria($c);
$this->politicos->init();
// Lista de instituciones
$c = new Criteria();
$c->addJoin(InstitucionPeer::ID, PoliticoInstitucionPeer::INSTITUCION_ID);
$c->addJoin(PoliticoInstitucionPeer::POLITICO_ID, PoliticoPeer::ID);
$c->addJoin(PoliticoPeer::PARTIDO_ID, PartidoPeer::ID);
$c->add(PoliticoPeer::PARTIDO_ID, $this->partido->getId());
$c->add(InstitucionPeer::IS_MAIN, true);
$c->setDistinct();
$c->addAscendingOrderByColumn(InstitucionPeer::ORDEN);
$this->instituciones = InstitucionPeer::doSelect($c);
// Lista de listas
$this->listasGenerales = false;
$this->listasAutonomicas = false;
$this->listasMunicipales = false;
foreach ($this->partido->getListas() as $lista) {
//$lista->getCircunscripcion()->getGeo()
foreach ($lista->getConvocatoria()->getEleccion()->getEleccionInstitucions() as $insti) {
$geo = $insti->getInstitucion()->getGeo();
if ($geo->getId() == 1) {
$this->listasGenerales = true;
} elseif ($geo->getGeoRelatedByGeoId()->getId() == 1) {
$this->listasAutonomicas = true;
} elseif ($geo->getGeoRelatedByGeoId()->getGeoRelatedByGeoId()->getId() == 1) {
} elseif ($geo->getGeoRelatedByGeoId()->getGeoRelatedByGeoId()->getGeoRelatedByGeoId()->getId() == 1) {
$this->listasMunicipales = true;
}
}
}
$this->pageTitle = $this->partido->getNombre() . " (" . $this->partido->getAbreviatura() . ")";
$this->title = $this->pageTitle . ' - Voota';
$this->response->addMeta('Title', $this->title);
$descripcion = $this->partido->getAbreviatura() . ": " . sfContext::getInstance()->getI18N()->__('presentación, opiniones de usuarios a favor y en contra, políticos mejor valorados y enlaces. ', array()) . SfVoUtil::cutToLength($this->partido->getPresentacion(), 140, '...', true);
$this->response->addMeta('Descripcion', $descripcion);
// Listas de electorales
$convocatoriaActiva = sfConfig::get('sf_convocatoria_activa');
$this->convocatoria = ConvocatoriaPeer::retrieveByPk($convocatoriaActiva);
$c = new Criteria();
$c->add(ListaPeer::PARTIDO_ID, $this->partido->getId());
$c->add(ListaPeer::CONVOCATORIA_ID, $convocatoriaActiva);
$c->addJoin(ListaPeer::CIRCUNSCRIPCION_ID, CircunscripcionPeer::ID);
$c->addJoin(CircunscripcionPeer::GEO_ID, GeoPeer::ID);
$c->addAscendingOrderByColumn(GeoPeer::NOMBRE);
$this->listas = ListaPeer::doSelect($c);
/* paginador */
$this->partidosPager = EntityManager::getPager($this->partido);
/* / paginador */
// Feed
$request->setAttribute('rssTitle', $this->title . " Feed RSS");
$request->setAttribute('rssFeed', 'partido/feed?id=' . $this->partido->getVanity());
}
