1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
if($choix=='valider')
{
$sql="insert into `commande` values('', '$numc_cde', '$refp_cde', '$date_cde' , '$qt_cde', DATE_ADD('$date_cde', INTERVAL 1 YEAR))";
}
elseif($duree==2)
{
$sql="insert into `commande` values('', '$numc_cde', '$refp_cde', '$date_cde' , '$qt_cde', DATE_ADD('$date_cde', INTERVAL 2 YEAR))";
}
else
{
$sql="insert into `commande` values('', '$numc_cde', '$refp_cde', '$date_cde' , '$qt_cde', DATE_ADD('$date_cde', INTERVAL 3 YEAR))";
}
mysql_query($sql) or die("Erreur en sql". mysql_error());
echo'<p font size="4" face="Verdana, Arial, Helvetica, sans-serif">
<div align="center"><font color="#003399"><br> La Commande est ajouter avec successee <img src="../images/ok.png" width="18" height="24"> </p></div>';
$sql1="update pack, commande set qts_pack=qts_pack - $qt_cde where pack.ref_pack = commande.refp_cde and refp_cde='$refp_cde'"; // maj qt en stock//
$sql2="insert into `sorti`(num_auto, refp_sorti, lib_sorti, qt_sorti, datee_sorti, dates_sorti, numclt_sorti, nomclt_sorti) select refp_cde, lib_pack, qt_cde, date_pack, date_cde, num_clt, nom_clt from client, pack, commande where client.num_clt = commande.numc_cde and pack.ref_pack = commande.refp_cde and numc_cde='$numc_cde' and refp_cde='$refp_cde'";
//requette d'insertion des données dans la table sorti automatiquement
mysql_query($sql1) or die("error en sql update". mysql_error());
mysql_query($sql2) or die("erreur requette d'insertion dans la table sorti". mysql_error()); |
Partager