rpt_main.js 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713
  1. /**
  2. * Created by Tony on 2017/6/26.
  3. */
  4. 'use strict'
  5. const PRE_PAGE_OFFSET = 150;
  6. const NEXT_PAGE_OFFSET = 160;
  7. const FIRST_PAGE_OFFSET = 50;
  8. const LAST_PAGE_OFFSET = 60;
  9. let fontSuffixMapObj = {"表标题": "title", "列标题": "column", "正文内容": "content", "合计": "summary", "表眉/表脚": "header_footer"};
  10. let rptTplObj = {
  11. hasInitialized: false,
  12. iniPage: function() {
  13. let me = this;
  14. if (!me.hasInitialized) {
  15. zTreeOprObj.getCustomerCfg();
  16. zTreeOprObj.getReportTemplateTree();
  17. me.hasInitialized = true;
  18. let canvas = document.getElementById("rptCanvas");
  19. canvas.onclick = canvasOprObj.canvasOnClick;
  20. canvas.onmousemove = canvasOprObj.canvasOnMouseMove;
  21. }
  22. }
  23. }
  24. let zTreeOprObj = {
  25. treeObj: null,
  26. prjFolderTreeObj: null,
  27. currentNode: null,
  28. checkedRptTplNodes: null,
  29. currentRptPageRst: null,
  30. reportPageCfg: null,
  31. defReportPageCfg: null,
  32. currentPage: 1,
  33. maxPages: 0,
  34. countChkedRptTpl: function () {
  35. let me = zTreeOprObj;
  36. if (me.treeObj) {
  37. me.checkedRptTplNodes = [];
  38. let chkNodes = me.treeObj.getCheckedNodes(true), cnt = 0, hasCurrentNode = false;
  39. for (let node of chkNodes) {
  40. if (node.nodeType === TPL_TYPE_TEMPLATE) {
  41. cnt++;
  42. me.checkedRptTplNodes.push(node);
  43. if (me.currentNode === node) hasCurrentNode = true;
  44. }
  45. }
  46. if (!hasCurrentNode && cnt === 0 && me.currentNode !== null) {
  47. //这里根据实际需求再做处理
  48. cnt++;
  49. me.checkedRptTplNodes.push(me.currentNode);
  50. }
  51. $("#export_div").find("span").each(function(cIdx,elementSpan){
  52. elementSpan.innerText = cnt;
  53. });
  54. $("#print_div").find("span").each(function(cIdx,elementSpan){
  55. elementSpan.innerText = cnt;
  56. });
  57. }
  58. },
  59. getReportTemplateTree: function() {
  60. let me = zTreeOprObj, params = {};
  61. params.engineerId = projectObj.project.projectInfo.property.engineering;
  62. let private_chk_hide = function (chkTplItem) {
  63. //考虑未来拓展,统一在此判断报表模板是否显示
  64. let rst = false;
  65. // if (chkTplItem.hasOwnProperty('flags') && chkTplItem.flags.hasOwnProperty('taxType') && chkTplItem.flags['taxType'] !== null &&
  66. // parseInt(chkTplItem.flags['taxType']) !== parseInt(projectObj.project.projectInfo.property.taxType)) {
  67. // rst = true;
  68. // }
  69. //重庆养护系统的判断逻辑有所不同
  70. if (chkTplItem.hasOwnProperty('flags') && chkTplItem.flags.hasOwnProperty('valuationType') && chkTplItem.flags['valuationType'] !== null &&
  71. chkTplItem.flags['valuationType'] !== projectObj.project.projectInfo.property.valuationType) {
  72. rst = true;
  73. }
  74. return rst;
  75. };
  76. // projectObj.project.projectInfo.property.taxType === 1 //1: 一般计税 2: 简易计税
  77. CommonAjax.postEx("report_tpl_api/getRptTplTree", params, 20000, true, function(result){
  78. let private_remove_hide_item = function (items, nlv) {
  79. if (items && items.length > 0) {
  80. for (let i = items.length - 1; i >= 0; i--) {
  81. if (!(items[i].released) && items[i].nodeType === 2) {
  82. items.splice(i, 1);
  83. } else if(private_chk_hide(items[i])) {
  84. items.splice(i, 1);
  85. } else {
  86. if (items[i].items && items[i].items.length > 0) {
  87. private_remove_hide_item(items[i].items, nlv + 1);
  88. if (items[i].items.length === 0 && nlv > 0) {
  89. items.splice(i, 1);
  90. }
  91. }
  92. }
  93. }
  94. }
  95. }
  96. let nodeLv = 0;
  97. private_remove_hide_item(result, nodeLv);
  98. for (let topNode of result) {
  99. if (topNode.userId === "-100") {
  100. topNode.name = topNode.name + " - 标准报表";
  101. } else {
  102. topNode.name = topNode.name + " - 定制报表";
  103. }
  104. }
  105. zTreeHelper.createTreeDirectly(result, rpt_tpl_setting, "rptTplTree", me);
  106. me.refreshNodes();
  107. }, null, null);
  108. },
  109. getCustomerCfg: function() {
  110. let me = zTreeOprObj, params = {};
  111. params.engineerId = projectObj.project.projectInfo.property.engineering;
  112. CommonAjax.postEx("report_tpl_api/getCustomizeCfg", params, 20000, true, function(result){
  113. if (result) {
  114. me.defReportPageCfg = result[0];
  115. me.reportPageCfg = result[1];
  116. me.iniFontCfgDom(me.reportPageCfg);
  117. me.renderRptCfg(result[1]);
  118. } else {
  119. me.reportPageCfg = null;
  120. me.defReportPageCfg = null;
  121. }
  122. }, null, null
  123. );
  124. },
  125. iniFontCfgDom: function (cfg) {
  126. for (let font of cfg.fonts) {
  127. let domArrs = [];
  128. let fontPropSuffix = fontSuffixMapObj[font.CfgDispName];
  129. domArrs.push("<div class='row mb-1'>");
  130. //1. label
  131. domArrs.push("<div class='col-3'>" + font.CfgDispName + "</div>");
  132. //2. font name
  133. domArrs.push("<div class='col-3'>");
  134. domArrs.push("<select class='form-control input-sm' id='fontName_" + fontPropSuffix + "' onchange='rptControlObj.changeFontMain(\"" + font.CfgDispName + "\", \"Name\", this)'>");
  135. domArrs.push("<option>宋体</option><option>楷体</option><option>黑体</option>");
  136. domArrs.push("</select>");
  137. domArrs.push("</div>");
  138. //3. font height
  139. domArrs.push("<div class='col-3'>");
  140. domArrs.push("<input class='form-control input-sm' id='fontHeight_" + fontPropSuffix + "' type='number' value='30' step='1' min='6' max='66' " +
  141. "onchange='rptControlObj.changeFontMain(\"" + font.CfgDispName + "\", \"FontHeight\", this)' " +
  142. "onkeyup='rptControlObj.changeFontMain(\"" + font.CfgDispName + "\", \"FontHeight\", this)'>");
  143. domArrs.push("</div>");
  144. //4. font bold italic underline
  145. domArrs.push("<div class='col-3'>");
  146. domArrs.push("<a id='font_bold_" + fontPropSuffix + "' class='btn btn-sm btn-outline-secondary' title='加粗' onclick='rptControlObj.changeFontAdhoc(\"" + font.CfgDispName + "\", \"FontBold\", this)'><i class='fa fa-bold'></i></a>");
  147. domArrs.push("<a id='font_italic_" + fontPropSuffix + "' class='btn btn-sm btn-outline-secondary' title='斜体' onclick='rptControlObj.changeFontAdhoc(\"" + font.CfgDispName + "\", \"FontItalic\", this)'><i class='fa fa-italic'></i></a>");
  148. domArrs.push("<a id='font_underline_" + fontPropSuffix + "' class='btn btn-sm btn-outline-secondary' title='下划线' onclick='rptControlObj.changeFontAdhoc(\"" + font.CfgDispName + "\", \"FontUnderline\", this)'><i class='fa fa-underline'></i></a>");
  149. domArrs.push("</div>");
  150. //
  151. domArrs.push("</div>");
  152. $(domArrs.join("")).insertBefore($("#font_cfg_blank_flag"));
  153. }
  154. },
  155. renderRptCfg: function (cfg) {
  156. $("#elementMargin_Left").get(0).value = cfg.margins.Left;
  157. $("#elementMargin_Right").get(0).value = cfg.margins.Right;
  158. $("#elementMargin_Top").get(0).value = cfg.margins.Top;
  159. $("#elementMargin_Bottom").get(0).value = cfg.margins.Bottom;
  160. for (let font of cfg.fonts) {
  161. let fontPropSuffix = fontSuffixMapObj[font.CfgDispName];
  162. document.getElementById("fontName_" + fontPropSuffix).value = font.Name;
  163. document.getElementById("fontHeight_" + fontPropSuffix).value = font.FontHeight;
  164. document.getElementById("font_bold_" + fontPropSuffix).className = (font.FontBold === "T")?"btn btn-sm btn-outline-secondary active":"btn btn-sm btn-outline-secondary";
  165. document.getElementById("font_italic_" + fontPropSuffix).className = (font.FontItalic === "T")?"btn btn-sm btn-outline-secondary active":"btn btn-sm btn-outline-secondary";
  166. document.getElementById("font_underline_" + fontPropSuffix).className = (font.FontUnderline === "T")?"btn btn-sm btn-outline-secondary active":"btn btn-sm btn-outline-secondary";
  167. }
  168. document.getElementById("rpt_vertical_line").checked = cfg.showVerticalLine;
  169. document.getElementById("rpt_narrow").checked = cfg.isNarrow;
  170. // document.getElementById("rpt_narrow").checked = false;
  171. document.getElementById("rpt_fill_zero").checked = cfg.fillZero;
  172. },
  173. extractRptCfg: function (cfg) {
  174. cfg.margins.Left = $("#elementMargin_Left").get(0).value;
  175. cfg.margins.Right = $("#elementMargin_Right").get(0).value;
  176. cfg.margins.Top = $("#elementMargin_Top").get(0).value;
  177. cfg.margins.Bottom = $("#elementMargin_Bottom").get(0).value;
  178. for (let font of cfg.fonts) {
  179. let fontPropSuffix = fontSuffixMapObj[font.CfgDispName];
  180. font.Name = document.getElementById("fontName_" + fontPropSuffix).value;
  181. font.FontHeight = document.getElementById("fontHeight_" + fontPropSuffix).value;
  182. font.FontBold = (document.getElementById("font_bold_" + fontPropSuffix).className === "btn btn-sm btn-outline-secondary active")?"T":"F";
  183. font.FontItalic = (document.getElementById("font_italic_" + fontPropSuffix).className === "btn btn-sm btn-outline-secondary active")?"T":"F";
  184. font.FontUnderline = (document.getElementById("font_underline_" + fontPropSuffix).className === "btn btn-sm btn-outline-secondary active")?"T":"F";
  185. }
  186. cfg.showVerticalLine = document.getElementById("rpt_vertical_line").checked;
  187. cfg.isNarrow = document.getElementById("rpt_narrow").checked;
  188. cfg.fillZero = document.getElementById("rpt_fill_zero").checked;
  189. },
  190. refreshNodes: function() {
  191. let me = this;
  192. let private_setupIsParent = function(node){
  193. node.isParent = (node.nodeType === RT.NodeType.NODE || node.level === 0);
  194. if (node.items && node.items.length) {
  195. for (let i = 0; i < node.items.length; i++) {
  196. private_setupIsParent(node.items[i]);
  197. }
  198. }
  199. };
  200. let topNodes = me.treeObj.getNodes();
  201. for (let i = 0; i < topNodes.length; i++) {
  202. private_setupIsParent(topNodes[i]);
  203. }
  204. me.treeObj.refresh();
  205. },
  206. onCheck: function(event, treeId, treeNode) {
  207. zTreeOprObj.countChkedRptTpl();
  208. },
  209. onClick: function(event,treeId,treeNode) {
  210. let me = zTreeOprObj;
  211. if (treeNode.nodeType === TPL_TYPE_TEMPLATE && treeNode.refId > 0) {
  212. if (treeNode.hasOwnProperty('flags') && treeNode.flags.hasOwnProperty('reportType')
  213. && treeNode['flags']['reportType'] === 'billSummary') {
  214. me.currentNode = treeNode;
  215. me.requestPrjFolder();
  216. me.countChkedRptTpl();
  217. } else {
  218. let params = {};
  219. let pageSize = rptControlObj.getCurrentPageSize();
  220. params.pageSize = pageSize;
  221. params.rpt_tpl_id = treeNode.refId;
  222. params.prj_id = projectObj.project.projectInfo.ID;
  223. params.custCfg = me.reportPageCfg;
  224. me.currentNode = treeNode;
  225. me.requestReport(params);
  226. me.countChkedRptTpl();
  227. }
  228. }
  229. },
  230. changePageSize: function(dom) {
  231. let me = zTreeOprObj,
  232. targetDom = document.getElementById("btnRptPageSize");
  233. let tmpStr = targetDom.innerHTML.trim();
  234. targetDom.innerHTML = dom.innerHTML.trim();
  235. dom.innerHTML = tmpStr;
  236. me.changeCfg();
  237. },
  238. changeOrientation: function(dom) {
  239. let me = zTreeOprObj,
  240. targetDom = document.getElementById("btnRptOrientation");
  241. let tmpStr = targetDom.innerHTML.trim();
  242. targetDom.innerHTML = dom.innerHTML.trim();
  243. dom.innerHTML = tmpStr;
  244. me.changeCfg();
  245. },
  246. changeCfg: function() {
  247. let me = zTreeOprObj;
  248. let params = {};
  249. params.pageSize = rptControlObj.getCurrentPageSize();
  250. params.orientation = rptControlObj.getCurrentOrientation();
  251. params.rpt_tpl_id = me.currentNode.refId;
  252. params.prj_id = projectObj.project.projectInfo.ID;
  253. params.custCfg = me.reportPageCfg;
  254. me.requestReport(params);
  255. },
  256. resetAfter: function (pageRst) {
  257. let size = pageRst[JV.NODE_PAGE_INFO][JV.NODE_PAGE_SIZE].slice(0);
  258. if (size[0] > size[1]) {
  259. document.getElementById("btnRptOrientation").innerHTML = "横向";
  260. document.getElementById("hrefRptOrientation").innerHTML = "纵向";
  261. } else {
  262. document.getElementById("btnRptOrientation").innerHTML = "纵向";
  263. document.getElementById("hrefRptOrientation").innerHTML = "横向";
  264. }
  265. },
  266. requestReport: function (params) {
  267. let me = zTreeOprObj;
  268. hintBox.waitBox();
  269. CommonAjax.postEx("report_api/getReport", params, 15000, true,
  270. function(result){
  271. hintBox.unWaitBox();
  272. let pageRst = result;
  273. let canvas = document.getElementById("rptCanvas");
  274. if (pageRst && pageRst.items && pageRst.items.length > 0) {
  275. me.resetAfter(pageRst);
  276. me.currentRptPageRst = pageRst;
  277. me.maxPages = pageRst.items.length;
  278. me.currentPage = 1;
  279. me.displayPageValue();
  280. let size = JpcCanvasOutput.getReportSizeInPixel(me.currentRptPageRst, getScreenDPI());
  281. canvas.width = size[0] + 20;
  282. if (size[1] > size[0]) {
  283. canvas.height = size[1] + 100;
  284. } else {
  285. canvas.height = size[1] + 50;
  286. }
  287. me.showPage(1, canvas);
  288. } else {
  289. //返回了无数据表
  290. JpcCanvasOutput.cleanCanvas(canvas);
  291. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  292. }
  293. }, function(err){
  294. hintBox.unWaitBox();
  295. }, function(ex){
  296. hintBox.unWaitBox();
  297. }
  298. );
  299. },
  300. requestPrjFolder: function () {
  301. //$("#show_project_folder").trigger("click");
  302. let me = zTreeOprObj;
  303. hintBox.waitBox();
  304. $.ajax({
  305. type:"POST",
  306. url: '/pm/api/getProjects',
  307. data: {'data': JSON.stringify({"user_id": userID, "compilation": projectObj.project.projectInfo.compilation})},
  308. dataType: 'json',
  309. cache: false,
  310. timeout: 15000,
  311. success: function(result){
  312. hintBox.unWaitBox();
  313. if (result.error === 0) {
  314. //console.log(result.data);
  315. let currPrjParentID = projectObj.project.projectInfo.ParentID;
  316. let selectedProjects = [];
  317. for (let prj of result.data) {
  318. if (currPrjParentID === prj.ParentID) {
  319. selectedProjects.push({name: prj.name, ID: prj.ID});
  320. }
  321. }
  322. $("#show_project_folder").trigger("click");
  323. me.prjFolderTreeObj = $.fn.zTree.init($("#prjFolderTree"), rpt_prj_folder_setting, selectedProjects);
  324. me.prjFolderTreeObj.expandAll(true);
  325. } else {
  326. alert('error: ' + result.message);
  327. }
  328. },
  329. error: function(jqXHR, textStatus, errorThrown){
  330. hintBox.unWaitBox();
  331. alert('error ' + textStatus + " " + errorThrown);
  332. }
  333. });
  334. },
  335. requestBillsSummaryRpt: function () {
  336. let me = zTreeOprObj;
  337. let nodes = me.prjFolderTreeObj.getCheckedNodes(true);
  338. if (nodes.length > 0) {
  339. hintBox.waitBox();
  340. let params = {};
  341. params.pageSize = rptControlObj.getCurrentPageSize();
  342. params.rpt_tpl_id = me.currentNode.refId;
  343. params.custCfg = me.reportPageCfg;
  344. params.prjIds = [];
  345. for (let node of nodes) {
  346. params.prjIds.push(node.ID);
  347. }
  348. CommonAjax.postEx("report_api/getBillsSummaryReport", params, 26000, true,
  349. function(result){
  350. hintBox.unWaitBox();
  351. let pageRst = result;
  352. let canvas = document.getElementById("rptCanvas");
  353. if (pageRst && pageRst.items && pageRst.items.length > 0) {
  354. me.resetAfter(pageRst);
  355. me.currentRptPageRst = pageRst;
  356. me.maxPages = pageRst.items.length;
  357. me.currentPage = 1;
  358. me.displayPageValue();
  359. let size = JpcCanvasOutput.getReportSizeInPixel(me.currentRptPageRst, getScreenDPI());
  360. canvas.width = size[0] + 20;
  361. if (size[1] > size[0]) {
  362. canvas.height = size[1] + 100;
  363. } else {
  364. canvas.height = size[1] + 50;
  365. }
  366. me.showPage(1, canvas);
  367. } else {
  368. //返回了无数据表
  369. JpcCanvasOutput.cleanCanvas(canvas);
  370. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  371. }
  372. }, function(err){
  373. hintBox.unWaitBox();
  374. }, function(ex){
  375. hintBox.unWaitBox();
  376. }
  377. );
  378. }
  379. },
  380. showPage: function (pageNum, canvas) {
  381. let me = zTreeOprObj;
  382. if (pageNum >= 1 && pageNum <= me.maxPages) {
  383. me.currentPage = pageNum;
  384. JpcCanvasOutput.cleanCanvas(canvas);
  385. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  386. JpcCanvasOutput.drawToCanvas(me.currentRptPageRst, canvas, me.currentPage);
  387. }
  388. me.displayPageValue();
  389. },
  390. displayPageValue: function() {
  391. let me = zTreeOprObj;
  392. $("#rpt_page_num").get(0).value = me.currentPage + "/" + me.maxPages;
  393. }
  394. };
  395. let canvasOprObj = {
  396. canvasOnMouseMove: function (event) {
  397. if (zTreeOprObj.currentNode) {
  398. let x = event.offsetX - JpcCanvasOutput.offsetX, canvas = event.originalTarget;
  399. if (!(canvas)) canvas = event.target; //chrome浏览器不认event.originalTarget,只认event.target或event.currentTarget
  400. if (x < FIRST_PAGE_OFFSET) {
  401. canvas.style.cursor = "url(/web/building_saas/img/FirstPageSimple.cur), auto";
  402. } else if (x < PRE_PAGE_OFFSET) {
  403. canvas.style.cursor = "url(/web/building_saas/img/PreviousPageSimple.cur), auto";
  404. } else if ((canvas.width - x) < LAST_PAGE_OFFSET) {
  405. canvas.style.cursor = "url(/web/building_saas/img/LastPageSimple.cur), auto";
  406. } else if ((canvas.width - x) < NEXT_PAGE_OFFSET) {
  407. canvas.style.cursor = "url(/web/building_saas/img/NextPageSimple.cur), auto";
  408. } else {
  409. canvas.style.cursor = "";
  410. }
  411. }
  412. },
  413. canvasOnClick: function(event){
  414. if (zTreeOprObj.currentNode) {
  415. let x = event.offsetX - JpcCanvasOutput.offsetX, canvas = event.originalTarget;
  416. if (!(canvas)) canvas = event.target; //chrome浏览器不认event.originalTarget,只认event.target或event.currentTarget
  417. if (x < FIRST_PAGE_OFFSET) {
  418. zTreeOprObj.showPage(1, canvas);
  419. } else if (x < PRE_PAGE_OFFSET) {
  420. zTreeOprObj.showPage(zTreeOprObj.currentPage - 1, canvas);
  421. } else if ((canvas.width - x) < LAST_PAGE_OFFSET) {
  422. zTreeOprObj.showPage(zTreeOprObj.maxPages, canvas);
  423. } else if ((canvas.width - x) < NEXT_PAGE_OFFSET) {
  424. zTreeOprObj.showPage(zTreeOprObj.currentPage + 1, canvas);
  425. }
  426. }
  427. }
  428. };
  429. let rptControlObj = {
  430. currentOutputType: "Excel",
  431. currentDownloadUrl: null,
  432. currentDownloadIdx: 0,
  433. getCurrentPageSize: function() {
  434. // let rst = "A4";
  435. let rst = document.getElementById("btnRptPageSize").innerHTML.trim();
  436. //btnRptPageSize
  437. return rst;
  438. },
  439. getCurrentOrientation: function() {
  440. // let rst = "横向";
  441. let rst = document.getElementById("btnRptOrientation").innerHTML.trim();
  442. return rst;
  443. },
  444. getCurrentReportOption: function() {
  445. //
  446. },
  447. changeType: function(newType) {
  448. let me = rptControlObj;
  449. let excelDom = document.getElementById("EXCEL_TYPE");
  450. let pdfDom = document.getElementById("PDF_TYPE");
  451. if (newType === "Excel") {
  452. excelDom.className = "btn btn-block btn-primary";
  453. pdfDom.className = "btn btn-block btn-outline-secondary";
  454. me.currentOutputType = newType;
  455. } else if (newType === "PDF") {
  456. excelDom.className = "btn btn-block btn-outline-secondary";
  457. pdfDom.className = "btn btn-block btn-primary";
  458. me.currentOutputType = newType;
  459. } else {
  460. //me.currentOutputType = newType;
  461. }
  462. },
  463. outputRpt: function() {
  464. let me = rptControlObj;
  465. if (me.currentOutputType === "Excel") {
  466. me.getExcel();
  467. } else if (me.currentOutputType === "PDF") {
  468. me.getPDF();
  469. } else {
  470. //other types if needed.
  471. }
  472. },
  473. getAllInOneBook: function () {
  474. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  475. let me = rptControlObj;
  476. let orgRptName = projectObj.project.projectInfo.name;
  477. let refRptTplIds = [];
  478. for (let node of zTreeOprObj.checkedRptTplNodes) {
  479. refRptTplIds.push(node.refId);
  480. }
  481. let params = {};
  482. params.prj_id = projectObj.project.projectInfo.ID;
  483. params.rpt_ids = refRptTplIds;
  484. params.rptName = orgRptName;
  485. params.pageSize = me.getCurrentPageSize();
  486. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  487. params.custCfg = zTreeOprObj.reportPageCfg;
  488. params.option = "normal";
  489. CommonAjax.postEx("report_api/createExcelFilesInOneBook", params, 20000, true, function(result){
  490. if (result) {
  491. let uuIdUrls = [];
  492. let uuIdUrl = "/report_api/getFileByUUID/" + result.uuid + "/" + stringUtil.replaceAll(result.reportName, "#", "_") + "/xlsx";
  493. uuIdUrls.push(uuIdUrl);
  494. downloadReport(uuIdUrls);
  495. } else {
  496. //
  497. }
  498. }, null, null
  499. );
  500. }
  501. },
  502. getAllIndividualExcelBook: function () {
  503. let me = rptControlObj;
  504. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  505. let rpt_ids = [], rpt_names = [];
  506. for (let tplNode of zTreeOprObj.checkedRptTplNodes) {
  507. rpt_ids.push(tplNode.refId);
  508. rpt_names.push(tplNode.name)
  509. }
  510. let params = {};
  511. params.prj_id = projectObj.project.projectInfo.ID;
  512. params.rpt_ids = rpt_ids;
  513. params.rpt_names = rpt_names;
  514. params.pageSize = me.getCurrentPageSize();
  515. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  516. params.isOneSheet = true;
  517. params.custCfg = zTreeOprObj.reportPageCfg;
  518. params.option = "normal";
  519. CommonAjax.postEx("report_api/createExcelFiles", params, 20000, true, function(result){
  520. if (result) {
  521. let uuIdUrls = [];
  522. for (let uuIdObj of result) {
  523. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/xlsx";
  524. uuIdUrls.push(uuIdUrl);
  525. }
  526. downloadReport(uuIdUrls);
  527. } else {
  528. //
  529. }
  530. }, null, null
  531. );
  532. }
  533. },
  534. checkAndGetExcel: function () {
  535. if (zTreeOprObj.treeObj) {
  536. let chkNodes = zTreeOprObj.treeObj.getCheckedNodes(true);
  537. if (chkNodes.length > 0) {
  538. $("#show_excel_output_cfg").trigger("click");
  539. } else {
  540. rptControlObj.getAllIndividualExcelBook();
  541. }
  542. }
  543. },
  544. getExcel: function () {
  545. let me = rptControlObj;
  546. if ($("#excelExportType_AllInOneBook").get(0).checked) {
  547. me.getAllInOneBook();
  548. } else if ($("#excelExportType_IndividualBook").get(0).checked) {
  549. me.getAllIndividualExcelBook();
  550. }
  551. },
  552. getPDF: function() {
  553. let me = rptControlObj;
  554. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  555. let rpt_ids = [], rpt_names = [];
  556. for (let tplNode of zTreeOprObj.checkedRptTplNodes) {
  557. rpt_ids.push(tplNode.refId);
  558. rpt_names.push(tplNode.name)
  559. }
  560. let params = {};
  561. params.prj_id = projectObj.project.projectInfo.ID;
  562. params.rpt_ids = rpt_ids;
  563. params.rpt_names = rpt_names;
  564. params.pageSize = me.getCurrentPageSize();
  565. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  566. params.custCfg = zTreeOprObj.reportPageCfg;
  567. params.option = "normal";
  568. CommonAjax.postEx("report_api/createPdfFiles", params, 20000, true, function(result){
  569. if (result) {
  570. let uuIdUrls = [];
  571. for (let uuIdObj of result) {
  572. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/pdf";
  573. uuIdUrls.push(uuIdUrl);
  574. }
  575. downloadReport(uuIdUrls);
  576. } else {
  577. //
  578. }
  579. }, null, null
  580. );
  581. }
  582. },
  583. firstPage: function(dom) {
  584. let canvas = document.getElementById("rptCanvas");
  585. zTreeOprObj.showPage(1, canvas);
  586. },
  587. prePage: function(dom) {
  588. let canvas = document.getElementById("rptCanvas");
  589. zTreeOprObj.showPage(zTreeOprObj.currentPage - 1, canvas);
  590. },
  591. nextPage: function(dom) {
  592. let canvas = document.getElementById("rptCanvas");
  593. zTreeOprObj.showPage(zTreeOprObj.currentPage + 1, canvas);
  594. },
  595. lastPage: function(dom) {
  596. let me = zTreeOprObj;
  597. let canvas = document.getElementById("rptCanvas");
  598. zTreeOprObj.showPage(me.maxPages, canvas);
  599. },
  600. onKeydown: function (event, dom) {
  601. let me = zTreeOprObj, keyPressed = null;
  602. if (window.event) {
  603. keyPressed = window.event.keyCode; // IE/Chrome
  604. } else {
  605. keyPressed = event.which; // Firefox
  606. }
  607. if (keyPressed === 13) {
  608. let pageNum = 1;
  609. try {
  610. pageNum = parseInt(dom.value);
  611. } catch (e) {
  612. pageNum = 1;
  613. }
  614. let canvas = document.getElementById("rptCanvas");
  615. if (pageNum < 1) {
  616. pageNum = 1;
  617. } else if (pageNum > me.maxPages) {
  618. pageNum = me.maxPages;
  619. }
  620. zTreeOprObj.showPage(pageNum, canvas);
  621. return false;
  622. }
  623. },
  624. changeMargin: function(marginPropStr, marginDom) {
  625. zTreeOprObj.reportPageCfg.margins[marginPropStr] = marginDom.value;
  626. },
  627. changeFontMain: function(CfgDispName, fontProperty, fontDom) {
  628. for (let font of zTreeOprObj.reportPageCfg.fonts) {
  629. if (font["CfgDispName"] === CfgDispName) {
  630. font[fontProperty] = fontDom.value;
  631. break;
  632. }
  633. }
  634. },
  635. changeCfgOption: function (optStr, dom) {
  636. zTreeOprObj.reportPageCfg[optStr] = dom.checked;
  637. },
  638. changeFontAdhoc: function(CfgDispName, fontProperty, fontDom) {
  639. for (let font of zTreeOprObj.reportPageCfg.fonts) {
  640. if (font["CfgDispName"] === CfgDispName) {
  641. if (font[fontProperty] === 'T') {
  642. font[fontProperty] = 'F';
  643. fontDom.className = "btn btn-sm btn-outline-secondary";
  644. } else {
  645. font[fontProperty] = 'T';
  646. fontDom.className = "btn btn-sm btn-outline-secondary active";
  647. }
  648. break;
  649. }
  650. }
  651. },
  652. restoreCustCFG: function () {
  653. let me = this;
  654. zTreeOprObj.renderRptCfg(zTreeOprObj.defReportPageCfg);
  655. zTreeOprObj.extractRptCfg(zTreeOprObj.reportPageCfg);
  656. me.saveCustCfg();
  657. },
  658. saveCustCfg: function() {
  659. let params = {};
  660. params.custCfg = zTreeOprObj.reportPageCfg;
  661. CommonAjax.postEx("report_tpl_api/saveCustomerCfg", params, 20000, true, function(result){
  662. // alert("Save successfully!");
  663. $("#update_msg_response")[0].style.color = "green";
  664. $("#update_msg_response")[0].innerHTML = " (保存成功!)";
  665. setTimeout(function(){
  666. $("#update_msg_response")[0].innerHTML = "";
  667. }, 1000);
  668. }, function (failRst) {
  669. $("#update_msg_response")[0].style.color = "red";
  670. $("#update_msg_response")[0].innerHTML = " (保存失败!)";
  671. setTimeout(function(){
  672. $("#update_msg_response")[0].innerHTML = "";
  673. }, 1000);
  674. }, null
  675. );
  676. },
  677. confirmCfgChange: function() {
  678. let treeNode = zTreeOprObj.currentNode;
  679. if (treeNode.nodeType === TPL_TYPE_TEMPLATE && treeNode.refId > 0) {
  680. let params = {};
  681. params.pageSize = rptControlObj.getCurrentPageSize();
  682. params.rpt_tpl_id = treeNode.refId;
  683. params.prj_id = projectObj.project.projectInfo.ID;
  684. params.custCfg = zTreeOprObj.reportPageCfg;
  685. zTreeOprObj.requestReport(params);
  686. }
  687. }
  688. };
  689. function downloadReport(urls) {
  690. //考虑到多个报表下载,一些浏览器(如chrome)不允许一下子下载多个文件,得缓缓处理,统一在这处理
  691. rptControlObj.currentDownloadUrl = null;
  692. rptControlObj.currentDownloadIdx = 0;
  693. let private_download = function() {
  694. if (rptControlObj.currentDownloadIdx >= 0 && rptControlObj.currentDownloadIdx < urls.length) {
  695. rptControlObj.currentDownloadUrl = urls[rptControlObj.currentDownloadIdx];
  696. rptControlObj.currentDownloadIdx++;
  697. window.location = rptControlObj.currentDownloadUrl;
  698. setTimeout(private_download, 2000);
  699. }
  700. }
  701. private_download();
  702. }