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);
}
private function propuesta($arguments = array(), $options = array())
{
// initialize the database connection
$databaseManager = new sfDatabaseManager($this->configuration);
$connection = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection();
$s3 = new S3Voota();
$c = new Criteria();
$c->add(PropuestaPeer::ID, $options['minid'], Criteria::GREATER_EQUAL);
$propuestas = PropuestaPeer::doSelect($c);
foreach ($propuestas as $propuesta) {
if ($propuesta->getImagen() != '') {
echo "Creating " . $propuesta->getImagen() . " ...\n";
$s3->createFromOri("propuestas", $propuesta->getImagen());
}
}
}
/**
* Gets an array of Propuesta objects which contain a foreign key that references this object.
*
* If this collection has already been initialized with an identical Criteria, it returns the collection.
* Otherwise if this sfGuardUser has previously been saved, it will retrieve
* related Propuestas from storage. If this sfGuardUser is new, it will return
* an empty collection or the current collection, the criteria is ignored on a new object.
*
* @param PropelPDO $con
* @param Criteria $criteria
* @return array Propuesta[]
* @throws PropelException
*/
public function getPropuestas($criteria = null, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(sfGuardUserPeer::DATABASE_NAME);
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collPropuestas === null) {
if ($this->isNew()) {
$this->collPropuestas = array();
} else {
$criteria->add(PropuestaPeer::SF_GUARD_USER_ID, $this->id);
PropuestaPeer::addSelectColumns($criteria);
$this->collPropuestas = PropuestaPeer::doSelect($criteria, $con);
}
} else {
// criteria has no effect for a new object
if (!$this->isNew()) {
// the following code is to determine if a new query is
// called for. If the criteria is the same as the last
// one, just return the collection.
$criteria->add(PropuestaPeer::SF_GUARD_USER_ID, $this->id);
PropuestaPeer::addSelectColumns($criteria);
if (!isset($this->lastPropuestaCriteria) || !$this->lastPropuestaCriteria->equals($criteria)) {
$this->collPropuestas = PropuestaPeer::doSelect($criteria, $con);
}
}
}
$this->lastPropuestaCriteria = $criteria;
return $this->collPropuestas;
}
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);
}
/**
* Retrieve multiple objects by pkey.
*
* @param array $pks List of primary keys
* @param PropelPDO $con the connection to use
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function retrieveByPKs($pks, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(PropuestaPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria(PropuestaPeer::DATABASE_NAME);
$criteria->add(PropuestaPeer::ID, $pks, Criteria::IN);
$objs = PropuestaPeer::doSelect($criteria, $con);
}
return $objs;
}
public function executeShow(sfWebRequest $request)
{
$vanity = $request->getParameter('username');
$this->f = $request->getParameter('f');
$culture = $this->getUser()->getCulture();
$this->sfReviewType = $request->getParameter("type_id", false);
$this->text = $request->getParameter("t", false);
$c = new Criteria();
$c->add(SfGuardUserProfilePeer::VANITY, $vanity, Criteria::EQUAL);
$userProfile = SfGuardUserProfilePeer::doSelectOne($c);
$this->forward404Unless($userProfile);
$this->user = $userProfile->getsfGuardUser();
if (!$this->user->getIsActive() && is_numeric($userProfile->getFacebookUid())) {
$user = SfGuardUserPeer::retrieveByPK($userProfile->getFacebookUid());
$this->forward404Unless($user);
$this->redirect('perfil/show?username='******'perfil/show?username='******'', Criteria::NOT_EQUAL);
$this->enlaces = EnlacePeer::doSelect($c);
$c = new Criteria();
$c->add(PropuestaPeer::SF_GUARD_USER_ID, $userProfile->getUserId());
$c->addDescendingOrderByColumn('created_at');
$this->propuestas = PropuestaPeer::doSelect($c);
//$this->reviews = SfReviewManager::getReviewsByUser($this->user->getId(), $this->f);
$filterText = '';
switch ($this->sfReviewType) {
case '1':
$filterText = sfContext::getInstance()->getI18N()->__('políticos');
break;
case '2':
$filterText = sfContext::getInstance()->getI18N()->__('partidos');
break;
case '3':
$filterText = sfContext::getInstance()->getI18N()->__('propuestas políticas');
break;
case 'null':
$filterText = sfContext::getInstance()->getI18N()->__('otros comentarios');
break;
}
//if (!$filterText){
$this->title = sfContext::getInstance()->getI18N()->__('Página de usuario de %1% en Voota', array('%1%' => trim($this->user) ? $this->user : $this->user->getProfile()->getVanity()));
/*}
else {
$this->title = sfContext::getInstance()->getI18N()->__('Opiniones de %1% sobre %2% en Voota', array(
'%1%' => trim($this->user)?$this->user:$this->user->getProfile()->getVanity()
, '%2%' => $filterText
));
}*/
$this->response->setTitle($this->title);
$filter = array();
if (isset($this->sfReviewType)) {
$filter['type_id'] = $this->sfReviewType;
$filter['textFilter'] = $this->text ? 'text' : false;
$filter['userId'] = $userProfile->getUserId();
$filter['culture'] = $culture;
}
$this->reviewsPager = SfReviewManager::getReviews($filter, 1, 3);
//if (!$filterText){
$descripcion = SfVoUtil::cutToLength($userProfile->getPresentacion(), 155, '...', true);
/*}
else {
if ($this->reviewsPager->getNbResults() == 0){
$descripcion = sfContext::getInstance()->getI18N()->__('%1% aún no se ha animado a comentar', trim($this->user)?$this->user:$this->user->getProfile()->getVanity());
}
else {
$descripcion = sfContext::getInstance()->getI18N()->__('%1% ha comentado sobre', array('%1%' => trim($this->user)?$this->user:$this->user->getProfile()->getVanity())). ': ';
foreach ($this->reviewsPager->getResults() as $idx => $review){
$type = $review->getSfReviewTypeId();
if (! $type){
$parentReview = $review->getSfReviewRelatedBySfReviewId();
$aEntityId = $parentReview->getEntityId();
$aTypeId = $parentReview->getSfReviewTypeId();
}
else {
$aTypeId = $type;
$aEntityId = $review->getEntityId();
}
$reviewType = SfReviewTypePeer::retrieveByPK ( $aTypeId );
$peer = $reviewType->getModel() .'Peer';
//$entity = $peer::retrieveByPK($aEntityId);
$entity = call_user_func("$peer::retrieveByPK", $aEntityId);
$descripcion .= ($idx != 0?', ':'').(!$type?sfContext::getInstance()->getI18N()->__('otro comentario sobre'). ' ':'').($aTypeId==Propuesta::NUM_ENTITY?"\"$entity\"":$entity);
}
}
}*/
$this->response->addMeta('Description', $descripcion ? $descripcion : sfContext::getInstance()->getI18N()->__('Votos y opiniones de %1% sobre políticos y partidos de España', array('%1%' => trim($this->user) ? $this->user : $this->user->getProfile()->getVanity())));
// Feed
$request->setAttribute('rssTitle', $this->title . " Feed RSS");
$request->setAttribute('rssFeed', 'perfil/feed?username=' . $this->user->getProfile()->getVanity());
}
/**
* Gets an array of Propuesta objects which contain a foreign key that references this object.
*
* If this collection has already been initialized with an identical Criteria, it returns the collection.
* Otherwise if this Partido has previously been saved, it will retrieve
* related PropuestasRelatedByPartidoVideo2Id from storage. If this Partido is new, it will return
* an empty collection or the current collection, the criteria is ignored on a new object.
*
* @param PropelPDO $con
* @param Criteria $criteria
* @return array Propuesta[]
* @throws PropelException
*/
public function getPropuestasRelatedByPartidoVideo2Id($criteria = null, PropelPDO $con = null)
{
if ($criteria === null) {
$criteria = new Criteria(PartidoPeer::DATABASE_NAME);
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collPropuestasRelatedByPartidoVideo2Id === null) {
if ($this->isNew()) {
$this->collPropuestasRelatedByPartidoVideo2Id = array();
} else {
$criteria->add(PropuestaPeer::PARTIDO_VIDEO2_ID, $this->id);
PropuestaPeer::addSelectColumns($criteria);
$this->collPropuestasRelatedByPartidoVideo2Id = PropuestaPeer::doSelect($criteria, $con);
}
} else {
// criteria has no effect for a new object
if (!$this->isNew()) {
// the following code is to determine if a new query is
// called for. If the criteria is the same as the last
// one, just return the collection.
$criteria->add(PropuestaPeer::PARTIDO_VIDEO2_ID, $this->id);
PropuestaPeer::addSelectColumns($criteria);
if (!isset($this->lastPropuestaRelatedByPartidoVideo2IdCriteria) || !$this->lastPropuestaRelatedByPartidoVideo2IdCriteria->equals($criteria)) {
$this->collPropuestasRelatedByPartidoVideo2Id = PropuestaPeer::doSelect($criteria, $con);
}
}
}
$this->lastPropuestaRelatedByPartidoVideo2IdCriteria = $criteria;
return $this->collPropuestasRelatedByPartidoVideo2Id;
}
