Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028173Retail ModulesWeb POSpublic2014-11-13 23:402014-12-01 16:38
Reporterjecharri 
Assigned Toaaroncalero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR15Q1 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customerOBPS
Support ticket32415
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028173: When you read a barcode it should fin by upc in upper case and not upc =
DescriptionWhen you read a barcode it should fin by upc in upper case and not upc =
Steps To Reproduce-Create a product and insert upc CAN01
-Go to Web POS and try to find by can01

You will not receive any result
Proposed SolutionChange files

modules//org.openbravo.retail.multiupc/web/org.openbravo.retail.multiupc/js/extendUPCSearch.js <- module Multi UPC/EAN for Products in Web POS
and
modules//org.openbravo.retail.posterminal/web/org.openbravo.retail.posterminal/js/pointofsale/view/keyboardorder.js

and change "upc =" to "upper(upc) = upper(txt)"
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-11-13 23:40jecharriNew Issue
2014-11-13 23:40jecharriAssigned To => marvintm
2014-11-13 23:40jecharriOBNetwork customer => Yes
2014-11-13 23:40jecharriSupport ticket => 32415
2014-11-13 23:40jecharriResolution time => 1419030000
2014-11-13 23:40jecharriTriggers an Emergency Pack => No
2014-11-13 23:42jecharriProposed Solution updated
2014-11-13 23:46jecharriSummaryWhen you read a barcode it should fin by upc ilike and not upc = => When you read a barcode it should fin by upc in upper case and not upc =
2014-11-13 23:46jecharriDescription Updatedbug_revision_view_page.php?rev_id=7049#r7049
2014-11-13 23:46jecharriProposed Solution updated
2014-11-13 23:59mtaalAssigned Tomarvintm => aaroncalero
2014-11-17 12:02hgbotCheckin
2014-11-17 12:02hgbotNote Added: 0071697
2014-11-17 12:02hgbotStatusnew => resolved
2014-11-17 12:02hgbotResolutionopen => fixed
2014-11-17 12:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.multiupc/rev/b7e14fdde24e2662f174edb98a1f7083ab717aed [^]
2014-11-17 12:03hgbotCheckin
2014-11-17 12:03hgbotNote Added: 0071698
2014-11-17 12:03hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.multiupc/rev/b7e14fdde24e2662f174edb98a1f7083ab717aed [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/72f3ed1a02e7c0785ebd093d2fa5dcb93606c99c [^]
2014-11-24 06:12mtaalNote Added: 0071907
2014-11-24 06:12mtaalStatusresolved => new
2014-11-24 06:12mtaalResolutionfixed => open
2014-11-24 13:11hgbotCheckin
2014-11-24 13:11hgbotNote Added: 0071934
2014-11-24 13:11hgbotStatusnew => resolved
2014-11-24 13:11hgbotResolutionopen => fixed
2014-11-24 13:11hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/72f3ed1a02e7c0785ebd093d2fa5dcb93606c99c [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.multiupc/rev/59dce0a5b52b8c5eb8839a2e69ab6a70a73981d6 [^]
2014-11-24 13:12hgbotCheckin
2014-11-24 13:12hgbotNote Added: 0071935
2014-11-24 13:12hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.multiupc/rev/59dce0a5b52b8c5eb8839a2e69ab6a70a73981d6 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/983408437f6ed4461f6fa4f5a22937a8da28d27d [^]
2014-12-01 16:38mtaalReview Assigned To => mtaal
2014-12-01 16:38mtaalNote Added: 0072207
2014-12-01 16:38mtaalStatusresolved => closed
2014-12-01 16:38mtaalFixed in Version => RR15Q1

Notes
(0071697)
hgbot   
2014-11-17 12:02   
Repository: erp/pmods/org.openbravo.retail.multiupc
Changeset: b7e14fdde24e2662f174edb98a1f7083ab717aed
Author: Aaron Calero <aaron.calero <at> openbravo.com>
Date: Mon Nov 17 11:52:32 2014 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.multiupc/rev/b7e14fdde24e2662f174edb98a1f7083ab717aed [^]

Fixed issue 0028173: When you read a barcode it should find by upc doing a case-insensitive search

---
M web/org.openbravo.retail.multiupc/js/extendUPCSearch.js
---
(0071698)
hgbot   
2014-11-17 12:03   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 72f3ed1a02e7c0785ebd093d2fa5dcb93606c99c
Author: Aaron Calero <aaron.calero <at> openbravo.com>
Date: Mon Nov 17 11:55:47 2014 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/72f3ed1a02e7c0785ebd093d2fa5dcb93606c99c [^]

Fixed issue 0028173: When you read a barcode it should find by upc doing a case-insensitive search

---
M web/org.openbravo.retail.posterminal/js/pointofsale/view/keyboardorder.js
---
(0071907)
mtaal   
2014-11-24 06:12   
Instead of using like, it seems better to use the upper SQL functions here.

Example:
select * from m_product product where upper(product.upc) = upper('abc123');
(0071934)
hgbot   
2014-11-24 13:11   
Repository: erp/pmods/org.openbravo.retail.multiupc
Changeset: 59dce0a5b52b8c5eb8839a2e69ab6a70a73981d6
Author: Aaron Calero <aaron.calero <at> openbravo.com>
Date: Mon Nov 24 13:06:11 2014 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.multiupc/rev/59dce0a5b52b8c5eb8839a2e69ab6a70a73981d6 [^]

Fixed issue 0028173: When you read a barcode it should find by upc doing a case-insensitive search

Use upper function and equal comparator instead of the like operator

---
M web/org.openbravo.retail.multiupc/js/extendUPCSearch.js
---
(0071935)
hgbot   
2014-11-24 13:12   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 983408437f6ed4461f6fa4f5a22937a8da28d27d
Author: Aaron Calero <aaron.calero <at> openbravo.com>
Date: Mon Nov 24 13:10:44 2014 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/983408437f6ed4461f6fa4f5a22937a8da28d27d [^]

Fixed issue 0028173: When you read a barcode it should find by upc doing a case-insensitive search

Use upper function and equal comparator instead of the like operator

---
M web/org.openbravo.retail.posterminal/js/pointofsale/view/keyboardorder.js
---
(0072207)
mtaal   
2014-12-01 16:38   
Reviewed and Tested