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