zhujian_OA/tpl/gongkaizhu/js/list.js

'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 = "<span class=\"sp-dialog-head\"><span class=\"sp-dialog-tip\">温馨提示</span><span class=\"sp-dialog-close sp-closeDialog\" title=\"关闭\">×</span></span>";
            var dialogBody = "<div class=\"sp-dialog-body\">" + res.data.REMARK + "</div>";
            var dialogFoot = "<div class=\"sp-dialog-foot\"><input id='delDataTrue' type='button' value='撤 回' class='sp-dialog-btnTrue' /><input type='button' value='取 消' class='sp-dialog-btnCancle sp-closeDialog' /></div>";
            $('.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;
    }
}