Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030261Retail ModulesWeb POSpublic2015-06-26 14:382015-09-04 13:30
Reportermalsasua 
Assigned Tojorge-garcia 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket37085
Regression levelProduction - Confirmed Stable
Regression date2014-11-06
Regression introduced in releaseRR15Q1
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9b8a8c54fe38 [^]
Triggers an Emergency PackNo
Summary0030261: receipts search in WEB POS does not work with the char -
Descriptionwhen the document no of receipts contains the char - and in the string to search is introduced the char -, no receips are displayed
Steps To Reproduce. in backoffice, configure the posterminal with the prefix 1121-1/
. go to webpos
. create and paid a recetipt: documentno 1121-1/100000 is created
. go to search receipt:
search 1121-1
no receipts are displayed
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0030267RR15Q2.3 closed jorge-garcia receipts search in WEB POS does not work with the char - 
depends on backport 0030268RR15Q1.6 closed Retail receipts search in WEB POS does not work with the char - 
depends on backport 0030270RR15Q3 closed jorge-garcia receipts search in WEB POS does not work with the char - 
caused by defect 0028088RR15Q1 closed szapata Errors on the PaidReceiptsHeader when filtering using some characters on the ticket selector on the webpos 
has duplicate defect 0030360 closed Retail Filter in Verified does not work 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-06-26 14:38malsasuaNew Issue
2015-06-26 14:38malsasuaAssigned To => Retail
2015-06-26 14:38malsasuaOBNetwork customer => Yes
2015-06-26 14:38malsasuaSupport ticket => 37085
2015-06-26 14:38malsasuaTriggers an Emergency Pack => No
2015-06-29 10:37malsasuaRegression level => Production - Confirmed Stable
2015-06-29 10:37malsasuaRegression date => 2014-11-06
2015-06-29 10:37malsasuaRegression introduced in release => RR15Q1
2015-06-29 10:37malsasuaRegression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9b8a8c54fe38 [^]
2015-06-29 11:43malsasuaStatusnew => scheduled
2015-06-29 12:03malsasuaStatusscheduled => acknowledged
2015-06-29 12:04malsasuaStatusacknowledged => scheduled
2015-06-29 13:58dmitry_mezentsevRelationship addedcaused by 0028088
2015-07-03 09:35jorge-garciaAssigned ToRetail => jorge-garcia
2015-07-17 14:36hgbotCheckin
2015-07-17 14:36hgbotNote Added: 0078934
2015-07-17 14:36hgbotStatusscheduled => resolved
2015-07-17 14:36hgbotResolutionopen => fixed
2015-07-17 14:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d19002d62d178380fe2ef7ac911e8eaf0ad3f1cc [^]
2015-07-17 14:37hgbotCheckin
2015-07-17 14:37hgbotNote Added: 0078935
2015-07-17 14:50hgbotCheckin
2015-07-17 14:50hgbotNote Added: 0078939
2015-07-27 17:38jorge-garciaRelationship addedhas duplicate 0030360
2015-08-06 17:12hgbotCheckin
2015-08-06 17:12hgbotNote Added: 0079233
2015-08-06 17:12hgbotCheckin
2015-08-06 17:12hgbotNote Added: 0079236
2015-08-14 12:12marvintmReview Assigned To => marvintm
2015-08-14 12:12marvintmStatusresolved => closed
2015-09-04 13:30hgbotCheckin
2015-09-04 13:30hgbotNote Added: 0080120

Notes
(0078934)
hgbot   
2015-07-17 14:36   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: d19002d62d178380fe2ef7ac911e8eaf0ad3f1cc
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Fri Jul 17 14:29:59 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d19002d62d178380fe2ef7ac911e8eaf0ad3f1cc [^]

Fixed issue 30261: Receipts search in WEB POS does not work with the char -

The problem was that the search process removes the char '-' and the filter from
the sql doesn't work as expected. This is a security measure to avoid sql
injection.

The solution is to add named parameters and change the filter value in the sql
string.

Now the filter works fine.

---
M src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java
---
(0078935)
hgbot   
2015-07-17 14:37   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 8cc2b929d1fdeb67e2e7f548da1bf9cdb39323a6
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Fri Jul 17 14:35:23 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/8cc2b929d1fdeb67e2e7f548da1bf9cdb39323a6 [^]

Related to issue 30261: Needed changes in the ProcessHQLQuery

Some changes are necessary in the ProcessHQLQuery file.

It's needed to add the possibility to add named parameters.

---
M src/org/openbravo/mobile/core/process/ProcessHQLQuery.java
---
(0078939)
hgbot   
2015-07-17 14:50   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 3587eeab02c40c175fde1c211b58637a7d1fa78a
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Fri Jul 17 14:49:56 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/3587eeab02c40c175fde1c211b58637a7d1fa78a [^]

Related to issue 30261: Needed changes in the ProcessHQLQuery

sanitizeString process must be deleted

---
M src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java
---
(0079233)
hgbot   
2015-08-06 17:12   
Repository: retail/backports/3.0RR15Q3/org.openbravo.mobile.core
Changeset: e0804400959715dd91094ac6d2650aeafe669f93
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Fri Jul 17 14:35:23 2015 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR15Q3/org.openbravo.mobile.core/rev/e0804400959715dd91094ac6d2650aeafe669f93 [^]

Fixed issue 30270, backport of issue 30261: Needed changes in the ProcessHQLQuery

---
M src/org/openbravo/mobile/core/process/ProcessHQLQuery.java
---
(0079236)
hgbot   
2015-08-06 17:12   
Repository: retail/backports/3.0RR15Q3/org.openbravo.retail.posterminal
Changeset: 47ab94ec787f1ec970a7b13d3734cff957f3616f
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Jul 17 14:47:51 2015 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR15Q3/org.openbravo.retail.posterminal/rev/47ab94ec787f1ec970a7b13d3734cff957f3616f [^]

Fixed issue 30270, backport of issue 30261: Receipts search in WEB POS does not work with the char -

---
M src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java
---
(0080120)
hgbot   
2015-09-04 13:30   
Repository: tools/automation/pi-mobile
Changeset: e1dd451ee76ea66cf9efecabe1c9b1f28ffd5329
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Fri Sep 04 12:47:51 2015 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/e1dd451ee76ea66cf9efecabe1c9b1f28ffd5329 [^]

Verifies issue 30261: Added the 'I30261_30360_SearchWithDash' test

---
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I30261_30360_SearchWithDash.java
---