Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0054192Retail ModulesDiscounts and Promotionspublic2023-12-21 13:222024-01-03 16:40
Reporterigor_trebol 
Assigned Toigor_trebol 
PrioritynormalSeveritymajorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0054192: API Change: VIP Prices
DescriptionChanged the following columns in M_OFFER table, from required to not required, and removed default values:
 - addamt
 - discount

Added constraint M_OFFER_DATE_CHK to table M_OFFER_PRODUCT:
 - defined as: DATEFROM <= DATETO

Try-backoffice result where the api change was detected: https://builds.openbravo.com/job/try-api/1770/ [^]

Impact: Medium: Could affect code that asumes that addamt and discount always have a value.
Steps To Reproducen/a
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks feature request 0054057 closed igor_trebol VIP Price. Price adjustments per product. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-12-21 13:22igor_trebolNew Issue
2023-12-21 13:22igor_trebolAssigned To => igor_trebol
2023-12-21 13:22igor_trebolTriggers an Emergency Pack => No
2023-12-21 15:02igor_trebolDescription Updatedbug_revision_view_page.php?rev_id=27260#r27260
2023-12-21 16:14hgbotNote Added: 0158493
2024-01-03 12:25igor_trebolDescription Updatedbug_revision_view_page.php?rev_id=27287#r27287
2024-01-03 12:32igor_trebolDescription Updatedbug_revision_view_page.php?rev_id=27288#r27288
2024-01-03 13:10igor_trebolRelationship addedblocks 0009782
2024-01-03 13:11igor_trebolRelationship deletedblocks 0009782
2024-01-03 13:11igor_trebolRelationship addedblocks 0054057
2024-01-03 13:42aferrazTag Attached: Approved
2024-01-03 16:09hgbotNote Added: 0158826
2024-01-03 16:09hgbotNote Added: 0158827
2024-01-03 16:39igor_trebolStatusnew => scheduled
2024-01-03 16:39igor_trebolStatusscheduled => resolved
2024-01-03 16:39igor_trebolResolutionopen => fixed
2024-01-03 16:40igor_trebolStatusresolved => closed

Notes
(0158493)
hgbot   
2023-12-21 16:14   
Merge Request created: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/58 [^]
(0158826)
hgbot   
2024-01-03 16:09   
Merge request merged: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/58 [^]
(0158827)
hgbot   
2024-01-03 16:09   
Repository: https://gitlab.com/openbravo/ci/backoffice-api [^]
Changeset: a04baefe16f1004eee6d06862f7ac25488cc99ce
Author: Igor Trebol <igor.trebol@openbravo.com>
Date: 21-12-2023 16:12:15
URL: https://gitlab.com/openbravo/ci/backoffice-api/-/commit/a04baefe16f1004eee6d06862f7ac25488cc99ce [^]

Related to ISSUE-54192: API change for VIP Prices

---
M model/src-db/database/model/tables/M_OFFER.xml
M model/src-db/database/model/tables/M_OFFER_PRODUCT.xml
---