| 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 |
}
|