Merge lp:~mallorymarcot/unifield-server/us-2054 into lp:unifield-server

[jftempo]

[lp:~mallorymarcot/unifield-server/us-2054]

4098. By Mallory MARCOT on 2016-12-02

US-2054 [Fix] Stock mission report lines are created even if the product's state is empty

=== modified file 'bin/addons/mission_stock/mission_stock.py'
--- bin/addons/mission_stock/mission_stock.py	2016-11-21 13:42:33 +0000
+++ bin/addons/mission_stock/mission_stock.py	2016-12-02 09:08:20 +0000
@@ -547,15 +547,22 @@
         line_obj = self.pool.get('stock.mission.report.line')
         for report in self.read(cr, uid, report_ids, ['local_report', 'full_view'], context=context):
             # Create one line by product
-            cr.execute('''SELECT p.id from product_product p
-                          WHERE NOT EXISTS (
+            cr.execute('''SELECT p.id, ps.code
+                          FROM product_product p, product_template pt
+                              LEFT JOIN product_status ps ON pt.state = ps.id
+                          WHERE p.product_tmpl_id = pt.id
+                          AND NOT EXISTS (
                             SELECT product_id
                             FROM
                             stock_mission_report_line smrl WHERE mission_report_id = %s
                             AND p.id = smrl.product_id)
                         ''' % report['id'])
-            for product in cr.fetchall():
-                line_obj.create(cr, uid, {'product_id': product, 'mission_report_id': report['id']}, context=context)
+            for product, prod_state in cr.fetchall():
+                line_obj.create(cr, uid, {
+                    'product_id': product, 
+                    'mission_report_id': report['id'],
+                    'product_state': prod_state,
+                }, context=context)
 
             # Don't update lines for full view or non local reports
             if not report['local_report']: