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

[Quentin THEURET @Amaris]

=== modified file 'bin/addons/mission_stock/mission_stock.py'
--- bin/addons/mission_stock/mission_stock.py	2016-11-10 16:36:42 +0000
+++ bin/addons/mission_stock/mission_stock.py	2016-11-21 09:48:09 +0000
@@ -696,7 +696,8 @@
                             'cross_qty': line.cross_qty or 0.00,
                             'secondary_qty': line.secondary_qty or 0.00,
                             'cu_qty': line.cu_qty or 0.00,
-                            'updated': True}
+                            'updated': True,
+                            'product_state': line.product_id.state and line.product_id.state.code,}
 
                     if move[4] in internal_loc:
                         vals['internal_qty'] -= qty
@@ -916,6 +917,7 @@
             write_relate=False,
             _fnct_migrate=is_migration,
         ),
+        'product_state': fields.char(size=128, string='Unifield state'),
         # mandatory nomenclature levels
         'nomen_manda_0': fields.related('product_id', 'nomen_manda_0', type='many2one', relation='product.nomenclature', string='Main Type'),
         'nomen_manda_1': fields.related('product_id', 'nomen_manda_1', type='many2one', relation='product.nomenclature', string='Group'),
@@ -1009,6 +1011,7 @@
         'in_pipe_coor_qty': 0.00,
         'in_pipe_coor_val': 0.00,
         'instance_id': _get_default_destination_instance_id,
+        'product_state': '',
     }
 
     def update_full_view_line(self, cr, uid, context=None):

=== modified file 'bin/addons/msf_profile/data/patches.xml'
--- bin/addons/msf_profile/data/patches.xml	2016-11-08 15:50:26 +0000
+++ bin/addons/msf_profile/data/patches.xml	2016-11-21 09:48:09 +0000
@@ -114,9 +114,16 @@
         <record id="us_1766_fix_fxa_aji_curr" model="patch.scripts">
             <field name="method">us_1766_fix_fxa_aji_curr</field>
         </record>
+<<<<<<< TREE
 
         <record id="us_635_dest_partner_ids" model="patch.scripts">
             <field name="method">us_635_dest_partner_ids</field>
         </record>
+=======
+
+        <record id="us_1671_stopped_products" model="patch.scripts">
+            <field name="method">us_1671_stopped_products</field>
+        </record>
+>>>>>>> MERGE-SOURCE
     </data>
 </openerp>

=== modified file 'bin/addons/msf_profile/i18n/fr_MF.po'
--- bin/addons/msf_profile/i18n/fr_MF.po	2016-11-09 15:21:10 +0000
+++ bin/addons/msf_profile/i18n/fr_MF.po	2016-11-21 09:48:09 +0000
@@ -6413,7 +6413,10 @@
 msgid "Either there are no moves linked to the picking or Accounting Journals are misconfigured!"
 msgstr "Soit les Journaux Comptables sont mal configurés, soit il n'y a pas de mouvement connexe à ce prélèvement !"
 
-#. modules: tender_flow, financing_contract, account_voucher, account_override, purchase_allocation_report, register_accounting, msf_accrual, account_msf, return_claim, res_currency_tables, procurement_request, stock_forecast, analytic, msf_doc_import, analytic_distribution, msf_order_date, account_payment, msf_homere_interface, msf_instance, purchase_override, specific_rules, kit, out_step, base, msf_budget, account_corrections, account, msf_outgoing, sale_override, sale, sales_followup, procurement, sourcing, purchase, msf_audittrail, stock
+#. modules: msf_tools, tender_flow, financing_contract, account_voucher, account_override, purchase_allocation_report, register_accounting, msf_accrual, account_msf, return_claim, res_currency_tables, procurement_request, stock_forecast, analytic, msf_doc_import, analytic_distribution, msf_order_date, account_payment, msf_homere_interface, msf_instance, purchase_override, specific_rules, kit, out_step, base, msf_budget, account_corrections, account, msf_outgoing, sale_override, sale, sales_followup, procurement, sourcing, purchase, msf_audittrail, stock
+#: view:automated.import.job:0
+#: selection:automated.import.job,state:0
+#: selection:export.report.stopped.products,state:0
 #: view:account.bank.statement:0
 #: selection:account.bank.statement,state:0
 #: view:account.invoice:0
@@ -11615,7 +11618,8 @@
 msgid "Net weight"
 msgstr "Net weight"
 
-#. modules: stock_forecast, procurement, sync_client, stock_override, stock
+#. modules: stock_forecast, procurement, sync_client, stock_override, stock, msf_tools
+#: selection:export.report.stopped.products,state:0
 #: selection:procurement.order,state:0
 #: view:stock.move:0
 #: selection:stock.forecast.line,state:0
@@ -31983,7 +31987,8 @@
 msgid "37 J(PM)"
 msgstr "37 J(PM)"
 
