'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;
}
}