rpt_main.js 35 KB

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