This update removes reliance on an older database query helper across several reporting and data cleanup areas. It keeps payroll, recruitment, planning, timesheet forecasting, and data cleaning reports aligned with the main platform’s database practices, reducing maintenance risk without changing day-to-day user workflows.

odoo/odoo#173992

This update adds automated test coverage for reacting to WhatsApp messages. It helps ensure upcoming WhatsApp messaging improvements work reliably before they reach users.

Preparation for PR odoo/odoo#170553

Users can now change the sorting of spreadsheet list data directly from the list side panel. The spreadsheet view updates immediately, making it easier to organize and review list information without leaving the current workflow.

### [IMP] spreadsheet_edition: add edit list sorting feature in list side panel

This commit implements a feature for changing the list sorting directly in the side panel with a real-time update of the user interface.

Task: [3636092](https://www.odoo.com/odoo/project/2328/tasks/3636092)

The manufacturing planning screen now orders related items more reliably, including complex products with several bill of materials levels. Opening planning from a bill of materials now shows all related child items, helping teams get a fuller view of demand and dependencies without extra navigation.

This PR contains the following commits:
- improve the sequence calculation
- see all the children MPS when opening from a specific bom and not just the first level

task-4033339

This update adjusts website sales and rental test tours to use the latest shared testing utility structure. It is an internal quality improvement that helps keep automated checks maintainable without changing customer-facing behavior.

This update improves how translated messages are built across multiple Odoo Enterprise apps, reducing cases where parts of messages could stay untranslated or appear in an unnatural word order. This helps deliver clearer, more accurate wording for users working in languages other than English.

There are many places in the code where translated strings are concatenated to other strings, translated or untranslated.
While it is sometimes the right thing to do, there are also a lot of problematic cases:
- When concatenating untranslated strings, it obviously means they won't be translated, even though they sometimes should be
- Even if they don't need to be, the order of words can vary greatly between languages, and including it makes reordering easier.
- The same issue can arise when concatenating multiple translated strings, especially if they are part of one sentence.

This commit fixes the problematic occurrences of concatenation.
It also adds some named placeholders and uses of the `format_list` helper.

Community: https://github.com/odoo/odoo/pull/171425

Task-3997249