public function getResults($geoName = false, $sorted = true)
{
$aKey = "Convocatoria_" . $this->getId() . "-{$geoName}-{$sorted}";
$cache = sfcontext::getInstance()->getViewCacheManager() ? sfcontext::getInstance()->getViewCacheManager()->getCache() : false;
if ($cache) {
$key = md5($aKey);
$data = unserialize($cache->get($key));
} else {
$data = false;
}
if (!$data) {
$res = array();
$c = new Criteria();
$c->addJoin(ListaPeer::PARTIDO_ID, PartidoPeer::ID);
$c->add(ListaPeer::CONVOCATORIA_ID, $this->getId());
$c->setDistinct();
$res['partidos'] = PartidoPeer::doSelect($c);
// Circus
$c = new Criteria();
$c->addJoin(ListaPeer::CIRCUNSCRIPCION_ID, CircunscripcionPeer::ID);
$c->addJoin(CircunscripcionPeer::GEO_ID, GeoPeer::ID);
$c->add(ListaPeer::CONVOCATORIA_ID, $this->getId());
$c->addAscendingOrderByColumn(GeoPeer::NOMBRE);
$c->setDistinct();
//$this->geos = GeoPeer::doSelect( $c );
$res['circus'] = CircunscripcionPeer::doSelect($c);
$instituciones = $this->getEleccion()->getEleccionInstitucions();
//$this->institucionName = $instituciones[0]->getInstitucion();
$res['institucionName'] = $instituciones[0]->getInstitucion();
// Minimo de votos necesario para obtener escaño
$listas = $this->getListas();
if ($geoName) {
$c = new Criteria();
$c->addJoin(ListaPeer::CIRCUNSCRIPCION_ID, CircunscripcionPeer::ID);
$c->addJoin(CircunscripcionPeer::GEO_ID, GeoPeer::ID);
$c->add(ListaPeer::CONVOCATORIA_ID, $this->getId());
$c->add(GeoPeer::NOMBRE, $geoName);
//$this->geos = GeoPeer::doSelect( $c );
$circu = CircunscripcionPeer::doSelectOne($c);
$numEscanyos = $circu->getEscanyos();
} else {
$numEscanyos = 0;
$circuCounted = array();
foreach ($listas as $lista) {
if (!in_array($lista->getCircunscripcion()->getId(), $circuCounted)) {
$circuCounted[] = $lista->getCircunscripcion()->getId();
$numEscanyos += $lista->getCircunscripcion()->getEscanyos();
}
}
}
$listaElectoral = ListaElectoral::getInstance($this->getId(), false, $geoName);
$politicos = $listaElectoral->getPoliticos();
$idx = 0;
//$this->minSumu = 0;
$res['minSumu'] = 0;
//$this->minSumd = 0;
$res['minSumd'] = 0;
$res['lastDate'] = null;
$res['apellidos'] = '';
$res['nombre'] = '';
foreach ($politicos as $politico) {
$idx++;
if ($idx == $numEscanyos + 1) {
$res['minSumu'] = $politico->getSumu();
$res['minSumd'] = $politico->getSumd();
$res['lastDate'] = $politico->getLastDate();
$res['apellidos'] = $politico->getApellidos();
$res['nombre'] = $politico->getNombre();
}
}
// Ordenar por escaños
if ($sorted) {
$idx = 0;
$res['totalEscanyos'] = 0;
foreach ($res['partidos'] as $partido) {
$listaElectoral = new ListaElectoral($this->getId(), $partido->getId(), $geoName);
$escanyos = $listaElectoral->getEscanyos($res['minSumu'], $res['minSumd'], $res['lastDate'], $res['apellidos']);
$res['totalEscanyos'] += $escanyos;
for ($j = 0; $j < $idx; $j++) {
$listaElectoral2 = ListaElectoral::getInstance($this->getId(), $res['partidos'][$j]->getId(), $geoName);
if ($listaElectoral2->getEscanyos($res['minSumu'], $res['minSumd'], $res['lastDate'], $res['apellidos']) < $escanyos) {
$partidoTmp = clone $res['partidos'][$idx];
$res['partidos'][$idx] = $res['partidos'][$j];
$res['partidos'][$j] = $partidoTmp;
}
}
$idx++;
}
}
$data = $res;
if ($cache) {
$n = rand(0, 100);
$cache->set($key, serialize($data ? $data : "zero"), 3600 * $n / 100);
}
}
return $data == "zero" ? 0 : $data;
}
public function executePartidoLista()
{
$listaElectoral = new ListaElectoral($this->convocatoria->getId(), $this->partido->getId(), $this->geoName);
$this->politicos = $listaElectoral->getPoliticos();
$this->numEscanyos = $listaElectoral->getEscanyos($this->minSumu, $this->minSumd, $this->lastDate, $this->apellidos);
}
public function getEscanyos($minSumu, $minSumd, $lastDate, $apellidos)
{
$cache = sfcontext::getInstance()->getViewCacheManager() ? sfcontext::getInstance()->getViewCacheManager()->getCache() : false;
if ($cache) {
$aKey = "Escanyos_" . $this->convocatoriaId . "-" . $this->partidoId . "-" . $this->geoName . "-{$minSumu}-{$minSumd}-{$lastDate}-{$apellidos}";
$key = md5($aKey);
$data = unserialize($cache->get($key));
} else {
$data = false;
}
if (!$data) {
//echo "($aKey-$key)";
if ($this->geoName) {
if (!$this->numEscanyos) {
$this->numEscanyos = 0;
foreach ($this->politicos as $politico) {
if ($politico->getSumu() > $minSumu || $politico->getSumu() == $minSumu && $politico->getSumd() < $minSumd || $politico->getSumu() == $minSumu && $politico->getSumd() == $minSumd && $politico->getLastDate() > $lastDate && $minSumu != 0 || $politico->getSumu() == $minSumu && $politico->getSumd() == $minSumd && $politico->getLastDate() == $lastDate && $politico->getApellidos() > $apellidos && $minSumu != 0) {
//echo "(".$politico->getApellidos().",".$politico->getSumu().",".$politico->getSumd().",".$politico->getLastDate().")";
$this->numEscanyos++;
}
}
}
} else {
// Circus
$c = new Criteria();
$c->addJoin(ListaPeer::CIRCUNSCRIPCION_ID, CircunscripcionPeer::ID);
$c->addJoin(CircunscripcionPeer::GEO_ID, GeoPeer::ID);
$c->add(ListaPeer::CONVOCATORIA_ID, $this->convocatoriaId);
$c->addAscendingOrderByColumn(GeoPeer::NOMBRE);
$c->setDistinct();
$circus = CircunscripcionPeer::doSelect($c);
$this->numEscanyos = 0;
foreach ($circus as $circu) {
$listaElectoral = new ListaElectoral($this->convocatoriaId, $this->partidoId, $circu->getGeo()->getNombre());
$res = $this->convocatoria->getResults($circu->getGeo()->getNombre(), false);
$sum = $listaElectoral->getEscanyos($res['minSumu'], $res['minSumd'], $res['lastDate'], $res['apellidos']);
$this->numEscanyos += $sum;
}
}
$data = $this->numEscanyos;
if ($cache) {
$cache->set($key, serialize($data ? $data : "zero"), 3600);
}
}
return $data == "zero" ? 0 : $data;
}
