inutile de verifier la ville : elle vient direct de geoloc

[platal.git] / include / profil / update_adresses.inc.php

diff --git a/include/profil/update_adresses.inc.php b/include/profil/update_adresses.inc.php
index d6f5213..103a2c2 100644 (file)
--- a/include/profil/update_adresses.inc.php
+++ b/include/profil/update_adresses.inc.php
@@ -43,6 +43,11 @@ foreach ($adresses as $adrid => $adr) {
         if ($adr["active"])        $statut .= 'active,';
         if ($adr["temporaire"])    $statut .= 'temporaire,';
         if (! empty($statut)) $statut = substr($statut, 0, -1);
+        $precise_coords = "";
+        if (isset($adr['precise_lat']) && isset($adr['precise_lon'])) {
+            $precise_coords  = ", glat = '".$adr['precise_lat']."'";
+            $precise_coords .= ", glng = '".$adr['precise_lon']."'";
+        }
 
         if ($adr["nouvelle"] == 'ajout') {
             //nouvelle adresse
@@ -50,7 +55,7 @@ foreach ($adresses as $adrid => $adr) {
                          adr3 = {?}, postcode = {?}, city = {?}, cityid = {?},
                          country = {?}, region = {?}, regiontxt = {?},
                          pub = {?}, datemaj = NOW(), statut = {?}, uid = {?},
-                         adrid = {?}", $adr['adr1'], $adr['adr2'],
+                         adrid = {?}".$precise_coords, $adr['adr1'], $adr['adr2'],
                          $adr['adr3'], $adr['postcode'], $adr['city'],
                          $adr['cityid'], $adr['country'], $adr['region'],
                          $adr['regiontxt'], $adr['pub'], $statut,
@@ -64,7 +69,7 @@ foreach ($adresses as $adrid => $adr) {
             XDB::execute("UPDATE adresses SET adr1 = {?}, adr2 = {?},
                          adr3 = {?}, postcode = {?}, city = {?}, cityid = {?},
                          country = {?}, region = {?}, regiontxt = {?},
-                         pub = {?}, datemaj = NOW(), statut = {?}
+                         pub = {?}, datemaj = NOW(), statut = {?}".$precise_coords."
                          WHERE uid = {?} AND adrid = {?}", $adr['adr1'],
                          $adr['adr2'], $adr['adr3'], $adr['postcode'],
                          $adr['city'], $adr['cityid'], $adr['country'],