[IMP] account_reports, l10n_*: Introduce unified reporting engine

(aka Reportalypse)
(aka "v16 reports yeaaaaaaaaaaaah")

This commit introduces the new reporting engine, largely refactoring the account.report model, and replacing what used to be managed by account.financial.html.report, account.tax.report/account.generic.tax.report, and account.accounting.report.

Multiple improvements are brought by this commit:


1) "One engine to rule them all"

All reports (including custom ones) are now direct instances of the account.report model, which becomes a stored model whose filter options are handled by regular fields. account.financial.html.report, account.tax.report and account.accounting report objects don't exist anymore and have been converted to the new engine. Custom (i.e. python-defined) reports still exist, but have been modified to fit the new approach. Note that thanks to this change, a manual reconfiguration of the reports by the user is now possible for every report (to add or remove a filter, change the load more limit, allow comparisons, ...). 

To allow the replacement of the tax reports, account.report's model declaration has been moved from enterprise to community. Indeed, those reports need to stay there, as they are referenced by the taxes requiring the account tags they generate in their repartition. All the logic applied on top of account.report's fields is still enterprise.


2) Introduce account.report.expression

Each account.report.line can define a set of account.report.expressions. Expressions are used for various advanced purposes (see below), but they can roughly be seen as a sub-variable needed by the line. The most basic case is for example what was done before with financial report lines using other invisible lines to do subcomputations: we don't need to use multiple not-obviously-connected lines to do that. Instead the line needing those subcomputations simply defines multiple expressions. 

Each expression is associated to a formula engine, a formula, and an optional subformula. The formula engine defines how the formula and subformula will be interpreted, leading to much more modularity and expressivity.

The following formula engines are available natively. Other engines could be added in the future, possibly even by specific modules: 

- domain:
This engines corresponds to what used to be handled by account.financial.html.report. Its formulas are domains on account.move.line.

- tax_tags:
Corresponds to account.tax.report. An expression using this engine will generate a + and - tag named after its formula, just as the tag_name used to work in the previous paradigm.

- account_codes:
Especially useful for P&L or Balance Sheet reports. This engine uses a formula consisting of account code prefixes. For example "11 + 42" will be evaluated as the sum of the balances of all move lines made on accounts whose code starts with 11 or 42. This is the most basic case ; more advanced expressions are also allowed (for example, to handle what used to be done by sum_if_pos_groupby/sum_if_neg_groupby in old financial reports).

- aggregation: 
Used to aggregate expressions. These expressions can use the "code" field of report lines to reference their value, and express a computation on them, pretty much like the "formula" field of account.tax.report and account.financial.html.report did.

- external
Use to reference values defined by account.report.external.value records (for carryover and manual values ; see below).

- custom
For this engine, the formula simply consists of a function to be called. This function needs to respect the specification of a formula engine function, and can then benefit from all the advantages linked to non-custom formulas (batching, automatic handling of the groupby, ...). This is a way to define engines that are only needed by 1 or 2 reports without making them available everywhere because they are too specific.


Note that this architecture means expressions using different engines can be mixed within the same report in any way that is necessary.


3) Custom reports

Fully defining a report in Python is still possible, but differently than before. Now, you don't have to generate a new AbstractModel inheriting from account.report. Instead, you just need a regular _inherit on account.report, and defining a few functions with specific signatures. The report then needs to be declared as an XML data, and must reference those functions using dedicated fields.


4) Performance improvement

Formulas engines are batched. Depending on the implementation of the engine, this can improve the performance. account_codes engine works this way, leading to tremendous improvement on most P&L and Balance Sheets.


5) Allow multiple columns on non-custom reports

Before, only Python-defined reports could have more than 1 column. This is not the case anymore, with the introduction of the new account.report.column model. Columns fetch their values using labels assigned on account.report.expression objects to identify them. To define different formulas for different columns, just use different expressions with the right label. 


6) Allow manual values

In the past, the only way for a user to input values into a report without creating move lines was to use a financial report with the from_context formula, and rely on a wizard when opening the report. This was too restrictive, as the input value was always the same whatever the period (so, comparisons did not work well), and the value didn't persist and needed to be re-entered every time the report was opened. 

To solve this, we introduce a new model called account.report.external.value. It essentially represents a value which can't be computed from account.move.line records directly. Manual values are handled by using an expression with engine 'external' and subformula 'editable' as the value of a column. A little pen will then be displayed in the corresponding cell, allowing to modify its value.


7) Carryover refactoring

The introduction of account.report.external.value also allowed refactoring the way the carryover works. We remove account.tax.carryover.line and instead use account.report.external.value. Also, instead of computing the carryover as the cumulated balance of all existing account.tax.carryover.line, we directly create a external value with a balance equal to the carryover amount. When getting the carryover coming from previous periods, we only consider the external values that is in the previous tax period.


