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