| 107,8 → 107,8 |
|---|
| "wgs84_longitude, ". |
| $concatenation_id." as id_coord ". |
| 'FROM cel_obs AS co '. |
| ' LEFT JOIN cel_zones_geo AS l '. |
| ' ON (l.nom = co.zone_geo AND l.id_zone_geo = co.ce_zone_geo) '. |
| ' LEFT JOIN cel_zones_geo AS zg '. |
| ' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '. |
| "WHERE transmission = '1' ". |
| " AND (". |
| $this->construireWhereRectangleStationOR()." OR ". |
| 145,8 → 145,8 |
|---|
| private function compterObservations($params) { |
| $requete = 'SELECT COUNT(*) as nb '. |
| 'FROM cel_obs AS co '. |
| ' LEFT JOIN cel_zones_geo AS l '. |
| ' ON (l.nom = co.zone_geo AND l.id_zone_geo = co.ce_zone_geo) '. |
| ' LEFT JOIN cel_zones_geo AS zg '. |
| ' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '. |
| "WHERE transmission = '1' ". |
| " AND (". |
| $this->construireWhereRectangleStationOR()." OR ". |
| 333,8 → 333,8 |
|---|
| ' lieudit, zone_geo, date_observation, milieu, commentaire, '. |
| ' utm_secteur, utm_x, utm_y, code, date_transmission, nom_referentiel '. |
| 'FROM cel_obs AS co '. |
| ' LEFT JOIN cel_zones_geo AS l '. |
| " ON (l.nom = co.zone_geo AND l.id_zone_geo = co.ce_zone_geo) ". |
| ' LEFT JOIN cel_zones_geo AS zg '. |
| " ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) ". |
| "WHERE transmission = '1' ". |
| (($this->communeEstDemandee()) ? $this->construireWhereCommuneSansCoordonneesAvecSensibles() : $this->construireWhereCoordonneesSansSensibles()). |
| $this->construireWhereDept(). |
| 479,8 → 479,8 |
|---|
| |
| $requete = 'SELECT SQL_CALC_FOUND_ROWS DISTINCT nom_ret, nom_ret_nn, nt, famille '. |
| 'FROM cel_obs AS co '. |
| ' LEFT JOIN cel_zones_geo AS l '. |
| ' ON (l.nom = co.zone_geo AND l.id_zone_geo = co.ce_zone_geo) '. |
| ' LEFT JOIN cel_zones_geo AS zg '. |
| ' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '. |
| "WHERE transmission = '1' ". |
| " AND nom_ret != '' ". |
| $this->construireWhereDept(). |
| 737,11 → 737,11 |
|---|
| private function obtenirObsLieesImg($type, $param) { |
| // Construction de la requête |
| $requete = 'SELECT DISTINCT co.id_obs, ci.ce_utilisateur AS utilisateur '. |
| 'FROM cel_images '. |
| 'FROM cel_images AS ci '. |
| ' LEFT JOIN cel_obs AS co '. |
| ' ON (ci.ce_observation = co.id_observation) '. |
| ' LEFT JOIN cel_zones_geo AS l '. |
| ' ON (l.nom = co.zone_geo AND l.id_zone_geo = co.ce_zone_geo) '. |
| ' LEFT JOIN cel_zones_geo AS zg '. |
| ' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '. |
| "WHERE co.transmission = '1' ". |
| ($type == 'date.photo' ? " AND (ci.date_prise_de_vue LIKE ".str_replace('-', ':', $param).' ' : ''). |
| ($type == 'date.creation' ? " AND ci.date_creation LIKE $param " : ''). |
| 1098,8 → 1098,8 |
|---|
| 'FROM cel_images ci'. |
| ' INNER JOIN cel_obs AS co '. |
| ' ON (ci.ce_observation = co.id_observation) '. |
| ' LEFT JOIN cel_zones_geo AS l '. |
| " ON (l.nom = co.zone_geo AND l.id_zone_geo = co.ce_zone_geo) ". |
| ' LEFT JOIN cel_zones_geo AS zg '. |
| " ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) ". |
| "WHERE co.transmission = '1' ". |
| $this->construireWhereCoordonnees(). |
| $this->construireWhereUtilisateur(). |