/** 表格扩展模块 date:2020-02-29 License By http://easyweb.vip */
layui.define(['layer', 'table', 'laytpl', 'contextMenu'], function (exports) {
var $ = layui.jquery;
var layer = layui.layer;
var table = layui.table;
var laytpl = layui.laytpl;
var contextMenu = layui.contextMenu;
var device = layui.device();
var tbSearchAttr = 'tb-search'; // 前端搜索属性
var tbRefreshAttr = 'tb-refresh'; // 刷新按钮属性
var tbExportAttr = 'tb-export'; // 导出按钮属性
var txFieldPre = 'txField_'; // templte列filed前缀
var tableX = {};
/* 合并相同单元格 */
tableX.merges = function (tableId, indexs, fields, sort) {
if (typeof fields === 'boolean') {
sort = fields;
fields = undefined;
}
var $tb = $('[lay-filter="' + tableId + '"]+.layui-table-view>.layui-table-box>.layui-table-body>table');
var $trs = $tb.find('>tbody>tr');
// 循环合并每一列
for (var i = 0; i < indexs.length; i++) {
if (fields) {
merge(tableId, indexs[i], fields[i]);
} else {
merge(tableId, indexs[i]);
}
}
$trs.find('[del="true"]').remove(); // 移除多余的单元格
// 监听排序事件
if (sort === undefined || sort) {
table.on('sort(' + tableId + ')', function () {
tableX.merges(tableId, indexs, fields, false);
});
}
// 合并一列
function merge(tableId, index, field) {
var data = table.cache[tableId];
if (data.length > 0) {
var lastValue, spanNum = 1;
if (field) {
lastValue = data[0][field];
} else {
lastValue = $trs.eq(0).find('td').eq(index).find('.layui-table-cell').html();
}
for (var i = 1; i < data.length; i++) {
var currentValue;
if (field) {
currentValue = data[i][field];
} else {
currentValue = $trs.eq(i).find('td').eq(index).find('.layui-table-cell').html();
}
if (currentValue === lastValue) {
spanNum++;
if (i === data.length - 1) {
$trs.eq(i - spanNum + 1).find('td').eq(index).attr('rowspan', spanNum);
for (var j = 1; j < spanNum; j++) {
$trs.eq(i - j + 1).find('td').eq(index).attr('del', 'true');
}
}
} else {
$trs.eq(i - spanNum).find('td').eq(index).attr('rowspan', spanNum);
for (var k = 1; k < spanNum; k++) {
$trs.eq(i - k).find('td').eq(index).attr('del', 'true');
}
spanNum = 1;
lastValue = currentValue;
}
}
}
}
};
/* 表格行绑定鼠标右键 */
tableX.bindCtxMenu = function (tableId, items) {
var data = table.cache[tableId];
var elem = '#' + tableId + '+.layui-table-view .layui-table-body tr';
$(elem).bind('contextmenu', function (event) {
var $this = $(this);
$(elem).removeClass('layui-table-click');
$this.addClass('layui-table-click');
var ctxItems;
if (typeof items === 'function') ctxItems = items(data[$this.data('index')], event.currentTarget);
else ctxItems = items;
function getCtxItems(menus) {
if (!menus) return;
var result = [];
for (var i = 0; i < menus.length; i++) {
result.push({
icon: menus[i].icon,
name: menus[i].name,
_click: menus[i].click,
click: function (e, e2) {
var $tr = $(e2.currentTarget);
this._click && this._click(data[$tr.data('index')], e2.currentTarget);
$tr.removeClass('layui-table-click');
},
subs: getCtxItems(menus[i].subs)
});
}
return result;
}
contextMenu.show(getCtxItems(ctxItems), event.clientX, event.clientY, event);
return false;
});
};
/* 导出任意数据 */
tableX.exportData = function (param) {
var cols = param.cols; // 表头
var data = param.data; // 数据
var fileName = param.fileName; // 文件名
var fileType = param.expType; // 类型,xls、csv
var option = param.option; // url方式加载的配置
option || (option = {});
if (device.ie) return layer.msg('不支持ie导出');
// data为url先请求数据
if (typeof data === 'string') {
var loadIndex = layer.load(2);
option.url = data;
tableX.loadUrl(option, function (res) {
layer.close(loadIndex);
param.data = res;
tableX.exportData(param);
});
return;
}
// 列参数补全
for (var i = 0; i < cols.length; i++) {
for (var j = 0; j < cols[i].length; j++) {
if (cols[i][j].type === undefined) {
cols[i][j].type = 'normal';
}
if (cols[i][j].hide === undefined) {
cols[i][j].hide = false;
}
}
}
var titles = [], fields = [], expData = [];
// 获取表头和表头字段名
table.eachCols(undefined, function (i, item) {
if (item.type === 'normal' && !item.hide) {
titles.push(item.title || '');
fields.push(item.field || (txFieldPre + i));
}
}, cols);
// 获取templet后的数据
var fullData = tableX.parseTbData(cols, tableX.deepClone(data), true);
for (var n = 0; n < fullData.length; n++) {
var rowItem = [];
for (var m = 0; m < fields.length; m++) {
var text = fullData[n][fields[m]];
text && (text = text.toString().replace(/,/g, ','));
rowItem.push(text);
}
expData.push(rowItem.join(','));
}
// 创建下载文件的a标签
var alink = document.createElement('a');
var type = ({csv: 'text/csv', xls: 'application/vnd.ms-excel'})[fileType || 'xls'];
var content = encodeURIComponent(titles.join(',') + '\r\n' + expData.join('\r\n'));
alink.href = 'data:' + type + ';charset=utf-8,\ufeff' + content;
alink.download = (fileName || 'table') + '.' + (fileType || 'xls');
document.body.appendChild(alink);
alink.click();
document.body.removeChild(alink);
};
/* 导出表格数据(高级) */
tableX.exportDataX = function (param) {
layui.use('excel', function () {
var excel = layui.excel;
var cols = param.cols; // 表头
var data = param.data; // 数据
var fileName = param.fileName; // 文件名
var fileType = param.expType; // 类型,xls、xlsx
var option = param.option; // url方式加载的配置
option || (option = {});
fileType || (fileType = 'xlsx');
// data为url先请求数据
if (data && typeof data === 'string') {
var loadIndex = layer.load(2);
option.url = data;
tableX.loadUrl(option, function (res) {
layer.close(loadIndex);
param.data = res;
tableX.exportDataX(param);
});
return;
}
// 列参数补全
for (var i = 0; i < cols.length; i++) {
for (var j = 0; j < cols[i].length; j++) {
if (cols[i][j].type === undefined) {
cols[i][j].type = 'normal';
}
if (cols[i][j].hide === undefined) {
cols[i][j].hide = false;
}
}
}
// 获取表头和表头字段名
var titles = {}, fields = [];
table.eachCols(undefined, function (i, item) {
if (item.type === 'normal' && !item.hide) {
var field = item.field || (txFieldPre + i);
fields.push(field);
titles[field] = item.title || '';
}
}, cols);
// 格式化数据
var fullData = tableX.parseTbData(cols, tableX.deepClone(data), true);
var expData = excel.filterExportData(fullData, fields);
expData.unshift(titles);
excel.exportExcel({sheet1: expData}, (fileName || 'table') + '.' + fileType, fileType);
});
};
/* 后端导出数据拼接参数 */
tableX.exportDataBack = function (url, where, method) {
where || (where = {});
if (!method || method.toString().toLowerCase() === 'get') {
var param = '';
for (var f in where) {
if (!param) {
param = ('?' + f + '=' + where[f]);
} else {
param += ('&' + f + '=' + where[f]);
}
}
window.open(url + param);
} else {
var htmlStr = '
';
$('#exportFrame').remove();
$('body').append('');
var eFrame = document.getElementById('exportFrame');
var eWindow = eFrame.contentWindow;
var eDocument = eWindow.document;
eWindow.focus();
eDocument.open();
eDocument.write(htmlStr);
eDocument.close();
eDocument.getElementById('eFrom').submit();
}
};
/* 渲染表格,后端排序 */
tableX.render = function (param) {
var tableId = $(param.elem).attr('lay-filter');
param.autoSort = false; // 关闭默认排序
var insTb = table.render(param); // 渲染表格
// 排序监听
table.on('sort(' + tableId + ')', function (obj) {
var sortField = obj.field, sortType = obj.type; // 排序字段、类型
var sortWhere = $.extend(param.where, {sort: sortField, order: sortType});
insTb.reload({where: sortWhere, page: {curr: 1}});
});
return insTb;
};
/* 渲染表格,前端分页 */
tableX.renderFront = function (param) {
var insTb, tableId = $(param.elem).attr('lay-filter');
param.autoSort = false; // 关闭默认排序
// 没有field的templet列补上,因为排序必须有filed字段,否则点击排序会报错
for (var i = 0; i < param.cols.length; i++) {
for (var j = 0; j < param.cols[i].length; j++) {
if (param.cols[i][j].templet && !param.cols[i][j].field) {
param.cols[i][j].field = txFieldPre + i + '_' + j;
}
}
}
if (param.url) { // url方式
var xParam = tableX.deepClone(param);
xParam.data = [];
xParam.url = undefined;
insTb = table.render(xParam); // 先渲染表格结构
// 提供刷新方法
insTb.reloadUrl = function (p) {
var reParam = tableX.deepClone(param);
p && (reParam = $.extend(reParam, p));
$(param.elem + '+.layui-table-view>.layui-table-box').append('
');
// 获取url数据
tableX.loadUrl(reParam, function (data) {
insTb.reload({url: '', data: data, page: {curr: 1}});
tableX.putTbData(tableId, tableX.parseTbData(reParam.cols, data)); // 缓存数据
$('input[' + tbSearchAttr + '="' + tableId + '"]').val(''); // 清空搜索输入框
window.tbX.cacheSearch[tableId] = undefined; // 重置搜索结果
});
};
insTb.reloadUrl();
} else {
insTb = table.render(param); // 渲染表格
// 提供刷新的方法
insTb.reloadData = function (p) {
insTb.reload(p);
tableX.parseTbData(param.cols, p.data); // 解析temple列
tableX.putTbData(tableId, p.data);
$('input[' + tbSearchAttr + '="' + tableId + '"]').val(''); // 清空搜索输入框
window.tbX.cacheSearch[tableId] = undefined; // 重置搜索结果
};
tableX.putTbData(tableId, tableX.parseTbData(param.cols, param.data)); // 缓存数据
}
tableX.renderAllTool(insTb); // 渲染工具组件
return insTb;
};
/* 加载表格数据 */
tableX.loadUrl = function (options, callback) {
// 响应数据的自定义格式
options.response = $.extend({
statusName: 'code',
statusCode: 0,
msgName: 'msg',
dataName: 'data',
countName: 'count'
}, options.response);
var response = options.response;
var where = options.where; // 参数
if (options.contentType && options.contentType.indexOf('application/json') === 0) {
where = JSON.stringify(where); // 提交 json 格式
}
$.ajax({
type: options.method || 'get',
url: options.url,
contentType: options.contentType,
data: where,
dataType: 'json',
headers: options.headers || {},
success: function (res) {
// 如果有数据解析的回调,则获得其返回的数据
if (typeof options.parseData === 'function') {
res = options.parseData(res) || res;
}
// 检查数据格式是否符合规范
if (res[response.statusName] != response.statusCode) {
var msgText = res[response.msgName] || ('返回的数据不符合规范,正确的成功状态码 (' + response.statusName + ') 应为:' + response.statusCode);
layer.msg(msgText, {icon: 2});
} else {
callback(res[response.dataName]);
}
},
error: function (e, m) {
layer.msg('数据接口请求异常:' + m, {icon: 2});
}
});
};
/* 解析数据表格templet列 */
tableX.parseTbData = function (cols, dataList, overwrite) {
var templets = []; // 需要解析的列
table.eachCols(undefined, function (i, item) {
if (item.templet) {
var one = {field: ((item.field && (overwrite || item.field.indexOf(txFieldPre) === 0)) ? item.field : ('txField_' + i))};
if (typeof item.templet === 'string') {
one.templet = function (d) { // templet列使用laytpl渲染
var rsStr = undefined;
laytpl($(item.templet).html()).render(d, function (html) {
rsStr = html;
});
return rsStr;
}
} else {
one.templet = item.templet;
}
templets.push(one);
}
}, cols);
for (var i = 0; i < dataList.length; i++) {
var current = dataList[i];
for (var j = 0; j < templets.length; j++) {
var htmlStr = '' + templets[j].templet(current) + '
';
current[templets[j].field] = $(htmlStr).not('.export-hide').text().replace(/(^\s*)|(\s*$)/g, ''); // 去除前后空格
}
}
return dataList;
};
/* 缓存表格的数据 */
tableX.putTbData = function (tableId, dataList) {
window.tbX.cache[tableId] = dataList;
};
/* 获取表格缓存的数据 */
tableX.getTbData = function (tableId) {
var dataList = window.tbX.cache[tableId];
return tableX.deepClone(dataList || table.cache[tableId]);
};
/* 搜索数据 */
tableX.filterData = function (dataList, searchName, searchValue) {
var newList = [], sfs;
for (var i = 0; i < dataList.length; i++) {
var obj = dataList[i];
if (!sfs) { // 搜索的字段
if (!searchName) {
sfs = [];
for (var f in obj) {
if (!obj.hasOwnProperty(f)) continue;
sfs.push(f);
}
} else {
sfs = searchName.split(',');
}
}
for (var j = 0; j < sfs.length; j++) {
if (tableX.isContains(obj[sfs[j]], searchValue)) {
newList.push(obj);
break;
}
}
}
return newList;
};
/* 字符串是否包含 */
tableX.isContains = function (str1, str2) {
str1 || (str1 = '');
str2 || (str2 = '');
str1 = str1.toString().toLowerCase();
str2 = str2.toString().toLowerCase();
if (str1 === str2 || str1.indexOf(str2) >= 0) {
return true;
}
return false;
};
/* 渲染所有组件 */
tableX.renderAllTool = function (insTb) {
renderRefresh(insTb); // 刷新
renderFrontSort(insTb); // 排序
renderFrontSearch(insTb); // 搜索
renderExport(insTb); // 导出
};
/* 深度克隆对象 */
tableX.deepClone = function (obj) {
var result;
var oClass = tableX.isClass(obj);
if (oClass === 'Object') {
result = {};
} else if (oClass === 'Array') {
result = [];
} else {
return obj;
}
for (var key in obj) {
if (!obj.hasOwnProperty(key)) continue;
var copy = obj[key];
if (tableX.isClass(copy) === 'Object') {
result[key] = arguments.callee(copy);//递归调用
} else if (tableX.isClass(copy) === 'Array') {
result[key] = arguments.callee(copy);
} else {
result[key] = obj[key];
}
}
return result;
};
/* 获取变量类型 */
tableX.isClass = function (o) {
if (o === null)
return 'Null';
if (o === undefined)
return 'Undefined';
return Object.prototype.toString.call(o).slice(8, -1);
};
// 创建数据缓存对象
window.tbX || (window.tbX = {});
window.tbX.cache || (window.tbX.cache = {});
window.tbX.cacheSearch || (window.tbX.cacheSearch = {});
// 前端搜索
var renderFrontSearch = function (insTb) {
var tableId = insTb.config.id, $input = $('input[' + tbSearchAttr + '="' + tableId + '"]');
if (!($input && $input.length > 0)) {
return;
}
if (!$input.attr('placeholder')) {
$input.attr('placeholder', '输入关键字按回车键搜索');
}
$input.off('keydown').on('keydown', function (event) {
if (event.keyCode !== 13) {
return;
}
var searchName = $input.attr('name'); // 搜索的字段名,用逗号分隔
var searchValue = $input.val().replace(/(^\s*)|(\s*$)/g, ''); // 搜索关键字
var loadIndex = layer.msg('搜索中..', {icon: 16, shade: 0.01, time: 0});
var dataList = tableX.getTbData(tableId);
var newDataList = tableX.filterData(dataList, searchName, searchValue);
window.tbX.cacheSearch[tableId] = newDataList; // 缓存搜索后的数据用于排序
insTb.reload({url: '', data: newDataList, page: {curr: 1}});
layer.close(loadIndex);
});
};
// 前端排序
var renderFrontSort = function (insTb) {
var tableId = insTb.config.id;
table.on('sort(' + tableId + ')', function (obj) {
var sortField = obj.field, sortType = obj.type; // 排序字段、类型
var loadIndex = layer.msg('加载中..', {icon: 16, shade: 0.01, time: 0});
var dataList = window.tbX.cacheSearch[tableId]; // 表格搜索后的数据
dataList || (dataList = tableX.getTbData(tableId));
if (sortType) {
dataList = dataList.sort(function (o1, o2) {
var o1Str = o1[sortField], o2Str = o2[sortField];
if (sortType === 'asc') { // 升序
return (o1Str === o2Str) ? 0 : ((o1Str < o2Str) ? -1 : 1);
} else { // 降序
return (o1Str === o2Str) ? 0 : ((o1Str < o2Str) ? 1 : -1);
}
});
}
insTb.reload({initSort: obj, url: '', data: dataList, page: {curr: 1}});
layer.close(loadIndex);
});
};
// 表格刷新按鈕
var renderRefresh = function (insTb) {
$('[' + tbRefreshAttr + '="' + insTb.config.id + '"]').off('click').on('click', function () {
if (insTb.reloadUrl) {
insTb.reloadUrl();
} else {
insTb.reload({page: {curr: 1}});
}
});
};
// 渲染导出按钮
var renderExport = function (insTb) {
var tableId = insTb.config.id;
$('[' + tbExportAttr + '="' + tableId + '"]').off('click').on('click', function (event) {
if ($(this).find('.tbx-dropdown-menu').length > 0) {
return;
}
if (event !== void 0) {
event.preventDefault();
event.stopPropagation();
}
var htmlStr = '';
$(this).append(htmlStr);
$(this).addClass('tbx-dropdown-btn');
$(this).parent().css('position', 'relative');
$(this).parent().css('z-index', '9998');
$('.tbx-dropdown-menu').off('click').on('click', '.tbx-dropdown-menu-item', function (event) {
var type = $(this).data('type');
if (type === 'check') {
var checkRows = table.checkStatus(tableId);
if (checkRows.data.length === 0) {
layer.msg('请选择要导出的数据', {icon: 2});
} else {
$('.tbx-dropdown-menu').remove();
tableX.exportData({
fileName: insTb.config.title,
cols: insTb.config.cols,
data: checkRows.data
});
}
} else if (type === 'current') {
tableX.exportData({
fileName: insTb.config.title,
cols: insTb.config.cols,
data: table.cache[tableId]
});
} else if (type === 'all') {
tableX.exportData({
fileName: insTb.config.title,
cols: insTb.config.cols,
data: tableX.getTbData(tableId)
});
}
if (event !== void 0) {
event.preventDefault();
event.stopPropagation();
}
});
});
$(document).off('click.tbxDropHide').on('click.tbxDropHide', function () {
$('.tbx-dropdown-menu').remove();
});
};
/* css样式 */
var getCommonCss = function () {
var cssStr = '.tbx-dropdown-btn {';
cssStr += ' position: relative;';
cssStr += ' }';
cssStr += ' .tbx-dropdown-btn:hover {';
cssStr += ' opacity: 1';
cssStr += ' }';
cssStr += ' .tbx-dropdown-menu {';
cssStr += ' position: absolute;';
cssStr += ' top: 100%;';
cssStr += ' right: 0;';
cssStr += ' padding: 5px 0;';
cssStr += ' margin: 5px 0 0 0;';
cssStr += ' overflow: visible;';
cssStr += ' min-width: 110px;';
cssStr += ' background: #fff;';
cssStr += ' border-radius: 2px;';
cssStr += ' box-shadow: 0 2px 4px rgba(0, 0, 0, .12);';
cssStr += ' border: 1px solid #d2d2d2;';
cssStr += ' z-index: 9998;';
cssStr += ' cursor: default;';
cssStr += ' }';
cssStr += ' .tbx-dropdown-menu .tbx-dropdown-menu-item {';
cssStr += ' display: block;';
cssStr += ' color: #555;';
cssStr += ' font-size: 14px;';
cssStr += ' padding: 10px 15px;';
cssStr += ' text-decoration: none;';
cssStr += ' white-space: nowrap;';
cssStr += ' cursor: pointer;';
cssStr += ' user-select: none;';
cssStr += ' line-height: normal;';
cssStr += ' }';
cssStr += ' .tbx-dropdown-menu .tbx-dropdown-menu-item:hover {';
cssStr += ' background-color: #eeeeee;';
cssStr += ' }';
cssStr += ' .export-show {';
cssStr += ' display: none;';
cssStr += ' }';
return cssStr;
};
$('head').append('');
exports("tableX", tableX);
});