-#. modules: sales_followup, reason_types_moves, procurement_request, order_types, msf_doc_import, return_claim, sourcing, register_accounting
+#. modules: msf_tools, sales_followup, reason_types_moves, procurement_request, order_types, msf_doc_import, return_claim, sourcing, register_accounting
+#: selection:export.report.stopped.products,state:0
 #: selection:wizard.import.fo.line,state:0
 #: selection:wizard.import.ir.line,state:0
 #: selection:wizard.import.po.line,state:0
@@ -43876,7 +43881,9 @@
 msgid "Average monthly consumption"
 msgstr "consommation mensuelle réelle"
 
-#. modules: account_override, msf_doc_import, account, consumption_calculation 
+#. modules: account_override, msf_doc_import, account, consumption_calculation, msf_tools
+#: field:automated.import.job,state:0
+#: field:export.report.stopped.products,state:0
 #: selection:account.journal.column,field:0
 #: report:addons/account_override/report/open_invoices_xls.mako:304
 #: field:real.average.consumption,state:0
@@ -74707,9 +74714,10 @@
 msgid "Generate report (all locations)"
 msgstr "Générer le rapport (toutes les zones)"
 
-#. module: specific_rules
+#. modules: specific_rules, msf_tools
 #: view:export.report.stock.inventory:0
 #: view:unconsistent.stock.report:0
+#: view:export.report.stopped.products:0
 msgid "Generate report"
 msgstr "Générer le rapport"
 
@@ -74724,8 +74732,9 @@
 msgid "Product Code"
 msgstr "Code Produit"
 
-#. module: specific_rules
+#. modules: specific_rules, msf_tools
 #: report:addons/specific_rules/report/report_stock_inventory_all_locations_xls.mako:129
+#: field:export.report.stopped.products,name:0
 #: field:export.report.stock.inventory,name:0
 msgid "Generated on"
 msgstr "Généré le"
@@ -74763,6 +74772,7 @@
 msgid "You can't search on this object without using at least one exact search term (precede your search with the character '=')."
 msgstr "Vous ne pouvez pas exécuter de recherche sur cet objet sans utiliser au moins une recherche exacte (ajoutez le caractère = devant votre filtre)."
 
+<<<<<<< TREE
 #. module: procurement_request
 #: code:addons/procurement_request/procurement_request.py:553
 #, python-format
@@ -75092,3 +75102,26 @@
 msgid "Attachment configuration"
 msgstr "Configuration des pièces jointes"
 
+=======
+#. module: msf_tools
+#: view:export.report.stopped.products:0
+msgid "Request information"
+msgstr "Information"
+
+#. module: msf_tools
+#: view:export.report.stopped.products:0
+#: model:ir.actions.act_window,name:msf_tools.export_report_stopped_products_action
+#: model:ir.ui.menu,name:msf_tools.export_report_stopped_products_menu
+msgid "Export Stopped Products"
+msgstr "Exporter produits stoppés"
+
+#. module: msf_tools
+#: view:export.report.stopped.products:0
+msgid "Status of the report"
+msgstr "Status du rapport"
+
+#. module: msf_tools
+#: code:addons/msf_tools/report/report_stopped_products.py:64
+#, python-format
+msgid "There is no stopped products to report"
+msgstr "Il n'y a aucun produit stoppé à afficher">>>>>>> MERGE-SOURCE

=== modified file 'bin/addons/msf_profile/msf_profile.py'
--- bin/addons/msf_profile/msf_profile.py	2016-11-09 13:21:34 +0000
+++ bin/addons/msf_profile/msf_profile.py	2016-11-21 09:48:09 +0000
@@ -909,6 +909,7 @@
                     currency_id != %s""", (currency_id, tuple(journal_ids), currency_id))
 
 
+<<<<<<< TREE
     def us_635_dest_partner_ids(self, cr, uid, *a, **b):
         """
         Fill many2many field dest_partner_ids
@@ -929,6 +930,23 @@
         return True
 
 
+=======
+    def us_1671_stopped_products(self, cr, uid, *a, **b):
+        '''
+        Fill field product_state of object stock.mission.report.line with the state of the products (product.product)
+        '''
+        prod_obj = self.pool.get('product.product')
+        smrl_obj = self.pool.get('stock.mission.report.line')
+        context = {}
+
+        prod_ids = prod_obj.search(cr, uid, [('state', '!=', False), ('active', 'in', ['t', 'f'])], context=context)
+        smrl_to_modify = smrl_obj.search(cr, uid, [('product_id', 'in', prod_ids), ('mission_report_id.local_report', '=', True)], context=context)
+
+        for smrl in smrl_obj.browse(cr, uid, smrl_to_modify, context=context):
+            smrl_obj.write(cr, uid, smrl.id, {'product_state': smrl.product_id.state.code}, context=context)
+
+
+>>>>>>> MERGE-SOURCE
 patch_scripts()
 
 

