Merge lp:~jfb-tempo-consulting/unifield-server/US-3413 into lp:unifield-server

[jftempo]

=== modified file 'bin/addons/msf_profile/data/patches.xml'
--- bin/addons/msf_profile/data/patches.xml	2019-04-09 12:51:41 +0000
+++ bin/addons/msf_profile/data/patches.xml	2019-06-06 13:39:02 +0000
@@ -416,5 +416,10 @@
             <field name="method">us_5771_allow_all_cc_in_default_dest</field>
         </record>
 
+        <!-- UF13.1 -->
+        <record id="us_3413_align_in_partner_to_po" model="patch.scripts">
+            <field name="method">us_3413_align_in_partner_to_po</field>
+        </record>
+
     </data>
 </openerp>

=== modified file 'bin/addons/msf_profile/msf_profile.py'
--- bin/addons/msf_profile/msf_profile.py	2019-04-09 12:51:41 +0000
+++ bin/addons/msf_profile/msf_profile.py	2019-06-06 13:39:02 +0000
@@ -69,6 +69,23 @@
                     err_msg,
                 )
 
+    # UF13.1
+    def us_3413_align_in_partner_to_po(self,cr, uid, *a, **b):
+        cr.execute("select p.name, p.id, po.partner_id, p.partner_id from stock_picking p, purchase_order po where p.type='in' and po.id = p.purchase_id and ( p.partner_id != po.partner_id or p.partner_id2 != po.partner_id) order by p.name")
+        pick_to_update = []
+        for x in cr.fetchall():
+            pick_to_update.append(x[1])
+            self._logger.warn('Update partner on IN: %s, from partner id: %s to id %s' % (x[0], x[3], x[2]))
+        if pick_to_update:
+            cr.execute('''update stock_picking set (partner_id, partner_id2, address_id) = (select po.partner_id, po.partner_id, po.partner_address_id from purchase_order po where po.id=stock_picking.purchase_id) where id in %s''' , (tuple(pick_to_update),))
+            cr.execute('''update stock_move set partner_id=(select partner_id from stock_picking where id=stock_move.picking_id) where picking_id in %s''', (tuple(pick_to_update),))
+            cr.execute('''select p.id from stock_picking p, res_partner_address ad where p.address_id = ad.id and p.id in %s and p.partner_id2 != ad.partner_id''', (tuple(pick_to_update),))
+            address_to_fix = [x[0] for x in cr.fetchall()]
+            if address_to_fix:
+                cr.execute('''update stock_picking set address_id=(select min(id) from res_partner_address where partner_id=stock_picking.partner_id) where id in %s''', (tuple(address_to_fix), ))
+                self._logger.warn('Update address on %d IN' % cr.rowcount)
+        return True
+
     # UF13.0
     def us_5771_allow_all_cc_in_default_dest(self, cr, uid, *a, **b):
         """