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

[jftempo]

=== modified file 'bin/addons/msf_profile/data/patches.xml'
--- bin/addons/msf_profile/data/patches.xml	2023-08-10 14:11:55 +0000
+++ bin/addons/msf_profile/data/patches.xml	2023-09-18 13:23:54 +0000
@@ -979,5 +979,10 @@
         <record id="us_11810_fix_company_logo" model="patch.scripts">
             <field name="method">us_11810_fix_company_logo</field>
         </record>
+
+        <!-- UF31.0 -->
+        <record id="us_11956_fix_po_line_reception_destination" model="patch.scripts">
+            <field name="method">us_11956_fix_po_line_reception_destination</field>
+        </record>
     </data>
 </openerp>

=== modified file 'bin/addons/msf_profile/msf_profile.py'
--- bin/addons/msf_profile/msf_profile.py	2023-08-10 14:11:55 +0000
+++ bin/addons/msf_profile/msf_profile.py	2023-09-18 13:23:54 +0000
@@ -57,6 +57,27 @@
         'model': lambda *a: 'patch.scripts',
     }
 
+    # UF31.0
+    def us_11956_fix_po_line_reception_destination(self, cr, uid, *a, **b):
+        '''
+        Set the Reception Destination to Cross Docking for all PO line by Nomenclature (no product) if they are linked
+        to a FO or an External IR
+        '''
+        cross_id = self.pool.get('ir.model.data').get_object_reference(cr, uid, 'msf_cross_docking',
+                                                                       'stock_location_cross_docking')[1]
+
+        cr.execute('''
+            UPDATE purchase_order_line SET reception_dest_id = %s WHERE id IN (
+                SELECT pl.id FROM purchase_order_line pl 
+                    LEFT JOIN sale_order so ON pl.link_so_id = so.id 
+                    LEFT JOIN stock_location l ON so.location_requestor_id = l.id 
+                WHERE pl.link_so_id = so.id AND pl.product_id IS NULL AND 
+                    (so.procurement_request = 'f' OR (so.location_requestor_id IS NOT NULL AND l.usage = 'customer'))
+        )''', (cross_id,))
+        self.log_info(cr, uid, "US-11956: The Line Destination of %s PO line(s) by Nomenclature have been set to 'Cross Docking'" % (cr.rowcount,))
+
+        return True
+
     # UF30.0
     def us_11810_fix_company_logo(self, cr, uid, *a, **b):
         '''