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()) {
}
}
