Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0030261
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSminoralways2015-06-26 14:382015-09-04 13:30
ReportermalsasuaView Statuspublic 
Assigned Tojorge-garcia 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisiond19002d62d17
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
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
Summary

0030261: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0030267RR15Q2.3 closedjorge-garcia receipts search in WEB POS does not work with the char - 
depends on backport 0030268RR15Q1.6 closedRetail receipts search in WEB POS does not work with the char - 
depends on backport 0030270RR15Q3 closedjorge-garcia receipts search in WEB POS does not work with the char - 
caused by defect 0028088RR15Q1 closedszapata Errors on the PaidReceiptsHeader when filtering using some characters on the ticket selector on the webpos 
has duplicate defect 0030360 closedRetail Filter in Verified does not work 

-  Notes
(0078934)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2015-06-26 14:38 malsasua New Issue
2015-06-26 14:38 malsasua Assigned To => Retail
2015-06-26 14:38 malsasua OBNetwork customer => Yes
2015-06-26 14:38 malsasua Support ticket => 37085
2015-06-26 14:38 malsasua Triggers an Emergency Pack => No
2015-06-29 10:37 malsasua Regression level => Production - Confirmed Stable
2015-06-29 10:37 malsasua Regression date => 2014-11-06
2015-06-29 10:37 malsasua Regression introduced in release => RR15Q1
2015-06-29 10:37 malsasua Regression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9b8a8c54fe38 [^]
2015-06-29 11:43 malsasua Status new => scheduled
2015-06-29 12:03 malsasua Status scheduled => acknowledged
2015-06-29 12:04 malsasua Status acknowledged => scheduled
2015-06-29 13:58 dmitry_mezentsev Relationship added caused by 0028088
2015-07-03 09:35 jorge-garcia Assigned To Retail => jorge-garcia
2015-07-17 14:36 hgbot Checkin
2015-07-17 14:36 hgbot Note Added: 0078934
2015-07-17 14:36 hgbot Status scheduled => resolved
2015-07-17 14:36 hgbot Resolution open => fixed
2015-07-17 14:36 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d19002d62d178380fe2ef7ac911e8eaf0ad3f1cc [^]
2015-07-17 14:37 hgbot Checkin
2015-07-17 14:37 hgbot Note Added: 0078935
2015-07-17 14:50 hgbot Checkin
2015-07-17 14:50 hgbot Note Added: 0078939
2015-07-27 17:38 jorge-garcia Relationship added has duplicate 0030360
2015-08-06 17:12 hgbot Checkin
2015-08-06 17:12 hgbot Note Added: 0079233
2015-08-06 17:12 hgbot Checkin
2015-08-06 17:12 hgbot Note Added: 0079236
2015-08-14 12:12 marvintm Review Assigned To => marvintm
2015-08-14 12:12 marvintm Status resolved => closed
2015-09-04 13:30 hgbot Checkin
2015-09-04 13:30 hgbot Note Added: 0080120

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker