Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0048685 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Retail Modules] Retail API | major | N/A | 2022-02-28 15:32 | 2022-03-14 14:45 | |||
| Reporter | prakashmurugesan88 | View Status | public | |||||
| Assigned To | prakashmurugesan88 | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR22Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0048685: Retail API Extension for Orders and Cashup | |||||||
| Description | 1. Extend Retail API to allow exporting Orders: There are several APIs that are already making references to order-related information. For example, existing Discounts engine webservice receives a simplified order as input. External Order Loader does the same, although in this case it requires a significantly greater amount of properties. Define a Retail API mapping for orders, to be used later for general export of transactions out of Openbravo. At the same time, we also want to homogeneize all references to orders in our APIs. Currently we have some inconsistencies in some properties, and this makes using different APIs confusing for users. If we need to adjust some properties, we will do so without breaking compatibility with older versions of our APIs, to ensure current users can still operate them without issues. https://docs.google.com/document/d/1f5XqBcKKY7XNe-J_rXc6E_xBiwm64uTb/edit [^] 2. Retail API extension: Cashup information Extend Retail API to allow exporting the Cashup Information This entity will essentially include all the information currently stored in the “Cashup History” tab of the Channel Touchpoint entity in the backoffice. https://docs.google.com/document/d/1PAg4ChwPLxNI1Nvi32k84jc-Hm3iA50L/edit# [^] | |||||||
| Steps To Reproduce | NA | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0135430) hgbot (developer) 2022-03-03 14:28 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/merge_requests/35 [^] |
|
(0135569) prakashmurugesan88 (developer) 2022-03-09 08:49 |
Created following Merge Request, https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/21 [^] https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/740 [^] https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/4 [^] https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/merge_requests/35 [^] https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/2 [^] |
|
(0135579) hgbot (developer) 2022-03-09 12:00 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: 3244742a8491e1b0488c19117c467f1385b868be Author: Prakash M <prakash@qualiantech.com> Date: 09-03-2022 16:23:19 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/3244742a8491e1b0488c19117c467f1385b868be [^] Fixed ISSUE-48685: Included following cashup related tables in sample data * OBPOS_Paymentmethodcashup * OBPOS_Paymentcashup_Events * OBPOS_Taxcashup * OBPOS_Cashup_Approval --- M src-db/database/sourcedata/AD_DATASET_TABLE.xml --- |
|
(0135580) hgbot (developer) 2022-03-09 12:10 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^] Changeset: 9e1318d2903237bf1502b2177e849614f99364b3 Author: Prakash M <prakash@qualiantech.com> Date: 09-03-2022 16:39:35 URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/9e1318d2903237bf1502b2177e849614f99364b3 [^] Fixed ISSUE-48685: Included CashUp Sample Data --- A referencedata/sampledata/The_White_Valley_Group/OBPOS_CASHUP_APPROVAL.xml A referencedata/sampledata/The_White_Valley_Group/OBPOS_PAYMENTCASHUP_EVENTS.xml A referencedata/sampledata/The_White_Valley_Group/OBPOS_PAYMENTMETHODCASHUP.xml A referencedata/sampledata/The_White_Valley_Group/OBPOS_TAXCASHUP.xml M referencedata/sampledata/The_White_Valley_Group/AD_SEQUENCE.xml M referencedata/sampledata/The_White_Valley_Group/C_INVOICE.xml M referencedata/sampledata/The_White_Valley_Group/C_INVOICELINE.xml M referencedata/sampledata/The_White_Valley_Group/C_INVOICELINETAX.xml M referencedata/sampledata/The_White_Valley_Group/C_INVOICETAX.xml M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINETAX.xml M referencedata/sampledata/The_White_Valley_Group/C_ORDERTAX.xml M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml M referencedata/sampledata/The_White_Valley_Group/FIN_FINACC_TRANSACTION.xml M referencedata/sampledata/The_White_Valley_Group/FIN_FINANCIAL_ACCOUNT.xml M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT.xml M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_DETAIL.xml M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULE.xml M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULEDETAIL.xml M referencedata/sampledata/The_White_Valley_Group/FIN_RECONCILIATION.xml M referencedata/sampledata/The_White_Valley_Group/M_INOUT.xml M referencedata/sampledata/The_White_Valley_Group/M_INOUTLINE.xml M referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml M referencedata/sampledata/The_White_Valley_Group/M_STOCK_PROPOSED.xml M referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION.xml M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION_COST.xml M referencedata/sampledata/The_White_Valley_Group/OBPOS_APPLICATIONS.xml M referencedata/sampledata/The_White_Valley_Group/OBPOS_APP_CASHUP.xml M referencedata/sampledata/The_White_Valley_Group/OBPOS_APP_PAYMENT_TYPE.xml --- |
|
(0135581) hgbot (developer) 2022-03-09 12:15 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^] Changeset: 52422273303e7757d9fba7b9a1a63b67a37c7e95 Author: Prakash M <prakash@qualiantech.com> Date: 09-03-2022 16:42:42 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/52422273303e7757d9fba7b9a1a63b67a37c7e95 [^] Fixed ISSUE-48685: Added Retail API Mapping for Order Export --- --- |
|
(0135582) hgbot (developer) 2022-03-09 12:19 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api [^] Changeset: 929685ed998028f40aafc29529cadc21cf699666 Author: Prakash M <prakash@qualiantech.com> Date: 04-03-2022 08:28:50 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/commit/929685ed998028f40aafc29529cadc21cf699666 [^] Related to FR-48685: Added examples to the Postman file for Order and Cashup APIs --- M examples/Retail API.postman_collection.json --- |
|
(0135583) hgbot (developer) 2022-03-09 12:19 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api [^] Changeset: a8a9c85b32cc34b26162b426276e688f58874539 Author: Prakash M <prakash@qualiantech.com> Date: 09-03-2022 16:48:03 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/commit/a8a9c85b32cc34b26162b426276e688f58874539 [^] Fixed ISSUE-48685: Added Retail API Mapping for CashUp Export --- M examples/Retail API.postman_collection.json M src-db/database/sourcedata/API_EXPORT_FILTER.xml M src-db/database/sourcedata/API_EXPORT_FILTER_PARAM.xml M src-db/database/sourcedata/OBEI_ENTITY_MAPPING.xml M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml --- |
|
(0135584) hgbot (developer) 2022-03-09 12:19 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/merge_requests/35 [^] |
|
(0135585) hgbot (developer) 2022-03-09 12:22 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^] Changeset: 652c688c1978000cf1d38a8f3a7b49b2b1aa3211 Author: Prakash M <prakash@qualiantech.com> Date: 09-03-2022 16:51:23 URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/652c688c1978000cf1d38a8f3a7b49b2b1aa3211 [^] Fixed ISSUE-48685: Added Export Order and Export CashUp API tests --- A src-test/data/export/filter/cashUp/CashUpById.json A src-test/data/export/filter/cashUp/byCashUpOrg.json A src-test/data/export/filter/cashUp/byCashUpTerminal.json A src-test/data/export/filter/order/OrderByDocumentNo.json A src-test/data/export/filter/order/OrderById.json A src-test/data/export/filter/order/OrderByOrgOrderDate.json A src-test/org/openbravo/api/tests/export/ApiExportCashUpFilters.java A src-test/org/openbravo/api/tests/export/ApiExportOrderFilters.java M src-test/data/export/filter/bpartner/BPartnerByBPartnerCategory.json M src-test/data/export/filter/bpartner/BPartnerById.json M src-test/data/export/filter/bpartner/BPartnerByName.json M src-test/data/export/filter/bpartner/BPartnerByOrg.json M src-test/data/export/filter/bpartner/BPartnerBySearchKey.json M src-test/data/export/filter/bpartner/BPartnerByStoreId.json M src-test/data/export/filter/bpartner/BPartnerByStoreName.json M src-test/data/export/filter/bpartner/BPartnerByStoreSearchKey.json M src-test/data/export/filter/product/ProductById.json M src-test/data/importer/Product.json M src-test/org/openbravo/api/tests/StandaloneTestSuite.java M src-test/org/openbravo/api/tests/util/ApiTestConstants.java --- |
|
(0135616) hgbot (developer) 2022-03-10 11:10 |
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^] Changeset: 9ed70dc07068936eeb1723a80e25ebf39e56e810 Author: Prakash M <prakash@qualiantech.com> Date: 10-03-2022 15:40:25 URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/9ed70dc07068936eeb1723a80e25ebf39e56e810 [^] Related ISSUE-48685: Fixes SAMPLEDATA dbconsinstency --- M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULE.xml M referencedata/sampledata/The_White_Valley_Group/M_INOUTLINE.xml M referencedata/sampledata/The_White_Valley_Group/OBPOS_CASHUP_APPROVAL.xml M referencedata/sampledata/The_White_Valley_Group/OBPOS_PAYMENTMETHODCASHUP.xml --- |
|
(0135626) hgbot (developer) 2022-03-10 16:16 |
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^] Changeset: af7231d9671872ec5dae486d5869bd55e1f5dfef Author: Prakash M <prakash@qualiantech.com> Date: 10-03-2022 20:05:55 URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/af7231d9671872ec5dae486d5869bd55e1f5dfef [^] Revert "Related ISSUE-48685: Fixes SAMPLEDATA dbconsinstency" This reverts commit 9ed70dc07068936eeb1723a80e25ebf39e56e810. --- M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULE.xml M referencedata/sampledata/The_White_Valley_Group/M_INOUTLINE.xml M referencedata/sampledata/The_White_Valley_Group/OBPOS_CASHUP_APPROVAL.xml M referencedata/sampledata/The_White_Valley_Group/OBPOS_PAYMENTMETHODCASHUP.xml --- |
|
(0135689) hgbot (developer) 2022-03-14 13:41 |
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.testing [^] Changeset: 9e4a8ab2ee26c90e436a316dfeee8d49850a674f Author: Prakash M <prakash@qualiantech.com> Date: 14-03-2022 12:41:38 URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.testing/-/commit/9e4a8ab2ee26c90e436a316dfeee8d49850a674f [^] Related to ISSUE-48685: Fixes tests failing after adding new orders in sample data Fixed by adding hardcoded order IDs to ensure new sampledata orders don't affect tests. --- M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRBlockchainTestBase.java M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRaTicketBlockchain.java M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRbTicketTaxBlockchain.java M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRcTicketReprintBlockchain.java M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRdTicketAggDayBlockchain.java M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFReTicketAggMonthBlockchain.java M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRfTicketAggYearBlockchain.java M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRgTerminalMonitorBlockchain.java M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRaIssueTicket.java M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRbIssueTicketTax.java M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRcIssueTicketReprint.java M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRdIssueTerminalMonitor.java M src-test/org/openbravo/certification/france/testing/issue/test/OBCFReIssueTicketAggDay.java M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRfIssueTicketAggMonth.java M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRgIssueTicketAggYear.java M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRhIssueArchivingLog.java M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRTicketTestBase.java M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRTicketTestSuite.java M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRaTicketCreateData.java M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRbTicketInitializationBackground.java M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRfTicketRemoveData.java M src-test/org/openbravo/certification/france/testing/utils/OBCFRTicketUtils.java --- |
|
(0135690) hgbot (developer) 2022-03-14 13:43 |
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^] Changeset: 9c7ea70bfc1bc0839018098886abd7316ed33ead Author: Prakash M <prakash@qualiantech.com> Date: 11-03-2022 13:36:27 URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/9c7ea70bfc1bc0839018098886abd7316ed33ead [^] Revert "Revert "Related ISSUE-48685: Fixes SAMPLEDATA dbconsinstency"" This reverts commit af7231d9671872ec5dae486d5869bd55e1f5dfef. --- M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULE.xml M referencedata/sampledata/The_White_Valley_Group/M_INOUTLINE.xml M referencedata/sampledata/The_White_Valley_Group/OBPOS_CASHUP_APPROVAL.xml M referencedata/sampledata/The_White_Valley_Group/OBPOS_PAYMENTMETHODCASHUP.xml --- |
|
(0135693) hgbot (developer) 2022-03-14 14:45 |
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.testing [^] Changeset: 1c7cb91d7033bffc2c8f290efe89b84835dda616 Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com> Date: 14-03-2022 14:44:21 URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.testing/-/commit/1c7cb91d7033bffc2c8f290efe89b84835dda616 [^] Related to ISSUE-48685: Avoid ORA-01873 error in Oracle --- M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRTicketTestBase.java --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2022-02-28 15:32 | prakashmurugesan88 | New Issue | |
| 2022-02-28 15:32 | prakashmurugesan88 | Assigned To | => prakashmurugesan88 |
| 2022-02-28 15:32 | prakashmurugesan88 | Triggers an Emergency Pack | => No |
| 2022-02-28 15:33 | prakashmurugesan88 | Status | new => scheduled |
| 2022-03-03 14:28 | hgbot | Note Added: 0135430 | |
| 2022-03-07 14:22 | ivancaceres | Issue Monitored: ivancaceres | |
| 2022-03-09 08:49 | prakashmurugesan88 | Note Added: 0135569 | |
| 2022-03-09 12:00 | hgbot | Resolution | open => fixed |
| 2022-03-09 12:00 | hgbot | Status | scheduled => closed |
| 2022-03-09 12:00 | hgbot | Fixed in Version | => RR22Q2 |
| 2022-03-09 12:00 | hgbot | Note Added: 0135579 | |
| 2022-03-09 12:10 | hgbot | Note Added: 0135580 | |
| 2022-03-09 12:15 | hgbot | Note Added: 0135581 | |
| 2022-03-09 12:19 | hgbot | Note Added: 0135582 | |
| 2022-03-09 12:19 | hgbot | Note Added: 0135583 | |
| 2022-03-09 12:19 | hgbot | Note Added: 0135584 | |
| 2022-03-09 12:22 | hgbot | Note Added: 0135585 | |
| 2022-03-10 11:10 | hgbot | Note Added: 0135616 | |
| 2022-03-10 16:16 | hgbot | Note Added: 0135626 | |
| 2022-03-14 13:41 | hgbot | Note Added: 0135689 | |
| 2022-03-14 13:43 | hgbot | Note Added: 0135690 | |
| 2022-03-14 14:45 | hgbot | Note Added: 0135693 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |