SELECT
Stock.IDStock AS IDStock,
CONCAT(Cuve.CodeCuve , ' ',Produit.Libelle , ' ',Automate.Nom ) AS Cuve,
Stock.Date AS DATE,
Stock.Heure AS Heure,
Produit.Libelle AS Produit,
Stock.TypeMouvement AS TypeMouvement,
Sum(CASE WHEN ( Stock.TypeMouvement = 1) THEN Stock.Quantite ELSE 0 END ) AS QuantiteEntree,
Sum(CASE WHEN ( Stock.TypeMouvement = 2) THEN Stock.Quantite ELSE 0 END ) AS Quantitesortie,
Stock.Prix AS Prix,
Sum(CASE WHEN ( Stock.TypeMouvement = 1) THEN ( Stock.Quantite * Stock.Prix ) ELSE 0 END ) AS Montant,
Stock.Observations AS Observations
FROM
(
(
Stock
Left OUTER JOIN
Cuve
ON Stock.IDCuve = Cuve.IDCuve
)
Left OUTER JOIN
Produit
ON Cuve.IDProduit = Produit.IDProduit
)
Left OUTER JOIN
Automate
ON Cuve.IDAutomate = Automate.IDAutomate
WHERE
(
CONCAT(Stock.Date ,Stock.Heure ) BETWEEN {pdhDebut} AND {pdhFin}
AND Cuve.IDCuve IN ({pIDCuve})
AND Produit.IDProduit = {pIDProduit}
)
GROUP by
Stock.IDStock,
CONCAT(Cuve.CodeCuve , ' ',Produit.Libelle , ' ',Automate.Nom ) ,
Stock.Date,
Stock.Heure,
Produit.Libelle,
Stock.TypeMouvement,
Stock.Prix,
Stock.Observations
ORDER by
Cuve Asc,
DATE Asc,
Heure Asc