Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0053810 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [POS2] Core | trivial | have not tried | 2023-10-30 23:48 | 2023-11-07 14:24 | |||
| Reporter | dcontrera | View Status | public | |||||
| Assigned To | dcontrera | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 24Q1 | |||
| 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 | 0053810: Price exceptions - Mechanism to maintain PRICES WITH EXCEPTIONS (M_PRODUCTPRICE_EXC) table clean | |||||||
| Description | Look for a way to keep the PRICES WITH EXCEPTIONS (M_PRODUCTPRICE_EXC) table clean, so we avoid impact on: - Full / incremental refresh - Print Labels Step 2 - Overlapping dates feature | |||||||
| Steps To Reproduce | Specs https://docs.google.com/document/d/1dS58ih8iXAeOpFZ_3e3rQkEdQrwzUisVLfreEQMhfEM/edit [^] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0156503) hgbot (developer) 2023-10-31 01:01 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2213 [^] |
|
(0156504) hgbot (developer) 2023-10-31 01:01 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1399 [^] |
|
(0156505) hgbot (developer) 2023-10-31 01:01 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.product.label.printing/-/merge_requests/37 [^] |
|
(0156506) hgbot (developer) 2023-10-31 01:02 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations/-/merge_requests/58 [^] |
|
(0156712) hgbot (developer) 2023-11-06 08:14 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^] Changeset: ff035b725d0ef845b93d59ea73edf3976f656108 Author: dante.contrera <dante.contrera@smfconsulting.es> Date: 06-11-2023 08:13:47 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/ff035b725d0ef845b93d59ea73edf3976f656108 [^] Fixed ISSUE-53810: Mechanism to maintain prices with exceptions table clean. --- A src-db/database/model/tables/OBPOS2_PRODPRICE_EXC_ARCH.xml A src/org/openbravo/pos2/process/DeleteProductPriceExceptions.java M src-db/database/model/modifiedTables/AD_ORG.xml M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_ELEMENT.xml M src-db/database/sourcedata/AD_FIELD.xml M src-db/database/sourcedata/AD_MESSAGE.xml M src-db/database/sourcedata/AD_MODEL_OBJECT.xml M src-db/database/sourcedata/AD_PROCESS.xml M src-db/database/sourcedata/AD_TABLE.xml --- |
|
(0156713) hgbot (developer) 2023-11-06 08:14 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^] Changeset: 2a67014f1db281deb0851d2d9398359980022990 Author: dante.contrera <dante.contrera@smfconsulting.es> Date: 06-11-2023 08:13:47 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/2a67014f1db281deb0851d2d9398359980022990 [^] Fixed ISSUE-53810: Mechanism to maintain prices with exceptions table clean. --- M src-db/database/sourcedata/AD_FIELD.xml M src/org/openbravo/pos2/process/DeleteProductPriceExceptions.java --- |
|
(0156714) hgbot (developer) 2023-11-06 08:14 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^] Changeset: 3559e1b1f377a7a3b7fe79b24f25dc433ec26bd6 Author: dante.contrera <dante.contrera@smfconsulting.es> Date: 06-11-2023 08:13:47 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/3559e1b1f377a7a3b7fe79b24f25dc433ec26bd6 [^] Related to ISSUE-53810: Product price foreign key added. --- M src-db/database/model/tables/OBPOS2_PRODPRICE_EXC_ARCH.xml --- |
|
(0156715) hgbot (developer) 2023-11-06 08:14 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^] Changeset: 17788a73ef6248a727212f873a0bc777fc0dd57a Author: Antonio Moreno <antonio.moreno@openbravo.com> Date: 06-11-2023 08:13:47 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/17788a73ef6248a727212f873a0bc777fc0dd57a [^] Related to ISSUE-53810: Fixed wrong Java import --- M src/org/openbravo/pos2/process/DeleteProductPriceExceptions.java --- |
|
(0156716) hgbot (developer) 2023-11-06 08:14 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^] Changeset: 640293276c57409a757961871ed5fceb9dfa727c Author: dante.contrera <dante.contrera@smfconsulting.es> Date: 06-11-2023 08:13:47 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/640293276c57409a757961871ed5fceb9dfa727c [^] Related to ISSUE-53810: Days field parameter moved to AD_Client table. --- A src-db/database/model/modifiedTables/AD_CLIENTINFO.xml M src-db/database/model/modifiedTables/AD_ORG.xml M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_FIELD.xml M src/org/openbravo/pos2/process/DeleteProductPriceExceptions.java --- |
|
(0156717) hgbot (developer) 2023-11-06 08:14 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^] Changeset: 5144feceba59ccf1a71687bef6f34bfbfb560d69 Author: Antonio Moreno <antonio.moreno@openbravo.com> Date: 06-11-2023 08:13:47 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/5144feceba59ccf1a71687bef6f34bfbfb560d69 [^] Related to ISSUE-53810: Adjusted field position --- M src-db/database/sourcedata/AD_FIELD.xml --- |
|
(0156718) hgbot (developer) 2023-11-06 08:14 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^] Changeset: 16f52711f9cab778b313d2d43e66952582cc10e0 Author: Antonio Moreno <antonio.moreno@openbravo.com> Date: 06-11-2023 08:14:19 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/16f52711f9cab778b313d2d43e66952582cc10e0 [^] Fixed ISSUE-53810: Added process to delete expired price exceptions. Merge branch 'fr/53810' --- A src-db/database/model/modifiedTables/AD_CLIENTINFO.xml A src-db/database/model/tables/OBPOS2_PRODPRICE_EXC_ARCH.xml A src/org/openbravo/pos2/process/DeleteProductPriceExceptions.java M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_ELEMENT.xml M src-db/database/sourcedata/AD_FIELD.xml M src-db/database/sourcedata/AD_MESSAGE.xml M src-db/database/sourcedata/AD_MODEL_OBJECT.xml M src-db/database/sourcedata/AD_PROCESS.xml M src-db/database/sourcedata/AD_TABLE.xml --- |
|
(0156719) hgbot (developer) 2023-11-06 08:14 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2213 [^] |
|
(0156720) hgbot (developer) 2023-11-06 08:15 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.product.label.printing [^] Changeset: 69f2272ed5170451f3efd80fc0d8489e92dba07d Author: dante.contrera <dante.contrera@smfconsulting.es> Date: 30-10-2023 20:57:05 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.product.label.printing/-/commit/69f2272ed5170451f3efd80fc0d8489e92dba07d [^] Fixed ISSUE-53810: Mechanism to maintain prices with exceptions table clean. --- A src-db/database/model/modifiedTables/OBPOS2_PRODPRICE_EXC_ARCH.xml M src-db/database/sourcedata/AD_COLUMN.xml --- |
|
(0156721) hgbot (developer) 2023-11-06 08:15 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.product.label.printing/-/merge_requests/37 [^] |
|
(0156722) hgbot (developer) 2023-11-06 08:15 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations [^] Changeset: 6110d26a33af3c69b93b144e865b7ca41193e159 Author: dante.contrera <dante.contrera@smfconsulting.es> Date: 30-10-2023 20:58:45 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations/-/commit/6110d26a33af3c69b93b144e865b7ca41193e159 [^] Fixed ISSUE-53810: Mechanism to maintain prices with exceptions table clean. --- A src-db/database/model/modifiedTables/OBPOS2_PRODPRICE_EXC_ARCH.xml M src-db/database/sourcedata/AD_COLUMN.xml --- |
|
(0156723) hgbot (developer) 2023-11-06 08:15 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations [^] Changeset: f219ff8de5441f376c2e74507bbc3cf425b3c7c3 Author: dante.contrera <dante.contrera@smfconsulting.es> Date: 31-10-2023 13:06:33 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations/-/commit/f219ff8de5441f376c2e74507bbc3cf425b3c7c3 [^] Related to ISSUE-53810: Foreign key added. --- M src-db/database/model/modifiedTables/OBPOS2_PRODPRICE_EXC_ARCH.xml --- |
|
(0156724) hgbot (developer) 2023-11-06 08:15 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations/-/merge_requests/58 [^] |
|
(0156725) hgbot (developer) 2023-11-06 08:15 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: 3c14165ffac092288f56e15a59665de8cc425ff8 Author: dante.contrera <dante.contrera@smfconsulting.es> Date: 06-11-2023 07:15:19 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/3c14165ffac092288f56e15a59665de8cc425ff8 [^] Fixed ISSUE-53810: Mechanism to maintain prices with exceptions table clean. --- A src-db/database/model/modifiedTables/OBPOS2_PRODPRICE_EXC_ARCH.xml M src-db/database/sourcedata/AD_COLUMN.xml --- |
|
(0156726) hgbot (developer) 2023-11-06 08:15 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1399 [^] |
|
(0156732) hgbot (developer) 2023-11-06 09:04 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: ef8e1f358290e21a9e5c4c306dffb9f21f149acc Author: Antonio Moreno <antonio.moreno@openbravo.com> Date: 06-11-2023 09:04:45 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/ef8e1f358290e21a9e5c4c306dffb9f21f149acc [^] Related to ISSUE-53810: Removed column that violated module dependencies --- M src-db/database/sourcedata/AD_COLUMN.xml R src-db/database/model/modifiedTables/OBPOS2_PRODPRICE_EXC_ARCH.xml --- |
|
(0156742) hgbot (developer) 2023-11-06 09:51 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^] Changeset: 611c909e665a0a1d62b85ffb3131c3c3072b500e Author: Antonio Moreno <antonio.moreno@openbravo.com> Date: 06-11-2023 09:50:53 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/611c909e665a0a1d62b85ffb3131c3c3072b500e [^] Related to ISSUE-53810: Revert "Fixed ISSUE-53810: Added process to delete expired price exceptions. Merge branch 'fr/53810'" This reverts commit 16f52711f9cab778b313d2d43e66952582cc10e0, reversing changes made to c12a58801b2e50b3576a3b04cc0717cc7948ba26. --- M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_ELEMENT.xml M src-db/database/sourcedata/AD_FIELD.xml M src-db/database/sourcedata/AD_MESSAGE.xml M src-db/database/sourcedata/AD_MODEL_OBJECT.xml M src-db/database/sourcedata/AD_PROCESS.xml M src-db/database/sourcedata/AD_TABLE.xml R src-db/database/model/modifiedTables/AD_CLIENTINFO.xml R src-db/database/model/tables/OBPOS2_PRODPRICE_EXC_ARCH.xml R src/org/openbravo/pos2/process/DeleteProductPriceExceptions.java --- |
|
(0156743) hgbot (developer) 2023-11-06 09:52 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.product.label.printing [^] Changeset: c0d61aab8716394ef7414ab1eb34673912a970b8 Author: Antonio Moreno <antonio.moreno@openbravo.com> Date: 06-11-2023 09:52:50 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.product.label.printing/-/commit/c0d61aab8716394ef7414ab1eb34673912a970b8 [^] Related to ISSUE-53810: Revert incorrect commit --- M src-db/database/sourcedata/AD_COLUMN.xml R src-db/database/model/modifiedTables/OBPOS2_PRODPRICE_EXC_ARCH.xml --- |
|
(0156746) hgbot (developer) 2023-11-06 09:54 |
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations [^] Changeset: 6bdcb45e9021296fa0d34d48d84c85ec05bb13f6 Author: Antonio Moreno <antonio.moreno@openbravo.com> Date: 06-11-2023 09:54:42 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.commercialoperations/-/commit/6bdcb45e9021296fa0d34d48d84c85ec05bb13f6 [^] Related to ISSUE-53810: Revert incorrect commit --- M src-db/database/sourcedata/AD_COLUMN.xml R src-db/database/model/modifiedTables/OBPOS2_PRODPRICE_EXC_ARCH.xml --- |
|
(0156747) marvintm (manager) 2023-11-06 09:56 |
Reopened as we had to revert it, due to problems in the way module dependencies are managed |
|
(0156790) hgbot (developer) 2023-11-06 18:30 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2224 [^] |
|
(0156795) hgbot (developer) 2023-11-06 22:11 |
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2224 [^] |
|
(0156796) hgbot (developer) 2023-11-06 22:43 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2225 [^] |
|
(0156852) hgbot (developer) 2023-11-07 14:22 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^] Changeset: b31165e054188218cdadbe9dc9b5a7ce1056c0ba Author: Dante Contrera <dante.contrera@smfconsulting.es> Date: 07-11-2023 13:22:08 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/b31165e054188218cdadbe9dc9b5a7ce1056c0ba [^] Fixed ISSUE-53810: Added process to delete expired price exceptions --- A src-db/database/model/modifiedTables/AD_CLIENTINFO.xml A src-db/database/model/tables/OBPOS2_PRODPRICE_EXC_ARCH.xml A src/org/openbravo/pos2/process/DeleteProductPriceExceptions.java M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_ELEMENT.xml M src-db/database/sourcedata/AD_FIELD.xml M src-db/database/sourcedata/AD_MESSAGE.xml M src-db/database/sourcedata/AD_MODEL_OBJECT.xml M src-db/database/sourcedata/AD_PROCESS.xml M src-db/database/sourcedata/AD_TABLE.xml --- |
|
(0156853) hgbot (developer) 2023-11-07 14:22 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2225 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2023-10-30 23:48 | dcontrera | New Issue | |
| 2023-10-30 23:48 | dcontrera | Assigned To | => dcontrera |
| 2023-10-30 23:48 | dcontrera | Triggers an Emergency Pack | => No |
| 2023-10-31 01:01 | hgbot | Note Added: 0156503 | |
| 2023-10-31 01:01 | hgbot | Note Added: 0156504 | |
| 2023-10-31 01:01 | hgbot | Note Added: 0156505 | |
| 2023-10-31 01:02 | hgbot | Note Added: 0156506 | |
| 2023-11-06 08:14 | hgbot | Resolution | open => fixed |
| 2023-11-06 08:14 | hgbot | Status | new => closed |
| 2023-11-06 08:14 | hgbot | Fixed in Version | => 24Q1 |
| 2023-11-06 08:14 | hgbot | Note Added: 0156712 | |
| 2023-11-06 08:14 | hgbot | Note Added: 0156713 | |
| 2023-11-06 08:14 | hgbot | Note Added: 0156714 | |
| 2023-11-06 08:14 | hgbot | Note Added: 0156715 | |
| 2023-11-06 08:14 | hgbot | Note Added: 0156716 | |
| 2023-11-06 08:14 | hgbot | Note Added: 0156717 | |
| 2023-11-06 08:14 | hgbot | Note Added: 0156718 | |
| 2023-11-06 08:14 | hgbot | Note Added: 0156719 | |
| 2023-11-06 08:15 | hgbot | Note Added: 0156720 | |
| 2023-11-06 08:15 | hgbot | Note Added: 0156721 | |
| 2023-11-06 08:15 | hgbot | Note Added: 0156722 | |
| 2023-11-06 08:15 | hgbot | Note Added: 0156723 | |
| 2023-11-06 08:15 | hgbot | Note Added: 0156724 | |
| 2023-11-06 08:15 | hgbot | Fixed in Version | 24Q1 => RR24Q1 |
| 2023-11-06 08:15 | hgbot | Note Added: 0156725 | |
| 2023-11-06 08:15 | hgbot | Note Added: 0156726 | |
| 2023-11-06 09:04 | hgbot | Note Added: 0156732 | |
| 2023-11-06 09:51 | hgbot | Fixed in Version | RR24Q1 => 24Q1 |
| 2023-11-06 09:51 | hgbot | Note Added: 0156742 | |
| 2023-11-06 09:52 | hgbot | Note Added: 0156743 | |
| 2023-11-06 09:54 | hgbot | Note Added: 0156746 | |
| 2023-11-06 09:56 | marvintm | Note Added: 0156747 | |
| 2023-11-06 09:56 | marvintm | Status | closed => new |
| 2023-11-06 09:56 | marvintm | Resolution | fixed => open |
| 2023-11-06 09:56 | marvintm | Fixed in Version | 24Q1 => |
| 2023-11-06 18:30 | hgbot | Note Added: 0156790 | |
| 2023-11-06 21:59 | hgbot | Note Added: 0156794 | |
| 2023-11-06 22:11 | hgbot | Note Added: 0156795 | |
| 2023-11-06 22:43 | hgbot | Note Added: 0156796 | |
| 2023-11-06 22:51 | hgbot | Note Added: 0156797 | |
| 2023-11-07 14:22 | hgbot | Resolution | open => fixed |
| 2023-11-07 14:22 | hgbot | Status | new => closed |
| 2023-11-07 14:22 | hgbot | Fixed in Version | => 24Q1 |
| 2023-11-07 14:22 | hgbot | Note Added: 0156852 | |
| 2023-11-07 14:22 | hgbot | Note Added: 0156853 | |
| 2023-11-07 14:23 | hgbot | Note Added: 0156854 | |
| 2023-11-07 14:24 | hgbot | Note Added: 0156855 | |
| 2023-11-07 14:24 | marvintm | Note Deleted: 0156797 | |
| 2023-11-07 14:24 | marvintm | Note Deleted: 0156794 | |
| 2023-11-07 14:24 | marvintm | Note Deleted: 0156854 | |
| 2023-11-07 14:24 | marvintm | Note Deleted: 0156855 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |