Line 66... |
Line 66... |
66 |
$dept = $this->traiterValeursMultiples($dept);
|
66 |
$dept = $this->traiterValeursMultiples($dept);
|
Line 67... |
Line 67... |
67 |
|
67 |
|
68 |
$requete = 'SELECT sector, x_utm, y_utm '.
|
68 |
$requete = 'SELECT sector, x_utm, y_utm '.
|
69 |
'FROM cel_inventory AS i '.
|
69 |
'FROM cel_inventory AS i '.
|
70 |
' LEFT JOIN locations AS l '.
|
70 |
' LEFT JOIN locations AS l '.
|
71 |
" ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ".
|
71 |
" ON (l.name = i.location AND l.code = i.id_location) ".
|
72 |
"WHERE transmission = '1' ".
|
72 |
"WHERE transmission = '1' ".
|
73 |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '' ).
|
73 |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '' ).
|
74 |
(isset($dept) ? " AND l.code IN ($dept) " : '').
|
74 |
(isset($dept) ? " AND l.code IN ($dept) " : '').
|
75 |
(isset($num_taxon) ? " AND num_taxon = '$num_taxon' " : '' ).
|
75 |
(isset($num_taxon) ? " AND num_taxon = '$num_taxon' " : '' ).
|
Line 138... |
Line 138... |
138 |
// Vérification que la clé passée dans l'url est correspond à celle attendue
|
138 |
// Vérification que la clé passée dans l'url est correspond à celle attendue
|
139 |
if ($cle == $this->config['jrest_admin']['cleCarto']) {
|
139 |
if ($cle == $this->config['jrest_admin']['cleCarto']) {
|
140 |
$requete = 'SELECT sector, x_utm, y_utm, coord_x, coord_y, ref_geo '.
|
140 |
$requete = 'SELECT sector, x_utm, y_utm, coord_x, coord_y, ref_geo '.
|
141 |
'FROM cel_inventory AS i '.
|
141 |
'FROM cel_inventory AS i '.
|
142 |
' LEFT JOIN locations AS l '.
|
142 |
' LEFT JOIN locations AS l '.
|
143 |
" ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ".
|
143 |
" ON (l.name = i.location AND l.code = i.id_location) ".
|
144 |
"WHERE transmission = '1' ".
|
144 |
"WHERE transmission = '1' ".
|
145 |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '' ).
|
145 |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '' ).
|
146 |
(isset($dept) ? " AND l.code IN ($dept) " : '').
|
146 |
(isset($dept) ? " AND l.code IN ($dept) " : '').
|
147 |
(isset($num_taxon) ? " AND num_taxon = '$num_taxon' " : '' ).
|
147 |
(isset($num_taxon) ? " AND num_taxon = '$num_taxon' " : '' ).
|
148 |
(isset($projet) ? ' AND ('.$this->getSqlWhereProjet($projet).') ' : '' );
|
148 |
(isset($projet) ? ' AND ('.$this->getSqlWhereProjet($projet).') ' : '' );
|
Line 219... |
Line 219... |
219 |
$requete = 'SELECT id, identifiant, nom_sel, nom_ret, num_nom_sel, num_nom_ret, num_taxon, famille, '.
|
219 |
$requete = 'SELECT id, identifiant, nom_sel, nom_ret, num_nom_sel, num_nom_ret, num_taxon, famille, '.
|
220 |
' lieudit, location, date_observation, milieu, commentaire, '.
|
220 |
' lieudit, location, date_observation, milieu, commentaire, '.
|
221 |
' sector, x_utm, y_utm, insee_code '.
|
221 |
' sector, x_utm, y_utm, insee_code '.
|
222 |
'FROM cel_inventory AS i '.
|
222 |
'FROM cel_inventory AS i '.
|
223 |
' LEFT JOIN locations AS l '.
|
223 |
' LEFT JOIN locations AS l '.
|
224 |
" ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ".
|
224 |
" ON (l.name = i.location AND l.code = i.id_location) ".
|
225 |
"WHERE transmission = '1' ".
|
225 |
"WHERE transmission = '1' ".
|
226 |
(($type == 'UTM') ? " AND (sector = '$secteur' AND x_utm = '$x_utm' AND y_utm = '$y_utm' ) " : '').
|
226 |
(($type == 'UTM') ? " AND (sector = '$secteur' AND x_utm = '$x_utm' AND y_utm = '$y_utm' ) " : '').
|
227 |
(($type == 'LngLat') ? " AND (coord_x = '$coord_x' AND coord_y = '$coord_y' ) " : '').
|
227 |
(($type == 'LngLat') ? " AND (coord_x = '$coord_x' AND coord_y = '$coord_y' ) " : '').
|
228 |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '').
|
228 |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '').
|
229 |
(isset($dept) ? " AND l.code IN ($dept) " : '').
|
229 |
(isset($dept) ? " AND l.code IN ($dept) " : '').
|
Line 257... |
Line 257... |
257 |
}
|
257 |
}
|
Line 258... |
Line 258... |
258 |
|
258 |
|
259 |
$requete = 'SELECT DISTINCT nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille '.
|
259 |
$requete = 'SELECT DISTINCT nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille '.
|
260 |
'FROM cel_inventory AS i '.
|
260 |
'FROM cel_inventory AS i '.
|
261 |
' LEFT JOIN locations AS l '.
|
261 |
' LEFT JOIN locations AS l '.
|
262 |
" ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ".
|
262 |
" ON (l.name = i.location AND l.code = i.id_location) ".
|
263 |
"WHERE transmission = '1' ".
|
263 |
"WHERE transmission = '1' ".
|
264 |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '').
|
264 |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '').
|
265 |
(isset($dept) ? " AND l.code IN ($dept) " : '').
|
265 |
(isset($dept) ? " AND l.code IN ($dept) " : '').
|
266 |
(isset($num_taxon) ? " AND num_taxon = '$num_taxon' " : '' ).
|
266 |
(isset($num_taxon) ? " AND num_taxon = '$num_taxon' " : '' ).
|