public static function doSelectNews() { $news = array(); // nuovi ddl $c = new Criteria(); $c->clearSelectColumns(); $c->addSelectColumn(OppAttoPeer::DATA_PRES); $c->addSelectColumn(OppAttoPeer::RAMO); $c->addSelectColumn(OppAttoPeer::NUMFASE); $c->addSelectColumn(OppAttoPeer::TITOLO); $c->addDescendingOrderByColumn(OppAttoPeer::DATA_PRES); $c->add(OppAttoPeer::TIPO_ATTO_ID, 1, Criteria::EQUAL); $c->setLimit(5); $rs = OppAttoPeer::doSelectRS($c); // cambi di status $c = new Criteria(); $c->clearSelectColumns(); $c->addSelectColumn(OppAttoHasIterPeer::DATA); $c->addSelectColumn(OppAttoPeer::RAMO); $c->addSelectColumn(OppAttoPeer::NUMFASE); $c->addSelectColumn(OppAttoPeer::TITOLO); $c->addSelectColumn(OppIterPeer::FASE); $c->addDescendingOrderByColumn(OppAttoPeer::DATA_PRES); $c->add(OppAttoPeer::TIPO_ATTO_ID, 1, Criteria::EQUAL); $c->addJoin(OppAttoHasIterPeer::ATTO_ID, OppAttoPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(OppAttoHasIterPeer::ITER_ID, OppIterPeer::ID, Criteria::LEFT_JOIN); $c->setLimit(5); $rs = OppAttoPeer::doSelectRS($c); while ($rs->next()) { } }