public function getPrimerDia() { $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->addAscendingOrderByColumn(HorarisPeer::DIA); $OH = HorarisPeer::doSelectOne($C); if ($OH instanceof Horaris) { return $OH->getDia('d/m/Y'); } else { return "n/d"; } }
public static function getPrimerHorariActivitat($IDA, $idS) { $C = new Criteria(); $C = HorarisPeer::getCriteriaActiu($C, $idS); $C->add(HorarisPeer::ACTIVITATS_ACTIVITATID, $IDA); $C->addAscendingOrderByColumn(HorarisPeer::DIA); $OH = HorarisPeer::doSelectOne($C); if ($OH instanceof Horaris) { return $OH; } else { return null; } }
public static function getDataUltimaActivitat($idC, $idS) { $C = new Criteria(); $C = self::getCriteriaActiu($C, $idS); $C = ActivitatsPeer::getCriteriaActiu($C, $idS); $C->addJoin(ActivitatsPeer::ACTIVITATID, HorarisPeer::ACTIVITATS_ACTIVITATID); $C->add(ActivitatsPeer::CICLES_CICLEID, $idC); $C->addDescendingOrderByColumn(HorarisPeer::DIA); $OH = HorarisPeer::doSelectOne($C); if ($OH instanceof Horaris) { return $OH->getDia('d/m/Y'); } else { return 'n/d'; } }
/** * Retorna l'horari que corresp�n al dia en q�esti� **/ public function getHorariDia($dia) { $C = new Criteria(); $C->add(HorarisPeer::DIA, $dia); $C->add(HorarisPeer::ACTIVITATS_ACTIVITATID, $this->getActivitatid()); return HorarisPeer::doSelectOne($C); }