<?php

session_start();

if (!isset($_GET['aux']))

{

header('Location: DEVIS.php');

exit();

}

unset($_SESSION['r_devis']);//Devis



$link = mysqli_connect("localhost",  "advery", "EoM6IJlnirGIfcu","factures") or die("Impossible de se connecter : " . mysqli_error());

$retour =mysqli_query($link,'SELECT MAX(id_bl) AS nbMax WHERE `refe_system_fisc` = YEAR(CURRENT_DATE()) FROM bon_livraison');

$valeur = mysqli_fetch_assoc($retour);

$a = $valeur['nbMax'];

$a ++ ;
$year = date("y");  
$x ='BL0'.$year.'/'.$a;

$_SESSION['r_devis'] = $x;



$dt = date('d-m-Y');

//Ajout Devis

$reponse = "INSERT INTO bon_livraison VALUES(id_bl ,'$x' , $_GET[aux] ,'$dt' , 'Initiation', YEAR(CURRENT_DATE()) );";

mysqli_query($link,$reponse);

//Notification

$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 BL : '.$x;

$reponse = "INSERT INTO notification VALUES(id_notif ,'dripicons-user-group','$a' ,'$dt', 'ADMIN');";

mysqli_query($link,$reponse);

header('Location: Detail-BL.php');

exit();

//echo 'Session : '.$_SESSION['r_devis'].'<br>Id User : '.$_GET['aux'];

?>