'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-sjpstz")) || { LEADERNAME: "", CTIME: "" }; self.getData = function () { self.list = []; self.loading = true; var data = { tablename: "SX_SJPSWJTZ", colums: "*,TO_CHAR(QPSJ,'yyyy-mm-dd')as QPSJ1,TO_CHAR(DBTXTIME,'yyyy-mm-dd')as DBTXTIME1", order: "ID", sqlwhere: "", sqlorwhere: "", sqlinwhere: "", sqllikewhere: { WJMC: self.search.WJMC, LWDW: self.search.LWDW } } $http.post(apiurljs.login + "g2app/dataabase/queryDataByCol", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg) .success(function (obj) { var res = strToJson(s4.decryptData_CBC(obj.data)); self.loading = false; self.list = res.data; self.list.forEach(function (item) { if (item.SJPS != null && item.SJPS.slice(0, 1) == "[") { var text = []; JSON.parse(item.SJPS).forEach(function (item1) { text.push(item1.opinion + " — " + item1.username + "," + item1.cdate) }) item.SJPS=text.join(";") } }) self.canExportExcel = true; }) } self.init = function () { var data = { flowid: { AA16: "AA16", AA18: "AA18" }, userid:self.userId } $http.post(apiurljs.login+"g2app/richang/initLingDaoPiShiFlow",{ data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg) .success(function (obj) { var res = strToJson(s4.decryptData_CBC(obj.data)); if (res.success) { self.getData() } }) } self.init(); self.openLayer = function () { sp.layer("#Search") } self.doSearch = function () { $.cookie("GlWorkPlatform-sjpstz", JSON.stringify(self.search), { path: '/', expires: 1 }); self.getData(self.pageno) sp.layerhide() } self.cancal = function () { self.search = { CTIME: "", LEADERNAME: "" } $.cookie("GlWorkPlatform-sjpstz", null, { path: '/', expires: 1 }); self.getData(1) sp.layerhide() } self.refresh = function () { self.getData(self.pageno); } self.printOut = function () { if (self.canExportExcel) { $('#table 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('#table'), 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('数据还未加载完成,请稍等...') } } //头部下滚冻结 $(function () { //页面高度撑满 setTimeout(function () { if ($(".ibox-content").height() < $(window).height() - 31) { $(".ibox-content").css("height", $(window).height() - 31) } }, 1) }) }])