Wednesday, April 21, 2021
8 changes · master
New functionality added to Odoo
Documents spreadsheets now support real-time collaborative editing, allowing multiple users to work on the same spreadsheet at once. The update also improves reliability and loading performance by managing shared revisions consistently and keeping regular snapshots.
Original PR description
This commit update o-spreadsheet to the latest version. The most notable change is the introduction of a realtime collaboration feature. It was introduced in odoo/o-spreadsheet@7c0e933 Odoo needs to implement the collaboration server that integrates with the o-spreadsheet library. This comes with some challenges: 1) Ensure consistency between many revisions coming from many concurrent users. This is documented in the code. 2) Maintaining regular snapshots to ensure low loading times. Alternatives and the final choice are described in enterprise/documents_spreadsheet/models/snapshotting.md The complete changelog with all the new spreadsheet features and bug fixes can be found here: https://github.com/odoo/o-spreadsheet/releases/tag/3.0.0 (still unpublished) Task-id 2345192 Co-authored-by: LucasLefevre <lul@odoo.com> Co-authored-by: pro-odoo <pro@odoo.com>
Enhancements to existing features
Payroll reports and declarations now gather payslip line totals much more efficiently, reducing generation time for Belgian monthly and annual documents. The update also includes related fixes to Belgian payroll declarations and data handling, improving reliability for payroll teams.
Original PR description
Resolved issues and error corrections
Sign requests now keep the signer email in sync when a contact's email address is updated. This helps ensure resent signature emails go to the latest address, reducing delivery mistakes and manual corrections.
Original PR description
the signer_email should depends on the partner_id.email rather than partner_id. So that when the email of a partner is changed in the Contact, the signer_email will be auto-updated in the sign request. taskid: 2512637
Miscellaneous changes
The payment method selected by default by account.payment.register on nightly builds sometimes was SEPA Credit Transfer instead of 'manual', which crashed the tests as we didn't expect that, and the bank account set on the journal was not an IBAN, hence not validating the SEPA constraint. We couldn't determine precisely the cause of this issue. This is a first attempt at fixing the test, it could require further investigation. Forward-Port-Of: odoo/enterprise#17842
Original PR description
The payment method selected by default by account.payment.register on nightly builds sometimes was SEPA Credit Transfer instead of 'manual', which crashed the tests as we didn't expect that, and the bank account set on the journal was not an IBAN, hence not validating the SEPA constraint. We couldn't determine precisely the cause of this issue. This is a first attempt at fixing the test, it could require further investigation. Forward-Port-Of: odoo/enterprise#17842
Purpose ======= For some payroll reports/declaration, we need to retrieve a lot of values for a lot of payslips, and aggregate those data in a PDF/XML/XLS/... file. Currently, it was mainly done by…
Purpose
=======
For some payroll reports/declaration, we need to retrieve a lot of values for a lot of payslips, and aggregate those data in a PDF/XML/XLS/... file.
Currently, it was mainly done by using some helpers like the method _get_salary_line_total to retrieve the value for a given code for a given payslip.
This PR introduces a new way to aggregate all those data in a single SQL request.
```python
a = sum(p._get_salary_line_total('BASIC') for p in payslips
b = sum(p._get_salary_line_total('NET') for p in payslips
c = sum(p._get_salary_line_quantity('MEAL_VOUCHERS') for p in payslips
```
would become
```python
line_values = payslips._get_line_values(['BASIC', 'NET'], vals_list=['total', 'quantity'], compute_sum=True)
a = line_values['BASIC']['sum']['total']
b = line_values['NET']['sum']['total']
c = line_values['MEAL_VOUCHERS']['sum']['quantity']
```
The value retrieval becomes O(1) instead of O(nbr_payslips x nbr_payslip_line)
For monthly/annual belgian reports, the execution time to generate a XML or PDF declaration for a hundred payslips is divided by 10.
TaskID: 2510163Accounting reports can now show tax details directly for each journal entry line, making tax amounts easier to review and trace. This improves the reliability of tax, general ledger, SAF-T, and related country-specific reports across different reporting scenarios.
Original PR description
task: 2352524
Marketing Automation now lets users edit activity filters directly inside the activity form instead of opening a second pop-up window. This reduces modal stacking, makes campaign setup smoother, and improves the overall user experience when configuring workflow activities.
Original PR description
PURPOSE In Marketing Automation, Change the domain editor in line. currently this activity_domain is open in wizard form, which is bad UX practice. CURRENT While creating/editing marketing activity in campaign it opens as wizard form, which is OK. But when we try to add domain on this particular activity, which open another wizard on the current one. which`s looks bad. TO BE Improves the behaviour of adding domain editor. Which is not open wizard for adding activity_domain, and open as inline domain editor. **TaskID - 2480625**
Pivot tables inserted into Documents spreadsheets no longer merge the top-left cells. This removes a purely visual formatting choice that could make selecting ranges harder, improving day-to-day spreadsheet usability.
Original PR description
…ertion Before this commit, the top left cells of a pivot are merged when inserting in spreadsheet. However, this merge can quickly become an issue when trying to select a range. Since the initial motivation for merging these cells was purely aesthetic, we simply get rid of this merge at pivot insertion. Task-id 2510104
preview text in marketing automation mailings is now made editable, earlier there was no option for input. subject field name is changed to title in marketing automation sms as subject looks weird in sms form. task-id: 2390284 Forward-Port-Of: odoo/enterprise#16254 Forward-Port-Of: odoo/enterprise#15098
Original PR description
preview text in marketing automation mailings is now made editable, earlier there was no option for input. subject field name is changed to title in marketing automation sms as subject looks weird in sms form. task-id: 2390284 Forward-Port-Of: odoo/enterprise#16254 Forward-Port-Of: odoo/enterprise#15098