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

[jftempo]

=== modified file 'bin/addons/base/ir/ir_actions.py'
--- bin/addons/base/ir/ir_actions.py	2021-10-12 16:20:20 +0000
+++ bin/addons/base/ir/ir_actions.py	2022-07-13 15:38:28 +0000
@@ -373,6 +373,8 @@
         if not new_tab:
             res['target'] = 'crush'
         return res
+
+
 act_window()
 
 class act_window_view(osv.osv):

=== modified file 'bin/addons/base/ir/ir_values.py'
--- bin/addons/base/ir/ir_values.py	2021-08-20 10:32:29 +0000
+++ bin/addons/base/ir/ir_values.py	2022-07-13 15:38:28 +0000
@@ -237,11 +237,23 @@
         # for the admin only add the "Update Sent / Received" links in the menu on the right for all synched objects
         if key == 'action' and key2 == 'client_action_relate' and uid == 1 and self.pool.get('update.link') and models:
             obj_model = models[0][0]
+            act_to_add = []
             if self.pool.get('sync.client.rule').search_exist(cr, uid, [('model', '=', obj_model), ('type', '!=', 'USB')]):
                 act_sent_id = self.pool.get('ir.model.data').get_object_reference(cr, uid, 'sync_client', 'action_open_updates_sent')[1]
-                result.append((act_sent_id, 'Updates_Sent', u'ir.actions.server,%d' % act_sent_id, True, None, u'action'))
+                act_to_add.append((act_sent_id, 'Updates_Sent', u'ir.actions.server,%d' % act_sent_id, True, None, u'action'))
                 act_rcv_id = self.pool.get('ir.model.data').get_object_reference(cr, uid, 'sync_client', 'action_open_updates_received')[1]
-                result.append((act_rcv_id, 'Updates_Received', u'ir.actions.server,%d' % act_rcv_id, True, None, u'action'))
+                act_to_add.append((act_rcv_id, 'Updates_Received', u'ir.actions.server,%d' % act_rcv_id, True, None, u'action'))
+
+                if obj_model == 'product.product':
+                    # on product updates links are not at the end
+                    new_res = []
+                    for x in result:
+                        new_res.append(x)
+                        if x[1] == u'View_log_product.product':
+                            new_res += act_to_add
+                    result = new_res
+                else:
+                    result += act_to_add
 
         if not result:
             return []

=== modified file 'bin/addons/msf_outgoing/msf_outgoing_view.xml'
--- bin/addons/msf_outgoing/msf_outgoing_view.xml	2022-03-09 10:33:36 +0000
+++ bin/addons/msf_outgoing/msf_outgoing_view.xml	2022-07-13 15:38:28 +0000
@@ -467,6 +467,7 @@
 						<field name="reason_type_id" widget="selection" domain="[('outgoing_ok', '=', True)]" />
 						<field name="date" />
 						<field name="min_date" />
+						<field name="product_id" />
                     </group>
                     <newline />
                     <group string="State of lines" col="8" colspan="4">
@@ -803,8 +804,10 @@
                         <field name="order_category" />
 						<field name="reason_type_id" widget="selection" />
 						<field name="company_id" widget="selection" groups="base.group_multi_company"/>
+                        <newline/>
 						<field name="date" />
 						<field name="min_date" />
+						<field name="product_id" />
 					</group>
 					<newline/>
 					<group expand="0" string="Group By..." colspan="4" col="8">

=== modified file 'bin/addons/msf_profile/i18n/fr_MF.po'
--- bin/addons/msf_profile/i18n/fr_MF.po	2022-07-11 08:43:43 +0000
+++ bin/addons/msf_profile/i18n/fr_MF.po	2022-07-13 15:38:28 +0000
@@ -10568,11 +10568,12 @@
 msgid "Lists/Sublists"
 msgstr "Listes/Sous-listes"
 
-#. modules: sale, useability_dashboard_and_menu
+#. modules: sale, useability_dashboard_and_menu, product_attributes
 #: view:sale.report:0
 #: view:sale.order:0
+#: model:ir.actions.server,name:product_attributes.action_product_fo_tree
 msgid "Field Orders"
-msgstr "Commandes du terrain"
+msgstr "Commandes de Terrain"
 
 #. modules: purchase_msf, purchase_override
 #: field:purchase.order.line,internal_name:0
@@ -12144,11 +12145,6 @@
 msgid "Draft statement"
 msgstr "Relevé sous statut brouillon"
 
-#. module: product_attributes
-#: model:ir.actions.act_window,name:product_attributes.action_order_line_product_tree
-msgid "Field orders"
-msgstr "Commandes de terrain"
-
 #. module: tender_flow
 #: selection:tender,internal_state:0
 msgid "Rfq Updated"
@@ -17168,7 +17164,7 @@
 msgstr "Employé - Etat civil "
 
 #. modules: product_attributes, tender_flow, sales_followup
-#: model:ir.actions.act_window,name:product_attributes.action_tender_product_tree
+#: model:ir.actions.server,name:product_attributes.action_product_tender_tree
 #: view:sale.order.line.followup:0
 #: model:ir.actions.act_window,name:tender_flow.tender_action
 #: model:ir.ui.menu,name:tender_flow.menu_tender
