Test the OpenSPP modules that are migrated to Odoo 17

[dasunhegoda]

1. No unique ID for Group and Individual Ticket: Improve odoo import for registrant #247

2. No Import Match, no Custom Fields, no Country Office in Registry > Configuration Tickets:

• Extend Importing Function with the Import Matching #5
• Add a way to recompute the indicator fields that are set to be recomputed daily #216
• Create a module that allow to create country office (aka company in odoo) and configure it #3

3. No import in the background checkbox on the left side of the screen when importing a file. Ticket: Improve the odoo import to support async #1

4. No top-up card or any cards in Individuals and Groups Ticket: Extend ID Document to support top-up card #249

5. No Program ID Ticket: Add a field program_id to each program. It is a string auto generated with the format: PROG_{SEQ} #88

6. No SQL-based Eligibility Manager, no Tag-based Eligibility Manager, no Compliance Criteria in Set Program Settings Tickets:

• implement a SQL eligibility manager #89
• Add a new enrollment manager that is based on tag+Area #86
• Implement compliance criteria #90

7. No Store Service Points to Entitlements checkbox in Entitlement Manager Tickets:

• Implement different way to associate service points to entitlements #83
• Enhance API and UI to Filter Service Points by Program #64

8. No local and global roles Ticket: Standardize user roles #2

9. No unique ID for Area and Service Points Ticket: create unique id on areas & service points for integrate with OpenFN #273

10. No Contacts, no OpenAPI in Home Menu Tickets:

• Associate a company and contacts to each service point. #245
• Setting up Swagger documentation for the APIs #70

11. No Import from Registry in Registry for the OpenCRVS Integration Ticket: G2P Connect API Implementation - OpenCRVS Integration #67

12. No DCI API Client Credentials in Settings Ticket: G2P Connect API Implementation - OpenCRVS Integration #67

13. No option to add negative criteria Ticket: In the enrollment module, Add an option to add negative criterias #18

14. Amount per Cycle column behavior in Entitlement Manager for Cash https://drive.google.com/file/d/198GySHEb4zXhfbOU4gDQdP1wDbwajlKX/view?usp=sharing

15. No Approve Entitlements button for In-kind Entitlements (unlike in Cash), resulting to Approved state but entitlements are still in Pending Validation.

16. PMT Score of Group is not updating when Default Weight is changed. https://drive.google.com/file/d/1dDbUqWkwmMU3ltsR8mxZBRMQBoL9rUZh/view?usp=sharing

17. Random error message appears in Custom Fields.

RPC_ERROR Odoo Server Error Traceback (most recent call last): File "/opt/odoo/custom/src/odoo/odoo/http.py", line 1765, in _serve_db return service_model.retrying(self._serve_ir_http, self.env) File "/opt/odoo/custom/src/odoo/odoo/service/model.py", line 133, in retrying result = func() File "/opt/odoo/custom/src/odoo/odoo/http.py", line 1792, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) File "/opt/odoo/custom/src/odoo/odoo/http.py", line 1996, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) File "/opt/odoo/custom/src/odoo/odoo/addons/base/models/ir_http.py", line 222, in _dispatch result = endpoint(**request.params) File "/opt/odoo/custom/src/odoo/odoo/http.py", line 722, in route_wrapper result = endpoint(self, *args, **params_ok) File "/opt/odoo/auto/addons/web/controllers/dataset.py", line 24, in call_kw return self._call_kw(model, method, args, kwargs) File "/opt/odoo/auto/addons/web/controllers/dataset.py", line 20, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/opt/odoo/custom/src/odoo/odoo/api.py", line 468, in call_kw result = _call_kw_multi(method, model, args, kwargs) File "/opt/odoo/custom/src/odoo/odoo/api.py", line 453, in _call_kw_multi result = method(recs, *args, **kwargs) File "/opt/odoo/auto/addons/web/models/models.py", line 76, in web_save return self.with_context(bin_size=True).web_read(specification) File "/opt/odoo/auto/addons/web/models/models.py", line 86, in web_read values_list: List[Dict] = self.read(fields_to_read, load=None) File "/opt/odoo/custom/src/odoo/odoo/models.py", line 3539, in read self._origin.fetch(fields) File "/opt/odoo/custom/src/odoo/odoo/models.py", line 3827, in fetch fetched = self._fetch_query(query, fields_to_fetch) File "/opt/odoo/custom/src/odoo/odoo/models.py", line 3940, in _fetch_query field.read(fetched) File "/opt/odoo/custom/src/odoo/odoo/fields.py", line 4821, in read query.order = comodel._order_to_sql(comodel._order, query) File "/opt/odoo/custom/src/odoo/odoo/models.py", line 5163, in _order_to_sql term = self._order_field_to_sql(alias, field_name, sql_direction, sql_nulls, query) File "/opt/odoo/custom/src/odoo/odoo/models.py", line 5184, in _order_field_to_sql raise ValueError(f"Invalid field {field_name!r} on model {self._name!r}") ValueError: Invalid field 'id' on model '_unknown'

