function initLieuEtab(){ $lieu_etab=AbsenceEleveLieuQuery::create()->filterByNom("Etablissement")->findOne(); if(is_null($lieu_etab)){ $lieu_etab= new AbsenceEleveLieu(); $lieu_etab->setNom("Etablissement"); $lieu_etab->setCommentaire("L'élève est dans l'enceinte de l'établissement"); $lieu_etab->save(); } return($lieu_etab->getId()); }
/** * Performs the work of inserting or updating the row in the database. * * If the object is new, it inserts it; otherwise an update is performed. * All related objects are also updated in this method. * * @param PropelPDO $con * @return int The number of rows affected by this insert/update and any referring fk objects' save() operations. * @throws PropelException * @see save() */ protected function doSave(PropelPDO $con) { $affectedRows = 0; // initialize var to track total num of affected rows if (!$this->alreadyInSave) { $this->alreadyInSave = true; // We call the save method on the following object(s) if they // were passed to this object by their coresponding set // method. This object relates to these object(s) by a // foreign key reference. if ($this->aUtilisateurProfessionnel !== null) { if ($this->aUtilisateurProfessionnel->isModified() || $this->aUtilisateurProfessionnel->isNew()) { $affectedRows += $this->aUtilisateurProfessionnel->save($con); } $this->setUtilisateurProfessionnel($this->aUtilisateurProfessionnel); } if ($this->aEleve !== null) { if ($this->aEleve->isModified() || $this->aEleve->isNew()) { $affectedRows += $this->aEleve->save($con); } $this->setEleve($this->aEleve); } if ($this->aEdtCreneau !== null) { if ($this->aEdtCreneau->isModified() || $this->aEdtCreneau->isNew()) { $affectedRows += $this->aEdtCreneau->save($con); } $this->setEdtCreneau($this->aEdtCreneau); } if ($this->aEdtEmplacementCours !== null) { if ($this->aEdtEmplacementCours->isModified() || $this->aEdtEmplacementCours->isNew()) { $affectedRows += $this->aEdtEmplacementCours->save($con); } $this->setEdtEmplacementCours($this->aEdtEmplacementCours); } if ($this->aGroupe !== null) { if ($this->aGroupe->isModified() || $this->aGroupe->isNew()) { $affectedRows += $this->aGroupe->save($con); } $this->setGroupe($this->aGroupe); } if ($this->aClasse !== null) { if ($this->aClasse->isModified() || $this->aClasse->isNew()) { $affectedRows += $this->aClasse->save($con); } $this->setClasse($this->aClasse); } if ($this->aAidDetails !== null) { if ($this->aAidDetails->isModified() || $this->aAidDetails->isNew()) { $affectedRows += $this->aAidDetails->save($con); } $this->setAidDetails($this->aAidDetails); } if ($this->aAbsenceEleveLieu !== null) { if ($this->aAbsenceEleveLieu->isModified() || $this->aAbsenceEleveLieu->isNew()) { $affectedRows += $this->aAbsenceEleveLieu->save($con); } $this->setAbsenceEleveLieu($this->aAbsenceEleveLieu); } if ($this->isNew() || $this->isModified()) { // persist changes if ($this->isNew()) { $this->doInsert($con); } else { $this->doUpdate($con); } $affectedRows += 1; $this->resetModified(); } if ($this->absenceEleveTraitementsScheduledForDeletion !== null) { if (!$this->absenceEleveTraitementsScheduledForDeletion->isEmpty()) { JTraitementSaisieEleveQuery::create() ->filterByPrimaryKeys($this->absenceEleveTraitementsScheduledForDeletion->getPrimaryKeys(false)) ->delete($con); $this->absenceEleveTraitementsScheduledForDeletion = null; } foreach ($this->getAbsenceEleveTraitements() as $absenceEleveTraitement) { if ($absenceEleveTraitement->isModified()) { $absenceEleveTraitement->save($con); } } } if ($this->jTraitementSaisieElevesScheduledForDeletion !== null) { if (!$this->jTraitementSaisieElevesScheduledForDeletion->isEmpty()) { JTraitementSaisieEleveQuery::create() ->filterByPrimaryKeys($this->jTraitementSaisieElevesScheduledForDeletion->getPrimaryKeys(false)) ->delete($con); $this->jTraitementSaisieElevesScheduledForDeletion = null; } } if ($this->collJTraitementSaisieEleves !== null) { foreach ($this->collJTraitementSaisieEleves as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->absenceEleveSaisieVersionsScheduledForDeletion !== null) { if (!$this->absenceEleveSaisieVersionsScheduledForDeletion->isEmpty()) { AbsenceEleveSaisieVersionQuery::create() ->filterByPrimaryKeys($this->absenceEleveSaisieVersionsScheduledForDeletion->getPrimaryKeys(false)) ->delete($con); $this->absenceEleveSaisieVersionsScheduledForDeletion = null; } } if ($this->collAbsenceEleveSaisieVersions !== null) { foreach ($this->collAbsenceEleveSaisieVersions as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } $this->alreadyInSave = false; } return $affectedRows; } // doSave()
/** * Performs the work of inserting or updating the row in the database. * * If the object is new, it inserts it; otherwise an update is performed. * All related objects are also updated in this method. * * @param PropelPDO $con * @return int The number of rows affected by this insert/update and any referring fk objects' save() operations. * @throws PropelException * @see save() */ protected function doSave(PropelPDO $con) { $affectedRows = 0; // initialize var to track total num of affected rows if (!$this->alreadyInSave) { $this->alreadyInSave = true; // We call the save method on the following object(s) if they // were passed to this object by their coresponding set // method. This object relates to these object(s) by a // foreign key reference. if ($this->aAbsenceEleveLieu !== null) { if ($this->aAbsenceEleveLieu->isModified() || $this->aAbsenceEleveLieu->isNew()) { $affectedRows += $this->aAbsenceEleveLieu->save($con); } $this->setAbsenceEleveLieu($this->aAbsenceEleveLieu); } if ($this->isNew() || $this->isModified()) { // persist changes if ($this->isNew()) { $this->doInsert($con); } else { $this->doUpdate($con); } $affectedRows += 1; $this->resetModified(); } if ($this->absenceEleveTypeStatutAutorisesScheduledForDeletion !== null) { if (!$this->absenceEleveTypeStatutAutorisesScheduledForDeletion->isEmpty()) { AbsenceEleveTypeStatutAutoriseQuery::create() ->filterByPrimaryKeys($this->absenceEleveTypeStatutAutorisesScheduledForDeletion->getPrimaryKeys(false)) ->delete($con); $this->absenceEleveTypeStatutAutorisesScheduledForDeletion = null; } } if ($this->collAbsenceEleveTypeStatutAutorises !== null) { foreach ($this->collAbsenceEleveTypeStatutAutorises as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->absenceEleveTraitementsScheduledForDeletion !== null) { if (!$this->absenceEleveTraitementsScheduledForDeletion->isEmpty()) { AbsenceEleveTraitementQuery::create() ->filterByPrimaryKeys($this->absenceEleveTraitementsScheduledForDeletion->getPrimaryKeys(false)) ->delete($con); $this->absenceEleveTraitementsScheduledForDeletion = null; } } if ($this->collAbsenceEleveTraitements !== null) { foreach ($this->collAbsenceEleveTraitements as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } $this->alreadyInSave = false; } return $affectedRows; } // doSave()
/** * Exchange the rank of the object with the one passed as argument, and saves both objects * * @param AbsenceEleveLieu $object * @param PropelPDO $con optional connection * * @return AbsenceEleveLieu the current object * * @throws Exception if the database cannot execute the two updates */ public function swapWith($object, PropelPDO $con = null) { if ($con === null) { $con = Propel::getConnection(AbsenceEleveLieuPeer::DATABASE_NAME); } $con->beginTransaction(); try { $oldRank = $this->getSortableRank(); $newRank = $object->getSortableRank(); $this->setSortableRank($newRank); $this->save($con); $object->setSortableRank($oldRank); $object->save($con); $con->commit(); return $this; } catch (Exception $e) { $con->rollback(); throw $e; } }
$lieu->moveDown(); } } elseif ($action == 'ajouterdefaut') { check_token(); //include("function.php"); ajoutLieuxParDefaut(); } else { if ($nom_lieu != '') { check_token(); $lieu = AbsenceEleveLieuQuery::create()->findPk($id_lieu); if ($lieu == null) { $lieu = new AbsenceEleveLieu(); } $lieu->setNom(stripslashes($nom_lieu)); $lieu->setCommentaire(stripslashes($com_lieu)); $lieu->save(); } } if(isset($_GET['corriger'])) { check_token(); $table="a_lieux"; $sql="SELECT * FROM $table ORDER BY sortable_rank, nom;"; //echo "$sql<br />"; $res=mysqli_query($GLOBALS["mysqli"], $sql); $cpt=1; while($lig=mysqli_fetch_object($res)) { $sql="UPDATE $table SET sortable_rank='$cpt' WHERE id='$lig->id';"; //echo "$sql<br />";