public static function getNoteById($bdd, $id)
{
$note = $bdd->prepare('SELECT * FROM note_frais WHERE id = :id LIMIT 1');
$note->execute(array(':id' => $id));
$array = $note->fetch();
$CloneNote = new Note();
$CloneNote->setDate($array['date']);
$CloneNote->setId($array['id']);
$CloneNote->setName($array['name']);
$CloneNote->setStatut($array['statut_id']);
$CloneNote->setUser($array['user_id']);
return $CloneNote;
}
$note_name = $_POST[$namenote];
if (isset($note_name) && !empty($note_name)) {
$namenote = htmlentities($note_name);
$statutnote = htmlentities($_POST['statut']);
$nid = $_GET['id'];
Note::updateNote($bdd, $nid, $namenote, $statutnote);
echo '<div class="bg-success">La note à bien été éditée</div><br/><br/>';
}
} elseif (isset($_POST['valider'])) {
$note_name = filter_input(INPUT_POST, $namenote);
if (isset($note_name) && !empty($note_name)) {
$date = date("Y-m-d");
$namenote = htmlentities($note_name);
$newnote = new Note();
$newnote->setName($namenote);
$newnote->setDate($date);
$newnote->setUser($sessionUser->getId());
$newnote->setStatut(1);
$newnote->insertNewNote($bdd);
echo '<div class="bg-success">La note à bien été ajoutée</div><br/><br/>';
}
} elseif (isset($_POST['modifier'])) {
$note_name = filter_input(INPUT_POST, $namenote);
if (isset($note_name) && !empty($note_name)) {
$namenote = htmlentities($note_name);
//s'il a coché la case 'Cloturer'
if (isset($_POST['cloturer']) && !empty($_POST['cloturer'])) {
$statutnote = "2";
} else {
$statutnote = "1";
}
