var example = null; var pers = null; layui.use(['layer'], function () { var layer = layui.layer; pers = checkPermission(); $("#searchBt").click(function () { example.ajax.reload(); }); $("#saveZipButton").click(function(){ importExcel(); }); init(); $("#exportBt").click(function () { var token = localStorage.getItem("token"); var loadingMsg = layer.msg('下载中,请稍候...', {icon: 16, scrollbar: false, time: 0}); var url = ctxPath + "/CommonProblem/exportCommonProblem?keyWord=" + $("#keyWord").val().trim()+ "&token=" + token; var xhr = new XMLHttpRequest(); xhr.open("get", url, true); xhr.responseType = "blob"; // 转换流 xhr.onload = function () { layer.close(loadingMsg); if (this.status === 200) { var blob = this.response; var a = document.createElement("a"); var url = window.URL.createObjectURL(blob); a.href = url; a.download = "农民工实名制管理平台使用常见问题汇总.xlsx"; // 文件名 }else { layer.msg('导出发生异常,请稍后重试', {icon: 16, scrollbar: false, time: 2000}); } a.click() window.URL.revokeObjectURL(url) }; xhr.send(); }); }); function init() { example = $('#dt-table').DataTable({ "searching": false, "processing": true, //加载数据时显示进度状态 "serverSide": true, "pagingType": "full_numbers", //首页|尾页saveZipButton "language": { "url": ctxPath + "/js/plugin/datatables/Chinese.lang" }, "ajax": { "url": ctxPath + "/CommonProblem", "type": "get", "data": function (d) { d.keyWord = $("#keyWord").val(); }, "error": function (xhr, textStatus, errorThrown) { var msg = xhr.responseText; var response = JSON.parse(msg); var code = response.code; var message = response.message; if (code == 400) { layer.msg(message); } else if (code == 401) { localStorage.removeItem("token"); layer.msg("token过期,请先登录", {shift: -1, time: 1000}, function () { location.href = ctxPath + '/login.html'; }); } else if (code == 403) { console.log("未授权:" + message); layer.msg('未授权'); } else if (code == 500) { console.log('系统错误:' + message); } } }, "lengthMenu": [ [10, 20, 50], [10, 20, 50] ], // 设置每页显示数据量选项 "drawCallback": function() { // alert( '表格重绘了' ); var thisDataTable = $('#dt-table').DataTable(); $(".pagination").append("
  • " + "" + "确认
  • "); //点击按钮跳转指定页数 $('#dataTable-btn').click(function (e) { if ($("#changePage").val() && $("#changePage").val() > 0) { var redirectpage = $("#changePage").val() - 1; } else { var redirectpage = 0; } thisDataTable.page(redirectpage).draw( 'page' ); }); //敲击回车键跳转指定页数 $("#changePage").keypress(function (e) { if(event.keyCode==13){ if ($("#changePage").val() && $("#changePage").val() > 0) { var redirectpage = $("#changePage").val() - 1; } else { var redirectpage = 0; } thisDataTable.page(redirectpage).draw( 'page' ); } }); }, "dom": "<'dt-toolbar'r>t<'dt-toolbar-footer'<'col-sm-4 col-xs-4 hidden-xs'i><'col-xs-8 col-sm-8' p v>><'dt-table-length'l>", "columns": [ { width: '40px', "orderable": false, data: function (row, type, set, meta) { var c = meta.settings._iDisplayStart + meta.row + 1; return c; } }, {"data": "subsystem","orderable": false,"defaultContent": ""},//子系统 {"data": "module", "orderable": false,"defaultContent": ""},//模块 {"data": "problemDescription", "orderable": false, "defaultContent": ""},//问题描述 {"data": "solution","orderable": false,"defaultContent": ""},//解决办法 {"data": "remark","orderable": false,"defaultContent": ""},//备注 { "data": "", "defaultContent": "", "orderable": false, "render": function (data, type, row) { var id = row['id']; var html = ''; html += buttonEdits(id, "sys:Sub:update", pers); //修改 html += buttonDel(id,"", pers); // 删除 return html; } }, ], }); } /** * 新增页面 * */ function addCommonProblem() { var height = '525px'; var width = '925px'; var index = layer.open({ title: ['新增','color:#3B70A1;background-color:#E8ECEB;font-size:20px'], type: 2, content: 'commonProblemForm.html', area: [width, height], maxmin: false, btn: ['确定', '关闭'], success:function(layero,index){ var myIframe = window[layero.find('iframe')[0]['name']]; /*myIframe.getCompanys(); //aaa()为子页面的方法*/ }, yes: function (index, layero) { // 获取弹出层中的form表单元素 var formSubmit = layer.getChildFrame('form', index); var submited = formSubmit.find('button')[0]; // 触发点击事件,会对表单进行验证,验证成功则提交表单,失败则返回错误信息 submited.click(); // example.ajax.reload(); // 刷新页面 }, btn2: function (index, layero) { } }); } // 编辑按钮 function buttonEdits(id, permission, pers) { if (permission != "") { if ($.inArray(permission, pers) < 0) { return ""; } } var btn = $(""); return btn.prop("outerHTML"); } /** * 编辑页面 */ function edit(id) { $.ajax({ type: 'POST', contentType: "application/x-www-form-urlencoded", url: ctxPath + '/CommonProblem/getCommonProblemById', data: {"id": id}, dataType: 'json', success: function (data) { var height = '85%'; var width = '85%'; var index = layer.open({ title: ['修改', 'color:#3B70A1;background-color:#E8ECEB;font-size:20px'], type: 2, content: 'commonProblemForm.html', area: [width, height], maxmin: false, btn: ['确定', '关闭'], success: function (layero, index) { var myIframe = window[layero.find('iframe')[0]['name']]; var fnc = myIframe.setData(data); //aaa()为子页面的方法 }, yes: function (index, layero) { // 获取弹出层中的form表单元素 var formSubmit = layer.getChildFrame('form', index); var submited = formSubmit.find('button')[0]; // 触发点击事件,会对表单进行验证,验证成功则提交表单,失败则返回错误信息 submited.click(); // example.ajax.reload(); // 刷新页面 }, btn2: function (index, layero) { } }); } }) } // 删除按钮 function buttonDel(id,permission, pers) { if (permission != "") { if ($.inArray(permission, pers) < 0) { return ""; } } var btn = $(""); return btn.prop("outerHTML"); } //删除 function del(id){ layer.confirm("您确定要删除此条数据吗?", function () { var form = {"id" : id}; $.ajax({ type: 'post', url: ctxPath + '/CommonProblem/delCommonProblem', contentType: "application/json; charset=utf-8", data: JSON.stringify(form), dataType: 'json', success: function (data) { if (data.resMsg == "删除成功") { layer.msg('删除成功', {icon: 1, time: 3000}); example.ajax.reload(null, false); // 刷新页面 } else { layer.msg(data.resMsg, {icon: 2, time: 3000}); example.ajax.reload(null, false); // 刷新页面 } } }) }) } //导入excel文件 function importExcel(){ var formData = new FormData($('form')[0]); var name = $("#articleImageFile").val(); if(name==null|| name == "") { return; } if(!(name.endsWith(".xls") || name.endsWith(".xlsx") || name.endsWith(".xlsm"))) { layer.msg("请上传正确的Excel表格!"); $("#articleImageFile").val(""); return; } formData.append("file", $("#articleImageFile")[0].files[0]); var idx = layer.msg('正在提交数据,请稍等...', { icon: 16 ,shade: 0.01 ,time:'-1' }); $.ajax({ url : ctxPath + "/CommonProblem/importExcel", type : 'POST', async : false, data : formData, timeout:20000, // 告诉jQuery不要去处理发送的数据 processData : false, // 告诉jQuery不要去设置Content-Type请求头 contentType : false, success : function(data) { layer.close(idx); if(data.indexOf("导入成功") !=-1){ layer.alert(data, {icon: 1}); }else if(data.indexOf("导入失败") !=-1){ console.log(data) layer.alert(data, {icon: 2}); } example.ajax.reload(null, false); // 刷新页面 }, error:function(XMLHttpRequest, textStatus, errorThrown) { console.log(JSON.stringify(errorThrown)); layer.close(idx); } }); $("#articleImageFile").val(""); } function downCommonProblem(){ window.location.href = ctxPath + "/download/download?filename=湖南农民工实名制管理平台使用常见问题汇总.xlsx"; }