public function getUltimaActivitat() { $C = new Criteria(); $C = CiclesPeer::getCriteriaActiu($C, $this->getSiteId()); $C = ActivitatsPeer::getCriteriaActiu($C, $this->getSiteId()); $C = HorarisPeer::getCriteriaActiu($C, $this->getSiteId()); $C->add(CiclesPeer::CICLEID, $this->getCicleid()); $C->addJoin(CiclesPeer::CICLEID, ActivitatsPeer::CICLES_CICLEID); $C->addJoin(ActivitatsPeer::ACTIVITATID, HorarisPeer::ACTIVITATS_ACTIVITATID); $C->addDescendingOrderByColumn(HorarisPeer::DIA); $OA = ActivitatsPeer::doSelectOne($C); if ($OA instanceof Activitats) { return $OA; } else { return null; } }
public function getActivitatss() { $C = new Criteria(); $C = ActivitatsPeer::getCriteriaActiu($C, $this->getSiteId()); $C = HorarisPeer::getCriteriaActiu($C, $this->getSiteId()); $C->add(HorarisPeer::HORARISID, $this->getHorarisid()); $C->addJoin(HorarisPeer::ACTIVITATS_ACTIVITATID, ActivitatsPeer::ACTIVITATID); $C->addGroupByColumn(ActivitatsPeer::ACTIVITATID); return ActivitatsPeer::doSelectOne($C); }