8) Reduce menuitems overhead in l10n modules

A lot of localizations define localized versions of generic reports, typically for the Balance Sheet, P&L and tax report. In v15, the tax report already was handled with a single menuitem and a selector on the report allowed choosing which country we wanted to view the report of. However, all other reports still created specific menuitems. This made the menus more complex, and overall impacted the user experience negatively. This was especially problematic in multicompany environment, since the menuitems of all companies' countries were always shown, whatever the active company. 

We now generalize what was done by the tax report: each report can point towards another report via the root_report_id field, hence becoming a variant of this report. Variants are available through a selector on the report, and the default selected one is the one that matches best the company country.

All reports which used a wizard to input manual values (such as in Spain) now make use of editable expressions. Also, the tax report lines which did not create any tag have also been converted so that they use manual values.


9) Misc improvements

- Cleaning: merge l10n_es_reports_2021 into l10n_es_reports
- Cleaning: merge l10n_nl_report_intrastat into l10n_nl_intrastat, and make l10n_nl_intrastat depend on account_reports
- Remove old Indian reports an introduce new more standard ones instead (more correct business-wise)
- Remove support for Mexican 13th month closing: this should either be done by impacting the current year earnings account directly or by using a specific journal, and a group to exclude it. 
- Remove a few unused reports whose information was redundant with the one in other, more complete reports



Task 2524389

Before this commit, when the customer chose SEPA Direct Debit to make a
payment, the transaction was set in the `pending` state after creating
the mandate. An `account.payment` was immediately created to allow
accountants to order the bank debit. After reconciliation of the
payment, which can take weeks, the transaction was confirmed (set to
`done`) and post-processed. Only then were the related documents
(quotation, subscription, invoice) confirmed.

This way of doing posed several problems:
- Most apps consider the `pending` state as a near-failure. When the
  customer was being redirected to the portal page of the document they
  intended to pay, no mention was made of the pending SEPA payment.
  Worse, the customer was invited to pay again.
- As SEPA payments take a lot of time to process, the confirmation of
  the document to pay was significantly delayed. In the Subscriptions
  app, in particular, this poses problems because the subscription was
  not started or resumed even though the customer had provided all the
  required payment details.
- Creating the `account.payment` record *before* setting the transaction
  to the state `done` implied extra technical complexity because every
  other payment flow waits for the transaction to be confirmed before
  creating the related payment, which is the logical way to post-process
  transactions. Indeed, we should typically wait for the funds to be
  available for reconciliation to create the payment, which was not the
  case for SEPA payments.

These problems can be addressed thanks to the following observations:
- By law, the customer must be able to cancel SEPA payments
  effortlessly. Therefore, handling the case where the customer cancels
  the payment after the paid document has been confirmed is required.
- SEPA mandates work conceptually like payment tokens: after they are
  created, one can use them to make payments without the intervention of
  the customer. A SEPA payment can therefore be considered as "almost
  confirmed" as soon as the mandate is created.

After this commit, SEPA payments are confirmed (the state is set to
`done`) as soon as the mandate is created. This avoids having to deal
with all the side effect of the `pending` state altogether and resolves
the technical difficulties related to the timing of the creation of the
`account.payment`. Should a SEPA payment fail, handling it would be the
same process as handling a payment cancelation.

task-2842241

Purpose:
========

Fix unfolded articles caching: previously, articles where added
or removed from the list of unfodled articles in the cache only when
clicking on the caret that folds or unfolds an article. Therefore,
when a child article was created or when an article was moved under
a parent article, these new parent articles were not added to the
cache and were folded when selecting another article.
Article ids are now also added/removed from the list of unfolded
articles when an article has been (un)folded without clicking on a
caret.

Fix moving articles under folded articles: previously, moving an
article under a folded article was either not possible if the article
had been unfolded and refolded before, or it overwrote the other
existing children if it had not been unfolded before.
The former issue arises because when one folds an article, the "ul"
containing the children articles was simply hidden, which is not
compatible with NestedSortable. Therefore, instead of only hiding the
"ul", it is moved to one of its siblings, so that one can move it
back when one unfolds the parent again, or when an article is moved
under it. This trick also allows to always place the moved article as
the last child of it's parent, which was not the case with other
approaches tried.
To solve the latter issue, an RPC is now done to fetch the other
children of the parent when an article is moved under this parent and
when the children have not been fetched yet.

Fix ordering of articles fetched through a RPC: previously, the
order of the articles fetched when unfolding an article was not the
same as the one when these articles were loaded on page load, causing
articles to change position when unfolding then selecting an article.
The order is now the same in both cases.

Scroll to articles in the sidebar when created: when one creates an
article, it spawns at the bottom of its section/group of children in
the sidebar. Now, the sideview is scrolled in order to have the
handle of the newly created article in the view.

Task-2858704

Forward-Port-Of: odoo/enterprise#29282