| Line 108... |
Line 108... |
| 108 |
"latitude, ".
|
108 |
"latitude, ".
|
| 109 |
"wgs84_latitude, ".
|
109 |
"wgs84_latitude, ".
|
| 110 |
"longitude, ".
|
110 |
"longitude, ".
|
| 111 |
"wgs84_longitude, ".
|
111 |
"wgs84_longitude, ".
|
| 112 |
$concatenation_id." as id_coord ".
|
112 |
$concatenation_id." as id_coord ".
|
| 113 |
'FROM cel_obs AS co '.
|
113 |
'FROM cel_export_total AS co '.
|
| 114 |
' LEFT JOIN cel_zones_geo AS zg '.
|
114 |
' LEFT JOIN cel_zones_geo AS zg '.
|
| 115 |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '.
|
115 |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '.
|
| 116 |
"WHERE transmission = '1' ".
|
116 |
"WHERE transmission = '1' ".
|
| 117 |
" AND (".
|
117 |
" AND (".
|
| 118 |
$this->construireWhereRectangleStationOR()." OR ".
|
118 |
$this->construireWhereRectangleStationOR()." OR ".
|
| Line 148... |
Line 148... |
| 148 |
|
148 |
|
| Line 149... |
Line 149... |
| 149 |
private $nb_obs = 0;
|
149 |
private $nb_obs = 0;
|
| 150 |
|
150 |
|
| 151 |
private function compterObservations($params) {
|
151 |
private function compterObservations($params) {
|
| 152 |
$requete = 'SELECT COUNT(*) as nb '.
|
152 |
$requete = 'SELECT COUNT(*) as nb '.
|
| 153 |
'FROM cel_obs AS co '.
|
153 |
'FROM cel_export_total AS co '.
|
| 154 |
' LEFT JOIN cel_zones_geo AS zg '.
|
154 |
' LEFT JOIN cel_zones_geo AS zg '.
|
| 155 |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '.
|
155 |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '.
|
| 156 |
"WHERE transmission = '1' ".
|
156 |
"WHERE transmission = '1' ".
|
| Line 338... |
Line 338... |
| 338 |
if (isset($this->parametres['station']) && !$this->etreNull($this->parametres['station'])) {
|
338 |
if (isset($this->parametres['station']) && !$this->etreNull($this->parametres['station'])) {
|
| 339 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS id_observation, ce_utilisateur, courriel_utilisateur, nom_utilisateur, prenom_utilisateur, '.
|
339 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS id_observation, ce_utilisateur, courriel_utilisateur, nom_utilisateur, prenom_utilisateur, '.
|
| 340 |
' nom_sel, nom_ret, nom_sel_nn, nom_ret_nn, nt, famille, '.
|
340 |
' nom_sel, nom_ret, nom_sel_nn, nom_ret_nn, nt, famille, '.
|
| 341 |
' lieudit, zone_geo, date_observation, milieu, commentaire, '.
|
341 |
' lieudit, zone_geo, date_observation, milieu, commentaire, '.
|
| 342 |
' utm_secteur, utm_x, utm_y, code, date_transmission, nom_referentiel '.
|
342 |
' utm_secteur, utm_x, utm_y, code, date_transmission, nom_referentiel '.
|
| 343 |
'FROM cel_obs AS co '.
|
343 |
'FROM cel_export_total AS co '.
|
| 344 |
' LEFT JOIN cel_zones_geo AS zg '.
|
344 |
' LEFT JOIN cel_zones_geo AS zg '.
|
| 345 |
" ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) ".
|
345 |
" ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) ".
|
| 346 |
"WHERE transmission = '1' ".
|
346 |
"WHERE transmission = '1' ".
|
| 347 |
(($this->communeEstDemandee()) ? $this->construireWhereCommuneSansCoordonneesAvecSensibles() : $this->construireWhereCoordonneesSansSensibles()).
|
347 |
(($this->communeEstDemandee()) ? $this->construireWhereCommuneSansCoordonneesAvecSensibles() : $this->construireWhereCoordonneesSansSensibles()).
|
| 348 |
$this->construireWhereDept().
|
348 |
$this->construireWhereDept().
|
| Line 486... |
Line 486... |
| 486 |
*/
|
486 |
*/
|
| 487 |
public function getTaxons($params) {
|
487 |
public function getTaxons($params) {
|
| 488 |
$json = null;
|
488 |
$json = null;
|
| Line 489... |
Line 489... |
| 489 |
|
489 |
|
| 490 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS DISTINCT nom_ret, nom_ret_nn, nt, famille '.
|
490 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS DISTINCT nom_ret, nom_ret_nn, nt, famille '.
|
| 491 |
'FROM cel_obs AS co '.
|
491 |
'FROM cel_export_total AS co '.
|
| 492 |
' LEFT JOIN cel_zones_geo AS zg '.
|
492 |
' LEFT JOIN cel_zones_geo AS zg '.
|
| 493 |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '.
|
493 |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '.
|
| 494 |
"WHERE transmission = '1' ".
|
494 |
"WHERE transmission = '1' ".
|
| 495 |
" AND nom_ret != '' ".
|
495 |
" AND nom_ret != '' ".
|