The above server error caused the following client error: RPC_ERROR: Odoo Server Error at makeErrorFromResponse (https://acf-dev.newlogic-demo.com/web/assets/fc5753c/web.assets_web.min.js:2879:163) at XMLHttpRequest. (https://acf-dev.newlogic-demo.com/web/assets/fc5753c/web.assets_web.min.js:2883:13)

18. Cannot delete a Rule in Audit Rule page.

RPC_ERROR Odoo Server Error Traceback (most recent call last): File "/opt/odoo/custom/src/odoo/odoo/http.py", line 1765, in _serve_db return service_model.retrying(self._serve_ir_http, self.env) File "/opt/odoo/custom/src/odoo/odoo/service/model.py", line 133, in retrying result = func() File "/opt/odoo/custom/src/odoo/odoo/http.py", line 1792, in _serve_ir_http response = self.dispatcher.dispatch(rule.endpoint, args) File "/opt/odoo/custom/src/odoo/odoo/http.py", line 1996, in dispatch result = self.request.registry['ir.http']._dispatch(endpoint) File "/opt/odoo/custom/src/odoo/odoo/addons/base/models/ir_http.py", line 222, in _dispatch result = endpoint(**request.params) File "/opt/odoo/custom/src/odoo/odoo/http.py", line 722, in route_wrapper result = endpoint(self, *args, **params_ok) File "/opt/odoo/auto/addons/web/controllers/dataset.py", line 24, in call_kw return self._call_kw(model, method, args, kwargs) File "/opt/odoo/auto/addons/web/controllers/dataset.py", line 20, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/opt/odoo/custom/src/odoo/odoo/api.py", line 468, in call_kw result = _call_kw_multi(method, model, args, kwargs) File "/opt/odoo/custom/src/odoo/odoo/api.py", line 453, in _call_kw_multi result = method(recs, *args, **kwargs) File "/opt/odoo/auto/addons/spp_audit_log/models/spp_audit_rule.py", line 177, in unlink audit_rule_count = self.env["spp.audit.rule"].search( TypeError: BaseModel.search() got an unexpected keyword argument 'count'

The above server error caused the following client error: RPC_ERROR: Odoo Server Error at makeErrorFromResponse (https://acf-dev.newlogic-demo.com/web/assets/debug/web.assets_web.js:27818:19) at XMLHttpRequest. (https://acf-dev.newlogic-demo.com/web/assets/debug/web.assets_web.js:27866:27)

19. Error message when clicking View Logs.

20. In Programs > Configuration > General Settings > Program Settings. No Setting Found error is still displaying even when Program Setting is already clicked.

21. Select a Program with Compliance Criteria. Click Configuration. Scroll down to Compliance Manager. The Compliance is not displayed properly. https://github.com/OpenSPP/openspp-modules/assets/138551361/4cfa5070-787f-4ed4-bee8-13e02f2aefb6

22. SQL Record Count is always zero in Compliance Criteria