Daily updates from Odoo
Friday, August 14, 2020
10 changes · master
Enhancements to existing features
Sample expense invoices now resize better on mobile screens instead of appearing at a fixed size. This makes the demo experience easier to view and use for people reviewing expense receipt extraction on phones or smaller devices.
Original PR description
Before this commit, the sample invoices would have fixed size and would render poorly in mobile. taskid: 2317997
The eBay status column in the product list is now hidden by default, reducing visual clutter for users who do not need it regularly. Users can still choose to show the column when they want to review eBay-related product status information.
Original PR description
Purpose of the task is to set the optional hide on ebay status in product list view. TaskID: 2309699 Related Community: https://github.com/odoo/odoo/pull/55451 Closes:12288
This update streamlines several internal checks so the system can stop processing as soon as it has enough information. It reduces unnecessary work in reports, payroll, planning, subscriptions, manufacturing, and other areas, helping improve performance without changing user-facing features.
Original PR description
Replace wrong usages of any(list|recordset), by any(generator) to speed up computations, avoiding list creations and/or looping twice on a recordset for nothing. any([generator]) => any(generator) any(filtered) => any(generator) Community PR: https://github.com/odoo/odoo/pull/55768
Users adding files to the Documents split tool can now select PDF files only. This reduces clutter in the file picker and helps users find and add the right documents faster.
Original PR description
PURPOSE The purpose of the task is to help users for faster searching the pdf and adding it to Splittools SPECIFICATIONS it should accept only pdf files LINKS PR #12296 Task-2309062
Code cleanup and technical improvements
CRM revenue fields were renamed so their labels better match the values they contain. This is an internal cleanup that improves consistency and reduces confusion for future maintenance without changing business functionality.
Original PR description
SPECIFICATION : This commit changes the field name "expected_revenue" into "prorated_revenue" and the field name "planned_revenue" into "expected_revenue". LINKS : Task ID : 2283052 PR : #
Miscellaneous changes
Set context on financial reports thus allowing them to skip the Closing Journal Entries from being computed in the results. Main - When module When module l10n_mx_reports_closing is installed Financial Reports take into account the Closing Journal Entries from the requested fiscal year. Hence Profit & Loss reports are not properly presented because the Closing Journal Entries zeroing the results. Closes - odoo/enterprise#12334 To be cherry-picked at - https://github.com/odoo
Original PR description
Set context on financial reports thus allowing them to skip the Closing Journal Entries from being computed in the results. Main - When module When module l10n_mx_reports_closing is installed Financial Reports take into account the Closing Journal Entries from the requested fiscal year. Hence Profit & Loss reports are not properly presented because the Closing Journal Entries zeroing the results. Closes - odoo/enterprise#12334 To be cherry-picked at - https://github.com/odoo/enterprise/pull/12424 Other Info - X-original-commit: ba12f3e351cf1abf0ede5a87357f7eef0b0169e3 Signed-off-by: Jorge Pinna Puissant (jpp) <jpp@odoo.com> Forward-Port-Of: odoo/enterprise#12425
Link to the release: https://github.com/odoo/o-spreadsheet/releases/tag/0.4.0 Here is the list of changes: Breaking changes: * CREATE_SHEET command now takes an id as parameter * getNumberColsand getNumberRowsnow takes the sheet id as parameter Improvements * parser: implement the unary operator + * functions: add some math functions * core: Get row and col number of inactive sheets * registries: label of insert rows/cols * top_bar: hide insert rows/cols if full col/row is select
Original PR description
Link to the release: https://github.com/odoo/o-spreadsheet/releases/tag/0.4.0 Here is the list of changes: Breaking changes: * CREATE_SHEET command now takes an id as parameter * getNumberColsand getNumberRowsnow takes the sheet id as parameter Improvements * parser: implement the unary operator + * functions: add some math functions * core: Get row and col number of inactive sheets * registries: label of insert rows/cols * top_bar: hide insert rows/cols if full col/row is selected * sidepanel: Tweak header and buttons design * sidepanel: Toggle sidepanel Fixes * conditional_format: Add rule to unactive sheet * formulas: support cross-sheet references on copy/paste/autofill * conditional_formatting: correctly set ranges on creation * sidepanel: Remove padding and fix delete button Forward-Port-Of: odoo/enterprise#12297
The eight columns balance for Chile shows draft and posted entries and does not have the option to choose to print them. After this commit: We will have the option to select the entries. <img width="1341" alt="Captura de Pantalla 2020-08-13 a la(s) 15 30 03" src="https://user-images.githubusercontent.com/382893/90178914-ae67ac80-dd7a-11ea-9a2b-b96e96792bc9.png"> Forward-Port-Of: odoo/enterprise#12403
Original PR description
The eight columns balance for Chile shows draft and posted entries and does not have the option to choose to print them. After this commit: We will have the option to select the entries. <img width="1341" alt="Captura de Pantalla 2020-08-13 a la(s) 15 30 03" src="https://user-images.githubusercontent.com/382893/90178914-ae67ac80-dd7a-11ea-9a2b-b96e96792bc9.png"> Forward-Port-Of: odoo/enterprise#12403
Forward-Port-Of: odoo/enterprise#12349 Forward-Port-Of: odoo/enterprise#12345
Original PR description
Forward-Port-Of: odoo/enterprise#12349 Forward-Port-Of: odoo/enterprise#12345
Indexing `mail_message_id` on `voip.phonecall` really helps the performances to delete mail messages when there is a lot of phonecalls in database. During a version upgrade, mail messages can be deleted when a model is being deleted. e.g. deleting `procurement.order` deletes the mail messages related to procurement orders. ```sql SELECT count(*) FROM voip_phonecall; count ------- 80664 SELECT count(*) FROM mail_message; count --------- 8022420 EXPLAIN ANALYZE DELETE FR
Original PR description
Indexing `mail_message_id` on `voip.phonecall` really helps the performances to delete mail messages when there is a lot of phonecalls in database. During a version upgrade, mail messages can be…
Indexing `mail_message_id` on `voip.phonecall`
really helps the performances to delete mail messages
when there is a lot of phonecalls in database.
During a version upgrade, mail messages can be deleted when a model is being deleted.
e.g. deleting `procurement.order` deletes the mail messages related to procurement orders.
```sql
SELECT count(*) FROM voip_phonecall;
count
-------
80664
SELECT count(*) FROM mail_message;
count
---------
8022420
EXPLAIN ANALYZE DELETE FROM mail_message WHERE id in (SELECT id FROM mail_message WHERE model = 'procurement.order' limit 1000);
BEGIN
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Delete on mail_message (cost=233.19..2877.65 rows=1000 width=34) (actual time=18.263..18.263 rows=0 loops=1)
-> Nested Loop (cost=233.19..2877.65 rows=1000 width=34) (actual time=3.585..14.200 rows=1000 loops=1)
-> HashAggregate (cost=232.75..242.75 rows=1000 width=32) (actual time=3.528..3.915 rows=1000 loops=1)
Group Key: "ANY_subquery".id
-> Subquery Scan on "ANY_subquery" (cost=0.56..230.25 rows=1000 width=32) (actual time=0.057..3.003 rows=1000 loops=1)
-> Limit (cost=0.56..220.25 rows=1000 width=4) (actual time=0.051..2.570 rows=1000 loops=1)
-> Index Scan using mail_message_model_index on mail_message mail_message_1 (cost=0.56..615555.95 rows=2801913 width=4) (actual time=0.050..2.410 rows=1000 loops=1)
Index Cond: ((model)::text = 'procurement.order'::text)
-> Index Scan using mail_message_pkey on mail_message (cost=0.43..2.63 rows=1 width=10) (actual time=0.010..0.010 rows=1 loops=1000)
Index Cond: (id = "ANY_subquery".id)
Planning Time: 0.396 ms
Trigger for constraint mail_channel_partner_seen_message_id_fkey: time=51.775 calls=1000
Trigger for constraint mail_compose_message_parent_id_fkey: time=29.725 calls=1000
Trigger for constraint mail_mail_mail_message_id_fkey: time=12.991 calls=1000
Trigger for constraint mail_message_mail_channel_rel_mail_message_id_fkey: time=9.910 calls=1000
Trigger for constraint mail_message_parent_id_fkey: time=134.675 calls=1000
Trigger for constraint mail_message_res_partner_needaction_rel_mail_message_id_fkey: time=12.822 calls=1000
Trigger for constraint mail_message_res_partner_rel_mail_message_id_fkey: time=11.092 calls=1000
Trigger for constraint mail_message_res_partner_starred_rel_mail_message_id_fkey: time=12.034 calls=1000
Trigger for constraint mail_tracking_value_mail_message_id_fkey: time=13.142 calls=1000
Trigger for constraint message_attachment_rel_message_id_fkey: time=11.479 calls=1000
Trigger for constraint rating_rating_message_id_fkey: time=18.046 calls=1000
Trigger for constraint res_partner_mail_message_rel_message_id_fkey: time=8.843 calls=1000
Trigger for constraint voip_phonecall_mail_message_id_fkey: time=41620.315 calls=1000
Execution Time: 41967.798 ms
(25 rows)
```
Upgrade request 52582
M120914764-zcaevxmq
Forward-Port-Of: odoo/enterprise#12405