Openbravo Issue Tracking System - Retail Modules
View Issue Details
0037520Retail ModulesWeb POSpublic2017-12-20 09:592018-01-19 09:24
Sandrahuguet 
ranjith_qualiantech_com 
normalmajorhave not tried
closedfixed 
30Openbravo Appliance 14.04
 
RR18Q2 
marvintm
No
0037520: Performance problem in remote mode when filter by best sellers category
Performance problem in remote mode when filter by best sellers category

test failing in hgvol jobs:
https://ci.openbravo.com/view/retail/job/ret-higvol-pgsql/1093/testReport/org.openbravo.test.mobile.retail.pack.selenium.tests.receipts/I32445_FilterByBrandAndBestseller/test/ [^]
In a hgvol environment
-Enable all high volumes preference
-Log in the WebPOS
-Tap on Search
-Select "Best sellers" in product category combo

Slow part:
add(new HQLProperty("case when product.isGeneric is false then "
            + "(case when pli.bestseller = 'Y' then true else false end) "
            + "when (product.isGeneric is true and exists(select 1 "
            + "from Product p3 left join p3.oBRETCOProlProductList as pli3, "
            + "PricingProductPrice ppp3 where p3.genericProduct.id = product.id and "
            + "p3 = ppp3.product and ppp3.priceListVersion.id = :priceListVersionId "
            + "and pli3.obretcoProductlist.id = :productListId and pli3.bestseller = true)) "
            + "then true else false end", "bestseller"));
Reestablish property to:
add(new HQLProperty("pli.bestseller", "bestseller"));

And persist bestsellers information for variant products

Same fix should be aplied to org.openbravo.retail.bestsellers module
https://code.openbravo.com/erp/pmods/org.openbravo.retail.bestsellers/file/35dff2889283/src/org/openbravo/retail/bestsellers/BestSellersProperties.java#l47 [^]
Performance
related to defect 0033057 closed ranjith_qualiantech_com Variants marked as Best Sellers are not listed in Web POS 
related to design defect 0037555 acknowledged Retail Performance problem in remote mode when filter by Best Sellers By Terminal Type 
Issue History
2017-12-20 09:59SandrahuguetNew Issue
2017-12-20 09:59SandrahuguetAssigned To => Retail
2017-12-20 09:59SandrahuguetTriggers an Emergency Pack => No
2017-12-20 10:00SandrahuguetRelationship addedrelated to 0033057
2017-12-20 10:00SandrahuguetTag Attached: Performance
2017-12-20 10:01SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=16485#r16485
2017-12-20 11:14SandrahuguetProposed Solution updated
2017-12-20 11:17SandrahuguetProposed Solution updated
2017-12-21 08:47hgbotCheckin
2017-12-21 08:47hgbotNote Added: 0101179
2017-12-21 08:47SandrahuguetNote Added: 0101180
2017-12-21 16:39SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=16490#r16490
2017-12-27 16:02SandrahuguetRelationship addedrelated to 0037555
2018-01-05 07:39ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2018-01-05 08:46ranjith_qualiantech_comStatusnew => scheduled
2018-01-10 14:33hgbotCheckin
2018-01-10 14:33hgbotNote Added: 0101652
2018-01-10 14:33hgbotCheckin
2018-01-10 14:33hgbotNote Added: 0101653
2018-01-10 14:34hgbotCheckin
2018-01-10 14:34hgbotNote Added: 0101654
2018-01-10 14:34hgbotStatusscheduled => resolved
2018-01-10 14:34hgbotResolutionopen => fixed
2018-01-10 14:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/a31a53d79bda0f8457833c69119c5169cc96d235 [^]
2018-01-10 14:34hgbotCheckin
2018-01-10 14:34hgbotNote Added: 0101655
2018-01-19 09:24marvintmReview Assigned To => marvintm
2018-01-19 09:24marvintmStatusresolved => closed
2018-01-19 09:24marvintmFixed in Version => RR18Q2

Notes
(0101179)
hgbot   
2017-12-21 08:47   
Repository: tools/automation/pi-mobile
Changeset: cdffdc3e522d02aab41013ddcd3db996957f1aab
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Dec 21 08:46:51 2017 +0100
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/cdffdc3e522d02aab41013ddcd3db996957f1aab [^]

related to issue 37520 Remove temporarily from the hgvol jobs

---
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/bestsellers/I32445_FilterByBrandAndBestseller.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I32445_FilterByBrandAndBestseller.java
---
(0101180)
Sandrahuguet   
2017-12-21 08:47   
Please, activate again when the issue will be fixed.
(0101652)
hgbot   
2018-01-10 14:33   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: a30e07b4da8b9a19ae276141f2fee48e7a874c72
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Jan 10 15:18:18 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/a30e07b4da8b9a19ae276141f2fee48e7a874c72 [^]

Related to issue 37520 : Modified besetseller in Product Properties for Performance issue

---
M src/org/openbravo/retail/posterminal/master/ProductProperties.java
---
(0101653)
hgbot   
2018-01-10 14:33   
Repository: tools/automation/pi-mobile
Changeset: aa4c32fa609c6917311304950e0752f327f2fa32
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Jan 10 19:03:11 2018 +0530
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/aa4c32fa609c6917311304950e0752f327f2fa32 [^]

Verifies issue 37520 : Modified automated test 'I33057_VerifyGenericProductsAsBestSeller'

---
M src-test/org/openbravo/test/mobile/retail/extmodules/selenium/tests/bestsellers/I32445_FilterByBrandAndBestseller.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/products/I33057_VerifyGenericProductsAsBestSeller.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I32445_FilterByBrandAndBestseller.java
---
(0101654)
hgbot   
2018-01-10 14:34   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: a31a53d79bda0f8457833c69119c5169cc96d235
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Jan 10 15:18:04 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/a31a53d79bda0f8457833c69119c5169cc96d235 [^]

Fixed issue 37520 : Update product query to get best sellers for Generic products

---
M web/org.openbravo.mobile.core/source/retail/component/ob-retail-product-browser.js
---
(0101655)
hgbot   
2018-01-10 14:34   
Repository: erp/pmods/org.openbravo.retail.bestsellers
Changeset: 0b7e6b7b2d59790c7fa36e425d574a490bbd1b92
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Jan 10 19:03:05 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.bestsellers/rev/0b7e6b7b2d59790c7fa36e425d574a490bbd1b92 [^]

Related to issue 37520 : Modified besetseller Properties for Performance issue

---
M src/org/openbravo/retail/bestsellers/BestSellersProperties.java
---