public function executeKeyvote($limite = 5)
{
// voti in evidenza
$this->limit = $limite;
$this->limit_count = 0;
$this->lanci = array();
$c = new Criteria();
$c->addJoin(OppVotazionePeer::ID, sfLaunchingPeer::OBJECT_ID);
$c->addJoin(OppVotazionePeer::SEDUTA_ID, OppSedutaPeer::ID);
$c->add(OppSedutaPeer::RAMO, $this->ramo == 'senato' ? 'S' : 'C');
$c->add(sfLaunchingPeer::OBJECT_MODEL, 'OppVotazione');
$c->add(sfLaunchingPeer::LAUNCH_NAMESPACE, 'key_vote');
//$c->addDescendingOrderByColumn(sfLaunchingPeer::PRIORITY);
$c->addDescendingOrderByColumn(OppSedutaPeer::DATA);
$evidences = sfLaunchingPeer::doSelect($c);
foreach ($evidences as $evidence) {
$c1 = new Criteria();
$c1->addJoin(OppCaricaPeer::ID, OppVotazioneHasCaricaPeer::CARICA_ID);
$c1->add(OppVotazioneHasCaricaPeer::CARICA_ID, $this->carica->getId());
$c1->add(OppVotazioneHasCaricaPeer::VOTAZIONE_ID, $evidence->getObjectId());
$result = OppVotazioneHasCaricaPeer::doSelectOne($c1);
if ($result) {
$this->lanci[] = array($result->getOppVotazione(), $evidence->getObjectModel(), $result->getVoto());
}
}
}
