public function executeSubreviews()
{
if (!isset($this->showCount)) {
$this->showCount = SfReviewManager::NUM_REVIEWS;
}
/*
$this->reviewLastList = SfReviewManager::getLastReviewsByEntityAndValue(false, $this->type_id, $this->id, null, SfReviewManager::NUM_LAST_REVIEWS);
$exclude = array();
foreach ($this->reviewLastList->getResults() as $result){
$exclude[] = $result->getId();
}
*/
$this->reviewList = SfReviewManager::getReviewsByEntityAndValue(false, $this->type_id, $this->id, null, $this->showCount);
//$this->positiveCount = SfReviewManager::getTotalReviewsByEntityAndValue('', $this->id, 1);
//$this->negativeCount = SfReviewManager::getTotalReviewsByEntityAndValue('', $this->id, -1);
$this->total = $this->reviewList->getNbResults();
// + $this->reviewList->getNbResults();
$this->seeMoreCount = 0;
if ($this->total > $this->showCount) {
$this->seeMoreCount = $this->total - $this->showCount > 10 ? $this->showCount + 10 : $this->total;
}
$this->review_c = $this->getUser()->getAttribute('review_c');
}
public function executeShow(sfWebRequest $request)
{
$vanity = $request->getParameter('id');
$s = $request->getParameter('s', 0);
$culture = $this->getUser()->getCulture();
$c = new Criteria();
$c->add(PropuestaPeer::VANITY, $vanity);
$this->propuesta = PropuestaPeer::doSelectOne($c);
$this->forward404Unless($this->propuesta);
if ($this->propuesta->getCulture() != $culture) {
$this->redirect("@homepage");
}
if ($this->propuesta->getVanity() != $vanity) {
$this->redirect('propuesta/show?id=' . $this->propuesta->getVanity(), 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;
}
$exclude = array();
$this->positives = SfReviewManager::getReviewsByEntityAndValue($request, Propuesta::NUM_ENTITY, $this->propuesta->getId(), 1);
$this->negatives = SfReviewManager::getReviewsByEntityAndValue($request, Propuesta::NUM_ENTITY, $this->propuesta->getId(), -1);
$positiveCount = $this->positives->getNbResults();
$negativeCount = $this->negatives->getNbResults();
$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;
}
$this->title = sfContext::getInstance()->getI18N()->__('%1%, opiniones a favor y en contra en Voota', array('%1%' => $this->propuesta->getTitulo()));
$description = sfContext::getInstance()->getI18N()->__('Página de %1%', array('%1%' => $this->propuesta->getTitulo()));
$description .= sfContext::getInstance()->getI18N()->__('%1% votos a favor y %2% votos en contra.', array('%1%' => $positiveCount, '%2%' => $negativeCount));
$this->response->addMeta('Description', $description);
$this->response->setTitle($this->title);
// Enlaces
$this->activeEnlaces = $this->getEnlaces($this->propuesta);
$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;
}
}
/* paginador */
$this->propuestasPager = EntityManager::getPager($this->propuesta);
/* / paginador */
$c = new Criteria();
$c->add(PropuestaPeer::IS_ACTIVE, true);
$c->add(PropuestaPeer::CULTURE, $culture);
$this->propuestasCount = PropuestaPeer::doCount($c);
// Feed
$request->setAttribute('rssTitle', $this->title . " Feed RSS");
$request->setAttribute('rssFeed', 'propuesta/feed?id=' . $this->propuesta->getVanity());
}
public function executeShow(sfWebRequest $request)
{
$vanity = $request->getParameter('id');
$s = $request->getParameter('s', 0);
$f = $request->getParameter('f', 'none');
$F = $request->getParameter('F', 'none');
$culture = $this->getUser()->getCulture();
$c = new Criteria();
$c->add(PoliticoPeer::VANITY, $vanity, Criteria::EQUAL);
$politico = PoliticoPeer::doSelectOne($c);
$this->forward404Unless($politico);
if ($f != 'none' || $F != 'none') {
$this->redirect('politico/show?id=' . $politico->getVanity(), 301);
}
$this->partido = $request->getParameter("partido");
$this->institucion = $request->getParameter("institucion");
$this->rankingUrl = $this->generateRankingUrl($this->partido, $this->institucion);
$this->politico = $politico;
$id = $this->politico->getId();
$this->forward404Unless($this->politico);
if ($this->politico->getVanity() != $vanity) {
$this->redirect('politico/show?id=' . $this->politico->getVanity(), 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->politico->getImagen() != '') {
$imageFileName = $this->politico->getImagen();
} else {
$imageFileName = "p_unknown.png";
}
$this->image = "bw_{$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;
}
$exclude = array();
$this->positives = SfReviewManager::getReviewsByEntityAndValue($request, 1, $id, 1, $resU);
$this->negatives = SfReviewManager::getReviewsByEntityAndValue($request, 1, $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;
}
$this->title = sfContext::getInstance()->getI18N()->__('%1%, opiniones a favor y en contra en Voota', array('%1%' => $this->politico->getNombre() . ' ' . $this->politico->getApellidos()));
$description = sfContext::getInstance()->getI18N()->__('Página de %1%', array('%1%' => $this->politico->getNombre() . ' ' . $this->politico->getApellidos()));
if (count($this->politico->getPoliticoInstitucions()) > 0) {
$description .= " (";
//instituciones
foreach ($this->politico->getPoliticoInstitucions() as $idx => $politicoInstitucion) {
if ($idx > 0) {
$description .= ', ';
}
$description .= $politicoInstitucion->getInstitucion()->getNombre();
}
$description .= ")";
}
$description .= ", " . $this->politico->getPartido() . ", ";
//partido
$description .= sfContext::getInstance()->getI18N()->__('%1% votos a favor y %2% votos en contra.', array('%1%' => $positiveCount, '%2%' => $negativeCount));
$this->response->addMeta('Description', $description);
$this->response->setTitle($this->title);
// 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);
if ($politico->getsfGuardUser()) {
$c->add(EnlacePeer::SF_GUARD_USER_ID, $politico->getsfGuardUser()->getId());
} else {
$c->add(EnlacePeer::POLITICO_ID, $id);
}
$c->add(EnlacePeer::URL, '', Criteria::NOT_EQUAL);
$c->addAscendingOrderByColumn(EnlacePeer::ORDEN);
$this->activeEnlaces = EnlacePeer::doSelect($c);
if ($politico->getsfGuardUser() && count($this->activeEnlaces) == 0) {
$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::POLITICO_ID, $id);
$c->add(EnlacePeer::URL, '', Criteria::NOT_EQUAL);
$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;
}
}
/* paginador */
$this->politicosPager = EntityManager::getPager($this->politico);
/* / paginador */
// Feed
$request->setAttribute('rssTitle', $this->title . " Feed RSS");
$request->setAttribute('rssFeed', 'politico/feed?id=' . $this->politico->getVanity());
$this->listas = false;
$c = new Criteria();
$c->add(PoliticoListaPeer::POLITICO_ID, $this->politico->getId());
$c->addJoin(PoliticoListaPeer::LISTA_ID, ListaPeer::ID);
$c->addJoin(ConvocatoriaPeer::ID, ListaPeer::CONVOCATORIA_ID);
$c->add(ConvocatoriaPeer::FECHA, time(), Criteria::GREATER_THAN);
$this->listas = PoliticoListaPeer::doSelect($c);
}
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());
}
private function reviews($data)
{
$page = $this->getRequestParameter("page", '1');
$limit = $this->getRequestParameter("limit", self::PAGE_SIZE);
$type = $this->getRequestParameter("type");
$entity = $this->getRequestParameter("entity");
$value = $this->getRequestParameter("value", NULL);
$typeId = -1;
switch ($type) {
case 'politician':
$typeId = Politico::NUM_ENTITY;
break;
case 'party':
$typeId = Partido::NUM_ENTITY;
break;
case 'proposal':
$typeId = Propuesta::NUM_ENTITY;
break;
default:
throw new BadRequestException('Invalid type.');
}
$sfReviewsPager = SfReviewManager::getReviewsByEntityAndValue(false, $typeId, $entity, $value, $limit, false, $page);
$reviews = array();
foreach ($sfReviewsPager->getResults() as $sfReview) {
$reviews[] = new Review($sfReview);
}
return $reviews;
}
