Line 408... |
Line 408... |
408 |
//echo '<pre>'.print_r($donnee,true).'</pre>';exit;
|
408 |
//echo '<pre>'.print_r($donnee,true).'</pre>';exit;
|
409 |
$observation = array();
|
409 |
$observation = array();
|
410 |
$observation['idObs'] = $donnee->id_observation;
|
410 |
$observation['idObs'] = $donnee->id_observation;
|
411 |
$observation['nn'] = $this->etreNull($donnee->nom_sel_nn) ? null : $donnee->nom_sel_nn;
|
411 |
$observation['nn'] = $this->etreNull($donnee->nom_sel_nn) ? null : $donnee->nom_sel_nn;
|
412 |
$observation['nomSci'] = $this->nettoyerTexte($donnee->nom_sel);
|
412 |
$observation['nomSci'] = $this->nettoyerTexte($donnee->nom_sel);
|
413 |
$observation['date'] = $this->formaterDate($donnee->date_observation, '%d/%m/%Y');
|
413 |
$observation['date'] = ($donnee->date_observation != '0000-00-00 00:00:00') ? $this->formaterDate($donnee->date_observation, '%d/%m/%Y') : '';
|
414 |
$observation['datePubli'] = $this->formaterDate($donnee->date_transmission);
|
414 |
$observation['datePubli'] = $this->formaterDate($donnee->date_transmission);
|
415 |
$observation['lieu'] = $this->traiterLieu($donnee);
|
415 |
$observation['lieu'] = $this->traiterLieu($donnee);
|
416 |
$observation['observateur'] = $donnee->courriel_utilisateur;
|
416 |
$observation['observateur'] = $donnee->courriel_utilisateur;
|
417 |
$observation['observateurId'] = $donnee->ce_utilisateur;
|
417 |
$observation['observateurId'] = $donnee->ce_utilisateur;
|
418 |
$observation['urlEflore'] = $this->getUrlEflore($donnee->nom_sel_nn);
|
418 |
$observation['urlEflore'] = $this->getUrlEflore($donnee->nom_sel_nn);
|
Line 946... |
Line 946... |
946 |
if (isset($this->parametres['commune']) && !$this->etreNull($commune)) {
|
946 |
if (isset($this->parametres['commune']) && !$this->etreNull($commune)) {
|
947 |
$commune = $this->proteger($commune);
|
947 |
$commune = $this->proteger($commune);
|
948 |
$sql = " AND zone_geo LIKE $commune ";
|
948 |
$sql = " AND zone_geo LIKE $commune ";
|
949 |
$sql .= " AND (
|
949 |
$sql .= " AND (
|
950 |
(
|
950 |
(
|
951 |
(latitude = '000null' OR latitude = '' OR latitude IS NULL) ".
|
951 |
(latitude = '000null' OR latitude = '' OR latitude = 0 OR latitude IS NULL) ".
|
952 |
" AND (longitude = '000null' OR longitude = '' OR longitude IS NULL)".
|
952 |
" AND (longitude = '000null' OR longitude = '' OR longitude = 0 OR longitude IS NULL)".
|
953 |
')'.
|
953 |
')'.
|
954 |
' OR mots_cles_texte LIKE "%sensible%"'.
|
954 |
' OR mots_cles_texte LIKE "%sensible%"'.
|
955 |
') ';
|
955 |
') ';
|
Line 956... |
Line 956... |
956 |
|
956 |
|