Merge lp:~dorian-kemps/unifield-server/US-4151 into lp:unifield-server

[jftempo]

=== modified file 'bin/addons/delivery_mechanism/delivery_mechanism.py'
--- bin/addons/delivery_mechanism/delivery_mechanism.py	2017-12-14 15:23:34 +0000
+++ bin/addons/delivery_mechanism/delivery_mechanism.py	2018-03-28 07:26:48 +0000
@@ -1084,6 +1084,7 @@
                                 context=context
                             )
                             out_values['price_unit'] = price_unit
+                            out_values['price_currency_id'] = out_move.price_currency_id.id
 
                         # List the Picking Ticket that need to be created from the Draft Picking Ticket
                         if out_move.picking_id.type == 'out' \
 
=== modified file 'bin/addons/msf_profile/data/patches.xml'
--- bin/addons/msf_profile/data/patches.xml	2018-03-15 14:46:24 +0000
+++ bin/addons/msf_profile/data/patches.xml	2018-03-28 07:26:48 +0000
@@ -14,6 +14,10 @@
             <field name="method">us_4407_update_free_lines_ad</field>
         </record>
 
+        <record id="us_4151_change_correct_out_currency" model="patch.scripts">
+            <field name="method">us_4151_change_correct_out_currency</field>
+        </record>
+
         <!-- UF7.3 -->
         <record id="send_instance_uuid" model="patch.scripts">
             <field name="method">send_instance_uuid</field>
 
=== modified file 'bin/addons/msf_profile/msf_profile.py'
--- bin/addons/msf_profile/msf_profile.py	2018-03-16 09:40:20 +0000
+++ bin/addons/msf_profile/msf_profile.py	2018-03-28 07:26:48 +0000
@@ -106,6 +106,39 @@
         cr.execute(update_free_1)
         cr.execute(update_free_2)
 
+    def us_4151_change_correct_out_currency(self, cr, uid, *a, **b):
+        '''
+        search the currency_id in FO/IR for each OUT/PICK to set the correct one, doesn't change it if no FO/IR found
+        '''
+        company_curr = self.pool.get('res.company').browse(cr, uid, 1, fields_to_fetch=['currency_id']).currency_id.id
+
+        move_ids_currencies = {}
+        cr.execute('''
+            select m.id, m.price_currency_id, s.procurement_request, pl.currency_id
+            from stock_move m
+                left join stock_picking p on (m.picking_id = p.id)
+                left join sale_order_line sl on (m.sale_line_id = sl.id)
+                left join sale_order s on (sl.order_id = s.id)
+                left join product_pricelist pl on (s.pricelist_id = pl.id)
+            where m.sale_line_id is not null and m.type = 'out' and p.type = 'out' and p.subtype in ('standard', 'picking')
+        ''')
+        for x in cr.fetchall():
+            if x[2]:
+                currency_id_key = company_curr
+            else:
+                currency_id_key = x[3]
+            if x[1] != currency_id_key:
+                if currency_id_key in move_ids_currencies:
+                    move_ids_currencies[currency_id_key].append(x[0])
+                else:
+                    move_ids_currencies.update({currency_id_key: [x[0]]})
+
+        for currency_id in move_ids_currencies:
+            cr.execute('''update stock_move set price_currency_id = %s where id in %s'''
+                       , (currency_id, tuple(move_ids_currencies[currency_id])))
+
+        return True
+
     # UF7.3
     def flag_pi(self, cr, uid, *a, **b):
         cr.execute('''select distinct i.id, p.default_code from