=== modified file 'bin/addons/msf_sync_data_server/data/sync_server.sync_rule.csv'
--- bin/addons/msf_sync_data_server/data/sync_server.sync_rule.csv	2016-11-03 15:58:00 +0000
+++ bin/addons/msf_sync_data_server/data/sync_server.sync_rule.csv	2016-11-21 09:48:09 +0000
@@ -84,8 +84,8 @@
 msf_sync_data_server.budget_line,TRUE,TRUE,FALSE,FALSE,bidirectional,Up,"[('budget_id','in',('msf.budget','id',[('type','=','normal'), ('state', '!=', 'draft')]))]","['account_id/id', 'budget_id/id', 'month1', 'month2', 'month3', 'month4', 'month5', 'month6', 'month7', 'month8', 'month9', 'month10', 'month11', 'month12', 'destination_id/id', 'line_type']",OC,msf.budget.line,,Budget line,Valid,,431
 msf_sync_data_server.budget_status,TRUE,TRUE,FALSE,FALSE,bidirectional,Up,"[('type','=','normal'), ('state', '!=', 'draft')]",['state'],OC,msf.budget,,Budget status,Valid,,432
 msf_sync_data_server.mission_stock_report,TRUE,TRUE,FALSE,FALSE,bidirectional,Up,"[('full_view', '=', False), ('local_report', '=', True)]","['full_view', 'instance_id/id', 'last_update', 'name']",OC,stock.mission.report,,Mission Stock Report,Valid,,440
-msf_sync_data_server.mission_stock_report_line,TRUE,TRUE,FALSE,FALSE,bidirectional,Up,"[('mission_report_id.full_view', '=', False), ('mission_report_id.local_report', '=', True), ('international_status','in',['Local', 'Temporary'])]","['central_qty', 'central_val', 'cross_qty', 'cross_val', 'cu_qty', 'cu_val', 'in_pipe_coor_qty', 'in_pipe_coor_val', 'in_pipe_qty', 'in_pipe_val', 'internal_qty', 'internal_val', 'mission_report_id/id', 'product_id/id', 'secondary_qty', 'secondary_val', 'stock_qty', 'stock_val', 'xmlid_code']",MISSION,stock.mission.report.line,,Mission Stock Report Line,Valid,,441
-msf_sync_data_server.mission_stock_report_line_OC,TRUE,TRUE,FALSE,FALSE,bidirectional,Up,"[('mission_report_id.full_view', '=', False), ('mission_report_id.local_report', '=', True), ('international_status','in',['ITC', 'UniData', 'ESC', 'HQ'])]","['central_qty', 'central_val', 'cross_qty', 'cross_val', 'cu_qty', 'cu_val', 'in_pipe_coor_qty', 'in_pipe_coor_val', 'in_pipe_qty', 'in_pipe_val', 'internal_qty', 'internal_val', 'mission_report_id/id', 'product_id/id', 'secondary_qty', 'secondary_val', 'stock_qty', 'stock_val', 'xmlid_code']",OC,stock.mission.report.line,,Mission Stock Report Line OC,Valid,,442
+msf_sync_data_server.mission_stock_report_line,TRUE,TRUE,FALSE,FALSE,bidirectional,Up,"[('mission_report_id.full_view', '=', False), ('mission_report_id.local_report', '=', True), ('international_status','in',['Local', 'Temporary'])]","['central_qty', 'central_val', 'cross_qty', 'cross_val', 'cu_qty', 'cu_val', 'in_pipe_coor_qty', 'in_pipe_coor_val', 'in_pipe_qty', 'in_pipe_val', 'internal_qty', 'internal_val', 'mission_report_id/id', 'product_id/id', 'secondary_qty', 'secondary_val', 'stock_qty', 'stock_val', 'xmlid_code', 'product_state']",MISSION,stock.mission.report.line,,Mission Stock Report Line,Valid,,441
+msf_sync_data_server.mission_stock_report_line_OC,TRUE,TRUE,FALSE,FALSE,bidirectional,Up,"[('mission_report_id.full_view', '=', False), ('mission_report_id.local_report', '=', True), ('international_status','in',['ITC', 'UniData', 'ESC', 'HQ'])]","['central_qty', 'central_val', 'cross_qty', 'cross_val', 'cu_qty', 'cu_val', 'in_pipe_coor_qty', 'in_pipe_coor_val', 'in_pipe_qty', 'in_pipe_val', 'internal_qty', 'internal_val', 'mission_report_id/id', 'product_id/id', 'secondary_qty', 'secondary_val', 'stock_qty', 'stock_val', 'xmlid_code', 'product_state']",OC,stock.mission.report.line,,Mission Stock Report Line OC,Valid,,442
 msf_sync_data_server.financing_contract_formats_fc,TRUE,TRUE,FALSE,TRUE,bidirectional,Bidirectional-Private,[],"['cost_center_ids/id', 'eligibility_from_date', 'eligibility_to_date', 'format_name', 'overhead_percentage', 'overhead_type', 'reporting_type', 'hidden_instance_id/id']",HQ + MISSION,financing.contract.format,hidden_instance_id,Financing Contract Formats FC,Valid,,450
 msf_sync_data_server.financing_contract_formats,TRUE,TRUE,TRUE,TRUE,bidirectional,Bidirectional,"[('hidden_instance_id','=',False)]","['hidden_instance_id/id','cost_center_ids/id', 'eligibility_from_date', 'eligibility_to_date', 'format_name', 'overhead_percentage', 'overhead_type', 'reporting_type']",HQ + MISSION,financing.contract.format,,Financing Contract Formats,Valid,,451
 msf_sync_data_server.financing_contract_format_lines,TRUE,TRUE,TRUE,TRUE,bidirectional,Bidirectional,"[('instance_id', '=', False)]","['account_destination_ids/id', 'instance_id/id','allocated_budget_value', 'allocated_real_value', 'code', 'format_id/id', 'line_type', 'name', 'overhead_percentage', 'overhead_type', 'project_budget_value', 'project_real_value',  'is_quadruplet','quadruplet_update']",HQ + MISSION,financing.contract.format.line,,Financing Contract Format Lines,Valid,,452

