From: Nicolas Iooss <nicolas.iooss_git@polytechnique.org>
Date: Sun, 5 Oct 2014 13:35:13 +0000 (+0200)
Subject: Make Address::save() remove possibly existing components from a previous address
X-Git-Url: http://git.polytechnique.org/?p=platal.git;a=commitdiff_plain;h=3da338db27ff7e09b46cad976342aeb133a60aad

Make Address::save() remove possibly existing components from a previous address
---

diff --git a/classes/address.php b/classes/address.php
index 4998577..7034196 100644
--- a/classes/address.php
+++ b/classes/address.php
@@ -704,6 +704,11 @@ class Address
                          $this->types, $this->formatted_address, $this->location_type, $this->partial_match, $this->latitude, $this->longitude,
                          $this->southwest_latitude, $this->southwest_longitude, $this->northeast_latitude, $this->northeast_longitude, $this->geocoding_calls, $this->postal_code_fr);
 
+            // In an ideal world there would not be any components to clean up before insertion.
+            // In real world, it happens that some addresses are badly removed and this query removes the leaked trash.
+            XDB::execute('DELETE FROM  profile_addresses_components
+                                WHERE  pid = {?} AND jobid = {?} AND groupid = {?} AND type = {?} AND id = {?}',
+                         $this->pid, $this->jobid, $this->groupid, $this->type, $this->id);
             if ($this->componentsIds) {
                 foreach (explode(',', $this->componentsIds) as $component_id) {
                     XDB::execute('INSERT IGNORE INTO  profile_addresses_components (pid, jobid, groupid, type, id, component_id)