Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0036232
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Discounts and Promotionsmajoralways2017-06-01 11:592017-06-27 09:50
ReportermalsasuaView Statuspublic 
Assigned Toranjith_qualiantech_com 
PriorityimmediateResolutionfixedFixed in VersionRR17Q1.2
StatusclosedFix in branchFixed in SCM revision607d3c2d3105
ProjectionnoneETAnoneTarget VersionRR17Q1.2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket46774
Regression levelProduction - Confirmed Stable
Regression date2017-02-17
Regression introduced in releaseRR17Q2
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/eb6b4b84a3416e104ee4aa2f2704ecaa732cc084 [^]
Triggers an Emergency PackNo
Summary

0036232: Discounts are not applied when a product is not included in the store assortment

Descriptionwhen a discount is configured with "included product: All excluding defined", and there is some product in product tab, then the discount is not applied for any product
Steps To Reproducein backend:
. discount and promotion window:
  . discount: GPS_10_per
  . change "included product" field, from "Only those defined" to "All excluding defined"
in product tab there are two products: gps handled and gps touch screen

in POS:
. add new product: inspect repelent
expected behavior: discount GPS_10_per should be applied, but it is not applied. It is not applied for any discount
Proposed Solutionin discount master query, this part should be removed:
    hql += "and ((p.includedProducts = 'Y' and not exists (select 1 ";
    hql += " from PricingAdjustmentProduct pap, OBRETCO_Prol_Product ppl ";
    hql += " where pap.active = true and pap.priceAdjustment = p ";
    hql += " and pap.product.id = ppl.product.id ";
    hql += " and ppl.obretcoProductlist.id ='" + productList.getId() + "')) ";
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0036160 closedranjith_qualiantech_com Discounts are not applied when a product is not included in the store assortment 

-  Notes
(0097354)
hgbot (developer)
2017-06-13 11:49

 Repository: retail/backports/3.0RR17Q1.2/org.openbravo.retail.posterminal
Changeset: 607d3c2d310590dd769db360a57fc14cafbaf12a
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Jun 13 15:19:09 2017 +0530
URL: http://code.openbravo.com/retail/backports/3.0RR17Q1.2/org.openbravo.retail.posterminal/rev/607d3c2d310590dd769db360a57fc14cafbaf12a [^]

Fixed issue 36232 : Validate Discount Product if includeProduct is set as "all excluding defined"

* For Discount Product, if includeProduct is set as "all excluding defined" then it should not be checked with assortment

---
M src/org/openbravo/retail/posterminal/master/Discount.java
---
(0097356)
hgbot (developer)
2017-06-13 11:50

 Repository: retail/backports/3.0RR17Q1.2/pi-mobile
Changeset: 5e9d92fa3b9d7ebfb1a7e33311f6cfd39088618a
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Jun 13 15:19:04 2017 +0530
URL: http://code.openbravo.com/retail/backports/3.0RR17Q1.2/pi-mobile/rev/5e9d92fa3b9d7ebfb1a7e33311f6cfd39088618a [^]

Verifies issue 36232 : Added automated test 'I36232_VerifyDiscountWithIncludeExcludeProducts'

---
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I36232_VerifyDiscountWithIncludeExcludeProducts.java
---
(0097697)
hgbot (developer)
2017-06-27 09:50

 Repository: tools/automation/pi-mobile
Changeset: 5e9d92fa3b9d7ebfb1a7e33311f6cfd39088618a
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Jun 13 15:19:04 2017 +0530
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/5e9d92fa3b9d7ebfb1a7e33311f6cfd39088618a [^]

Verifies issue 36232 : Added automated test 'I36232_VerifyDiscountWithIncludeExcludeProducts'

---
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/discountsandpromotions/I36232_VerifyDiscountWithIncludeExcludeProducts.java
---

- Issue History
Date Modified Username Field Change
2017-06-12 16:15 ranjith_qualiantech_com Type defect => backport
2017-06-12 16:15 ranjith_qualiantech_com Target Version => RR17Q1.2
2017-06-13 11:49 hgbot Checkin
2017-06-13 11:49 hgbot Note Added: 0097354
2017-06-13 11:49 hgbot Status scheduled => resolved
2017-06-13 11:49 hgbot Resolution open => fixed
2017-06-13 11:49 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a99eaea6ebd2ae64996cbbabdddf5e2d76131638 [^] => http://code.openbravo.com/retail/backports/3.0RR17Q1.2/org.openbravo.retail.posterminal/rev/607d3c2d310590dd769db360a57fc14cafbaf12a [^]
2017-06-13 11:50 hgbot Checkin
2017-06-13 11:50 hgbot Note Added: 0097356
2017-06-19 18:29 marvintm Review Assigned To => marvintm
2017-06-19 18:29 marvintm Status resolved => closed
2017-06-19 18:29 marvintm Fixed in Version => RR17Q1.2
2017-06-27 09:50 hgbot Checkin
2017-06-27 09:50 hgbot Note Added: 0097697

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker