Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030562Retail ModulesWeb POSpublic2015-08-12 15:212015-09-10 12:33
Reportermaite 
Assigned ToSandrahuguet 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR15Q4Fixed in VersionRR15Q4 
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
Summary0030562: Duplicated table with product characteristic values in local database.
DescriptionThe backend "M_Product_Ch_Value" table is loaded in the pos "M_Product_Ch" and
"M_Product_CH_Value" tables. Both tables have the same information, for each product
their characteristics and its values.
These tables are loaded in
* the "productcharacteristic.js" file using the ProductCharacteristic.java class.
* the "promotions.js" file using the ProductProductChValue.java class

One of those tables should be removed from the local model so that information is
only loaded once.
Steps To ReproduceLogin in a POS Terminal.
Open the developer tools.
Check in the WEBPOS database tables m_product_ch and m_product_ch_value stores the
same information.
Proposed SolutionOne of those tables should be removed from the local model so that information is
only loaded once.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0030563RR15Q4 closed fmolina Loaded product characteristic values of products that are not in the webpos database. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-08-12 15:21maiteNew Issue
2015-08-12 15:21maiteAssigned To => Retail
2015-08-12 15:21maiteTriggers an Emergency Pack => No
2015-08-12 15:22maiteTarget Version => RR15Q4
2015-08-12 15:26maiteSeveritymajor => critical
2015-08-12 15:26maiteIssue Monitored: networkb
2015-08-13 08:52gorkaionRelationship addedrelated to 0030563
2015-08-24 13:24maiteResolution time => 1442354400
2015-09-02 13:22hgbotCheckin
2015-09-02 13:22hgbotNote Added: 0080019
2015-09-02 13:22hgbotStatusnew => resolved
2015-09-02 13:22hgbotResolutionopen => fixed
2015-09-02 13:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/446246b7bebf16970ff5cf952d6321dfab1581f1 [^]
2015-09-02 13:25hgbotCheckin
2015-09-02 13:25hgbotNote Added: 0080020
2015-09-03 15:01hgbotCheckin
2015-09-03 15:01hgbotNote Added: 0080051
2015-09-04 09:35marvintmAssigned ToRetail => Sandrahuguet
2015-09-04 10:10hgbotCheckin
2015-09-04 10:10hgbotNote Added: 0080082
2015-09-04 10:29hgbotCheckin
2015-09-04 10:29hgbotNote Added: 0080084
2015-09-07 11:07marvintmSeveritycritical => major
2015-09-07 11:08marvintmReview Assigned To => marvintm
2015-09-07 11:08marvintmStatusresolved => closed
2015-09-07 11:08marvintmFixed in Version => RR15Q4
2015-09-10 12:33hgbotCheckin
2015-09-10 12:33hgbotNote Added: 0080314

Notes
(0080019)
hgbot   
2015-09-02 13:22   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 446246b7bebf16970ff5cf952d6321dfab1581f1
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Sep 01 18:53:57 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/446246b7bebf16970ff5cf952d6321dfab1581f1 [^]

Fixed issue 30562 removed ProductCharacteristic model

ProductCharacteristicValue and ProductCharacteristic load the same
information in the local database, this is the reason to removed
ProductCharacteristic model.

Renamed ProductChValue model to the correct name CharacteristicValue

---
M src/org/openbravo/retail/posterminal/ApplicationCacheComponent.java
M src/org/openbravo/retail/posterminal/OBPOSComponentProvider.java
M web/org.openbravo.retail.posterminal/js/components/modalproductcharacteristic.js
M web/org.openbravo.retail.posterminal/js/model/promotions.js
M web/org.openbravo.retail.posterminal/js/pointofsale/model/pointofsale-model.js
A src/org/openbravo/retail/posterminal/master/CharacteristicValue.java
A src/org/openbravo/retail/posterminal/master/CharacteristicValueProperties.java
A src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java
A src/org/openbravo/retail/posterminal/master/ProductCharacteristicValueProperties.java
A web/org.openbravo.retail.posterminal/js/model/characteristicvalue.js
A web/org.openbravo.retail.posterminal/js/model/productcharacteristicvalue.js
R src/org/openbravo/retail/posterminal/master/ProductChValue.java
R src/org/openbravo/retail/posterminal/master/ProductChValueProperties.java
R src/org/openbravo/retail/posterminal/master/ProductCharacteristic.java
R src/org/openbravo/retail/posterminal/master/ProductCharacteristicProperties.java
R src/org/openbravo/retail/posterminal/master/ProductProductChValue.java
R src/org/openbravo/retail/posterminal/master/ProductProductChValueProperties.java
R web/org.openbravo.retail.posterminal/js/model/productcharacteristic.js
R web/org.openbravo.retail.posterminal/js/model/productchvalue.js
---
(0080020)
hgbot   
2015-09-02 13:25   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 602f94e79541f3c8b5c2613773f24ad0fba1761b
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Tue Sep 01 18:56:43 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/602f94e79541f3c8b5c2613773f24ad0fba1761b [^]

related to issue 30562 fixed querys

---
M web/org.openbravo.mobile.core/source/retail/component/ob-retail-searchproductcharacteristic.js
---
(0080051)
hgbot   
2015-09-03 15:01   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: fabf5f4fad656336275eb4ce8d85acc9d243e57a
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Sep 03 15:00:28 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/fabf5f4fad656336275eb4ce8d85acc9d243e57a [^]

related to issue 30562 update Copyright

---
M src/org/openbravo/retail/posterminal/master/CharacteristicValue.java
M src/org/openbravo/retail/posterminal/master/CharacteristicValueProperties.java
M src/org/openbravo/retail/posterminal/master/ProductCharacteristicValueProperties.java
---
(0080082)
hgbot   
2015-09-04 10:10   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: e9933ad9366f91c6c8db7b3e719bb6fefa1192ae
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Fri Sep 04 10:09:48 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/e9933ad9366f91c6c8db7b3e719bb6fefa1192ae [^]

Related to issue 30562. Related to issue 30257. Filter hidden characteristics.

It is possible to flag a characteristic as hidden in the Web POS. These
characteristics shouldn't be loaded to the WebPOS.

---
M src/org/openbravo/retail/posterminal/master/CharacteristicValue.java
M src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java
---
(0080084)
hgbot   
2015-09-04 10:29   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 9c48c51a89d26d424023096dd42f8923989be2ed
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Sep 04 10:28:16 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9c48c51a89d26d424023096dd42f8923989be2ed [^]

Related to issue 30562 added incrementalUpdateCriteria

Added incrementalUpdateCriteria in ProductCharacteristicValue mistakenly deleted

---
M src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java
---
(0080314)
hgbot   
2015-09-10 12:33   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: bc4b6a132bd3a5559520775c380b1173159ca547
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Sep 10 12:30:05 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/bc4b6a132bd3a5559520775c380b1173159ca547 [^]

related to issue 30562 added primaryKey

---
M web/org.openbravo.retail.posterminal/js/model/productcharacteristicvalue.js
---