@@ -23027,7 +23023,7 @@
 msgid "Pacific/Easter"
 msgstr "Pacific/Easter"
 
-#. modules: purchase, msf_outgoing, useability_dashboard_and_menu, stock
+#. modules: purchase, msf_outgoing, useability_dashboard_and_menu, stock, product_attributes
 #: view:purchase.order:0
 #: model:ir.actions.act_window,name:stock.action_picking_tree
 #: model:ir.ui.menu,name:stock.menu_action_picking_tree
@@ -23037,6 +23033,7 @@
 #: code:addons/msf_outgoing/wizard/internal_move_processor.py:185
 #: code:addons/msf_outgoing/wizard/internal_move_processor.py:205
 #: code:addons/msf_outgoing/wizard/outgoing_delivery_processor.py:104
+#: model:ir.actions.server,name:product_attributes.action_product_out_tree
 #, python-format
 msgid "Delivery Orders"
 msgstr "Bons de Livraison"
@@ -39331,9 +39328,10 @@
 msgid "Cross-docking Val."
 msgstr "Transbordement - Valeur."
 
-#. module: tender_flow
+#. module: tender_flow, product_attributes
 #: view:tender:0
 #: field:tender,rfq_ids:0
+#: model:ir.actions.server,name:product_attributes.action_product_rfq_tree
 msgid "RfQs"
 msgstr "DdD"
 
@@ -69281,7 +69279,7 @@
 msgid "Display graph"
 msgstr "Affichage du Graphique"
 
-#. modules: purchase, useability_dashboard_and_menu, stock, msf_outgoing
+#. modules: purchase, useability_dashboard_and_menu, stock, msf_outgoing, product_attributes
 #: code:addons/msf_outgoing/wizard/internal_move_processor.py:183
 #: model:ir.ui.menu,name:purchase.menu_action_picking_tree4
 #: model:ir.actions.act_window,name:stock.action_picking_tree4
@@ -69289,6 +69287,7 @@
 #: view:stock.picking:0
 #: view:board.board:0
 #: model:ir.actions.act_window,name:useability_dashboard_and_menu.action_picking_tree_available
+#: model:ir.actions.server,name:product_attributes.action_product_in_tree
 #, python-format
 msgid "Incoming Shipments"
 msgstr "Livraisons Entrantes"
@@ -78816,12 +78815,13 @@
 msgid "Subtotal (functional currency)"
 msgstr "Sous-Total (devise fonctionnelle)"
 
-#. modules: stock, msf_outgoing
+#. modules: stock, msf_outgoing, product_attributes
 #: code:addons/msf_outgoing/wizard/internal_move_processor.py:184
 #: model:ir.actions.act_window,name:stock.action_picking_tree6
 #: model:ir.ui.menu,name:stock.menu_action_picking_tree6
 #: view:stock.picking:0
 #: field:stock.picking,move_lines:0
+#: model:ir.actions.server,name:product_attributes.action_product_int_tree
 #, python-format
 msgid "Internal Moves"
 msgstr "Mouvements Internes"
@@ -79431,9 +79431,10 @@
 msgid "You do not have access to the field (%s). If you did not edit this field, please let an OpenERP administrator know about this error message, and the field name."
 msgstr "You do not have access to the field (%s). If you did not edit this field, please let an OpenERP administrator know about this error message, and the field name."
 
-#. module: procurement_request
+#. module: procurement_request, product_attributes
 #: model:ir.actions.act_window,name:procurement_request.action_procurement_request
 #: model:ir.ui.menu,name:procurement_request.menu_procurement_request
+#: model:ir.actions.server,name:product_attributes.action_product_ir_tree
 #: view:sale.order:0
 msgid "Internal Requests"
 msgstr "Demandes Internes"
@@ -82989,6 +82990,7 @@
 #: field:view.expired.expiring.stock.lines,product_id:0
 #: field:account.commitment.line,line_product_id:0
 #: field:product.ed_bn.mass.update.history,product_id:0
+#: field:stock.picking,product_id:0
 #, python-format
 msgid "Product"
 msgstr "Produit"
@@ -87933,7 +87935,7 @@
 #: view:account.analytic.line:0
 #: field:analytic.distribution,purchase_ids:0
 #: model:ir.ui.menu,name:base.menu_purchase_root
-#: model:ir.actions.act_window,name:purchase.action_purchase_line_product_tree2
+#: model:ir.actions.server,name:product_attributes.action_product_po_tree
 msgid "Purchases"
 msgstr "Achats"
 
@@ -115351,6 +115353,7 @@
 #, python-format
 msgid "Cannot update these products, ED/BN attributes have not changed since the KCL creation"
 msgstr "Impossible de mettre à jour ces produits. Les attributs NL/DE n'ont pas changé depuis la création du Kit"
+<<<<<<< TREE
 
 #. module: board
 #: report:addons/board/report/integrity.mako:83
@@ -115652,3 +115655,23 @@
 msgid "This report is an analysis done by employee. It is a report containing one line per employee representing the cumulative credit balance."
 msgstr "Ce rapport est une analyse effectuée par employé. Il s'agit d'un rapport contenant une ligne par employé et représentant le solde créditeur cumulé."
 
