'use strict'; var app = angular.module('app', [ 'angularUtils.directives.dirPagination' ]); app.controller("listCtrl", ["$scope", "$http", "$timeout", "$interval", function ($scope, $http, $timeout, $interval) { var self = this; var s4 = new SM4Util(); self.userId = $.cookie("GlWorkPlatform-userid"); self.userName = $.cookie("GlWorkPlatform-chineseName"); self.get_AccessToken = localStorage.getItem("GlWorkPlatform-AccessToken"); self.deviceType = localStorage.getItem("tjJxtGoldenlinkWork-deviceType"); self.get_lastReturnPageno = sp.getUrlName("lastReturnPageno"); self.get_type = sp.getUrlName("type"); self.params = sp.getUrlName("params"); var postCfg = { headers: { 'Content-Type': 'application/json', 'Authorization': "Bearer " + self.get_AccessToken } } self.type = self.get_type != "" ? self.get_type : "todo"; self.Url = getUrl(self.type); self.CrossPage = window.parent.CrossPage; self.loading = false; self.search = null//JSON.parse($.cookie("GlWorkPlatform-gongkaizhu")); self.noDataTip = 1;//没有数据时赋变量为0,先默认为1 self.pageno = 1; self.total_count = 0; self.itemsPerPage = 10; self.pageOptions = [10, 20, 30, 40, 50, 100, 300, 500]; self.ordercondition = []; self.getData = function (pageno) { if (self.search == null) { self.search = { BT: "", LAIYUAN: "", BIANHAO: "", GKSXLB: "", SQGKNRMS: "", USER: "", LXDH: "", DATE1: "", DATE2: "", SJBJRQ1: "", SJBJRQ2: "" } } var querycondition = []; var columnscondition = [ { COLID: "LAIYUAN", COLUMNS: "SX_SZJWYSQGKXXCBD.LAIYUAN" }, { COLID: "BIANHAO", COLUMNS: "SX_SZJWYSQGKXXCBD.BIANHAO" }, { COLID: "GKSXLB", COLUMNS: "SX_SZJWYSQGKXXCBD.GKSXLB" }, { COLID: "SQRQ", COLUMNS: "SX_SZJWYSQGKXXCBD.TO_CHAR(SQRQ)" }, { COLID: "LXDH", COLUMNS: "SX_SZJWYSQGKXXCBD.LXDH" }, { COLID: "SJBJRQ", COLUMNS: "SX_SZJWYSQGKXXCBD.TO_CHAR(SJBJRQ)" }, { COLID: "SQGKNRMS", COLUMNS: "SX_SZJWYSQGKXXCBD.SQGKNRMS" } ] if (self.type == 'todo') { querycondition.push({ "CKIND": "SQLWORD", "TABLEID": "", "COLID": "", "VALUEA": "ROUTEINFOID not in (SELECT ROUTEINFOID from SYS_ROUTE_INFO_UNCANCEL_VIEW)", "VALUEB": "" }) } if (self.search.BT != "") { querycondition.push({ "CKIND": "VARCHAR", "TABLEID": "SYS_ROUTE_VIEW", "COLID": "TITLE", "VALUEA": self.search.BT, "VALUEB": "" }) } if (self.search.LAIYUAN != "") { querycondition.push({ "CKIND": "VARLIST", "TABLEID": "CODETABLE", "COLID": "LAIYUAN", "VALUEA": self.search.LAIYUAN.join(","), "VALUEB": "" }) } if (self.search.BIANHAO != "") { querycondition.push({ "CKIND": "VARCHAR", "TABLEID": "CODETABLE", "COLID": "BIANHAO", "VALUEA": self.search.BIANHAO, "VALUEB": "" }) } if (self.search.LXDH != "") { querycondition.push({ "CKIND": "VARCHAR", "TABLEID": "CODETABLE", "COLID": "LXDH", "VALUEA": self.search.LXDH, "VALUEB": "" }) } if (self.search.GKSXLB != "") { querycondition.push({ "CKIND": "VARLIST", "TABLEID": "CODETABLE", "COLID": "GKSXLB", "VALUEA": self.search.GKSXLB.join(","), "VALUEB": "" }) } if (self.search.SQGKNRMS != "") { querycondition.push({ "CKIND": "VARCHAR", "TABLEID": "CODETABLE", "COLID": "SQGKNRMS", "VALUEA": self.search.SQGKNRMS, "VALUEB": "" }) } if (self.params != "") { querycondition.push({ "CKIND": "VARLIST", "TABLEID": "SYS_ROUTE", "COLID": "ROUTEID", "VALUEA": self.params, "VALUEB": "" }) } if (self.search.DATE1 != "" && self.search.DATE2 != "") { //querycondition.push({ "CKIND": "DATETIME", "TABLEID": "SYS_ROUTE_VIEW", "COLID": "RECEIVEDATE", "VALUEA": self.search.DATE1, "VALUEB": self.search.DATE2 }) querycondition.push({ "CKIND": "DATETIME", "TABLEID": "CODETABLE", "COLID": "SQRQ", "VALUEA": self.search.DATE1, "VALUEB": self.search.DATE2 }) } else if (self.search.DATE1 != "" && self.search.DATE2 == "") { //querycondition.push({ "CKIND": "DATETIME", "TABLEID": "SYS_ROUTE_VIEW", "COLID": "RECEIVEDATE", "VALUEA": self.search.DATE1, "VALUEB": "" }) querycondition.push({ "CKIND": "DATETIME", "TABLEID": "CODETABLE", "COLID": "SQRQ", "VALUEA": self.search.DATE1, "VALUEB": "" }) } else if (self.search.DATE1 == "" && self.search.DATE2 != "") { //querycondition.push({ "CKIND": "DATETIME", "TABLEID": "SYS_ROUTE_VIEW", "COLID": "RECEIVEDATE", "VALUEA": "", "VALUEB": self.search.DATE2 }) querycondition.push({ "CKIND": "DATETIME", "TABLEID": "CODETABLE", "COLID": "SQRQ", "VALUEA": "", "VALUEB": self.search.DATE2 }) } if (self.search.SJBJRQ1 != "" && self.search.SJBJRQ2 != "") { querycondition.push({ "CKIND": "DATETIME", "TABLEID": "CODETABLE", "COLID": "SJBJRQ", "VALUEA": self.search.SJBJRQ1, "VALUEB": self.search.SJBJRQ2 }) } else if (self.search.SJBJRQ1 != "" && self.search.SJBJRQ2 == "") { querycondition.push({ "CKIND": "DATETIME", "TABLEID": "CODETABLE", "COLID": "SJBJRQ", "VALUEA": self.search.SJBJRQ1, "VALUEB": "" }) } else if (self.search.SJBJRQ1 == "" && self.search.SJBJRQ2 != "") { querycondition.push({ "CKIND": "DATETIME", "TABLEID": "CODETABLE", "COLID": "SJBJRQ", "VALUEA": "", "VALUEB": self.search.SJBJRQ }) } console.log(querycondition) self.list = []; self.total_count = 0; self.loading = true; self.pageno = pageno; $scope.__default__currentPage = self.pageno; //设置页面样式在第几页 var data = { flowid: "AA51", userid: self.userId, pageno: self.pageno, pagesize: self.itemsPerPage, columnscondition: JSON.stringify(columnscondition), querycondition: JSON.stringify(querycondition), ordercondition: self.ordercondition.length == 0 ? "" : JSON.stringify(self.ordercondition) } if (self.type =='yifa'){ data.creatormark = true } if (self.type =='daifa'){ data.creatormark = true } //$http.post(apiurljs.login + "g2work/routeinfo/" + self.Url, { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg) $http.post(apiurljs.login + "g2work/routeinfo/" + self.Url, data, postCfg) .success(function (obj) { var res = obj; //var res = strToJson(s4.decryptData_CBC(obj.data)); self.loading = false; if (res.data == null || res.data == undefined || res.data == "") { self.noDataTip = 0; if (self.params != "") { self.params = ""; self.getData(1) } } else { self.noDataTip = 1; self.list = res.data; self.total_count = res.totalCount; $.each(self.list, function (index, item) { self.LAIYUAN.forEach(function (item1) { if (item.LAIYUAN == item1.CODE) item.LAIYUAN = item1.CNAME; }) self.GKSXLB.forEach(function (item1) { if (item.GKSXLB == item1.CODE) item.GKSXLB = item1.CNAME; }) item.SQRQ = sp.format(item.SQRQ); item.SJBJRQ = sp.format(item.SJBJRQ) if (item.USERS) { item.USERSNAME = item.USERS.map(function (item1) { return item1.USERNAME }).join(","); item.ENDNODESNAME = item.USERS.map(function (item1) { return item1.ENDNODENAME }).join(","); } if (item.FILEN != "") { item.FILEN = item.FILEN.indexOf("dotype") > -1 ? item.FILEN.replace("dotype=1", "dotype=" + getDoType(self.type)) + "&type=" + self.type + "&lastReturnPageno=" + self.pageno : item.FILEN + "&dotype=" + getDoType(self.type) + "&type=" + self.type + "&lastReturnPageno=" + self.pageno; } else { item.FILEN = "#"; } if (self.type == "finish") { item.RECEIVEDATE = item.FINISHEDDATE; } }) } if (self.CrossPage.type == 0) { self.journalRecord(self.CrossPage.ctime, sp.getLocalDate1(), "", "接入日志", window.location.pathname) } }) } self.btnRecall = function (routeid, kind) { var data = { routeid: routeid, kind: kind, userid: self.userId } $http.post(apiurljs.login + "g2work/routeinfo/queryDataRecallDoneByRouteid", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg) .success(function (obj) { var res = strToJson(s4.decryptData_CBC(obj.data)); var dialogHead = "温馨提示×"; var dialogBody = "
" + res.data.REMARK + "
"; var dialogFoot = "
"; $('.sp-dialog').html(dialogHead + dialogBody + dialogFoot); sp.openCenter(".sp-dialog"); ///取消按钮 $('.sp-closeDialog').click(function (event) { sp.closeCenter(".sp-dialog"); event.preventDefault(); event.stopPropagation(); }); //post消息的id $("#delDataTrue").click(function () { $http.post(apiurljs.login + "g2work/routeinfo/recallDoneByRouteid", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg) .success(function (obj) { var res = strToJson(s4.decryptData_CBC(obj.data)); sp.dialoghide() if (res.success == true) { self.getData(self.pageno) } else { sp.dialog(res.message) } }) }); }) } self.getLAIYUAN = function () { var data = { ckey: "CODE_LAIYUAN", routeinfoid: self.routeinfoid } $http.post(apiurljs.login + "g2app/abase/queryDataCode", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg) .success(function (obj) { var res = strToJson(s4.decryptData_CBC(obj.data)); self.LAIYUAN = res.data.CODE_LAIYUAN.filter(function (item) { return item.CODE != "C14"; }); self.getGKSXLB() }) } self.getGKSXLB = function () { var data = { ckey: "CODE_GKSXLB", routeinfoid: self.routeinfoid } $http.post(apiurljs.login + "g2app/abase/queryDataCode", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg) .success(function (obj) { var res = strToJson(s4.decryptData_CBC(obj.data)); self.GKSXLB = res.data.CODE_GKSXLB; self.load() }) } self.load = function () { if (self.get_lastReturnPageno == undefined || self.get_lastReturnPageno == null || self.get_lastReturnPageno == "") { self.getData(self.pageno); } else { $timeout(function () { self.getData(self.get_lastReturnPageno); }, 1) } } self.sortFiled = function (str) { var n = 0, obj, x = -1; self.ordercondition.forEach(function (item, index) { if (item.COLID == str) { n++ item.SORTTYPE = item.SORTTYPE == "" || item.SORTTYPE == "asc" ? "desc" : "asc" obj = item; x = index } }) if (n == 0) { self.ordercondition.unshift({ COLID: str, SORTTYPE: "desc" }) } if (x != -1) { self.ordercondition.splice(x, 1) self.ordercondition.unshift(obj) } self.getData(1); } self.getLAIYUAN(); self.openLayer = function () { self.params = ""; if (self.search == null) { self.search = { BT: "", LAIYUAN: "", BIANHAO: "", GKSXLB: "", SQGKNRMS: "", USER: "", LXDH: "", DATE1: "", DATE2: "", SJBJRQ1: "", SJBJRQ2: "" } } else { self.LAIYUAN.forEach(function (item) { item.checked = false; if (self.search.LAIYUAN.indexOf(item.CODE) > -1) { item.checked = true; } }) self.GKSXLB.forEach(function (item) { item.checked = false; if (self.search.GKSXLB.indexOf(item.CODE) > -1) { item.checked = true; } }) } sp.layer("#Search") } self.doSearch = function () { self.search.LAIYUAN = []; self.LAIYUAN.forEach(function (item) { if (item.checked == true) { self.search.LAIYUAN.push(item.CODE) } }) self.search.GKSXLB = []; self.GKSXLB.forEach(function (item) { if (item.checked == true) { self.search.GKSXLB.push(item.CODE) } }) $.cookie("GlWorkPlatform-gongkaizhu", JSON.stringify(self.search), { path: '/', expires: 1 }); self.getData(self.pageno) sp.layerhide() } self.cancal = function () { self.search = { BT: "", LAIYUAN: "", BIANHAO: "", GKSXLB: "", SQGKNRMS: "", USER: "", LXDH: "", DATE1: "", DATE2: "", SJBJRQ1: "", SJBJRQ2: "" } $.cookie("GlWorkPlatform-gongkaizhu", null, { path: '/', expires: 1 }); self.getData(1) sp.layerhide() } self.refresh = function () { self.CrossPage.type = null; self.getData(self.pageno); } self.goUrl = function (item) { if (item.TODOLIST && item.TODOLIST.length > 1) { self.todoTitle = item.TITLE; self.todoList = item.TODOLIST; sp.layer("#todolist") } else { if (self.deviceType == "pad") { window.location.href = item.FILEN + "&dotype=" + getDoType(self.type) } else { sp.openNewWindow(item.FILEN + "&dotype=" + getDoType(self.type), item.TITLE + item.BIANHAO) } sp.layerhide(); } } self.btnDel = function (item) { var data = { routeinfoid: item.ROUTEINFOID, userid: self.userId } $http.post(apiurljs.login + "g2work/routeinfo/deleteDraftByRouteinfoid", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg) .success(function (obj) { var res = strToJson(s4.decryptData_CBC(obj.data)); if (res.success == true) { self.getData(self.pageno) } else { sp.dialog(res.message) } }) } //撤销 self.btnCX = function (item) { self.cxObj = { ROUTEINFOID: item.ROUTEINFOID, CONTENT: "" }; sp.layer("#chexiao") } self.cxSubmit = function () { if (self.cxObj.CONTENT == "") { sp.layerhide(); sp.dialog("请填写撤销原因!") $timeOut(function () { sp.dialoghide() sp.layer("#chexiao") },2000) } var data = { userid: self.userId, routeinfoid: self.cxObj.ROUTEINFOID, content: self.cxObj.CONTENT } $http.post(apiurljs.login + "g2work/routeinfo/unCancelDataByRouteinfoid", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg) .success(function (obj) { var res = strToJson(s4.decryptData_CBC(obj.data)); sp.layerhide() if (res.success == true) { self.getData(self.pageno) } else { sp.dialog(res.message) } }) } self.changeType = function (str) { if (self.type == str) { return; } else { var time1 = sp.getLocalDate1(); self.journalRecord(time1, sp.getLocalDate1(), "查询", "查询日志", "/g2work/routeinfo/" + self.Url) self.type = str; self.Url = getUrl(self.type); self.getData(1) } } self.getAddFlag = function () { var data = { userid: self.userId, ntops: 0 } $http.post(apiurljs.login + "g2work/desktop/queryWorkflowCando", data, postCfg) .success(function (obj) { var res = strToJson(s4.decryptData_CBC(obj.data)); self.lcList = []; self.activeLC = {}; res.data.forEach(function (item) { if ("AA51".indexOf(item.FLOWID) > -1) { self.lcList.push(item); } }) }) } self.getAddFlag() self.addLC = function () { if (self.lcList.length == 1) { sp.openNewWindow(self.lcList[0].FILEN + "&dotype=1", self.lcList[0].FLOWNAME) //window.location.href = self.lcList[0].FILEN + "&dotype=1" } else { sp.layer("#addLC"); } } self.seeLCT = function (item,event) { event.preventDefault(); event.stopPropagation(); } self.goAddUrl = function () { sp.openNewWindow(self.activeLC.FILEN + "&dotype=1", self.activeLC.FLOWNAME) //window.location.href = self.activeLC.FILEN + "&dotype=1" } self.printEXCEL = function () { //var querycondition = []; //var columnscondition = [ // { COLID: "LAIYUAN", COLUMNS: "SX_SZJWYSQGKXXCBD.LAIYUAN" }, // { COLID: "BIANHAO", COLUMNS: "SX_SZJWYSQGKXXCBD.BIANHAO" }, // { COLID: "GKSXLB", COLUMNS: "SX_SZJWYSQGKXXCBD.GKSXLB" }, // { COLID: "SQRQ", COLUMNS: "SX_SZJWYSQGKXXCBD.SQRQ" }, // { COLID: "LXDH", COLUMNS: "SX_SZJWYSQGKXXCBD.LXDH" }, // { COLID: "SJBJRQ", COLUMNS: "SX_SZJWYSQGKXXCBD.SJBJRQ" }, // { COLID: "SQGKNRMS", COLUMNS: "SX_SZJWYSQGKXXCBD.SQGKNRMS" } //] //var data = { // flowid: "AA51", // userid: self.userId, // pageno: 1, // pagesize: self.total_count, // columnscondition: JSON.stringify(columnscondition), // querycondition: JSON.stringify(querycondition), // ordercondition: "" //} //if (self.type == 'yifa') { // data.creatormark = true //} //if (self.type == 'daifa') { // data.creatormark = true //} //$http.post(apiurljs.login + "g2work/routeinfo/" + self.Url, data, postCfg) //.success(function (res) { // if (res.data == null || res.data == undefined || res.data == "") { // } else { // $.each(res.data, function (index, item) { // self.LAIYUAN.forEach(function (item1) { // if (item.LAIYUAN == item1.CODE) // item.LAIYUAN = item1.CNAME; // }) // self.GKSXLB.forEach(function (item1) { // if (item.GKSXLB == item1.CODE) // item.GKSXLB = item1.CNAME; // }) // item.SQRQ = sp.format(item.SQRQ); // item.SJBJRQ = sp.format(item.SJBJRQ) // if (item.USERS) { // item.USERSNAME = item.USERS.map(function (item1) { return item1.USERNAME }).join(","); // item.ENDNODESNAME = item.USERS.map(function (item1) { return item1.ENDNODENAME }).join(","); // } // if (self.type == "finish") { // item.RECEIVEDATE = item.FINISHEDDATE; // } // }) //} if (self.type == "todo") { self.columns = [ { header: "来源", key: "LAIYUAN", width: 20 }, { header: "编号", key: "BIANHAO", width: 20 }, { header: "名称", key: "TITLE", width: 25 }, { header: "申请公开描述", key: "SQGKNRMS", width: 100 }, { header: "申请时间", key: "SQRQ", width: 20 }, { header: "联系电话", key: "LXDH", width: 20 }, { header: "实际办结日期", key: "SJBJRQ", width: 20 }, { header: "公开属性类别", key: "GKSXLB", width: 20 }, { header: "转发人", key: "USERNAMEFROM", width: 25 }, { header: "当前节点", key: "ENDNODENAME", width: 25 }, { header: "接收时间", key: "RECEIVEDATE", width: 30 } ] self.listExcel = self.list.map(function (item) { return { LAIYUAN: item.LAIYUAN, BIANHAO: item.BIANHAO, TITLE: item.TITLE, SQGKNRMS: item.SQGKNRMS, SQRQ: item.SQRQ, LXDH: item.LXDH, SJBJRQ: item.SJBJRQ, GKSXLB: item.GKSXLB, USERNAMEFROM: item.USERNAMEFROM, ENDNODENAME: item.ENDNODENAME, RECEIVEDATE: item.RECEIVEDATE } }) } else if (self.type == "done") { self.columns = [ { header: "来源", key: "LAIYUAN", width: 20 }, { header: "编号", key: "BIANHAO", width: 20 }, { header: "名称", key: "TITLE", width: 25 }, { header: "申请公开描述", key: "SQGKNRMS", width: 100 }, { header: "申请时间", key: "SQRQ", width: 20 }, { header: "联系电话", key: "LXDH", width: 20 }, { header: "实际办结日期", key: "SJBJRQ", width: 20 }, { header: "公开属性类别", key: "GKSXLB", width: 20 }, { header: "当前办理人", key: "USERSNAME", width: 25 }, { header: "当前节点", key: "ENDNODESNAME", width: 25 }, { header: "接收时间", key: "RECEIVEDATE", width: 30 } ] self.listExcel = self.list.map(function (item) { return { LAIYUAN: item.LAIYUAN, BIANHAO: item.BIANHAO, TITLE: item.TITLE, SQGKNRMS: item.SQGKNRMS, SQRQ: item.SQRQ, LXDH: item.LXDH, SJBJRQ: item.SJBJRQ, GKSXLB: item.GKSXLB, USERSNAME: item.USERSNAME, ENDNODESNAME: item.ENDNODESNAME, RECEIVEDATE: item.RECEIVEDATE } }) } else if (self.type == "finish") { self.columns = [ { header: "来源", key: "LAIYUAN", width: 20 }, { header: "编号", key: "BIANHAO", width: 20 }, { header: "名称", key: "TITLE", width: 25 }, { header: "申请公开描述", key: "SQGKNRMS", width: 100 }, { header: "申请时间", key: "SQRQ", width: 20 }, { header: "联系电话", key: "LXDH", width: 20 }, { header: "实际办结日期", key: "SJBJRQ", width: 20 }, { header: "公开属性类别", key: "GKSXLB", width: 20 }, { header: "当前节点", key: "ENDNODENAME", width: 25 }, { header: "接收时间", key: "RECEIVEDATE", width: 30 } ] self.listExcel = self.list.map(function (item) { return { LAIYUAN: item.LAIYUAN, BIANHAO: item.BIANHAO, TITLE: item.TITLE, SQGKNRMS: item.SQGKNRMS, SQRQ: item.SQRQ, LXDH: item.LXDH, SJBJRQ: item.SJBJRQ, GKSXLB: item.GKSXLB, ENDNODENAME: item.ENDNODENAME, RECEIVEDATE: item.RECEIVEDATE } }) } else if (self.type == "yifa") { self.columns = [ { header: "来源", key: "LAIYUAN", width: 20 }, { header: "编号", key: "BIANHAO", width: 20 }, { header: "名称", key: "TITLE", width: 25 }, { header: "申请公开描述", key: "SQGKNRMS", width: 100 }, { header: "申请时间", key: "SQRQ", width: 20 }, { header: "联系电话", key: "LXDH", width: 20 }, { header: "实际办结日期", key: "SJBJRQ", width: 20 }, { header: "公开属性类别", key: "GKSXLB", width: 20 }, { header: "上一节点办理人", key: "USERNAMEFROM", width: 25 }, { header: "当前节点", key: "ENDNODENAME", width: 25 } ] self.listExcel = self.list.map(function (item) { return { LAIYUAN: item.LAIYUAN, BIANHAO: item.BIANHAO, TITLE: item.TITLE, SQGKNRMS: item.SQGKNRMS, SQRQ: item.SQRQ, LXDH: item.LXDH, SJBJRQ: item.SJBJRQ, GKSXLB: item.GKSXLB, USERNAMEFROM: item.USERNAMEFROM, ENDNODENAME: item.ENDNODENAME } }) } else if (self.type == "daifa") { self.columns = [ { header: "来源", key: "LAIYUAN", width: 20 }, { header: "编号", key: "BIANHAO", width: 20 }, { header: "名称", key: "TITLE", width: 25 }, { header: "联系电话", key: "LXDH", width: 20 }, { header: "实际办结日期", key: "SJBJRQ", width: 20 }, { header: "公开属性类别", key: "GKSXLB", width: 20 }, { header: "撤销原因", key: "UNCANCELCONTENT", width: 100 }, { header: "当前节点", key: "ENDNODENAME", width: 25 }, { header: "撤销时间", key: "UNCANCELCDATE", width: 30 } ] self.listExcel = self.list.map(function (item) { return { LAIYUAN: item.LAIYUAN, BIANHAO: item.BIANHAO, TITLE: item.TITLE, LXDH: item.LXDH, SJBJRQ: item.SJBJRQ, GKSXLB: item.GKSXLB, UNCANCELCONTENT: item.UNCANCELCONTENT, ENDNODENAME: item.ENDNODENAME, UNCANCELCDATE: item.UNCANCELCDATE } }) } // 创建工作簿 var workbook = new ExcelJS.Workbook() // 添加工作表 var worksheet = workbook.addWorksheet('sheet1') // 设置表头 worksheet.columns = self.columns // 添加表体数据 self.listExcel.forEach(function (item) { worksheet.addRow(item) }) /** * 设置样式 */ // 1、设置标题行样式 var headerRow = worksheet.getRow(1) // 连续遍历所有非空单元格 headerRow.eachCell(function(cell) { // 边框 https://github.com/exceljs/exceljs/blob/HEAD/README_zh.md#%E8%BE%B9%E6%A1%86 cell.border = { top: { style: 'thin' }, left: { style: 'thin' }, bottom: { style: 'thin' }, right: { style: 'thin' }, } // 填充 https://github.com/exceljs/exceljs/blob/HEAD/README_zh.md#%E5%A1%AB%E5%85%85 cell.fill = { type: 'pattern', pattern: 'solid', fgColor: { argb: '4f81bd' } } // 字体 https://github.com/exceljs/exceljs/blob/HEAD/README_zh.md#%E5%AD%97%E4%BD%93 cell.font = { name: '微软雅黑', size: 11, bold: true, color: { argb: '000000' } } // 对齐 https://github.com/exceljs/exceljs/blob/HEAD/README_zh.md#%E5%AF%B9%E9%BD%90 cell.alignment = { vertical: 'middle', horizontal: 'center' } }) // 2、设置内容行样式 const bodyRow = worksheet.getRows(2, self.listExcel.length + 1) bodyRow.forEach(function (row) { //遍历此列中的所有当前单元格,包括空单元格 row.eachCell({ includeEmpty: true }, function (cell) { // 边框 cell.border = { top: { style: 'thin' }, left: { style: 'thin' }, bottom: { style: 'thin' }, right: { style: 'thin' }, } // 字体 https://github.com/exceljs/exceljs/blob/HEAD/README_zh.md#%E5%AD%97%E4%BD%93 cell.font = { name: '微软雅黑', size: 11, color: { argb: '000000' } } // 对齐 https://github.com/exceljs/exceljs/blob/HEAD/README_zh.md#%E5%AF%B9%E9%BD%90 cell.alignment = { vertical: 'middle', horizontal: 'center' } }) }) // 导出表格 workbook.xlsx.writeBuffer().then(function (buffer) { const blob = new Blob([buffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' }) const link = document.createElement('a') link.href = URL.createObjectURL(blob) link.download = '申请公开-' + (self.type == "todo" ? "待办" : self.type == "done" ? "已办" : self.type == "finish" ? "办结" : self.type == "yifa" ? "已发" : "待发") + sp.format(sp.getLocalDate()) + '.xlsx' link.click() URL.revokeObjectURL(link.href) // 下载完成释放掉blob对象 }) //}) } //记录日志 self.journalRecord = function (time1, time2, title, func, url) { if (!self.CrossPage || !self.CrossPage.cname) { return; } var data = { tablename: "SYS_CLICKLOG", data: { CTIME: time1 == null ? sp.getLocalDate1() : time1, TITLE: (title != "" ? self.CrossPage.cname + "/" + title : self.CrossPage.cname), REQUESTURL: url, REQUESTHEADERURL: window.location.origin, LOGTYPE: func, USERTYPE: $.cookie("GlWorkPlatform-userType"), ADMIN: $.cookie("GlWorkPlatform-userTypeEng"), CLIENTIP: sp.myIP(), PCNAME: sp.detectOS(), BROWSERNAME: sp.browser(), RESPONSETIME: time2 == null ? sp.getLocalDate1() : time2, USERID: self.userId, USERNAME: self.userName } } $http.post(apiurljs.login + "g2app/dataabase/insertFormData", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg) .success(function (res) { self.CrossPage.type = 1; }) } $interval(function () { if (localStorage.getItem("GlWorkPlatform-gongkaizhu-refresh") == 1) { localStorage.removeItem("GlWorkPlatform-gongkaizhu-refresh") self.refresh() } }, 1000) //头部下滚冻结 $(function () { //页面高度撑满 setTimeout(function () { if ($(".ibox-content").height() < $(window).height() - 31) { $(".ibox-content").css("height", $(window).height() - 31) } }, 1) }) }]) function getUrl(str) { switch (str) { case "todo": return "queryDataTodoWithPage"; break; case "done": return "queryDataDoneWithPage"; break; case "finish": return "queryDataFinishWithPage"; break; case "yifa": return "queryDataYifaWithPage"; break; case "daifa": return "queryDataDaifaWithPage"; break; } } function getDoType(str) { switch (str) { case "todo": return 1; break; case "daifa": return 1; break; default: return 0; break; } }