0027539: Generic product is loaded more than once when it has more that one price

Openbravo Issue Tracking System - Retail Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0027539

Retail Modules

Web POS

public

2014-09-04 02:36

2014-11-11 16:25

Reporter

jecharri

Assigned To

mario_castello

Priority

high

Severity

minor

Reproducibility

always

Status

closed

Resolution

unable to reproduce

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

malsasua

OBNetwork customer

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0027539: Generic product is loaded more than once when it has more that one price

Description

Generic product is loaded more than once when it has more that one price

Steps To Reproduce

-Create a generic product with one variant characteristic and set the price in 3 price lists
-Create the variants
-Include the variants in the assortment

Verify that when you login in Web POS you will get the following error

[SQLTransaction, SQLError]0: SQLTransaction1: SQLErrorcallee: function () {length: 2__proto__: Object x {modelName: "Product", tableName: "m_product", entityName: "Product", source: "org.openbravo.retail.posterminal.master.Product", dataLimit: 300…}constructor: function (){a.apply(this,arguments)}dataLimit: 300entityName: "Product"includeTerminalDate: trueinitialize: function () {modelName: "Product"source: "org.openbravo.retail.posterminal.master.Product"tableName: "m_product"__proto__: x

The problem is that query
// generic products
    products
        .add("select "
            + regularProductsHQLProperties.getHqlSelect()
            + " from Product product left outer join product.image img left join product.oBRETCOProlProductList as pli left outer join product.pricingProductPriceList ppp where exists (select 1 from Product product2 left join product2.oBRETCOProlProductList as pli2, PricingProductPrice ppp2 where product.id = product2.genericProduct.id and product2 = ppp2.product and ppp2.priceListVersion.id = '"
            + priceListVersion.getId() + "' and pli2.obretcoProductlist.id = '"
            + productList.getId() + "')");

in file modules/org.openbravo.retail.posterminal/src/org/openbravo/retail/posterminal/master/Product.java
is returning the same generic product more than once.

Proposed Solution

Additional Information