+=======
+
+#. modules: purchase, tender_flow, sale, stock
+#: help:purchase.order,product_id:0
+#: help:sale.order,product_id:0
+#: help:stock.picking,product_id:0
+#: help:tender,product_id:0
+msgid "Product to find in the lines"
+msgstr "Produit à trouver dans les lignes"
+
+#. module: product_attributes
+#: model:ir.actions.server,name:product_attributes.action_product_pick_tree
+msgid "Pickings"
+msgstr "Pickings"
+
+#. module: product_attributes
+#: model:ir.actions.server,name:product_attributes.action_product_pack_tree
+msgid "Packings"
+msgstr "Colisages"
+>>>>>>> MERGE-SOURCE

=== modified file 'bin/addons/procurement_request/procurement_request_view.xml'
--- bin/addons/procurement_request/procurement_request_view.xml	2022-05-18 11:32:30 +0000
+++ bin/addons/procurement_request/procurement_request_view.xml	2022-07-13 15:38:28 +0000
@@ -173,19 +173,18 @@
             <field name="priority" eval="250" />
             <field name="arch" type="xml">
                 <search string="Internal Requests">
-                    <group string="Filters" expand="1">
-                        <filter name="state_proc" string="Draft" icon="terp-document-new" domain="[('state', 'in', ['draft','draft_p'])]" />
-                        <filter name="state_valid" string="Validated" icon="terp-check" domain="[('state', 'in', ['validated','validated_p'])]" />
-                        <filter name="sourced" string="Sourced" icon="gtk-paste-v" domain="[('state','in',['sourced','sourced_p'])]" />
-                        <filter name="state_proc_progress" string="Confirmed" icon="terp-camera_test" domain="[('state', 'in', ('confirmed', 'confirmed_p'))]" />
-                        <filter name="state_done" string="Closed" icon="terp-dialog-close" domain="[('state', '=', 'done')]" />
-                        <filter name="cancelled" string="Cancelled" icon="gtk-cancel" domain="[('state', '=', 'cancel')]" />
-                        <separator orientation="vertical" />
-                        <field name="name" />
-                        <field name="origin" />
-                        <field name="requestor" />
-                        <field name="location_requestor_id" />
-                    </group>
+                    <filter name="state_proc" string="Draft" icon="terp-document-new" domain="[('state', 'in', ['draft','draft_p'])]" />
+                    <filter name="state_valid" string="Validated" icon="terp-check" domain="[('state', 'in', ['validated','validated_p'])]" />
+                    <filter name="sourced" string="Sourced" icon="gtk-paste-v" domain="[('state','in',['sourced','sourced_p'])]" />
+                    <filter name="state_proc_progress" string="Confirmed" icon="terp-camera_test" domain="[('state', 'in', ('confirmed', 'confirmed_p'))]" />
+                    <filter name="state_done" string="Closed" icon="terp-dialog-close" domain="[('state', '=', 'done')]" />
+                    <filter name="cancelled" string="Cancelled" icon="gtk-cancel" domain="[('state', '=', 'cancel')]" />
+                    <separator orientation="vertical" />
+                    <field name="name" />
+                    <field name="origin" />
+                    <field name="requestor" />
+                    <field name="location_requestor_id" />
+                    <field name="product_id" />
                     <newline />
                     <group string="Group By...">
                         <filter string="State" icon="terp-gtk-select-all" domain="[]" context="{'group_by': 'state'}" />
@@ -216,7 +215,7 @@
             <field name="res_model">sale.order</field>
             <field name="view_type">form</field>
             <field name="view_mode">tree,form</field>
-            <field name="view_search_id" ref="procurement_request_search_view" />
+            <field name="search_view_id" ref="procurement_request_search_view" />
             <field name="context">{'procurement_request': True}</field>
             <field name="domain">[('procurement_request', '=', True)]</field>
         </record>

=== modified file 'bin/addons/product/product.py'
--- bin/addons/product/product.py	2021-08-06 15:49:01 +0000
+++ bin/addons/product/product.py	2022-07-13 15:38:28 +0000
@@ -27,6 +27,7 @@
 import re
 from tools.translate import _
 from tools import cache
+from tools.safe_eval import safe_eval
 
 def is_pair(x):
     return not x%2
@@ -893,9 +894,29 @@
                     res.update({'value': {'list_price': list_price}})
         return res
 
+    def view_docs_with_product(self, cr, uid, ids, menu_action, context=None):
+        '''
+        Get info from the given menu action to return the right view with the right data
+        '''
+
+        if context is None:
+            context = {}
+
+        res = self.pool.get('ir.actions.act_window').open_view_from_xmlid(cr, uid, menu_action, ['tree', 'form'], new_tab=True, context=context)
+
+        res_context = res.get('context', False) and safe_eval(res['context']) or {}
+        for col in res_context:  # Remove the default filters
+            if 'search_default_' in col:
+                res_context[col] = False
+        res_context['search_default_product_id'] = context.get('active_id', False)
+        res['context'] = res_context
+
+        return res
+
 
 product_product()
 
