zhujian_OA/tpl/SJPSDB/js/taizhang.js

'use strict';

var app = angular.module('app', [
  'angularUtils.directives.dirPagination'
]);
app.controller("taizhangCtrl", ["$scope", "$http", "$timeout", function ($scope, $http, $timeout) {
    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.get_lastReturnPageno = sp.getUrlName("lastReturnPageno");

    var postCfg = {
        headers: {
            'Content-Type': 'application/json',
            'Authorization': "Bearer " + self.get_AccessToken
        }
    }

    self.loading = false;
    self.search = JSON.parse($.cookie("GlWorkPlatform-sjpsdbtz")) || { TITLE: "", QTCS: "", CHDATE1: "", CHDATE2: "", QPRQ1: "", QPRQ2: "", DBSX1: "", DBSX2: "" };

    self.noDataTip = 1;//没有数据时赋变量为0,先默认为1
    self.pageno = 1;
    self.total_count = 0;
    self.itemsPerPage = 10;
    self.pageOptions = [10, 20, 30, 40, 100, 300, 500];

    self.getData = function (pageno) {
        self.list = [];
        self.loading = true;
        self.pageno = pageno;
        $scope.__default__currentPage = self.pageno;   //设置页面样式在第几页
        var sqlwhere = [];
        if (self.search.TITLE != "") {
            sqlwhere.push("and TITLE like '%" + self.search.TITLE + "%'")
        }
        if (self.search.QTCS != "") {
            sqlwhere.push("and QTCS like '%" + self.search.QTCS + "%'")
        }
        if (self.search.CHDATE1 != "" && self.search.CHDATE2 != "") {
            sqlwhere.push("and CHDATE between '" + self.search.CHDATE1 + " 00:00:00' and '" + self.search.CHDATE2 + " 23:59:59'")
        }
        if (self.search.QPRQ1 != "" && self.search.QPRQ2 != "") {
            sqlwhere.push("and QPRQ between '" + self.search.QPRQ1 + " 00:00:00' and '" + self.search.QPRQ2 + " 23:59:59'")
        }
        if (self.search.DBSX1 != "" && self.search.DBSX2 != "") {
            sqlwhere.push("and DBSX between '" + self.search.DBSX1 + " 00:00:00' and '" + self.search.DBSX2 + " 23:59:59'")
        }
        var data = {
            tablename: "SX_SJPSDU",
            pagesize: self.itemsPerPage,
            pageno: self.pageno,
            //colums: "*,TO_CHAR(CHDATE,'yyyy-mm-dd')as CHDATE,TO_CHAR(QPRQ,'yyyy-mm-dd')as QPRQ,TO_CHAR(DBSX,'yyyy-mm-dd')as DBSX",
            columns: "ROUTEINFOID,TITLE,to_char(CHDATE,'yyyy-MM-dd') as CHDATE,SJPS,to_char(QPRQ,'yyyy-MM-dd') as QPRQ,QTCS,to_char(DBSX,'yyyy-MM-dd') as DBSX,BLJD",
            opinion_col: "BLJDYJ",
            order: "ROUTEINFOID",
            sqlwhere: sqlwhere.join(" ")
        }
        $http.post(apiurljs.login + "g2app/dataabase/queryDataAndOpinionWithPage", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg)
        .success(function (obj) {
            var res = strToJson(s4.decryptData_CBC(obj.data));
            self.loading = false;
            if (res.data == null || res.data == undefined || res.data == "") {
                self.noDataTip = 0;
            } else {
                self.noDataTip = 1;
                self.list = res.data;
                self.list.forEach(function (item) {
                    self.BLJD.forEach(function (item1) {
                        if (item.BLJD == item1.CODE)
                            item.BLJD = item1.CNAME
                    })
                })
                self.total_count = res.totalCount;
                self.canExportExcel = true;
            }
        })
    }
    self.getBLJD = function () {
        var data = {
            ckey: "CODE_SJPSBLJD",
            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.BLJD = res.data.CODE_SJPSBLJD;
            self.getData(1)
        })
    }
    self.getBLJD();

    self.openLayer = function () {
        sp.layer("#Search")
    }
    self.doSearch = function () {
        if ((self.search.CHDATE1 != "" && self.search.CHDATE2 == "") ||
            (self.search.CHDATE1 == "" && self.search.CHDATE2 != "") ||
            (self.search.QPRQ1 != "" && self.search.QPRQ2 == "") ||
            (self.search.QPRQ1 == "" && self.search.QPRQ2 != "") ||
            (self.search.DBSX1 != "" && self.search.DBSX2 == "") ||
            (self.search.DBSX1 == "" && self.search.DBSX2 != "")) {
            sp.layerhide()
            sp.dialog("请输入正确时间区间！");
            $timeout(function () {
                sp.dialoghide();
                sp.layer("#Search")
            }, 2000)
        } else {
            $.cookie("GlWorkPlatform-sjpsdbtz", JSON.stringify(self.search), { path: '/', expires: 1 });
            self.getData(self.pageno)
            sp.layerhide()
        }
    }
    self.cancal = function () {
        self.search = {
            TITLE: "",
            QTCS: "",
            CHDATE1: "",
            CHDATE2: "",
            QPRQ1: "",
            QPRQ2: "",
            DBSX1: "",
            DBSX2: ""
        }
        $.cookie("GlWorkPlatform-sjpsdbtz", null, { path: '/', expires: 1 });
        self.getData(1)
        sp.layerhide()
    }

    self.refresh = function () {
        self.getData(self.pageno);
    }

    self.printOut = function () {
        $.ajax({
            url:apiurljs.login + "g2app/dataabase/ExpExeclWithDataAndOpinion_ByParam",
            type:'POST',
            cache: false,
            xhr: function () {
                var xhr = new XMLHttpRequest();
                xhr.onreadystatechange = function () {
                    if (xhr.readyState == 2) {
                        if (xhr.status == 200) {
                            xhr.responseType = "blob";
                        } else {
                            xhr.responseType = "text";
                        }
                    }
                };
                return xhr;
            },
            headers: {
                "Content-Type": "application/json",
                "file-argument":s4.encryptData_CBC('execlCol|文件,来文,书记批示,签批日期,牵头处室,督办时限,办理进度,办理情况&tablename|SX_SJPSDU&columns|ROUTEINFOID,TITLE,CHDATE,SJPS,QPRQ,QTCS,DBSX,BLJD&opinion_col|BLJDYJ&pageno|' + self.pageno + '&pagesize|' + self.itemsPerPage + '&order|ROUTEINFOID&sqlwhere|&dateform|yyyy-MM-dd')
            },
            success:function(res){
                download(res, "书记批示督办" + sp.getLocalDate() + ".et")
            },
        })
    }
    //头部下滚冻结
    $(function () {
        //页面高度撑满
        setTimeout(function () {
            if ($(".ibox-content").height() < $(window).height() - 31) {
                $(".ibox-content").css("height", $(window).height() - 31)
            }
        }, 1)
    })
}])
function download(data, filename, mime, bom) {
    var blobData = typeof bom !== "undefined" ? [bom, data] : [data];
    var blob = new Blob(blobData, { type: mime || "application/octet-stream" });
    if (typeof window.navigator.msSaveBlob !== "undefined") {
        // IE workaround for "HTML7007: One or more blob URLs were
        // revoked by closing the blob for which they were created.
        // These URLs will no longer resolve as the data backing
        // the URL has been freed."
        window.navigator.msSaveBlob(blob, filename);
    } else {
        var blobURL =
          window.URL && window.URL.createObjectURL
            ? window.URL.createObjectURL(blob)
            : window.webkitURL.createObjectURL(blob);
        var tempLink = document.createElement("a");
        tempLink.style.display = "none";
        tempLink.href = blobURL;
        tempLink.setAttribute("download", filename);

        // Safari thinks _blank anchor are pop ups. We only want to set _blank
        // target if the browser does not support the HTML5 download attribute.
        // This allows you to download files in desktop safari if pop up blocking
        // is enabled.
        if (typeof tempLink.download === "undefined") {
            tempLink.setAttribute("target", "_blank");
        }

        document.body.appendChild(tempLink);
        tempLink.click();
        // Fixes "webkit blob resource error 1"
        setTimeout(function () {
            document.body.removeChild(tempLink);
            window.URL.revokeObjectURL(blobURL);
        }, 200);
    }
}