| 56,9 → 56,10 |
|---|
| $utilisateur = isset($_GET['utilisateur']) ? Cel::db()->quote($_GET['utilisateur']) : null; |
| |
| // Récupération des données |
| $requete = "SELECT DATE_FORMAT(date_creation, '%Y%m') AS periode, COUNT(ci.id_image) AS nbre ". |
| "FROM cel_obs_images coi LEFT JOIN cel_images ci ON (coi.id_image = ci.id_image) ". |
| $requete = "SELECT DATE_FORMAT(date_creation, '%Y%m') AS periode, COUNT(id_image) AS nbre ". |
| "FROM cel_images ". |
| "WHERE date_creation != '0000-00-00 00:00:00' ". |
| ' AND ce_observation IS NOT NULL AND ce_observation != 0 '. |
| ((isset($utilisateur)) ? " AND courriel_utilisateur = $utilisateur " : ''). |
| 'GROUP BY periode '. |
| 'ORDER BY periode '; |