Line 222... |
Line 222... |
222 |
(($type == 'UTM') ? " AND (sector = '$secteur' AND x_utm = '$x_utm' AND y_utm = '$y_utm' ) " : '').
|
222 |
(($type == 'UTM') ? " AND (sector = '$secteur' AND x_utm = '$x_utm' AND y_utm = '$y_utm' ) " : '').
|
223 |
(($type == 'LngLat') ? " AND (coord_x = '$coord_x' AND coord_y = '$coord_y' ) " : '').
|
223 |
(($type == 'LngLat') ? " AND (coord_x = '$coord_x' AND coord_y = '$coord_y' ) " : '').
|
224 |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '').
|
224 |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '').
|
225 |
(isset($dept) ? " AND l.insee_code LIKE '$dept%' " : '').
|
225 |
(isset($dept) ? " AND l.insee_code LIKE '$dept%' " : '').
|
226 |
(isset($num_taxon) ? " AND num_taxon = '$num_taxon' " : '' ).
|
226 |
(isset($num_taxon) ? " AND num_taxon = '$num_taxon' " : '' ).
|
227 |
((isset($projet) && $projet_sql != '') ? " AND ($projet_sql) " : '' );
|
227 |
((isset($projet) && $projet_sql != '') ? " AND ($projet_sql) " : '' ).
|
- |
|
228 |
'ORDER BY nom_sel ASC ';
|
- |
|
229 |
|
228 |
//$this->debug[] = $requete;
|
230 |
//$this->debug[] = $requete;
|
Line 229... |
Line 231... |
229 |
|
231 |
|
Line 230... |
Line 232... |
230 |
$resultats = $this->executerRequete($requete);
|
232 |
$resultats = $this->executerRequete($requete);
|