public function update(){
$query = "UPDATE TYPE_EVALUATION SET ".
"libelleEvaluation = '".db_connect::escape_string($this->getLibelleTypeEvaluation())."'".
"WHERE idTypeEvaluation = ".$this->getIdTypeEvaluation();
if (db_connect::query($query))
return true;
return false;
}
public function update() {
$query = "UPDATE UTILISATEUR SET " .
" nomUtilisateur = '" . db_connect::escape_string(trim($this->getNomUtilisateur())) . "', " .
" prenomUtilisateur = '" . db_connect::escape_string(trim($this->getPrenomUtilisateur())) . "', " .
" adr1Utilisateur = '" . db_connect::escape_string(trim($this->getAdr1Utilisateur())) . "', " .
" adr2Utilisateur = '" . db_connect::escape_string(trim($this->getAdr2Utilisateur())) . "', " .
" cpUtilisateur = '" . db_connect::escape_string(trim($this->getCpUtilisateur())) . "', " .
" villeUtilisateur = '" . db_connect::escape_string(trim($this->getVilleUtilisateur())) . "', " .
" actifUtilisateur = " . ($this->getActifUtilisateur() ? 'true' : 'false') . ", " .
" mailUtilisateur = '" . db_connect::escape_string(trim($this->getMailUtilisateur())) . "', " .
" dateNaissanceUtilisateur = '" . db_connect::escape_string(trim($this->getDateNaissanceUtilisateur())) . "', " .
" dateInscriptionUtilisateur = '" . db_connect::escape_string(trim($this->getDateInscriptionUtilisateur())) . "'" .
" WHERE idUtilisateur = " . $this->getIdUtilisateur();
if (db_connect::query($query)) {
$connexion = Connexion::getById($this->getIdUtilisateur());
if (empty($connexion->getIdUtilisateur()))
$connexion->setIdUtilisateur($this->getIdUtilisateur());
$connexion->setLoginUtilisateur($this->getNomUtilisateur() . '.' . $this->getPrenomUtilisateur());
if (empty($connexion->getMdpUtilisateur()))
$connexion->setMdpUtilisateur('123Soleil');
return $connexion->update();
}
return FALSE;
}
public function update(){
$query = "UPDATE TRIMESTRE SET ".
"libelleTrimestre = '".db_connect::escape_string($this->getLibelleTrimestre())."', ".
"dateDebutTrimestre = '".$this->SQLdateDebutTrimestre()."', ".
"dateFinTrimestre = '".$this->SQLdateFinTrimestre()."', ".
"dateFinCommentaire = '".$this->SQLdateFinCommentaire()."'".
"WHERE idTrimestre = ".$this->getIdTrimestre();
if (db_connect::query($query))
return true;
return false;
}
public static function connecter($login, $mdp) {
$connexion = new Connexion();
$connexion->setLoginUtilisateur($login);
$connexion->setMdpUtilisateur($mdp);
$query = " SELECT c.* FROM CONNEXION c, UTILISATEUR u " .
" WHERE c.loginUtilisateur = '" . db_connect::escape_string($connexion->getLoginUtilisateur()) . "' " .
" AND c.mdpUtilisateur = '" . $connexion->getMdpUtilisateur() . "' " .
" AND c.idUtilisateur = u.idUtilisateur " .
" AND u.actifUtilisateur = 1 ";
$result = db_connect::query($query);
if ($result->num_rows != 1) {
return new connexion;
} else {
return $result->fetch_object('Connexion');
}
}
public function insert(){
$query = "INSERT INTO ABSENCE (idEleve, dateDebutAbsence, dateFinAbsence, etatAbsence, motifAbsence, dateRedaction, idRedacteur) VALUES (".
$this->getIdEleve().", '".$this->getDateDebutAbsence()."', '".$this->getDateFinAbsence()."', ".
($this->getEtatAbsence()?'TRUE':'FALSE').", '".db_connect::escape_string($this->getMotifAbsence())."', '".$this->getDateRedaction()."', ".$this->getIdRedacteur().
")";
if( db_connect::query($query)){
$query2 = "SELECT * FROM ABSENCE WHERE idEleve = ".$this->getIdEleve()." AND dateDebutAbsence = '".$this->getDateDebutAbsence()."' AND dateFinAbsence = '".$this->getDateFinAbsence()."' ".
"AND etatAbsence = ". ($this->getEtatAbsence()?'TRUE':'FALSE')." and motifAbsence = '".db_connect::escape_string($this->getMotifAbsence())."' AND dateRedaction = '".$this->getDateRedaction()."' AND idRedacteur = ".$this->getIdRedacteur();
$result = db_connect::query($query2);
if ($result->num_rows == 1){
$return = $result->fetch_object('Absence');
$this->setIdAbsence($return->getIdAbsence());
return true;
}
return false;
}
return false;
}
public function update()
{
$query = "UPDATE NIVEAU_CPT SET libelleNiveauCpt = '" . db_connect::escape_string($this->getLibelleNiveauCpt()) . "', codeNiveauCpt = '" . db_connect::escape_string($this->getCodeNiveauCpt()) . "' WHERE idNiveauCpt = " . $this->getIdNiveauCpt();
if (db_connect::query($query))
return TRUE;
return FALSE;
}
if (isset($_POST['noter'])){
if (isset($_POST['selectEval']) && !empty($_POST['selectEval']))
header('location: ../Intranet/affectNote.php?idEval='.$_POST['selectEval']);
}
if (isset($_POST['btAjouter'])) {
$evaluation = new Evaluation();
$evaluation->setDateEvaluation($_POST['addDate']);
$evaluation->setIdMatiereNiveau(MatiereNiveau::getByMatiereNiveau($_POST['addMatiere'], $_POST['addNiveau'])->getIdMatiereNiveau());
$evaluation->setIdTypeEvaluation($_POST['addType']);
$evaluation->setTitreEvaluation(db_connect::escape_string($_POST['addTitre']));
// echo $evaluation->getTitreEvaluation();
$evaluation->setMaxEvaluation($_POST['addMax']);
if ($evaluation->getIdTypeEvaluation() == 3)
$evaluation->setAutreEvaluation(db_connect::escape_string($_POST['autreEval']));
if ($evaluation->insert()){
$msgInsert = "<h4 style='color: green'>
L'ajout de l'évaluation a réussi.
</h4>";
}
else{
$msgInsert = "<h4 style='color: red'>
L'ajout de l'évaluation a échoué.
</h4>";
}
// tansfert du fichier Sujet associ�.
if (!empty($_FILES['fichierSujet'])) {
if (ftp_link::estPDFfile($_FILES['fichierSujet']['name'], $_FILES['fichierSujet']['type'])) {
public function update(){
$query = "UPDATE MODULE SET libelleModule = '".db_connect::escape_string($this->getLibelleModule())."' WHERE idModule = ".$this->getIdModule();
if (db_connect::query($query))
return true;
return false;
}
public function insert(){
$query = "INSERT INTO COMMUNICATION (".
"contenuCommunication, idRedacteur, dateRedaction"
.") VALUES (".
"'".db_connect::escape_string($this->getContenuCommunication())."', ".
$this->getIdRedacteur().", ".
"'".$this->getDateRedaction()."'"
.")";
if (db_connect::query($query)){
$query2 = "SELECT idCommunication FROM COMMUNICATION WHERE ".
"contenuCommunication = '".db_connect::escape_string($this->getContenuCommunication())."' AND ".
"idRedacteur = ".$this->getIdRedacteur()." AND ".
"dateRedaction = '".$this->getDateRedaction()."'";
$result = db_connect::query($query2);
if ($result->num_rows == 1){
$info = $result->fetch_assoc();
$this->setIdCommunication($info['idCommunication']);
$result->close();
return true;
}
}
//db_connect::getInstance()->rollback();
return false;
}
public function update(){
$query = "UPDATE CAHIER_TEXTE SET ".
"idMatiereNiveau = ".$this->getIdMatiereNiveau()." , ".
"idRedacteur = ".$this->idRedacteur." , ".
"dateRedaction = '".$this->SQLdateRedaction()."' , ".
"dateRealisation = '".$this->SQLdateRealisation()."' , ".
"contenuCahierTexte = '".db_connect::escape_string($this->getContenuCahierTexte())."' ".
"WHERE idCahierTexte = ".$this->getIdCahierTexte();
if (db_connect::query($query))
return true;
return false;
}
public function update(){
$query = "UPDATE CARNET_LIAISON SET ".
"contenuCarnetLiaison = '".db_connect::escape_string($this->getContenuCarnetLiaison())."', ".
"idReponse = ".($this->getIdReponse()?$this->getIdReponse():'NULL').", ".
"idRedacteur = ".$this->getIdRedacteur().", ".
"dateRedaction = '".$this->sqlDateRedaction()."', ".
"idEleve = ".$this->getIdEleve().
"WHERE idCarnetLiaison = ".$this->getIdCarnetLiaison();
if (db_connect::query($query))
return true;
return false;
}
public function update () {
$query = "UPDATE MATIERE SET " . "libelleMatiere = '" . db_connect::escape_string($this->getLibelleMatiere()) . "'
WHERE idMatiere = " . $this->getIdMatiere();
if (db_connect::query($query)) return true;
return false;
}
public function update(){
$query = "UPDATE DOMAINE_CPT SET ".
"libelleDomaineCpt = '".db_connect::escape_string($this->getLibelleDomaineCpt())."', ".
"idMatiere = ".$this->getIdMatiere().
"WHERE idDomaineCpt = ".$this->getIdDomaineCpt();
if (db_connect::query($query))
return true;
return false;
}
public function delete(){
$query = "DELETE FROM PLAN_TRAVAIL WHERE idPlanTravail = ".db_connect::escape_string($this->getIdPlanTravail());
if (db_connect::query($query))
return true;
return false;
}
public function update() {
$query = "UPDATE POINT_CPT SET " .
"libellePointCpt = '" . db_connect::escape_string($this->getLibellePointCpt()) . "', " .
"idDomaineCpt = " . $this->getIdDomaineCpt() . " " .
"WHERE idPointCpt = " . $this->getIdPointCpt();
if (db_connect::query($query))
return TRUE;
return FALSE;
}
public function update(){
$query = "UPDATE PERIODE SET ".
"libellePeriode = '".db_connect::escape_string($this->getLibellePeriode())."', ".
"dateDebutPeriode = '".$this->SQLdateDebutperiode()."', ".
"dateFinPeriode = '".$this->SQLdateFinPeriode()."', ".
"idTrimestre = ".$this->getIdTrimestre()." ".
"WHERE idPeriode = ".$this->getIdPeriode();
if (db_connect::query($query))
return true;
return false;
}
public function update(){
$query = " UPDATE BULLETIN
SET
dateRedaction = '".$this->getDateRedacton()."',
contenuBulletin = '".db_connect::escape_string($this->getContenuBulletin())."',
idEleve = ".$this->getIdEleve().",
idMatiereNiveau = ".$this->getIdMatiereNiveau()."
WHERE idBulletin = ".$this->getIdBulletin();
if (db_connect::query($query)){
return true;
}
return false;
}
public function update () {
$query = "UPDATE EVALUATION SET " . "idTypeEvaluation = " . $this->getIdTypeEvaluation() . ", " . "idMatiereNiveau = " . $this->getIdMatiereNiveau() . ", " . "dateEvaluation = '" . $this->sqlDateEvaluation() . "', " . "titreEvaluation = '" . db_connect::escape_string($this->getTitreEvaluation()) . "', " . "autreEvaluation = " . (empty($this->getAutreEvaluation()) ? 'NULL' : "'".db_connect::escape_string($this->getAutreEvaluation())."'") . ", " . "maxEvaluation = " . $this->getMaxEvaluation() . " " . "WHERE idEvaluation = " . $this->getIdEvaluation();
if (db_connect::query($query)) return true;
return false;
}
public function update() {
$query = "UPDATE ELEVE SET
idNiveau = " . db_connect::escape_string(trim($this->getIdNiveau())) .
" WHERE idEleve = " . $this->getIdEleve();
return db_connect::query($query);
}
public function update(){
$query = "UPDATE NIVEAU SET ".
"libelleNiveau = '".db_connect::escape_string($this->getLibelleNiveau())."', ".
"idModule = ".$this->getIdModule().
"WHERE idNiveau = ".$this->getIdNiveau();
if (db_connect::query($query))
return true;
return false;
}
