public function executeInterventi()
{
$response = sfContext::getInstance()->getResponse();
if ($this->getUser()->isAuthenticated() && ($this->getUser()->hasCredential('amministratore') || $this->getUser()->hasCredential('adhoc'))) {
$response->addStylesheet('votazione_interventi', 'last');
$response->addJavascript('votazione_interventi', 'last');
}
$this->_getAndCheckParlamentare();
if ($this->carica == NULL) {
return;
}
$this->session = $this->getUser();
// reset dei filtri se richiesto esplicitamente
if ($this->getRequestParameter('reset_filters', 'false') == 'true') {
$this->getRequest()->getParameterHolder()->set('filter_ddls_collegati', '0');
}
$this->processInterventiFilters(array('ddls_collegati'));
// if all filters were reset, then restart
if ($this->getRequestParameter('filter_ddls_collegati') == '0') {
$this->redirect('@parlamentare_interventi?id=' . $this->getRequestParameter('id') . '&slug=' . $this->parlamentare->getSlug());
}
if ($this->hasRequestParameter('itemsperpage')) {
$this->getUser()->setAttribute('itemsperpage', $this->getRequestParameter('itemsperpage'));
}
$itemsperpage = $this->getUser()->getAttribute('itemsperpage', sfConfig::get('app_pagination_limit'));
$this->pager = new sfPropelPager('OppIntervento', $itemsperpage);
$c = new Criteria();
$c->add(OppInterventoPeer::CARICA_ID, $this->carica->getId());
$c->addDescendingOrderByColumn(OppInterventoPeer::CREATED_AT);
$this->addInterventiFiltersCriteria($c);
$this->pager->setCriteria($c);
$this->pager->setPage($this->getRequestParameter('page', 1));
$this->pager->setPeerMethod('doSelectJoinAll');
$this->pager->init();
$cariche_ids = $this->parlamentare->getCaricheCorrentiIds();
$this->ddls_collegati = OppInterventoPeer::getDDLCollegatiCariche($cariche_ids);
if ($this->carica->getTipoCaricaId() == 1) {
$ramo = 'C';
}
if ($this->carica->getTipoCaricaId() == 4 || $this->carica->getTipoCaricaId() == 5) {
$ramo = 'S';
}
$this->ramo = $ramo == 'C' ? 'camera' : 'senato';
$this->getResponse()->setTitle('Interventi in Parlamento ' . ($this->ramo == 'camera' ? 'On. ' : 'Sen. ') . $this->parlamentare->getNome() . ' ' . $this->parlamentare->getCognome() . ' - ' . sfConfig::get('app_main_title'));
// if ($this->ramo=='camera')
// $this->getResponse()->setTitle('On. '.$this->parlamentare->getNome().' '.$this->parlamentare->getCognome().' - interventi parlamentari - '.sfConfig::get('app_main_title'));
// else
// $this->getResponse()->setTitle('Sen. '.$this->parlamentare->getNome().' '.$this->parlamentare->getCognome().' - interventi parlamentari - '.sfConfig::get('app_main_title'));
$this->response->addMeta('description', 'La lista aggiornata quotidianamente di tutti gli interventi in Parlamento, in aula e nelle commissioni, di ' . $this->parlamentare->getNome() . ' ' . $this->parlamentare->getCognome(), true);
}
