| 42,7 → 42,7 |
|---|
| |
| $infos_altitude_json = file_get_contents('http://maps.googleapis.com/maps/api/elevation/json?sensor=false&locations='.$lat.','.$lon); |
| $infos_commune_json = file_get_contents("http://ws.geonames.org/findNearbyJSON?featureClass=ADM4&lat=".urlencode($lat)."&lng=".urlencode($lon)."&style=full") ; |
| |
| |
| // à voir l'utilisation de google places lors de la mise en place d'un compte google premier api |
| //$infos_commune = file_get_contents('https://maps.googleapis.com/maps/api/place/search/json?sensor=false&locations='.$lat.','.$lon); |
| |
| 57,7 → 57,7 |
|---|
| |
| $commune = $this->remplacerNomCommunePourRecherche($commune); |
| |
| $requete_infos_communes = 'SELECT * FROM ods.COMMUNE WHERE COMMUNE_NOM LIKE '.$this->proteger($commune).' ORDER BY COMMUNE_NOM LIMIT 0,10'; |
| $requete_infos_communes = 'SELECT * FROM ods_communes WHERE oc_nom LIKE '.$this->proteger($commune).' ORDER BY oc_nom LIMIT 0,10'; |
| |
| $infos_communes = $this->executerRequete($requete_infos_communes); |
| |
| 104,11 → 104,24 |
|---|
| |
| foreach($infos_communes as $commune) { |
| |
| $cp = $commune['oc_code_insee']; |
| $limite = 2; |
| if(strlen($cp) == 4) { |
| $limite = 1; |
| } |
| |
| $dpt = substr($cp,0,$limite); |
| |
| if($limite == 1) { |
| $dpt = '0'.$dpt; |
| } |
| |
| $infos_formatees[] = array( |
| 'commune' => $commune['COMMUNE_NOM'], |
| 'dpt' => $commune['COMMUNE_CODEPOSTAL'], |
| 'lat' => $commune['COMMUNE_LATITUDE'], |
| 'lon' => $commune['COMMUNE_LONGITUDE'] |
| 'commune' => $commune['oc_nom'], |
| 'dpt' => $dpt, |
| 'code_insee' => $commune['oc_code_insee'], |
| 'lat' => $commune['oc_latitude'], |
| 'lon' => $commune['oc_longitude'] |
| ); |
| } |
| return $infos_formatees; |