public static function getDatesCursosHospici($a_cursos) { $C = new Criteria(); $C->add(self::ACTIU, true); $C->add(self::IDCURSOS, $a_cursos, CRITERIA::IN); $C->addJoin(TipusPeer::IDTIPUS, self::CATEGORIA); $C->addGroupByColumn(self::IDCURSOS); $RET = array(); $SOL = array(); $RET[0] = array('NOM' => "En el futur...", 'COUNT' => 0); foreach (CursosPeer::doSelect($C) as $OC) { $m = $OC->getDatainici('m'); $y = $OC->getDatainici('Y'); $TRIM = self::toTrimestre($m, $y); if (!isset($RET[$TRIM['ID']])) { $RET[$TRIM['ID']] = array('NOM' => $y . ' . ' . $TRIM['NOM'], 'COUNT' => 0); } $RET[$TRIM['ID']]['COUNT'] += 1; $RET[0]['COUNT'] += 1; } asort($RET); foreach ($RET as $K => $V) { $SOL[$K] = $V['NOM'] . " ({$V['COUNT']})"; } return $SOL; }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param PropelPDO $con the connection to use * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function retrieveByPKs($pks, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(CursosPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(CursosPeer::DATABASE_NAME); $criteria->add(CursosPeer::IDCURSOS, $pks, Criteria::IN); $objs = CursosPeer::doSelect($criteria, $con); } return $objs; }
/** * Per cada curs, recarreguem els descomptes i els treballem * @deprecated * */ public function executeMigraCursos(sfWebRequest $request) { $C = new Criteria(); $C->add(CursosPeer::ADESCOMPTES, null, CRITERIA::ISNOTNULL); $A = array(); foreach (CursosPeer::doSelect($C) as $OC) { $i = 0; foreach (explode('@', $OC->getADescomptesVell()) as $A) { //Agafo un descompte, creo el que toqui a descomptes i els assigno a les matrícules $OD = DescomptesPeer::retrieveByPK($A); if ($A > 0) { if ($OD instanceof Descomptes) { $ODN = new Descomptes(); $ODN->setIdextern($OC->getIdcursos()); $ODN->setNom($OD->getNom()); $ODN->setPercentatge($OD->getPercentatge()); $ODN->setPreu(null); $ODN->setTipus(DescomptesPeer::TIPUS_CURS); $ODN->setActiu(true); $ODN->setSiteId($OD->getSiteId()); $ODN->save(); echo 'OK: ' . $OC->getIdcursos() . ' <br />'; //Un cop guardat, carrego totes les matrícules que el tenen d'aquest curs i ho modifico $CM = new Criteria(); $CM->add(MatriculesPeer::TREDUCCIO, $A); $CM->add(MatriculesPeer::CURSOS_IDCURSOS, $OC->getIdcursos()); foreach (MatriculesPeer::doSelect($CM) as $OM) { $OM->setTreduccio($ODN->getIddescompte()); $OM->save(); } } else { echo 'Error: ' . $OC->getIdcursos() . ' - ' . $A . ' <br />'; } } } } return sfView::NONE; }
static function getCursosMatriculacio($idS) { $C = new Criteria(); $C = CursosPeer::getCriteriaActiu($C, $idS); $C->add(CursosPeer::ISACTIU, true); $C->addAscendingOrderByColumn(CursosPeer::CATEGORIA); $C->addAscendingOrderByColumn(CursosPeer::CODI); return CursosPeer::doSelect($C); }