| Line 133... |
Line 133... |
| 133 |
$total = 0;
|
133 |
$total = 0;
|
| 134 |
if (!$this->etreNull($this->parametres['station'])) {
|
134 |
if (!$this->etreNull($this->parametres['station'])) {
|
| 135 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS id_observation, ce_utilisateur, courriel_utilisateur, '.
|
135 |
$requete = 'SELECT SQL_CALC_FOUND_ROWS id_observation, ce_utilisateur, courriel_utilisateur, '.
|
| 136 |
' nom_sel, nom_ret, nom_sel_nn, nom_ret_nn, nt, famille, '.
|
136 |
' nom_sel, nom_ret, nom_sel_nn, nom_ret_nn, nt, famille, '.
|
| 137 |
' lieudit, zone_geo, date_observation, milieu, commentaire, '.
|
137 |
' lieudit, zone_geo, date_observation, milieu, commentaire, '.
|
| 138 |
' utm_secteur, utm_x, utm_y, id_zone_geo, date_transmission '.
|
138 |
' utm_secteur, utm_x, utm_y, id_zone_geo, date_transmission, nom_referentiel '.
|
| 139 |
'FROM cel_obs AS co '.
|
139 |
'FROM cel_obs AS co '.
|
| 140 |
' LEFT JOIN cel_zones_geo AS l '.
|
140 |
' LEFT JOIN cel_zones_geo AS l '.
|
| 141 |
" ON (l.id_zone_geo = co.ce_zone_geo) ".
|
141 |
" ON (l.id_zone_geo = co.ce_zone_geo) ".
|
| 142 |
"WHERE transmission = '1' ".
|
142 |
"WHERE transmission = '1' ".
|
| 143 |
$this->construireWhereCoordonnees().
|
143 |
$this->construireWhereCoordonnees().
|
| Line 178... |
Line 178... |
| 178 |
$observation['date'] = $this->formaterDate($donnee->date_observation, '%d/%m/%Y');
|
178 |
$observation['date'] = $this->formaterDate($donnee->date_observation, '%d/%m/%Y');
|
| 179 |
$observation['datePubli'] = $this->formaterDate($donnee->date_transmission);
|
179 |
$observation['datePubli'] = $this->formaterDate($donnee->date_transmission);
|
| 180 |
$observation['lieu'] = $this->traiterLieu($donnee);
|
180 |
$observation['lieu'] = $this->traiterLieu($donnee);
|
| 181 |
$observation['observateur'] = $donnee->courriel_utilisateur;
|
181 |
$observation['observateur'] = $donnee->courriel_utilisateur;
|
| 182 |
$observation['observateurId'] = $donnee->ce_utilisateur;
|
182 |
$observation['observateurId'] = $donnee->ce_utilisateur;
|
| - |
|
183 |
$observation['referentiel'] = $this->supprimerVersionDuReferentiel($donnee->nom_referentiel);
|
| 183 |
$observation['urlEflore'] = $this->getUrlEflore($donnee->nom_sel_nn);
|
184 |
$observation['urlEflore'] = $this->getUrlEflore($donnee->nom_referentiel, $donnee->nom_sel_nn);
|
| Line 184... |
Line 185... |
| 184 |
|
185 |
|
| 185 |
if (isset($donnee->zone_geo)) {
|
186 |
if (isset($donnee->zone_geo)) {
|
| 186 |
$observations['commune'] = $this->nettoyerTexte($donnee->zone_geo);
|
187 |
$observations['commune'] = $this->nettoyerTexte($donnee->zone_geo);
|
| 187 |
}
|
188 |
}
|
| Line 192... |
Line 193... |
| 192 |
}
|
193 |
}
|
| 193 |
}
|
194 |
}
|
| 194 |
return $observations;
|
195 |
return $observations;
|
| 195 |
}
|
196 |
}
|
| Line 196... |
Line -... |
| 196 |
|
- |
|
| 197 |
private function getUrlEflore($nn) {
|
- |
|
| 198 |
$urlEflore = null;
|
- |
|
| 199 |
if (! $this->etreNull($nn)) {
|
- |
|
| 200 |
$urlEflore = sprintf($this->config['settings']['efloreUrlTpl'], $nn, 'illustration');
|
- |
|
| 201 |
}
|
- |
|
| 202 |
return $urlEflore;
|
- |
|
| 203 |
}
|
- |
|
| 204 |
|
197 |
|
| 205 |
private function traiterLieu($donnee) {
|
198 |
private function traiterLieu($donnee) {
|
| 206 |
$lieu = array();
|
199 |
$lieu = array();
|
| 207 |
if (!$this->etreNull($donnee->lieudit)) {
|
200 |
if (!$this->etreNull($donnee->lieudit)) {
|
| 208 |
$lieu[] = $donnee->lieudit;
|
201 |
$lieu[] = $donnee->lieudit;
|