public static function criteriaHorari_EspaiExtern($idH, $C, $idS) { //Agafem la relació amb un horari que té un espai extern. $C = HorarisespaisPeer::getCriteriaActiu($C, $idS); $C = EspaisExternsPeer::getCriteriaActiu($C, $idS); $C->add(HorarisespaisPeer::HORARIS_HORARISID, $idH); $C->add(HorarisespaisPeer::ESPAIS_ESPAIID, null); $C->addJoin(HorarisespaisPeer::IDESPAIEXTERN, EspaisExternsPeer::IDESPAIEXTERN); return EspaisExternsPeer::doSelect($C); }
public function getNomEspai() { //Si l'espai és null ens quedem amb el nom que apareix a l'horari. $idE = $this->getEspaisEspaiid(); if (is_null($idE)) { $OEE = EspaisExternsPeer::retrieveByPK($this->getIdespaiextern()); if (!$OEE instanceof EspaisExterns) { return 'n/d'; } else { return $OEE->getNom() . ' (' . $OEE->getPoblacions()->getNom() . ')'; } //Sinó retornem el nom de l'espai que hi ha a la taula espais' } else { return $this->getEspais()->getNom(); } }
public function executeGActivitats(sfWebRequest $request) { $this->setLayout('gestio'); $this->IDS = $this->getUser()->getSessionPar('idS'); //Netegem cerca if ($request->getParameter('accio') == 'C') { $this->CERCA = $this->getUser()->setSessionPar('cerca', array('text' => '')); $this->PAGINA = $this->getUser()->setSessionPar('pagina', 1); $this->DATAI = $this->getUser()->setSessionPar('DATAI', time()); } //Afegit per si algú ha d'enviar algun error $this->ERROR = $request->getParameter('ERROR'); if ($this->ERROR == "HORARI_NO_EXISTEIX") { $this->MISSATGE = array(0 => "L'Horari no existeix o no s'ha trobat."); } elseif ($this->ERROR == "ACTIVITAT_NO_EXISTEIX") { $this->MISSATGE = array(0 => "La activitat no existeix o no s'ha trobat. "); } elseif ($this->ERROR == "NO_HI_HA_MES_HORARIS") { $this->MISSATGE = array(0 => "No s'ha creat cap nova activitat, perquè només conté un horari."); } $this->CERCA = $this->getUser()->ParReqSesForm($request, 'cerca', array('text' => "")); $T = time(); $this->PAGINA = $request->getParameter('PAGINA', 1); $this->DATAI = $this->getUser()->ParReqSesForm($request, 'DATAI', $T); $this->DIA = $request->getParameter('DIA', time()); $this->IDA = $request->getParameter('IDA', 0); $this->accio = $request->getParameter('accio', 'C'); $this->ACTIVITAT_NOVA = false; //Inicialitzem el formulari de cerca $this->FCerca = new CercaForm(); if (isset($this->CERCA['text'])) { $this->FCerca->bind(array('text' => $this->CERCA['text'])); } else { $this->FCerca->bind(array('text' => '')); } //Inicialitzem variables $this->MODE = array(); if ($request->isMethod('POST')) { if ($request->hasParameter('BCERCA')) { $this->accio = 'C'; $this->PAGINA = 1; } elseif ($request->hasParameter('BNOU')) { $this->accio = 'ACTIVITAT'; } elseif ($request->hasParameter('BCICLE')) { $this->accio = 'CICLE'; } elseif ($request->hasParameter('BCICLESAVE')) { $this->accio = 'CICLE_SAVE'; } elseif ($request->hasParameter('B-GUARDA-ACTIVITAT')) { $this->accio = 'ACTIVITAT_SAVE'; } elseif ($request->hasParameter('B-ESBORRA-ACTIVITAT')) { $this->accio = 'ACTIVITAT_DELETE'; } elseif ($request->hasParameter('BGENERANOTICIA')) { $this->accio = 'GENERA_NOTICIA'; } elseif ($request->hasParameter('BPREUSSAVE')) { $this->accio = 'PREUS'; } } //Quan cliquem per primer cop a qualsevol de les cerques, la pàgina es posa a 1 if ($request->getParameter('accio') == 'C') { $this->PAGINA = 1; } if ($request->getParameter('accio') == 'CD') { $this->PAGINA = 1; } if ($request->hasParameter('DATAI')) { $this->DIA = ""; } //Aquest petit bloc és per si es modifica amb un POST el que s'ha enviat per GET //$this->getUser()->setSessionPar('PAGINA',$this->PAGINA); //Guardem la pà gina per si hem fet una consulta nova $this->DATAF = mktime(0, 0, 0, date('m', $this->DATAI) + 3, date('d', $this->DATAI), date('Y', $this->DATAI)); //La data final sempre és 3 mesos superior a la inicial switch ($this->accio) { //Consulta inicial del calendari sense prèmer cap dia, només amb un factor de cerca case 'C': $this->getUser()->addLogAction('inside', 'gActivitats'); $HORARIS = HorarisPeer::getActivitats(null, $this->CERCA['text'], $this->DATAI, $this->DATAF, null, $this->IDS); if ($this->CERCA['text'] != "") { $this->ACTIVITATS = $HORARIS['ACTIVITATS']; } else { $this->ACTIVITATS = array(); } $this->CALENDARI = $HORARIS['CALENDARI']; $this->MODE['CONSULTA'] = true; $this->MODE['LLISTAT'] = true; break; break; //Consulta que em mostra les activitats quan canvio de mensualitat o any //Consulta que em mostra les activitats quan canvio de mensualitat o any case 'CC': $HORARIS = HorarisPeer::getActivitats(null, $this->CERCA['text'], $this->DATAI, $this->DATAF, null, $this->IDS); //$this->ACTIVITATS = $HORARIS['ACTIVITATS']; $this->ACTIVITATS = array(); $this->CALENDARI = $HORARIS['CALENDARI']; $this->MODE['CONSULTA'] = true; $this->MODE['LLISTAT'] = true; break; //Consulta que em mostra les activitats d'un dia seleccionat del calendari //Consulta que em mostra les activitats d'un dia seleccionat del calendari case 'CD': $HORARIS = HorarisPeer::getActivitats($this->DIA, $this->CERCA['text'], null, null, null, $this->IDS); $this->ACTIVITATS = $HORARIS['ACTIVITATS']; $this->CALENDARI = $HORARIS['CALENDARI']; $this->MODE['CONSULTA'] = true; $this->MODE['LLISTAT'] = true; break; //Entrem les activitats... que necessitem //Entrem les activitats... que necessitem case 'ACTIVITAT': $this->IDA = $request->getParameter('IDA'); //Carrego l'activitat i també les relacionades del cicle... si n'hi ha. $OA = ActivitatsPeer::retrieveByPK($this->IDA); if ($OA instanceof Activitats) { $OC = $OA->getCicles(); $idC = 0; if ($OC instanceof Cicles) { $idC = $OC->getCicleid(); } $FA = ActivitatsPeer::initialize($this->IDA, $idC, $this->IDS); //Si l'activitat té un cicle, carreguem les activitats relacionades $L_OA_REL = array(); $this->N = CiclesPeer::getActivitatsCicle($idC, $this->IDS); //Carreguem el formulari de preus $LOH = $OA->getHorarisActius($this->IDS); //Carreguem els horaris actius de l'activitat. $this->FPREUS = array(); if ($OC instanceof Cicles && $this->N < 50) { $L_OA_REL = CiclesPeer::getActivitatsCicleList($idC, $this->IDS); } $this->OC = $OC; $this->OA = $OA; $this->L_OA_REL = $L_OA_REL; $this->FA = $FA; $this->MODE['ACTIVITAT_CICLE'] = true; //Si no hi ha l'activitat, vol dir que és nova... } else { $FA = ActivitatsPeer::initialize(0, 0, $this->IDS); $L_OA_REL = array(); $this->N = 0; $this->OC = null; $this->OA = $FA->getObject(); $this->L_OA_REL = $L_OA_REL; $this->FA = $FA; $this->MODE['ACTIVITAT_CICLE'] = true; } break; //Guardem l'activitat //Guardem l'activitat case 'ACTIVITAT_SAVE': $RP = $request->getParameter('activitats'); $this->IDA = $RP['ActivitatID']; $this->IDC = $RP['Cicles_CicleID']; $this->FActivitat = ActivitatsPeer::initialize($this->IDA, $this->IDC, $this->IDS); $this->FActivitat->bind($RP); if ($this->FActivitat->isValid()) { $nova = $this->FActivitat->isNew(); $this->FActivitat->save(); $this->getUser()->addLogAction($this->accio, 'gActivitats', $this->FActivitat->getObject()); $this->IDA = $this->FActivitat->getObject()->getActivitatid(); if ($RP['ActivitatID'] > 0) { myUser::addLogTimeline('alta', 'activitats', $this->getUser()->getSessionPar('idU'), $this->IDS, $this->FActivitat->getObject()->getActivitatid()); } myUser::addLogTimeline('modificació', 'activitats', $this->getUser()->getSessionPar('idU'), $this->IDS, $this->FActivitat->getObject()->getActivitatid()); $this->redirect('gestio/gActivitats?accio=ACTIVITAT&IDA=' . $this->IDA); } else { $this->MISSATGE = "HI HA HAGUT ALGUN PROBLEMA CREANT L'ACTIVITAT."; } break; //Esborrem una activitat //Esborrem una activitat case 'ACTIVITAT_DELETE': $RP = $request->getParameter('activitats'); $this->IDA = $RP['ActivitatID']; $this->IDC = $RP['Cicles_CicleID']; $this->FActivitat = ActivitatsPeer::initialize($this->IDA, $this->IDC, $this->IDS); $OA = $this->FActivitat->getObject(); if ($OA instanceof Activitats) { $this->getUser()->addLogAction($this->accio, 'gActivitats', $OA); myUser::addLogTimeline('baixa', 'activitats', $this->getUser()->getSessionPar('idU'), $this->IDS, $RP['ActivitatID']); $OA->setInactiu(); $this->redirect('gestio/gActivitats?accio=CC'); } break; //Crida AJAX per carregar un horari //Crida AJAX per carregar un horari case 'HORARI': $idH = $request->getParameter('idH'); $idA = $request->getParameter('idA'); $OH = HorarisPeer::retrieveByPK($idH); if ($OH instanceof Horaris) { return $this->renderPartial('formHorari', array("OH" => $OH)); } else { return $this->renderPartial('formHorari', array("OH" => HorarisPeer::initialize($idH, $idA, $this->IDS)->getObject())); } break; //Crida per AJAX que emmagatzema els horaris i fa les comprovacions pertinents //Crida per AJAX que emmagatzema els horaris i fa les comprovacions pertinents case 'HORARI_SAVE': //Carreguem els paràmetres a la variable enviats per ajax. parse_str($request->getParameter('FORMULARI'), $RP); $ERRORS = array(); $IDA = $RP['horaris']['Activitats_ActivitatID']; $IDH = $RP['horaris']['HorarisID']; //Comprovem si existeix l'activitat... si no existeix li diem que primer l'han de guardar. $OA = ActivitatsPeer::retrieveByPK($IDA); //Si no podem carregar l'activitat, mostrem un error... if (!$OA instanceof Activitats) { $ERRORS['OA'] = 'ERROR: ABANS DE CREAR UN HORARI HAS DE GUARDAR L\'ACTIVITAT.'; return $this->renderText(implode('<br />', $ERRORS)); //Hem pogut carregar l'activitat relacionada i podem donar d'alta l'horari. } else { //Carreguem l'Horari que s'ha entrat... o en creem un de nou. $OH = HorarisPeer::retrieveByPK($IDH); if ($OH instanceof Horaris) { $FHorari = new HorarisForm($OHorari); } else { $FHorari = new HorarisForm(); } //Fem un bind de les dades generals per si hi ha un error $FHorari->bind($RP); //Creem la variable EXTRES $EXTRES = array('ESPAISOUT' => array(), 'MATERIALOUT' => array()); //Guardem a extres els espais que volem reservar de la nostra entitat $EXTRES['ESPAISOUT'] = $RP['espais']; //Comprovem l'existència del material i el guardem en format de save foreach ($RP['material'] as $M => $idM) { $OM = MaterialPeer::retrieveByPK($idM); if ($OM instanceof Material) { $EXTRES['MATERIALOUT'][] = array('material' => $idM, 'generic' => $OM->getMaterialgenericIdmaterialgeneric()); } } //Tractem els espais externs, i el guardem si n'hi ha algun. $EXTRES['ESPAIEXTERN'] = EspaisExternsPeer::initialize($RP['espais_externs']); if ($RP_EE['espais_externs']['Poble'] > 0) { $EXTRES['ESPAIEXTERN']->bind($RP['espais_externs']); if (!$EXTRES['ESPAIEXTERN']->isValid()) { $ERRORS['EE'] = "ERROR: HI HA ALGUN ERROR EN L'ESPAI EXTERN."; } else { $EXTRES['ESPAIEXTERN']->save(); } } //Si no hi ha cap error, passem a guardar. if (empty($ERRORS)) { $ERRORS = HorarisPeer::GuardaHorari($RP['horaris'], $EXTRES, $this->IDS); } //Si no hi ha hagut cap error, ho guardem al log com un canvi en l'horari if (empty($ERRORS)) { $this->getUser()->addLogAction('HORARI_SAVE', 'gActivitats', $FHorari->getObject()); if ($RP['horaris']['HorarisID'] > 0) { myUser::addLogTimeline('modificació', 'horaris', $this->getUser()->getSessionPar('idU'), $this->IDS, $IDA); } else { myUser::addLogTimeline('alta', 'horaris', $this->getUser()->getSessionPar('idU'), $this->IDS, $IDA); } return $this->renderText(implode("\n", $ERRORS)); //Hem d'informar que ha anat tot bé. } else { //Hem d'informar que hi ha hagut algun error return $this->renderText(implode("\n", $ERRORS)); } } break; //Funció AJAX que esborra un horari determinat. //Funció AJAX que esborra un horari determinat. case 'HORARI_DELETE': //Llegim el que s'envia per ajax. parse_str($request->getParameter('FORMULARI'), $RP); $OH = HorarisPeer::retrieveByPK($RP['horaris']['HorarisID']); if ($OH instanceof Horaris) { $this->getUser()->addLogAction($this->accio, 'gActivitats', $OH); myUser::addLogTimeline('baixa', 'horaris', $this->getUser()->getSessionPar('idU'), $this->IDS, $RP['horaris']['Activitats_ActivitatID']); $OH->setInactiu(); return $this->renderText(""); } else { return $this->renderText("ERROR: No s'ha trobat l'horari. "); } break; /* case 'DESCRIPCIO': $this->CarregaActivitats($request,false); $this->FActivitat = ActivitatsPeer::initializeDescription($this->IDA,$this->IDS); $this->MODE['DESCRIPCIO'] = true; break; */ /* case 'DESCRIPCIO': $this->CarregaActivitats($request,false); $this->FActivitat = ActivitatsPeer::initializeDescription($this->IDA,$this->IDS); $this->MODE['DESCRIPCIO'] = true; break; */ case 'DESCRIPCIO_SAVE': parse_str($request->getParameter('FORMULARI'), $RP); $RP = $RP['activitats']; $this->IDA = $RP['ActivitatID']; $this->FActivitat = ActivitatsPeer::initializeDescription($this->IDA, $this->IDS); $this->FActivitat->bind($RP); if ($this->FActivitat->isValid()) { $this->FActivitat->save(); $this->getUser()->addLogAction($this->accio, 'gActivitats', $this->FActivitat->getObject()); return $this->renderText(''); } else { return $this->renderText('ERROR: No s\'ha trobat la descripció.'); } break; case 'GENERA_NOTICIA': $RP = $request->getParameter('activitats'); $this->IDA = $RP['ActivitatID']; $ONoticia = NoticiesPeer::getNoticiaActivitat($this->IDA, $this->IDS); $this->redirect('gestio/gNoticies?accio=E&idn=' . $ONoticia->getIdnoticia()); break; case 'PREUS': parse_str($request->getParameter('FORMULARI'), $RP); $RP = $RP['entrades_preus']; $ERRORS = array(); if ($request->hasParameter('FORMULARI')) { $FEP = EntradesPreusPeer::initialize($this->IDS, $RP['horari_id']); $FEP->bind($RP); if ($FEP->isValid()) { $FEP->save(); return $this->renderText(''); } else { $A = array(); foreach ($FEP as $E) { if ($E->hasError()) { $A[] = 'ERROR a ' . $E->getName() . ' >> ' . $E->getError(); } } return $this->renderText(json_encode($A)); } } else { $IDH = $request->getParameter('idH'); $this->FEP = EntradesPreusPeer::initialize($this->IDS, $IDH); return $this->renderPartial('formPreus', array('FEP' => $this->FEP)); } break; //Des d'un horari, creem una activitat nova amb les mateixes dades. Ja està entrat l'error a dalt. //Des d'un horari, creem una activitat nova amb les mateixes dades. Ja està entrat l'error a dalt. case 'DESDOBLAR': $IDH = $request->getParameter('IDH'); $OH = HorarisPeer::retrieveByPK($IDH); if (!$OH instanceof Horaris) { $this->redirect("gestio/gActivitats?accio=ERROR_GREU&ERROR=HORARI_NO_EXISTEIX"); } //Carreguem l'activitat i en fem una de nova. $OA = ActivitatsPeer::retrieveByPK($OH->getActivitatsActivitatid()); if (!$OA instanceof Activitats) { $this->redirect("gestio/gActivitats?accio=ERROR_GREU&ERROR=ACTIVITAT_NO_EXISTEIX"); } //Comprovem que tingui algun altre horari, sinó donem error. $NH = $OA->countHorarisActius($this->IDS); if ($NH <= 1) { $this->redirect("gestio/gActivitats?accio=HORARI&IDA={$OA->getActivitatid()}&IDH={$OH->getHorarisid()}&ERROR=NO_HI_HA_MES_HORARIS"); } $NOVA_ACTIVITAT = $OA->copy(); $NOVA_ACTIVITAT->save(); $OH->setActivitatsActivitatid($NOVA_ACTIVITAT->getActivitatid()); $OH->save(); $this->redirect("gestio/gActivitats?accio=ACTIVITAT&IDA={$NOVA_ACTIVITAT->getActivitatid()}"); break; //Mostra un error greu on apareix només el missatge //Mostra un error greu on apareix només el missatge case 'ERROR_GREU': $this->MODE['ERROR_GREU'] = true; break; } }
public function getEspaiExternForm() { if ($this->hasEspaiExtern()) { $LEE = EspaisExternsPeer::criteriaHorari_EspaiExtern($this->getHorarisid(), new Criteria(), $this->getSiteId()); return EspaisExternsPeer::initialize($LEE[0]->getIdespaiextern()); } else { return EspaisExternsPeer::initialize(null); } }
/** * 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(EspaisExternsPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(EspaisExternsPeer::DATABASE_NAME); $criteria->add(EspaisExternsPeer::IDESPAIEXTERN, $pks, Criteria::IN); $objs = EspaisExternsPeer::doSelect($criteria, $con); } return $objs; }
/** * 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 = EspaisExternsPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setIdespaiextern($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setPoble($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setNom($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setAdreca($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setContacte($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setActiu($arr[$keys[5]]); } }
/** * 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 = PoblacionsPeer::doSelect($criteria, $con); foreach ($objects as $obj) { // delete related EspaisExterns objects $criteria = new Criteria(EspaisExternsPeer::DATABASE_NAME); $criteria->add(EspaisExternsPeer::POBLE, $obj->getIdpoblacio()); $affectedRows += EspaisExternsPeer::doDelete($criteria, $con); } return $affectedRows; }
/** * Selects a collection of Horarisespais objects pre-filled with all related objects except Horaris. * * @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 Horarisespais objects. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doSelectJoinAllExceptHoraris(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); } HorarisespaisPeer::addSelectColumns($criteria); $startcol2 = HorarisespaisPeer::NUM_COLUMNS - HorarisespaisPeer::NUM_LAZY_LOAD_COLUMNS; MaterialPeer::addSelectColumns($criteria); $startcol3 = $startcol2 + (MaterialPeer::NUM_COLUMNS - MaterialPeer::NUM_LAZY_LOAD_COLUMNS); EspaisPeer::addSelectColumns($criteria); $startcol4 = $startcol3 + (EspaisPeer::NUM_COLUMNS - EspaisPeer::NUM_LAZY_LOAD_COLUMNS); EspaisExternsPeer::addSelectColumns($criteria); $startcol5 = $startcol4 + (EspaisExternsPeer::NUM_COLUMNS - EspaisExternsPeer::NUM_LAZY_LOAD_COLUMNS); $criteria->addJoin(HorarisespaisPeer::MATERIAL_IDMATERIAL, MaterialPeer::IDMATERIAL, $join_behavior); $criteria->addJoin(HorarisespaisPeer::ESPAIS_ESPAIID, EspaisPeer::ESPAIID, $join_behavior); $criteria->addJoin(HorarisespaisPeer::IDESPAIEXTERN, EspaisExternsPeer::IDESPAIEXTERN, $join_behavior); // symfony_behaviors behavior foreach (sfMixer::getCallables(self::getMixerPreSelectHook(__FUNCTION__)) as $sf_hook) { call_user_func($sf_hook, 'BaseHorarisespaisPeer', $criteria, $con); } $stmt = BasePeer::doSelect($criteria, $con); $results = array(); while ($row = $stmt->fetch(PDO::FETCH_NUM)) { $key1 = HorarisespaisPeer::getPrimaryKeyHashFromRow($row, 0); if (null !== ($obj1 = HorarisespaisPeer::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 = HorarisespaisPeer::getOMClass(false); $obj1 = new $cls(); $obj1->hydrate($row); HorarisespaisPeer::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 (Horarisespais) to the collection in $obj2 (Material) $obj2->addHorarisespais($obj1); } // if joined row is not null // Add objects for joined Espais rows $key3 = EspaisPeer::getPrimaryKeyHashFromRow($row, $startcol3); if ($key3 !== null) { $obj3 = EspaisPeer::getInstanceFromPool($key3); if (!$obj3) { $cls = EspaisPeer::getOMClass(false); $obj3 = new $cls(); $obj3->hydrate($row, $startcol3); EspaisPeer::addInstanceToPool($obj3, $key3); } // if $obj3 already loaded // Add the $obj1 (Horarisespais) to the collection in $obj3 (Espais) $obj3->addHorarisespais($obj1); } // if joined row is not null // Add objects for joined EspaisExterns rows $key4 = EspaisExternsPeer::getPrimaryKeyHashFromRow($row, $startcol4); if ($key4 !== null) { $obj4 = EspaisExternsPeer::getInstanceFromPool($key4); if (!$obj4) { $cls = EspaisExternsPeer::getOMClass(false); $obj4 = new $cls(); $obj4->hydrate($row, $startcol4); EspaisExternsPeer::addInstanceToPool($obj4, $key4); } // if $obj4 already loaded // Add the $obj1 (Horarisespais) to the collection in $obj4 (EspaisExterns) $obj4->addHorarisespais($obj1); } // if joined row is not null $results[] = $obj1; } $stmt->closeCursor(); return $results; }
public function executeGActivitats(sfWebRequest $request) { $this->setLayout('gestio'); $this->IDS = $this->getUser()->getSessionPar('idS'); //Netegem cerca if ($request->getParameter('accio') == 'C') { $this->CERCA = $this->getUser()->setSessionPar('cerca', array('text' => '')); $this->PAGINA = $this->getUser()->setSessionPar('pagina', 1); $this->DATAI = $this->getUser()->setSessionPar('DATAI', time()); } $this->CERCA = $this->getUser()->ParReqSesForm($request, 'cerca', array('text' => "")); $T = time(); $this->PAGINA = $request->getParameter('PAGINA', 1); $this->DATAI = $this->getUser()->ParReqSesForm($request, 'DATAI', $T); $this->DIA = $request->getParameter('DIA', time()); $this->IDA = $request->getParameter('IDA', 0); $this->accio = $request->getParameter('accio', 'C'); $this->ACTIVITAT_NOVA = false; //Inicialitzem el formulari de cerca $this->FCerca = new CercaForm(); if (isset($this->CERCA['text'])) { $this->FCerca->bind(array('text' => $this->CERCA['text'])); } else { $this->FCerca->bind(array('text' => '')); } //Inicialitzem variables $this->MODE = array(); if ($request->isMethod('POST')) { if ($request->hasParameter('BCERCA')) { $this->accio = 'C'; $this->PAGINA = 1; } elseif ($request->hasParameter('BNOU')) { $this->accio = 'ACTIVITAT'; } elseif ($request->hasParameter('BCICLE')) { $this->accio = 'CICLE'; } elseif ($request->hasParameter('BCICLESAVE')) { $this->accio = 'CICLE_SAVE'; } elseif ($request->hasParameter('BACTIVITAT')) { $this->accio = 'ACTIVITAT'; } elseif ($request->hasParameter('BACTIVITATSAVE')) { $this->accio = 'ACTIVITAT_SAVE'; } elseif ($request->hasParameter('BACTIVITATDELETE')) { $this->accio = 'ACTIVITAT_DELETE'; } elseif ($request->hasParameter('BHORARI')) { $this->accio = 'HORARI'; } elseif ($request->hasParameter('BHORARISAVE')) { $this->accio = 'HORARI_SAVE'; } elseif ($request->hasParameter('BHORARIDELETE')) { $this->accio = 'HORARI_DELETE'; } elseif ($request->hasParameter('BDESCRIPCIO')) { $this->accio = 'DESCRIPCIO'; } elseif ($request->hasParameter('BDESCRIPCIOSAVE')) { $this->accio = 'DESCRIPCIO_SAVE'; } elseif ($request->hasParameter('BDESCRIPCIODELETE')) { $this->accio = 'DESCRIPCIO_DELETE'; } elseif ($request->hasParameter('BGENERANOTICIA')) { $this->accio = 'GENERA_NOTICIA'; } } //Quan cliquem per primer cop a qualsevol de les cerques, la pàgina es posa a 1 if ($request->getParameter('accio') == 'C') { $this->PAGINA = 1; } if ($request->getParameter('accio') == 'CD') { $this->PAGINA = 1; } if ($request->hasParameter('DATAI')) { $this->DIA = ""; } //Aquest petit bloc és per si es modifica amb un POST el que s'ha enviat per GET //$this->getUser()->setSessionPar('PAGINA',$this->PAGINA); //Guardem la pà gina per si hem fet una consulta nova $this->DATAF = mktime(0, 0, 0, date('m', $this->DATAI) + 3, date('d', $this->DATAI), date('Y', $this->DATAI)); //La data final sempre és 3 mesos superior a la inicial switch ($this->accio) { //Consulta inicial del calendari sense prèmer cap dia, només amb un factor de cerca case 'C': $this->getUser()->addLogAction('inside', 'gActivitats'); $HORARIS = HorarisPeer::getActivitats(null, $this->CERCA['text'], $this->DATAI, $this->DATAF, null, $this->IDS); if ($this->CERCA['text'] != "") { $this->ACTIVITATS = $HORARIS['ACTIVITATS']; } else { $this->ACTIVITATS = array(); } $this->CALENDARI = $HORARIS['CALENDARI']; $this->MODE['CONSULTA'] = true; $this->MODE['LLISTAT'] = true; break; break; //Consulta que em mostra les activitats quan canvio de mensualitat o any //Consulta que em mostra les activitats quan canvio de mensualitat o any case 'CC': $HORARIS = HorarisPeer::getActivitats(null, $this->CERCA['text'], $this->DATAI, $this->DATAF, null, $this->IDS); //$this->ACTIVITATS = $HORARIS['ACTIVITATS']; $this->ACTIVITATS = array(); $this->CALENDARI = $HORARIS['CALENDARI']; $this->MODE['CONSULTA'] = true; $this->MODE['LLISTAT'] = true; break; //Consulta que em mostra les activitats d'un dia seleccionat del calendari //Consulta que em mostra les activitats d'un dia seleccionat del calendari case 'CD': $HORARIS = HorarisPeer::getActivitats($this->DIA, $this->CERCA['text'], null, null, null, $this->IDS); $this->ACTIVITATS = $HORARIS['ACTIVITATS']; $this->CALENDARI = $HORARIS['CALENDARI']; $this->MODE['CONSULTA'] = true; $this->MODE['LLISTAT'] = true; break; //Entrem les activitats... que necessitem //Entrem les activitats... que necessitem case 'ACTIVITAT': $this->CarregaActivitats($request, $request->getParameter('form', true)); $this->MODE['ACTIVITAT_EDIT'] = true; break; case 'ACTIVITAT_NO_EDIT': $this->CarregaActivitats($request, $request->getParameter('form', true)); break; //Guardem l'activitat //Guardem l'activitat case 'ACTIVITAT_SAVE': $RP = $request->getParameter('activitats'); $this->IDA = $RP['ActivitatID']; $this->IDC = $RP['Cicles_CicleID']; $this->FActivitat = ActivitatsPeer::initialize($this->IDA, $this->IDC, $this->IDS); $this->FActivitat->bind($request->getParameter('activitats')); if ($this->FActivitat->isValid()) { $nova = $this->FActivitat->isNew(); $this->FActivitat->save(); $this->getUser()->addLogAction($this->accio, 'gActivitats', $this->FActivitat->getObject()); $this->IDA = $this->FActivitat->getObject()->getActivitatid(); if ($nova) { $this->redirect('gestio/gActivitats?accio=HORARI&IDA=' . $this->IDA . '&nou=' . $this->IDA); } else { $this->redirect('gestio/gActivitats?accio=ACTIVITAT&IDA=' . $this->IDA); } } else { $this->CarregaActivitats($request, $request->getParameter('form', true)); } break; //Esborrem una activitat //Esborrem una activitat case 'ACTIVITAT_DELETE': $RP = $request->getParameter('activitats'); $this->IDA = $RP['ActivitatID']; $this->IDC = $RP['Cicles_CicleID']; $this->FActivitat = ActivitatsPeer::initialize($this->IDA, $this->IDC, $this->IDS); $OA = $this->FActivitat->getObject(); if ($OA instanceof Activitats) { $this->getUser()->addLogAction($this->accio, 'gActivitats', $OA); $OA->setInactiu(); $this->redirect('gestio/gActivitats?accio=CC'); } break; //Entrem els horaris de les activitats //Entrem els horaris de les activitats case 'HORARI': $this->CarregaActivitats($request, false); $OActivitat = ActivitatsPeer::retrieveByPK($this->IDA); $this->HORARIS = $OActivitat->getHorarisActius($this->IDS); $this->NOMACTIVITAT = $OActivitat->getNom(); $OHorari = new Horaris(); $OHorari->setActivitatsActivitatid($this->IDA); if ($request->hasParameter('nou')) { $this->FHorari = new HorarisForm($OHorari); } $this->HORARI = $OHorari; $this->EXTRES = array('ESPAISOUT' => array(), 'MATERIALOUT' => array(), 'ESPAIEXTERN' => EspaisExternsPeer::initialize(null)); $this->getUser()->setSessionPar('IDH', 0); if ($request->hasParameter('IDH')) { $H = HorarisPeer::retrieveByPK($request->getParameter('IDH')); $this->getUser()->setSessionPar('IDH', $request->getParameter('IDH')); $this->FHorari = new HorarisForm($H); $this->HORARI = $H; $this->EXTRES['ESPAISOUT'] = $H->getArrayHorarisEspaisActiusAgrupats(); $this->EXTRES['MATERIALOUT'] = $H->getArrayHorarisEspaisMaterial(); $this->EXTRES['ESPAIEXTERN'] = $H->getEspaiExternForm(); } $this->MODE['HORARI'] = true; break; case 'HORARI_SAVE': $RP = $request->getParameter('horaris'); $this->IDA = $RP['Activitats_ActivitatID']; $this->IDH = $RP['HorarisID']; $OActivitat = ActivitatsPeer::retrieveByPK($this->IDA); $this->NOMACTIVITAT = $OActivitat->getNom(); $this->HORARIS = $OActivitat->getHorarisActius($this->IDS); $OHorari = HorarisPeer::retrieveByPK($this->IDH); if ($this->IDH == 0) { $this->FHorari = new HorarisForm(); } else { $this->FHorari = new HorarisForm($OHorari); } //Fem un bind de les dades generals per si hi ha un error $this->FHorari->bind($RP); //Creem la variable EXTRES $this->EXTRES = array('ESPAISOUT' => array(), 'MATERIALOUT' => array()); //Guardem a extres el material que volem reservar. foreach ($request->getParameter('material', array()) as $M => $idM) { $OM = MaterialPeer::retrieveByPK($idM); if ($OM instanceof Material) { $this->EXTRES['MATERIALOUT'][] = array('material' => $idM, 'generic' => $OM->getMaterialgenericIdmaterialgeneric()); } } //Guardem a extres els espais que volem reservar de la nostra entitat $this->EXTRES['ESPAISOUT'] = $request->getParameter('espais', array()); //Tractem els espais externs, si n'hi ha algun. $RPEE = $request->getParameter('espais_externs', null); $this->EXTRES['ESPAIEXTERN'] = EspaisExternsPeer::initialize($RPEE['idEspaiextern']); if ($RPEE['Poble'] > 0) { $this->EXTRES['ESPAIEXTERN']->bind($RPEE); $RET = array(); if (!$this->EXTRES['ESPAIEXTERN']->isValid()) { $RET = array('Hi ha algun error a la localització externa.'); } else { $this->EXTRES['ESPAIEXTERN']->save(); } } if (empty($RET)) { $RET = $this->GuardaHorari($request->getParameter('horaris'), $this->EXTRES, $this->IDS, $this->MISSATGE); } if (empty($RET)) { $this->getUser()->addLogAction($this->accio, 'gActivitats', $this->FHorari->getObject()); $this->MISSATGE = array(1 => 'Horari guardat correctament'); $this->redirect('gestio/gActivitats?accio=HORARI&IDA=' . $this->IDA); } else { $this->MISSATGE = $RET; } $this->CarregaActivitats($request, false); $this->MODE['HORARI'] = true; break; case 'HORARI_DELETE': $RH = $request->getParameter('horaris'); $OH = HorarisPeer::retrieveByPK($RH['HorarisID']); if ($OH instanceof Horaris) { $this->getUser()->addLogAction($this->accio, 'gActivitats', $OH); $OH->setInactiu(); } $this->redirect('gestio/gActivitats?accio=HORARI&IDA=' . $RH['Activitats_ActivitatID']); break; case 'DESCRIPCIO': $this->CarregaActivitats($request, false); $this->FActivitat = ActivitatsPeer::initializeDescription($this->IDA, $this->IDS); $this->MODE['DESCRIPCIO'] = true; break; case 'DESCRIPCIO_SAVE': $RP = $request->getParameter('activitats'); $this->IDA = $RP['ActivitatID']; $this->CarregaActivitats($request, false); $this->FActivitat = ActivitatsPeer::initializeDescription($this->IDA, $this->IDS); $this->FActivitat->bind($RP, $request->getFiles('activitats')); if ($this->FActivitat->isValid()) { $this->FActivitat->save(); $this->getUser()->addLogAction($this->accio, 'gActivitats', $this->FActivitat->getObject()); $this->redirect('gestio/gActivitats?accio=ACTIVITAT_NO_EDIT&IDA=' . $this->IDA); } $THIS->MODE['DESCRIPCIO'] = true; break; case 'GENERA_NOTICIA': $RP = $request->getParameter('activitats'); $this->IDA = $RP['ActivitatID']; $ONoticia = NoticiesPeer::getNoticiaActivitat($this->IDA, $this->IDS); $this->redirect('gestio/gNoticies?accio=E&idn=' . $ONoticia->getIdnoticia()); break; } }
/** * Returns the number of related EspaisExterns objects. * * @param Criteria $criteria * @param boolean $distinct * @param PropelPDO $con * @return int Count of related EspaisExterns objects. * @throws PropelException */ public function countEspaisExternss(Criteria $criteria = null, $distinct = false, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(PoblacionsPeer::DATABASE_NAME); } else { $criteria = clone $criteria; } if ($distinct) { $criteria->setDistinct(); } $count = null; if ($this->collEspaisExternss === null) { if ($this->isNew()) { $count = 0; } else { $criteria->add(EspaisExternsPeer::POBLE, $this->idpoblacio); $count = EspaisExternsPeer::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(EspaisExternsPeer::POBLE, $this->idpoblacio); if (!isset($this->lastEspaisExternsCriteria) || !$this->lastEspaisExternsCriteria->equals($criteria)) { $count = EspaisExternsPeer::doCount($criteria, false, $con); } else { $count = count($this->collEspaisExternss); } } else { $count = count($this->collEspaisExternss); } } return $count; }
/** * Get the associated EspaisExterns object * * @param PropelPDO Optional Connection object. * @return EspaisExterns The associated EspaisExterns object. * @throws PropelException */ public function getEspaisExterns(PropelPDO $con = null) { if ($this->aEspaisExterns === null && $this->idespaiextern !== null) { $this->aEspaisExterns = EspaisExternsPeer::retrieveByPk($this->idespaiextern); /* 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->aEspaisExterns->addHorarisespaiss($this); */ } return $this->aEspaisExterns; }