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 />";
