zhujian_OA/tpl/totalyanqidb/js/list.js

'use strict';

var app = angular.module('app', [
  'angularUtils.directives.dirPagination'
]);
app.controller("listCtrl", ["$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");
    self.get_type = sp.getUrlName("type");

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

    self.search = {
        DBLX: "",
        TYPE: "",
        CBBM: "",
        KSSJ: sp.format(sp.getLocalDate()),
        JSSJ: sp.format(sp.getLocalDate())
    }
    self.chart = {
        pie: 1,
        column: 1
    }

    self.getDBLX = function () {
        var data = {
            tablename: "CODE_DUBAN"
        }
        $http.post(apiurljs.login + "g2app/DangAn/queryCodeData", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg)
        .success(function (obj) {
            var res = strToJson(s4.decryptData_CBC(obj.data));
            self.DBLX = res.data;
            self.getDpList();
        })
    }
    self.getDpList = function () {
        var data = {
            nodekid: "AA82N04,AA16N08,AA17N08,AA18N08"
        }
        $http.post(apiurljs.login + "g2app/richang/querychengbanDp", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg)
        .success(function (obj) {
            var res = strToJson(s4.decryptData_CBC(obj.data));
            self.CBBM = res.data;
            self.getData();
        })
    }

    self.noDataTip = 0;
    self.getData = function () {
        self.list = [];
        var data = {
            dblx: self.search.DBLX,
            gstype: self.search.TYPE,
            zbcscode: self.search.CBBM,
            begindate: self.search.KSSJ + " 00:00:00",
            enddate: self.search.JSSJ + "23:59:59"
        }
        $http.post(apiurljs.login + "g2app/richang/queryDuBanYanQiStatistics", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg)
        .success(function (obj) {
            var res = strToJson(s4.decryptData_CBC(obj.data));
            self.loading = false;
            self.canExportExcel = true;
            if (res.data == null || res.data == undefined || res.data == "") {
                self.noDataTip = 0;
            } else {
                self.noDataTip = 1;
                self.list = res.data;

                self.dataPie = [{ name: "一般督办", y: 0 }, { name: "重点督办", y: 0 }]
                self.column = {
                    title: [],
                    data: [{ name: "超期办结", data: [] }, { name: "按期办结", data: [] }, { name: "未超期未办结", data: [] }, { name: "超期未办结", data: [] }]
                }

                self.list.forEach(function (item) {
                    self.dataPie.forEach(function (item1) {
                        if (item.DBLX == item1.name) {
                            item1.y = item1.y + numIsNull(item.CQBJ_AVG) + numIsNull(item.WCQBJ_AVG) + numIsNull(item.WCQWBJ_AVG) + numIsNull(item.CQWBJ_AVG)
                        }
                    })
                    if (self.column.title.indexOf(item.SECTION) == -1) {
                        self.column.title.push(item.SECTION)
                        self.column.data.forEach(function (item1) {
                            item1.data.push(0)
                        })
                    }
                })
                self.getPie()
                self.getColumn()
            }
        })
    }
    self.getDBLX()
    self.printOut = function () {
        if (self.canExportExcel) {
            $('#printOut td').attr('t', 's')
            var defaultCellStyle = {
                font: {
                    name: 'Times New Roman',
                    sz: 12,
                    color: {
                        rgb: "000000"
                    },
                    bold: false, italic: false,
                    underline: false
                },
                alignment: {
                    vertical: "center",
                    horizontal: "center", indent: 0, wrapText: true
                },
                border: {
                    top: {
                        style: "thin",
                        color: {
                            rgb: "000000"
                        }
                    },
                    right: {
                        style: "thin",
                        color: {
                            rgb: "000000"
                        }
                    },
                    bottom: {
                        style: "thin",
                        color: {
                            rgb: "000000"
                        }
                    },
                    left: {
                        style: "thin",
                        color: {
                            rgb: "000000"
                        }
                    }
                }
            };
            var cell = { defaultCellStyle: defaultCellStyle };
            var wb = XLSX.utils.table_to_book_addtitle(document.querySelector('#printOut'), cell, "事项统计")

            //设置表格的样式
            var wbout = XLSX.write(wb, {
                bookType: 'xlsx',
                bookSST: false,
                type: 'binary',
                cellStyles: true,
                defaultCellStyle: defaultCellStyle,
                showGridLines: false
            });
            var s2ab = function (s) {
                var buf = new ArrayBuffer(s.length);
                var view = new Uint8Array(buf);
                for (var i = 0; i !== s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF;
                return buf;
            };
            try {
                saveAs(new Blob([s2ab(wbout)], { type: 'application/octet-stream' }), '事项统计.xlsx')
            } catch (e) { if (typeof console !== 'undefined') console.log(e, wbout) }
            return wbout
        } else {
            sp.dialog('数据还未加载完成,请稍等...')
        }
    }

    self.getPie = function () {
        var chart = new Highcharts.Chart({
            chart: {
                renderTo: "pie",
                type: 'pie',
                style: {
                    position: 'relative',
                    left: '-30px'
                }
            },
            title: {
                text: '', //图表的标题
                //margin: 80
            },
            tooltip: {
                pointFormat: '{series.name}: <b>{point.y}</b>'
            },
            legend: {
                floating: true,
                align: 'left',
                verticalAlign: 'middle',
                layout: 'vertical',
                backgroundColor: '#FFF',
                itemMarginTop: 5,
                itemMarginBottom: 5,
                itemStyle: {
                    fontSize: 16
                },
                enabled: false,
            },
            plotOptions: {
                pie: {
                    allowPointSelect: true,
                    cursor: 'pointer',
                    size: 300,
                    dataLabels: {
                        enabled: true,
                        distance: -50,
                        formatter: function () {
                            return this.point.name + "：" + this.point.percentage.toFixed(2) + "%";
                        }
                    },
                    showInLegend: true
                }
            },
            series: [{
                name: '',
                data: self.dataPie
            }],
            credits: {
                enabled: false//隐藏右下角网址
            },
            exporting: {
                enabled: false//隐藏右上角打印
            }
        })
    }
    self.getColumn = function () {
        self.column.title.forEach(function (item, index) {
            console.log(item)
            self.list.forEach(function (item1) {
                if (item1.SECTION == item) {
                    console.log(self.column.data[0].data[index] + item1.CQBJ)
                    self.column.data[0].data[index] = self.column.data[0].data[index] + numIsNull(item1.CQBJ_AVG)
                    self.column.data[1].data[index] = self.column.data[0].data[index] + numIsNull(item1.WCQBJ_AVG)
                    self.column.data[2].data[index] = self.column.data[0].data[index] + numIsNull(item1.WCQWBJ_AVG)
                    self.column.data[3].data[index] = self.column.data[0].data[index] + numIsNull(item1.CQWBJ_AVG)
                }
            })
        })
        console.log(self.column)
        var chart = new Highcharts.Chart({
            chart: {
                renderTo: "column",
                type: 'column'
            },
            title: {
                text: '', //图表的标题
                //margin: 80
            },
            tooltip: {
                headerFormat: '<span style="font-size:10px">{point.key}</span><table>',
                pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' +
                '<td style="padding:0"><b>{point.y}</b>{series.className}</td></tr>',
                footerFormat: '</table>',
                shared: true,
                useHTML: true
            },
            xAxis: {
                categories: self.column.title
            },
            yAxis: {
                title: {
                    text: ''
                },
                lineWidth: 1,
                gridLineWidth: 1
            },
            legend: {
                enabled: true
            },
            plotOptions: {
                series: {
                    turboThreshold: 0,
                    cursor: 'pointer',
                    pointWidth: 20,
                    dataLabels: {
                        enabled: true,
                    }
                }
            },
            series: self.column.data,
            credits: {
                enabled: false//隐藏右下角网址
            },
            exporting: {
                enabled: false//隐藏右上角打印
            }
        })
    }

    //头部下滚冻结
    $(function () {
        //页面高度撑满
        setTimeout(function () {
            if ($(".ibox-content").height() < $(window).height() - 31) {
                $(".ibox-content").css("height", $(window).height() - 31)
            }
        }, 1)
    })
}])

function numIsNull(n) {
    if (n == "" || n == null || n == undefined) {
        return 0
    } else {
        return n
    }
}