layui.use(['layer', 'form', 'table', 'ztree', 'laydate', 'admin', 'ax','upload'], function () { var layer = layui.layer; var form = layui.form; var table = layui.table; var $ZTree = layui.ztree; var $ax = layui.ax; var laydate = layui.laydate; var admin = layui.admin; var upload = layui.upload; /** * 系统管理--用户管理 */ var MgrUser = { tableId: "userTable", //表格id condition: { name: "", deptId: "", timeLimit: "" } }; /** * 初始化表格的列 */ MgrUser.initColumn = function () { return [[ {type: 'checkbox'}, {field: 'userId', hide: true, sort: true, title: '用户id'}, {field: 'account', sort: true, title: '账号'}, {field: 'name', sort: true, title: '姓名'}, {field: 'sexName', sort: true, title: '性别'}, {field: 'roleName', sort: true, title: '角色'}, {field: 'deptName', sort: true, title: '部门'}, {field: 'email', sort: true, title: '邮箱'}, {field: 'phone', sort: true, title: '电话'}, {field: 'createTime', sort: true, title: '创建时间'}, {field: 'status', sort: true, templet: '#statusTpl', title: '状态'} ]]; }; /** * 导出excel按钮 */ MgrUser.exportExcel = function () { var checkRows = table.checkStatus(MgrUser.tableId); if (checkRows.data.length === 0) { Feng.error("请选择要导出的数据"); } else { table.exportFile(tableResult.config.id, checkRows.data, 'xls'); } }; // 渲染表格 var tableResult = table.render({ elem: '#' + MgrUser.tableId, url: Feng.ctxPath + '/mgr/list', page: true, height: "full-98", cellMinWidth: 100, cols: MgrUser.initColumn() }); //渲染时间选择框 laydate.render({ elem: '#timeLimit', range: true, max: Feng.currentDate() }); //执行实例 var uploadInst = upload.render({ elem: '#btnExp' , url: '/excel/uploadExcel' ,accept: 'file' , done: function (res) { table.reload(MgrUser.tableId, {url: Feng.ctxPath + "/excel/getUploadData"}); } , error: function () { //请求异常回调 } }); });