page_footer(); $template->set_filenames(array('body' => 'modifiernote.html')); $submit = isset($_POST['submit']); $id = $_GET['idLigne']; $template->assign_var('IDLIGNE', $id); if ($submit) { $date = $_POST['date']; $annee = $_POST['annee']; $motif = $_POST['idmotif']; $trajet = $_POST['trajet']; $kms = $_POST['kms']; $cpeages = $_POST['cpeages']; $crepas = $_POST['crepas']; $chebergement = $_POST['chebergement']; $indemnites = new IndemniteMySqlDAO(); $indemniteQuery = $indemnites->queryByAnnee($annee); $ligne = new LignefraisMySqlDAO(); $FraisInsert = new Lignefrai(); $FraisInsert->idLigne = $id; $FraisInsert->date = $date; $FraisInsert->idMotif = $motif; $FraisInsert->trajet = $trajet; $FraisInsert->km = $kms; $FraisInsert->coutPeage = $cpeages; $FraisInsert->coutRepas = $crepas; $FraisInsert->coutHebergement = $chebergement; $FraisInsert->coutTrajet = $kms * $indemniteQuery[0]->tarifKilometrique; $FraisInsert->coutTotal = $cpeages + $crepas + $chebergement + $kms * $indemniteQuery[0]->tarifKilometrique; $FraisInsert->idIndemnite = $indemniteQuery[0]->idIndemnite; $FraisInsert->idDemandeur = $_SESSION['idDemandeur']; $ligne->update($FraisInsert);