Convert filter value for type date

[infodrom/rico3] / minsrc / ricoLiveGridAjax.js

diff --git a/minsrc/ricoLiveGridAjax.js b/minsrc/ricoLiveGridAjax.js
index d239546..7fde76c 100644 (file)
--- a/minsrc/ricoLiveGridAjax.js
+++ b/minsrc/ricoLiveGridAjax.js
@@ -484,6 +484,16 @@ Rico.Buffer.AjaxSQLMethods = {
       queryHash['f['+colnum+'][len]']=c.filterValues.length;
       for (var i=0; i<c.filterValues.length; i++) {
         var fval=c.filterValues[i];
+       if (c.format.type == 'date') {
+           var parts = fval.split('.');
+           if (parts.length > 1) {
+               parts.reverse();
+               for (var j=0; j < parts.length; j++)
+                   if (parts[j].length == 1)
+                       parts[j] = '0' + parts[j].toString();
+               fval = parts.join('-');
+           }
+       }
         if (c.filterOp=='LIKE' && fval.indexOf('*')==-1) {
            if (c.format.filterUI.charAt(1) == '^') fval=fval+'*';
            else if (c.format.filterUI.charAt(1) == '$') fval='*'+fval;