68,7 → 68,7 |
$requete = 'SELECT sector, x_utm, y_utm '. |
'FROM cel_inventory AS i '. |
' LEFT JOIN locations AS l '. |
" ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ". |
" ON (l.name = i.location AND l.code = i.id_location) ". |
"WHERE transmission = '1' ". |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '' ). |
(isset($dept) ? " AND l.code IN ($dept) " : ''). |
140,7 → 140,7 |
$requete = 'SELECT sector, x_utm, y_utm, coord_x, coord_y, ref_geo '. |
'FROM cel_inventory AS i '. |
' LEFT JOIN locations AS l '. |
" ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ". |
" ON (l.name = i.location AND l.code = i.id_location) ". |
"WHERE transmission = '1' ". |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '' ). |
(isset($dept) ? " AND l.code IN ($dept) " : ''). |
221,7 → 221,7 |
' sector, x_utm, y_utm, insee_code '. |
'FROM cel_inventory AS i '. |
' LEFT JOIN locations AS l '. |
" ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ". |
" ON (l.name = i.location AND l.code = i.id_location) ". |
"WHERE transmission = '1' ". |
(($type == 'UTM') ? " AND (sector = '$secteur' AND x_utm = '$x_utm' AND y_utm = '$y_utm' ) " : ''). |
(($type == 'LngLat') ? " AND (coord_x = '$coord_x' AND coord_y = '$coord_y' ) " : ''). |
259,7 → 259,7 |
$requete = 'SELECT DISTINCT nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille '. |
'FROM cel_inventory AS i '. |
' LEFT JOIN locations AS l '. |
" ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ". |
" ON (l.name = i.location AND l.code = i.id_location) ". |
"WHERE transmission = '1' ". |
(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : ''). |
(isset($dept) ? " AND l.code IN ($dept) " : ''). |