/** * @author: aperez * @version: v2.0.0 * * @update Dennis Hernández */ !function ($) { 'use strict'; var firstLoad = false; var sprintf = $.fn.bootstrapTable.utils.sprintf; var showAvdSearch = function (pColumns, that) { var searchTitle = that.options.formatAdvancedSearch(); if (!$("#avdSearchModal" + "_" + that.options.idTable).hasClass("modal")) { var vModal = sprintf("
", "_" + that.options.idTable); vModal += "
"; vModal += "
"; vModal += "
"; vModal += " "; vModal += sprintf("

%s

", searchTitle); vModal += "
"; vModal += "
"; vModal += sprintf("
", "_" + that.options.idTable); vModal += "
"; vModal += "
"; vModal += "
"; vModal += createFormBtn(that).join(''); vModal += "
"; vModal += "
"; vModal += "
"; vModal += "
"; $("body").append($(vModal)); var vFormAvd = createFormAvd(pColumns, that), timeoutId = 0; ; $('#avdSearchModalContent' + "_" + that.options.idTable).append(vFormAvd.join('')); if (that.options.sidePagination != 'server' || !that.options.url) { $('#' + that.options.idForm).off('keyup blur', 'input').on('keyup blur', 'input', function (event) { clearTimeout(timeoutId); timeoutId = setTimeout(function () { that.onColumnAdvancedSearch(event); }, that.options.searchTimeOut); }); } else { } // 提交搜索 $("#btnSubmitAvd" + "_" + that.options.idTable).click(function (event) { that.onColumnAdvancedSearch(); }); // 重置搜索 $("#btnResetAvd" + "_" + that.options.idTable).click(function () { $("#avdSearchModal" + "_" + that.options.idTable + " form")[0].reset(); that.onColumnAdvancedSearch(); }); $("#avdSearchModal" + "_" + that.options.idTable).modal(); } else { $("#avdSearchModal" + "_" + that.options.idTable).modal(); } }; var createFormAvd = function (pColumns, that) { var htmlForm = []; var opList = ['=', '>', '>=', '<', '<=', '!=', 'LIKE', 'LIKE %...%', 'NOT LIKE', 'IN(...)', 'NOT IN(...)', 'BETWEEN', 'NOT BETWEEN', 'IS NULL', 'IS NOT NULL']; var selectList = []; for (var i = 0; i < opList.length; i++) { selectList.push(""); } var selectHtml = selectList.join(''); htmlForm.push(sprintf('
', that.options.idForm, that.options.actionForm)); for (var i in pColumns) { var vObjCol = pColumns[i]; if (!vObjCol.checkbox && vObjCol.field != 'operate' && vObjCol.visible && vObjCol.searchable) { htmlForm.push('
'); htmlForm.push(sprintf('', vObjCol.title)); if (that.options.sidePagination == 'server' && that.options.url) { htmlForm.push('
'); htmlForm.push(sprintf('', vObjCol.field, vObjCol.field, selectHtml)); htmlForm.push('
'); } htmlForm.push('
'); htmlForm.push(sprintf('', vObjCol.field, vObjCol.title, vObjCol.field)); htmlForm.push('
'); htmlForm.push('
'); } } htmlForm.push('
'); return htmlForm; }; var createFormBtn = function (that) { var htmlBtn = []; var searchSubmit = that.options.formatAdvancedSubmitButton(); var searchReset = that.options.formatAdvancedResetButton(); var searchClose = that.options.formatAdvancedCloseButton(); htmlBtn.push('
'); htmlBtn.push('
'); if (that.options.sidePagination == 'server' && that.options.url) { htmlBtn.push(sprintf(' ', "_" + that.options.idTable, searchSubmit)); htmlBtn.push(sprintf(' ', "_" + that.options.idTable, searchReset)); } else { htmlBtn.push(sprintf(' ', "_" + that.options.idTable, searchClose)); } htmlBtn.push('
'); htmlBtn.push('
'); return htmlBtn; }; $.extend($.fn.bootstrapTable.defaults, { advancedSearch: false, idForm: 'advancedSearch', actionForm: '', idTable: undefined, onColumnAdvancedSearch: function (field, text) { return false; } }); $.extend($.fn.bootstrapTable.defaults.icons, { advancedSearchIcon: 'glyphicon-search' }); $.extend($.fn.bootstrapTable.Constructor.EVENTS, { 'column-advanced-search.bs.table': 'onColumnAdvancedSearch' }); $.extend($.fn.bootstrapTable.locales, { formatAdvancedSearch: function () { return 'Advanced search'; }, formatAdvancedSubmitButton: function () { return "Submit"; }, formatAdvancedResetButton: function () { return "Reset"; }, formatAdvancedCloseButton: function () { return "Close"; } }); $.extend($.fn.bootstrapTable.defaults, $.fn.bootstrapTable.locales); var BootstrapTable = $.fn.bootstrapTable.Constructor, _initToolbar = BootstrapTable.prototype.initToolbar, _load = BootstrapTable.prototype.load, _initSearch = BootstrapTable.prototype.initSearch; BootstrapTable.prototype.initToolbar = function () { _initToolbar.apply(this, Array.prototype.slice.apply(arguments)); if (!this.options.search) { return; } if (!this.options.advancedSearch) { return; } if (!this.options.idTable) { return; } var that = this, html = []; html.push(sprintf('
', this.options.buttonsAlign, this.options.buttonsAlign)); html.push(sprintf('
'); that.$toolbar.prepend(html.join('')); that.$toolbar.find('button[name="advancedSearch"]') .off('click').on('click', function () { showAvdSearch(that.columns, that); }); }; BootstrapTable.prototype.load = function (data) { _load.apply(this, Array.prototype.slice.apply(arguments)); if (!this.options.advancedSearch) { return; } if (typeof this.options.idTable === 'undefined') { return; } else { if (!firstLoad) { var height = parseInt($(".bootstrap-table").height()); height += 10; $("#" + this.options.idTable).bootstrapTable("resetView", {height: height}); firstLoad = true; } } }; BootstrapTable.prototype.initSearch = function () { _initSearch.apply(this, Array.prototype.slice.apply(arguments)); if (!this.options.advancedSearch) { return; } var that = this; var fp = $.isEmptyObject(this.filterColumnsPartial) ? null : this.filterColumnsPartial; this.data = fp ? $.grep(this.data, function (item, i) { for (var key in fp) { var fval = fp[key].toLowerCase(); var value = item[key]; value = $.fn.bootstrapTable.utils.calculateObjectValue(that.header, that.header.formatters[$.inArray(key, that.header.fields)], [value, item, i], value); if (!($.inArray(key, that.header.fields) !== -1 && (typeof value === 'string' || typeof value === 'number') && (value + '').toLowerCase().indexOf(fval) !== -1)) { return false; } } return true; }) : this.data; }; BootstrapTable.prototype.onColumnAdvancedSearch = function (event) { if (typeof event == 'undefined') { var op = {}; var filter = {}; $("#avdSearchModalContent_" + this.options.idTable + " select").each(function () { var name = $(this).data("name"); var sym = $(this).val(); var value = $("input[name='" + name + "']").val(); if (value == '' && sym.indexOf("NULL") == -1) { return true; } op[name] = sym; filter[name] = value; }); // 追加查询关键字 this.options.pageNumber = 1; this.refresh({query: {filter: JSON.stringify(filter), op: JSON.stringify(op)}}); } else { var text = $.trim($(event.currentTarget).val()); var $field = $(event.currentTarget)[0].id; if ($.isEmptyObject(this.filterColumnsPartial)) { this.filterColumnsPartial = {}; } if (text) { this.filterColumnsPartial[$field] = text; } else { delete this.filterColumnsPartial[$field]; } this.options.pageNumber = 1; this.onSearch(event); // this.updatePagination(); this.trigger('column-advanced-search', $field, text); } }; }(jQuery);