+
 class product_packaging(osv.osv):
     _name = "product.packaging"
     _description = "Packaging"

=== modified file 'bin/addons/product_attributes/product_attributes_view.xml'
--- bin/addons/product_attributes/product_attributes_view.xml	2021-12-07 15:12:27 +0000
+++ bin/addons/product_attributes/product_attributes_view.xml	2022-07-13 15:38:28 +0000
@@ -542,22 +542,196 @@
             </field>
         </record>
 
-        <act_window
-            context="{}"
-            domain="[('procurement_request', '=', False), ('product_id', '=', active_id)]"
-            id="action_order_line_product_tree"
-            name="Field orders"
-            res_model="sale.order"
-            src_model="product.product" />
-
-        <act_window
-            context="{}"
-            domain="[('product_id', '=', active_id)]"
-            id="action_tender_product_tree"
-            name="Tenders"
-            res_model="tender"
-            src_model="product.product" />
-
+        <!-- List of actions at the bottom of the list, the dashed line-break is located on the web's side -->
+        <!-- FO -->
+        <record id="action_product_fo_tree" model="ir.actions.server">
+            <field name="name">Field Orders</field>
+            <field name="model_id" ref="product.model_product_product"/>
+            <field name="state">code</field>
+            <field name="code">
+action = self.view_docs_with_product(cr, uid, ids, menu_action='sale.action_order_form', context=context)
+            </field>
+        </record>
+
+        <record id="open_product_fo_tree" model="ir.values">
+            <field name="key2">client_action_relate</field>
+            <field name="model">product.product</field>
+            <field name="name">Field Orders</field>
+            <field name="value" eval="'ir.actions.server,%d'%action_product_fo_tree"/>
+            <field name="object" eval="True"/>
+            <field name="sequence" eval="100001"/>
+        </record>
+
+        <!-- IR -->
+        <record id="action_product_ir_tree" model="ir.actions.server">
+            <field name="name">Internal Requests</field>
+            <field name="model_id" ref="product.model_product_product"/>
+            <field name="state">code</field>
+            <field name="code">
+action = self.view_docs_with_product(cr, uid, ids, menu_action='procurement_request.action_procurement_request', context=context)
+            </field>
+        </record>
+
+        <record id="open_product_ir_tree" model="ir.values">
+            <field name="key2">client_action_relate</field>
+            <field name="model">product.product</field>
+            <field name="name">Internal Requests</field>
+            <field name="value" eval="'ir.actions.server,%d'%action_product_ir_tree"/>
+            <field name="object" eval="True"/>
+            <field name="sequence" eval="100002"/>
+        </record>
+
+        <!-- PO -->
+        <record id="action_product_po_tree" model="ir.actions.server">
+            <field name="name">Purchases</field>
+            <field name="model_id" ref="product.model_product_product"/>
+            <field name="state">code</field>
+            <field name="code">
+action = self.view_docs_with_product(cr, uid, ids, menu_action='purchase.purchase_form_action', context=context)
+            </field>
+        </record>
+
+        <record id="open_product_po_tree" model="ir.values">
+            <field name="key2">client_action_relate</field>
+            <field name="model">product.product</field>
+            <field name="name">Purchases</field>
+            <field name="value" eval="'ir.actions.server,%d'%action_product_po_tree"/>
+            <field name="object" eval="True"/>
+            <field name="sequence" eval="100003"/>
+        </record>
+
+        <!-- RfQ -->
+        <record id="action_product_rfq_tree" model="ir.actions.server">
+            <field name="name">RfQs</field>
+            <field name="model_id" ref="product.model_product_product"/>
+            <field name="state">code</field>
+            <field name="code">
+action = self.view_docs_with_product(cr, uid, ids, menu_action='purchase.purchase_rfq', context=context)
+            </field>
+        </record>
+
+        <record id="open_product_rfq_tree" model="ir.values">
+            <field name="key2">client_action_relate</field>
+            <field name="model">product.product</field>
+            <field name="name">RfQs</field>
+            <field name="value" eval="'ir.actions.server,%d'%action_product_rfq_tree"/>
+            <field name="object" eval="True"/>
+            <field name="sequence" eval="100004"/>
+        </record>
+
+        <!-- Tender -->
+        <record id="action_product_tender_tree" model="ir.actions.server">
+            <field name="name">Tenders</field>
+            <field name="model_id" ref="product.model_product_product"/>
+            <field name="state">code</field>
+            <field name="code">
+action = self.view_docs_with_product(cr, uid, ids, menu_action='tender_flow.tender_action', context=context)
+            </field>
+        </record>
+
+        <record id="open_product_tender_tree" model="ir.values">
+            <field name="key2">client_action_relate</field>
+            <field name="model">product.product</field>
+            <field name="name">Tenders</field>
+            <field name="value" eval="'ir.actions.server,%d'%action_product_tender_tree"/>
+            <field name="object" eval="True"/>
+            <field name="sequence" eval="100005"/>
+        </record>
+
+        <!-- IN -->
+        <record id="action_product_in_tree" model="ir.actions.server">
+            <field name="name">Incoming Shipments</field>
+            <field name="model_id" ref="product.model_product_product"/>
+            <field name="state">code</field>
+            <field name="code">
+action = self.view_docs_with_product(cr, uid, ids, menu_action='stock.action_picking_tree4', context=context)
+            </field>
+        </record>
+
+        <record id="open_product_in_tree" model="ir.values">
+            <field name="key2">client_action_relate</field>
+            <field name="model">product.product</field>
+            <field name="name">Incoming Shipments</field>
+            <field name="value" eval="'ir.actions.server,%d'%action_product_in_tree"/>
+            <field name="object" eval="True"/>
+            <field name="sequence" eval="100006"/>
+        </record>
+
+        <!-- INT -->
+        <record id="action_product_int_tree" model="ir.actions.server">
+            <field name="name">Internal Moves</field>
+            <field name="model_id" ref="product.model_product_product"/>
+            <field name="state">code</field>
+            <field name="code">
+action = self.view_docs_with_product(cr, uid, ids, menu_action='stock.action_picking_tree6', context=context)
+            </field>
+        </record>
+
+        <record id="open_product_int_tree" model="ir.values">
+            <field name="key2">client_action_relate</field>
+            <field name="model">product.product</field>
+            <field name="name">Internal Moves</field>
+            <field name="value" eval="'ir.actions.server,%d'%action_product_int_tree"/>
+            <field name="object" eval="True"/>
+            <field name="sequence" eval="100007"/>
+        </record>
+
+        <!-- OUT -->
+        <record id="action_product_out_tree" model="ir.actions.server">
+            <field name="name">Delivery Orders</field>
+            <field name="model_id" ref="product.model_product_product"/>
+            <field name="state">code</field>
+            <field name="code">
+action = self.view_docs_with_product(cr, uid, ids, menu_action='stock.action_picking_tree', context=context)
+            </field>
+        </record>
+
+        <record id="open_product_out_tree" model="ir.values">
+            <field name="key2">client_action_relate</field>
+            <field name="model">product.product</field>
+            <field name="name">Delivery Orders</field>
+            <field name="value" eval="'ir.actions.server,%d'%action_product_out_tree"/>
+            <field name="object" eval="True"/>
+            <field name="sequence" eval="100008"/>
+        </record>
+
+        <!-- Pick -->
+        <record id="action_product_pick_tree" model="ir.actions.server">
+            <field name="name">Pickings</field>
+            <field name="model_id" ref="product.model_product_product"/>
+            <field name="state">code</field>
+            <field name="code">
+action = self.view_docs_with_product(cr, uid, ids, menu_action='msf_outgoing.action_picking_ticket', context=context)
+            </field>
+        </record>
+
+        <record id="open_product_pick_tree" model="ir.values">
+            <field name="key2">client_action_relate</field>
+            <field name="model">product.product</field>
+            <field name="name">Pickings</field>
+            <field name="value" eval="'ir.actions.server,%d'%action_product_pick_tree"/>
+            <field name="object" eval="True"/>
+            <field name="sequence" eval="100009"/>
+        </record>
+
+        <!-- PPL -->
+        <record id="action_product_pack_tree" model="ir.actions.server">
+            <field name="name">Packings</field>
+            <field name="model_id" ref="product.model_product_product"/>
+            <field name="state">code</field>
+            <field name="code">
+action = self.view_docs_with_product(cr, uid, ids, menu_action='msf_outgoing.action_ppl', context=context)
+            </field>
+        </record>
+
+        <record id="open_product_pack_tree" model="ir.values">
+            <field name="key2">client_action_relate</field>
+            <field name="model">product.product</field>
+            <field name="name">Packings</field>
+            <field name="value" eval="'ir.actions.server,%d'%action_product_pack_tree"/>
+            <field name="object" eval="True"/>
+            <field name="sequence" eval="100010"/>
+        </record>
 
         <!-- Add a link to see all inactivated products -->
         <act_window

