public function executeRanking(sfWebRequest $request)
{
$p = $request->getParameter("p");
$culture = $this->getUser()->getCulture("es");
$page = $request->getParameter("page", 1);
$this->order = $request->getParameter("o", "pd");
$filter = array('type' => 'propuesta', 'partido' => false, 'institucion' => false, 'culture' => $culture, 'page' => $page, 'order' => $this->order);
$this->getUser()->setAttribute("filter_" . Propuesta::NUM_ENTITY, $filter);
$this->propuestasPager = EntityManager::getPropuestas($culture, $page, $this->order, EntityManager::PAGE_SIZE, &$totalUp, &$totalDown);
$this->totalUp = $totalUp;
$this->totalDown = $totalDown;
$rule = sfContext::getInstance()->getRouting()->getCurrentRouteName();
$params = "";
foreach ($request->getParameterHolder()->getAll() as $name => $value) {
if ($name != 'module' && $name != 'action' && $name != 'o' && $name != 'page') {
if ($params === "") {
$params .= "?";
} else {
$params .= "&";
}
$params .= "{$name}={$value}";
}
}
$this->route = "propuesta/ranking{$params}";
$this->pageTitle = sfContext::getInstance()->getI18N()->__('Ranking de propuestas', array());
if ($this->order != 'pd') {
switch ($this->order) {
case 'pa':
$orderTxt = sfContext::getInstance()->getI18N()->__('votos positivos inverso');
break;
case 'nd':
$orderTxt = sfContext::getInstance()->getI18N()->__('votos negativos');
break;
case 'na':
$orderTxt = sfContext::getInstance()->getI18N()->__('votos negativos inverso');
break;
case 'fd':
$orderTxt = sfContext::getInstance()->getI18N()->__('más recientes');
break;
case 'fa':
$orderTxt = sfContext::getInstance()->getI18N()->__('más antiguas');
break;
}
$this->pageTitle .= ", {$orderTxt}";
}
if ($page && $page != 1) {
$this->pageTitle .= " " . sfContext::getInstance()->getI18N()->__('(Pág. %1%)', array('%1%' => $page));
}
$this->title = $this->pageTitle . ' - Voota';
$description = sfContext::getInstance()->getI18N()->__('Ranking de propuestas', array());
if ($this->order != 'pd') {
$description .= ", {$orderTxt}";
}
if ($page && $page != 1) {
$description .= " " . sfContext::getInstance()->getI18N()->__('(Pág. %1%)', array('%1%' => $page));
}
$this->response->addMeta('Description', $description);
$this->response->setTitle($this->title);
}
protected function execute($arguments = array(), $options = array())
{
$sfContext = sfContext::createInstance($this->configuration);
$controller = $sfContext->getController();
$this->cultures = array('ca' => 'cat', 'es' => 'es');
$culture = $options['culture'];
// initialize the database connection
$databaseManager = new sfDatabaseManager($this->configuration);
$connection = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection();
//foreach($this->cultures as $culture => $ext){
$sfContext->getUser()->setCulture($culture);
// **************** HOME **********************
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@homepage", true), $culture);
// **************** Ultimas opiniones **********************
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@ultimas_opiniones_{$culture}", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@ultimas_opiniones_politicos_{$culture}", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@ultimas_opiniones_partidos_{$culture}", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@ultimas_opiniones_propuestas_{$culture}", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@ultimas_opiniones_otras_{$culture}", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@ultimas_opiniones_feed_{$culture}", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@ultimas_opiniones_politicos_feed_{$culture}", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@ultimas_opiniones_partidos_feed_{$culture}", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@ultimas_opiniones_propuestas_feed_{$culture}", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@ultimas_opiniones_otras_feed_{$culture}", true), $culture);
// **************** varias **********************
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@about", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@rules", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@search", true), $culture);
$this->writeToSitemap("voota-{$culture}", $controller->genUrl("@contact", true), $culture);
// **************** Fichas POLITICOS **********************
$c = new Criteria();
//$c->setLimit(5);
$politicos = PoliticoPeer::doSelect($c);
foreach ($politicos as $politico) {
$this->writeToSitemap("politico-{$culture}", $controller->genUrl("politico/show?id=" . $politico->getVanity(), true), $culture);
}
// **************** Fichas PARTIDOS **********************
$c = new Criteria();
$c->add(PartidoPeer::IS_ACTIVE, true);
$partidos = PartidoPeer::doSelect($c);
foreach ($partidos as $partido) {
$this->writeToSitemap("partido-{$culture}", $controller->genUrl("partido/show?id=" . $partido->getAbreviatura(), true), $culture);
}
// **************** Fichas PROPUESTAS **********************
$c = new Criteria();
$c->add(PropuestaPeer::IS_ACTIVE, true);
$c->add(PropuestaPeer::CULTURE, $culture);
$propuestas = PropuestaPeer::doSelect($c);
foreach ($propuestas as $propuesta) {
$this->writeToSitemap("propuesta-{$culture}", $controller->genUrl("propuesta/show?id=" . $propuesta->getVanity(), true), $culture);
}
// **************** Fichas USUARIOS **********************
$c = new Criteria();
$c->add(SfGuardUserPeer::IS_ACTIVE, true);
$usuarios = SfGuardUserPeer::doSelect($c);
foreach ($usuarios as $usuario) {
$this->writeToSitemap("usuario-{$culture}", $controller->genUrl("perfil/show?username="******"politico-feed-{$culture}", $controller->genUrl("politico/show?id=" . $politico->getVanity(), true), $culture);
}
// **************** feeds PARTIDOS **********************
$c = new Criteria();
$c->add(PartidoPeer::IS_ACTIVE, true);
$partidos = PartidoPeer::doSelect($c);
foreach ($partidos as $partido) {
$this->writeToSitemap("partido-feed-{$culture}", $controller->genUrl("partido/feed?id=" . $partido->getAbreviatura(), true), $culture);
}
// **************** feeds PROPUESTAS **********************
$c = new Criteria();
$c->add(PropuestaPeer::IS_ACTIVE, true);
$c->add(PropuestaPeer::CULTURE, $culture);
$propuestas = PropuestaPeer::doSelect($c);
foreach ($propuestas as $propuesta) {
$this->writeToSitemap("propuesta-feed-{$culture}", $controller->genUrl("propuesta/feed?id=" . $propuesta->getVanity(), true), $culture);
}
// **************** feeds USUARIOS **********************
$c = new Criteria();
$c->add(SfGuardUserPeer::IS_ACTIVE, true);
$usuarios = SfGuardUserPeer::doSelect($c);
foreach ($usuarios as $usuario) {
$this->writeToSitemap("usuario-feed-{$culture}", $controller->genUrl("perfil/feed?username="******"propuesta-ranking-{$culture}", $controller->genUrl("propuesta/ranking", true), $culture);
$pager = EntityManager::getPropuestas($culture);
$idx = 1;
while ($idx < $pager->getLastPage()) {
$idx++;
$this->writeToSitemap("propuesta-ranking-{$culture}", $controller->genUrl("propuesta/ranking?page={$idx}", true), $culture);
}
// **************** ranking POLITICOS **********************
$this->writeToSitemap("politico-ranking-{$culture}", $controller->genUrl("politico/ranking", true), $culture);
$pager = EntityManager::getPoliticos(false, false, $culture);
$idx = 1;
while ($idx < $pager->getLastPage()) {
$idx++;
$this->writeToSitemap("politico-ranking-{$culture}", $controller->genUrl("politico/ranking?page={$idx}", true), $culture);
}
# ranking de polis filtrados por partido
$c = new Criteria();
$c->add(PartidoPeer::IS_ACTIVE, true);
$partidos = PartidoPeer::doSelect($c);
foreach ($partidos as $partido) {
$this->writeToSitemap("politico-ranking-{$culture}", $controller->genUrl("politico/ranking?partido=" . $partido->getAbreviatura(), true), $culture);
$pager = EntityManager::getPoliticos($partido->getAbreviatura(), false, $culture);
$idx = 1;
while ($idx < $pager->getLastPage()) {
$idx++;
$this->writeToSitemap("politico-ranking-{$culture}", $controller->genUrl("politico/ranking?partido=" . $partido->getAbreviatura() . "&page={$idx}", true), $culture);
}
# ranking de polis filtrados por partido e insti
$c = new Criteria();
$c->add(InstitucionPeer::IS_ACTIVE, true);
$c->addJoin(PoliticoInstitucionPeer::INSTITUCION_ID, InstitucionPeer::ID);
$c->addJoin(PoliticoPeer::ID, PoliticoInstitucionPeer::POLITICO_ID);
$c->add(PoliticoPeer::PARTIDO_ID, $partido->getId());
$instis = InstitucionPeer::doSelect($c);
foreach ($instis as $insti) {
$this->writeToSitemap("politico-ranking-{$culture}", $controller->genUrl("politico/ranking?partido=" . $partido->getAbreviatura() . "&institucion=" . $insti->getVanity(), true), $culture);
$pager = EntityManager::getPoliticos($partido->getAbreviatura(), $insti->getVanity(), $culture);
$idx = 1;
while ($idx < $pager->getLastPage()) {
$idx++;
$this->writeToSitemap("politico-ranking-{$culture}", $controller->genUrl("politico/ranking?partido=" . $partido->getAbreviatura() . "&institucion=" . $insti->getVanity() . "&page={$idx}", true), $culture);
}
}
}
# ranking de polis filtrados por insti
$c = new Criteria();
$c->add(InstitucionPeer::IS_ACTIVE, true);
$instis = InstitucionPeer::doSelect($c);
foreach ($instis as $insti) {
$this->writeToSitemap("politico-ranking-{$culture}", $controller->genUrl("politico/ranking?partido=all&institucion=" . $insti->getVanity(), true), $culture);
$pager = EntityManager::getPoliticos(false, $insti->getVanity(), $culture);
$idx = 1;
while ($idx < $pager->getLastPage()) {
$idx++;
$this->writeToSitemap("politico-ranking-{$culture}", $controller->genUrl("politico/ranking?partido=all&institucion=" . $insti->getVanity() . "&page={$idx}", true), $culture);
}
}
// **************** ranking PARTIDOS **********************
$this->writeToSitemap("partido-ranking-{$culture}", $controller->genUrl("partido/ranking", true), $culture);
$pager = EntityManager::getPartidos(false, $culture);
$idx = 1;
while ($idx < $pager->getLastPage()) {
$idx++;
$this->writeToSitemap("partido-ranking-{$culture}", $controller->genUrl("partido/ranking?page={$idx}", true), $culture);
}
$c = new Criteria();
$c->add(InstitucionPeer::IS_ACTIVE, true);
$instis = InstitucionPeer::doSelect($c);
foreach ($instis as $insti) {
$this->writeToSitemap("partido-ranking-{$culture}", $controller->genUrl("partido/ranking?institucion=" . $insti->getVanity(), true), $culture);
$pager = EntityManager::getPartidos($insti->getVanity(), $culture);
$idx = 1;
while ($idx < $pager->getLastPage()) {
$idx++;
$this->writeToSitemap("partido-ranking-{$culture}", $controller->genUrl("partido/ranking?institucion=" . $insti->getVanity() . "&page={$idx}", true), $culture);
}
}
// **************** elecciones **********************
$c = new Criteria();
$convocatorias = ConvocatoriaPeer::doSelect($c);
foreach ($convocatorias as $convocatoria) {
$this->writeToSitemap("elecciones-{$culture}", $controller->genUrl('eleccion/show?vanity=' . $convocatoria->getEleccion()->getVanity() . '&convocatoria=' . $convocatoria->getNombre(), true), $culture);
$used = array();
foreach ($convocatoria->getListasJoinCircunscripcion() as $geoLista) {
if (!in_array($geoLista->getCircunscripcion()->getGeo(), $used)) {
$used[] = $geoLista->getCircunscripcion()->getGeo();
$this->writeToSitemap("elecciones-{$culture}", $controller->genUrl('eleccion/show?geo=' . $geoLista->getCircunscripcion()->getGeo()->getNombre() . '&vanity=' . $convocatoria->getEleccion()->getVanity() . '&convocatoria=' . $convocatoria->getNombre(), true), $culture);
}
$this->writeToSitemap("elecciones-{$culture}", $controller->genUrl('lista/show?partido=' . $geoLista->getPartido()->getAbreviatura() . '&geo=' . $geoLista->getCircunscripcion()->getGeo()->getNombre() . '&vanity=' . $convocatoria->getEleccion()->getVanity() . '&convocatoria=' . $convocatoria->getNombre(), true), $culture);
}
}
//}
$this->closeAll($culture);
}
private function entities_proposal($data)
{
$sort = $this->getRequestParameter("sort", 'positive');
$page = $this->getRequestParameter("page", '1');
$limit = $this->getRequestParameter("limit", self::PAGE_SIZE);
if ($sort != 'positive' && $sort != 'negative') {
throw new BadRequestException('Invalid sort value.');
}
$pager = EntityManager::getPropuestas($this->getUser()->getCulture("es"), $page, $sort == 'positive' ? "pd" : "nd", $limit);
$entities = array();
foreach ($pager->getResults() as $proposal) {
$entities[] = new Entity($proposal);
}
return $entities;
}
