1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| require_once('includes/fonctions.php');
$login = $_SESSION['login'];
$code_code=$_POST['code_cde'];
$date_code=$_POST['date_cde'];
$nomemploye=$_POST['nomemploye'];
$nomFRS=$_POST['nom_FRS'];
$objetcde=$_POST['objet_cde'];
$r=$bdd->prepare("SET @maxid=(SELECT max(Num_commande) FROM bondecommande WHERE code_commande LIKE concat(`BC-',date_format(CURRENT_DATE(),'%Y%m'),'-%') )");
$re=$bdd->prepare("SET @num=(SELECT SUBSTRING_INDEX(code_commande,'-',-1) FROM bondecommande WHERE Num_commande=@maxid");
//var_dump($re);
$qer=$bdd->prepare("SET @num=ifnull(@num+1,1)");
$r->execute();
$re->execute();
$qer->execute();
var_dump($qer);
$req = $bdd->prepare("INSERT INTO bondecommande (code_commande, date_commande, num_employe, num_fournisseur, objet_commande, soumis, valide, rejete, soumis_par) VALUES(concat('BC-',date_format(CURRENT_DATE(),'%Y%m'),'-',@num), :date_cde, (select num_employe FROM employe WHERE nom_employe= :nom_employe), (SELECT num_fournisseur FROM fournisseur WHERE nom_fournisseur= :nom_FRS), :objet_cde, 1, 0, 0, :soumis_par)");
//$req->bindParam(":code_cde",$code_code);
$req->bindParam(":date_cde",$date_code);
$req->bindParam(":nom_employe",$nomemploye);
$req->bindParam(":nom_FRS",$nomFRS);
$req->bindParam(":objet_cde",$objetcde);
$req->bindParam(":soumis_par",$login);
$req->execute(); |
Partager