/**
*
* @name: 表格筛选扩展
* @author: yelog
* @link: https://github.com/yelog/layui-soul-table
* @license: MIT
* @version: v1.6.4
*/
layui.define(['table', 'form', 'laydate', 'util', 'excel', 'laytpl'], function (exports) {
var $ = layui.jquery,
table = layui.table,
form = layui.form,
laydate = layui.laydate,
laytpl = layui.laytpl,
util = layui.util,
excel = layui.excel,
columnsTimeOut,
dorpListTimeOut,
conditionTimeOut,
bfColumnTimeOut,
bfCond1TimeOut,
isFilterReload = {},
SOUL_ROW_INDEX = 'SOUL_ROW_INDEX',
cache = {},
HIDE = 'layui-hide',
maxId = 1,
UNHANDLED_VALUES = [undefined, '', null],
where_cache = {},
isFilterCache = {},
table_cache = {},
conditionChangeItems = {
'eq': '等于',
'ne': '≠ 不等于',
'gt': '> 大于',
'ge': '≥ 大于等于',
'lt': '< 小于',
'le': '≤ 小于等于',
'contain': '包含',
'notContain': '不包含',
'start': '以...开头',
'end': '以...结尾',
'null': '为空',
'notNull': '不为空'
},
dateTimeItems = {
'all': '全部',
'yesterday': '昨天',
'thisWeek': '本周',
'lastWeek': '上周',
'thisMonth': '本月',
'thisYear': '今年'
},
defaultFilterItems = ['column', 'data', 'condition', 'editCondition', 'excel'],
itemsMap = {
'column': 'soul-column',
'data': 'soul-dropList',
'condition': 'soul-condition',
'editCondition': 'soul-edit-condition',
'excel': 'soul-export',
'clearCache': 'soul-clear-cache',
},
modeMapItems = {
'in': 'data',
'condition': 'condition',
'date': 'condition',
},
revertMode = {
'data': {
'mode': 'condition',
'type': 'eq',
'value': '',
},
'condition': {
'mode': 'in',
'values': [],
},
};
// 封装方法
var mod = {
/**
* 摧毁render数据
* @param myTables
*/
destroy: function (myTables) {
if (myTables) {
if (Array.isArray(myTables)) {
for (var i = 0; i < myTables.length; i++) {
deleteRender(myTables[i])
}
} else {
deleteRender(myTables);
}
}
function deleteRender(myTable) {
if (!myTable) {
return;
}
var tableId = myTable.config.id;
$('#soul-filter-list' + tableId).remove();
$('#soulCondition' + tableId).remove();
$('#soulDropList' + tableId).remove();
delete isFilterReload[tableId];
delete where_cache[tableId];
delete table_cache[tableId];
}
},
clearFilter: function (myTable) {
if (typeof myTable === 'string') {
myTable = table_cache[myTable]
}
if (!where_cache[myTable.id] || !where_cache[myTable.id].filterSos || where_cache[myTable.id].filterSos === "[]") {
return;
}
where_cache[myTable.id].filterSos = "[]"
this.soulReload(myTable, true)
if (table_cache[myTable.id].where && table_cache[myTable.id].where.filterSos && table_cache[myTable.id].where.filterSos !== "[]") {
table_cache[myTable.id].where.filterSos = "[]"
}
},
render: function (myTable) {
var _this = this,
$table = $(myTable.elem),
$tableMain = $table.next().children('.layui-table-box').children('.layui-table-main'),
$tableHead = $table.next().children('.layui-table-box').children('.layui-table-header').children('table'),
$fixedLeftTableHead = $table.next().children('.layui-table-box').children('.layui-table-fixed-l').children('.layui-table-header').children('table'),
$fixedRigthTableHead = $table.next().children('.layui-table-box').children('.layui-table-fixed-r').children('.layui-table-header').children('table'),
tableId = myTable.id,
columns = _this.getCompleteCols(myTable.cols),
filterItems = myTable.filter ? myTable.filter.items || defaultFilterItems : defaultFilterItems,
needFilter = false, // 是否存在筛选列需要进行初始化
initFilter = false, // 是否为第一次筛选
mainExcel = typeof myTable.excel === 'undefined' || ((myTable.excel && (typeof myTable.excel.on === 'undefined' || myTable.excel.on)) ? myTable.excel : false),
i, j;
for (i = 0; i < columns.length; i++) {
if (columns[i].field && columns[i].filter) {
needFilter = true;
if ($tableHead.find('th[data-field="' + columns[i].field + '"]').children().children('.soul-table-filter').length === 0) {
initFilter = true;
if ($tableHead.find('th[data-field="' + columns[i].field + '"]').children().children('.layui-table-sort').length > 0) {
$tableHead.find('th[data-field="' + columns[i].field + '"]').children().children('.layui-table-sort').hide()
$tableHead.find('th[data-field="' + columns[i].field + '"]').children().append('";
for (var key in conditionChangeItems) {
selectStr += '' + conditionChangeItems[key] + ' ';
}
selectStr += " ";
conditionHtml.push(' 添加 查询
')
$('#soul-condition' + tableId).data({head: true, id: filterSo ? filterSo.id || '' : ''})
.html(conditionHtml.join(''))
.css({'top': $(this).offset().top, 'left': left})
.show().removeClass().addClass(animate + ' animated');
$('.condition-table').on('click', function () {
return false;
})
// 新增与查询
$('#soul-condition' + tableId + ' button[data-type]').on('click', function () {
/**
* 新增
*/
if ($(this).data('type') === 'add') {
var groupId = $('#soul-condition' + tableId).data('id'),
head = $('#soul-condition' + tableId).data('head'),
type = 'eq',
filterSo,
$tr1 = $('#soul-condition' + tableId).find('tr:eq(0)');
if (groupId) {
filterSo = {
head: head,
prefix: 'and',
field: field,
mode: 'condition',
type: type,
value: '',
groupId: groupId
}
} else {
filterSo = {
head: head,
prefix: head ? 'and' : 'and',
mode: 'group',
field: field,
children: [{
id: _this.getDifId(),
prefix: 'and',
field: field,
mode: 'condition',
type: $tr1.find('select').val(),
value: $tr1.find('.value').val()
}, {
id: _this.getDifId(),
prefix: 'and',
field: field,
mode: 'condition',
type: type,
value: ''
}]
}
}
_this.updateWhere(myTable, filterSo);
if (!groupId) {
$('#soul-condition' + tableId).data('id', filterSo.id);
$tr1.data('id', filterSo.children[0].id);
}
// $tableHead.find('thead>tr>th[data-field="'+field+'"] .soul-table-filter').attr('soul-filter','true');
var newId = groupId ? filterSo.id : filterSo.children[1].id;
var newTr = '' +
' ' +
'
' +
' '
+ '' + selectStr + '
');
}
if ($tableHead.find('.soul-table-filter').length > 0) {
var columnField = [], mainDataSwitch = filterItems.indexOf('data') !== -1;
$tableHead.find('.soul-table-filter').each(function (index, elem) {
if ($(this).data('column') && (mainDataSwitch ? (!$(this).data('items') || $(this).data('items').split(',').indexOf('data') !== -1) : $(this).data('items').split(',').indexOf('data') !== -1)) {
columnField.push($(this).data('column'));
}
});
if (columnField.length > 0) {
if (typeof myTable.url !== 'undefined' && myTable.page) {
var datas = JSON.parse(JSON.stringify(myTable.where)), url = myTable.url;
datas['columns'] = JSON.stringify(columnField);
$.ajax({
url: url,
data: datas,
dataType: 'json',
method: 'post',
headers: myTable.headers || {},
contentType: myTable.contentType,
success: function (result) {
var uls = [];
for (var key in result) {
var list = result[key];
if (!((list.length === 1 && list[0] === '') || list.length === 0)) {
var ul = [];
ul.push("");
uls.push(ul.join(''));
} else {
uls.push("")
}
}
$('#soulDropList' + tableId).html(uls.join(''));
},
error: function () {
// layer.msg('列筛选数据查询失败！', {icon: 2, anim: 6})
}
})
} else {
var tableDatas = cache[myTable.id];
var dropDatas = {};
for (i = 0; i < tableDatas.length; i++) {
for (j = 0; j < columnField.length; j++) {
var value = typeof tableDatas[i][columnField[j]] === 'undefined' ? '' : tableDatas[i][columnField[j]];
if (dropDatas[columnField[j]]) {
if (dropDatas[columnField[j]].indexOf(value) === -1) {
dropDatas[columnField[j]].push(value);
}
} else {
dropDatas[columnField[j]] = [value]
}
}
}
var columnsConfigs = columns;
var uls = [];
for (j = 0; j < columnsConfigs.length; j++) {
var key = columnsConfigs[j].field;
var list = dropDatas[key];
if (list && !(list.length === 1 && list[0] === '')) {
if (columnsConfigs[j].filter && columnsConfigs[j].filter.split) {
var tempList = []
for (i = 0; i < list.length; i++) {
var tempList2 = String(list[i]).split(columnsConfigs[j].filter.split);
for (var k = 0; k < tempList2.length; k++) {
if (tempList.indexOf(tempList2[k]) === -1) {
tempList.push(tempList2[k])
}
}
}
list = tempList;
}
list.sort(function (a, b) {
if (isNaN(a) || isNaN(b)) {
return String(a) >= String(b)
} else {
return Number(a) - Number(b)
}
})
var ul = [];
ul.push("");
uls.push(ul.join(''));
} else {
uls.push("")
}
}
$('#soulDropList' + tableId).html(uls.join(''));
}
} else {
_this.bindFilterClick(myTable);
}
}
this.bindFilterClick(myTable);
},
showConditionBoard: function (myTable) {
var _this = this,
tableId = myTable.id,
where = where_cache[myTable.id] || {},
tableFilterTypes = where.tableFilterType ? JSON.parse(where.tableFilterType) : {},
filterSos = where.filterSos ? JSON.parse(where.filterSos) : [],
filterBoard = [], fieldMap = {}, firstColumn, curItems,
filterItems = myTable.filter ? myTable.filter.items || defaultFilterItems : defaultFilterItems,
columns = _this.getCompleteCols(myTable.cols),
i;
for (i = 0; i < columns.length; i++) {
if (columns[i].field && columns[i].filter) {
if (!firstColumn) {
firstColumn = columns[i]
}
curItems = columns[i].filter.items || filterItems;
fieldMap[columns[i]['field']] = {
title: columns[i].title,
items: curItems
}
}
}
filterBoard.push('')
filterBoard.push('
')
filterBoard.push('
');
filterBoard.push('')
// if (!isFirst) { //第一个隐藏 与或
filterBoard.push('
')
// }
switch (mode) {
case 'in':
filterBoard.push('' + (fieldMap[field].title) + '
');
filterBoard.push('筛选数据
');
filterBoard.push('共' + (filterSo.values ? filterSo.values.length : 0) + '条数据
');
filterBoard.push('
');
break;
case 'date':
filterBoard.push('' + (fieldMap[field].title) + '
');
filterBoard.push('选择日期
');
filterBoard.push('' + (filterSo.type === 'specific' ? filterSo.value || '请选择' : dateTimeItems[filterSo.type]) + '
');
filterBoard.push('
');
break;
case 'condition':
filterBoard.push('' + (fieldMap[field].title) + '
');
filterBoard.push('' + conditionChangeItems[filterSo.type] + '
');
if (type !== 'null' && type !== 'notNull') {
filterBoard.push('' + (typeof filterSo.value === 'undefined' || filterSo.value === '' ? '请输入...' : filterSo.value) + '
');
}
filterBoard.push('
');
break;
case 'group':
filterBoard.push('分组
')
filterBoard.push('')
filterBoard.push('
');
filterBoard.push('');
if (filterSo.children) {
for (var i = 0; i < filterSo.children.length; i++) {
groupHtml(filterSo.children[i], filterBoard, fieldMap, i === 0, i === (filterSo.children.length - 1));
}
}
filterBoard.push(' ');
break;
}
filterBoard.push(' ')
}
// prefix
form.on('switch(soul-edit-switch)', function (data) {
changePrefix(data)
})
// column
$('.soul-edit-out .item-field').on('click', function (e) {
e.stopPropagation();
showColums(this)
})
// type
$('.soul-edit-out .item-type').on('click', function (e) {
e.stopPropagation();
showTypes(this)
})
// value
$('.soul-edit-out .item-value').on('click', function (e) {
e.stopPropagation();
showValue(this)
})
// delete
$('.soul-edit-out .delete-item').on('click', function () {
var id = $(this).parent().data('id'),
refresh = $('.soul-edit-out .out_auto').prop('checked');
$(this).parent().remove();
_this.updateWhere(myTable, {
id: id,
delete: true
})
if (refresh) {
_this.soulReload(myTable);
}
})
function changePrefix(data) {
var prefix = data.elem.checked ? 'and' : 'or',
id = $(data.elem).parents('li:eq(0)').data('id'),
refresh = $('.soul-edit-out .out_auto').prop('checked');
$(data.elem).parents('li:eq(0)').data('prefix', prefix);
_this.updateWhere(myTable, {
id: id,
prefix: prefix
})
if (refresh) {
_this.soulReload(myTable)
}
}
function showColums(obj) {
_this.hideDropList(myTable);
_this.hideCondition(myTable);
_this.hideColumns(myTable);
_this.hideBfPrefix(myTable)
_this.hideBfType(myTable);
var top = $(obj).offset().top + $(obj).outerHeight(),
left = $(obj).offset().left;
$('#soul-bf-column' + tableId).find('li.soul-bf-selected').removeClass('soul-bf-selected')
$('#soul-bf-column' + tableId)
.data('field', $(obj).parent().data('field'))
.data('id', $(obj).parent().data('id'))
.data('mode', $(obj).parent().data('mode'))
.data('group', $(obj).parents('li:eq(2)').data('id') || '')
.data('refresh', $('.soul-edit-out .out_auto').prop('checked'))
.show()
.css({top: top, left: left})
.removeClass().addClass('fadeInUp animated')
.find('li[data-field="' + $(obj).parent().data('field') + '"]')
.addClass('soul-bf-selected')
}
function showTypes(obj) {
_this.hideDropList(myTable);
_this.hideCondition(myTable);
_this.hideColumns(myTable);
_this.hideBfColumn(myTable);
_this.hideBfPrefix(myTable);
var top = $(obj).offset().top + $(obj).outerHeight(),
left = $(obj).offset().left,
field = $(obj).parent().data('field');
$('#soul-bf-type' + tableId + ' li').hide()
if (tableFilterTypes[field] && tableFilterTypes[field].indexOf('date') === 0) {
$('#soul-bf-type' + tableId + ' li[data-mode=date]').show()
}
if (fieldMap[field].items.indexOf('data') !== -1) {
$('#soul-bf-type' + tableId + ' li[data-mode=in]').show()
}
if (fieldMap[field].items.indexOf('condition') !== -1) {
$('#soul-bf-type' + tableId + ' li[data-mode=condition]').show()
}
$('#soul-bf-type' + tableId).find('li.soul-bf-selected').removeClass('soul-bf-selected')
switch ($(obj).parent().data('mode')) {
case 'in':
$('#soul-bf-type' + tableId).find('li[data-mode="in"]')
.addClass('soul-bf-selected')
break;
case 'date':
$('#soul-bf-type' + tableId).find('li[data-mode="date"]')
.addClass('soul-bf-selected')
case 'condition':
$('#soul-bf-type' + tableId).find('li[data-value="' + $(obj).parent().data('type') + '"]')
.addClass('soul-bf-selected')
}
$('#soul-bf-type' + tableId)
.data('type', $(obj).parent().data('type'))
.data('mode', $(obj).parent().data('mode'))
.data('id', $(obj).parent().data('id'))
.data('group', $(obj).parents('li:eq(2)').data('id') || '')
.data('refresh', $('.soul-edit-out .out_auto').prop('checked'))
.show()
.css({top: top, left: left})
.removeClass().addClass('fadeInUp animated')
}
function showValue(obj) {
_this.hideColumns(myTable);
_this.hideBfType(myTable);
_this.hideBfPrefix(myTable)
_this.hideBfColumn(myTable);
var top,
left = $(obj).offset().left,
mode = $(obj).parent().data('mode'),
field = $(obj).parent().data('field'),
id = $(obj).parent().data('id'),
head = $(obj).parent().data('head'),
prefix = $(obj).parent().data('prefix'),
value = $(obj).parent().data('value'),
refresh = $('.soul-edit-out .out_auto').prop('checked'),
where = where_cache[myTable.id] || {},
filterSos = where.filterSos ? JSON.parse(where.filterSos) : [];
switch (mode) {
case 'in':
_this.hideCondition(myTable);
if (dorpListTimeOut) {
clearTimeout(dorpListTimeOut);
}
$('#soul-dropList' + tableId + '>.filter-search>input').val('');
$('#soul-dropList' + tableId).show();
$('#soulDropList' + tableId).find('.' + field + 'DropList li input[type=checkbox]:checked').prop('checked', false);
var filterSo = _this.getFilterSoById(filterSos, id);
if (filterSo.values) {
for (i = 0; i < filterSo.values.length; i++) {
$('#soulDropList' + tableId).find('.' + field + 'DropList li input[type=checkbox][value="' + filterSo.values[i] + '"]').prop('checked', true);
}
}
$('#soul-dropList' + tableId + '>ul').data('id', id).data('head', head).data('refresh', refresh).data('prefix', prefix).html($('#soulDropList' + tableId).find('.' + field + 'DropList li').clone());
form.render('checkbox', 'orm');
top = $(obj).offset().top + $(obj).outerHeight();
$('#soul-dropList' + tableId).css({'top': top, 'left': left})
.show().removeClass().addClass('fadeInUp animated');
setTimeout(function () {
$('#soul-dropList' + tableId + '>.filter-search>input').focus() // 聚焦搜索框
}, 1);
// 监听筛选数据
var liClick = true;
form.on('checkbox(soulDropList' + tableId + ')', function (data) {
liClick = false;
_this.updateDropList(myTable, field);
});
$('#soul-dropList' + tableId + '>ul>li[data-value]').on('click', function () {
if (liClick) {
$(this).find('div.layui-form-checkbox').trigger('click');
}
liClick = true;
})
break;
case 'date':
_this.hideDropList(myTable);
if (conditionTimeOut) {
clearTimeout(conditionTimeOut);
}
var filterSo = _this.getFilterSoById(filterSos, id),
top = $(obj).offset().top + $(obj).height();
_this.showDate(myTable, field, filterSo, "fadeInUp", top, left, "down", refresh);
break;
case 'condition':
$(obj).hide();
$(obj).after('
')
$(obj).next().children().val(value).select().on('keydown', function (e) {
if (e.keyCode === 13) {
$(this).blur();
}
}).on('blur', function () {
var newValue = $(this).val();
$(obj).html(typeof newValue === 'undefined' || newValue === '' ? '请输入...' : newValue);
$(obj).show();
$(this).parent().remove()
if (newValue !== value) {
$(obj).parent().data('value', newValue);
_this.updateWhere(myTable, {
id: id,
value: newValue
})
if (refresh) {
_this.soulReload(myTable);
}
}
})
break;
}
}
$('.soul-edit-out a[data-type]').on('click', function () {
if ($(this).data('type') === 'search') {
_this.soulReload(myTable);
} else {
addLine(this)
}
})
function addLine(obj) {
var refresh = $('.soul-edit-out .out_auto').prop('checked');
filterBoard = []
switch ($(obj).data('type')) {
case 'addOne':
var filterSo = {
prefix: 'and',
field: firstColumn.field,
mode: 'condition',
type: 'eq',
value: ''
}
if ($(obj).parent().parent().data('id')) {
$.extend(filterSo, {
groupId: $(obj).parent().parent().data('id')
})
}
_this.updateWhere(myTable, filterSo);
filterBoard.push('');
filterBoard.push('');
filterBoard.push('
')
filterBoard.push('' + fieldMap[filterSo.field].title + '
');
filterBoard.push('等于
');
filterBoard.push('请输入...
');
filterBoard.push('
');
filterBoard.push(' ');
break;
case 'addGroup':
var filterSo = {
prefix: 'and',
mode: 'group',
children: []
}
if ($(obj).parent().parent().data('id')) {
$.extend(filterSo, {
groupId: $(obj).parent().parent().data('id')
})
}
_this.updateWhere(myTable, filterSo);
filterBoard.push('');
filterBoard.push('');
filterBoard.push('
')
filterBoard.push('分组
')
filterBoard.push('')
filterBoard.push('
');
filterBoard.push('');
filterBoard.push(' ');
break;
}
if (refresh) {
_this.soulReload(myTable);
}
if ($(obj).parent().parent().children('ul').children('li').length > 0) {
$(obj).parent().parent().children('ul').children('li:last').removeClass('last');
if ($(obj).parent().parent().children('ul').children('li:last').children('ul.group').length > 0) {
$(obj).parent().parent().children('ul').children('li:last').children('ul.group').addClass('line')
}
}
$(obj).parent().parent().children('ul').append(filterBoard.join(''));
form.render('checkbox', 'soul-edit-out')
if ($(obj).data('type') === 'addGroup') {
$(obj).parent().parent().children('ul').children("li:last").find('a[data-type]').on('click', function () {
addLine(this)
})
} else {
$(obj).parent().parent().children('ul').children("li:last").find('.item-field').on('click', function (e) {
e.stopPropagation();
showColums(this);
})
$(obj).parent().parent().children('ul').children("li:last").find('.item-type').on('click', function (e) {
e.stopPropagation();
showTypes(this);
})
$(obj).parent().parent().children('ul').children("li:last").find('.item-value').on('click', function (e) {
e.stopPropagation();
showValue(this);
})
}
$(obj).parent().parent().children('ul').children("li:last").children('.delete-item').on('click', function () {
var id = $(this).parent().data('id'),
refresh = $('.soul-edit-out .out_auto').prop('checked');
$(this).parent().remove();
_this.updateWhere(myTable, {
id: id,
delete: true
})
if (refresh) {
_this.soulReload(myTable);
}
})
}
}
, hideColumns: function (myTable, animate) {
var tableId = myTable.id;
$('#soul-columns' + tableId).removeClass().addClass('fadeOutLeft animated')
if (columnsTimeOut) {
clearTimeout(columnsTimeOut)
}
if (typeof animate === 'undefined' || animate) {
columnsTimeOut = setTimeout(function (e) {
$('#soul-columns' + tableId).hide();
}, 500)
} else {
$('[id^=soul-columns]').hide();
}
}
, hideDropList: function (myTable, animate) {
var tableId = myTable.id;
$('#soul-dropList' + tableId).removeClass().addClass('fadeOutLeft animated')
if (dorpListTimeOut) {
clearTimeout(dorpListTimeOut);
}
if (typeof animate === 'undefined' || animate) {
dorpListTimeOut = setTimeout(function (e) {
$('#soul-dropList' + tableId).hide();
}, 500)
} else {
$('[id^=soul-dropList]').hide();
}
}
, hideCondition: function (myTable, animate) {
var tableId = myTable.id;
$('#soul-condition' + tableId).removeClass().addClass('fadeOutLeft animated')
if (conditionTimeOut) {
clearTimeout(conditionTimeOut);
}
if (typeof animate === 'undefined' || animate) {
conditionTimeOut = setTimeout(function (e) {
$('#soul-condition' + tableId).hide();
}, 500)
} else {
$('[id^=soul-condition]').hide();
}
}
, hideBfPrefix: function (myTable, animate) {
var tableId = myTable.id;
$('#soul-bf-prefix' + tableId).removeClass().addClass('fadeOutDown animated')
if (bfColumnTimeOut) {
clearTimeout(bfColumnTimeOut);
}
if (typeof animate === 'undefined' || animate) {
bfColumnTimeOut = setTimeout(function () {
$('#soul-bf-prefix' + tableId).hide();
}, 500)
} else {
$('[id=soul-bf-prefix' + tableId + ']').hide();
}
}
, hideBfColumn: function (myTable, animate) {
var tableId = myTable.id;
$('#soul-bf-column' + tableId).removeClass().addClass('fadeOutDown animated')
if (bfColumnTimeOut) {
clearTimeout(bfColumnTimeOut);
}
if (typeof animate === 'undefined' || animate) {
bfColumnTimeOut = setTimeout(function () {
$('#soul-bf-column' + tableId).hide();
}, 500)
} else {
$('[id=soul-bf-column' + tableId + ']').hide();
}
}
, hideBfType: function (myTable, animate) {
var tableId = myTable.id;
$('#soul-bf-type' + tableId).removeClass().addClass('fadeOutDown animated')
if (bfCond1TimeOut) {
clearTimeout(bfCond1TimeOut);
}
if (typeof animate === 'undefined' || animate) {
bfCond1TimeOut = setTimeout(function () {
$('#soul-bf-type' + tableId).hide();
}, 500)
} else {
$('[id=soul-bf-type' + tableId + ']').hide();
}
}
, bindFilterClick: function (myTable) {
var _this = this,
$table = $(myTable.elem),
$tableHead = $table.next().children('.layui-table-box').children('.layui-table-header').children('table'),
$fixedLeftTableHead = $table.next().children('.layui-table-box').children('.layui-table-fixed-l').children('.layui-table-header').children('table'),
$fixedRigthTableHead = $table.next().children('.layui-table-box').children('.layui-table-fixed-r').children('.layui-table-header').children('table'),
tableId = myTable.id,
filterItems = myTable.filter ? myTable.filter.items || defaultFilterItems : defaultFilterItems,
mainListTimeOut;
// 显示筛选框
$tableHead.find('.soul-table-filter').off('click').on('click', function (e) {
e.stopPropagation();
showFilter($(this))
});
$fixedLeftTableHead.find('.soul-table-filter').off('click').on('click', function (e) {
e.stopPropagation();
showFilter($(this))
});
$fixedRigthTableHead.find('.soul-table-filter').off('click').on('click', function (e) {
e.stopPropagation();
showFilter($(this))
});
function showFilter($that) {
var curItems = $that.data('items') ? $that.data('items').split(',') : filterItems
_this.hideColumns(myTable, false);
_this.hideDropList(myTable, false);
_this.hideCondition(myTable, false);
$('[id^=main-list]').hide();
$('#main-list' + tableId).data({'field': $that.data('column'), 'split': $that.data('split')});
$('#soul-columns' + tableId + ' [type=checkbox]').attr('disabled', false);
// if (myTable.cols[0][0].type=='checkbox') {
// $('#soul-columns'+tableId+' [type=checkbox]:eq('+($that.parents('th').data('key').split('-')[2]-1)+')').attr('disabled', true);
// } else {
$('#soul-columns' + tableId + ' li[data-key=' + $that.parents('th').data('key').split('-')[2] + '] [type=checkbox]').attr('disabled', true);
// }
$('#main-list' + tableId + ' > li').hide()
// 是否显示排序框
if ($that.hasClass('layui-table-sort')) {
$('#main-list' + tableId + ' .soul-sort').show()
}
for (var i = 0; i < curItems.length; i++) {
$('#main-list' + tableId + ' .' + itemsMap[curItems[i]]).show()
if ($('#main-list' + tableId + ' .' + itemsMap[curItems[i]]).index() !== (i + 2)) {
$('#main-list' + tableId + '>li:eq("' + (i + 2) + '")').before($('#main-list' + tableId + ' .' + itemsMap[curItems[i]]))
}
}
if (mainListTimeOut) {
clearTimeout(mainListTimeOut)
}
var left, animate;
if ($that.offset().left + $('#main-list' + tableId).outerWidth() < document.body.clientWidth) {
left = $that.offset().left + 10;
animate = 'fadeInLeft';
} else {
left = $that.offset().left - $('#main-list' + tableId).outerWidth();
animate = 'fadeInRight';
}
$('#main-list' + tableId).data('type', myTable.where.tableFilterType ? JSON.parse(myTable.where.tableFilterType)[$that.data('column')] || '' : '').hide().css({
'top': $that.offset().top + 10,
'left': left
}).show().removeClass().addClass(animate + ' animated');
// 排序
$('#main-list' + tableId + ' .soul-sort').on('click', function (e) {
$that.siblings('.layui-table-sort').find('.layui-table-sort-' + $(this).data('value')).trigger('click');
$('#main-list' + tableId).hide();
})
form.render('checkbox', 'orm');
}
$(document).on('click', function (e) {
$('#main-list' + tableId).hide();
_this.hideColumns(myTable, false);
_this.hideDropList(myTable, false);
_this.hideCondition(myTable, false);
_this.hideBfPrefix(myTable, false);
_this.hideBfColumn(myTable, false);
_this.hideBfType(myTable, false);
});
$('#main-list' + tableId + ',#soul-columns' + tableId + ',#soul-dropList' + tableId + ',#soul-condition' + tableId).on('click', function (e) {
$(this).find('.layui-form-selected').removeClass('layui-form-selected')
e.stopPropagation();
});
//渲染底部筛选条件
_this.renderBottomCondition(myTable);
// 表头样式
var where = where_cache[myTable.id] || {},
filterSos = JSON.parse(where.filterSos ? where.filterSos : '[]');
for (var i = 0; i < filterSos.length; i++) {
if (filterSos[i].head) {
var hasFilter = false;
switch (filterSos[i].mode) {
case 'in':
if (filterSos[i].values && filterSos[i].values.length > 0) {
hasFilter = true
}
break;
case 'date':
if (filterSos[i].type !== 'all' && typeof filterSos[i].value !== 'undefined' && filterSos[i].value !== '') {
hasFilter = true
}
break;
case 'group':
if (filterSos[i].children && filterSos[i].children.length > 0) {
hasFilter = true
}
default:
break;
}
$tableHead.find('thead>tr>th[data-field="' + filterSos[i].field + '"] .soul-table-filter').attr('soul-filter', '' + hasFilter);
$fixedLeftTableHead.find('thead>tr>th[data-field="' + filterSos[i].field + '"] .soul-table-filter').attr('soul-filter', '' + hasFilter);
$fixedRigthTableHead.find('thead>tr>th[data-field="' + filterSos[i].field + '"] .soul-table-filter').attr('soul-filter', '' + hasFilter);
}
}
}
, resize: function (myTable) {
var _this = this,
$table = $(myTable.elem),
$tableBox = $table.next().children('.layui-table-box'),
$tableMain = $tableBox.children('.layui-table-main')
// 减去底部筛选的高度
if ($table.next().children('.soul-bottom-contion').length > 0) {
$table.next().children('.soul-bottom-contion').children('.condition-items').css('width', $table.next().children('.soul-bottom-contion').width() - $table.next().children('.soul-bottom-contion').children('.editCondtion').outerWidth());
var bodyHeight = $table.next().height() - $table.next().children('.soul-bottom-contion').outerHeight()
if ($table.next().children('.layui-table-tool').length > 0) {
bodyHeight = bodyHeight - $table.next().children('.layui-table-tool').outerHeight();
}
if ($table.next().children('.layui-table-total').length > 0) {
bodyHeight = bodyHeight - $table.next().children('.layui-table-total').outerHeight();
}
if ($table.next().children('.layui-table-page').length > 0) {
bodyHeight = bodyHeight - $table.next().children('.layui-table-page').outerHeight();
}
bodyHeight = bodyHeight - $table.next().children('.layui-table-box').children('.layui-table-header').outerHeight();
$table.next().children('.layui-table-box').children('.layui-table-body').height(bodyHeight)
var fixHeight = bodyHeight - _this.getScrollWidth($tableMain[0]),
layMainTableHeight = $tableMain.children('table').height()
$table.next().children('.layui-table-box').children('.layui-table-fixed').children('.layui-table-body').height(layMainTableHeight >= fixHeight ? fixHeight : 'auto')
var scollWidth = $tableMain.width() - $tableMain.prop('clientWidth') //纵向滚动条宽度;
$tableBox.children('.layui-table-fixed-r').css('right', scollWidth - 1);
}
}
/**
* 同步当前 droplist
* @param myTable
* @param field
*/
, updateDropList: function (myTable, field) {
var _this = this,
$table = $(myTable.elem),
tableId = myTable.id,
id = $('#soul-dropList' + tableId + '>ul').data('id'),
$checkedDom = $('#soul-dropList' + tableId + '>ul input[type=checkbox]:checked'),
values = [],
head = $('#soul-dropList' + tableId + '>ul').data('head'),
prefix = $('#soul-dropList' + tableId + '>ul').data('prefix'),
refresh = $('#soul-dropList' + tableId + '>ul').data('refresh'),
split = $('#soul-dropList' + tableId + '>ul').data('split');
if ($checkedDom.length > 0) {
$checkedDom.each(function () {
values.push($(this).val())
})
}
var filterSo = {
id: id,
head: head,
prefix: prefix || 'and',
mode: 'in',
field: field,
split: split,
values: values
};
_this.updateWhere(myTable, filterSo);
if (!id) {
$('#soul-dropList' + tableId + '>ul').data('id', filterSo.id);
}
if ($('.soul-edit-out').length > 0) {
$('.soul-edit-out li[data-id="' + filterSo.id + '"]>.item-value').html('共' + (filterSo.values ? filterSo.values.length : 0) + '条数据')
}
if (refresh) {
_this.soulReload(myTable);
}
}
, getFilterSoById: function (filterSos, id) {
for (var i = 0; i < filterSos.length; i++) {
if (filterSos[i].id === id) {
return filterSos[i]
} else if (filterSos[i].mode === 'group') {
for (var j = 0; j < filterSos[i].children.length; j++) {
var filterSo = this.getFilterSoById(filterSos[i].children, id);
if (filterSo) return filterSo;
}
}
}
return null
}
/**
* 更新 filter 条件
* @param myTable
* @param filterSo
*/
, updateWhere: function (myTable, filterSo) {
var _this = this,
where = where_cache[myTable.id] || {},
filterSos = JSON.parse(where.filterSos ? where.filterSos : '[]');
if (filterSo.id || filterSo.groupId) {
for (var i = 0; i < filterSos.length; i++) {
if (filterSo.delete && filterSos[i].id === filterSo.id) {
filterSos.splice(i, 1);
break;
}
if (updateFilterSo(filterSos[i], filterSo)) {
break;
}
}
} else if (!(filterSo.mode === 'in' && !(filterSo.values && filterSo.values.length > 0))) {
filterSos.push($.extend(filterSo, {
id: _this.getDifId()
}))
}
where['filterSos'] = JSON.stringify(filterSos);
myTable.where = where;
where_cache[myTable.id] = where;
function updateFilterSo(filterSo, newFilterSo) {
var isMatch = false;
if (filterSo.id === newFilterSo.id) {
$.extend(filterSo, newFilterSo);
isMatch = true;
}
// 在分组中新增
if (!newFilterSo.id && filterSo.id === newFilterSo.groupId) {
filterSo.children.push($.extend(newFilterSo, {
id: _this.getDifId()
}))
} else if (filterSo.mode === 'group') {
for (var i = 0; i < filterSo.children.length; i++) {
if (newFilterSo.delete && filterSo.children[i].id === newFilterSo.id) {
filterSo.children.splice(i, 1);
return true;
}
if (updateFilterSo(filterSo.children[i], newFilterSo)) {
return true;
}
}
}
return isMatch;
}
}
/**
* 根据当前条件重载表格
* @param myTable 需要重载的表格对象
* @param isr 是否为筛选重载，为 true 时，不进行筛选的初始化动作（包括渲染dom、请求表头数据等）
*/
, soulReload: function (myTable, isr) {
var _this = this,
$table = $(myTable.elem),
scrollLeft = $table.next().children('.layui-table-box').children('.layui-table-main').scrollLeft();
isFilterReload[myTable.id] = typeof isr === 'undefined' ? true : isr;
if (typeof myTable.url !== 'undefined' && myTable.page) {
$table.data('scrollLeft', scrollLeft);
/**
* 后台筛选
*/
table.reload(myTable.id, {
where: where_cache[myTable.id] || {},
page: {
curr: 1 //重新从第 1 页开始
}
})
} else {
/**
* 前端筛选
*/
var where = where_cache[myTable.id] || {},
filterSos = JSON.parse(where.filterSos ? where.filterSos : '[]'),
tableFilterTypes = where.tableFilterType ? JSON.parse(where.tableFilterType) : {},
loading = layer.load(2);
if (!myTable.page) {
// 修复前端不分页时，layui table bug 导致的只显示10条数据的问题
myTable.limit = 100000000
}
if (filterSos.length > 0) {
var newData = [];
layui.each(cache[myTable.id], function (index, item) {
var show = true;
for (var i = 0; i < filterSos.length; i++) {
show = _this.handleFilterSo(filterSos[i], item, tableFilterTypes, show, i === 0)
}
if (show) {
newData.push(item)
}
})
if (myTable.page) {
table.reload(myTable.id, {
data: newData
, initSort: myTable.initSort
, isSoulFrontFilter: true
, page: {
curr: 1 //重新从第 1 页开始
}
})
} else {
var url = myTable.url;
$table.next().off('click')
var inst = table.reload(myTable.id, {
url: ''
, initSort: myTable.initSort
, isSoulFrontFilter: true
, data: newData
})
inst.config.url = url;
}
myTable.data = newData
} else {
if (myTable.page) {
table.reload(myTable.id, {
data: cache[myTable.id]
, initSort: myTable.initSort
, isSoulFrontFilter: true
, page: {
curr: 1 //重新从第 1 页开始
}
})
} else {
table.reload(myTable.id, {
data: cache[myTable.id]
, initSort: myTable.initSort
, isSoulFrontFilter: true
})
}
myTable.data = cache[myTable.id]
}
$table.next().children('.layui-table-box').children('.layui-table-main').scrollLeft(scrollLeft);
layer.close(loading)
}
}
, handleFilterSo: function (filterSo, item, tableFilterTypes, show, first) {
var isOr = first ? false : filterSo.prefix === 'or',
field = filterSo.field,
value = filterSo.value,
status = true;
// 如果有子元素
if (filterSo.children && filterSo.children.length > 0) {
for (var i = 0; i < filterSo.children.length; i++) {
status = this.handleFilterSo(filterSo.children[i], item, tableFilterTypes, status, i === 0)
}
return isOr ? show || status : show && status;
}
switch (filterSo.mode) {
case "in":
if (filterSo.values && filterSo.values.length > 0) {
if (filterSo.split) {
var tempList = (item[field] + '').split(filterSo.split);
var tempStatus = false;
for (var i = 0; i < tempList.length; i++) {
if (filterSo.values.indexOf(tempList[i]) !== -1) {
tempStatus = true;
}
}
status = tempStatus;
} else {
status = filterSo.values.indexOf(item[field] + '') !== -1
}
} else {
return show;
}
break;
case "condition":
if (filterSo.type !== 'null' && filterSo.type !== 'notNull' && (typeof value === 'undefined' || value === '')) {
return show;
}
switch (filterSo.type) {
case "eq":
status = isNaN(item[field]) || isNaN(value) ? item[field] === value : Number(item[field]) === Number(value);
break;
case "ne":
status = isNaN(item[field]) || isNaN(value) ? item[field] !== value : Number(item[field]) !== Number(value);
break;
case "gt":
status = isNaN(item[field]) || isNaN(value) ? item[field] > value : Number(item[field]) > Number(value);
break;
case "ge":
status = isNaN(item[field]) || isNaN(value) ? item[field] >= value : Number(item[field]) >= Number(value);
break;
case "lt":
status = isNaN(item[field]) || isNaN(value) ? item[field] < value : Number(item[field]) < Number(value);
break;
case "le":
status = isNaN(item[field]) || isNaN(value) ? item[field] <= value : Number(item[field]) <= Number(value);
break;
case "contain":
status = (item[field] + '').indexOf(value) !== -1;
break;
case "notContain":
status = (item[field] + '').indexOf(value) === -1;
break;
case "start":
status = (item[field] + '').indexOf(value) === 0;
break;
case "end":
var d = (item[field] + '').length - (value + '').length;
status = d >= 0 && (item[field] + '').lastIndexOf(value) === d;
break;
case "null":
status = typeof item[field] === 'undefined' || item[field] === '' || item[field] === null;
break;
case "notNull":
status = typeof item[field] !== 'undefined' && item[field] !== '' && item[field] !== null;
break;
}
break;
case "date":
var dateVal = new Date(Date.parse(item[field].replace(/-/g, "/")));
switch (filterSo.type) {
case 'all':
status = true;
break;
case 'yesterday':
status = item[field] && isBetween(dateVal, getToday() - 86400, getToday() - 1);
break;
case 'thisWeek':
status = item[field] && isBetween(dateVal, getFirstDayOfWeek(), getFirstDayOfWeek() + 86400 * 7 - 1);
break;
case 'lastWeek':
status = item[field] && isBetween(dateVal, getFirstDayOfWeek() - 86400 * 7, getFirstDayOfWeek() - 1);
break;
case 'thisMonth':
status = item[field] && isBetween(dateVal, getFirstDayOfMonth(), getCurrentMonthLast());
break;
case 'thisYear':
status = item[field] && isBetween(dateVal, new Date(new Date().getFullYear(), 1, 1) / 1000, new Date(new Date().getFullYear() + 1, 1, 1) / 1000 - 1);
break;
case 'specific':
var dateFormat = dateVal.getFullYear();
dateFormat += '-' + (timeAdd0(dateVal.getMonth() + 1));
dateFormat += '-' + timeAdd0(dateVal.getDate());
status = item[field] && dateFormat === value
break;
}
break;
}
// 今天凌晨
function getToday() {
return new Date().setHours(0, 0, 0, 0) / 1000;
}
// 本周第一天
function getFirstDayOfWeek() {
var now = new Date();
var weekday = now.getDay() || 7; //获取星期几,getDay()返回值是 0（周日） 到 6（周六） 之间的一个整数。0||7为7，即weekday的值为1-7
return new Date(now.setDate(now.getDate() - weekday + 1)).setHours(0, 0, 0, 0) / 1000;//往前算（weekday-1）天，年份、月份会自动变化
}
//获取当月第一天
function getFirstDayOfMonth() {
return new Date(new Date().setDate(1)).setHours(0, 0, 0, 0) / 1000;
}
//获取当月最后一天最后一秒
function getCurrentMonthLast() {
var date = new Date();
var currentMonth = date.getMonth();
var nextMonth = ++currentMonth;
var nextMonthFirstDay = new Date(date.getFullYear(), nextMonth, 1);
return nextMonthFirstDay / 1000 - 1;
}
function isBetween(v, a, b) {
return (v.getTime() / 1000) >= a && (v.getTime() / 1000) <= b;
}
function timeAdd0(str) {
str += "";
if (str.length <= 1) {
str = '0' + str;
}
return str
}
return isOr ? show || status : show && status;
}
, getDifId: function () {
return maxId++;
}
, showDate: function (myTable, field, filterSo, animate, top, left, type, refresh) {
var _this = this,
tableId = myTable.id,
conditionHtml = [],
documentWidth = document.body.clientWidth,
animate;
conditionHtml.push('');
conditionHtml.push('
');
for (var key in dateTimeItems) {
conditionHtml.push('
');
}
conditionHtml.push('
');
conditionHtml.push('
');
if (!first) {
bcHtml.push('
' + (isOr ? '或' : '与') + '
');
}
for (var i = 0; i < filterSo.children.length; i++) {
_this.bottomConditionHtml(bcHtml, filterSo.children[i], fieldMap, i === 0);
}
bcHtml.push('
');
bcHtml.push('
');
if (!first) {
bcHtml.push('
' + (isOr ? '或' : '与') + '
');
}
bcHtml.push('
' + fieldMap[field].title + '
');
bcHtml.push('
');
switch (filterSo.mode) {
case 'in':
bcHtml.push('筛选数据');
break;
case 'condition':
bcHtml.push(conditionChangeItems[filterSo.type]);
break;
case 'date':
bcHtml.push('选择日期');
break;
default:
bcHtml.push('未知');
break;
}
bcHtml.push('
');
if (filterSo.type !== 'null' && filterSo.type !== 'notNull') {
bcHtml.push('
');
switch (filterSo.mode) {
case 'in':
bcHtml.push('共' + (filterSo.values ? filterSo.values.length : 0) + '条数据');
break;
case 'date':
bcHtml.push(filterSo.type === 'specific' ? filterSo.value || '请选择' : dateTimeItems[filterSo.type])
break;
case 'condition':
default:
bcHtml.push(typeof filterSo.value === 'undefined' || filterSo.value === '' ? '请输入...' : filterSo.value);
break;
}
bcHtml.push('
')
}
bcHtml.push('
');
bcHtml.push('
')
bcHtml.push('与 ')
bcHtml.push('或 ')
bcHtml.push(' ')
for (var field in fieldMap) {
bcHtml.push('' + fieldMap[field].title + ' ')
}
bcHtml.push(' ')
bcHtml.push('筛选数据 ')
bcHtml.push('选择日期 ')
for (var key in conditionChangeItems) {
bcHtml.push('' + conditionChangeItems[key] + ' ')
}
bcHtml.push('
')
$(obj).next().children().val(value).select().on('keydown', function (e) {
if (e.keyCode === 13) {
$(this).blur();
}
}).on('blur', function () {
var newValue = $(this).val();
$(obj).html(typeof newValue === 'undefined' || newValue === '' ? '请输入...' : newValue);
$(obj).show();
$(this).parent().remove()
if (newValue !== value) {
_this.updateWhere(myTable, {
id: id,
value: newValue
})
_this.soulReload(myTable);
}
})
break;
}
})
/**
* 三、选择事件
*/
// 1. 选择prefix
$('#soul-bf-prefix' + tableId + '>ul>li').off('click').on('click', function () {
var id = $(this).parent().parent().data('id'),
newPrefix = $(this).data('value'),
oldPrefix = $(this).parent().parent().data('prefix'),
refresh = $(this).parent().parent().data('refresh');
if (oldPrefix !== newPrefix) {
_this.updateWhere(myTable, {
id: id,
prefix: newPrefix
});
if (refresh === true) {
_this.soulReload(myTable);
}
}
})
// 1. 选择列
$('#soul-bf-column' + tableId + '>ul>li').off('click').on('click', function () {
var oldField = $(this).parent().parent().data('field'),
newField = $(this).data('field'),
mode = $(this).parent().parent().data('mode'),
group = $(this).parent().parent().data('group'),
refresh = $(this).parent().parent().data('refresh');
if (oldField !== newField) {
var filterSo = {
id: $(this).parent().parent().data('id'),
field: newField
}
if (fieldMap[newField].items.indexOf(modeMapItems[mode]) === -1) {
$.extend(filterSo, $.extend({}, revertMode[modeMapItems[mode]],
revertMode[modeMapItems[mode]].mode === 'condition' && _this.startsWith(tableFilterTypes[newField], 'date')
? {
mode: 'date',
type: 'all'
} : {}))
} else {
// 重置values值
if (mode === 'in') {
$.extend(filterSo, {
values: []
})
} else if (mode === 'date' && !(_this.startsWith(tableFilterTypes[newField], 'date'))) {
$.extend(filterSo, {
mode: 'condition',
type: 'eq',
value: ''
})
} else if (mode !== 'date' && _this.startsWith(tableFilterTypes[newField], 'date')) {
$.extend(filterSo, {
mode: 'date',
type: 'all'
})
}
}
// 如果是头部条件，选择列是清除
if (group) {
_this.updateWhere(myTable, {
id: group,
head: false
})
}
_this.updateWhere(myTable, filterSo);
if ($('.soul-edit-out').length > 0) {
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').data(filterSo).children('.item-field').html(fieldMap[newField].title);
if (filterSo.mode === 'in') {
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').children('.item-type').html('筛选数据')
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').children('.item-value').html('共0条数据')
} else if (mode !== filterSo.mode) {
if (filterSo.mode === 'date') {
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').children('.item-type').html('选择日期')
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').children('.item-value').html(dateTimeItems[filterSo.type])
} else if (filterSo.mode === 'condition') {
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').children('.item-type').html(conditionChangeItems[filterSo.type])
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').children('.item-value').html(filterSo.value === '' ? '请输入...' : filterSo.value)
}
}
}
if (refresh === true) {
_this.soulReload(myTable);
}
}
})
// 2. 选择类型
$('#soul-bf-type' + tableId + '>ul>li').off('click').on('click', function () {
var newType = $(this).data('value') + "" // 引号修复为空（null值）传递问题
, newMode = $(this).data('mode')
, type = $(this).parent().parent().data('type')
, mode = $(this).parent().parent().data('mode')
, group = $(this).parent().parent().data('group')
, refresh = $(this).parent().parent().data('refresh')
if (type !== newType) {
var filterSo = {
id: $(this).parent().parent().data('id'),
type: newType,
mode: newMode
}
if (mode !== newMode) {
$.extend(filterSo, {
value: '',
values: []
})
}
// 如果是头部条件，选择列是清除
if (group && newMode === 'in') {
_this.updateWhere(myTable, {
id: group,
head: false
})
}
_this.updateWhere(myTable, filterSo)
if ($('.soul-edit-out').length > 0) {
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').data(filterSo).children('.item-value').show();
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').data(filterSo).children('.item-type').html(conditionChangeItems[newType] || (newMode === 'in' ? '筛选数据' : '选择日期'));
switch (newMode) {
case 'in':
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').data(filterSo).children('.item-value').html('共0条数据');
break;
case 'date':
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').data(filterSo).children('.item-value').html(dateTimeItems[newType]);
break;
case 'condition':
if (mode !== newMode) {
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').data(filterSo).children('.item-value').html('请输入...');
}
$('.soul-edit-out li[data-id="' + filterSo.id + '"]').data(filterSo).children('.item-value')[newType === 'null' || newType === 'notNull' ? 'hide' : 'show']()
break;
}
}
// 是否立即更新
if (refresh === true) {
_this.soulReload(myTable);
}
}
})
/**
* 五、底部筛选条件删除事件
*/
$bottomCondition.find('.condition-items .condition-item .condition-item-close').on('click', function () {
_this.updateWhere(myTable, {
id: $(this).parents('.condition-item:eq(0)').data('id'),
delete: true
})
_this.soulReload(myTable);
})
}
/**
* 导出 excel 文件
* @param myTable
* @param curExcel
*/
, export: function (myTable, curExcel) {
if (typeof myTable === 'string') {
myTable = table_cache[myTable] // tableId 转 myTable
}
var loading = layer.msg('文件下载中', {
icon: 16
, time: -1
, anim: -1
, fixed: false
});
var cols = this.deepClone(myTable.cols)
, style = myTable.elem.next().find('style')[0]
, sheet = style.sheet || style.styleSheet || {}
, rules = sheet.cssRules || sheet.rules;
layui.each(rules, function (i, item) {
if (item.style.width) {
var keys = item.selectorText.split('-');
cols[keys[3]][keys[4]]['width'] = parseInt(item.style.width)
}
})
var data = JSON.parse(JSON.stringify(myTable.data || cache[myTable.id])),
showField = {},
widths = {},
mergeArrays = [], // 合并配置
heightConfig = {},
$table = $(myTable.elem),
$tableBody = $table.next().children('.layui-table-box').children('.layui-table-body').children('table'),
$tableTotal = myTable.totalRow ? $table.next().children('.layui-table-total').children(":first") : null,
finalExcel = Object.assign({}, myTable.excel, curExcel);
var filename = finalExcel.filename ? (typeof finalExcel.filename === 'function' ? finalExcel.filename.call(this) : finalExcel.filename) : '表格数据.xlsx',
checked = finalExcel.checked === true,
curPage = finalExcel.curPage === true,
customColumns = finalExcel.columns,
totalRow = finalExcel.totalRow,
type = filename.substring(filename.lastIndexOf('.') + 1, filename.length),
tableStartIndex = finalExcel.add && finalExcel.add.top && Array.isArray(finalExcel.add.top.data) ? finalExcel.add.top.data.length + 1 : 1, //表格内容从哪一行开始
bottomLength = finalExcel.add && finalExcel.add.bottom && Array.isArray(finalExcel.add.bottom.data) ? finalExcel.add.bottom.data.length : 0,// 底部自定义行数
i, j, k;
if (finalExcel.data){
if(Array.isArray(finalExcel.data)) {
data = finalExcel.data
} else {
console.error('导出指定数据 data 不符合数组格式', finalExcel.data)
layer.close(loading)
return;
}
} else if (checked) { // 获取选中行数据
// data = table.checkStatus(myTable.id).data;
data = []
if (cache[myTable.id] && cache[myTable.id].length > 0) {
for (i = 0; i < cache[myTable.id].length; i++) {
if (cache[myTable.id][i][table.config.checkName]) {
data.push(cache[myTable.id][i])
}
}
}
} else if (curPage) {
data = layui.table.cache[myTable.id]
} else if (myTable.url && myTable.page) {
var ajaxStatus = true;
var searchParam = isFilterCache[myTable.id] ? where_cache[myTable.id] : table_cache[myTable.id].where;
if (myTable.contentType && myTable.contentType.indexOf("application/json") == 0) { //提交 json 格式
searchParam = JSON.stringify(searchParam);
}
$.ajax({
url: myTable.url,
data: searchParam,
dataType: 'json',
method: myTable.method || 'post',
async: false,
cache: false,
headers: myTable.headers || {},
contentType: myTable.contentType,
success: function (res) {
if (typeof myTable.parseData === 'function') {
res = myTable.parseData(res) || res;
}
//检查数据格式是否符合规范
if (res[myTable.response.statusName] != myTable.response.statusCode) {
layer.msg('返回的数据不符合规范，正确的成功状态码应为："' + myTable.response.statusName + '": ' + myTable.response.statusCode, {
icon: 2,
anim: 6
});
} else {
data = res[myTable.response.dataName]
}
},
error: function (res) {
layer.msg('请求异常！', {icon: 2, anim: 6});
ajaxStatus = false;
}
})
if (!ajaxStatus) {
return;
}
} else {
var $sortDoom = $table.next().children('.layui-table-box').children('.layui-table-header').find('.layui-table-sort[lay-sort$="sc"]:eq(0)')
if ($sortDoom.length > 0) {
var sortField = $sortDoom.parent().parent().data('field');
var sortOrder = $sortDoom.attr('lay-sort');
switch (sortOrder) {
case 'asc':
data = layui.sort(data, sortField);
break;
case 'desc':
data = layui.sort(data, sortField, true);
break;
default:
break;
}
}
}
// 制定显示列和顺序
var tempArray, cloneCol, columnsMap = [], curRowUnShowCount;
for (i = 0; i < cols.length; i++) {
curRowUnShowCount = 0;
for (j = 0; j < cols[i].length; j++) {
if (!cols[i][j].exportHandled) {
if (cols[i][j].rowspan > 1) {
if ((cols[i][j].field || cols[i][j].type === 'numbers') && !cols[i][j].hide) {
mergeArrays.push([numberToLetter(j + 1 - curRowUnShowCount) + (i + tableStartIndex), numberToLetter(j + 1 - curRowUnShowCount) + (i + parseInt(cols[i][j].rowspan) + tableStartIndex - 1)])
} else {
curRowUnShowCount++;
}
cloneCol = this.deepClone(cols[i][j])
cloneCol.exportHandled = true;
k = i + 1;
while (k < cols.length) {
cols[k].splice(j, 0, cloneCol)
k++
}
}
if (cols[i][j].colspan > 1) {
mergeArrays.push([numberToLetter(j + 1 - curRowUnShowCount) + (i + tableStartIndex), numberToLetter(j + parseInt(cols[i][j].colspan) - curRowUnShowCount) + (i + tableStartIndex)])
cloneCol = this.deepClone(cols[i][j])
cloneCol.exportHandled = true;
for (k = 1; k < cols[i][j].colspan; k++) {
cols[i].splice(j, 0, cloneCol)
}
j = j + parseInt(cols[i][j].colspan) - 1
}
} else if (!((cols[i][j].field || cols[i][j].type === 'numbers') && !cols[i][j].hide)) {
curRowUnShowCount++;
}
}
}
var columns = cols[cols.length - 1]; // 获取真实列
// 处理数据
for (i = 0; i < data.length; i++) {
for (j = 0; j < columns.length; j++) {
if ((columns[j].field || columns[j].type === 'numbers') && (customColumns && Array.isArray(customColumns) || !columns[j].hide)) {
data[i][columns[j].key] = data[i][columns[j].field || columns[j]['LAY_TABLE_INDEX']]
}
}
}
// 处理合计行
if (totalRow !== false && myTable.totalRow) {
var obj = {}, totalRows = {};
if (typeof totalRow === 'object' && totalRow.type === 'origin') {
// 通过 dom 解析
for (i = 0; i < columns.length; i++) {
if (columns[i].field) {
obj[columns[i].key] = $tableTotal.find('[data-field="'+columns[i].field+'"]').text().trim()
}
}
data.push(obj);
} else {
// 通过数据解析
for (i = 0; i < columns.length; i++) {
if (columns[i].totalRowText) {
obj[columns[i].key] = columns[i].totalRowText
} else if (columns[i].totalRow) {
totalRows[columns[i].key] = 0
}
}
if (JSON.stringify(totalRows) !== '{}') {
for (i = 0; i < data.length; i++) {
for (var key in totalRows) {
totalRows[key] = (parseFloat(totalRows[key]) + (parseFloat(data[i][key]) || 0)).toFixed(2)
}
}
}
data.push(Object.assign(obj, totalRows));
}
}
if (customColumns && Array.isArray(customColumns)) {
// 自定义表头
var tempCustomColumns = [];
tempArray = {};
mergeArrays = []; // 重置表头合并列
columnsMap[0] = {};
for (i = 0; i < customColumns.length; i++) {
for (j = 0; j < columns.length; j++) {
if (columns[j].field === customColumns[i]) {
columns[j].hide = false
tempCustomColumns.push(columns[j]);
columnsMap[0][columns[j].key] = columns[j];
tempArray[columns[j].key] = $(''+columns[j].title+'
').text()
break;
}
}
}
columns = tempCustomColumns;
data.splice(0, 0, tempArray)
} else {
// 拼接表头数据
for (i = 0; i < cols.length; i++) {
columnsMap[i] = {}
tempArray = {}
for (j = 0; j < cols[i].length; j++) {
columnsMap[i][cols[cols.length - 1][j].key] = cols[i][j];
tempArray[cols[cols.length - 1][j].key] = $(''+cols[i][j].title+'
').text()
}
data.splice(i, 0, tempArray)
}
}
//添加自定义内容
if (finalExcel.add) {
var addTop = finalExcel.add.top,
addBottom = finalExcel.add.bottom,
startPos, endPos, jumpColsNum;
if (addTop && Array.isArray(addTop.data) && addTop.data.length > 0) {
for (i = 0; i < addTop.data.length; i++) {
tempArray = {}, jumpColsNum = 0;
for (j = 0; j < (addTop.data[i].length > columns.length ? addTop.data[i].length : columns.length); j++) {
if ((columns[j].field || columns[j].type === 'numbers') && !columns[j].hide) {
tempArray[columns[j] ? columns[j].key : j + ''] = addTop.data[i][j - jumpColsNum] || ''
} else {
jumpColsNum++
}
}
data.splice(i, 0, tempArray);
}
if (Array.isArray(addTop.heights) && addTop.heights.length > 0) {
for (i = 0; i < addTop.heights.length; i++) {
heightConfig[i] = addTop.heights[i]
}
}
if (Array.isArray(addTop.merge) && addTop.merge.length > 0) {
for (i = 0; i < addTop.merge.length; i++) {
if (addTop.merge[i].length === 2) {
startPos = addTop.merge[i][0].split(',');
endPos = addTop.merge[i][1].split(',');
mergeArrays.push([numberToLetter(startPos[1]) + startPos[0], numberToLetter(endPos[1]) + endPos[0]])
}
}
}
}
if (addBottom && Array.isArray(addBottom.data) && addBottom.data.length > 0) {
for (i = 0; i < addBottom.data.length; i++) {
tempArray = {}, jumpColsNum = 0;
for (j = 0; j < (addBottom.data[i].length > columns.length ? addBottom.data[i].length : columns.length); j++) {
if ((columns[j].field || columns[j].type === 'numbers') && !columns[j].hide) {
tempArray[columns[j] ? columns[j].key : j + ''] = addBottom.data[i][j - jumpColsNum] || ''
} else {
jumpColsNum++
}
}
data.push(tempArray);
}
if (Array.isArray(addBottom.heights) && addBottom.heights.length > 0) {
for (i = 0; i < addBottom.heights.length; i++) {
heightConfig[data.length - addBottom.data.length + i] = addBottom.heights[i]
}
}
if (Array.isArray(addBottom.merge) && addBottom.merge.length > 0) {
for (i = 0; i < addBottom.merge.length; i++) {
if (addBottom.merge[i].length === 2) {
startPos = addBottom.merge[i][0].split(',');
endPos = addBottom.merge[i][1].split(',');
mergeArrays.push([numberToLetter(startPos[1]) + (data.length - addBottom.data.length + parseInt(startPos[0])), numberToLetter(endPos[1]) + (data.length - addBottom.data.length + parseInt(endPos[0]))])
}
}
}
}
}
var index = 0, alignTrans = {'left': 'left', 'center': 'center', 'right': 'right'},
borderTypes = ['top', 'bottom', 'left', 'right'];
for (i = 0; i < columns.length; i++) {
if ((columns[i].field || columns[i].type === 'numbers') && !columns[i].hide) {
if (columns[i].width) {
widths[String.fromCharCode(64 + parseInt(++index))] = columns[i].width
}
showField[columns[i].key] = function (field, line, data, curIndex) {
var bgColor = 'ffffff', color = '000000', family = 'Calibri', size = 12, cellType = 's',
bodyIndex = curIndex - (customColumns ? 1 : cols.length) - tableStartIndex + 1,
border = {
top: {
style: 'thin',
color: {indexed: 64}
},
bottom: {
style: 'thin',
color: {indexed: 64}
},
left: {
style: 'thin',
color: {indexed: 64}
},
right: {
style: 'thin',
color: {indexed: 64}
}
}
if (finalExcel.border) {
for (j = 0; j < borderTypes.length; j++) {
if (finalExcel.border[borderTypes[j]]) {
border[borderTypes[j]].style = finalExcel.border[borderTypes[j]].style || border[borderTypes[j]].style
border[borderTypes[j]].color = handleRgb(finalExcel.border[borderTypes[j]].color) || border[borderTypes[j]].color
} else if (finalExcel.border['color'] || finalExcel.border['style']) {
border[borderTypes[j]].style = finalExcel.border['style'] || border[borderTypes[j]].style
border[borderTypes[j]].color = handleRgb(finalExcel.border['color']) || border[borderTypes[j]].color
}
}
}
if (curIndex < tableStartIndex - 1 || curIndex >= data.length - bottomLength) {
return {
v: line[field] || '',
s: {// s 代表样式
alignment: {
horizontal: 'center',
vertical: 'center'
},
font: {name: family, sz: size, color: {rgb: color}},
fill: {
fgColor: {rgb: bgColor, bgColor: {indexed: 64}}
},
border: border
},
t: cellType
}
} else if (bodyIndex < 0) {
// 头部样式
bgColor = 'C7C7C7';
if (finalExcel.head) {
bgColor = finalExcel.head.bgColor || bgColor;
color = finalExcel.head.color || color;
family = finalExcel.head.family || family;
size = finalExcel.head.size || size;
}
} else {
// 默认全局字体样式
if (finalExcel.font) {
bgColor = finalExcel.font.bgColor || bgColor;
color = finalExcel.font.color || color;
family = finalExcel.font.family || family;
size = finalExcel.font.size || size;
}
// 默认全局边框样式
if (finalExcel.border) {
for (j = 0; j < borderTypes.length; j++) {
if (finalExcel.border[borderTypes[j]]) {
border[borderTypes[j]].style = finalExcel.border[borderTypes[j]].style || border[borderTypes[j]].style
border[borderTypes[j]].color = handleRgb(finalExcel.border[borderTypes[j]].color) || border[borderTypes[j]].color
} else if (finalExcel.border['color'] || finalExcel.border['style']) {
border[borderTypes[j]].style = finalExcel.border['style'] || border[borderTypes[j]].style
border[borderTypes[j]].color = handleRgb(finalExcel.border['color']) || border[borderTypes[j]].color
}
}
}
// 列上配置了自定义样式
if (columnsMap[columnsMap.length - 1][field].excel) {
var colExcel = typeof columnsMap[columnsMap.length - 1][field].excel === 'function' ? columnsMap[columnsMap.length - 1][field].excel.call(this, line, bodyIndex, data.length - cols.length - tableStartIndex + 1 - bottomLength) : columnsMap[columnsMap.length - 1][field].excel
if (colExcel) {
bgColor = colExcel.bgColor || bgColor;
color = colExcel.color || color;
family = colExcel.family || family;
size = colExcel.size || size;
cellType = colExcel.cellType || cellType;
if (colExcel.border) {
for (j = 0; j < borderTypes.length; j++) {
if (colExcel.border[borderTypes[j]]) {
border[borderTypes[j]].style = colExcel.border[borderTypes[j]].style || border[borderTypes[j]].style
border[borderTypes[j]].color = handleRgb(colExcel.border[borderTypes[j]].color) || border[borderTypes[j]].color
} else if (colExcel.border['color'] || colExcel.border['style']) {
border[borderTypes[j]].style = colExcel.border['style'] || border[borderTypes[j]].style
border[borderTypes[j]].color = handleRgb(colExcel.border['color']) || border[borderTypes[j]].color
}
}
}
}
}
}
function handleNull(val) {
if (typeof val === 'undefined' || val === null) {
return ""
}
return val;
}
var value = bodyIndex >= 0 && columnsMap[columnsMap.length - 1][field].templet ?
typeof columnsMap[columnsMap.length - 1][field].templet === 'function' ?
$('' + columnsMap[columnsMap.length - 1][field].templet(line) + '
').find(':input').length === 0 ? $('' + columnsMap[columnsMap.length - 1][field].templet(line) + '
').text() : $tableBody.children('tbody').children('tr[data-index=' + bodyIndex + ']').children('td[data-field="' + field + '"]').find(':input').val() || handleNull(line[field])
: $('' + laytpl($(columnsMap[columnsMap.length - 1][field].templet).html() || String(columnsMap[columnsMap.length - 1][field].templet)).render(line) + '
').find(':input').length === 0 ? $('' + laytpl($(columnsMap[columnsMap.length - 1][field].templet).html() || String(columnsMap[columnsMap.length - 1][field].templet)).render(line) + '
').text() : $tableBody.children('tbody').children('tr[data-index=' + bodyIndex + ']').children('td[data-field="' + field + '"]').find(':input').val() || handleNull(line[field])
: bodyIndex >= 0 && columnsMap[columnsMap.length - 1][field].type === 'numbers' ? bodyIndex + 1 : handleNull(line[field]);
return {
v: value,// v 代表单元格的值
s: {// s 代表样式
alignment: {
horizontal: columnsMap[bodyIndex < -1 ? curIndex - tableStartIndex + 1 : columnsMap.length - 1][field].align ? alignTrans[columnsMap[bodyIndex < -1 ? curIndex - tableStartIndex + 1 : columnsMap.length - 1][field].align] : 'top',
vertical: 'center'
},
font: {name: family, sz: size, color: {rgb: color}},
fill: {
fgColor: {rgb: bgColor, bgColor: {indexed: 64}}
},
border: border
},
t: UNHANDLED_VALUES.indexOf(value) === -1 ? cellType : 's'
};
}
}
}
excel.exportExcel({
sheet1: excel.filterExportData(data, showField)
}, filename, type, {
extend: {
'!cols': excel.makeColConfig(widths, 80),
'!merges': excel.makeMergeConfig(mergeArrays),
'!rows': excel.makeRowConfig(heightConfig, 16)
}
});
layer.close(loading);
// 合成 excel.js 识别的 rgb
function handleRgb(rgb) {
return rgb ? {rgb: rgb} : rgb
}
function numberToLetter(num) {
var result = [];
while (num) {
var t = num % 26;
if (!t) {
t = 26;
--num;
}
// Polyfill 兼容旧浏览器
if (!String.fromCodePoint) (function (stringFromCharCode) {
var fromCodePoint = function (_) {
var codeUnits = [], codeLen = 0, result = "";
for (var index = 0, len = arguments.length; index !== len; ++index) {
var codePoint = +arguments[index];
// correctly handles all cases including `NaN`, `-Infinity`, `+Infinity`
// The surrounding `!(...)` is required to correctly handle `NaN` cases
// The (codePoint>>>0) === codePoint clause handles decimals and negatives
if (!(codePoint < 0x10FFFF && (codePoint >>> 0) === codePoint))
throw RangeError("Invalid code point: " + codePoint);
if (codePoint <= 0xFFFF) { // BMP code point
codeLen = codeUnits.push(codePoint);
} else { // Astral code point; split in surrogate halves
// https://mathiasbynens.be/notes/javascript-encoding#surrogate-formulae
codePoint -= 0x10000;
codeLen = codeUnits.push(
(codePoint >> 10) + 0xD800, // highSurrogate
(codePoint % 0x400) + 0xDC00 // lowSurrogate
);
}
if (codeLen >= 0x3fff) {
result += stringFromCharCode.apply(null, codeUnits);
codeUnits.length = 0;
}
}
return result + stringFromCharCode.apply(null, codeUnits);
};
try { // IE 8 only supports `Object.defineProperty` on DOM elements
Object.defineProperty(String, "fromCodePoint", {
"value": fromCodePoint, "configurable": true, "writable": true
});
} catch (e) {
String.fromCodePoint = fromCodePoint;
}
}(String.fromCharCode));
result.push(String.fromCodePoint(t + 64));
if (!String.fromCodePoint) (function (stringFromCharCode) {
var fromCodePoint = function (_) {
var codeUnits = [], codeLen = 0, result = "";
for (var index = 0, len = arguments.length; index !== len; ++index) {
var codePoint = +arguments[index];
// correctly handles all cases including `NaN`, `-Infinity`, `+Infinity`
// The surrounding `!(...)` is required to correctly handle `NaN` cases
// The (codePoint>>>0) === codePoint clause handles decimals and negatives
if (!(codePoint < 0x10FFFF && (codePoint >>> 0) === codePoint))
throw RangeError("Invalid code point: " + codePoint);
if (codePoint <= 0xFFFF) { // BMP code point
codeLen = codeUnits.push(codePoint);
} else { // Astral code point; split in surrogate halves
// https://mathiasbynens.be/notes/javascript-encoding#surrogate-formulae
codePoint -= 0x10000;
codeLen = codeUnits.push(
(codePoint >> 10) + 0xD800, // highSurrogate
(codePoint % 0x400) + 0xDC00 // lowSurrogate
);
}
if (codeLen >= 0x3fff) {
result += stringFromCharCode.apply(null, codeUnits);
codeUnits.length = 0;
}
}
return result + stringFromCharCode.apply(null, codeUnits);
};
try { // IE 8 only supports `Object.defineProperty` on DOM elements
Object.defineProperty(String, "fromCodePoint", {
"value": fromCodePoint, "configurable": true, "writable": true
});
} catch (e) {
String.fromCodePoint = fromCodePoint;
}
}(String.fromCharCode));
num = ~~(num / 26);
}
return result.reverse().join('');
}
},
startsWith: function (content, str) {
var reg = new RegExp("^" + str);
return content && reg.test(content);
},
// 深度克隆-不丢失方法
deepClone: function (obj) {
var newObj = Array.isArray(obj) ? [] : {}
if (obj && typeof obj === "object") {
for (var key in obj) {
if (obj.hasOwnProperty(key)) {
newObj[key] = (obj && typeof obj[key] === 'object') ? this.deepClone(obj[key]) : obj[key];
}
}
}
return newObj
},
deepStringify: function (obj) {
var JSON_SERIALIZE_FIX = {
PREFIX: "[[JSON_FUN_PREFIX_",
SUFFIX: "_JSON_FUN_SUFFIX]]"
};
return JSON.stringify(obj, function (key, value) {
if (typeof value === 'function') {
return JSON_SERIALIZE_FIX.PREFIX + value.toString() + JSON_SERIALIZE_FIX.SUFFIX;
}
return value;
});
},
/* layui table 中原生的方法 */
getScrollWidth: function (elem) {
var width = 0;
if (elem) {
width = elem.offsetWidth - elem.clientWidth;
} else {
elem = document.createElement('div');
elem.style.width = '100px';
elem.style.height = '100px';
elem.style.overflowY = 'scroll';
document.body.appendChild(elem);
width = elem.offsetWidth - elem.clientWidth;
document.body.removeChild(elem);
}
return width;
}
, getCompleteCols: function (origin) {
var cols = this.deepClone(origin);
var i, j, k, cloneCol;
for (i = 0; i < cols.length; i++) {
for (j = 0; j < cols[i].length; j++) {
if (!cols[i][j].exportHandled) {
if (cols[i][j].rowspan > 1) {
cloneCol = this.deepClone(cols[i][j])
cloneCol.exportHandled = true;
k = i + 1;
while (k < cols.length) {
cols[k].splice(j, 0, cloneCol)
k++
}
}
if (cols[i][j].colspan > 1) {
cloneCol = this.deepClone(cols[i][j])
cloneCol.exportHandled = true;
for (k = 1; k < cols[i][j].colspan; k++) {
cols[i].splice(j, 0, cloneCol)
}
j = j + parseInt(cols[i][j].colspan) - 1
}
}
}
}
return cols[cols.length - 1];
}
, parseTempData: function (item3, content, tplData, text) { //表头数据、原始内容、表体数据、是否只返回文本
var str = item3.templet ? function () {
return typeof item3.templet === 'function'
? item3.templet(tplData)
: laytpl($(item3.templet).html() || String(content)).render(tplData)
}() : content;
return text ? $('' + str + '
').text() : str;
}
, cache: cache
};
// 输出
exports('tableFilter', mod);
});