<?php
$resoconto = OppResocontoPeer::retrieveByPK($result->propel_id);
$num_seduta = $resoconto->getNumSeduta();
//$sede = $resoconto->getOppSede();
?>
<a href="<?php
echo $resoconto->getUrl();
?>
" target="_blank">
Resoconto della seduta <?php
echo $num_seduta ? ' n. ' . $num_seduta : '';
?>
del <?php
echo $resoconto->getData('d/m/Y');
?>
<br /> <?php
echo $resoconto->getNota();
?>
</a>
<span style="font-size: 11px; color: gray;">(<?php
echo date("d/m/Y", strtotime($result->data_pres_dt));
?>
)</span>
public function executeLavoroCommissioni()
{
$c = new Criteria();
$c->add(OppSedePeer::RAMO, $this->ramo);
$c->add(OppSedePeer::TIPOLOGIA, 'Commissione permanente');
$comms = OppSedePeer::doSelect($c);
foreach ($comms as $comm) {
$c = new Criteria();
$c->addJoin(OppAttoPeer::ID, OppAttoHasSedePeer::ATTO_ID);
$c->add(OppAttoPeer::LEGISLATURA, $this->leg);
$c->add(OppAttoPeer::TIPO_ATTO_ID, 1);
$c->add(OppAttoHasSedePeer::SEDE_ID, $comm->getId());
$c->add(OppAttoHasSedePeer::TIPO, 'Referente');
$ref = OppAttoHasSedePeer::doCount($c);
$c = new Criteria();
$c->addJoin(OppAttoPeer::ID, OppAttoHasSedePeer::ATTO_ID);
$c->add(OppAttoPeer::LEGISLATURA, $this->leg);
$c->add(OppAttoPeer::TIPO_ATTO_ID, 1);
$c->add(OppAttoHasSedePeer::SEDE_ID, $comm->getId());
$c->add(OppAttoHasSedePeer::TIPO, 'Consultiva');
$con = OppAttoHasSedePeer::doCount($c);
$c = new Criteria();
$c->addJoin(OppAttoPeer::ID, OppAttoHasSedePeer::ATTO_ID);
$c->add(OppAttoPeer::LEGISLATURA, $this->leg);
$c->add(OppAttoPeer::TIPO_ATTO_ID, 1, Criteria::NOT_EQUAL);
$c->add(OppAttoHasSedePeer::SEDE_ID, $comm->getId());
$atti_non_leg = OppAttoHasSedePeer::doCount($c);
$c = new Criteria();
$c->add(OppResocontoPeer::LEGISLATURA, $this->leg);
$c->add(OppResocontoPeer::SEDE_ID, $comm->getId());
$sedute = OppResocontoPeer::doCount($c);
$c = new Criteria();
$c->addJoin(OppAttoPeer::ID, OppInterventoPeer::ATTO_ID);
$c->add(OppAttoPeer::LEGISLATURA, $this->leg);
$c->add(OppInterventoPeer::SEDE_ID, $comm->getId());
$interventi = OppInterventoPeer::doCount($c);
$compara_comm[$comm->getId()] = array($ref, $con, $atti_non_leg, $sedute, $interventi);
}
$this->compara_comm = $compara_comm;
}
