mysql_query("UPDATE stocks set stock_entree = (SELECT SUM(qte) AS qte_entree FROM stocks WHERE id_pros = '".$id_pros."' )WHERE id_pros = '".$id_pros."'");
mysql_query("UPDATE stocks set stock_entree = (SELECT SUM(qte) AS qte_entree FROM stocks WHERE id_pros = ".$id_pros." group by id_pros) WHERE id_pros = ".$id_pros);
<?php
include('body/header.php');
include('body/menu.php');
if (isset($_POST["valider"])) {
$num = mysql_real_escape_string(htmlspecialchars(trim($_POST['num'])));
$article = mysql_real_escape_string(htmlspecialchars(trim($_POST['article'])));
$ref = mysql_real_escape_string(htmlspecialchars(trim($_POST['ref'])));
$pa = mysql_real_escape_string(htmlspecialchars(trim($_POST['pa'])));
$fourn = mysql_real_escape_string(htmlspecialchars(trim($_POST['fourn'])));
$qte = mysql_real_escape_string(htmlspecialchars(trim($_POST['qte'])));
$depot = mysql_real_escape_string(htmlspecialchars(trim($_POST['depot'])));
$pv = mysql_real_escape_string(htmlspecialchars(trim($_POST['pv'])));
//RECUPERER ID PRODUIT
$id_pro = explode("/",$article);
$id_pros = $id_pro[1]; echo $id_pros;
$nom_pros = $id_pro[0];
//RECUPERER ID FOURNISSEUR
$id_fourn = explode("/",$fourn);
$id_fours = $id_fourn[1];
//RECUPERER ID DEPOT
$id_depot = explode("/",$depot);
$id_depots = $id_depot[1];
//VERIFICATION DE L EXISTENCE DU PRODUIT
$sql = "SELECT article FROM produits WHERE article='$article'";
$req = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
// on compte le nombre de résultats
$res = mysql_num_rows($req);
if($res!=0) // l'url existe déjà, on affiche un message d'erreur
{
$msg = 'Désolé, mais ce nom existe déjà dans notre base.';
echo '<script>alert(\' '.$msg.' \');</script>';
}
else // L'url n'existe pas, on insère les informations du formulaire dans la table
{
if (empty($article)) {
$msg="<font color=red>Veuillez saisir le nom !!!!!!!!</font>";
}
else {
$sql="INSERT INTO produits(id,article,pa,pv,ref,id_pros) VALUES('','".$nom_pros."','".$pa."','".$pv."','".$ref."','".$id_pros."')";
// on insère les informations du formulaire dans la table
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$id_get = mysql_insert_id();
mysql_query("INSERT INTO tb_fournisseur(id,id_get,id_pros) VALUES('".$id_get."','".$id_fours."','".$id_pros."')");
mysql_query("INSERT INTO tb_depot(id,id_get,id_pros) VALUES('".$id_get."','".$id_depots."','".$id_pros."')");
mysql_query("INSERT INTO stocks(num,date,qte,stock_entree,stock_sortie,total_stock,id_get,id_pros) VALUES('".$num."',NOW(),'".$qte."','".$stock_entree."','','".$total_stock."','".$id_get."','".$id_pros."')");
//mysql_query("UPDATE stocks set stock_entree = (SELECT SUM(qte) AS qte_entree FROM stocks WHERE id_pros = '".$id_pros."' )WHERE id_pros = '".$id_pros."'");
$r = mysql_query("UPDATE stocks set stock_entree = (SELECT SUM(qte) AS qte_entree FROM stocks WHERE id_pros = ".$id_pros." group by id_pros) WHERE id_pros = ".$id_pros);
printf($r);
$msg = 'Produit***de***'.$article.'***enregistré!!!!';
echo '<script>alert(\' '.$msg.' \');</script>';
}
}
}
?>
SUM(qte)puis mise à jours).
// on crée la requête SQL
$sql = "SELECT DISTINCT
b.articleVendu,
SUM(a.qte) AS arrive,
SUM(b.articleQuant) AS vendu,
SUM(a.qte) - SUM(b.articleQuant) AS diff
FROM stocks a,articles b
WHERE a.id_pros = b.id_prod
GROUP BY a.id_pros
";
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
"SELECT DISTINCT
a.qte,
b.articleQuant
FROM stocks a,articles b
WHERE a.id_pros = b.id_prod
";
SUM(a.qte) AS arrive,comment je procede ??
SUM(b.articleQuant) AS vendu,
SUM(a.qte) - SUM(b.articleQuant) AS diff
$sql = "SELECT DISTINCT
b.articleVendu,
SUM(a.qte) AS arrive,
SUM(b.articleQuant) AS vendu,
SUM(a.qte) - SUM(b.articleQuant) AS diff
FROM stocks a,articles b
WHERE a.id_pros = b.id_prod
AND id_pros = ".$id_pros."
GROUP BY a.id_pros
";
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
".$id_pros."
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question$sql=" SELECT DISTINCT b.articleVendu , SUM(a.qte) AS arrive , SUM(b.articleQuant) AS vendu , SUM(a.qte) - SUM(b.articleQuant) AS diff FROM stocks a ,articles b WHERE a.id_pros = b.id_prod GROUP BY a.id_pros,b.articleVendu ";
SELECT DISTINCT S.id_pros ,ART.* ,SUM(S.qte) AS arrive ,SUM(S.qte) - (ART.vendu) AS diff FROM stocks S ,(SELECT A.id_prod ,SUM(A.articleQuant) as vendu FROM articles A GROUP BY A.id_prod) ART WHERE(ART.id_prod = S.id_pros) GROUP BY S.id_pros