111,8 → 111,8 |
$emplacements = null; |
$concatenation_id = "CONCAT(IFNULL(latitude,''),IFNULL(longitude,'')) "; |
$transmission = ( $this->standard == 0) ? "transmission = '1' AND " : ""; |
$requete = 'SELECT ce_zone_geo, zone_geo, station, '. |
"mots_cles_texte, ". |
$requete = 'SELECT distinct ce_zone_geo, zone_geo, NULL as station, '. |
"NULL as mots_cles_texte, ". |
"latitude, ". |
"NULL as wgs84_latitude, ". |
"longitude, ". |
138,8 → 138,7 |
$this->construireWhereTag(). |
$this->construireWhereNombreDeJours(). |
$this->construireWhereAnnee(). |
$this->construireWhereGroupeZoneGeo(). |
' GROUP BY id_coord'; |
$this->construireWhereGroupeZoneGeo(); |
|
$resultats_emplacements = Cel::db()->requeter($requete); |
$emplacements = $this->traiterEmplacements($resultats_emplacements, $this->compterObservations($params)); |