<?php
session_start();
if (!isset($_SESSION['compte_user']))
{
header('Location: erreur_surfing.html');
exit();
}
$link = mysqli_connect("localhost",  "advery", "EoM6IJlnirGIfcu","factures") or die("Impossible de se connecter : " . mysqli_error());
$b = date('H:i');
$c = date('d-m-Y');
$dt = $c . ' [ '. $b . ' ]';
$rep = $_POST['desc'];
$rep = str_replace("\n", '<br>', $rep);
$rep = addslashes($rep);
$rep1 = $_POST['libelle'];
$rep1 = addslashes($rep1);
$reponse = "INSERT INTO article_service VALUES(id_art_serv,'$rep1' , '$rep' , $_POST[prixht] ,$_POST[tva] , $_POST[qte_stock] ,'Article',$_POST[prix_ac_ht]);";
mysqli_query($link,$reponse);
$retour =mysqli_query($link,'SELECT MAX(id_art_serv) AS nbMax FROM article_service');
$valeur = mysqli_fetch_assoc($retour);
$a = $valeur['nbMax'];
//Insertion article -> facture fournisseur
$reponse = "INSERT INTO detail_fac_fournisseur VALUES(id_detail ,'$_SESSION[r_facture]' , $a ,$_POST[qte_stock] , $_POST[remise], $_POST[prixht]);";
mysqli_query($link,$reponse);
$reponse = "select * from comptes_user where id_clt = $_SESSION[compte_user] ;";
$exec =mysqli_query($link,$reponse);
$row = mysqli_fetch_assoc($exec);
$a = $row['nom'].' vient de creer un nouveau article : '.$_POST['libelle'];
$reponse = "INSERT INTO notification VALUES(id_notif ,'dripicons-user-group','$a' ,'$dt', 'ADMIN');";
mysqli_query($link,$reponse);
mysql_close($link);
header('Location: Detail-Facture-Fournisseur.php');
exit();
?>