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 
Review Assigned Tomarvintm
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