=== modified file 'bin/addons/msf_tools/__init__.py'
--- bin/addons/msf_tools/__init__.py	2016-04-29 14:50:53 +0000
+++ bin/addons/msf_tools/__init__.py	2016-11-21 09:48:09 +0000
@@ -23,3 +23,4 @@
 import automated_import_function
 import automated_import
 import automated_import_job
+import report

=== modified file 'bin/addons/msf_tools/__openerp__.py'
--- bin/addons/msf_tools/__openerp__.py	2016-05-03 07:35:36 +0000
+++ bin/addons/msf_tools/__openerp__.py	2016-11-21 09:48:09 +0000
@@ -39,6 +39,8 @@
         'views/automated_import_function_view.xml',
         'views/automated_import_job_view.xml',
         'security/ir.model.access.csv',
+        'report/report_stopped_products_view.xml',
+        'report/report_stopped_products_report.xml',
         'automated_import_data.xml',
     ],
     'demo_xml': [

=== added directory 'bin/addons/msf_tools/report'
=== added file 'bin/addons/msf_tools/report/__init__.py'
--- bin/addons/msf_tools/report/__init__.py	1970-01-01 00:00:00 +0000
+++ bin/addons/msf_tools/report/__init__.py	2016-11-21 09:48:09 +0000
@@ -0,0 +1,22 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import report_stopped_products

=== added file 'bin/addons/msf_tools/report/report_stopped_products.py'
--- bin/addons/msf_tools/report/report_stopped_products.py	1970-01-01 00:00:00 +0000
+++ bin/addons/msf_tools/report/report_stopped_products.py	2016-11-21 09:48:09 +0000
@@ -0,0 +1,279 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+
+import time
+import threading
+from osv import fields
+from osv import osv
+from report import report_sxw
+from spreadsheet_xml.spreadsheet_xml_write import SpreadsheetReport
+from service.web_services import report_spool
+from tools.translate import _
+
+
+
+class export_report_stopped_products(osv.osv):
+
+    _name = 'export.report.stopped.products'
+    _order = 'name desc'
+
+    _columns = {
+        'name': fields.datetime(string='Generated On', readonly=True),
+        'state': fields.selection(
+            [('draft', 'Draft'),
+            ('in_progress', 'In Progress'),
+            ('ready', 'Ready')],
+            string='State',
+            readonly=True,
+        ),
+    }
+
+    _defaults = {
+        'state': lambda *a: 'draft',
+    }
+
+
+    def generate_report(self, cr, uid, ids, context=None):
+        '''
+        Generate a report of stopped products
+        Method is called by button on XML view (form)
+        '''
+        prod_obj = self.pool.get('product.product')
+        data_obj = self.pool.get('ir.model.data')
+
+        res = {}
+        for report in self.browse(cr, uid, ids, context=context):
+            # get ids of all non-local products :
+            status_local_id = data_obj.get_object_reference(cr, uid, 'product_attributes', 'int_4')[1]
+            product_ids = prod_obj.search(cr, uid, [('international_status', '!=', status_local_id)], context=context)
+            if not product_ids:
+                continue
+
+            # state of report is in progress :
+            self.write(cr, uid, [report.id], {
+                'name': time.strftime('%Y-%m-%d %H:%M:%S'), 
+                'state': 'in_progress'
+            }, context=context)
+
+            datas = {
+                'ids': [report.id],
+                'lines': product_ids,
+            }
+
+            cr.commit()
+            new_thread = threading.Thread(target=self.generate_report_bkg, args=(cr, uid, report.id, datas, context))
+            new_thread.start()
+            new_thread.join(timeout=30.0) # join = wait until new_thread is finished but if it last more then timeout value, you can continue to work
+
+            res = {
+                'type': 'ir.actions.act_window',
+                'res_model': self._name,
+                'view_type': 'form',
+                'view_mode': 'form,tree',
+                'res_id': report.id,
+                'context': context,
+                'target': 'same',
+            }
+
+            if new_thread.isAlive():
+                view_id = data_obj.get_object_reference(
+                    cr, uid,
+                    'msf_tools',
+                    'report_stopped_products_info_view')[1]
+                res['view_id'] = [view_id]
+
+        if not res:
+            raise osv.except_osv(
+                _('Error'),
+                _("Nothing to generate")
+            )
+
+        return res
+
+
+    def generate_report_bkg(self, cr, uid, report_ids, datas, context=None):
+        '''
+        Generate the report in background (thread)
+        '''
+        attachment_obj = self.pool.get('ir.attachment')
+
+        if context is None:
+            context ={}
+
+        if isinstance(report_ids, (int, long)):
+            report_ids = [report_ids]
+
+        import pooler
+        new_cr = pooler.get_db(cr.dbname).cursor()
+
+        # export datas :
+        report_name = "stopped.products.xls"
+        attachment_name = "stopped_products_report_%s.xls" % time.strftime('%d-%m-%Y_%Hh%M')
+        rp_spool = report_spool()
+        res_export = rp_spool.exp_report(cr.dbname, uid, report_name, report_ids, datas, context)
+        file_res = {'state': False}
+        while not file_res.get('state'):
+            file_res = rp_spool.exp_report_get(new_cr.dbname, uid, res_export)
+            time.sleep(0.5)
+
+        # attach report to the right panel :
+        attachment_obj.create(new_cr, uid, {
+            'name': attachment_name,
+            'datas_fname': attachment_name,
+            'description': "Stopped products",
+            'res_model': 'export.report.stopped.products',
+            'res_id': report_ids[0],
+            'datas': file_res.get('result'),
+        }, context=context)
+
+        # state is now 'ready' :
+        self.write(new_cr, uid, report_ids, {'state': 'ready'}, context= context)
+
+        new_cr.commit()
+        new_cr.close(True)
+
+        return True
+
+
+export_report_stopped_products()
+
+
+
+
+class parser_report_stopped_products_xls(report_sxw.rml_parse):
+    '''
+    To parse our mako template for stopped products
+    '''
+    def __init__(self, cr, uid, name, context=None):
+        super(parser_report_stopped_products_xls, self).__init__(cr, uid, name, context=context)
+
+        # localcontext allows you to call methods inside mako file :
+        self.localcontext.update({
+            'time': time,
+            'get_uf_stopped_products': self.get_uf_stopped_products,
+            'get_stock_mission_report_lines': self.get_stock_mission_report_lines,
+            'get_uf_status': self.get_uf_status,
+        })
+
+        self.status_buffer = {}
+
+
+    def get_uf_stopped_products(self):
+        '''
+        Return browse record list that contains stopped products
+        taking in account non-local/temp products stopped in the current instance,
+        and products in stock mission if they have qty in stock or in pipe
+        '''
+        prod_obj = self.pool.get('product.product')
+        data_obj = self.pool.get('ir.model.data')
+        smrl_obj = self.pool.get('stock.mission.report.line')
+
+        stopped_state_id = data_obj.get_object_reference(self.cr, self.uid, 'product_attributes', 'status_3')[1]
+        status_local_id = data_obj.get_object_reference(self.cr, self.uid, 'product_attributes', 'int_4')[1]
+        temporary_status_id = data_obj.get_object_reference(self.cr, self.uid, 'product_attributes', 'int_5')[1]
+
+        hq_stopped_ids = prod_obj.search(self.cr, self.uid, [
+            ('state', '=', stopped_state_id), 
+            ('international_status', '!=', status_local_id),
+            ('international_status', '!=', temporary_status_id)],
+            context=self.localcontext)
+
+        smrl_ids = smrl_obj.search(self.cr, self.uid, [
+            ('full_view', '=', False),
+            ('product_state', '=', 'stopped'),
+            '|', ('internal_qty', '!=', 0),
+            ('in_pipe_qty', '!=', 0)
+        ], context=self.localcontext)
+
+        sm_stopped_ids = smrl_obj.read(self.cr, self.uid, smrl_ids, ['product_id'], context=self.localcontext)
+        sm_stopped_ids = [x.get('product_id')[0] for x in sm_stopped_ids]
+
+        # build a list of stopped products with unique ids and sorted by default_code:
+        stopped_ids = list(set(hq_stopped_ids + sm_stopped_ids))
+        ls = []
+        for prod in prod_obj.browse(self.cr, self.uid, stopped_ids, context=self.localcontext):
+            ls.append( (prod.id, prod.default_code) )
+        sorted_stopped_ids = [x[0] for x in sorted(ls, key=lambda tup: tup[1])]
+
+        return prod_obj.browse(self.cr, self.uid, sorted_stopped_ids, context=self.localcontext)
+
+
+    def get_stock_mission_report_lines(self, product):
+        '''
+        Return browse record list of stock_mission_report_line with given product_id
+        '''
+        data_obj = self.pool.get('ir.model.data')
+        smrl_obj = self.pool.get('stock.mission.report.line')
+        smrl_ids = smrl_obj.search(self.cr, self.uid, [('product_id', '=', product.id)], context=self.localcontext)
+
+        stopped_state_id = data_obj.get_object_reference(self.cr, self.uid, 'product_attributes', 'status_3')[1]
+
+        res = [smrl for smrl in smrl_obj.browse(self.cr, self.uid, smrl_ids, context=self.localcontext) if \
+                not smrl.full_view and (smrl.product_state == 'stopped' or product.state.id == stopped_state_id) and (smrl.internal_qty != 0 or smrl.in_pipe_qty != 0)]
+
+        return res
+
+
+    def get_uf_status(self, code):
+        '''
+        Return the name of the unifield status with the given code
+        '''
+        if code in self.status_buffer:
+            return self.status_buffer[code]
+
+        status_obj = self.pool.get('product.status')
+        code_ids = status_obj.search(self.cr, self.uid, [('code', '=', code)], context=self.localcontext)
+        res = ""
+        if code_ids:
+            res = status_obj.read(self.cr, self.uid, code_ids, ['name'])[0]['name']
+
+        self.status_buffer[code] = res
+
+        return res
+
+
+
+class report_stopped_products_xls(SpreadsheetReport):
+
+    def __init(self, name, table, rml=False, parser=report_sxw.rml_parse, header='external', store=False):
+        super(report_stopped_products_xls, self).__init__(
+            name,
+            table,
+            rml=rml,
+            parser=parser,
+            header=header,
+            store=store
+        )
+
+    def create(self, cr, uid, ids, data, context=None):
+        a = super(report_stopped_products_xls, self).create(cr, uid, ids, data, context=context)
+        return (a[0], 'xls')
+
+
+
+report_stopped_products_xls(
+    'report.stopped.products.xls',
+    'export.report.stopped.products',
+    'addons/msf_tools/report/report_stopped_products_xls.mako',
+    parser=parser_report_stopped_products_xls,
+    header='internal',
+)

=== added file 'bin/addons/msf_tools/report/report_stopped_products_report.xml'
--- bin/addons/msf_tools/report/report_stopped_products_report.xml	1970-01-01 00:00:00 +0000
+++ bin/addons/msf_tools/report/report_stopped_products_report.xml	2016-11-21 09:48:09 +0000
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+
+        <report
+            id="report_stopped_products_xls"
+            string="Stopped products"
+            model="export.report.stopped.products"
+            name="stopped.products.xls"
+            file="msf_tools/report/report_stopped_products_xls.mako"
+            report_type="webkit"
+            header="False"
+            auto="False"
+            menu="False"
+            />
+
+
+    </data>
+</openerp>
\ No newline at end of file

=== added file 'bin/addons/msf_tools/report/report_stopped_products_view.xml'
--- bin/addons/msf_tools/report/report_stopped_products_view.xml	1970-01-01 00:00:00 +0000
+++ bin/addons/msf_tools/report/report_stopped_products_view.xml	2016-11-21 09:48:09 +0000
@@ -0,0 +1,92 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+
+
+        <record id="export_report_stopped_products_form_view" model="ir.ui.view">
+            <field name="name">export.report.stopped.products.form.view</field>
+            <field name="model">export.report.stopped.products</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Export Stopped Products">
+                    <separator colspan="4" string="Request information" />
+                    <field name="name" />
+                    <field name="state" />
+                    <button name="generate_report" type="object" string="Generate report" 
+                        icon="gtk-execute" states='draft' />
+                </form>
+            </field>
+        </record>
+
+
+        <record id="export_report_stopped_products_tree_view" model="ir.ui.view">
+            <field name="name">export.report.stopped.products.tree.view</field>
+            <field name="model">export.report.stopped.products</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Export Stopped Products">
+                    <field name="name" />
+                    <field name="state" />
+                </tree>
+            </field>
+        </record>
+
+
+        <record id="report_stopped_product_search_view" model="ir.ui.view">
+            <field name="name">export.report.stopped.products.search.view</field>
+            <field name="model">export.report.stopped.products</field> <!-- _name of openERP object -->
+            <field name="type">search</field>
+            <field name="arch" type="xml">
+                <search string="Export Stopped Products">
+                    <field name="name" />
+                    <field name="state" />
+                </search>
+            </field>
+        </record>
+
+
+        <record id="report_stopped_products_info_view" model="ir.ui.view">
+            <field name="name">export.report.stopped.products.info.view</field>
+            <field name="model">export.report.stopped.products</field>
+            <field name="type">form</field>
+            <field name="priority" eval="99" />
+            <field name="arch" type="xml">
+                <form string="Status of the report" hide_new_button="1" hide_delete_button="1">
+                    <label> </label>                                                
+                    <group colspan="2" col="2">                                     
+                        <html>                                                      
+                            <div style="align: center">                             
+                                <p style="font-size:14px;align:center">             
+                                    Your export inventory level demand will be treated quickly.<br />
+                                </p>                                                
+                                <p style="font-size:14px;align:center">             
+                                    Due to the volume of data, your report cannot be shown immediatly.<br />
+                                </p>                                                
+                                <p style="font-size:14px;align:center">             
+                                    When the report will be ready, you can access to it by the menu Tools / Export Stopped Products.<br />
+                                </p>                                                
+                            </div>                                                  
+                        </html>                                                     
+                    </group>                                                        
+                    <label> </label>                                                
+                </form>
+            </field>
+        </record>
+
+
+        <record id="export_report_stopped_products_action" model="ir.actions.act_window">
+            <field name="name">Export Stopped Products</field>
+            <field name="res_model">export.report.stopped.products</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+        </record>
+
+        
+        <menuitem
+            id="export_report_stopped_products_menu"
+            action="export_report_stopped_products_action"
+            parent="object_query.menu_preferences"
+            sequence="51" />
+
+    </data>
+</openerp>
\ No newline at end of file

=== added file 'bin/addons/msf_tools/report/report_stopped_products_xls.mako'
--- bin/addons/msf_tools/report/report_stopped_products_xls.mako	1970-01-01 00:00:00 +0000
+++ bin/addons/msf_tools/report/report_stopped_products_xls.mako	2016-11-21 09:48:09 +0000
@@ -0,0 +1,140 @@
+<?xml version="1.0"?>
+<?mso-application progid="Excel.Sheet"?>
+<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
+ xmlns:o="urn:schemas-microsoft-com:office:office"
+ xmlns:x="urn:schemas-microsoft-com:office:excel"
+ xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
+ xmlns:html="http://www.w3.org/TR/REC-html40">
+ <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
+  <Author>MSFUser</Author>
+  <LastAuthor>MSFUser</LastAuthor>
+  <Created>2012-06-18T15:46:09Z</Created>
+  <Company>Medecins Sans Frontieres</Company>
+  <Version>11.9999</Version>
+</DocumentProperties>
+<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
+  <WindowHeight>13170</WindowHeight>
+  <WindowWidth>19020</WindowWidth>
+  <WindowTopX>120</WindowTopX>
+  <WindowTopY>60</WindowTopY>
+  <ProtectStructure>False</ProtectStructure>
+  <ProtectWindows>False</ProtectWindows>
+</ExcelWorkbook>
+
+<Styles>
+  <Style ss:ID="tab_header_orange">
+    <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
+    <Interior ss:Color="#ffcc99" ss:Pattern="Solid"/>
+    <Borders>
+      <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" />
+      <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" />
+      <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" />
+      <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" />
+    </Borders>
+  </Style>
+  <Style ss:ID="tab_header_gray">
+    <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
+    <Interior ss:Color="#dbdbdb" ss:Pattern="Solid"/>
+    <Borders>
+      <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" />
+      <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" />
+      <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" />
+      <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" />
+    </Borders>
+  </Style>
+  <Style ss:ID="tab_content">
+    <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
+    <Borders>
+      <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" />
+      <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" />
+      <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" />
+      <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" />
+    </Borders>
+  </Style>
+</Styles>
+
+
+<ss:Worksheet ss:Name="Stopped products">
+
+  <Table x:FullColumns="1" x:FullRows="1">
+
+    <Columns ss:AutoFitWidth="1" ss:Width="90" /> # product code
+    <Columns ss:AutoFitWidth="1" ss:Width="200" /> # product description
+    <Columns ss:AutoFitWidth="1" ss:Width="90" /> # product creator
+    <Columns ss:AutoFitWidth="1" ss:Width="90" /> # standardization level
+    <Columns ss:AutoFitWidth="1" ss:Width="90" /> # unidata status
+
+    ##### Table with all stopped products #####
+
+    <% stopped_products = get_uf_stopped_products() %>
+    % if not stopped_products:
+        <Row ss:AutoFitHeight="1">
+          <Cell ss:StyleID="tab_content"><Data ss:Type="String"></Data></Cell>
+          <Cell ss:StyleID="tab_content"><Data ss:Type="String">There is no stopped products to report</Data></Cell>
+        </Row>
+    % endif
+    
+    % for line in stopped_products:
+        <Row ss:AutoFitHeight="1">
+          <Cell ss:StyleID="tab_header_orange"><Data ss:Type="String">Code</Data></Cell>
+          <Cell ss:StyleID="tab_header_orange"><Data ss:Type="String">Description</Data></Cell>
+          <Cell ss:StyleID="tab_header_orange"><Data ss:Type="String">Product Creator</Data></Cell>
+          <Cell ss:StyleID="tab_header_orange"><Data ss:Type="String">Standardization Level</Data></Cell>
+          <Cell ss:StyleID="tab_header_orange"><Data ss:Type="String">Unidata Status</Data></Cell>
+        </Row>
+
+        <% standard_level = 'Standard' if line.standard_ok == 'True' else 'Non-standard' %>
+        <Row ss:AutoFitHeight="1">
+          <Cell ss:StyleID="tab_content"><Data ss:Type="String">${(line.default_code)|x}</Data></Cell>
+          <Cell ss:StyleID="tab_content"><Data ss:Type="String">${(line.name_template)|x}</Data></Cell>
+          <Cell ss:StyleID="tab_content"><Data ss:Type="String">${(line.international_status and line.international_status.name or '')|x}</Data></Cell>
+          <Cell ss:StyleID="tab_content"><Data ss:Type="String">${(standard_level)|x}</Data></Cell>
+          <Cell ss:StyleID="tab_content"><Data ss:Type="String">${(line.state_ud and getSel(line, 'state_ud') or '')|x}</Data></Cell>
+        </Row>
+
+        <% smrl_list = get_stock_mission_report_lines(line) %>
+        <Row ss:AutoFitHeight="1">
+          <Cell ss:StyleID="tab_header_gray"><Data ss:Type="String">Instance/Mission</Data></Cell>
+          <Cell ss:StyleID="tab_header_gray"><Data ss:Type="String">Unifield Status</Data></Cell>
+          <Cell ss:StyleID="tab_header_gray"><Data ss:Type="String">Instance stock</Data></Cell>
+          <Cell ss:StyleID="tab_header_gray"><Data ss:Type="String">Pipeline Qty</Data></Cell>
+        </Row>
+        % for smrl in smrl_list:
+            <Row ss:AutoFitHeight="1">
+              <Cell ss:StyleID="tab_content"><Data ss:Type="String">${(smrl.mission_report_id.name)|x}</Data></Cell>
+              <Cell ss:StyleID="tab_content"><Data ss:Type="String">${(get_uf_status(smrl.product_state))|x}</Data></Cell>
+              <Cell ss:StyleID="tab_content"><Data ss:Type="Number">${(smrl.internal_qty)|x}</Data></Cell>
+              <Cell ss:StyleID="tab_content"><Data ss:Type="Number">${(smrl.in_pipe_qty)|x}</Data></Cell>
+            </Row>
+        % endfor
+            <Row></Row>
+            <Row></Row>
+    % endfor
+
+  </Table>
+
+  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
+   <PageSetup>
+    <Layout x:Orientation="Landscape"/>
+    <Header x:Data="&amp;C&amp;&quot;Arial,Bold&quot;&amp;14"/>
+    <Footer x:Data="Page &amp;P of &amp;N"/>
+  </PageSetup>
+  <Print>
+    <ValidPrinterInfo/>
+    <PaperSizeIndex>9</PaperSizeIndex>
+    <HorizontalResolution>600</HorizontalResolution>
+    <VerticalResolution>600</VerticalResolution>
+  </Print>
+  <Selected/>
+  <Panes>
+    <Pane>
+     <Number>3</Number>
+     <ActiveRow>17</ActiveRow>
+   </Pane>
+ </Panes>
+ <ProtectObjects>False</ProtectObjects>
+ <ProtectScenarios>False</ProtectScenarios>
+</WorksheetOptions>
+</ss:Worksheet>
+
+</Workbook>

=== modified file 'bin/addons/product_attributes/product_attributes.py'
--- bin/addons/product_attributes/product_attributes.py	2016-09-28 08:24:48 +0000
+++ bin/addons/product_attributes/product_attributes.py	2016-11-21 09:48:09 +0000
@@ -1261,6 +1261,8 @@
         if not ids:
             return True
         data_obj = self.pool.get('ir.model.data')
+        smrl_obj = self.pool.get('stock.mission.report.line')
+        prod_status_obj = self.pool.get('product.status')
 
         if context is None:
             context = {}
@@ -1290,6 +1292,18 @@
                         _('White spaces are not allowed in product code'),
                     )
 
+        # update local stock mission report lines :
+        if 'state' in vals:
+            prod_state = ''
+            if vals['state']:
+                state_id = vals['state']
+                if isinstance(state_id, (int, long)):
+                    state_id = [state_id]
+                prod_state = prod_status_obj.read(cr, uid, state_id, ['code'], context=context)[0]['code']
+            local_smrl_ids = smrl_obj.search(cr, uid, [('product_state', '!=', prod_state), ('product_id', 'in', ids), ('full_view', '=', False), ('mission_report_id.local_report', '=', True)], context=context)
+            if local_smrl_ids:
+                smrl_obj.write(cr, uid, local_smrl_ids, {'product_state': prod_state}, context=context)
+                
         product_uom_categ = []
         if 'uom_id' in vals or 'uom_po_id' in vals:
             if isinstance(ids, (int, long)):