rpt_main.js 64 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336
  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.getAvailablePageSize();
  19. zTreeOprObj.getReportTemplateTree();
  20. zTreeOprObj.selectedPrjIDs = [];
  21. me.hasInitialized = true;
  22. let canvas = document.getElementById("rptCanvas");
  23. canvas.onclick = canvasOprObj.canvasOnClick;
  24. canvas.onmousemove = canvasOprObj.canvasOnMouseMove;
  25. if (JpcJsPDFHelper.doc === null) {
  26. JpcJsPDFHelper.initialize('p', 'pt', 'a4');
  27. }
  28. // dynamicLoadJs('/lib/jspdf/SmartSimsun-normal.js');
  29. // dynamicLoadJs('/lib/jspdf/SmartSimsun-bold.js', me.pdfFontSimsunCallBack);
  30. // dynamicLoadJs('http://d2.smartcost.com.cn/cach/SmartSimsun-normal.js');
  31. // dynamicLoadJs('http://d2.smartcost.com.cn/cach/SmartSimsun-bold.js', me.pdfFontSimsunCallBack);
  32. }
  33. },
  34. pdfFontSimsunCallBack: function() {
  35. rptTplObj.pdfFont['SmartSimsun'].push('normal');
  36. rptTplObj.pdfFont['SmartSimsun'].push('bold');
  37. },
  38. pdfFontSimkaiCallBack: function() {
  39. rptTplObj.pdfFont['simkai'].push('normal');
  40. rptTplObj.pdfFont['simkai'].push('bold');
  41. },
  42. pdfFontSimheiCallBack: function() {
  43. rptTplObj.pdfFont['simhei'].push('normal');
  44. rptTplObj.pdfFont['simhei'].push('bold');
  45. }
  46. }
  47. let zTreeOprObj = {
  48. treeObj: null,
  49. prjFolderTreeObj: null,
  50. currentNode: null,
  51. checkedRptTplNodes: null,
  52. currentRptPageRst: null,
  53. reportPageCfg: null,
  54. defReportPageCfg: null,
  55. currentPage: 1,
  56. maxPages: 0,
  57. selectedPrjIDs: [],
  58. isFreeUser: true,
  59. waterMarks: [],
  60. countChkedRptTpl: function () {
  61. let me = zTreeOprObj;
  62. if (me.treeObj) {
  63. me.checkedRptTplNodes = [];
  64. let chkNodes = me.treeObj.getCheckedNodes(true), cnt = 0, hasCurrentNode = false;
  65. for (let node of chkNodes) {
  66. if (node.nodeType === TPL_TYPE_TEMPLATE) {
  67. cnt++;
  68. me.checkedRptTplNodes.push(node);
  69. if (me.currentNode === node) hasCurrentNode = true;
  70. }
  71. }
  72. if (!hasCurrentNode && cnt === 0 && me.currentNode !== null) {
  73. //这里根据实际需求再做处理
  74. cnt++;
  75. me.checkedRptTplNodes.push(me.currentNode);
  76. }
  77. $("#export_div").find("span").each(function(cIdx,elementSpan){
  78. elementSpan.innerText = cnt;
  79. });
  80. $("#print_div").find("span").each(function(cIdx,elementSpan){
  81. elementSpan.innerText = cnt;
  82. });
  83. }
  84. },
  85. getReportTemplateTree: function() {
  86. let me = zTreeOprObj, params = {};
  87. params.engineerId = projectObj.project.projectInfo.property.engineering;
  88. let private_chk_hide = function (chkTplItem) {
  89. //考虑未来拓展,统一在此判断报表模板是否显示
  90. let rst = false;
  91. // if (chkTplItem.hasOwnProperty('flags') && chkTplItem.flags.hasOwnProperty('taxType') && chkTplItem.flags['taxType'] !== null &&
  92. // parseInt(chkTplItem.flags['taxType']) !== parseInt(projectObj.project.projectInfo.property.taxType)) {
  93. // rst = true;
  94. // }
  95. //重庆养护系统的判断逻辑有所不同
  96. if (chkTplItem.hasOwnProperty('flags') && chkTplItem.flags.hasOwnProperty('valuationType') && chkTplItem.flags['valuationType'] !== null &&
  97. chkTplItem.flags['valuationType'] !== projectObj.project.projectInfo.property.valuationType) {
  98. rst = true;
  99. }
  100. return rst;
  101. };
  102. // projectObj.project.projectInfo.property.taxType === 1 //1: 一般计税 2: 简易计税
  103. CommonAjax.postEx("report_tpl_api/getRptTplTree", params, 20000, true, function(result){
  104. let private_remove_hide_item = function (items, nlv) {
  105. if (items && items.length > 0) {
  106. for (let i = items.length - 1; i >= 0; i--) {
  107. if (!(items[i].released) && items[i].nodeType === 2) {
  108. items.splice(i, 1);
  109. } else if(private_chk_hide(items[i])) {
  110. items.splice(i, 1);
  111. } else {
  112. if (items[i].items && items[i].items.length > 0) {
  113. private_remove_hide_item(items[i].items, nlv + 1);
  114. if (items[i].items.length === 0 && nlv > 0) {
  115. items.splice(i, 1);
  116. }
  117. }
  118. }
  119. }
  120. }
  121. }
  122. let nodeLv = 0;
  123. zTreeOprObj.isFreeUser = result.isFreeUser;
  124. zTreeOprObj.waterMarks = result.waterMarks;
  125. private_remove_hide_item(result.data, nodeLv);
  126. for (let topNode of result.data) {
  127. if (topNode.userId === "-100") {
  128. topNode.name = topNode.name + " - 标准报表";
  129. } else {
  130. topNode.name = topNode.name + " - 定制报表";
  131. }
  132. }
  133. zTreeHelper.createTreeDirectly(result.data, rpt_tpl_setting, "rptTplTree", me);
  134. me.refreshNodes();
  135. }, null, null);
  136. },
  137. getAvailablePageSize: function() {
  138. let me = zTreeOprObj, params = {};
  139. params.engineerId = projectObj.project.projectInfo.property.engineering;
  140. CommonAjax.postEx("report_tpl_api/getAvailablePageSize", params, 2000, true, function(result){
  141. if (result) {
  142. // console.log(result);
  143. if (result.length > 0) {
  144. $('#btnRptPageSize')[0].innerHTML = result[0];
  145. let divDom = $('#divRptPageSize');
  146. divDom.empty();
  147. for (let pIdx = 1; pIdx < result.length; pIdx++) {
  148. //<a class="dropdown-item" id="hrefRptPageSize_A3" style="cursor:pointer" onclick="zTreeOprObj.changePageSize(this)">A3</a>
  149. let aDomStr = `<a class="dropdown-item" id="hrefRptPageSize_${result[pIdx]}" style="cursor:pointer" onclick="zTreeOprObj.changePageSize(this)">${result[pIdx]}</a>`;
  150. divDom.append(aDomStr);
  151. }
  152. }
  153. } else {
  154. //
  155. }
  156. }, null, null
  157. );
  158. },
  159. getCustomerCfg: function() {
  160. let me = zTreeOprObj, params = {};
  161. params.engineerId = projectObj.project.projectInfo.property.engineering;
  162. CommonAjax.postEx("report_tpl_api/getCustomizeCfg", params, 20000, true, function(result){
  163. if (result) {
  164. me.defReportPageCfg = result[0];
  165. me.reportPageCfg = result[1];
  166. me.iniFontCfgDom(me.reportPageCfg);
  167. me.renderRptCfg(result[1]);
  168. } else {
  169. me.reportPageCfg = null;
  170. me.defReportPageCfg = null;
  171. }
  172. }, null, null
  173. );
  174. },
  175. iniFontCfgDom: function (cfg) {
  176. for (let font of cfg.fonts) {
  177. let domArrs = [];
  178. let fontPropSuffix = fontSuffixMapObj[font.CfgDispName];
  179. domArrs.push("<div class='row mb-1'>");
  180. //1. label
  181. domArrs.push("<div class='col-3'>" + font.CfgDispName + "</div>");
  182. //2. font name
  183. domArrs.push("<div class='col-3'>");
  184. domArrs.push("<select class='form-control input-sm' id='fontName_" + fontPropSuffix + "' onchange='rptControlObj.changeFontMain(\"" + font.CfgDispName + "\", \"Name\", this)'>");
  185. domArrs.push("<option>宋体</option><option>楷体</option><option>黑体</option>");
  186. domArrs.push("</select>");
  187. domArrs.push("</div>");
  188. //3. font height
  189. domArrs.push("<div class='col-3'>");
  190. domArrs.push("<input class='form-control input-sm' id='fontHeight_" + fontPropSuffix + "' type='number' value='30' step='1' min='6' max='66' " +
  191. "onchange='rptControlObj.changeFontMain(\"" + font.CfgDispName + "\", \"FontHeight\", this)' " +
  192. "onkeyup='rptControlObj.changeFontMain(\"" + font.CfgDispName + "\", \"FontHeight\", this)'>");
  193. domArrs.push("</div>");
  194. //4. font bold italic underline
  195. domArrs.push("<div class='col-3'>");
  196. 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>");
  197. 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>");
  198. 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>");
  199. domArrs.push("</div>");
  200. //
  201. domArrs.push("</div>");
  202. $(domArrs.join("")).insertBefore($("#font_cfg_blank_flag"));
  203. }
  204. },
  205. renderRptCfg: function (cfg) {
  206. $("#elementMargin_Left").get(0).value = cfg.margins.Left;
  207. $("#elementMargin_Right").get(0).value = cfg.margins.Right;
  208. $("#elementMargin_Top").get(0).value = cfg.margins.Top;
  209. $("#elementMargin_Bottom").get(0).value = cfg.margins.Bottom;
  210. for (let font of cfg.fonts) {
  211. let fontPropSuffix = fontSuffixMapObj[font.CfgDispName];
  212. document.getElementById("fontName_" + fontPropSuffix).value = font.Name;
  213. document.getElementById("fontHeight_" + fontPropSuffix).value = font.FontHeight;
  214. document.getElementById("font_bold_" + fontPropSuffix).className = (font.FontBold === "T")?"btn btn-sm btn-outline-secondary active":"btn btn-sm btn-outline-secondary";
  215. document.getElementById("font_italic_" + fontPropSuffix).className = (font.FontItalic === "T")?"btn btn-sm btn-outline-secondary active":"btn btn-sm btn-outline-secondary";
  216. document.getElementById("font_underline_" + fontPropSuffix).className = (font.FontUnderline === "T")?"btn btn-sm btn-outline-secondary active":"btn btn-sm btn-outline-secondary";
  217. }
  218. document.getElementById("rpt_vertical_line").checked = cfg.showVerticalLine;
  219. document.getElementById("rpt_narrow").checked = cfg.isNarrow;
  220. // document.getElementById("rpt_narrow").checked = false;
  221. document.getElementById("rpt_fill_zero").checked = cfg.fillZero;
  222. },
  223. extractRptCfg: function (cfg) {
  224. cfg.margins.Left = $("#elementMargin_Left").get(0).value;
  225. cfg.margins.Right = $("#elementMargin_Right").get(0).value;
  226. cfg.margins.Top = $("#elementMargin_Top").get(0).value;
  227. cfg.margins.Bottom = $("#elementMargin_Bottom").get(0).value;
  228. for (let font of cfg.fonts) {
  229. let fontPropSuffix = fontSuffixMapObj[font.CfgDispName];
  230. font.Name = document.getElementById("fontName_" + fontPropSuffix).value;
  231. font.FontHeight = document.getElementById("fontHeight_" + fontPropSuffix).value;
  232. font.FontBold = (document.getElementById("font_bold_" + fontPropSuffix).className === "btn btn-sm btn-outline-secondary active")?"T":"F";
  233. font.FontItalic = (document.getElementById("font_italic_" + fontPropSuffix).className === "btn btn-sm btn-outline-secondary active")?"T":"F";
  234. font.FontUnderline = (document.getElementById("font_underline_" + fontPropSuffix).className === "btn btn-sm btn-outline-secondary active")?"T":"F";
  235. }
  236. cfg.showVerticalLine = document.getElementById("rpt_vertical_line").checked;
  237. cfg.isNarrow = document.getElementById("rpt_narrow").checked;
  238. cfg.fillZero = document.getElementById("rpt_fill_zero").checked;
  239. },
  240. refreshNodes: function() {
  241. let me = this;
  242. let private_setupIsParent = function(node){
  243. node.isParent = (node.nodeType === RT.NodeType.NODE || node.level === 0);
  244. if (node.items && node.items.length) {
  245. for (let i = 0; i < node.items.length; i++) {
  246. private_setupIsParent(node.items[i]);
  247. }
  248. }
  249. };
  250. let topNodes = me.treeObj.getNodes();
  251. for (let i = 0; i < topNodes.length; i++) {
  252. private_setupIsParent(topNodes[i]);
  253. }
  254. me.treeObj.refresh();
  255. },
  256. onCheck: function(event, treeId, treeNode) {
  257. zTreeOprObj.countChkedRptTpl();
  258. },
  259. onClick: function(event,treeId,treeNode) {
  260. let me = zTreeOprObj;
  261. if (treeNode.nodeType === TPL_TYPE_TEMPLATE && treeNode.refId > 0) {
  262. me.currentNode = treeNode;
  263. if (treeNode.hasOwnProperty('flags') && treeNode.flags.hasOwnProperty('reportType') && treeNode['flags']['reportType'] !== 'NA' && treeNode['flags']['reportType'] !== null) {
  264. if (treeNode['flags']['reportType'] === 'billSummary') {
  265. me.requestPrjFolderForBillsSummary();
  266. } else if (treeNode['flags']['reportType'] === 'gljSummary') {
  267. me.requestPrjFolderForGljSummary();
  268. }
  269. } else {
  270. let params = {};
  271. let pageSize = rptControlObj.getCurrentPageSize();
  272. params.pageSize = pageSize;
  273. params.rpt_tpl_id = treeNode.refId;
  274. params.prj_id = projectObj.project.projectInfo.ID;
  275. params.custCfg = me.reportPageCfg;
  276. me.requestNormalReport(params);
  277. }
  278. me.countChkedRptTpl();
  279. }
  280. },
  281. changePageSize: function(dom) {
  282. let me = zTreeOprObj,
  283. targetDom = document.getElementById("btnRptPageSize");
  284. let tmpStr = targetDom.innerHTML.trim();
  285. targetDom.innerHTML = dom.innerHTML.trim();
  286. dom.innerHTML = tmpStr;
  287. me.changeCfg();
  288. },
  289. changeOrientation: function(dom) {
  290. let me = zTreeOprObj,
  291. targetDom = document.getElementById("btnRptOrientation");
  292. let tmpStr = targetDom.innerHTML.trim();
  293. targetDom.innerHTML = dom.innerHTML.trim();
  294. dom.innerHTML = tmpStr;
  295. me.changeCfg();
  296. },
  297. changeCfg: function() {
  298. let me = zTreeOprObj;
  299. if (me.currentNode) {
  300. if (me.currentNode.hasOwnProperty('flags') && me.currentNode.flags.hasOwnProperty('reportType') && me.currentNode['flags']['reportType'] !== 'NA' && me.currentNode['flags']['reportType'] !== null) {
  301. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  302. if (me.currentNode['flags']['reportType'] === 'billSummary') {
  303. refBillSumPrjsIds.push(me.currentNode.refId);
  304. } else if (me.currentNode['flags']['reportType'] === 'gljSummary') {
  305. refGljSumPrjsIds.push(me.currentNode.refId);
  306. }
  307. if (zTreeOprObj.selectedPrjIDs.length > 0) {
  308. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  309. params.pageSize = rptControlObj.getCurrentPageSize();
  310. params.orientation = rptControlObj.getCurrentOrientation();
  311. params.rpt_ids = refRptTplIds;
  312. params.rpt_bill_tpl_ids = refBillSumPrjsIds;
  313. params.rpt_glj_tpl_ids = refGljSumPrjsIds;
  314. params.custCfg = me.reportPageCfg;
  315. CommonAjax.postEx("report_api/getMultiReports", params, 300000, true,
  316. function(result){
  317. hintBox.unWaitBox();
  318. let pageRst = result[0];
  319. let canvas = document.getElementById("rptCanvas");
  320. if (pageRst && pageRst.items && pageRst.items.length > 0) {
  321. me.resetAfter(pageRst);
  322. me.currentRptPageRst = pageRst;
  323. me.maxPages = pageRst.items.length;
  324. me.currentPage = 1;
  325. me.displayPageValue();
  326. let size = JpcCanvasOutput.getReportSizeInPixel(me.currentRptPageRst, getScreenDPI());
  327. canvas.width = size[0] + 20;
  328. if (size[1] > size[0]) {
  329. canvas.height = size[1] + 100;
  330. } else {
  331. canvas.height = size[1] + 50;
  332. }
  333. me.showPage(1, canvas);
  334. } else {
  335. //返回了无数据表
  336. JpcCanvasOutput.cleanCanvas(canvas);
  337. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  338. }
  339. }, function(err){
  340. hintBox.unWaitBox();
  341. }, function(ex){
  342. hintBox.unWaitBox();
  343. }
  344. );
  345. } else {
  346. if (me.currentNode['flags']['reportType'] === 'billSummary') {
  347. me.requestPrjFolderForBillsSummary();
  348. } else if (me.currentNode['flags']['reportType'] === 'gljSummary') {
  349. me.requestPrjFolderForGljSummary();
  350. }
  351. }
  352. } else {
  353. let params = {};
  354. params.pageSize = rptControlObj.getCurrentPageSize();
  355. params.orientation = rptControlObj.getCurrentOrientation();
  356. params.rpt_tpl_id = me.currentNode.refId;
  357. params.prj_id = projectObj.project.projectInfo.ID;
  358. params.custCfg = me.reportPageCfg;
  359. me.requestNormalReport(params);
  360. }
  361. }
  362. },
  363. resetAfter: function (pageRst) {
  364. let size = pageRst[JV.NODE_PAGE_INFO][JV.NODE_PAGE_SIZE].slice(0);
  365. if (size[0] > size[1]) {
  366. document.getElementById("btnRptOrientation").innerHTML = "横向";
  367. document.getElementById("hrefRptOrientation").innerHTML = "纵向";
  368. } else {
  369. document.getElementById("btnRptOrientation").innerHTML = "纵向";
  370. document.getElementById("hrefRptOrientation").innerHTML = "横向";
  371. }
  372. },
  373. requestNormalReport: function (params) {
  374. let me = zTreeOprObj;
  375. hintBox.waitBox();
  376. CommonAjax.postEx("report_api/getReport", params, 60000, true,
  377. function(result){
  378. hintBox.unWaitBox();
  379. let pageRst = result;
  380. let canvas = document.getElementById("rptCanvas");
  381. if (pageRst && pageRst.items && pageRst.items.length > 0) {
  382. me.resetAfter(pageRst);
  383. me.currentRptPageRst = pageRst;
  384. me.maxPages = pageRst.items.length;
  385. me.currentPage = 1;
  386. me.displayPageValue();
  387. let size = JpcCanvasOutput.getReportSizeInPixel(me.currentRptPageRst, getScreenDPI());
  388. canvas.width = size[0] + 20;
  389. if (size[1] > size[0]) {
  390. canvas.height = size[1] + 100;
  391. } else {
  392. canvas.height = size[1] + 50;
  393. }
  394. me.showPage(1, canvas);
  395. } else {
  396. //返回了无数据表
  397. JpcCanvasOutput.cleanCanvas(canvas);
  398. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  399. }
  400. }, function(err){
  401. hintBox.unWaitBox();
  402. }, function(ex){
  403. hintBox.unWaitBox();
  404. }
  405. );
  406. },
  407. requestPrjFolderCommon: function () {
  408. let me = zTreeOprObj;
  409. hintBox.waitBox();
  410. $.ajax({
  411. type:"POST",
  412. url: '/pm/api/getProjects',
  413. data: {'data': JSON.stringify({"user_id": userID, "compilation": projectObj.project.projectInfo.compilation})},
  414. dataType: 'json',
  415. cache: false,
  416. timeout: 15000,
  417. success: function(result){
  418. hintBox.unWaitBox();
  419. if (result.error === 0) {
  420. //console.log(result.data);
  421. let currPrjParentID = projectObj.project.projectInfo.ParentID;
  422. let selectedProjects = [];
  423. let targetData = [];
  424. tree_Data_Helper.getFlatArray(tree_Data_Helper.buildTreeNodeDirectly(result.data, false), targetData);
  425. for (let prj of targetData) {
  426. if (currPrjParentID === prj.ParentID) {
  427. selectedProjects.push({name: prj.name, ID: prj.ID});
  428. }
  429. }
  430. $("#show_project_folder").trigger("click");
  431. let topItem = [{name: '所有相关项目', items: selectedProjects}];
  432. // me.prjFolderTreeObj = $.fn.zTree.init($("#prjFolderTree"), rpt_prj_folder_setting, selectedProjects);
  433. me.prjFolderTreeObj = $.fn.zTree.init($("#prjFolderTree"), rpt_prj_folder_setting, topItem);
  434. me.prjFolderTreeObj.expandAll(true);
  435. } else {
  436. alert('error: ' + result.message);
  437. }
  438. },
  439. error: function(jqXHR, textStatus, errorThrown){
  440. hintBox.unWaitBox();
  441. alert('error ' + textStatus + " " + errorThrown);
  442. }
  443. });
  444. },
  445. requestPrjFolderForBillsSummary: function () {
  446. let me = zTreeOprObj;
  447. $("#divReqBillSummary")[0].style.display = "";
  448. $("#divReqGljSummary")[0].style.display = "none";
  449. $("#divReqCommonSummaryExcel")[0].style.display = "none";
  450. $("#divReqCommonSummaryMultiExcel")[0].style.display = "none";
  451. $("#divReqCommonSummaryPDF")[0].style.display = "none";
  452. me.requestPrjFolderCommon();
  453. },
  454. requestPrjFolderForGljSummary: function () {
  455. let me = zTreeOprObj;
  456. $("#divReqBillSummary")[0].style.display = "none";
  457. $("#divReqGljSummary")[0].style.display = "";
  458. $("#divReqCommonSummaryExcel")[0].style.display = "none";
  459. $("#divReqCommonSummaryMultiExcel")[0].style.display = "none";
  460. $("#divReqCommonSummaryPDF")[0].style.display = "none";
  461. me.requestPrjFolderCommon();
  462. },
  463. requestBillsSummaryRpt: function () {
  464. let me = zTreeOprObj;
  465. let nodes = me.prjFolderTreeObj.getCheckedNodes(true);
  466. if (nodes.length > 0) {
  467. if (nodes[0].level === 0) {
  468. nodes.splice(0, 1);
  469. }
  470. hintBox.waitBox();
  471. let params = {};
  472. params.pageSize = rptControlObj.getCurrentPageSize();
  473. params.rpt_tpl_id = me.currentNode.refId;
  474. params.custCfg = me.reportPageCfg;
  475. params.prjIds = [];
  476. me.selectedPrjIDs = [];
  477. for (let node of nodes) {
  478. params.prjIds.push(node.ID);
  479. me.selectedPrjIDs.push(node.ID);
  480. }
  481. CommonAjax.postEx("report_api/getBillsSummaryReport", params, 60000, true,
  482. function(result){
  483. hintBox.unWaitBox();
  484. let pageRst = result;
  485. let canvas = document.getElementById("rptCanvas");
  486. if (pageRst && pageRst.items && pageRst.items.length > 0) {
  487. me.resetAfter(pageRst);
  488. me.currentRptPageRst = pageRst;
  489. me.maxPages = pageRst.items.length;
  490. me.currentPage = 1;
  491. me.displayPageValue();
  492. let size = JpcCanvasOutput.getReportSizeInPixel(me.currentRptPageRst, getScreenDPI());
  493. canvas.width = size[0] + 20;
  494. if (size[1] > size[0]) {
  495. canvas.height = size[1] + 100;
  496. } else {
  497. canvas.height = size[1] + 50;
  498. }
  499. me.showPage(1, canvas);
  500. } else {
  501. //返回了无数据表
  502. JpcCanvasOutput.cleanCanvas(canvas);
  503. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  504. }
  505. }, function(err){
  506. hintBox.unWaitBox();
  507. }, function(ex){
  508. hintBox.unWaitBox();
  509. }
  510. );
  511. }
  512. },
  513. requestGljSummaryRpt: function () {
  514. let me = zTreeOprObj;
  515. let nodes = me.prjFolderTreeObj.getCheckedNodes(true);
  516. if (nodes.length > 0) {
  517. if (nodes[0].level === 0) {
  518. nodes.splice(0, 1);
  519. }
  520. hintBox.waitBox();
  521. let params = {};
  522. params.pageSize = rptControlObj.getCurrentPageSize();
  523. params.rpt_tpl_id = me.currentNode.refId;
  524. params.custCfg = me.reportPageCfg;
  525. params.prjIds = [];
  526. zTreeOprObj.selectedPrjIDs = [];
  527. for (let node of nodes) {
  528. params.prjIds.push(node.ID);
  529. zTreeOprObj.selectedPrjIDs.push(node.ID);
  530. }
  531. CommonAjax.postEx("report_api/getGljSummaryReport", params, 60000, true,
  532. function(result){
  533. hintBox.unWaitBox();
  534. let pageRst = result;
  535. let canvas = document.getElementById("rptCanvas");
  536. if (pageRst && pageRst.items && pageRst.items.length > 0) {
  537. me.resetAfter(pageRst);
  538. me.currentRptPageRst = pageRst;
  539. me.maxPages = pageRst.items.length;
  540. me.currentPage = 1;
  541. me.displayPageValue();
  542. let size = JpcCanvasOutput.getReportSizeInPixel(me.currentRptPageRst, getScreenDPI());
  543. canvas.width = size[0] + 20;
  544. if (size[1] > size[0]) {
  545. canvas.height = size[1] + 100;
  546. } else {
  547. canvas.height = size[1] + 50;
  548. }
  549. me.showPage(1, canvas);
  550. } else {
  551. //返回了无数据表
  552. JpcCanvasOutput.cleanCanvas(canvas);
  553. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  554. }
  555. }, function(err){
  556. hintBox.unWaitBox();
  557. }, function(ex){
  558. hintBox.unWaitBox();
  559. }
  560. );
  561. }
  562. },
  563. requestSumAndNormalRptForPDF: function () {
  564. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  565. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  566. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  567. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  568. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  569. params.rpt_names = rpt_names;
  570. params.isOneSheet = true;
  571. CommonAjax.postEx("report_api/createPdfFiles", params, WAIT_TIME_EXPORT, true, function(result){
  572. if (result) {
  573. let uuIdUrls = [];
  574. for (let uuIdObj of result) {
  575. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/pdf";
  576. uuIdUrls.push(uuIdUrl);
  577. }
  578. downloadReport(uuIdUrls);
  579. } else {
  580. //
  581. }
  582. }, null, null
  583. );
  584. },
  585. requestSumAndNormalRptForPDF_Ex: function () {
  586. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  587. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  588. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  589. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  590. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  591. params.rpt_names = rpt_names;
  592. params.isOneSheet = true;
  593. CommonAjax.postEx("report_api/getMultiReports", params, WAIT_TIME_EXPORT, true,
  594. function(result){
  595. let pageSize = rptControlObj.getCurrentPageSize();
  596. for (let idx = 0; idx < result.length; idx++) {
  597. let pageData = result[idx];
  598. JpcJsPDFHelper.outputAsPdf(pageData, pageSize, result[idx][JV.NODE_PAGE_INFO][JV.NODE_MAIN_INFO_RPT_NAME]);
  599. }
  600. },
  601. function(failRst){
  602. console.log(failRst);
  603. },
  604. function(exceptionRst){
  605. console.log(exceptionRst);
  606. }
  607. );
  608. },
  609. requestSumAndNormalRptForMultiExcel: function () {
  610. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  611. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  612. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  613. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  614. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  615. params.rpt_names = rpt_names;
  616. params.isOneSheet = true;
  617. $.bootstrapLoading.start();
  618. CommonAjax.postEx("report_api/createExcelFiles", params, WAIT_TIME_EXPORT, true, function(result){
  619. if (result) {
  620. $.bootstrapLoading.end();
  621. let uuIdUrls = [];
  622. for (let uuIdObj of result) {
  623. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/xlsx";
  624. uuIdUrls.push(uuIdUrl);
  625. }
  626. downloadReport(uuIdUrls);
  627. } else {
  628. $.bootstrapLoading.end();
  629. }
  630. },
  631. function(failRst){
  632. $.bootstrapLoading.end();
  633. console.log(failRst);
  634. },
  635. function(exceptionRst){
  636. $.bootstrapLoading.end();
  637. console.log(exceptionRst);
  638. }
  639. );
  640. },
  641. requestSumAndNormalRptForAllInOneExcel: function () {
  642. let orgRptName = projectObj.project.projectInfo.name;
  643. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  644. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, null, null, null);
  645. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  646. params.rptName = orgRptName;
  647. $.bootstrapLoading.start();
  648. CommonAjax.postEx("report_api/createExcelFilesInOneBook", params, WAIT_TIME_EXPORT, true, function(result){
  649. if (result) {
  650. $.bootstrapLoading.end();
  651. let uuIdUrls = [];
  652. let uuIdUrl = "/report_api/getFileByUUID/" + result.uuid + "/" + stringUtil.replaceAll(result.reportName, "#", "_") + "/xlsx";
  653. uuIdUrls.push(uuIdUrl);
  654. downloadReport(uuIdUrls);
  655. } else {
  656. $.bootstrapLoading.end();
  657. }
  658. },
  659. function(failRst){
  660. $.bootstrapLoading.end();
  661. console.log(failRst);
  662. },
  663. function(exceptionRst){
  664. $.bootstrapLoading.end();
  665. console.log(exceptionRst);
  666. }
  667. );
  668. },
  669. showPage: function (pageNum, canvas) {
  670. let me = zTreeOprObj;
  671. if (pageNum >= 1 && pageNum <= me.maxPages) {
  672. me.currentPage = pageNum;
  673. JpcCanvasOutput.cleanCanvas(canvas);
  674. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  675. // JpcCanvasOutput.drawWaterMarks(canvas, zTreeOprObj.waterMarks);
  676. JpcCanvasOutput.drawToCanvas(me.currentRptPageRst, canvas, me.currentPage);
  677. }
  678. me.displayPageValue();
  679. },
  680. displayPageValue: function() {
  681. let me = zTreeOprObj;
  682. $("#rpt_page_num").get(0).value = me.currentPage + "/" + me.maxPages;
  683. }
  684. };
  685. let canvasOprObj = {
  686. canvasOnMouseMove: function (event) {
  687. if (zTreeOprObj.currentNode) {
  688. let x = event.offsetX - JpcCanvasOutput.offsetX, canvas = event.originalTarget;
  689. if (!(canvas)) canvas = event.target; //chrome浏览器不认event.originalTarget,只认event.target或event.currentTarget
  690. if (x < PRE_PAGE_OFFSET) {
  691. canvas.style.cursor = "url(/web/building_saas/img/PreviousPage.cur), auto";
  692. } else if ((canvas.width - x) < NEXT_PAGE_OFFSET) {
  693. canvas.style.cursor = "url(/web/building_saas/img/NextPage.cur), auto";
  694. } else {
  695. canvas.style.cursor = "";
  696. }
  697. }
  698. },
  699. canvasOnClick: function(event){
  700. if (zTreeOprObj.currentNode) {
  701. let x = event.offsetX - JpcCanvasOutput.offsetX, canvas = event.originalTarget;
  702. if (!(canvas)) canvas = event.target; //chrome浏览器不认event.originalTarget,只认event.target或event.currentTarget
  703. if (x < FIRST_PAGE_OFFSET) {
  704. zTreeOprObj.showPage(1, canvas);
  705. } else if (x < PRE_PAGE_OFFSET) {
  706. zTreeOprObj.showPage(zTreeOprObj.currentPage - 1, canvas);
  707. } else if ((canvas.width - x) < LAST_PAGE_OFFSET) {
  708. zTreeOprObj.showPage(zTreeOprObj.maxPages, canvas);
  709. } else if ((canvas.width - x) < NEXT_PAGE_OFFSET) {
  710. zTreeOprObj.showPage(zTreeOprObj.currentPage + 1, canvas);
  711. }
  712. }
  713. }
  714. };
  715. let rptControlObj = {
  716. currentOutputType: "Excel",
  717. currentDownloadUrl: null,
  718. currentDownloadIdx: 0,
  719. getCurrentPageSize: function() {
  720. // let rst = "A4";
  721. let rst = document.getElementById("btnRptPageSize").innerHTML.trim();
  722. //btnRptPageSize
  723. return rst;
  724. },
  725. getCurrentOrientation: function() {
  726. // let rst = "横向";
  727. let rst = document.getElementById("btnRptOrientation").innerHTML.trim();
  728. return rst;
  729. },
  730. getCurrentReportOption: function() {
  731. //
  732. },
  733. changeType: function(newType) {
  734. let me = rptControlObj;
  735. let excelDom = document.getElementById("EXCEL_TYPE");
  736. let pdfDom = document.getElementById("PDF_TYPE");
  737. if (newType === "Excel") {
  738. excelDom.className = "btn btn-block btn-primary";
  739. pdfDom.className = "btn btn-block btn-outline-secondary";
  740. me.currentOutputType = newType;
  741. } else if (newType === "PDF") {
  742. excelDom.className = "btn btn-block btn-outline-secondary";
  743. pdfDom.className = "btn btn-block btn-primary";
  744. me.currentOutputType = newType;
  745. } else {
  746. //me.currentOutputType = newType;
  747. }
  748. },
  749. outputRpt: function() {
  750. let me = rptControlObj;
  751. if (me.currentOutputType === "Excel") {
  752. me.getExcel();
  753. } else if (me.currentOutputType === "PDF") {
  754. me.getPDF();
  755. } else {
  756. //other types if needed.
  757. }
  758. },
  759. getTplIdsCommon: function (refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names) {
  760. for (let node of zTreeOprObj.checkedRptTplNodes) {
  761. if (node.hasOwnProperty('flags') && node.flags.hasOwnProperty('reportType') && node['flags']['reportType'] !== 'NA' && node['flags']['reportType'] !== null) {
  762. if (node['flags']['reportType'] === 'billSummary') {
  763. refBillSumPrjsIds.push(node.refId);
  764. if (bill_rpt_names) bill_rpt_names.push(node.name);
  765. } else if (node['flags']['reportType'] === 'gljSummary') {
  766. refGljSumPrjsIds.push(node.refId);
  767. if (glj_rpt_names) glj_rpt_names.push(node.name);
  768. }
  769. } else {
  770. refRptTplIds.push(node.refId);
  771. if (rpt_names) rpt_names.push(node.name);
  772. }
  773. }
  774. },
  775. creatCommonExportParam: function (refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds) {
  776. let nodes = (zTreeOprObj.prjFolderTreeObj === null)?[]:zTreeOprObj.prjFolderTreeObj.getCheckedNodes(true);
  777. let rst = {};
  778. rst.prj_id = projectObj.project.projectInfo.ID;
  779. rst.rpt_ids = refRptTplIds;
  780. rst.rpt_bill_tpl_ids = refBillSumPrjsIds;
  781. rst.rpt_glj_tpl_ids = refGljSumPrjsIds;
  782. rst.prjIds = [];
  783. zTreeOprObj.selectedPrjIDs = [];
  784. for (let node of nodes) {
  785. if (node.level > 0) {
  786. rst.prjIds.push(node.ID);
  787. zTreeOprObj.selectedPrjIDs.push(node.ID);
  788. }
  789. }
  790. // rst.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  791. // rst.rpt_names = rpt_names;
  792. // rst.isOneSheet = true;
  793. rst.pageSize = rptControlObj.getCurrentPageSize();
  794. rst.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:rptControlObj.getCurrentOrientation());
  795. rst.custCfg = zTreeOprObj.reportPageCfg;
  796. rst.option = "normal";
  797. return rst;
  798. },
  799. getAllInOneBook: function () {
  800. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  801. let me = rptControlObj;
  802. let orgRptName = projectObj.project.projectInfo.name;
  803. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  804. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  805. if (zTreeOprObj.selectedPrjIDs.length > 0 && (refBillSumPrjsIds.length > 0 || refGljSumPrjsIds.length > 0)) {
  806. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  807. params.rptName = orgRptName;
  808. $.bootstrapLoading.start();
  809. CommonAjax.postEx("report_api/createExcelFilesInOneBook", params, WAIT_TIME_EXPORT, true, function(result){
  810. if (result) {
  811. $.bootstrapLoading.end();
  812. let uuIdUrls = [];
  813. let uuIdUrl = "/report_api/getFileByUUID/" + result.uuid + "/" + stringUtil.replaceAll(result.reportName, "#", "_") + "/xlsx";
  814. uuIdUrls.push(uuIdUrl);
  815. downloadReport(uuIdUrls);
  816. } else {
  817. $.bootstrapLoading.end();
  818. }
  819. },
  820. function(failRst){
  821. $.bootstrapLoading.end();
  822. console.log(failRst);
  823. },
  824. function(exceptionRst){
  825. $.bootstrapLoading.end();
  826. console.log(exceptionRst);
  827. }
  828. );
  829. } else {
  830. if (refBillSumPrjsIds.length > 0 || refGljSumPrjsIds.length > 0) {
  831. $("#divReqBillSummary")[0].style.display = "none";
  832. $("#divReqGljSummary")[0].style.display = "none";
  833. $("#divReqCommonSummaryExcel")[0].style.display = "";
  834. $("#divReqCommonSummaryMultiExcel")[0].style.display = "none";
  835. $("#divReqCommonSummaryPDF")[0].style.display = "none";
  836. zTreeOprObj.requestPrjFolderCommon(); //先处理需要汇总的报表,走另外一个分支
  837. } else if (refRptTplIds.length > 0) {
  838. let params = {};
  839. params.prj_id = projectObj.project.projectInfo.ID;
  840. params.rpt_ids = refRptTplIds;
  841. params.rptName = orgRptName;
  842. params.pageSize = me.getCurrentPageSize();
  843. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  844. params.custCfg = zTreeOprObj.reportPageCfg;
  845. params.option = "normal";
  846. $.bootstrapLoading.start();
  847. CommonAjax.postEx("report_api/createExcelFilesInOneBook", params, WAIT_TIME_EXPORT, true, function(result){
  848. if (result) {
  849. $.bootstrapLoading.end();
  850. let uuIdUrls = [];
  851. let uuIdUrl = "/report_api/getFileByUUID/" + result.uuid + "/" + stringUtil.replaceAll(result.reportName, "#", "_") + "/xlsx";
  852. uuIdUrls.push(uuIdUrl);
  853. downloadReport(uuIdUrls);
  854. } else {
  855. $.bootstrapLoading.end();
  856. }
  857. },
  858. function(failRst){
  859. $.bootstrapLoading.end();
  860. console.log(failRst);
  861. },
  862. function(exceptionRst){
  863. $.bootstrapLoading.end();
  864. console.log(exceptionRst);
  865. }
  866. );
  867. }
  868. }
  869. }
  870. },
  871. getAllIndividualExcelBook: function () {
  872. let me = rptControlObj;
  873. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  874. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  875. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  876. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  877. if (zTreeOprObj.selectedPrjIDs.length > 0 && (glj_rpt_names.length > 0 || bill_rpt_names.length > 0)) {
  878. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  879. params.prj_id = projectObj.project.projectInfo.ID;
  880. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  881. params.rpt_names = rpt_names;
  882. params.isOneSheet = true;
  883. params.rptName = projectObj.project.projectInfo.name;
  884. $.bootstrapLoading.start();
  885. CommonAjax.postEx("report_api/createExcelFiles", params, WAIT_TIME_EXPORT, true, function(result){
  886. if (result) {
  887. $.bootstrapLoading.end();
  888. let uuIdUrls = [];
  889. for (let uuIdObj of result) {
  890. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/xlsx";
  891. uuIdUrls.push(uuIdUrl);
  892. }
  893. downloadReport(uuIdUrls);
  894. } else {
  895. $.bootstrapLoading.end();
  896. }
  897. },
  898. function(failRst){
  899. $.bootstrapLoading.end();
  900. console.log(failRst);
  901. },
  902. function(exceptionRst){
  903. $.bootstrapLoading.end();
  904. console.log(exceptionRst);
  905. }
  906. );
  907. } else {
  908. if (refBillSumPrjsIds.length > 0 || refGljSumPrjsIds.length > 0) {
  909. $("#divReqBillSummary")[0].style.display = "none";
  910. $("#divReqGljSummary")[0].style.display = "none";
  911. $("#divReqCommonSummaryExcel")[0].style.display = "none";
  912. $("#divReqCommonSummaryMultiExcel")[0].style.display = "";
  913. $("#divReqCommonSummaryPDF")[0].style.display = "none";
  914. zTreeOprObj.requestPrjFolderCommon(); //先处理需要汇总的报表,走另外一个分支
  915. } else if (refRptTplIds.length > 0) {
  916. let params = {};
  917. params.prj_id = projectObj.project.projectInfo.ID;
  918. params.rpt_ids = refRptTplIds;
  919. params.rpt_names = rpt_names;
  920. params.pageSize = me.getCurrentPageSize();
  921. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  922. params.isOneSheet = true;
  923. params.custCfg = zTreeOprObj.reportPageCfg;
  924. params.option = "normal";
  925. $.bootstrapLoading.start();
  926. CommonAjax.postEx("report_api/createExcelFiles", params, WAIT_TIME_EXPORT, true, function(result){
  927. if (result) {
  928. $.bootstrapLoading.end();
  929. let uuIdUrls = [];
  930. for (let uuIdObj of result) {
  931. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/xlsx";
  932. uuIdUrls.push(uuIdUrl);
  933. }
  934. downloadReport(uuIdUrls);
  935. } else {
  936. $.bootstrapLoading.end();
  937. }
  938. },
  939. function(failRst){
  940. $.bootstrapLoading.end();
  941. console.log(failRst);
  942. },
  943. function(exceptionRst){
  944. $.bootstrapLoading.end();
  945. console.log(exceptionRst);
  946. }
  947. );
  948. }
  949. }
  950. }
  951. },
  952. checkAndGetExcel: function () {
  953. if (zTreeOprObj.isFreeUser && !commonUtil.isGLYun()) {//2020-11-25 zhang 公路云版,免费版允许打印、导出报表
  954. hintBox.versionBox('对不起,您当前使用的是学习版,不提供导出、打印报表功能,请联系我们的客服人员。');
  955. return;
  956. }
  957. if (zTreeOprObj.treeObj) {
  958. let chkNodes = zTreeOprObj.treeObj.getCheckedNodes(true);
  959. if (chkNodes.length > 0) {
  960. $("#show_excel_output_cfg").trigger("click");
  961. } else {
  962. rptControlObj.getAllIndividualExcelBook();
  963. }
  964. }
  965. },
  966. getExcel: function () {
  967. let me = rptControlObj;
  968. if ($("#excelExportType_AllInOneBook").get(0).checked) {
  969. me.getAllInOneBook();
  970. } else if ($("#excelExportType_IndividualBook").get(0).checked) {
  971. me.getAllIndividualExcelBook();
  972. }
  973. },
  974. getPDF: function () {
  975. let me = rptControlObj;
  976. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  977. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  978. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  979. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  980. if (zTreeOprObj.selectedPrjIDs.length > 0 && (glj_rpt_names.length > 0 || bill_rpt_names.length > 0)) {
  981. let params = rptControlObj.creatCommonExportParam();
  982. params.prj_id = projectObj.project.projectInfo.ID;
  983. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  984. params.rpt_ids = refRptTplIds;
  985. params.rpt_bill_tpl_ids = refBillSumPrjsIds;
  986. params.rpt_glj_tpl_ids = refGljSumPrjsIds;
  987. params.rpt_names = rpt_names;
  988. params.isOneSheet = true;
  989. params.rptName = projectObj.project.projectInfo.name;
  990. CommonAjax.postEx("report_api/createPdfFiles", params, WAIT_TIME_EXPORT, true, function(result){
  991. if (result) {
  992. let uuIdUrls = [];
  993. for (let uuIdObj of result) {
  994. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/pdf";
  995. uuIdUrls.push(uuIdUrl);
  996. }
  997. downloadReport(uuIdUrls);
  998. } else {
  999. //
  1000. }
  1001. }, null, null
  1002. );
  1003. } else {
  1004. if (refBillSumPrjsIds.length > 0 || refGljSumPrjsIds.length > 0) {
  1005. $("#divReqBillSummary")[0].style.display = "none";
  1006. $("#divReqGljSummary")[0].style.display = "none";
  1007. $("#divReqCommonSummaryExcel")[0].style.display = "none";
  1008. $("#divReqCommonSummaryMultiExcel")[0].style.display = "none";
  1009. $("#divReqCommonSummaryPDF")[0].style.display = "";
  1010. zTreeOprObj.requestPrjFolderCommon(); //先处理需要汇总的报表,走另外一个分支
  1011. } else if (refRptTplIds.length > 0) {
  1012. let params = {};
  1013. params.prj_id = projectObj.project.projectInfo.ID;
  1014. params.rpt_ids = refRptTplIds;
  1015. params.rpt_names = rpt_names;
  1016. params.pageSize = me.getCurrentPageSize();
  1017. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  1018. params.custCfg = zTreeOprObj.reportPageCfg;
  1019. params.option = "normal";
  1020. CommonAjax.postEx("report_api/createPdfFiles", params, WAIT_TIME_EXPORT, true, function(result){
  1021. if (result) {
  1022. let uuIdUrls = [];
  1023. for (let uuIdObj of result) {
  1024. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/pdf";
  1025. uuIdUrls.push(uuIdUrl);
  1026. }
  1027. downloadReport(uuIdUrls);
  1028. } else {
  1029. //
  1030. }
  1031. }, null, null
  1032. );
  1033. }
  1034. }
  1035. }
  1036. },
  1037. _hidePdfIniPage: function () {
  1038. if ($('#ini_PDF_cover').is(':visible')) {
  1039. // $("#ini_PDF_Btn_Cancel").trigger("click");
  1040. // 因在Z+可能会有冲突,所以暴力关闭初始化PDF页面!
  1041. $('#ini_PDF_cover').remove();
  1042. if ($("div.modal-backdrop.fade.show")) {
  1043. $('div.modal-backdrop.fade.show').remove();
  1044. }
  1045. }
  1046. },
  1047. getPdfFontCallback: function(fontProperty) {
  1048. let me = rptControlObj;
  1049. rptTplObj.pdfFont['SmartSimsun'].push(fontProperty);
  1050. if (rptTplObj.pdfFont['SmartSimsun'].length === 2) {
  1051. me._hidePdfIniPage();
  1052. setTimeout(function() {
  1053. me.getPDFEx();
  1054. }, 50); // 50毫秒足够关闭PDF初始化page了
  1055. }
  1056. },
  1057. getPDFPre: function () {
  1058. let me = rptControlObj;
  1059. if (zTreeOprObj.isFreeUser && !commonUtil.isGLYun()) {//2020-11-25 zhang 公路云版,免费版允许打印、导出报表
  1060. hintBox.versionBox('对不起,您当前使用的是学习版,不提供导出、打印报表功能,请联系我们的客服人员。');
  1061. return;
  1062. }
  1063. if (rptTplObj.pdfFont['SmartSimsun'].length === 2) {
  1064. me.getPDFEx();
  1065. } else {
  1066. // dynamicLoadJs('/lib/jspdf/SmartSimsun-normal.js', 'normal', me.getPdfFontCallback);
  1067. // dynamicLoadJs('/lib/jspdf/SmartSimsun-bold.js', 'bold', me.getPdfFontCallback);
  1068. $("#ini_PDF_Btn").trigger("click");
  1069. dynamicLoadJs('https://d2.smartcost.com.cn/cach/SmartSimsun-normal.js', 'normal', me.getPdfFontCallback);
  1070. dynamicLoadJs('https://d2.smartcost.com.cn/cach/SmartSimsun-bold.js', 'bold', me.getPdfFontCallback);
  1071. }
  1072. },
  1073. getPDFEx: function () {
  1074. let me = rptControlObj;
  1075. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  1076. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  1077. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  1078. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  1079. // refRptTplIds获取的是
  1080. if (zTreeOprObj.selectedPrjIDs.length > 0 && (glj_rpt_names.length > 0 || bill_rpt_names.length > 0)) {
  1081. let params = rptControlObj.creatCommonExportParam();
  1082. params.prj_id = projectObj.project.projectInfo.ID;
  1083. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  1084. params.rpt_ids = refRptTplIds;
  1085. params.rpt_bill_tpl_ids = refBillSumPrjsIds;
  1086. params.rpt_glj_tpl_ids = refGljSumPrjsIds;
  1087. params.rpt_names = rpt_names;
  1088. params.isOneSheet = true;
  1089. params.rptName = projectObj.project.projectInfo.name;
  1090. $.bootstrapLoading.start();
  1091. CommonAjax.postEx("report_api/getMultiReports", params, WAIT_TIME_EXPORT, true,
  1092. function(result){
  1093. $.bootstrapLoading.end();
  1094. me._hidePdfIniPage();
  1095. let pageSize = rptControlObj.getCurrentPageSize();
  1096. let rstRptNames = [];
  1097. for (let idx = 0; idx < result.length; idx++) {
  1098. rstRptNames.push(result[idx][JV.NODE_PAGE_INFO][JV.NODE_MAIN_INFO_RPT_NAME]);
  1099. }
  1100. downloadPDFReport(result, pageSize, rstRptNames);
  1101. // for (let idx = 0; idx < result.length; idx++) {
  1102. // let pageData = result[idx];
  1103. // JpcJsPDFHelper.outputAsPdf(pageData, pageSize, result[idx][JV.NODE_PAGE_INFO][JV.NODE_MAIN_INFO_RPT_NAME]);
  1104. // }
  1105. },
  1106. function(failRst){
  1107. $.bootstrapLoading.end();
  1108. me._hidePdfIniPage();
  1109. console.log(failRst);
  1110. },
  1111. function(exceptionRst){
  1112. $.bootstrapLoading.end();
  1113. me._hidePdfIniPage();
  1114. console.log(exceptionRst);
  1115. }
  1116. );
  1117. } else {
  1118. if (refBillSumPrjsIds.length > 0 || refGljSumPrjsIds.length > 0) {
  1119. $("#divReqBillSummary")[0].style.display = "none";
  1120. $("#divReqGljSummary")[0].style.display = "none";
  1121. $("#divReqCommonSummaryExcel")[0].style.display = "none";
  1122. $("#divReqCommonSummaryMultiExcel")[0].style.display = "none";
  1123. $("#divReqCommonSummaryPDF")[0].style.display = "";
  1124. zTreeOprObj.requestPrjFolderCommon(); //先处理需要汇总的报表,走另外一个分支
  1125. } else if (refRptTplIds.length > 0) {
  1126. let params = {};
  1127. params.prj_id = projectObj.project.projectInfo.ID;
  1128. params.rpt_ids = refRptTplIds;
  1129. params.rpt_names = rpt_names;
  1130. params.pageSize = me.getCurrentPageSize();
  1131. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  1132. params.custCfg = zTreeOprObj.reportPageCfg;
  1133. params.option = "normal";
  1134. $.bootstrapLoading.start();
  1135. CommonAjax.postEx("report_api/getMultiReports", params, WAIT_TIME_EXPORT, true,
  1136. function(result){
  1137. $.bootstrapLoading.end();
  1138. me._hidePdfIniPage();
  1139. let pageSize = rptControlObj.getCurrentPageSize();
  1140. downloadPDFReport(result, pageSize, rpt_names);
  1141. // for (let idx = 0; idx < result.length; idx++) {
  1142. // let pageData = result[idx];
  1143. // JpcJsPDFHelper.outputAsPdf(pageData, pageSize, rpt_names[idx]);
  1144. // }
  1145. },
  1146. function(failRst){
  1147. $.bootstrapLoading.end();
  1148. me._hidePdfIniPage();
  1149. console.log(failRst);
  1150. },
  1151. function(exceptionRst){
  1152. $.bootstrapLoading.end();
  1153. me._hidePdfIniPage();
  1154. console.log(exceptionRst);
  1155. }
  1156. );
  1157. } else {
  1158. //这个分支是为了减少请求,用户已经点过的表,又没有勾选,那么就直接导出成PDF,不过貌似已经走不到这里了
  1159. let pageSize = rptControlObj.getCurrentPageSize();
  1160. let pageData = zTreeOprObj.currentRptPageRst;
  1161. $.bootstrapLoading.end();
  1162. me._hidePdfIniPage();
  1163. if (pageData) {
  1164. JpcJsPDFHelper.outputAsPdf(pageData, pageSize, zTreeOprObj.currentNode.name);
  1165. }
  1166. }
  1167. }
  1168. } else {
  1169. $.bootstrapLoading.end();
  1170. }
  1171. },
  1172. firstPage: function(dom) {
  1173. let canvas = document.getElementById("rptCanvas");
  1174. zTreeOprObj.showPage(1, canvas);
  1175. },
  1176. prePage: function(dom) {
  1177. let canvas = document.getElementById("rptCanvas");
  1178. zTreeOprObj.showPage(zTreeOprObj.currentPage - 1, canvas);
  1179. },
  1180. nextPage: function(dom) {
  1181. let canvas = document.getElementById("rptCanvas");
  1182. zTreeOprObj.showPage(zTreeOprObj.currentPage + 1, canvas);
  1183. },
  1184. lastPage: function(dom) {
  1185. let me = zTreeOprObj;
  1186. let canvas = document.getElementById("rptCanvas");
  1187. zTreeOprObj.showPage(me.maxPages, canvas);
  1188. },
  1189. onKeydown: function (event, dom) {
  1190. let me = zTreeOprObj, keyPressed = null;
  1191. if (window.event) {
  1192. keyPressed = window.event.keyCode; // IE/Chrome
  1193. } else {
  1194. keyPressed = event.which; // Firefox
  1195. }
  1196. if (keyPressed === 13) {
  1197. let pageNum = 1;
  1198. try {
  1199. pageNum = parseInt(dom.value);
  1200. } catch (e) {
  1201. pageNum = 1;
  1202. }
  1203. let canvas = document.getElementById("rptCanvas");
  1204. if (pageNum < 1) {
  1205. pageNum = 1;
  1206. } else if (pageNum > me.maxPages) {
  1207. pageNum = me.maxPages;
  1208. }
  1209. zTreeOprObj.showPage(pageNum, canvas);
  1210. return false;
  1211. }
  1212. },
  1213. changeMargin: function(marginPropStr, marginDom) {
  1214. zTreeOprObj.reportPageCfg.margins[marginPropStr] = marginDom.value;
  1215. },
  1216. changeFontMain: function(CfgDispName, fontProperty, fontDom) {
  1217. for (let font of zTreeOprObj.reportPageCfg.fonts) {
  1218. if (font["CfgDispName"] === CfgDispName) {
  1219. font[fontProperty] = fontDom.value;
  1220. break;
  1221. }
  1222. }
  1223. },
  1224. changeCfgOption: function (optStr, dom) {
  1225. zTreeOprObj.reportPageCfg[optStr] = dom.checked;
  1226. },
  1227. changeFontAdhoc: function(CfgDispName, fontProperty, fontDom) {
  1228. for (let font of zTreeOprObj.reportPageCfg.fonts) {
  1229. if (font["CfgDispName"] === CfgDispName) {
  1230. if (font[fontProperty] === 'T') {
  1231. font[fontProperty] = 'F';
  1232. fontDom.className = "btn btn-sm btn-outline-secondary";
  1233. } else {
  1234. font[fontProperty] = 'T';
  1235. fontDom.className = "btn btn-sm btn-outline-secondary active";
  1236. }
  1237. break;
  1238. }
  1239. }
  1240. },
  1241. restoreCustCFG: function () {
  1242. let me = this;
  1243. zTreeOprObj.renderRptCfg(zTreeOprObj.defReportPageCfg);
  1244. zTreeOprObj.extractRptCfg(zTreeOprObj.reportPageCfg);
  1245. me.saveCustCfg();
  1246. },
  1247. saveCustCfg: function() {
  1248. let params = {};
  1249. params.custCfg = zTreeOprObj.reportPageCfg;
  1250. CommonAjax.postEx("report_tpl_api/saveCustomerCfg", params, 20000, true, function(result){
  1251. // alert("Save successfully!");
  1252. $("#update_msg_response")[0].style.color = "green";
  1253. $("#update_msg_response")[0].innerHTML = " (保存成功!)";
  1254. setTimeout(function(){
  1255. $("#update_msg_response")[0].innerHTML = "";
  1256. }, 1000);
  1257. }, function (failRst) {
  1258. $("#update_msg_response")[0].style.color = "red";
  1259. $("#update_msg_response")[0].innerHTML = " (保存失败!)";
  1260. setTimeout(function(){
  1261. $("#update_msg_response")[0].innerHTML = "";
  1262. }, 1000);
  1263. }, null
  1264. );
  1265. },
  1266. confirmCfgChange: function() {
  1267. zTreeOprObj.changeCfg();
  1268. }
  1269. };
  1270. function downloadPDFReport(pageDataArr, pageSize, rpt_names) {
  1271. rptControlObj.currentDownloadIdx = 0;
  1272. const private_download = function() {
  1273. if (rptControlObj.currentDownloadIdx < pageDataArr.length) {
  1274. let pageData = pageDataArr[rptControlObj.currentDownloadIdx];
  1275. let rptName = rpt_names[rptControlObj.currentDownloadIdx];
  1276. rptControlObj.currentDownloadIdx++;
  1277. JpcJsPDFHelper.outputAsPdf(pageData, pageSize, rptName);
  1278. if (rptControlObj.currentDownloadIdx < pageDataArr.length) setTimeout(private_download, 1000);
  1279. }
  1280. }
  1281. private_download();
  1282. }
  1283. function downloadReport(urls) {
  1284. //考虑到多个报表下载,一些浏览器(如chrome)不允许一下子下载多个文件,得缓缓处理,统一在这处理
  1285. rptControlObj.currentDownloadUrl = null;
  1286. rptControlObj.currentDownloadIdx = 0;
  1287. let private_download = function() {
  1288. if (rptControlObj.currentDownloadIdx >= 0 && rptControlObj.currentDownloadIdx < urls.length) {
  1289. rptControlObj.currentDownloadUrl = urls[rptControlObj.currentDownloadIdx];
  1290. rptControlObj.currentDownloadIdx++;
  1291. window.location = rptControlObj.currentDownloadUrl;
  1292. setTimeout(private_download, 2000);
  1293. }
  1294. }
  1295. private_download();
  1296. }
  1297. function dynamicLoadJs(url, type, callback) {
  1298. let head = document.getElementsByTagName('head')[0];
  1299. let script = document.createElement('script');
  1300. script.type = 'text/javascript';
  1301. script.src = url;
  1302. if(callback) {
  1303. script.onload = script.onreadystatechange = function (event) {
  1304. // console.log('this.readyState: ' + this.readyState);
  1305. callback(type);
  1306. script.onload = script.onreadystatechange = null;
  1307. // if (this.readyState === "loaded" || this.readyState === "complete"){
  1308. // }
  1309. };
  1310. }
  1311. head.appendChild(script);
  1312. }
  1313. function dynamicLoadCss(url) {
  1314. let head = document.getElementsByTagName('head')[0];
  1315. let link = document.createElement('link');
  1316. link.type='text/css';
  1317. link.rel = 'stylesheet';
  1318. link.href = url;
  1319. head.appendChild(link);
  1320. }