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; }