public function editUserByAdmin($bdd, $CloneUser)
{
$req = $bdd->prepare("UPDATE user SET name = :name, login = :login, password = :password, mail = :mail, role_id = :role_id, devise_id = :devise_id WHERE id = :id");
$req->execute(array(':name' => $CloneUser->getname(), ':login' => $CloneUser->getLogin(), ':password' => $CloneUser->getPassword(), ':mail' => $CloneUser->getEmail(), 'role_id' => $CloneUser->getRole(), ':devise_id' => $CloneUser->getDevise(), ':id' => $this->id));
$table_name = "user";
$user = unserialize($_SESSION['user']);
$author_id = $user->getId();
$nid = $this->id;
Modification::insertNewModif($bdd, $nid, $table_name, $author_id);
}
public function updateNote($bdd, $nid, $namenote, $satutnote)
{
$getname = $bdd->prepare("UPDATE `note_frais` SET `name`= :name, `statut_id`= :statut WHERE id= :nid");
$getname->execute(array(":name" => $namenote, ":statut" => $satutnote, ":nid" => $nid));
$table_name = "note_frais";
$user = unserialize($_SESSION['user']);
$author_id = $user->getId();
Modification::insertNewModif($bdd, $nid, $table_name, $author_id);
}
public function upDateFrais($bdd)
{
$req = $bdd->prepare("UPDATE frais SET image = :image, date = :date, description = :description, " . "montant = :montant, devise_id = :devise_id, note_id = :note_id, categorie_id = :categorie_id " . "WHERE id = :id");
$req->execute(array(':image' => $this->image, ':date' => $this->date, ':description' => $this->description, ':montant' => $this->montant, ':devise_id' => $this->devise, ':note_id' => $this->note, ':categorie_id' => $this->categorie, ':id' => $this->id));
$req->closeCursor();
$table_name = "frais";
$user = unserialize($_SESSION['user']);
$author_id = $user->getId();
$nid = $this->id;
Modification::insertNewModif($bdd, $nid, $table_name, $author_id);
}
