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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
<?php
$resem=$cbd->prepare('SELECT
m.ns,
COALESCE((DATE_FORMAT(datedec,"%U")),0) AS NS,
YEAR(c.datedec) AS Annee,
COALESCE((sum(c.m) + sum(c.m1) + sum(c.m2) + sum(c.m3) + sum(c.m4) + sum(c.m5) + sum(c.m6) + sum(c.m7) + sum(c.m8)), 0) AS Total_M,
COALESCE((sum(c.f) + sum(c.f1) + sum(c.f2) + sum(c.f3) + sum(c.f4) + sum(c.f5) + sum(c.f6) + sum(c.f7) + sum(c.f8)), 0) AS Total_F,
COALESCE((sum(c.m) + sum(c.m1) + sum(c.m2) + sum(c.m3) + sum(c.m4) + sum(c.m5) + sum(c.m6) + sum(c.m7) + sum(c.m8) + sum(c.f) + sum(c.f1) + sum(c.f2) + sum(c.f3) + sum(c.f4) + sum(c.f5) + sum(c.f6) + sum(c.f7) + sum(c.f8)), 0) AS Total
FROM conteneur c
WHERE YEAR(datedec)=:an && cdet=:cdet
RIGHT OUTER JOIN numsem m ON DATE_FORMAT(datedec,"%U") = m.ns
GROUP BY YEAR(c.datedec),
DATE_FORMAT(datedec,"%U"),
m.ns
ORDER BY m.ns ASC ');
try {
// On envois la requète
$ann = trim(htmlspecialchars(stripslashes($_POST['an'])));
$cdet = trim(htmlspecialchars(stripslashes($_SESSION['cdet'])));
$resem->bindParam(':an', $ann , PDO::PARAM_INT);
$resem->bindParam(':cdet', $cdet , PDO::PARAM_STR);
$resem->execute();
// On récupère en 1er toutes les données
$dataresem = $resem->fetchAll(PDO::FETCH_ASSOC);
// libèré la connexion du serveur
$resem->closeCursor();
}
catch( Exception $e ){
echo 'Erreur d\'affichage : ', $e->getMessage();
}
/*----------------- fin affichage */
?> |
Partager