Issue:
======
After adding all the values in a sign doucent and then go back to change other fields, clicking in a text field and then clicking on another will make the sign & validate button unresponsive.

Steps to reproduce the issue:
=============================
- install sign
- send a sign request to a customer , the sign document should have at least 2 text fields -
- Open the sent link  using mobile display and add all tha values but do not validate
- Click on any text field
- Click on another text field and click next
- Clicking on the button validate will do nothing.

Origin of the issue:
====================
Toggling between text fields will remove `show` class from the old bottom sheet and add it to the new one. but when closing the new one , the old one will still exist but we can't see it  because it doesn't have the class `show` but it's display is still `block` , that's why clicking on the button validate woudln't work , it's below the div of the bottom sheet.

Solution:
=========
Removing the manual style as block and adding it to the show class so it will be updated automatically when we add/remove the class.

opw-3477410
opw-3511365m

Forward-Port-Of: odoo/enterprise#51526
Forward-Port-Of: odoo/enterprise#51377

Steps
=====
- Open app Project
- In settings of Project activate task dependencies
- Open a project with dependencies between task (e.g. research and development in demo data)
- Go to the Gantt view of the tasks of this project in mobile view (or with as small window)
- Deactivate all filters to ensure that tasks with dependencies appear in the current view
- Switch to desktop view (or resize the window)

Issue
=====
A traceback appears indicating "Cannot read properties of undefined (reading '__pill__1')".

Cause
=====
The connections between dependent pill is only displayed if the user is not in mobile view. To avoid unecessary memory allocation, some variable used to manage the connections display (e.g. mappingPillToConnectors), are only declared if the user is not in mobile view. However, when resizing the window (or leaving mobile view), the onWillRender method is called and can make use of those variables if the connections need to be displayed. This create the traceback are those variables have not been declared.

Fix
===
The method computeDerivedParams used to manage such variable declaration is called in the onWillRender method under the condition that connectors were not present in the previous render (i.e. it was in mobile view).

Forward-Port-Of: odoo/enterprise#50525
Forward-Port-Of: odoo/enterprise#48107

Issue:
This SQL query is slow when an user has a big quantity of account move lines and products.

Analyze:
In this query it joins the table of account_move_line with product_product to check if the product is active which is causing the slowness.
The issue is that the CTEs are inlined by the planner due to this Postgres commit
: postgres/postgres@608b167f.

The source and ranking CTE become a single SQL query and thus the tsvector Filter is run on all the account_move_line instead of the query limitation number. To solve the planner has to execute the first query (first_source) and then the second (source) on the result of first_source.

Fix:
In order to force the planner to make the limit on account_move_line a MATERIALIZED view has been used.
(https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-CTE-MATERIALIZATION)

Note:
MATERIALIZED views have been implemented on PSQL 12. But all Odoo's internal servers (both Odoo.sh and SaaS) haven't any server running a previous version.

Benchmark:
| # Input data | Before PR | After PR |
|:-------------:|:----------:|:---------:|
|   3M AML               |    28.579 s            |     59.4 ms |
|   47 AML (demo data)                  |    1.262ms (planning) + 0.682 ms (execution)            |   5.289 ms + 0.994 ms            |

Related task:
opw-3539632 (Query and Planners are available in the task)

Forward-Port-Of: odoo/enterprise#51211
Forward-Port-Of: odoo/enterprise#50911

This traceback arises when the user tries to click on Recent in Softphone

To reproduce this issue:
1. Install `VoIP`
2. Open `Discuss/Softphone/Recent`
3. Try to search for something in the Voip search bar

Error: 