=== modified file 'bin/addons/purchase/purchase_order.py'
--- bin/addons/purchase/purchase_order.py	2022-03-22 09:01:13 +0000
+++ bin/addons/purchase/purchase_order.py	2022-07-13 15:38:28 +0000
@@ -54,9 +54,12 @@
         '''
         new_dom = []
         dest_partner_names = False
+        product_id = False
         for x in domain:
             if x[0] == 'dest_partner_names':
                 dest_partner_names = x[2]
+            elif x[0] == 'product_id':
+                product_id = x[2]
             else:
                 new_dom.append(x)
 
@@ -72,6 +75,12 @@
                 ret.where_clause.append(' "res_partner"."name" ilike %s ')
             ret.where_clause_params.append('%%%s%%'%dest_partner_names)
             ret.having_group_by = ' GROUP BY "purchase_order"."id" '
+        if product_id and isinstance(product_id, int):
+            ret.tables.append('"purchase_order_line"')
+            ret.joins.setdefault('"purchase_order"', [])
+            ret.joins['"purchase_order"'] += [('"purchase_order_line"', 'id', 'order_id', 'LEFT JOIN')]
+            ret.where_clause.append(''' "purchase_order_line"."product_id" = %s  ''')
+            ret.where_clause_params.append(product_id)
         return ret
 
     def _amount_all(self, cr, uid, ids, field_name, arg, context=None):
@@ -708,9 +717,13 @@
 
     def _get_fake(self, cr, uid, ids, name, arg, context=None):
         """
-        Fake method for 'has_confirmed_line' field
+        Fake method for 'has_confirmed_line', 'has_confirmed_or_further_line' and 'product_id' fields
         """
         res = {}
+        if not ids:
+            return res
+        if isinstance(ids, (int, long)):
+            ids = [ids]
         for po_id in ids:
             res[po_id] = False
         return res
@@ -806,7 +819,6 @@
 
         return ret
 
-
     _columns = {
         'order_type': fields.selection(ORDER_TYPES_SELECTION, string='Order Type', required=True),
         'loan_id': fields.many2one('sale.order', string='Linked loan', readonly=True),
@@ -841,7 +853,7 @@
         'unallocation_ok': fields.boolean(string='Unallocated PO'),
         'partner_ref': fields.char('Supplier Reference', size=128),
         'short_partner_ref': fields.function(_get_short_partner_ref, method=True, string='Supplier Reference', type='char', size=64, store=False),
-        'product_id': fields.related('order_line', 'product_id', type='many2one', relation='product.product', string='Product'),
+        'product_id': fields.function(_get_fake, method=True, type='many2one', relation='product.product', string='Product', help='Product to find in the lines', store=False, readonly=True),
         'no_line': fields.function(_get_no_line, method=True, type='boolean', string='No line'),
         'active': fields.boolean('Active', readonly=True),
         'po_from_ir': fields.function(_po_from_x, method=True, type='boolean', string='Is PO from IR ?', multi='po_from_x'),

=== modified file 'bin/addons/purchase/purchase_view.xml'
--- bin/addons/purchase/purchase_view.xml	2022-06-14 11:28:55 +0000
+++ bin/addons/purchase/purchase_view.xml	2022-07-13 15:38:28 +0000
@@ -1015,12 +1015,6 @@
             </field>
         </record>
 
-
-        <act_window context="{}"
-                    domain="[('rfq_ok', '=', False), ('product_id', '=', active_id)]"
-                    id="purchase.action_purchase_line_product_tree2" name="Purchases"
-                    res_model="purchase.order" src_model="product.product" groups=""/>
-
         <record id="purchase_line_form_action2" model="ir.actions.act_window">
             <field name="name">Purchase Lines Not Invoiced</field>
             <field name="type">ir.actions.act_window</field>

=== modified file 'bin/addons/reason_types_moves/reason_type_view.xml'
--- bin/addons/reason_types_moves/reason_type_view.xml	2020-02-06 15:20:20 +0000
+++ bin/addons/reason_types_moves/reason_type_view.xml	2022-07-13 15:38:28 +0000
@@ -196,6 +196,7 @@
                         <newline />
                         <field name="date" />
                         <field name="min_date" />
+                        <field name="product_id" />
                     </xpath>
                     <xpath expr="/search//field[@name='company_id']" position="replace" />
                     <xpath expr="/search//filter[@name='done']" position="attributes">

=== modified file 'bin/addons/reason_types_moves/stock_view.xml'
--- bin/addons/reason_types_moves/stock_view.xml	2021-12-20 15:55:25 +0000
+++ bin/addons/reason_types_moves/stock_view.xml	2022-07-13 15:38:28 +0000
@@ -157,6 +157,7 @@
                         <field name="date" string="Creation date" />
                         <field name="min_date" string="Expected date" />
                         <field name="shipment_ref" />
+                        <field name="product_id" />
                     </group>
                     <newline/>
                     <group expand="0" string="Group By..." colspan="4" col="8">

=== modified file 'bin/addons/sale/sale_order.py'
--- bin/addons/sale/sale_order.py	2022-06-20 12:17:27 +0000
+++ bin/addons/sale/sale_order.py	2022-07-13 15:38:28 +0000
@@ -61,6 +61,27 @@
     _name = "sale.order"
     _description = "Sales Order"
 
+    def _where_calc(self, cr, uid, domain, active_test=True, context=None):
+        '''
+        overwrite to allow search on customer and self instance
+        '''
+        new_dom = []
+        product_id = False
+        for x in domain:
+            if x[0] == 'product_id':
+                product_id = x[2]
+            else:
+                new_dom.append(x)
+
+        ret = super(sale_order, self)._where_calc(cr, uid, new_dom, active_test=active_test, context=context)
+        if product_id and isinstance(product_id, int):
+            ret.tables.append('"sale_order_line"')
+            ret.joins.setdefault('"sale_order"', [])
+            ret.joins['"sale_order"'] += [('"sale_order_line"', 'id', 'order_id', 'LEFT JOIN')]
+            ret.where_clause.append(''' "sale_order_line"."product_id" = %s  ''')
+            ret.where_clause_params.append(product_id)
+        return ret
+
     def copy(self, cr, uid, id, default=None, context=None):
         """
         Copy the sale.order. When copy the sale.order:
@@ -598,6 +619,19 @@
 
         return ret
 
+    def _get_fake(self, cr, uid, ids, name, args, context=None):
+        '''
+        Fake method for 'product_id' field
+        '''
+        res = {}
+        if not ids:
+            return res
+        if isinstance(ids, (int, long)):
+            ids = [ids]
+        for id in ids:
+            res[id] = False
+        return res
+
     _columns = {
         'name': fields.char('Order Reference', size=64, required=True, readonly=True, states={'draft': [('readonly', False)]}, select=True, sort_column='id'),
         'origin': fields.char('Source Document', size=512, help="Reference of the document that generated this sales order request."),
@@ -694,7 +728,7 @@
         'split_type_sale_order': fields.selection(SALE_ORDER_SPLIT_SELECTION, required=True, readonly=True, internal=1),
         'original_so_id_sale_order': fields.many2one('sale.order', 'Original Field Order', readonly=True),
         'active': fields.boolean('Active', readonly=True),
-        'product_id': fields.related('order_line', 'product_id', type='many2one', relation='product.product', string='Product'),
+        'product_id': fields.function(_get_fake, method=True, type='many2one', relation='product.product', string='Product', help='Product to find in the lines', store=False, readonly=True),
         'no_line': fields.function(_get_no_line, method=True, type='boolean', string='No line'),
         'manually_corrected': fields.function(_get_manually_corrected, method=True, type='boolean', string='Manually corrected'),
         'is_a_counterpart': fields.boolean('Counterpart?', help="This field is only for indicating that the order is a counterpart"),

=== modified file 'bin/addons/sale/sale_view.xml'
--- bin/addons/sale/sale_view.xml	2022-05-17 14:21:03 +0000
+++ bin/addons/sale/sale_view.xml	2022-07-13 15:38:28 +0000
@@ -504,6 +504,8 @@
                         <filter domain="[('user_id','=',uid)]" help="My Sale Orders" icon="terp-personal"/>
                     </field>
                     <newline />
+                    <field name="product_id" />
+                    <newline />
                     <group string="Type" expand="0">
                         <filter icon="terp-check" string="Regular" domain="[('order_type','=','regular')]"/>
                         <filter icon="terp-stage" string="Donation before expiry" domain="[('order_type','=','donation_exp')]"/>

=== modified file 'bin/addons/stock/stock.py'
--- bin/addons/stock/stock.py	2022-05-02 15:04:12 +0000
+++ bin/addons/stock/stock.py	2022-07-13 15:38:28 +0000
@@ -746,6 +746,27 @@
     _name = "stock.picking"
     _description = "Picking List"
 
+    def _where_calc(self, cr, uid, domain, active_test=True, context=None):
+        '''
+        overwrite to allow search on customer and self instance
+        '''
+        new_dom = []
+        product_id = False
+        for x in domain:
+            if x[0] == 'product_id':
+                product_id = x[2]
+            else:
+                new_dom.append(x)
+
+        ret = super(stock_picking, self)._where_calc(cr, uid, new_dom, active_test=active_test, context=context)
+        if product_id and isinstance(product_id, int):
+            ret.tables.append('"stock_move"')
+            ret.joins.setdefault('"stock_picking"', [])
+            ret.joins['"stock_picking"'] += [('"stock_move"', 'id', 'picking_id', 'LEFT JOIN')]
+            ret.where_clause.append(''' "stock_move"."product_id" = %s  ''')
+            ret.where_clause_params.append(product_id)
+        return ret
+
     def _set_maximum_date(self, cr, uid, ids, name, value, arg, context=None):
         """ Calculates planned date if it is greater than 'value'.
         @param name: Name of field
@@ -893,6 +914,19 @@
 
         return res
 
+    def _get_fake(self, cr, uid, ids, name, args, context=None):
+        '''
+        Fake method for 'product_id' field
+        '''
+        res = {}
+        if not ids:
+            return res
+        if isinstance(ids, (int, long)):
+            ids = [ids]
+        for id in ids:
+            res[id] = False
+        return res
+
     _columns = {
         'object_name': fields.function(_get_object_name, type='char', method=True, string='Title'),
         'name': fields.char('Reference', size=64, select=True),
@@ -952,6 +986,7 @@
         'customers': fields.char('Customers', size=1026),
         'customer_ref': fields.char('Customer Ref.', size=1026),
         'sync_dpo_in': fields.boolean('Synced IN for DPO reception', internal=1, help='Used to flag a IN linked to a DPO'),
+        'product_id': fields.function(_get_fake, method=True, type='many2one', relation='product.product', string='Product', help='Product to find in the lines', store=False, readonly=True),
     }
 
     _defaults = {

=== modified file 'bin/addons/stock/stock_view.xml'
--- bin/addons/stock/stock_view.xml	2021-11-17 15:46:45 +0000
+++ bin/addons/stock/stock_view.xml	2022-07-13 15:38:28 +0000
@@ -1003,6 +1003,7 @@
                         <field name="origin"/>
                         <field name="stock_journal_id" groups="base.group_extended" widget="selection"/>
                         <field name="company_id" widget="selection"/>
+                        <field name="product_id"/>
                     </group>
                     <newline/>
                     <group expand="0" string="Group By..." colspan="4" col="8">

=== modified file 'bin/addons/tender_flow/tender_flow.py'
--- bin/addons/tender_flow/tender_flow.py	2022-03-21 12:41:58 +0000
+++ bin/addons/tender_flow/tender_flow.py	2022-07-13 15:38:28 +0000
@@ -41,6 +41,27 @@
     _description = 'Tender'
     _trace = True
 
+    def _where_calc(self, cr, uid, domain, active_test=True, context=None):
+        '''
+        overwrite to allow search on customer and self instance
+        '''
+        new_dom = []
+        product_id = False
+        for x in domain:
+            if x[0] == 'product_id':
+                product_id = x[2]
+            else:
+                new_dom.append(x)
+
+        ret = super(tender, self)._where_calc(cr, uid, new_dom, active_test=active_test, context=context)
+        if product_id and isinstance(product_id, int):
+            ret.tables.append('"tender_line"')
+            ret.joins.setdefault('"tender"', [])
+            ret.joins['"tender"'] += [('"tender_line"', 'id', 'tender_id', 'LEFT JOIN')]
+            ret.where_clause.append(''' "tender_line"."product_id" = %s  ''')
+            ret.where_clause_params.append(product_id)
+        return ret
+
     def copy(self, cr, uid, id, default=None, context=None, done_list=[], local=False):
         if not default:
             default = {}
@@ -116,6 +137,19 @@
             res[tender.id] = diff_number
         return res
 
+    def _get_fake(self, cr, uid, ids, name, args, context=None):
+        '''
+        Fake method for 'product_id' field
+        '''
+        res = {}
+        if not ids:
+            return res
+        if isinstance(ids, (int, long)):
+            ids = [ids]
+        for id in ids:
+            res[id] = False
+        return res
+
     _columns = {
         'name': fields.char('Tender Reference', size=64, required=True, select=True, readonly=True, sort_column='id'),
         'sale_order_id': fields.many2one('sale.order', string="Sale Order", readonly=True),
@@ -136,7 +170,7 @@
         'notes': fields.text('Notes'),
         'internal_state': fields.selection([('draft', 'Draft'), ('updated', 'Rfq Updated'), ], string="Internal State", readonly=True),
         'rfq_name_list': fields.function(_vals_get, method=True, string='RfQs Ref', type='char', readonly=True, store=False, multi='get_vals',),
-        'product_id': fields.related('tender_line_ids', 'product_id', type='many2one', relation='product.product', string='Product'),
+        'product_id': fields.function(_get_fake, method=True, type='many2one', relation='product.product', string='Product', help='Product to find in the lines', store=False, readonly=True),
         'delivery_address': fields.many2one('res.partner.address', string='Delivery address', required=True),
         'tender_from_fo': fields.function(_is_tender_from_fo, method=True, type='boolean', string='Is tender from FO ?',),
         'diff_nb_rfq_supplier': fields.function(_diff_nb_rfq_supplier, method=True, type="boolean", string="Compare the number of rfqs and the number of suppliers", store=False),

=== modified file 'bin/addons/tender_flow/tender_flow_view.xml'
--- bin/addons/tender_flow/tender_flow_view.xml	2020-05-06 12:28:03 +0000
+++ bin/addons/tender_flow/tender_flow_view.xml	2022-07-13 15:38:28 +0000
@@ -136,7 +136,7 @@
                             domain="[('state', '=', 'cancel')]" />
                     <field name="name" />
                     <field name="supplier_ids" string="Supplier" widget="many2one" />
-                    <field name="product_id" string="Product" widget="many2one" />
+                    <field name="product_id" />
                     <field name="sale_order_id" string="Sale Order" />
                     <field name="creator" />
                     <field name="creation_date" />

=== modified file 'bin/import_xml.rng'
--- bin/import_xml.rng	2021-10-12 15:17:17 +0000
+++ bin/import_xml.rng	2022-07-13 15:38:28 +0000
@@ -214,6 +214,7 @@
             <rng:optional> <rng:attribute name="empty_ids"/> </rng:optional>
             <rng:optional> <rng:attribute name="auto_refresh"/> </rng:optional>
             <rng:optional> <rng:attribute name="search_view_id"/> </rng:optional>
+            <rng:optional> <rng:attribute name="sequence"/> </rng:optional>
             <rng:empty />
         </rng:element>
     </rng:define>

=== modified file 'bin/tools/convert.py'
--- bin/tools/convert.py	2021-10-12 15:17:17 +0000
+++ bin/tools/convert.py	2022-07-13 15:38:28 +0000
@@ -537,7 +537,7 @@
             if rec.get('view_ids'):
                 for x in rec.get('view_ids').split(','):
                     linked_views.append(self.id_get(cr,x))
-            self.pool.get('ir.model.data').ir_set(cr, self.uid, 'action', keyword, xml_id, [src_model], value, replace=replace, isobject=True, xml_id=xml_id, view_ids=linked_views)
+            self.pool.get('ir.model.data').ir_set(cr, self.uid, 'action', keyword, xml_id, [src_model], value, replace=replace, isobject=True, xml_id=xml_id, view_ids=linked_views, sequence=rec.get('sequence', 100))
         # TODO add remove ir.model.data
 
     def _tag_ir_set(self, cr, rec, data_node=None):