| 64,7 → 64,7 |
|---|
| $requete = 'SELECT utm_secteur, utm_x, utm_y, wgs84_latitude AS latitude, wgs84_longitude AS longitude '. |
| '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) '. |
| ' ON (l.id_zone_geo = co.ce_zone_geo) '. |
| "WHERE transmission = '1' ". |
| $this->construireWhereDept(). |
| $this->construireWhereCommune(). |
| 137,7 → 137,7 |
|---|
| ' utm_secteur, utm_x, utm_y, id_zone_geo, date_transmission '. |
| '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) ". |
| " ON (l.id_zone_geo = co.ce_zone_geo) ". |
| "WHERE transmission = '1' ". |
| $this->construireWhereCoordonnees(). |
| $this->construireWhereUtilisateur(). |
| 282,7 → 282,7 |
|---|
| $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) '. |
| ' ON (l.id_zone_geo = co.ce_zone_geo) '. |
| "WHERE transmission = '1' ". |
| " AND nom_ret != '' ". |
| $this->construireWhereDept(). |
| 516,7 → 516,7 |
|---|
| ' LEFT JOIN cel_obs AS co '. |
| ' ON coi.id_observation = co.id_observation '. |
| ' LEFT JOIN locations AS l '. |
| ' ON (l.nom = co.zone_geo AND l.id_zone_geo = co.ce_zone_geo) '. |
| ' ON (l.id_zone_geo = co.ce_zone_geo) '. |
| "WHERE transmission = '1' ". |
| ($type == 'date.photo' ? " AND (date_prise_de_vue LIKE ".str_replace('-', ':', $param).") " : ''). |
| ($type == 'date.ajout' ? " AND date_creation LIKE $param " : ''). |
| 670,7 → 670,7 |
|---|
| ' LEFT JOIN cel_obs AS co '. |
| ' ON (coi.id_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) ". |
| " ON (l.id_zone_geo = co.ce_zone_geo) ". |
| "WHERE transmission = '1' ". |
| $this->construireWhereCoordonnees(). |
| $this->construireWhereUtilisateur(). |