public function getArrayHorarisEspaisMaterial() { $RET = array(); $C = new Criteria(); $C = HorarisespaisPeer::getCriteriaActiu($C, $this->getSiteId()); // $C->add( HorarisespaisPeer::IDESPAIEXTERN, null); $C->addGroupByColumn(HorarisespaisPeer::MATERIAL_IDMATERIAL); $LHE = $this->getHorarisespaiss($C); foreach ($LHE as $HE) { $OM = MaterialPeer::retrieveByPK($HE->getMaterialIdmaterial()); if ($OM instanceof Material) { $RET[$OM->getIdmaterial()] = array('material' => $OM->getIdmaterial(), 'nom' => $OM->toString(), 'generic' => $OM->getMaterialgenericIdmaterialgeneric()); } } return $RET; }
/** * 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(MaterialPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(MaterialPeer::DATABASE_NAME); $criteria->add(MaterialPeer::IDMATERIAL, $pks, Criteria::IN); $objs = MaterialPeer::doSelect($criteria, $con); } return $objs; }
function formEditaHoraris($IDA, $FHorari, $MISSATGE, $EXTRES, $IDS) { ?> <form action="<?php echo url_for('gestio/gActivitats'); ?> " method="POST"> <?php if (isset($MISSATGE)) { ?> <div style="padding:20px; margin-left:20px; border:10px solid red; width:650px; background-color: black; color:yellow; font-weight:bold;"><?php echo '<ul>'; if (!isset($MISSATGE)) { $MISSATGE = array(); } foreach ($MISSATGE as $M) { echo '<li>' . $M . '</li>'; } echo '</ul>'; ?> </div> <?php } ?> <div class="REQUADRE"> <div class="OPCIO_FINESTRA"><?php echo link_to(image_tag('icons/Grey/PNG/action_delete.png'), 'gestio/gActivitats?accio=HORARI&IDA=' . $IDA . '&form=0'); ?> </div> <div class="TITOL">Edició horaris</div> <div class="FORMULARI"> <?php echo $FHorari; ?> <div class="clear row fb"> <span class="title row_title fb"><b>Espais: </b></span> <span class="row_field fb"> <?php $id = 1; $VAL = ""; foreach ($EXTRES['ESPAISOUT'] as $idE => $nom) { if (!empty($idE)) { $VAL .= '<span id="rowE[' . $id . ']"> <select name="espais[' . $id . ']" id="espais[' . $id . ']">' . EspaisPeer::selectJavascript($IDS, $idE) . '</select> <input type="button" style="width:30px;" onClick="esborraLiniaE(' . $id . ');" id="mesespais" value="-"></input> <br /> </span> '; $id++; } } echo '<input type="button" id="mesespais" style="width:30px;" value="+"></input><br />'; echo '<input type="hidden" id="idE" value="' . $id . '"></input>'; echo '<div id="divTxtE">' . $VAL . '</div>'; ?> </span> </div> <div class="clear row fb"> <span class="title row_title fb"><b>Material: </b></span> <span class="row_field fb"> <?php $id = 1; $VAL = ""; foreach ($EXTRES['MATERIALOUT'] as $M => $idM) { $VAL .= ' <span id="row[' . $id . ']"> <select onChange="ajax(this,' . $id . ')" name="generic[' . $id . ']"> id="generic[' . $id . ']">' . options_for_select(MaterialgenericPeer::select($IDS), $idM['generic']) . '</select> <select name="material[' . $id . ']" id="material[' . $id . ']">' . options_for_select(MaterialPeer::selectGeneric($idM['generic'], $IDS, $idM['material']), $idM['material']) . '</select> <input type="button" style="width:30px;" onClick="esborraLinia(' . $id . ');" id="mesmaterial" value="-"></input> <br /> </span> '; $id++; } echo '<input type="button" id="mesmaterial" style="width:30px;" value="+"></input><br />'; echo '<input type="hidden" id="idV" value="' . $id . '"></input>'; echo '<div id="divTxt">' . $VAL . '</div>'; ?> </span> </div> <div class="clear"></div> <div id="div_lloc_extern" class="clear row fb"> <span class="title row_title fb"><b>Opcions: </b></span> <span class="row_field fb"> <a href="#" id="a_lloc_extern">L'activitat es realitza a un lloc extern</a> </span> </div> <div id="formulari_lloc_extern"> <div><b>Població externa</b><br /><br /></div> <?php echo $EXTRES['ESPAIEXTERN']; ?> <div class="clear"></div> </div> <div class="clear row fb"> <div style="text-align:right"> <?php include_partial('botonera', array('element' => 'l\\\'horari', 'tipus' => 'Guardar', 'nom' => 'BHORARISAVE')); ?> <?php include_partial('botonera', array('element' => 'l\\\'horari', 'tipus' => 'Esborrar', 'nom' => 'BHORARIDELETE')); ?> </div> </div> </div> <div class="clear"></div> </div> <script type="text/javascript"> $(function() { $('#multi999Datepicker').datepick({numberOfMonths: 3, multiSelect: 999, showOn: 'both', buttonImageOnly: true, buttonImage: '<?php echo image_path('template/calendar_1.png'); ?> '}); }); </script> </form> <?php }
public function LoadEscullMaterial($OCESSIO, $RMATERIAL = null, $RMATERIALNOINV = "", $ERROR_SELECT_MATERIAL = false) { $this->MATERIALOUT = array(); //Si és una cessió nova if (!$OCESSIO->isNew() && !$ERROR_SELECT_MATERIAL) { $this->MATERIALOUT = CessiomaterialPeer::getSelectMaterialOut($OCESSIO->getCessioId(), $this->IDS); $this->MAT_NO_INV = $OCESSIO->getMaterialNoInventariat(); //Si és una edició } else { //Carreguem el material no inventariat i passem el material a visualitzar altre cop $this->MAT_NO_INV = $RMATERIALNOINV; foreach ($RMATERIAL as $G => $AM) { $idMG = MaterialPeer::retrieveByPK($AM)->getMaterialgenericIdmaterialgeneric(); $this->MATERIALOUT[] = array('material' => $AM, 'generic' => $idMG); } } $this->IDC = $this->FCessio->getObject()->getCessioId(); $this->MODE = 'ESCULL_MATERIAL'; }
/** * Returns the number of related Material objects. * * @param Criteria $criteria * @param boolean $distinct * @param PropelPDO $con * @return int Count of related Material objects. * @throws PropelException */ public function countMaterials(Criteria $criteria = null, $distinct = false, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(MaterialgenericPeer::DATABASE_NAME); } else { $criteria = clone $criteria; } if ($distinct) { $criteria->setDistinct(); } $count = null; if ($this->collMaterials === null) { if ($this->isNew()) { $count = 0; } else { $criteria->add(MaterialPeer::MATERIALGENERIC_IDMATERIALGENERIC, $this->idmaterialgeneric); $count = MaterialPeer::doCount($criteria, false, $con); } } else { // criteria has no effect for a new object if (!$this->isNew()) { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return count of the collection. $criteria->add(MaterialPeer::MATERIALGENERIC_IDMATERIALGENERIC, $this->idmaterialgeneric); if (!isset($this->lastMaterialCriteria) || !$this->lastMaterialCriteria->equals($criteria)) { $count = MaterialPeer::doCount($criteria, false, $con); } else { $count = count($this->collMaterials); } } else { $count = count($this->collMaterials); } } return $count; }
/** * Populates the object using an array. * * This is particularly useful when populating an object from one of the * request arrays (e.g. $_POST). This method goes through the column * names, checking to see whether a matching key exists in populated * array. If so the setByName() method is called for that column. * * You can specify the key type of the array by additionally passing one * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME, * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM. * The default key type is the column's phpname (e.g. 'AuthorId') * * @param array $arr An array to populate the object from. * @param string $keyType The type of keys the array uses. * @return void */ public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = MaterialPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setIdmaterial($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setMaterialgenericIdmaterialgeneric($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setNom($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setDescripcio($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setResponsable($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setUbicacio($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setDatacompra($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setIdentificador($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setIdentificadorComptable($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setNumserie($arr[$keys[9]]); } if (array_key_exists($keys[10], $arr)) { $this->setDatagarantia($arr[$keys[10]]); } if (array_key_exists($keys[11], $arr)) { $this->setDatarevisio($arr[$keys[11]]); } if (array_key_exists($keys[12], $arr)) { $this->setCedit($arr[$keys[12]]); } if (array_key_exists($keys[13], $arr)) { $this->setDatacessio($arr[$keys[13]]); } if (array_key_exists($keys[14], $arr)) { $this->setDataretorn($arr[$keys[14]]); } if (array_key_exists($keys[15], $arr)) { $this->setNumfactura($arr[$keys[15]]); } if (array_key_exists($keys[16], $arr)) { $this->setProveidor($arr[$keys[16]]); } if (array_key_exists($keys[17], $arr)) { $this->setPreu($arr[$keys[17]]); } if (array_key_exists($keys[18], $arr)) { $this->setAmortitzacio($arr[$keys[18]]); } if (array_key_exists($keys[19], $arr)) { $this->setVidaUtil($arr[$keys[19]]); } if (array_key_exists($keys[20], $arr)) { $this->setNotesmanteniment($arr[$keys[20]]); } if (array_key_exists($keys[21], $arr)) { $this->setDatabaixa($arr[$keys[21]]); } if (array_key_exists($keys[22], $arr)) { $this->setDatareparacio($arr[$keys[22]]); } if (array_key_exists($keys[23], $arr)) { $this->setDisponible($arr[$keys[23]]); } if (array_key_exists($keys[24], $arr)) { $this->setAltaregistre($arr[$keys[24]]); } if (array_key_exists($keys[25], $arr)) { $this->setIstransferible($arr[$keys[25]]); } if (array_key_exists($keys[26], $arr)) { $this->setIsadministratiu($arr[$keys[26]]); } if (array_key_exists($keys[27], $arr)) { $this->setSiteId($arr[$keys[27]]); } if (array_key_exists($keys[28], $arr)) { $this->setActiu($arr[$keys[28]]); } if (array_key_exists($keys[29], $arr)) { $this->setUnitats($arr[$keys[29]]); } }
/** * Get the associated Material object * * @param PropelPDO Optional Connection object. * @return Material The associated Material object. * @throws PropelException */ public function getMaterial(PropelPDO $con = null) { if ($this->aMaterial === null && $this->material_idmaterial !== null) { $this->aMaterial = MaterialPeer::retrieveByPk($this->material_idmaterial); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->aMaterial->addCessiomaterials($this); */ } return $this->aMaterial; }
<div> <input type="hidden" name="IDC" value="<?php echo $IDC; ?> " /> <?php $id = 1; $VAL = ""; if (!isset($MATERIALOUT)) { $MATERIALOUT = array(); } foreach ($MATERIALOUT as $M => $idM) { $VAL .= ' <span id="row[' . $id . ']"> <select onChange="ajax(this,' . $id . ')" name="generic[' . $id . ']"> id="generic[' . $id . ']">' . options_for_select(MaterialgenericPeer::select($IDS), $idM['generic']) . '</select> <select name="material[' . $id . ']" id="material[' . $id . ']">' . options_for_select(MaterialPeer::selectGeneric($idM['generic'], $IDS, $idM['material']), $idM['material']) . '</select> <input type="button" onClick="esborraLinia(' . $id . ');" id="mesmaterial" value="-"></input> <br /> </span> '; $id++; } echo '<input type="button" id="mesmaterial" value="+"></input><br />'; echo '<input type="hidden" id="idV" value="' . $id . '"></input>'; echo '<div id="divTxt">' . $VAL . '</div>'; ?> </div> <br /> <div class="fb TITOL" style="width:100%">Material no inventariat</div>
/** * Entrem l'identificador de la línia que estem tractant * * @param int idL */ public static function getLinies($idL) { $C = new Criteria(); $C->add(MaterialPeer::MATERIALGENERIC_IDMATERIALGENERIC, $idL); return MaterialPeer::doCount($C); }
/** * Selects a collection of Cessiomaterial objects pre-filled with all related objects except Cessio. * * @param Criteria $criteria * @param PropelPDO $con * @param String $join_behavior the type of joins to use, defaults to Criteria::LEFT_JOIN * @return array Array of Cessiomaterial objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAllExceptCessio(Criteria $criteria, $con = null, $join_behavior = Criteria::LEFT_JOIN) { $criteria = clone $criteria; // Set the correct dbName if it has not been overridden // $criteria->getDbName() will return the same object if not set to another value // so == check is okay and faster if ($criteria->getDbName() == Propel::getDefaultDB()) { $criteria->setDbName(self::DATABASE_NAME); } CessiomaterialPeer::addSelectColumns($criteria); $startcol2 = CessiomaterialPeer::NUM_COLUMNS - CessiomaterialPeer::NUM_LAZY_LOAD_COLUMNS; MaterialPeer::addSelectColumns($criteria); $startcol3 = $startcol2 + (MaterialPeer::NUM_COLUMNS - MaterialPeer::NUM_LAZY_LOAD_COLUMNS); $criteria->addJoin(CessiomaterialPeer::MATERIAL_IDMATERIAL, MaterialPeer::IDMATERIAL, $join_behavior); // symfony_behaviors behavior foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) { call_user_func($sf_hook, 'BaseCessiomaterialPeer', $criteria, $con); } $stmt = BasePeer::doSelect($criteria, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = CessiomaterialPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = CessiomaterialPeer::getInstanceFromPool($key1))) { // We no longer rehydrate the object, since this can cause data loss. // See http://propel.phpdb.org/trac/ticket/509 // $obj1->hydrate($row, 0, true); // rehydrate } else { $cls = CessiomaterialPeer::getOMClass(false); $obj1 = new $cls(); $obj1->hydrate($row); CessiomaterialPeer::addInstanceToPool($obj1, $key1); } // if obj1 already loaded // Add objects for joined Material rows $key2 = MaterialPeer::getPrimaryKeyHashFromRow($row, $startcol2); if ($key2 !== null) { $obj2 = MaterialPeer::getInstanceFromPool($key2); if (!$obj2) { $cls = MaterialPeer::getOMClass(false); $obj2 = new $cls(); $obj2->hydrate($row, $startcol2); MaterialPeer::addInstanceToPool($obj2, $key2); } // if $obj2 already loaded // Add the $obj1 (Cessiomaterial) to the collection in $obj2 (Material) $obj2->addCessiomaterial($obj1); } // if joined row is not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
function formCercaMaterials($CERCA, $IDS) { ?> <form action="<?php echo url_for('gestio/gEstadistiques'); ?> " id="FMATERIALS" method="POST"> <table class="FORMULARI" width="100%"> <tr><td> <div class="TITOL">Cerca materials</div> <div class="CERCA"> <div style="margin-bottom:10px;"> <?php echo select_tag('cerca[ANY]', options_for_select(selectAnys(), $CERCA['ANY']), array('class' => 'cinquanta')); ?> <?php echo select_tag('cerca[MES]', options_for_select(selectMesos(), $CERCA['MES'], array()), array('class' => 'cinquanta')); ?> <?php echo select_tag('cerca[MATERIAL_GENERIC]', options_for_select(MaterialgenericPeer::select($IDS, false, false), $CERCA['MATERIAL_GENERIC'])); ?> </div> <?php foreach (MaterialPeer::selectGeneric($CERCA['MATERIAL_GENERIC'], $IDS) as $K => $V) { echo '<div style="float:left; width:210px;">' . checkbox_tag('cerca[MATERIAL][' . $K . ']', $K, isset($CERCA['MATERIAL'][$K]), array()) . ' ' . $V . ' (M' . $K . ')</div>'; } ?> </div> </td></tr> <tr> <td colspan="2"> <input type="submit" name="BCERCA_MAT" value="Prem per buscar" /> </td> </tr> </table> </form> <?php }
/** * This is a method for emulating ON DELETE CASCADE for DBs that don't support this * feature (like MySQL or SQLite). * * This method is not very speedy because it must perform a query first to get * the implicated records and then perform the deletes by calling those Peer classes. * * This method should be used within a transaction if possible. * * @param Criteria $criteria * @param PropelPDO $con * @return int The number of affected rows (if supported by underlying database driver). */ protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con) { // initialize var to track total num of affected rows $affectedRows = 0; // first find the objects that are implicated by the $criteria $objects = MaterialgenericPeer::doSelect($criteria, $con); foreach ($objects as $obj) { // delete related Material objects $criteria = new Criteria(MaterialPeer::DATABASE_NAME); $criteria->add(MaterialPeer::MATERIALGENERIC_IDMATERIALGENERIC, $obj->getIdmaterialgeneric()); $affectedRows += MaterialPeer::doDelete($criteria, $con); } return $affectedRows; }
public function GuardaHorari($horaris, $EXTRES, $idS) { $ERRORS = array(); $DBDD[] = array(); //Comprovem que s'hagi entrat un dia if (empty($horaris['Dia'])) { $ERRORS[] = "No has entrat cap data"; $DBDD['DIES'] = array(); } else { $DIES = explode(',', $horaris['Dia']); foreach ($DIES as $D) { list($dia, $mes, $any) = explode('/', $D); if (!($any > 2000 && $mes < 13 && $dia < 32)) { $ERRORS[] = "La data que has entrat és incorrecta"; } $DBDD['DIES'][] = "{$any}-{$mes}-{$dia}"; } } //Passem l'hora a format numèric per fer les comprovacions $DBDD['HoraPre'] = strval($horaris['HoraPre']['hour']) * 60 + strval($horaris['HoraPre']['minute']); $DBDD['HoraIn'] = strval($horaris['HoraInici']['hour']) * 60 + strval($horaris['HoraInici']['minute']); $DBDD['HoraFi'] = strval($horaris['HoraFi']['hour']) * 60 + strval($horaris['HoraFi']['minute']); $DBDD['HoraPost'] = strval($horaris['HoraPost']['hour']) * 60 + strval($horaris['HoraPost']['minute']); if ($DBDD['HoraPre'] > $DBDD['HoraIn']) { $ERRORS[] = "L'hora de preparació no pot ser més gran que la d'inici."; } if ($DBDD['HoraIn'] >= $DBDD['HoraFi']) { $ERRORS[] = "L'hora d'inici no pot ser més gran o igual que la d'acabament."; } if ($DBDD['HoraFi'] > $DBDD['HoraPost']) { $ERRORS[] = "L'hora d'acabament no pot ser més gran que la de desmuntatge."; } //Un cop fetes les verificacions... tornem a posar els valors que guardarem $DBDD['HoraPre'] = $horaris['HoraPre']['hour'] . ':' . $horaris['HoraPre']['minute']; $DBDD['HoraIn'] = $horaris['HoraInici']['hour'] . ':' . $horaris['HoraInici']['minute']; $DBDD['HoraFi'] = $horaris['HoraFi']['hour'] . ':' . $horaris['HoraFi']['minute']; $DBDD['HoraPost'] = $horaris['HoraPost']['hour'] . ':' . $horaris['HoraPost']['minute']; //Hem d'entrar algun espai ja sigui intern o extern i no podem entrar espais interns i a més externs if (empty($EXTRES['ESPAISOUT']) && !$EXTRES['ESPAIEXTERN']->isBound()) { $ERRORS[] = "Has d'entrar algun espai intern o extern"; } if (!empty($EXTRES['ESPAISOUT']) && $EXTRES['ESPAIEXTERN']->isBound()) { $ERRORS[] = "No pots entrar espais interns i externs a la vegada"; } //Mirem que la data no es solapi amb alguna altra activitat al mateix espai foreach ($DBDD['DIES'] as $D) { //Per tots els espais interns foreach ($EXTRES['ESPAISOUT'] as $E => $idE) { //Si l'usuari bloqueja un espai hem de mirar que no hi hagi cap activitat aquell dia. if ($idE == 22) { $RS = HorarisPeer::getActivitatsDia($D, $idS); if (sizeof($RS) > 0) { $ERRORS[] = "El dia {$D} hi ha " . sizeof($RS) . " activitat(s) que impedeixen el bloqueig."; } } else { //Mirem si encaixa amb alguna altra activitat solta $LOH = HorarisPeer::validaDia($D, $idE, $DBDD['HoraPre'], $DBDD['HoraPost'], $horaris['HorarisID'], $idS); if (sizeof($LOH) > 0) { $Espai = EspaisPeer::retrieveByPK($idE)->getNom(); foreach ($LOH as $OH) { $OA = $OH->getActivitatss(); $nomActivitat = $OA->getNom(); $ERRORS[] = "El dia {$D} coincideix a l'espai {$Espai} amb l'activitat '" . $nomActivitat . "'"; } } elseif (HorarisPeer::validaDiaBloqueig($D, $horaris['HorarisID'], $this->IDS)) { $ERRORS[] = "El dia {$D} hi ha una activitat que bloqueja tots els espais!"; } } } //Comprovem l'ocupació del material foreach ($EXTRES['MATERIALOUT'] as $M => $idM) { if (!MaterialPeer::isLliure($idM['material'], $this->IDS, $D, $DBDD['HoraPre'], $DBDD['HoraPost'], $horaris['HorarisID'])) { $OM = MaterialPeer::retrieveByPK($idM['material']); if ($OM instanceof Material) { $nom = $OM->toString(); } else { $nom = "n/d"; } $ERRORS[] = "El material " . $nom . " està ocupat el dia " . $D; } } } //Si no hem trobat cap error, guardem els registres d'ocupació. if (empty($ERRORS)) { HorarisPeer::save($horaris, $DBDD, $EXTRES, $idS); } return $ERRORS; }
public static function getSelectMaterialOut($idC, $idS) { $C = new Criteria(); $C->add(self::CESSIO_ID, $idC); $C->add(self::SITE_ID, $idS); $C->add(self::ACTIU, true); $C->addJoin(self::MATERIAL_IDMATERIAL, MaterialPeer::IDMATERIAL); $RET = array(); foreach (MaterialPeer::doSelect($C) as $K => $V) { $RET[] = array('material' => $V->getIdmaterial(), 'generic' => $V->getMaterialgenericIdmaterialgeneric()); } return $RET; }
public function getMaterialsActiu() { $C = new Criteria(); $C = MaterialPeer::getCriteriaActiu($C, $this->getSiteId()); return $this->getMaterials($C); }
/** * Comprova que el dia estigui lliure * */ public static function validaDia($DIA, $idE, $HoraPre, $HoraPost, $idH, $idS) { //Garantim que si hi ha un altre espai, no comprovi if ($idE == 1) { $idE = 0; } //Tornar-la a fer per fer-la més criteria; $C = new Criteria(); $C = self::getCriteriaActiu($C, $idS); $C->addJoin(self::HORARISID, HorarisespaisPeer::HORARIS_HORARISID); $C = HorarisespaisPeer::getCriteriaActiu($C, $idS); $C->add(HorarisespaisPeer::ESPAIS_ESPAIID, $idE); $C->addAnd(MaterialPeer::getCriteriaSolapament($C, $HoraPre, $HoraPost, HorarisPeer::HORAPRE, HorarisPeer::HORAPOST)); $C->add(self::DIA, $DIA); if ($idH > 0) { $C->add(HorarisespaisPeer::HORARIS_HORARISID, $idH, Criteria::NOT_EQUAL); } return self::doSelect($C); }