/** * 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(TipusPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(TipusPeer::DATABASE_NAME); $criteria->add(TipusPeer::IDTIPUS, $pks, Criteria::IN); $objs = TipusPeer::doSelect($criteria, $con); } return $objs; }
public static function getCategoriaCursosHospici($a_cursos) { $C = new Criteria(); $C->add(self::ACTIU, true); $C->add(self::IDCURSOS, $a_cursos, CRITERIA::IN); $C->addJoin(TipusPeer::IDTIPUS, self::CATEGORIA); $RET = array(); $SOL = array(); $RET[0] = array('NOM' => "Totes les categories...", 'COUNT' => 0); foreach (TipusPeer::doSelect($C) as $OT) { if (!isset($RET[$OT->getIdtipus()])) { $RET[$OT->getIdtipus()] = array('NOM' => $OT->getTipusdesc(), 'COUNT' => 0); } $RET[$OT->getIdtipus()]['COUNT'] += 1; $RET[0]['COUNT'] += 1; } foreach ($RET as $K => $V) { $SOL[$K] = $V['NOM'] . " ({$V['COUNT']})"; } return $SOL; }