1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
| 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 () {
| //请求异常回调
| }
| });
|
| });
|
|