public function getMatricules($idS = 0)
{
$C = new Criteria();
$C = UsuarisPeer::getCriteriaActiu($C, $idS);
$C = MatriculesPeer::getCriteriaActiu($C, $idS);
$C->addJoin(UsuarisPeer::USUARIID, MatriculesPeer::USUARIS_USUARIID);
$C->add(MatriculesPeer::ESTAT, MatriculesPeer::EN_PROCES, CRITERIA::NOT_EQUAL);
$C->add(UsuarisPeer::USUARIID, $this->getUsuariid());
return MatriculesPeer::doSelect($C);
}
public function countMatriculesActives($idS)
{
$C = new Criteria();
$C = MatriculesPeer::getCriteriaActiu($C, $idS);
$C1 = $C->getNewCriterion(MatriculesPeer::ESTAT, MatriculesPeer::ACCEPTAT_NO_PAGAT);
$C2 = $C->getNewCriterion(MatriculesPeer::ESTAT, MatriculesPeer::ACCEPTAT_PAGAT);
$C1->addOr($C2);
$C->add($C1);
$C->add(MatriculesPeer::CURSOS_IDCURSOS, $this->getIdcursos());
return MatriculesPeer::doCount($C);
}
static function getMatricules($idC, $idS)
{
$Curs = self::retrieveByPK($idC);
$C = new Criteria();
$C = MatriculesPeer::getCriteriaActiu($C, $idS);
$c3 = $C->getNewCriterion(MatriculesPeer::ESTAT, MatriculesPeer::ACCEPTAT_NO_PAGAT);
$c1 = $C->getNewCriterion(MatriculesPeer::ESTAT, MatriculesPeer::ACCEPTAT_PAGAT);
$c2 = $C->getNewCriterion(MatriculesPeer::ESTAT, MatriculesPeer::EN_ESPERA);
$c1->addOr($c2);
$c1->addOr($c3);
$C->add($c1);
$C->addJoin(MatriculesPeer::USUARIS_USUARIID, UsuarisPeer::USUARIID);
$C->addAscendingOrderByColumn(UsuarisPeer::COG1);
$C->addAscendingOrderByColumn(UsuarisPeer::COG2);
$C->addAscendingOrderByColumn(UsuarisPeer::NOM);
return $Curs->getMatriculess($C);
}
