/*
|
*
|
* The filter uses JSON entities to hold filter rules and groups. Here is an example of a filter:
|
|
{ "groupOp": "AND",
|
"groups" : [
|
{ "groupOp": "OR",
|
"rules": [
|
{ "field": "name", "op": "eq", "data": "England" },
|
{ "field": "id", "op": "le", "data": "5"}
|
]
|
}
|
],
|
"rules": [
|
{ "field": "name", "op": "eq", "data": "Romania" },
|
{ "field": "id", "op": "le", "data": "1"}
|
]
|
}
|
*/
|
/*jshint eqeqeq:false, eqnull:true, devel:true */
|
/*global jQuery, define */
|
|
(function( factory ) {
|
"use strict";
|
if ( typeof define === "function" && define.amd ) {
|
// AMD. Register as an anonymous module.
|
define([
|
"jquery",
|
"./grid.base",
|
"./grid.common"
|
], factory );
|
} else {
|
// Browser globals
|
factory( jQuery );
|
}
|
}(function( $ ) {
|
"use strict";
|
//module begin
|
$.fn.jqFilter = function( arg ) {
|
if (typeof arg === 'string') {
|
|
var fn = $.fn.jqFilter[arg];
|
if (!fn) {
|
throw ("jqFilter - No such method: " + arg);
|
}
|
var args = $.makeArray(arguments).slice(1);
|
return fn.apply(this,args);
|
}
|
|
var p = $.extend(true,{
|
filter: null,
|
columns: [],
|
sortStrategy: null,
|
onChange : null,
|
afterRedraw : null,
|
checkValues : null,
|
error: false,
|
errmsg : "",
|
errorcheck : true,
|
showQuery : true,
|
sopt : null,
|
ops : [],
|
operands : null,
|
numopts : ['eq','ne', 'lt', 'le', 'gt', 'ge', 'nu', 'nn', 'in', 'ni'],
|
stropts : ['eq', 'ne', 'bw', 'bn', 'ew', 'en', 'cn', 'nc', 'nu', 'nn', 'in', 'ni'],
|
strarr : ['text', 'string', 'blob'],
|
groupOps : [{ op: "AND", text: "AND" }, { op: "OR", text: "OR" }],
|
groupButton : true,
|
ruleButtons : true,
|
uniqueSearchFields : false,
|
direction : "ltr"
|
}, $.jgrid.filter, arg || {});
|
return this.each( function() {
|
if (this.filter) {return;}
|
this.p = p;
|
// setup filter in case if they is not defined
|
if (this.p.filter === null || this.p.filter === undefined) {
|
this.p.filter = {
|
groupOp: this.p.groupOps[0].op,
|
rules: [],
|
groups: []
|
};
|
}
|
|
// Sort the columns if the sort strategy is provided.
|
if (this.p.sortStrategy != null && $.isFunction(this.p.sortStrategy)) {
|
this.p.columns.sort(this.p.sortStrategy);
|
}
|
|
var i, len = this.p.columns.length, cl,
|
isIE = /msie/i.test(navigator.userAgent) && !window.opera;
|
|
// translating the options
|
this.p.initFilter = $.extend(true,{},this.p.filter);
|
|
// set default values for the columns if they are not set
|
if( !len ) {return;}
|
for(i=0; i < len; i++) {
|
cl = this.p.columns[i];
|
if( cl.stype ) {
|
// grid compatibility
|
cl.inputtype = cl.stype;
|
} else if(!cl.inputtype) {
|
cl.inputtype = 'text';
|
}
|
if( cl.sorttype ) {
|
// grid compatibility
|
cl.searchtype = cl.sorttype;
|
} else if (!cl.searchtype) {
|
cl.searchtype = 'string';
|
}
|
if(cl.hidden === undefined) {
|
// jqGrid compatibility
|
cl.hidden = false;
|
}
|
if(!cl.label) {
|
cl.label = cl.name;
|
}
|
if(cl.index) {
|
cl.name = cl.index;
|
}
|
if(!cl.hasOwnProperty('searchoptions')) {
|
cl.searchoptions = {};
|
}
|
if(!cl.hasOwnProperty('searchrules')) {
|
cl.searchrules = {};
|
}
|
if(cl.search === undefined) {
|
cl.inlist = true;
|
} else {
|
cl.inlist = cl.search;
|
}
|
}
|
var getGrid = function () {
|
return $("#" + $.jgrid.jqID(p.id))[0] || null;
|
},
|
|
$tg = getGrid(),
|
classes = $.jgrid.styleUI[($tg.p.styleUI || 'jQueryUI')].filter,
|
common = $.jgrid.styleUI[($tg.p.styleUI || 'jQueryUI')].common;
|
|
|
if(this.p.showQuery) {
|
$(this).append("<table class='queryresult " + classes.table_widget + "' style='display:block;max-width:440px;border:0px none;' dir='"+this.p.direction+"'><tbody><tr><td class='query'></td></tr></tbody></table>");
|
}
|
/*
|
*Perform checking.
|
*
|
*/
|
var checkData = function(val, colModelItem) {
|
var ret = [true,""], $t = getGrid();
|
if($.isFunction(colModelItem.searchrules)) {
|
ret = colModelItem.searchrules.call($t, val, colModelItem);
|
} else if($.jgrid && $.jgrid.checkValues) {
|
try {
|
ret = $.jgrid.checkValues.call($t, val, -1, colModelItem.searchrules, colModelItem.label);
|
} catch (e) {}
|
}
|
if(ret && ret.length && ret[0] === false) {
|
p.error = !ret[0];
|
p.errmsg = ret[1];
|
}
|
};
|
/* moving to common
|
randId = function() {
|
return Math.floor(Math.random()*10000).toString();
|
};
|
*/
|
|
this.onchange = function ( ){
|
// clear any error
|
this.p.error = false;
|
this.p.errmsg="";
|
return $.isFunction(this.p.onChange) ? this.p.onChange.call( this, this.p ) : false;
|
};
|
/*
|
* Redraw the filter every time when new field is added/deleted
|
* and field is changed
|
*/
|
this.reDraw = function() {
|
$("table.group:first",this).remove();
|
var t = this.createTableForGroup(p.filter, null);
|
$(this).append(t);
|
if($.isFunction(this.p.afterRedraw) ) {
|
this.p.afterRedraw.call(this, this.p);
|
}
|
};
|
/*
|
* Creates a grouping data for the filter
|
* @param group - object
|
* @param parentgroup - object
|
*/
|
this.createTableForGroup = function(group, parentgroup) {
|
var that = this, i;
|
// this table will hold all the group (tables) and rules (rows)
|
var table = $("<table class='group " + classes.table_widget +" ui-search-table' style='border:0px none;'><tbody></tbody></table>"),
|
// create error message row
|
align = "left";
|
if(this.p.direction === "rtl") {
|
align = "right";
|
table.attr("dir","rtl");
|
}
|
if(parentgroup === null) {
|
table.append("<tr class='error' style='display:none;'><th colspan='5' class='" + common.error + "' align='"+align+"'></th></tr>");
|
}
|
|
var tr = $("<tr></tr>");
|
table.append(tr);
|
// this header will hold the group operator type and group action buttons for
|
// creating subgroup "+ {}", creating rule "+" or deleting the group "-"
|
var th = $("<th colspan='5' align='"+align+"'></th>");
|
tr.append(th);
|
|
if(this.p.ruleButtons === true) {
|
// dropdown for: choosing group operator type
|
var groupOpSelect = $("<select class='opsel " + classes.srSelect + "'></select>");
|
th.append(groupOpSelect);
|
// populate dropdown with all posible group operators: or, and
|
var str= "", selected;
|
for (i = 0; i < p.groupOps.length; i++) {
|
selected = group.groupOp === that.p.groupOps[i].op ? " selected='selected'" :"";
|
str += "<option value='"+that.p.groupOps[i].op+"'" + selected+">"+that.p.groupOps[i].text+"</option>";
|
}
|
|
groupOpSelect
|
.append(str)
|
.bind('change',function() {
|
group.groupOp = $(groupOpSelect).val();
|
that.onchange(); // signals that the filter has changed
|
});
|
}
|
// button for adding a new subgroup
|
var inputAddSubgroup ="<span></span>";
|
if(this.p.groupButton) {
|
inputAddSubgroup = $("<input type='button' value='+ {}' title='Add subgroup' class='add-group " + common.button + "'/>");
|
inputAddSubgroup.bind('click',function() {
|
if (group.groups === undefined ) {
|
group.groups = [];
|
}
|
|
group.groups.push({
|
groupOp: p.groupOps[0].op,
|
rules: [],
|
groups: []
|
}); // adding a new group
|
|
that.reDraw(); // the html has changed, force reDraw
|
|
that.onchange(); // signals that the filter has changed
|
return false;
|
});
|
}
|
th.append(inputAddSubgroup);
|
if(this.p.ruleButtons === true) {
|
// button for adding a new rule
|
var inputAddRule = $("<input type='button' value='+' title='Add rule' class='add-rule ui-add " + common.button + "'/>"), cm;
|
inputAddRule.bind('click',function() {
|
//if(!group) { group = {};}
|
if (group.rules === undefined) {
|
group.rules = [];
|
}
|
for (i = 0; i < that.p.columns.length; i++) {
|
// but show only serchable and serchhidden = true fields
|
var searchable = (that.p.columns[i].search === undefined) ? true: that.p.columns[i].search,
|
hidden = (that.p.columns[i].hidden === true),
|
ignoreHiding = (that.p.columns[i].searchoptions.searchhidden === true);
|
if ((ignoreHiding && searchable) || (searchable && !hidden)) {
|
cm = that.p.columns[i];
|
break;
|
}
|
}
|
if( !cm ) {
|
return false;
|
}
|
var opr;
|
if( cm.searchoptions.sopt ) {opr = cm.searchoptions.sopt;}
|
else if(that.p.sopt) { opr= that.p.sopt; }
|
else if ( $.inArray(cm.searchtype, that.p.strarr) !== -1 ) {opr = that.p.stropts;}
|
else {opr = that.p.numopts;}
|
|
group.rules.push({
|
field: cm.name,
|
op: opr[0],
|
data: ""
|
}); // adding a new rule
|
|
that.reDraw(); // the html has changed, force reDraw
|
// for the moment no change have been made to the rule, so
|
// this will not trigger onchange event
|
return false;
|
});
|
th.append(inputAddRule);
|
}
|
|
// button for delete the group
|
if (parentgroup !== null) { // ignore the first group
|
var inputDeleteGroup = $("<input type='button' value='-' title='Delete group' class='delete-group " + common.button + "'/>");
|
th.append(inputDeleteGroup);
|
inputDeleteGroup.bind('click',function() {
|
// remove group from parent
|
for (i = 0; i < parentgroup.groups.length; i++) {
|
if (parentgroup.groups[i] === group) {
|
parentgroup.groups.splice(i, 1);
|
break;
|
}
|
}
|
|
that.reDraw(); // the html has changed, force reDraw
|
|
that.onchange(); // signals that the filter has changed
|
return false;
|
});
|
}
|
|
// append subgroup rows
|
if (group.groups !== undefined) {
|
for (i = 0; i < group.groups.length; i++) {
|
var trHolderForSubgroup = $("<tr></tr>");
|
table.append(trHolderForSubgroup);
|
|
var tdFirstHolderForSubgroup = $("<td class='first'></td>");
|
trHolderForSubgroup.append(tdFirstHolderForSubgroup);
|
|
var tdMainHolderForSubgroup = $("<td colspan='4'></td>");
|
tdMainHolderForSubgroup.append(this.createTableForGroup(group.groups[i], group));
|
trHolderForSubgroup.append(tdMainHolderForSubgroup);
|
}
|
}
|
if(group.groupOp === undefined) {
|
group.groupOp = that.p.groupOps[0].op;
|
}
|
|
// append rules rows
|
var suni = that.p.ruleButtons && that.p.uniqueSearchFields;
|
if( suni ) {
|
for (var ii = 0; ii < that.p.columns.length; ii++) {
|
if(that.p.columns[ii].inlist) {
|
that.p.columns[ii].search = true;
|
}
|
}
|
}
|
if (group.rules !== undefined) {
|
for (i = 0; i < group.rules.length; i++) {
|
table.append(
|
this.createTableRowForRule(group.rules[i], group)
|
);
|
if( suni ) {
|
var field = group.rules[i].field;
|
for (var ii = 0; ii < that.p.columns.length; ii++) {
|
if(field === that.p.columns[ii].name) {
|
that.p.columns[ii].search = false;
|
break;
|
}
|
}
|
}
|
}
|
}
|
return table;
|
};
|
/*
|
* Create the rule data for the filter
|
*/
|
this.createTableRowForRule = function(rule, group ) {
|
// save current entity in a variable so that it could
|
// be referenced in anonimous method calls
|
|
var that=this, $t = getGrid(), tr = $("<tr></tr>"),
|
//document.createElement("tr"),
|
|
// first column used for padding
|
//tdFirstHolderForRule = document.createElement("td"),
|
i, op, trpar, cm, str="", selected;
|
//tdFirstHolderForRule.setAttribute("class", "first");
|
tr.append("<td class='first'></td>");
|
|
|
// create field container
|
var ruleFieldTd = $("<td class='columns'></td>");
|
tr.append(ruleFieldTd);
|
|
|
// dropdown for: choosing field
|
var ruleFieldSelect = $("<select class='" + classes.srSelect + "'></select>"), ina, aoprs = [];
|
ruleFieldTd.append(ruleFieldSelect);
|
ruleFieldSelect.bind('change',function() {
|
rule.field = $(ruleFieldSelect).val();
|
|
trpar = $(this).parents("tr:first");
|
$(".data",trpar).empty();
|
for (i=0;i<that.p.columns.length;i++) {
|
if(that.p.columns[i].name === rule.field) {
|
cm = that.p.columns[i];
|
break;
|
}
|
}
|
if(!cm) {return;}
|
cm.searchoptions.id = $.jgrid.randId();
|
cm.searchoptions.name = rule.field;
|
cm.searchoptions.oper = 'filter';
|
|
if(isIE && cm.inputtype === "text") {
|
if(!cm.searchoptions.size) {
|
cm.searchoptions.size = 10;
|
}
|
}
|
var elm = $.jgrid.createEl.call($t, cm.inputtype,cm.searchoptions, "", true, that.p.ajaxSelectOptions || {}, true);
|
$(elm).addClass("input-elm " + classes.srInput );
|
//that.createElement(rule, "");
|
|
if( cm.searchoptions.sopt ) {op = cm.searchoptions.sopt;}
|
else if(that.p.sopt) { op= that.p.sopt; }
|
else if ($.inArray(cm.searchtype, that.p.strarr) !== -1) {op = that.p.stropts;}
|
else {op = that.p.numopts;}
|
// operators
|
var s ="", so = 0;
|
aoprs = [];
|
$.each(that.p.ops, function() { aoprs.push(this.oper); });
|
for ( i = 0 ; i < op.length; i++) {
|
ina = $.inArray(op[i],aoprs);
|
if(ina !== -1) {
|
if(so===0) {
|
rule.op = that.p.ops[ina].oper;
|
}
|
s += "<option value='"+that.p.ops[ina].oper+"'>"+that.p.ops[ina].text+"</option>";
|
so++;
|
}
|
}
|
$(".selectopts",trpar).empty().append( s );
|
$(".selectopts",trpar)[0].selectedIndex = 0;
|
if( $.jgrid.msie && $.jgrid.msiever() < 9) {
|
var sw = parseInt($("select.selectopts",trpar)[0].offsetWidth, 10) + 1;
|
$(".selectopts",trpar).width( sw );
|
$(".selectopts",trpar).css("width","auto");
|
}
|
// data
|
$(".data",trpar).append( elm );
|
$.jgrid.bindEv.call($t, elm, cm.searchoptions);
|
$(".input-elm",trpar).bind('change',function( e ) {
|
var elem = e.target;
|
rule.data = elem.nodeName.toUpperCase() === "SPAN" && cm.searchoptions && $.isFunction(cm.searchoptions.custom_value) ?
|
cm.searchoptions.custom_value.call($t, $(elem).children(".customelement:first"), 'get') : elem.value;
|
that.onchange(); // signals that the filter has changed
|
});
|
setTimeout(function(){ //IE, Opera, Chrome
|
rule.data = $(elm).val();
|
that.onchange(); // signals that the filter has changed
|
}, 0);
|
});
|
|
// populate drop down with user provided column definitions
|
var j=0;
|
for (i = 0; i < that.p.columns.length; i++) {
|
// but show only serchable and serchhidden = true fields
|
var searchable = (that.p.columns[i].search === undefined) ? true: that.p.columns[i].search,
|
hidden = (that.p.columns[i].hidden === true),
|
ignoreHiding = (that.p.columns[i].searchoptions.searchhidden === true);
|
if ((ignoreHiding && searchable) || (searchable && !hidden)) {
|
selected = "";
|
if(rule.field === that.p.columns[i].name) {
|
selected = " selected='selected'";
|
j=i;
|
}
|
str += "<option value='"+that.p.columns[i].name+"'" +selected+">"+that.p.columns[i].label+"</option>";
|
}
|
}
|
ruleFieldSelect.append( str );
|
|
|
// create operator container
|
var ruleOperatorTd = $("<td class='operators'></td>");
|
tr.append(ruleOperatorTd);
|
cm = p.columns[j];
|
// create it here so it can be referentiated in the onchange event
|
//var RD = that.createElement(rule, rule.data);
|
cm.searchoptions.id = $.jgrid.randId();
|
if(isIE && cm.inputtype === "text") {
|
if(!cm.searchoptions.size) {
|
cm.searchoptions.size = 10;
|
}
|
}
|
cm.searchoptions.name = rule.field;
|
cm.searchoptions.oper = 'filter';
|
var ruleDataInput = $.jgrid.createEl.call($t, cm.inputtype,cm.searchoptions, rule.data, true, that.p.ajaxSelectOptions || {}, true);
|
if(rule.op === 'nu' || rule.op === 'nn') {
|
$(ruleDataInput).attr('readonly','true');
|
$(ruleDataInput).attr('disabled','true');
|
} //retain the state of disabled text fields in case of null ops
|
// dropdown for: choosing operator
|
var ruleOperatorSelect = $("<select class='selectopts " + classes.srSelect + "'></select>");
|
ruleOperatorTd.append(ruleOperatorSelect);
|
ruleOperatorSelect.bind('change',function() {
|
rule.op = $(ruleOperatorSelect).val();
|
trpar = $(this).parents("tr:first");
|
var rd = $(".input-elm",trpar)[0];
|
if (rule.op === "nu" || rule.op === "nn") { // disable for operator "is null" and "is not null"
|
rule.data = "";
|
if(rd.tagName.toUpperCase() !== 'SELECT') { rd.value = ""; }
|
rd.setAttribute("readonly", "true");
|
rd.setAttribute("disabled", "true");
|
} else {
|
if(rd.tagName.toUpperCase() === 'SELECT') { rule.data = rd.value; }
|
rd.removeAttribute("readonly");
|
rd.removeAttribute("disabled");
|
}
|
|
that.onchange(); // signals that the filter has changed
|
});
|
|
// populate drop down with all available operators
|
if( cm.searchoptions.sopt ) {op = cm.searchoptions.sopt;}
|
else if(that.p.sopt) { op= that.p.sopt; }
|
else if ($.inArray(cm.searchtype, that.p.strarr) !== -1) {op = that.p.stropts;}
|
else {op = that.p.numopts;}
|
str="";
|
$.each(that.p.ops, function() { aoprs.push(this.oper); });
|
for ( i = 0; i < op.length; i++) {
|
ina = $.inArray(op[i],aoprs);
|
if(ina !== -1) {
|
selected = rule.op === that.p.ops[ina].oper ? " selected='selected'" : "";
|
str += "<option value='"+that.p.ops[ina].oper+"'"+selected+">"+that.p.ops[ina].text+"</option>";
|
}
|
}
|
ruleOperatorSelect.append( str );
|
// create data container
|
var ruleDataTd = $("<td class='data'></td>");
|
tr.append(ruleDataTd);
|
|
// textbox for: data
|
// is created previously
|
//ruleDataInput.setAttribute("type", "text");
|
ruleDataTd.append(ruleDataInput);
|
$.jgrid.bindEv.call($t, ruleDataInput, cm.searchoptions);
|
$(ruleDataInput)
|
.addClass("input-elm " + classes.srInput )
|
.bind('change', function() {
|
rule.data = cm.inputtype === 'custom' ? cm.searchoptions.custom_value.call($t, $(this).children(".customelement:first"),'get') : $(this).val();
|
that.onchange(); // signals that the filter has changed
|
});
|
|
// create action container
|
var ruleDeleteTd = $("<td></td>");
|
tr.append(ruleDeleteTd);
|
|
// create button for: delete rule
|
if(this.p.ruleButtons === true) {
|
var ruleDeleteInput = $("<input type='button' value='-' title='Delete rule' class='delete-rule ui-del " + common.button + "'/>");
|
ruleDeleteTd.append(ruleDeleteInput);
|
//$(ruleDeleteInput).html("").height(20).width(30).button({icons: { primary: "ui-icon-minus", text:false}});
|
ruleDeleteInput.bind('click',function() {
|
// remove rule from group
|
for (i = 0; i < group.rules.length; i++) {
|
if (group.rules[i] === rule) {
|
group.rules.splice(i, 1);
|
break;
|
}
|
}
|
|
that.reDraw(); // the html has changed, force reDraw
|
|
that.onchange(); // signals that the filter has changed
|
return false;
|
});
|
}
|
return tr;
|
};
|
|
this.getStringForGroup = function(group) {
|
var s = "(", index;
|
if (group.groups !== undefined) {
|
for (index = 0; index < group.groups.length; index++) {
|
if (s.length > 1) {
|
s += " " + group.groupOp + " ";
|
}
|
try {
|
s += this.getStringForGroup(group.groups[index]);
|
} catch (eg) {alert(eg);}
|
}
|
}
|
|
if (group.rules !== undefined) {
|
try{
|
for (index = 0; index < group.rules.length; index++) {
|
if (s.length > 1) {
|
s += " " + group.groupOp + " ";
|
}
|
s += this.getStringForRule(group.rules[index]);
|
}
|
} catch (e) {alert(e);}
|
}
|
|
s += ")";
|
|
if (s === "()") {
|
return ""; // ignore groups that don't have rules
|
}
|
return s;
|
};
|
this.getStringForRule = function(rule) {
|
var opUF = "",opC="", i, cm, ret, val,
|
numtypes = ['int', 'integer', 'float', 'number', 'currency']; // jqGrid
|
for (i = 0; i < this.p.ops.length; i++) {
|
if (this.p.ops[i].oper === rule.op) {
|
opUF = this.p.operands.hasOwnProperty(rule.op) ? this.p.operands[rule.op] : "";
|
opC = this.p.ops[i].oper;
|
break;
|
}
|
}
|
for (i=0; i<this.p.columns.length; i++) {
|
if(this.p.columns[i].name === rule.field) {
|
cm = this.p.columns[i];
|
break;
|
}
|
}
|
if (cm === undefined) { return ""; }
|
val = rule.data;
|
if(opC === 'bw' || opC === 'bn') { val = val+"%"; }
|
if(opC === 'ew' || opC === 'en') { val = "%"+val; }
|
if(opC === 'cn' || opC === 'nc') { val = "%"+val+"%"; }
|
if(opC === 'in' || opC === 'ni') { val = " ("+val+")"; }
|
if(p.errorcheck) { checkData(rule.data, cm); }
|
if($.inArray(cm.searchtype, numtypes) !== -1 || opC === 'nn' || opC === 'nu') { ret = rule.field + " " + opUF + " " + val; }
|
else { ret = rule.field + " " + opUF + " \"" + val + "\""; }
|
return ret;
|
};
|
this.resetFilter = function () {
|
this.p.filter = $.extend(true,{},this.p.initFilter);
|
this.reDraw();
|
this.onchange();
|
};
|
this.hideError = function() {
|
$("th."+common.error, this).html("");
|
$("tr.error", this).hide();
|
};
|
this.showError = function() {
|
$("th."+common.error, this).html(this.p.errmsg);
|
$("tr.error", this).show();
|
};
|
this.toUserFriendlyString = function() {
|
return this.getStringForGroup(p.filter);
|
};
|
this.toString = function() {
|
// this will obtain a string that can be used to match an item.
|
var that = this;
|
function getStringRule(rule) {
|
if(that.p.errorcheck) {
|
var i, cm;
|
for (i=0; i<that.p.columns.length; i++) {
|
if(that.p.columns[i].name === rule.field) {
|
cm = that.p.columns[i];
|
break;
|
}
|
}
|
if(cm) {checkData(rule.data, cm);}
|
}
|
return rule.op + "(item." + rule.field + ",'" + rule.data + "')";
|
}
|
|
function getStringForGroup(group) {
|
var s = "(", index;
|
|
if (group.groups !== undefined) {
|
for (index = 0; index < group.groups.length; index++) {
|
if (s.length > 1) {
|
if (group.groupOp === "OR") {
|
s += " || ";
|
}
|
else {
|
s += " && ";
|
}
|
}
|
s += getStringForGroup(group.groups[index]);
|
}
|
}
|
|
if (group.rules !== undefined) {
|
for (index = 0; index < group.rules.length; index++) {
|
if (s.length > 1) {
|
if (group.groupOp === "OR") {
|
s += " || ";
|
}
|
else {
|
s += " && ";
|
}
|
}
|
s += getStringRule(group.rules[index]);
|
}
|
}
|
|
s += ")";
|
|
if (s === "()") {
|
return ""; // ignore groups that don't have rules
|
}
|
return s;
|
}
|
|
return getStringForGroup(this.p.filter);
|
};
|
|
// Here we init the filter
|
this.reDraw();
|
|
if(this.p.showQuery) {
|
this.onchange();
|
}
|
// mark is as created so that it will not be created twice on this element
|
this.filter = true;
|
});
|
};
|
$.extend($.fn.jqFilter,{
|
/*
|
* Return SQL like string. Can be used directly
|
*/
|
toSQLString : function()
|
{
|
var s ="";
|
this.each(function(){
|
s = this.toUserFriendlyString();
|
});
|
return s;
|
},
|
/*
|
* Return filter data as object.
|
*/
|
filterData : function()
|
{
|
var s;
|
this.each(function(){
|
s = this.p.filter;
|
});
|
return s;
|
|
},
|
getParameter : function (param) {
|
if(param !== undefined) {
|
if (this.p.hasOwnProperty(param) ) {
|
return this.p[param];
|
}
|
}
|
return this.p;
|
},
|
resetFilter: function() {
|
return this.each(function(){
|
this.resetFilter();
|
});
|
},
|
addFilter: function (pfilter) {
|
if (typeof pfilter === "string") {
|
pfilter = $.jgrid.parse( pfilter );
|
}
|
this.each(function(){
|
this.p.filter = pfilter;
|
this.reDraw();
|
this.onchange();
|
});
|
}
|
|
});
|
$.jgrid.extend({
|
filterToolbar : function(p){
|
var regional = $.jgrid.getRegional(this[0], 'search');
|
p = $.extend({
|
autosearch: true,
|
autosearchDelay: 500,
|
searchOnEnter : true,
|
beforeSearch: null,
|
afterSearch: null,
|
beforeClear: null,
|
afterClear: null,
|
onClearSearchValue : null,
|
searchurl : '',
|
stringResult: false,
|
groupOp: 'AND',
|
defaultSearch : "bw",
|
searchOperators : false,
|
resetIcon : "x",
|
splitSelect : ",",
|
groupOpSelect : "OR",
|
operands : { "eq" :"==", "ne":"!","lt":"<","le":"<=","gt":">","ge":">=","bw":"^","bn":"!^","in":"=","ni":"!=","ew":"|","en":"!@","cn":"~","nc":"!~","nu":"#","nn":"!#", "bt":"..."}
|
}, regional , p || {});
|
return this.each(function(){
|
var $t = this;
|
if($t.p.filterToolbar) { return; }
|
if(!$($t).data('filterToolbar')) {
|
$($t).data('filterToolbar', p);
|
}
|
if($t.p.force_regional) {
|
p = $.extend(p, regional);
|
}
|
var classes = $.jgrid.styleUI[($t.p.styleUI || 'jQueryUI')].filter,
|
common = $.jgrid.styleUI[($t.p.styleUI || 'jQueryUI')].common,
|
base = $.jgrid.styleUI[($t.p.styleUI || 'jQueryUI')].base,
|
|
triggerToolbar = function() {
|
var sdata={}, j=0, v, nm, sopt={},so, ms = false, ssfield = [], bbt =false, sop;
|
$.each($t.p.colModel,function(){
|
var $elem = $("#gs_"+ $t.p.idPrefix + $.jgrid.jqID(this.name), (this.frozen===true && $t.p.frozenColumns === true) ? $t.grid.fhDiv : $t.grid.hDiv);
|
nm = this.index || this.name;
|
sop = this.searchoptions || {};
|
if(p.searchOperators && sop.searchOperMenu) {
|
so = $elem.parent().prev().children("a").attr("soper") || p.defaultSearch;
|
} else {
|
so = (sop.sopt) ? sop.sopt[0] : this.stype==='select' ? 'eq' : p.defaultSearch;
|
}
|
v = this.stype === "custom" && $.isFunction(sop.custom_value) && $elem.length > 0 && $elem[0].nodeName.toUpperCase() === "SPAN" ?
|
sop.custom_value.call($t, $elem.children(".customelement:first"), "get") :
|
$elem.val();
|
// detect multiselect
|
if(this.stype === 'select' && sop.multiple && $.isArray(v) && v.length) {
|
ms = true;
|
ssfield.push(nm);
|
v= v.length === 1 ? v[0] : v;
|
}
|
if(so==="bt") {
|
bbt = true;
|
}
|
if(v || so==="nu" || so==="nn") {
|
sdata[nm] = v;
|
sopt[nm] = so;
|
j++;
|
} else {
|
try {
|
delete $t.p.postData[nm];
|
} catch (z) {}
|
}
|
});
|
var sd = j>0 ? true : false;
|
if(p.stringResult === true || $t.p.datatype === "local" || p.searchOperators === true)
|
{
|
var ruleGroup = "{\"groupOp\":\"" + p.groupOp + "\",\"rules\":[";
|
var gi=0;
|
$.each(sdata,function(i,n){
|
if (gi > 0) {ruleGroup += ",";}
|
ruleGroup += "{\"field\":\"" + i + "\",";
|
ruleGroup += "\"op\":\"" + sopt[i] + "\",";
|
n+="";
|
ruleGroup += "\"data\":\"" + n.replace(/\\/g,'\\\\').replace(/\"/g,'\\"') + "\"}";
|
gi++;
|
});
|
ruleGroup += "]}";
|
// multiselect
|
var filters, rules, k,str, rule, ssdata, group;
|
if(ms) {
|
filters = $.jgrid.parse(ruleGroup);//, rules, k,str, rule, ssdata, group;
|
if(filters.rules && filters.rules.length) {
|
rules = filters.rules;
|
for(k=0;k < rules.length; k++) {
|
rule = rules[k];
|
if($.inArray(rule.filed, ssfield)) {
|
ssdata = rule.data.split(p.splitSelect);
|
if(ssdata.length > 1) {
|
if(filters.groups === undefined) {
|
filters.groups = [];
|
}
|
group = { groupOp: p.groupOpSelect, groups: [], rules: [] };
|
filters.groups.push(group);
|
$.each(ssdata,function(l) {
|
str = ssdata[l];
|
if (str) {
|
group.rules.push({ data: ssdata[l], op: rule.op, field: rule.field});
|
}
|
});
|
rules.splice(k, 1);
|
k--;
|
}
|
}
|
}
|
}
|
//ruleGroup = JSON.stringify( filters );
|
}
|
if(bbt) {
|
if(!$.isPlainObject(filters)) {
|
filters = $.jgrid.parse(ruleGroup);
|
}
|
if(filters.rules && filters.rules.length) {
|
rules = filters.rules;
|
for(k=0;k < rules.length; k++) {
|
rule = rules[k];
|
if(rule.op === "bt") {
|
ssdata = rule.data.split("...");
|
if(ssdata.length > 1) {
|
if(filters.groups === undefined) {
|
filters.groups = [];
|
}
|
group = { groupOp: 'AND', groups: [], rules: [] };
|
filters.groups.push(group);
|
$.each(ssdata,function(l) {
|
var btop = l === 0 ? 'ge' : 'le';
|
str = ssdata[l];
|
if(str) {
|
group.rules.push({ data: ssdata[l], op: btop, field: rule.field});
|
}
|
});
|
rules.splice(k, 1);
|
k--;
|
}
|
}
|
}
|
}
|
}
|
if(bbt || ms ) {
|
ruleGroup = JSON.stringify( filters );
|
}
|
$.extend($t.p.postData,{filters:ruleGroup});
|
$.each(['searchField', 'searchString', 'searchOper'], function(i, n){
|
if($t.p.postData.hasOwnProperty(n)) { delete $t.p.postData[n];}
|
});
|
} else {
|
$.extend($t.p.postData,sdata);
|
}
|
var saveurl;
|
if($t.p.searchurl) {
|
saveurl = $t.p.url;
|
$($t).jqGrid("setGridParam",{url:$t.p.searchurl});
|
}
|
var bsr = $($t).triggerHandler("jqGridToolbarBeforeSearch") === 'stop' ? true : false;
|
if(!bsr && $.isFunction(p.beforeSearch)){bsr = p.beforeSearch.call($t);}
|
if(!bsr) { $($t).jqGrid("setGridParam",{search:sd}).trigger("reloadGrid",[{page:1}]); }
|
if(saveurl) {$($t).jqGrid("setGridParam",{url:saveurl});}
|
$($t).triggerHandler("jqGridToolbarAfterSearch");
|
if($.isFunction(p.afterSearch)){p.afterSearch.call($t);}
|
},
|
clearToolbar = function(trigger){
|
var sdata={}, j=0, nm;
|
trigger = (typeof trigger !== 'boolean') ? true : trigger;
|
$.each($t.p.colModel,function(){
|
var v, $elem = $("#gs_"+$t.p.idPrefix+$.jgrid.jqID(this.name),(this.frozen===true && $t.p.frozenColumns === true) ? $t.grid.fhDiv : $t.grid.hDiv);
|
if(this.searchoptions && this.searchoptions.defaultValue !== undefined) {
|
v = this.searchoptions.defaultValue;
|
}
|
nm = this.index || this.name;
|
switch (this.stype) {
|
case 'select' :
|
$elem.find("option").each(function (i){
|
if(i===0) { this.selected = true; }
|
if ($(this).val() === v) {
|
this.selected = true;
|
return false;
|
}
|
});
|
if ( v !== undefined ) {
|
// post the key and not the text
|
sdata[nm] = v;
|
j++;
|
} else {
|
try {
|
delete $t.p.postData[nm];
|
} catch(e) {}
|
}
|
break;
|
case 'text':
|
$elem.val(v || "");
|
if(v !== undefined) {
|
sdata[nm] = v;
|
j++;
|
} else {
|
try {
|
delete $t.p.postData[nm];
|
} catch (y){}
|
}
|
break;
|
case 'custom':
|
if ($.isFunction(this.searchoptions.custom_value) && $elem.length > 0 && $elem[0].nodeName.toUpperCase() === "SPAN") {
|
this.searchoptions.custom_value.call($t, $elem.children(".customelement:first"), "set", v || "");
|
}
|
break;
|
}
|
});
|
var sd = j>0 ? true : false;
|
$t.p.resetsearch = true;
|
if(p.stringResult === true || $t.p.datatype === "local") {
|
var ruleGroup = "{\"groupOp\":\"" + p.groupOp + "\",\"rules\":[";
|
var gi=0;
|
$.each(sdata,function(i,n){
|
if (gi > 0) {ruleGroup += ",";}
|
ruleGroup += "{\"field\":\"" + i + "\",";
|
ruleGroup += "\"op\":\"" + "eq" + "\",";
|
n+="";
|
ruleGroup += "\"data\":\"" + n.replace(/\\/g,'\\\\').replace(/\"/g,'\\"') + "\"}";
|
gi++;
|
});
|
ruleGroup += "]}";
|
$.extend($t.p.postData,{filters:ruleGroup});
|
$.each(['searchField', 'searchString', 'searchOper'], function(i, n){
|
if($t.p.postData.hasOwnProperty(n)) { delete $t.p.postData[n];}
|
});
|
} else {
|
$.extend($t.p.postData,sdata);
|
}
|
var saveurl;
|
if($t.p.searchurl) {
|
saveurl = $t.p.url;
|
$($t).jqGrid("setGridParam",{url:$t.p.searchurl});
|
}
|
var bcv = $($t).triggerHandler("jqGridToolbarBeforeClear") === 'stop' ? true : false;
|
if(!bcv && $.isFunction(p.beforeClear)){bcv = p.beforeClear.call($t);}
|
if(!bcv) {
|
if(trigger) {
|
$($t).jqGrid("setGridParam",{search:sd}).trigger("reloadGrid",[{page:1}]);
|
}
|
}
|
if(saveurl) {$($t).jqGrid("setGridParam",{url:saveurl});}
|
$($t).triggerHandler("jqGridToolbarAfterClear");
|
if($.isFunction(p.afterClear)){p.afterClear();}
|
},
|
toggleToolbar = function(){
|
var trow = $("tr.ui-search-toolbar",$t.grid.hDiv),
|
trow2 = $t.p.frozenColumns === true ? $("tr.ui-search-toolbar",$t.grid.fhDiv) : false;
|
if(trow.css("display") === 'none') {
|
trow.show();
|
if(trow2) {
|
trow2.show();
|
}
|
} else {
|
trow.hide();
|
if(trow2) {
|
trow2.hide();
|
}
|
}
|
},
|
buildRuleMenu = function( elem, left, top ){
|
$("#sopt_menu").remove();
|
|
left=parseInt(left,10);
|
top=parseInt(top,10) + 18;
|
|
var fs = $('.ui-jqgrid-view').css('font-size') || '11px';
|
var str = '<ul id="sopt_menu" class="ui-search-menu modal-content" role="menu" tabindex="0" style="font-size:'+fs+';left:'+left+'px;top:'+top+'px;">',
|
selected = $(elem).attr("soper"), selclass,
|
aoprs = [], ina;
|
var i=0, nm =$(elem).attr("colname"),len = $t.p.colModel.length;
|
while(i<len) {
|
if($t.p.colModel[i].name === nm) {
|
break;
|
}
|
i++;
|
}
|
var cm = $t.p.colModel[i], options = $.extend({}, cm.searchoptions);
|
if(!options.sopt) {
|
options.sopt = [];
|
options.sopt[0]= cm.stype==='select' ? 'eq' : p.defaultSearch;
|
}
|
$.each(p.odata, function() { aoprs.push(this.oper); });
|
for ( i = 0 ; i < options.sopt.length; i++) {
|
ina = $.inArray(options.sopt[i],aoprs);
|
if(ina !== -1) {
|
selclass = selected === p.odata[ina].oper ? common.highlight : "";
|
str += '<li class="ui-menu-item '+selclass+'" role="presentation"><a class="'+ common.cornerall+' g-menu-item" tabindex="0" role="menuitem" value="'+p.odata[ina].oper+'" oper="'+p.operands[p.odata[ina].oper]+'"><table class="ui-common-table"><tr><td width="25px">'+p.operands[p.odata[ina].oper]+'</td><td>'+ p.odata[ina].text+'</td></tr></table></a></li>';
|
}
|
}
|
str += "</ul>";
|
$('body').append(str);
|
$("#sopt_menu").addClass("ui-menu " + classes.menu_widget);
|
$("#sopt_menu > li > a").hover(
|
function(){ $(this).addClass(common.hover); },
|
function(){ $(this).removeClass(common.hover); }
|
).click(function() {
|
var v = $(this).attr("value"),
|
oper = $(this).attr("oper");
|
$($t).triggerHandler("jqGridToolbarSelectOper", [v, oper, elem]);
|
$("#sopt_menu").hide();
|
$(elem).text(oper).attr("soper",v);
|
if(p.autosearch===true){
|
var inpelm = $(elem).parent().next().children()[0];
|
if( $(inpelm).val() || v==="nu" || v ==="nn") {
|
triggerToolbar();
|
}
|
}
|
});
|
};
|
// create the row
|
var tr = $("<tr class='ui-search-toolbar' role='row'></tr>"),
|
timeoutHnd, rules, filterobj;
|
if( p.restoreFromFilters ) {
|
filterobj = $t.p.postData.filters;
|
if(filterobj) {
|
if( typeof filterobj === "string") {
|
filterobj = $.jgrid.parse( filterobj );
|
}
|
rules = filterobj.rules.length ? filterobj.rules : false;
|
}
|
}
|
$.each($t.p.colModel,function(ci){
|
var cm=this, soptions, select="", sot="=", so, i, st, csv, df, elem, restores,
|
th = $("<th role='columnheader' class='" + base.headerBox+" ui-th-"+$t.p.direction+"' id='gsh_" + $t.p.id + "_" + cm.name + "' ></th>"),
|
thd = $("<div></div>"),
|
stbl = $("<table class='ui-search-table' cellspacing='0'><tr><td class='ui-search-oper' headers=''></td><td class='ui-search-input' headers=''></td><td class='ui-search-clear' headers=''></td></tr></table>");
|
if(this.hidden===true) { $(th).css("display","none");}
|
this.search = this.search === false ? false : true;
|
if(this.stype === undefined) {this.stype='text';}
|
this.searchoptions = this.searchoptions || {};
|
if(this.searchoptions.searchOperMenu === undefined) {
|
this.searchoptions.searchOperMenu = true;
|
}
|
soptions = $.extend({},this.searchoptions , {name:cm.index || cm.name, id: "gs_"+$t.p.idPrefix+cm.name, oper:'search'});
|
if(this.search){
|
if( p.restoreFromFilters && rules) {
|
restores = false;
|
for( var is = 0; is < rules.length; is++) {
|
if(rules[is].field ) {
|
var snm = cm.index || cm.name;
|
if( snm === rules[is].field) {
|
restores = rules[is];
|
break;
|
}
|
}
|
}
|
}
|
if(p.searchOperators) {
|
so = (soptions.sopt) ? soptions.sopt[0] : cm.stype==='select' ? 'eq' : p.defaultSearch;
|
// overwrite search operators
|
if( p.restoreFromFilters && restores) {
|
so = restores.op;
|
}
|
for(i = 0;i<p.odata.length;i++) {
|
if(p.odata[i].oper === so) {
|
sot = p.operands[so] || "";
|
break;
|
}
|
}
|
st = soptions.searchtitle != null ? soptions.searchtitle : p.operandTitle;
|
select = this.searchoptions.searchOperMenu ? "<a title='"+st+"' style='padding-right: 0.5em;' soper='"+so+"' class='soptclass' colname='"+this.name+"'>"+sot+"</a>" : "";
|
}
|
$("td:eq(0)",stbl).attr("colindex",ci).append(select);
|
if(soptions.clearSearch === undefined) {
|
soptions.clearSearch = true;
|
}
|
if(soptions.clearSearch) {
|
csv = p.resetTitle || 'Clear Search Value';
|
$("td:eq(2)",stbl).append("<a title='"+csv+"' style='padding-right: 0.3em;padding-left: 0.3em;' class='clearsearchclass'>"+p.resetIcon+"</a>");
|
} else {
|
$("td:eq(2)", stbl).hide();
|
}
|
if(this.surl) {
|
soptions.dataUrl = this.surl;
|
}
|
df="";
|
if(soptions.defaultValue ) {
|
df = $.isFunction(soptions.defaultValue) ? soptions.defaultValue.call($t) : soptions.defaultValue;
|
}
|
//overwrite default value if restore from filters
|
if( p.restoreFromFilters && restores) {
|
df = restores.data;
|
}
|
elem = $.jgrid.createEl.call($t, this.stype, soptions , df, false, $.extend({},$.jgrid.ajaxOptions, $t.p.ajaxSelectOptions || {}));
|
$(elem).addClass( classes.srInput );
|
$("td:eq(1)",stbl).append(elem);
|
$(thd).append(stbl);
|
if(soptions.dataEvents == null ) {
|
soptions.dataEvents = [];
|
}
|
switch (this.stype)
|
{
|
case "select":
|
if(p.autosearch === true) {
|
soptions.dataEvents.push({
|
type : "change",
|
fn : function() {
|
triggerToolbar();
|
return false;
|
}
|
});
|
}
|
break;
|
case "text":
|
if(p.autosearch===true){
|
if(p.searchOnEnter) {
|
soptions.dataEvents.push({
|
type: "keypress",
|
fn : function(e) {
|
var key = e.charCode || e.keyCode || 0;
|
if(key === 13){
|
triggerToolbar();
|
return false;
|
}
|
return this;
|
}
|
});
|
} else {
|
soptions.dataEvents.push({
|
type: "keydown",
|
fn : function(e) {
|
var key = e.which;
|
switch (key) {
|
case 13:
|
return false;
|
case 9 :
|
case 16:
|
case 37:
|
case 38:
|
case 39:
|
case 40:
|
case 27:
|
break;
|
default :
|
if(timeoutHnd) { clearTimeout(timeoutHnd); }
|
timeoutHnd = setTimeout(function(){triggerToolbar();}, p.autosearchDelay);
|
}
|
}
|
});
|
}
|
}
|
break;
|
}
|
|
$.jgrid.bindEv.call($t, elem , soptions);
|
}
|
$(th).append(thd);
|
$(tr).append(th);
|
if(!p.searchOperators || select === "") {
|
$("td:eq(0)",stbl).hide();
|
}
|
});
|
$("table thead",$t.grid.hDiv).append(tr);
|
if(p.searchOperators) {
|
$(".soptclass",tr).click(function(e){
|
var offset = $(this).offset(),
|
left = ( offset.left ),
|
top = ( offset.top);
|
buildRuleMenu(this, left, top );
|
e.stopPropagation();
|
});
|
$("body").on('click', function(e){
|
if(e.target.className !== "soptclass") {
|
$("#sopt_menu").remove();
|
}
|
});
|
}
|
$(".clearsearchclass",tr).click(function() {
|
var ptr = $(this).parents("tr:first"),
|
coli = parseInt($("td.ui-search-oper", ptr).attr('colindex'),10),
|
sval = $.extend({},$t.p.colModel[coli].searchoptions || {}),
|
dval = sval.defaultValue ? sval.defaultValue : "",
|
elem;
|
if($t.p.colModel[coli].stype === "select") {
|
elem = $("td.ui-search-input select", ptr);
|
if(dval) {
|
elem.val( dval );
|
} else {
|
elem[0].selectedIndex = 0;
|
}
|
} else {
|
elem = $("td.ui-search-input input", ptr);
|
elem.val( dval );
|
}
|
$($t).triggerHandler("jqGridToolbarClearVal",[elem[0], coli, sval, dval]);
|
if($.isFunction(p.onClearSearchValue)) {
|
p.onClearSearchValue.call($t, elem[0], coli, sval, dval);
|
}
|
// ToDo custom search type
|
if(p.autosearch===true){
|
triggerToolbar();
|
}
|
|
});
|
this.p.filterToolbar = true;
|
this.triggerToolbar = triggerToolbar;
|
this.clearToolbar = clearToolbar;
|
this.toggleToolbar = toggleToolbar;
|
});
|
},
|
destroyFilterToolbar: function () {
|
return this.each(function () {
|
if (!this.p.filterToolbar) {
|
return;
|
}
|
this.triggerToolbar = null;
|
this.clearToolbar = null;
|
this.toggleToolbar = null;
|
this.p.filterToolbar = false;
|
$(this.grid.hDiv).find("table thead tr.ui-search-toolbar").remove();
|
});
|
},
|
refreshFilterToolbar : function ( p ) {
|
p = $.extend(true, {
|
filters : "",
|
onClearVal : null,
|
onSetVal : null
|
}, p || {});
|
return this.each(function () {
|
var $t = this, cm = $t.p.colModel, i, l = $t.p.colModel.length,
|
searchitem, filters, rules, rule, ssfield =[], ia;
|
// clear the values on toolbar.
|
// do not call clearToolbar
|
if(!$t.p.filterToolbar) {
|
return;
|
}
|
for (i = 0; i < l; i++) {
|
ssfield.push(cm[i].name);
|
searchitem = $("#gs_" +$t.p.idPrefix+ $.jgrid.jqID(cm[i].name));
|
switch (cm[i].stype) {
|
case 'select' :
|
case 'text' :
|
searchitem.val("");
|
break;
|
}
|
if($.isFunction(p.onClearVal)) {
|
p.onClearVal.call($t, searchitem, cm[i].name);
|
}
|
}
|
function setrules (filter) {
|
if(filter && filter.rules) { // condition to exit
|
rules = filter.rules;
|
l = rules.length;
|
for (i = 0; i < l; i++) {
|
rule = rules[i];
|
ia = $.inArray(rule.field, ssfield);
|
if( ia !== -1) {
|
searchitem = $("#gs_" + $t.p.idPrefix + $.jgrid.jqID(cm[ia].name));
|
// problem for between operator
|
if ( searchitem.length > 0) {
|
if (cm[ia].stype === "select") {
|
searchitem.find("option[value='" + $.jgrid.jqID(rule.data) + "']").prop('selected', true);
|
} else if (cm[ia].stype === "text") {
|
searchitem.val(rule.data);
|
}
|
if($.isFunction(p.onSetVal)) {
|
p.onSetVal.call($t, searchitem, cm[ia].name);
|
}
|
}
|
}
|
}
|
if(filter.groups) {
|
for(var k=0;k<filter.groups.length;k++) {
|
setrules(filter.groups[k]);
|
}
|
}
|
}
|
}
|
if (typeof (p.filters) === "string" && p.filters.length) {
|
filters = $.jgrid.parse(p.filters);
|
// flat filters only
|
}
|
if ($.isPlainObject(filters)) {
|
setrules( filters );
|
}
|
});
|
},
|
searchGrid : function (p) {
|
var regional = $.jgrid.getRegional(this[0], 'search');
|
p = $.extend(true, {
|
recreateFilter: false,
|
drag: true,
|
sField:'searchField',
|
sValue:'searchString',
|
sOper: 'searchOper',
|
sFilter: 'filters',
|
loadDefaults: true, // this options activates loading of default filters from grid's postData for Multipe Search only.
|
beforeShowSearch: null,
|
afterShowSearch : null,
|
onInitializeSearch: null,
|
afterRedraw : null,
|
afterChange: null,
|
sortStrategy: null,
|
closeAfterSearch : false,
|
closeAfterReset: false,
|
closeOnEscape : false,
|
searchOnEnter : false,
|
multipleSearch : false,
|
multipleGroup : false,
|
//cloneSearchRowOnAdd: true,
|
top : 0,
|
left: 0,
|
jqModal : true,
|
modal: false,
|
resize : true,
|
width: 450,
|
height: 'auto',
|
dataheight: 'auto',
|
showQuery: false,
|
errorcheck : true,
|
sopt: null,
|
stringResult: undefined,
|
onClose : null,
|
onSearch : null,
|
onReset : null,
|
toTop : true,
|
overlay : 30,
|
columns : [],
|
tmplNames : null,
|
tmplFilters : null,
|
tmplLabel : ' Template: ',
|
showOnLoad: false,
|
layer: null,
|
operands : { "eq" :"=", "ne":"<>","lt":"<","le":"<=","gt":">","ge":">=","bw":"LIKE","bn":"NOT LIKE","in":"IN","ni":"NOT IN","ew":"LIKE","en":"NOT LIKE","cn":"LIKE","nc":"NOT LIKE","nu":"IS NULL","nn":"ISNOT NULL"}
|
}, regional, p || {});
|
return this.each(function() {
|
var $t = this;
|
if(!$t.grid) {return;}
|
var fid = "fbox_"+$t.p.id,
|
showFrm = true,
|
mustReload = true,
|
IDs = {themodal:'searchmod'+fid,modalhead:'searchhd'+fid,modalcontent:'searchcnt'+fid, scrollelm : fid},
|
defaultFilters = $t.p.postData[p.sFilter],
|
fl,
|
classes = $.jgrid.styleUI[($t.p.styleUI || 'jQueryUI')].filter,
|
common = $.jgrid.styleUI[($t.p.styleUI || 'jQueryUI')].common;
|
p.styleUI = $t.p.styleUI;
|
if(typeof defaultFilters === "string") {
|
defaultFilters = $.jgrid.parse( defaultFilters );
|
}
|
if(p.recreateFilter === true) {
|
$("#"+$.jgrid.jqID(IDs.themodal)).remove();
|
}
|
function showFilter(_filter) {
|
showFrm = $($t).triggerHandler("jqGridFilterBeforeShow", [_filter]);
|
if(showFrm === undefined) {
|
showFrm = true;
|
}
|
if(showFrm && $.isFunction(p.beforeShowSearch)) {
|
showFrm = p.beforeShowSearch.call($t,_filter);
|
}
|
if(showFrm) {
|
$.jgrid.viewModal("#"+$.jgrid.jqID(IDs.themodal),{gbox:"#gbox_"+$.jgrid.jqID(fid),jqm:p.jqModal, modal:p.modal, overlay: p.overlay, toTop: p.toTop});
|
$($t).triggerHandler("jqGridFilterAfterShow", [_filter]);
|
if($.isFunction(p.afterShowSearch)) {
|
p.afterShowSearch.call($t, _filter);
|
}
|
}
|
}
|
if ( $("#"+$.jgrid.jqID(IDs.themodal))[0] !== undefined ) {
|
showFilter($("#fbox_"+$.jgrid.jqID( $t.p.id )));
|
} else {
|
var fil = $("<div><div id='"+fid+"' class='searchFilter' style='overflow:auto'></div></div>").insertBefore("#gview_"+$.jgrid.jqID($t.p.id)),
|
align = "left", butleft ="";
|
if($t.p.direction === "rtl") {
|
align = "right";
|
butleft = " style='text-align:left'";
|
fil.attr("dir","rtl");
|
}
|
var columns = $.extend([],$t.p.colModel),
|
bS ="<a id='"+fid+"_search' class='fm-button " + common.button + " fm-button-icon-right ui-search'><span class='" + common.icon_base + " " +classes.icon_search + "'></span>"+p.Find+"</a>",
|
bC ="<a id='"+fid+"_reset' class='fm-button " + common.button +" fm-button-icon-left ui-reset'><span class='" + common.icon_base + " " +classes.icon_reset + "'></span>"+p.Reset+"</a>",
|
bQ = "", tmpl="", colnm, found = false, bt, cmi=-1;
|
if(p.showQuery) {
|
bQ ="<a id='"+fid+"_query' class='fm-button " + common.button + " fm-button-icon-left'><span class='" + common.icon_base + " " +classes.icon_query + "'></span>Query</a>";
|
}
|
if(!p.columns.length) {
|
$.each(columns, function(i,n){
|
if(!n.label) {
|
n.label = $t.p.colNames[i];
|
}
|
// find first searchable column and set it if no default filter
|
if(!found) {
|
var searchable = (n.search === undefined) ? true: n.search ,
|
hidden = (n.hidden === true),
|
ignoreHiding = (n.searchoptions && n.searchoptions.searchhidden === true);
|
if ((ignoreHiding && searchable) || (searchable && !hidden)) {
|
found = true;
|
colnm = n.index || n.name;
|
cmi =i;
|
}
|
}
|
});
|
} else {
|
columns = p.columns;
|
cmi = 0;
|
colnm = columns[0].index || columns[0].name;
|
}
|
// old behaviour
|
if( (!defaultFilters && colnm) || p.multipleSearch === false ) {
|
var cmop = "eq";
|
if(cmi >=0 && columns[cmi].searchoptions && columns[cmi].searchoptions.sopt) {
|
cmop = columns[cmi].searchoptions.sopt[0];
|
} else if(p.sopt && p.sopt.length) {
|
cmop = p.sopt[0];
|
}
|
defaultFilters = {groupOp: "AND", rules: [{field: colnm, op: cmop, data: ""}]};
|
}
|
found = false;
|
if(p.tmplNames && p.tmplNames.length) {
|
found = true;
|
tmpl = "<tr><td class='ui-search-label'>"+ p.tmplLabel +"</td>";
|
tmpl += "<td><select class='ui-template " + classes.srSelect + "'>";
|
tmpl += "<option value='default'>Default</option>";
|
$.each(p.tmplNames, function(i,n){
|
tmpl += "<option value='"+i+"'>"+n+"</option>";
|
});
|
tmpl += "</select></td></tr>";
|
}
|
|
bt = "<table class='EditTable' style='border:0px none;margin-top:5px' id='"+fid+"_2'><tbody><tr><td colspan='2'><hr class='" + common.content + "' style='margin:1px'/></td></tr>"+tmpl+"<tr><td class='EditButton' style='text-align:"+align+"'>"+bC+"</td><td class='EditButton' "+butleft+">"+bQ+bS+"</td></tr></tbody></table>";
|
fid = $.jgrid.jqID( fid);
|
$("#"+fid).jqFilter({
|
columns: columns,
|
sortStrategy: p.sortStrategy,
|
filter: p.loadDefaults ? defaultFilters : null,
|
showQuery: p.showQuery,
|
errorcheck : p.errorcheck,
|
sopt: p.sopt,
|
groupButton : p.multipleGroup,
|
ruleButtons : p.multipleSearch,
|
uniqueSearchFields : p.uniqueSearchFields,
|
afterRedraw : p.afterRedraw,
|
ops : p.odata,
|
operands : p.operands,
|
ajaxSelectOptions: $t.p.ajaxSelectOptions,
|
groupOps: p.groupOps,
|
onChange : function() {
|
if(this.p.showQuery) {
|
$('.query',this).html(this.toUserFriendlyString());
|
}
|
if ($.isFunction(p.afterChange)) {
|
p.afterChange.call($t, $("#"+fid), p);
|
}
|
},
|
direction : $t.p.direction,
|
id: $t.p.id
|
});
|
fil.append( bt );
|
if(found && p.tmplFilters && p.tmplFilters.length) {
|
$(".ui-template", fil).bind('change', function(){
|
var curtempl = $(this).val();
|
if(curtempl==="default") {
|
$("#"+fid).jqFilter('addFilter', defaultFilters);
|
} else {
|
$("#"+fid).jqFilter('addFilter', p.tmplFilters[parseInt(curtempl,10)]);
|
}
|
return false;
|
});
|
}
|
if(p.multipleGroup === true) {p.multipleSearch = true;}
|
$($t).triggerHandler("jqGridFilterInitialize", [$("#"+fid)]);
|
if($.isFunction(p.onInitializeSearch) ) {
|
p.onInitializeSearch.call($t, $("#"+fid));
|
}
|
p.gbox = "#gbox_"+fid;
|
if (p.layer) {
|
$.jgrid.createModal(IDs ,fil,p,"#gview_"+$.jgrid.jqID($t.p.id),$("#gbox_"+$.jgrid.jqID($t.p.id))[0], "#"+$.jgrid.jqID(p.layer), {position: "relative"});
|
} else {
|
$.jgrid.createModal(IDs ,fil,p,"#gview_"+$.jgrid.jqID($t.p.id),$("#gbox_"+$.jgrid.jqID($t.p.id))[0]);
|
}
|
if (p.searchOnEnter || p.closeOnEscape) {
|
$("#"+$.jgrid.jqID(IDs.themodal)).keydown(function (e) {
|
var $target = $(e.target);
|
if (p.searchOnEnter && e.which === 13 && // 13 === $.ui.keyCode.ENTER
|
!$target.hasClass('add-group') && !$target.hasClass('add-rule') &&
|
!$target.hasClass('delete-group') && !$target.hasClass('delete-rule') &&
|
(!$target.hasClass("fm-button") || !$target.is("[id$=_query]"))) {
|
$("#"+fid+"_search").click();
|
return false;
|
}
|
if (p.closeOnEscape && e.which === 27) { // 27 === $.ui.keyCode.ESCAPE
|
$("#"+$.jgrid.jqID(IDs.modalhead)).find(".ui-jqdialog-titlebar-close").click();
|
return false;
|
}
|
});
|
}
|
if(bQ) {
|
$("#"+fid+"_query").bind('click', function(){
|
$(".queryresult", fil).toggle();
|
return false;
|
});
|
}
|
if (p.stringResult===undefined) {
|
// to provide backward compatibility, inferring stringResult value from multipleSearch
|
p.stringResult = p.multipleSearch;
|
}
|
$("#"+fid+"_search").bind('click', function(){
|
var sdata={}, res, filters;
|
fl = $("#"+fid);
|
fl.find(".input-elm:focus").change();
|
filters = fl.jqFilter('filterData');
|
if(p.errorcheck) {
|
fl[0].hideError();
|
if(!p.showQuery) {fl.jqFilter('toSQLString');}
|
if(fl[0].p.error) {
|
fl[0].showError();
|
return false;
|
}
|
}
|
|
if(p.stringResult) {
|
try {
|
res = JSON.stringify(filters);
|
} catch (e2) { }
|
if(typeof res==="string") {
|
sdata[p.sFilter] = res;
|
$.each([p.sField,p.sValue, p.sOper], function() {sdata[this] = "";});
|
}
|
} else {
|
if(p.multipleSearch) {
|
sdata[p.sFilter] = filters;
|
$.each([p.sField,p.sValue, p.sOper], function() {sdata[this] = "";});
|
} else {
|
sdata[p.sField] = filters.rules[0].field;
|
sdata[p.sValue] = filters.rules[0].data;
|
sdata[p.sOper] = filters.rules[0].op;
|
sdata[p.sFilter] = "";
|
}
|
}
|
$t.p.search = true;
|
$.extend($t.p.postData,sdata);
|
mustReload = $($t).triggerHandler("jqGridFilterSearch");
|
if( mustReload === undefined) {
|
mustReload = true;
|
}
|
if(mustReload && $.isFunction(p.onSearch) ) {
|
mustReload = p.onSearch.call($t, $t.p.filters);
|
}
|
if (mustReload !== false) {
|
$($t).trigger("reloadGrid",[{page:1}]);
|
}
|
if(p.closeAfterSearch) {
|
$.jgrid.hideModal("#"+$.jgrid.jqID(IDs.themodal),{gb:"#gbox_"+$.jgrid.jqID($t.p.id),jqm:p.jqModal,onClose: p.onClose});
|
}
|
return false;
|
});
|
$("#"+fid+"_reset").bind('click', function(){
|
var sdata={},
|
fl = $("#"+fid);
|
$t.p.search = false;
|
$t.p.resetsearch = true;
|
if(p.multipleSearch===false) {
|
sdata[p.sField] = sdata[p.sValue] = sdata[p.sOper] = "";
|
} else {
|
sdata[p.sFilter] = "";
|
}
|
fl[0].resetFilter();
|
if(found) {
|
$(".ui-template", fil).val("default");
|
}
|
$.extend($t.p.postData,sdata);
|
mustReload = $($t).triggerHandler("jqGridFilterReset");
|
if(mustReload === undefined) {
|
mustReload = true;
|
}
|
if(mustReload && $.isFunction(p.onReset) ) {
|
mustReload = p.onReset.call($t);
|
}
|
if(mustReload !== false) {
|
$($t).trigger("reloadGrid",[{page:1}]);
|
}
|
if (p.closeAfterReset) {
|
$.jgrid.hideModal("#"+$.jgrid.jqID(IDs.themodal),{gb:"#gbox_"+$.jgrid.jqID($t.p.id),jqm:p.jqModal,onClose: p.onClose});
|
}
|
return false;
|
});
|
showFilter($("#"+fid));
|
$(".fm-button:not(."+common.disabled+")",fil).hover(
|
function(){$(this).addClass(common.hover);},
|
function(){$(this).removeClass(common.hover);}
|
);
|
}
|
});
|
},
|
filterInput : function( val, p) {
|
p = $.extend(true, {
|
defaultSearch : 'cn',
|
groupOp : 'OR',
|
searchAll : false,
|
beforeSearch : null,
|
afterSearch : null
|
}, p || {});
|
return this.each(function(){
|
var $t = this;
|
if(!$t.grid) {return;}
|
var nm, sop,ruleGroup = "{\"groupOp\":\"" + p.groupOp + "\",\"rules\":[", gi=0, so;
|
val +="";
|
if(!$t.p.datatype === 'local') { return; }
|
$.each($t.p.colModel,function(){
|
nm = this.index || this.name;
|
sop = this.searchoptions || {};
|
so = p.defaultSearch ? p.defaultSearch : (sop.sopt) ? sop.sopt[0] : p.defaultSearch;
|
this.search = this.search === false ? false : true;
|
if (this.search || p.searchAll) {
|
if (gi > 0) {ruleGroup += ",";}
|
ruleGroup += "{\"field\":\"" + nm + "\",";
|
ruleGroup += "\"op\":\"" + so + "\",";
|
ruleGroup += "\"data\":\"" + val.replace(/\\/g,'\\\\').replace(/\"/g,'\\"') + "\"}";
|
gi++;
|
}
|
});
|
ruleGroup += "]}";
|
$.extend($t.p.postData,{filters:ruleGroup});
|
$.each(['searchField', 'searchString', 'searchOper'], function(i, n){
|
if($t.p.postData.hasOwnProperty(n)) { delete $t.p.postData[n];}
|
});
|
var bsr = $($t).triggerHandler("jqGridFilterInputBeforeSearch") === 'stop' ? true : false;
|
if(!bsr && $.isFunction(p.beforeSearch)){bsr = p.beforeSearch.call($t);}
|
if(!bsr) { $($t).jqGrid("setGridParam",{search:true}).trigger("reloadGrid",[{page:1}]); }
|
$($t).triggerHandler("jqGridFilterInputAfterSearch");
|
if($.isFunction(p.afterSearch)){p.afterSearch.call($t);}
|
});
|
}
|
});
|
//module end
|
}));
|
