| 155,7 → 155,8 |
|---|
| } |
| |
| private function chargerVille() { |
| $requete = "SELECT * FROM tb_cel.locations"; |
| $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;"; |
| $villes = $this->getBdd()->recupererTous($requete); |
| foreach ($villes as $ville) { |
| $this->tab_code_insee[$ville['insee_code']] = $ville; |
| 178,7 → 179,8 |
|---|
| $utm = $this->cartesFormateur->chercherVille($inventory, $this->tab_code_insee); |
| // Ultime tentative |
| if (!$utm) { |
| $requete = "SELECT * FROM tb_cel.locations WHERE name LIKE ".$this->getBdd()->proteger($inventory['location']); |
| $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 name LIKE ".$this->getBdd()->proteger($inventory['location']); |
| $utm = $this->getBdd()->recupererTous($requete); |
| } |
| |