taizhang.js 8.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209
  1. 'use strict';
  2. var app = angular.module('app', [
  3. 'angularUtils.directives.dirPagination'
  4. ]);
  5. app.controller("taizhangCtrl", ["$scope", "$http", "$timeout", function ($scope, $http, $timeout) {
  6. var self = this;
  7. var s4 = new SM4Util();
  8. self.userId = $.cookie("GlWorkPlatform-userid");
  9. self.userName = $.cookie("GlWorkPlatform-chineseName");
  10. self.get_AccessToken = localStorage.getItem("GlWorkPlatform-AccessToken");
  11. self.get_lastReturnPageno = sp.getUrlName("lastReturnPageno");
  12. var postCfg = {
  13. headers: {
  14. 'Content-Type': 'application/json',
  15. 'Authorization': "Bearer " + self.get_AccessToken
  16. }
  17. }
  18. self.loading = false;
  19. self.search = JSON.parse($.cookie("GlWorkPlatform-sjpsdbtz")) || { TITLE: "", QTCS: "", CHDATE1: "", CHDATE2: "", QPRQ1: "", QPRQ2: "", DBSX1: "", DBSX2: "" };
  20. self.noDataTip = 1;//没有数据时赋变量为0,先默认为1
  21. self.pageno = 1;
  22. self.total_count = 0;
  23. self.itemsPerPage = 10;
  24. self.pageOptions = [10, 20, 30, 40, 100, 300, 500];
  25. self.getData = function (pageno) {
  26. self.list = [];
  27. self.loading = true;
  28. self.pageno = pageno;
  29. $scope.__default__currentPage = self.pageno; //设置页面样式在第几页
  30. var sqlwhere = [];
  31. if (self.search.TITLE != "") {
  32. sqlwhere.push("and TITLE like '%" + self.search.TITLE + "%'")
  33. }
  34. if (self.search.QTCS != "") {
  35. sqlwhere.push("and QTCS like '%" + self.search.QTCS + "%'")
  36. }
  37. if (self.search.CHDATE1 != "" && self.search.CHDATE2 != "") {
  38. sqlwhere.push("and CHDATE between '" + self.search.CHDATE1 + " 00:00:00' and '" + self.search.CHDATE2 + " 23:59:59'")
  39. }
  40. if (self.search.QPRQ1 != "" && self.search.QPRQ2 != "") {
  41. sqlwhere.push("and QPRQ between '" + self.search.QPRQ1 + " 00:00:00' and '" + self.search.QPRQ2 + " 23:59:59'")
  42. }
  43. if (self.search.DBSX1 != "" && self.search.DBSX2 != "") {
  44. sqlwhere.push("and DBSX between '" + self.search.DBSX1 + " 00:00:00' and '" + self.search.DBSX2 + " 23:59:59'")
  45. }
  46. var data = {
  47. tablename: "SX_SJPSDU",
  48. pagesize: self.itemsPerPage,
  49. pageno: self.pageno,
  50. //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",
  51. 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",
  52. opinion_col: "BLJDYJ",
  53. order: "ROUTEINFOID",
  54. sqlwhere: sqlwhere.join(" ")
  55. }
  56. $http.post(apiurljs.login + "g2app/dataabase/queryDataAndOpinionWithPage", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg)
  57. .success(function (obj) {
  58. var res = strToJson(s4.decryptData_CBC(obj.data));
  59. self.loading = false;
  60. if (res.data == null || res.data == undefined || res.data == "") {
  61. self.noDataTip = 0;
  62. } else {
  63. self.noDataTip = 1;
  64. self.list = res.data;
  65. self.list.forEach(function (item) {
  66. self.BLJD.forEach(function (item1) {
  67. if (item.BLJD == item1.CODE)
  68. item.BLJD = item1.CNAME
  69. })
  70. })
  71. self.total_count = res.totalCount;
  72. self.canExportExcel = true;
  73. }
  74. })
  75. }
  76. self.getBLJD = function () {
  77. var data = {
  78. ckey: "CODE_SJPSBLJD",
  79. routeinfoid: self.routeinfoid
  80. }
  81. $http.post(apiurljs.login + "g2app/abase/queryDataCode", { data: s4.encryptData_CBC(JSON.stringify(data)) }, postCfg)
  82. .success(function (obj) {
  83. var res = strToJson(s4.decryptData_CBC(obj.data));
  84. self.BLJD = res.data.CODE_SJPSBLJD;
  85. self.getData(1)
  86. })
  87. }
  88. self.getBLJD();
  89. self.openLayer = function () {
  90. sp.layer("#Search")
  91. }
  92. self.doSearch = function () {
  93. if ((self.search.CHDATE1 != "" && self.search.CHDATE2 == "") ||
  94. (self.search.CHDATE1 == "" && self.search.CHDATE2 != "") ||
  95. (self.search.QPRQ1 != "" && self.search.QPRQ2 == "") ||
  96. (self.search.QPRQ1 == "" && self.search.QPRQ2 != "") ||
  97. (self.search.DBSX1 != "" && self.search.DBSX2 == "") ||
  98. (self.search.DBSX1 == "" && self.search.DBSX2 != "")) {
  99. sp.layerhide()
  100. sp.dialog("请输入正确时间区间!");
  101. $timeout(function () {
  102. sp.dialoghide();
  103. sp.layer("#Search")
  104. }, 2000)
  105. } else {
  106. $.cookie("GlWorkPlatform-sjpsdbtz", JSON.stringify(self.search), { path: '/', expires: 1 });
  107. self.getData(self.pageno)
  108. sp.layerhide()
  109. }
  110. }
  111. self.cancal = function () {
  112. self.search = {
  113. TITLE: "",
  114. QTCS: "",
  115. CHDATE1: "",
  116. CHDATE2: "",
  117. QPRQ1: "",
  118. QPRQ2: "",
  119. DBSX1: "",
  120. DBSX2: ""
  121. }
  122. $.cookie("GlWorkPlatform-sjpsdbtz", null, { path: '/', expires: 1 });
  123. self.getData(1)
  124. sp.layerhide()
  125. }
  126. self.refresh = function () {
  127. self.getData(self.pageno);
  128. }
  129. self.printOut = function () {
  130. $.ajax({
  131. url:apiurljs.login + "g2app/dataabase/ExpExeclWithDataAndOpinion_ByParam",
  132. type:'POST',
  133. cache: false,
  134. xhr: function () {
  135. var xhr = new XMLHttpRequest();
  136. xhr.onreadystatechange = function () {
  137. if (xhr.readyState == 2) {
  138. if (xhr.status == 200) {
  139. xhr.responseType = "blob";
  140. } else {
  141. xhr.responseType = "text";
  142. }
  143. }
  144. };
  145. return xhr;
  146. },
  147. headers: {
  148. "Content-Type": "application/json",
  149. "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')
  150. },
  151. success:function(res){
  152. download(res, "书记批示督办" + sp.getLocalDate() + ".et")
  153. },
  154. })
  155. }
  156. //头部下滚冻结
  157. $(function () {
  158. //页面高度撑满
  159. setTimeout(function () {
  160. if ($(".ibox-content").height() < $(window).height() - 31) {
  161. $(".ibox-content").css("height", $(window).height() - 31)
  162. }
  163. }, 1)
  164. })
  165. }])
  166. function download(data, filename, mime, bom) {
  167. var blobData = typeof bom !== "undefined" ? [bom, data] : [data];
  168. var blob = new Blob(blobData, { type: mime || "application/octet-stream" });
  169. if (typeof window.navigator.msSaveBlob !== "undefined") {
  170. // IE workaround for "HTML7007: One or more blob URLs were
  171. // revoked by closing the blob for which they were created.
  172. // These URLs will no longer resolve as the data backing
  173. // the URL has been freed."
  174. window.navigator.msSaveBlob(blob, filename);
  175. } else {
  176. var blobURL =
  177. window.URL && window.URL.createObjectURL
  178. ? window.URL.createObjectURL(blob)
  179. : window.webkitURL.createObjectURL(blob);
  180. var tempLink = document.createElement("a");
  181. tempLink.style.display = "none";
  182. tempLink.href = blobURL;
  183. tempLink.setAttribute("download", filename);
  184. // Safari thinks _blank anchor are pop ups. We only want to set _blank
  185. // target if the browser does not support the HTML5 download attribute.
  186. // This allows you to download files in desktop safari if pop up blocking
  187. // is enabled.
  188. if (typeof tempLink.download === "undefined") {
  189. tempLink.setAttribute("target", "_blank");
  190. }
  191. document.body.appendChild(tempLink);
  192. tempLink.click();
  193. // Fixes "webkit blob resource error 1"
  194. setTimeout(function () {
  195. document.body.removeChild(tempLink);
  196. window.URL.revokeObjectURL(blobURL);
  197. }, 200);
  198. }
  199. }