0030268: receipts search in WEB POS does not work with the char -

diff -r ed38a9d04ca3 src/org/openbravo/mobile/core/process/ProcessHQLQuery.java
--- a/src/org/openbravo/mobile/core/process/ProcessHQLQuery.java	Tue May 26 09:50:21 2015 +0000
+++ b/src/org/openbravo/mobile/core/process/ProcessHQLQuery.java	Mon Jul 27 19:36:14 2015 +0200
@@ -15,6 +15,7 @@
 import java.util.Date;
 import java.util.Iterator;
 import java.util.List;
+import java.util.Map;
 
 import javax.servlet.ServletException;
 
@@ -43,6 +44,10 @@
     return ProcessHQLQuery.StrategyQueryScroll;
   }
 
+  protected Map<String, Object> getParameterValues(JSONObject jsonsent) throws JSONException {
+    return null;
+  }
+
   @Override
   public final void exec(Writer w, JSONObject jsonsent) throws IOException, ServletException {
     Query rememberQueryForErrorLog = null;
@@ -60,6 +65,7 @@
 
       int totalRows = 0;
       boolean firstQuery = true;
+      Map<String, Object> parameterValues = this.getParameterValues(jsonsent);
       for (String hqlQuery : getQuery(jsonsent)) {
         rememberQueryForErrorLog = null;
 
@@ -69,6 +75,11 @@
 
         final Session session = OBDal.getInstance().getSession();
         final Query query = session.createQuery(querybuilder.getHQLQuery());
+        if (parameterValues != null) {
+          for (String paramName : parameterValues.keySet()) {
+            query.setParameter(paramName, parameterValues.get(paramName).toString());
+          }
+        }
         rememberQueryForErrorLog = query;
 
         if (jsonsent.has("_limit")) {

diff -r e960d2465cd5 src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java
--- a/src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java	Mon Jun 22 05:36:15 2015 +0000
+++ b/src/org/openbravo/retail/posterminal/PaidReceiptsHeader.java	Tue Aug 11 14:35:53 2015 +0200
@@ -9,7 +9,9 @@
 package org.openbravo.retail.posterminal;
 
 import java.util.Arrays;
+import java.util.HashMap;
 import java.util.List;
+import java.util.Map;
 
 import org.codehaus.jettison.json.JSONArray;
 import org.codehaus.jettison.json.JSONException;
@@ -23,6 +25,18 @@
   }
 
   @Override
+  protected Map<String, Object> getParameterValues(JSONObject jsonsent) throws JSONException {
+    if (!jsonsent.getJSONObject("filters").getString("filterText").isEmpty()) {
+      Map<String, Object> paramValues = new HashMap<String, Object>();
+      paramValues.put("filterT1", ("%"
+          + jsonsent.getJSONObject("filters").getString("filterText").trim() + "%"));
+      return paramValues;
+    } else {
+      return null;
+    }
+  }
+
+  @Override
   protected List<String> getQuery(JSONObject jsonsent) throws JSONException {
 
     // OBContext.setAdminMode(true);
@@ -41,12 +55,10 @@
         + json.getString("organization")
         + "' and ord.obposApplications is not null";
 
-    final String filterText = sanitizeString(json.getString("filterText"));
-    if (!filterText.isEmpty()) {
-      hqlPaidReceipts += " and (ord.documentNo like '%" + filterText
-          + "%' or REPLACE(ord.documentNo, '/', '') like '%" + filterText
-          + "%' or upper(ord.businessPartner.name) like upper('%" + filterText + "%')) ";
+    if (!json.getString("filterText").isEmpty()) {
+      hqlPaidReceipts += " and (ord.documentNo like :filterT1 or REPLACE(ord.documentNo, '/', '') like :filterT1 or upper(ord.businessPartner.name) like upper(:filterT1)) ";
     }
+
     if (!json.isNull("documentType")) {
       JSONArray docTypes = json.getJSONArray("documentType");
       hqlPaidReceipts += " and ( ";