```  ValueError: too many values to unpack (expected 3)
  File "odoo/http.py", line 2157, in __call__
    response = request._serve_db()
  File "odoo/http.py", line 1732, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "odoo/service/model.py", line 133, in retrying
    result = func()
  File "odoo/http.py", line 1759, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "odoo/http.py", line 1960, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "addons/website/models/ir_http.py", line 235, in _dispatch
    response = super()._dispatch(endpoint)
  File "odoo/addons/base/models/ir_http.py", line 207, in _dispatch
    result = endpoint(**request.params)
  File "odoo/http.py", line 722, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "addons/web/controllers/dataset.py", line 24, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "addons/web/controllers/dataset.py", line 20, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "odoo/api.py", line 462, in call_kw
    result = _call_kw_model(method, model, args, kwargs)
  File "odoo/api.py", line 435, in _call_kw_model
    result = method(recs, *args, **kwargs)
  File "home/odoo/src/enterprise/17.0/voip/models/voip_call.py", line 85, in get_recent_phone_calls
    return self.search(domain, offset=offset, limit=limit, order="create_date DESC")._format_calls()
  File "odoo/models.py", line 1604, in search
    return self.search_fetch(domain, [], offset=offset, limit=limit, order=order)
  File "odoo/models.py", line 1627, in search_fetch
    query = self._search(domain, offset=offset, limit=limit, order=order or self._order)
  File "odoo/models.py", line 5366, in _search
    query = self._where_calc(domain)
  File "odoo/models.py", line 5081, in _where_calc
    return expression.expression(domain, self).query
  File "odoo/osv/expression.py", line 788, in __init__
    self.expression = domain_combine_anies(domain, model)
  File "odoo/osv/expression.py", line 597, in domain_combine_anies
    domain_any = _anyfy_leaves(domain, model)
  File "odoo/osv/expression.py", line 371, in _anyfy_leaves
    left, operator, right = item = tuple(item)
```

When the user tries to search for something in the search bar an invalid domain format is formed in `get_recent_phone_call`method. Which leads to the traceback from here

https://github.com/odoo/enterprise/blob/5c42708683905cfb5fe8c1005aabbbc9fb016fa2/voip/models/voip_call.py#L79-L85

After applying this commit will resolve the issue by giving a valid domain format to search.

sentry-4644858097

Forward-Port-Of: odoo/enterprise#51276

This commit does 2 things:

- avoids an error occurring when scanning a source location that has no
  (remaining) reserved qtys at that location to scan. Issue was due to:

https://github.com/odoo/enterprise/blob/61d3aa2d4ba7540803b88ca4f426e6ee6503e8dd/stock_barcode/static/src/models/barcode_picking_model.js#L165

  still being used by barcode_mrp_model, but this.needSourceConfirmation
  is set to `false` in the mrp model, so an error is thrown because
  booleans don't have an index. Originally it was thought this
  (picking) feature wasn't wanted for MOs, but this has been
  reconsidered and we now want it (afterall, it is better to have
  consistent behavior).

  Note that in order to add this check in, the _createNewLine in MOs had
  to be adjusted so that the assignment of the final product for an MO
  created from scratch occurred before the check:
  https://github.com/odoo/enterprise/blob/57986a41fb80deecd7c4d2a374afa801bc44a507/stock_barcode/static/src/models/barcode_picking_model.js#L51

  because the this.location will throw a cache error due to there being
  no default location to find (i.e. there are no locations for the MO
  yet). No tests were added for this because existing tours already
  failed when creating MOs from scratch.

  Steps to reproduce:
  - activate multi-locations + set barcode setting for manufacture
    picking type: `restrict_scan_source_location`=`mandatory`
  - create 2 products, 1 with stock in WH/Stock, the other with stock in
    WH/Stock/Shelf 1, both with barcodes
  - create MO using those 2 products + reserve
  - open MO in barcode, scan "Shelf 1" barcode + scan component in that
    loc
  - scan "WH/Stock"

  expected result: should switch source locations + should be able to
  scan the other component

  actual result: JS error

- adds in a test to avoid the same mistake that is fixed in the COM PR
  of this branch. Existing test has been redone so the test includes:
  + the above location switching scanning (to scan a non-reserved
    component)
  + the mandatory consumption check
  + the original test of scanning a diff lot than the one already
    reserved

COM PR: https://github.com/odoo/odoo/pull/142933

Forward-Port-Of: odoo/enterprise#51171