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