| Line 310... |
Line 310... |
| 310 |
//$format = preg_match('/^[-]?[0-9]+(?:[.][0-9]+|)$/', $lng) ? true : false;
|
310 |
//$format = preg_match('/^[-]?[0-9]+(?:[.][0-9]+|)$/', $lng) ? true : false;
|
| 311 |
$ok = ($lng >= -180 && $lng <= 180) ? true : false;
|
311 |
$ok = ($lng >= -180 && $lng <= 180) ? true : false;
|
| 312 |
return $ok;
|
312 |
return $ok;
|
| 313 |
}
|
313 |
}
|
| Line -... |
Line 314... |
| - |
|
314 |
|
| - |
|
315 |
|
| 314 |
|
316 |
/* à changer pour localisation_floutage */
|
| 315 |
private function etreObsSensible($tags) {
|
317 |
private function etreObsSensible($tags) {
|
| 316 |
$sensible = true;
|
318 |
$sensible = true;
|
| 317 |
if (stristr($tags, 'sensible') === FALSE) {
|
319 |
if (stristr($tags, 'sensible') === FALSE) {
|
| 318 |
$sensible = false;
|
320 |
$sensible = false;
|
| Line 746... |
Line 748... |
| 746 |
* Récupération des identifiant d'utilisateur et des ordres des observations correspondant à une date.
|
748 |
* Récupération des identifiant d'utilisateur et des ordres des observations correspondant à une date.
|
| 747 |
* Retour sous forme de tableau : array[identifiant] = array(ordre, ordre...);
|
749 |
* Retour sous forme de tableau : array[identifiant] = array(ordre, ordre...);
|
| 748 |
*/
|
750 |
*/
|
| 749 |
private function obtenirObsLieesImg($type, $param) {
|
751 |
private function obtenirObsLieesImg($type, $param) {
|
| 750 |
// Construction de la requête
|
752 |
// Construction de la requête
|
| 751 |
$requete = 'SELECT DISTINCT co.id_obs, ci.ce_utilisateur AS utilisateur '.
|
753 |
$requete = 'SELECT DISTINCT co.id_obs, co.ce_utilisateur AS utilisateur '.
|
| 752 |
'FROM cel_images AS ci '.
|
754 |
'FROM cel_export_total AS co '.
|
| 753 |
' LEFT JOIN cel_obs AS co '.
|
- |
|
| 754 |
' ON (ci.ce_observation = co.id_observation) '.
|
- |
|
| 755 |
' LEFT JOIN cel_zones_geo AS zg '.
|
755 |
' LEFT JOIN cel_zones_geo AS zg '.
|
| 756 |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '.
|
756 |
' ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) '.
|
| 757 |
"WHERE co.transmission = '1' ".
|
757 |
"WHERE co.transmission = '1' and co.images != null".
|
| 758 |
($type == 'date.photo' ? " AND (ci.date_prise_de_vue LIKE ".str_replace('-', ':', $param).' ' : '').
|
- |
|
| 759 |
($type == 'date.creation' ? " AND ci.date_creation LIKE $param " : '').
|
758 |
($type == 'date.creation' ? " AND co.date_creation LIKE $param " : '').
|
| 760 |
($type == 'date.liaison' ? " AND ci.date_liaison LIKE $param " : '').
|
- |
|
| 761 |
($type == 'commentaire.img' ? " AND ci.commentaire LIKE $param " : '').
|
- |
|
| 762 |
($type == 'commentaire.obs' ? " AND co.commentaire LIKE $param " : '').
|
759 |
($type == 'commentaire.obs' ? " AND co.commentaire LIKE $param " : '').
|
| 763 |
($type == 'commentaire.*' ? " AND (co.commentaire LIKE $param OR ci.commentaire LIKE $param) " : '').
|
760 |
($type == 'commentaire.*' ? " AND co.commentaire LIKE $param " : '').
|
| 764 |
$this->construireWhereCoordonnees().
|
761 |
$this->construireWhereCoordonnees().
|
| 765 |
$this->construireWhereDept().
|
762 |
$this->construireWhereDept().
|
| 766 |
$this->construireWhereCommune().
|
763 |
$this->construireWhereCommune().
|
| 767 |
$this->construireWherePays().
|
764 |
$this->construireWherePays().
|
| 768 |
$this->construireWhereUtilisateur().
|
765 |
$this->construireWhereUtilisateur().
|
| Line 998... |
Line 995... |
| 998 |
$sql = '';
|
995 |
$sql = '';
|
| 999 |
// Récupération des coordonnées depuis l'id station
|
996 |
// Récupération des coordonnées depuis l'id station
|
| 1000 |
extract($this->parametres);
|
997 |
extract($this->parametres);
|
| 1001 |
if (isset($this->parametres['num_taxon']) && !$this->etreNull($num_taxon)) {
|
998 |
if (isset($this->parametres['num_taxon']) && !$this->etreNull($num_taxon)) {
|
| 1002 |
$num_taxon = Cel::db()->proteger($num_taxon);
|
999 |
$num_taxon = Cel::db()->proteger($num_taxon);
|
| 1003 |
$sql = " AND nt = $num_taxon ";
|
1000 |
$sql = " AND nom_ret_nn = $num_taxon ";
|
| 1004 |
}
|
1001 |
}
|
| 1005 |
return $sql;
|
1002 |
return $sql;
|
| 1006 |
}
|
1003 |
}
|
| Line 1007... |
Line 1004... |
| 1007 |
|
1004 |
|
| Line 1012... |
Line 1009... |
| 1012 |
if (isset($this->parametres['num_taxon']) && !$this->etreNull($num_taxon)) {
|
1009 |
if (isset($this->parametres['num_taxon']) && !$this->etreNull($num_taxon)) {
|
| 1013 |
$sous_taxons = $this->obtenirSousTaxons($this->parametres['num_taxon']);
|
1010 |
$sous_taxons = $this->obtenirSousTaxons($this->parametres['num_taxon']);
|
| 1014 |
$num_taxon = Cel::db()->proteger($num_taxon);
|
1011 |
$num_taxon = Cel::db()->proteger($num_taxon);
|
| 1015 |
if(!empty($sous_taxons)) {
|
1012 |
if(!empty($sous_taxons)) {
|
| 1016 |
$sql_in_sous_tax = implode(',', $sous_taxons);
|
1013 |
$sql_in_sous_tax = implode(',', $sous_taxons);
|
| 1017 |
$sql = " AND (nt = $num_taxon OR ".
|
- |
|
| 1018 |
"nom_sel_nn IN (".$sql_in_sous_tax.") OR ".
|
1014 |
$sql = " AND (nom_sel_nn IN (".$sql_in_sous_tax.") OR ".
|
| 1019 |
"nom_ret_nn IN (".$sql_in_sous_tax.") ".
|
1015 |
"nom_ret_nn IN (".$sql_in_sous_tax.") ".
|
| 1020 |
") ";
|
1016 |
") ";
|
| 1021 |
}
|
1017 |
}
|
| 1022 |
else {
|
1018 |
else {
|
| 1023 |
$sql = " AND nt = $num_taxon ";
|
1019 |
$sql = " AND nom_ret_nn = $num_taxon ";
|
| 1024 |
}
|
1020 |
}
|
| 1025 |
}
|
1021 |
}
|
| 1026 |
return $sql;
|
1022 |
return $sql;
|
| 1027 |
}
|
1023 |
}
|
| Line 1139... |
Line 1135... |
| 1139 |
$sql = null;
|
1135 |
$sql = null;
|
| 1140 |
if (isset($tag) && !$this->etreNull($tag)) {
|
1136 |
if (isset($tag) && !$this->etreNull($tag)) {
|
| 1141 |
$tag_sql = $this->getSqlWhereMotsCles($tag);
|
1137 |
$tag_sql = $this->getSqlWhereMotsCles($tag);
|
| 1142 |
// Construction de la requête
|
1138 |
// Construction de la requête
|
| 1143 |
$requete = 'SELECT DISTINCT co.id_observation AS id_obs, ci.ce_utilisateur AS utilisateur '.
|
1139 |
$requete = 'SELECT DISTINCT co.id_observation AS id_obs, ci.ce_utilisateur AS utilisateur '.
|
| 1144 |
'FROM cel_images ci'.
|
1140 |
'FROM photo ci'.
|
| 1145 |
' INNER JOIN cel_obs AS co '.
|
1141 |
' INNER JOIN cel_obs AS co '.
|
| 1146 |
' ON (ci.ce_observation = co.id_observation) '.
|
1142 |
' ON (ci.ce_observation = co.id_observation) '.
|
| 1147 |
' LEFT JOIN cel_zones_geo AS zg '.
|
1143 |
' LEFT JOIN cel_zones_geo AS zg '.
|
| 1148 |
" ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) ".
|
1144 |
" ON (zg.nom = co.zone_geo AND zg.id_zone_geo = co.ce_zone_geo) ".
|
| 1149 |
"WHERE co.transmission = '1' ".
|
1145 |
"WHERE co.transmission = '1' ".
|