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