1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| "SELECT k.id, k.pa, k.ecotaxe, k.taxedd, k.fdp, k.fdp_type, k.libelle, k.code_f, k.ppi, k.tva, k.frais_gestion, k.temp, m.libelle AS marque, m.BtoB,
(pa + ecotaxe + taxedd + fdp) as paGlobal,
(
SELECT SUM(cont1.qte)
FROM ".CONTENIR." cont1
LEFT JOIN ".COM." com1 ON com1.id=cont1.commande
WHERE cont1.kdo=k.id AND com1.date LIKE '".$annee."%'
) as total1,
(
SELECT SUM(cont2.qte)
FROM ".CONTENIR_STIM." cont2
LEFT JOIN ".COM." com2 ON com2.id=cont2.commande
WHERE cont2.kdo=k.id AND com2.date LIKE '".$annee."%'
) as total2,
(
SELECT COUNT(cont3.id)
FROM ".CONTENIR_CARTE." cont3
LEFT JOIN ".COM." com3 ON com3.id=cont3.commande
WHERE cont3.kdo=k.id AND com3.date LIKE '".$annee."%'
) as total3
FROM (".KDO." k, ".MARQUE." m)
WHERE k.vivant=1 AND k.sous_rubrique=".$_GET["id"]." AND m.id=k.marque
ORDER BY ".$orderBy |
Partager