Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032533Retail ModulesWeb POSpublic2016-03-22 16:542016-05-05 09:37
Reporteraaroncalero 
Assigned ToSandrahuguet 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR16Q3 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032533: Discounts by product characteristics don't work with the remote preference for products
DescriptionWhen the Remote preference for products is active, it is not possible to filter discounts using product characteristics.
The m_product_ch_value is never loaded in websql because of the remote preference, but the discounts query has a join to that table.
Steps To ReproduceLogin in backend and configure a discount filtering by characteristics:
Name: Test Characteristics
Starting date: 1/1/16
Included Characteristics: Only Those Defined
Discount amount: 2
Rest of the fields as default.
Go to the characteristics tab and add a record:
Characteristic: Color
Value: Black/Silver

Go to the product window, find the Avalanche Transceiver product, go to the Characteristics tab and add a new record with Characteristic: color. Save and use the Update Characteristics button on the header to set the Color to Black/Silver.

Go to the Preference window and ensure that the 'Enable Remote for Product' preference is set to N.
Login in web pos, add an Avalanche Transceiver, and verify that the Test Characteristics discount is applied.
Delete the ticket.

Go back to the erp, to the preference window, and change the value of the 'Enable Remote for Product' preference to Y.

Go to the web pos, clear cache (required when transitioning from non-remote to remote) and refresh.

Add an Avalanche Transceiver again and verify that this time the discount has not been applied.
Proposed SolutionThe websql tables related to product characteristics should be filled at least with the characteristics of the current product, so the discounts query returns the correct discounts.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0032867 closed Sandrahuguet [HGVOL] Products that are not in an open ticket should be deleted from the local database 
depends on defect 0032662 closed Sandrahuguet Ability to reset OB.Cache when a record is saved in the local database 
depends on defect 0032693 closed Sandrahuguet [HGVOL] Products that are not in an open ticket should be deleted from the local database 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-03-22 16:54aaroncaleroNew Issue
2016-03-22 16:54aaroncaleroAssigned To => Sandrahuguet
2016-03-22 16:54aaroncaleroTriggers an Emergency Pack => No
2016-03-29 10:06daniOpenbravoIssue Monitored: daniOpenbravo
2016-04-06 09:52SandrahuguetStatusnew => scheduled
2016-04-07 13:10SandrahuguetRelationship addedrelated to 0030885
2016-04-08 10:51SandrahuguetReview Assigned To => mtaal
2016-04-13 15:50SandrahuguetRelationship addeddepends on 0032662
2016-04-18 16:54SandrahuguetRelationship addeddepends on 0032693
2016-04-18 16:54SandrahuguetRelationship deletedrelated to 0030885
2016-04-19 08:42hgbotCheckin
2016-04-19 08:42hgbotNote Added: 0085722
2016-04-19 08:42hgbotStatusscheduled => resolved
2016-04-19 08:42hgbotResolutionopen => fixed
2016-04-19 08:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/26b6900d6a0b1267a168ae47ab6080099cce4603 [^]
2016-04-19 08:44hgbotCheckin
2016-04-19 08:44hgbotNote Added: 0085725
2016-04-19 10:26hgbotCheckin
2016-04-19 10:26hgbotNote Added: 0085737
2016-04-26 09:11SandrahuguetReview Assigned Tomtaal => marvintm
2016-04-26 12:19marvintmStatusresolved => closed
2016-04-26 12:19marvintmFixed in Version => RR16Q3
2016-05-05 09:37SandrahuguetRelationship addedrelated to 0032867

Notes
(0085722)
hgbot   
2016-04-19 08:42   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 26b6900d6a0b1267a168ae47ab6080099cce4603
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon Apr 18 17:43:11 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/26b6900d6a0b1267a168ae47ab6080099cce4603 [^]

Fixed issue 32533 Discounts by product characteristics in remote mode

websql tables related to product characteristics filled with the
characteristics of the current product

"undo action" deletes the product and the characteristics in the local databaseo

---
M src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java
M web/org.openbravo.retail.posterminal/js/model/order.js
---
(0085725)
hgbot   
2016-04-19 08:44   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: d3e4a570de6e835eeb1c56f4903d0c0a17bdb503
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Apr 07 16:14:12 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/d3e4a570de6e835eeb1c56f4903d0c0a17bdb503 [^]

related to issue 32533: Discounts by product characteristics in remote mode

---
M web/org.openbravo.mobile.core/source/data/ob-dal.js
---
(0085737)
hgbot   
2016-04-19 10:26   
Repository: tools/automation/pi-mobile
Changeset: 8434592d245eae91fa683165f3f616c2e2e6554d
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Apr 19 10:25:43 2016 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/8434592d245eae91fa683165f3f616c2e2e6554d [^]

related to issue 32533 added I32533_DiscountsByProductCharacteristic test

---
M src-test/org/openbravo/test/mobile/common/selenium/javascript/TestId.java
A src-test/org/openbravo/test/mobile/quarantine/pack/SHUG/I32533_DiscountsByProductCharacteristic.java
---