Пример #1
0
function ajoutMotifsParDefaut() {
    $motif = new AbsenceEleveMotif();
    $motif->setNom("Médical");
    $motif->setCommentaire("L'élève est absent pour raison médicale");
    if (AbsenceEleveMotifQuery::create()->filterByNom($motif->getNom())->find()->isEmpty()) {
	$motif->save();
    }

    $motif = new AbsenceEleveMotif();
    $motif->setNom("Familial");
    $motif->setCommentaire("L'élève est absent pour raison familiale");
    if (AbsenceEleveMotifQuery::create()->filterByNom($motif->getNom())->find()->isEmpty()) {
	$motif->save();
    }

    $motif = new AbsenceEleveMotif();
    $motif->setNom("Sportive");
    $motif->setCommentaire("L'élève est absent pour cause de compétition sportive");
    if (AbsenceEleveMotifQuery::create()->filterByNom($motif->getNom())->find()->isEmpty()) {
	$motif->save();
    }
}
Пример #2
0
	/**
	 * 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->aAbsenceEleveType !== null) {
				if ($this->aAbsenceEleveType->isModified() || $this->aAbsenceEleveType->isNew()) {
					$affectedRows += $this->aAbsenceEleveType->save($con);
				}
				$this->setAbsenceEleveType($this->aAbsenceEleveType);
			}

			if ($this->aAbsenceEleveMotif !== null) {
				if ($this->aAbsenceEleveMotif->isModified() || $this->aAbsenceEleveMotif->isNew()) {
					$affectedRows += $this->aAbsenceEleveMotif->save($con);
				}
				$this->setAbsenceEleveMotif($this->aAbsenceEleveMotif);
			}

			if ($this->aAbsenceEleveJustification !== null) {
				if ($this->aAbsenceEleveJustification->isModified() || $this->aAbsenceEleveJustification->isNew()) {
					$affectedRows += $this->aAbsenceEleveJustification->save($con);
				}
				$this->setAbsenceEleveJustification($this->aAbsenceEleveJustification);
			}

			if ($this->aModifieParUtilisateur !== null) {
				if ($this->aModifieParUtilisateur->isModified() || $this->aModifieParUtilisateur->isNew()) {
					$affectedRows += $this->aModifieParUtilisateur->save($con);
				}
				$this->setModifieParUtilisateur($this->aModifieParUtilisateur);
			}

			if ($this->isNew() || $this->isModified()) {
				// persist changes
				if ($this->isNew()) {
					$this->doInsert($con);
				} else {
					$this->doUpdate($con);
				}
				$affectedRows += 1;
				$this->resetModified();
			}

			if ($this->absenceEleveSaisiesScheduledForDeletion !== null) {
				if (!$this->absenceEleveSaisiesScheduledForDeletion->isEmpty()) {
					JTraitementSaisieEleveQuery::create()
						->filterByPrimaryKeys($this->absenceEleveSaisiesScheduledForDeletion->getPrimaryKeys(false))
						->delete($con);
					$this->absenceEleveSaisiesScheduledForDeletion = null;
				}

				foreach ($this->getAbsenceEleveSaisies() as $absenceEleveSaisie) {
					if ($absenceEleveSaisie->isModified()) {
						$absenceEleveSaisie->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->absenceEleveNotificationsScheduledForDeletion !== null) {
				if (!$this->absenceEleveNotificationsScheduledForDeletion->isEmpty()) {
					AbsenceEleveNotificationQuery::create()
						->filterByPrimaryKeys($this->absenceEleveNotificationsScheduledForDeletion->getPrimaryKeys(false))
						->delete($con);
					$this->absenceEleveNotificationsScheduledForDeletion = null;
				}
			}

			if ($this->collAbsenceEleveNotifications !== null) {
				foreach ($this->collAbsenceEleveNotifications as $referrerFK) {
					if (!$referrerFK->isDeleted()) {
						$affectedRows += $referrerFK->save($con);
					}
				}
			}

			$this->alreadyInSave = false;

		}
		return $affectedRows;
	} // doSave()
Пример #3
0
	$motif->moveDown();
    }
} elseif ($action == 'ajouterdefaut') {
	check_token();
    //include("function.php");
    ajoutMotifsParDefaut();
} else {
    if ($nom_motif != '') {
		check_token();
		$motif = AbsenceEleveMotifQuery::create()->findPk($id_motif);
		if ($motif == null) {
			$motif = new AbsenceEleveMotif();
		}
		$motif->setNom(stripslashes($nom_motif));
		$motif->setCommentaire(stripslashes($com_motif));
		$motif->save();
    }
}

if(isset($_GET['corriger'])) {
	check_token();

	$table="a_motifs";

	$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 />";
Пример #4
0
	/**
	 * Exchange the rank of the object with the one passed as argument, and saves both objects
	 *
	 * @param     AbsenceEleveMotif $object
	 * @param     PropelPDO $con optional connection
	 *
	 * @return    AbsenceEleveMotif 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(AbsenceEleveMotifPeer::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;
		}
	}