Subversion Repositories eFlore/Applications.cel

[
        {
                "titre": "observations dont la date d'observation est postérieure à la date de transmission",
                "sql": "SELECT count(*) as nombre, CONCAT(YEAR(GREATEST(date_transmission, date_observation)), '-', LPAD(MONTH(GREATEST(date_transmission, date_observation)), 2, 0)) periode FROM cel_obs WHERE date_transmission < date_observation GROUP BY periode ORDER BY periode asc"
        },
        {
                "titre": "observations dont la clef étrangère de l'utilisateur est nulle ou vide",
                "sql": "SELECT count(*) as nombre, CONCAT(YEAR(GREATEST(date_transmission, date_observation)), '-', LPAD(MONTH(GREATEST(date_transmission, date_observation)), 2, 0)) periode FROM cel_obs WHERE ce_utilisateur IS NULL OR ce_utilisateur = '' GROUP BY periode ORDER BY periode asc"
        },
        {
                "titre": "observations non localisées",
                "sql": "SELECT count(*) as nombre, CONCAT(YEAR(GREATEST(date_transmission, date_observation)), '-', LPAD(MONTH(GREATEST(date_transmission, date_observation)), 2, 0)) periode FROM cel_obs WHERE (ce_zone_geo IS NULL OR ce_zone_geo = '') AND (zone_geo = '' OR zone_geo IS NULL) AND (latitude = '' OR latitude IS NULL) AND (longitude = '' OR longitude IS NULL) GROUP BY periode ORDER BY periode asc"
        }
]