<?php

session_start();

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

{

header('Location: DEVIS.php');

exit();

}

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



$link = mysqli_connect("localhost", "c0adveryinvoices", "hwvTZJ7_4","c0adveryinvoices") or die("Impossible de se connecter : " . mysqli_error());

$reponserm = "select count(*) from devis ;";

$execrm = mysqli_query($link,$reponserm);

$numrm = mysqli_fetch_row($execrm);
$year = date("y");  
if ( $numrm['0']!= 0)

{	

	$retour =mysqli_query($link,'SELECT * FROM devis WHERE `refe_system_fisc` = YEAR(CURRENT_DATE()) ORDER BY `id_devis` DESC LIMIT 0, 1');

	$valeur = mysqli_fetch_assoc($retour);

	$a = substr( $valeur['ref_devis'], strpos( $valeur['ref_devis'], "/") + 1);

	 

	$a += 1 ;

	$x ='D0'.$year.'/'.$a;

}

else

	$a = 1;

	

$x ='D0'.$year.'/'.$a;

$_SESSION['r_devis'] = $x;



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

//Ajout Devis

$reponse = "INSERT INTO devis VALUES(id_devis ,'$x' , $_GET[aux] ,'$dt' , 'Initiation',  YEAR(CURDATE()) );";

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

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

mysqli_query($link,$reponse);

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

exit();

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

?>