var page = 1; var totalPages = 0; var param1 = ''; var param2 = ''; var param3 = ''; var param4 = ''; var param5 = ''; // 数据统计及责任人下拉 start getStaticAndSelectAjax(); function getStaticAndSelectAjax(queryParam = {}) { ajaxRequest(RECORD_STATIC_AND_SELECT, "POST", queryParam, function(result) { let data = result.RESULT1; $('#xjrysl').html(result.xjrysl) $('#jrrw').html(result.jrrw) $('#csrw').html(result.csrw) $('#jrwcrw').html(result.jrwcrw) let items = ''; data.forEach(function(item, key) { items += `` }) $('#person_liable_id').append(items); }, function(errorMsg) { alert("请求数据失败!"); }) } // 数据统计及责任人下拉end //列表渲染 getListDataAjax(); //获取列表 ajax请求 function getListDataAjax(queryParam = {}, page = 1) { queryParam.page = page; queryParam.limit = 8; //每页显示条数 queryParam.start = (queryParam.page - 1) * queryParam.limit; ajaxRequest(RECORD_LIST, "POST", queryParam, function(result) { let data = result.RESULT; let items = ''; if (result.totalCount > 0) { data.forEach(function(item, key) { items += "" + "" + "" + item.xh + "" + "" + item.plan_name + "" + "查看" + "" + item.ywcsj + "" + "" + item.zt + "" + "" + item.completion + "" + "" + item.name + "" + "" + item.phone + "" + "" }) $('#dataList').html(items); } else { $('#dataList').html(''); } console.log(result) totalPages = result.totalCount / result.limit; totalPages = Math.ceil(totalPages); $('#totalPage').html(totalPages); //总共多少页 $('#dataTotal').html(result.totalCount); //总共多少条数据 $('#currentPage').val(page); //当前页面 let pageFrom = (page - 1) * result.limit + 1; //开始 let pageTo = result.page * result.limit; //结束 pageTo = pageTo > result.totalCount ? result.totalCount : pageTo; $('#pageFrom').html(pageFrom); $('#pageTo').html(pageTo); // 无数据时 if (!result.totalCount) { $('.pager.has-data').hide() $('.pager.no-data').show() } else { $('.pager.has-data').show() $('.pager.no-data').hide() } if (page < totalPages) { $('#nextPageButton,#lastPageButton').removeClass('disabled'); } else { $('#nextPageButton,#lastPageButton').addClass('disabled'); } if (page === 1) { $('#firstPageButton,#prevPageButton').addClass('disabled'); } else { $('#firstPageButton,#prevPageButton').removeClass('disabled'); } }, function(errorMsg) { alert("请求数据失败!"); }, 3) } //按钮搜索 $('#buttonSearch').on('click', function() { page = 1; getListDataAjax(getSearchParamObj()); param1 = $('#data3a').val() param2 = $('#data3b').val() param3 = $('#zt').val() param4 = $('#plan_name').val() param5 = $('#person_liable_id').val() }) //拼接搜索条件 function getSearchParamObj() { let queryParam = {}; let data3a = $('#data3a').val(); let data3b = $('#data3b').val(); let zt = $('#zt').val(); let plan_name = $('#plan_name').val() let person_liable_id = $('#person_liable_id').val(); queryParam.data3a = data3a; queryParam.data3b = data3b; queryParam.zt = zt; queryParam.plan_name = plan_name; queryParam.person_liable_id = person_liable_id; return queryParam; } //重置表单 $('.reset').click(resetForm); //分页刷新按钮 $('.pg-refresh').click(resetForm); //重置表单 function resetForm() { page = 1; $("#data3a").val(""); $("#data3b").val(""); $("#zt").val("4"); $("#plan_name").val(""); $("#person_liable_id").val(""); getListDataAjax(getSearchParamObj()); param1 = $('#data3a').val() param2 = $('#data3b').val() param3 = $('#zt').val() param4 = $('#plan_name').val() param5 = $('#person_liable_id').val() } //分页操作 $('#firstPageButton').on('click', function() { page = 1; getListDataAjax(getSearchParamObj(), 1); }) $('#lastPageButton').on('click', function() { page = totalPages; getListDataAjax({}, page); }) $('#prevPageButton').on('click', function() { page -= 1; getListDataAjax(getSearchParamObj(), page); }) $('#nextPageButton').on('click', function() { page += 1; getListDataAjax(getSearchParamObj(), page); }) // 导出 start $('.export').click(function() { getDataExport({ "data3a": param1, "data3b": param2, "zt": param3, "plan_name": param4, "person_liable_id": param5 }) }) function getDataExport(queryParam = {}) { // 输出base64编码 const base64 = s => window.btoa(unescape(encodeURIComponent(s))); ajaxRequest(RECORD_EXPORT, "POST", queryParam, function(result) { console.log('result.RESULT') console.log(result.RESULT) let data = result.RESULT; let newData = []; if (data) { data.forEach(function(item, index) { newData.push({ xh: item.xh, plan_name: item.plan_name, ywcsj: item.ywcsj, zt: item.zt, completion: item.completion, name: item.name, phone: item.phone }) }); } let str = '序号任务名称应完成时间当前状态完成情况%相关责任人联系电话'; // 循环遍历,每行加入tr标签,每个单元格加td标签 for (let i = 0; i < newData.length; i++) { str += ''; for (const key in newData[i]) { // 增加\t为了不让表格显示科学计数法或者其他格式 str += `${ newData[i][key] + '\t'}`; } str += ''; } // Worksheet名 const worksheet = 'Sheet1' const uri = 'data:application/vnd.ms-excel;base64,'; // 下载的表格模板数据 const template = ` ${str}
`; // 通过创建a标签实现 const link = document.createElement("a"); link.href = uri + base64(template); // 对下载的文件命名 link.download = "维保记录数据表.xls"; link.click(); }, function(errorMsg) { alert("请求数据失败!"); }, 3) } // 导出 end