public function getCommissioni()
{
$sedi = array();
$c = new Criteria();
$c->add(OppAttoPeer::ID, $this->getId(), Criteria::EQUAL);
$c->addJoin(OppAttoPeer::ID, OppAttoHasSedePeer::ATTO_ID);
$c->addDescendingOrderByColumn('tipo');
return OppAttoHasSedePeer::doSelectJoinOppSede($c);
}
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;
}
