Merge lp:~unifield-team/unifield-server/us-1716 into lp:unifield-server

[jftempo]

=== modified file 'bin/addons/msf_partner/partner.py'
--- bin/addons/msf_partner/partner.py	2017-01-20 14:37:30 +0000
+++ bin/addons/msf_partner/partner.py	2017-02-13 13:48:00 +0000
@@ -626,6 +626,8 @@
         return super(res_partner, self).write(cr, uid, ids, vals, context=context)
 
     def create(self, cr, uid, vals, context=None):
+        if context is None:
+            context = {}
         vals = self.check_pricelists_vals(cr, uid, vals, context=context)
         if 'partner_type' in vals and vals['partner_type'] in ('internal', 'section', 'esc', 'intermission'):
             msf_customer = self.pool.get('ir.model.data').get_object_reference(cr, uid, 'stock', 'stock_location_internal_customers')
@@ -645,7 +647,7 @@
                         elif pl.type == 'purchase':
                             vals['property_product_pricelist_purchase'] = pl.id
 
-        if not vals.get('address'):
+        if not context.get('sync_update_execution') and not vals.get('address'):
             vals['address'] = [(0, 0, {'function': False, 'city': False, 'fax': False, 'name': False, 'zip': False, 'title': False, 'mobile': False, 'street2': False, 'country_id': False, 'phone': False, 'street': False, 'active': True, 'state_id': False, 'type': False, 'email': False})]
 
         if vals.get('name'):
@@ -873,6 +875,26 @@
         '''
         Remove empty addresses if exist and create the new one
         '''
+        def src_addr_link(addresses):
+            cr.execute("""
+                SELECT ccu.constraint_name
+                FROM information_schema.constraint_column_usage ccu
+                WHERE ccu.table_name = %s AND ccu.table_catalog = %s""", (self._table, cr.dbname))
+            constraints = cr.fetchall()
+            cr.execute("""
+                SELECT kcu.column_name, kcu.table_name
+                FROM information_schema.key_column_usage kcu
+                WHERE kcu.table_catalog = %s AND kcu.constraint_name IN %s""", (cr.dbname, tuple([x[0] for x in constraints])))
+            for column, table in cr.fetchall():
+                if table == self._table:
+                    continue
+                cr.execute("""SELECT count(id) FROM %s WHERE %s IN %%s""" % (table, column), (tuple(addresses),))
+                res = cr.fetchall()
+                if res[0][0]:
+                    return True
+
+            return False
+
         if vals.get('partner_id'):
             domain_dict = {
                 'partner_id': vals.get('partner_id'),
@@ -894,7 +916,10 @@
             }
             domain = [(k, '=', v) for k, v in domain_dict.iteritems()]
             addr_ids = self.search(cr, uid, domain, context=context)
-            self.unlink(cr, uid, addr_ids, context=context)
+            if addr_ids and not src_addr_link(addr_ids):
+                self.unlink(cr, uid, addr_ids, context=context)
+            elif addr_ids:
+                self.write(cr, uid, addr_ids, {'active': False}, context=context)
 
         return super(res_partner_address, self).create(cr, uid, vals, context=context)