Line 106... |
Line 106... |
106 |
$utm = array();
|
106 |
$utm = array();
|
107 |
if ($inventory['id_location'] != 'null') {
|
107 |
if ($inventory['id_location'] != 'null') {
|
108 |
if (isset($tab_code_insee) & in_array($inventory['id_location'], $tab_code_insee)) {
|
108 |
if (isset($tab_code_insee) & in_array($inventory['id_location'], $tab_code_insee)) {
|
109 |
$utm = array(0 => $this->tab_code_insee[$id_location_protege]);
|
109 |
$utm = array(0 => $this->tab_code_insee[$id_location_protege]);
|
110 |
} else {
|
110 |
} else {
|
111 |
$requete = "SELECT *, nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector ".
|
111 |
$requete = "SELECT nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector ".
|
112 |
"FROM tb_cel.cel_zones_geo ".
|
112 |
"FROM cel.cel_zones_geo ".
|
113 |
"WHERE nom LIKE $location_protege ".
|
113 |
"WHERE nom LIKE $location_protege ".
|
114 |
" AND code = $id_location_protege ";
|
114 |
" AND code = $id_location_protege ";
|
115 |
$resultat = $this->getBdd()->recupererTous($requete);
|
115 |
$resultat = $this->getBdd()->recupererTous($requete);
|
116 |
$utm = $resultat;
|
116 |
$utm = $resultat;
|
117 |
}
|
117 |
}
|
118 |
} else {
|
118 |
} else {
|
119 |
$requete = "SELECT *, nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector FROM tb_cel.cel_zones_geo WHERE nom LIKE $location_protege ";
|
119 |
$requete = "SELECT nom as name, code as insee_code, utm_x as x_utm, utm_y as y_utm, utm_secteur as sector".
|
- |
|
120 |
" FROM tb_cel.cel_zones_geo WHERE nom LIKE $location_protege ";
|
120 |
$utm = $this->getBdd()->recupererTous($requete);
|
121 |
$utm = $this->getBdd()->recupererTous($requete);
|
121 |
}
|
122 |
}
|
122 |
return $utm;
|
123 |
return $utm;
|
123 |
}
|
124 |
}
|