rpt_main.js 64 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334
  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. for (let prj of result.data) {
  424. if (currPrjParentID === prj.ParentID) {
  425. selectedProjects.push({name: prj.name, ID: prj.ID});
  426. }
  427. }
  428. $("#show_project_folder").trigger("click");
  429. let topItem = [{name: '所有相关项目', items: selectedProjects}];
  430. // me.prjFolderTreeObj = $.fn.zTree.init($("#prjFolderTree"), rpt_prj_folder_setting, selectedProjects);
  431. me.prjFolderTreeObj = $.fn.zTree.init($("#prjFolderTree"), rpt_prj_folder_setting, topItem);
  432. me.prjFolderTreeObj.expandAll(true);
  433. } else {
  434. alert('error: ' + result.message);
  435. }
  436. },
  437. error: function(jqXHR, textStatus, errorThrown){
  438. hintBox.unWaitBox();
  439. alert('error ' + textStatus + " " + errorThrown);
  440. }
  441. });
  442. },
  443. requestPrjFolderForBillsSummary: function () {
  444. let me = zTreeOprObj;
  445. $("#divReqBillSummary")[0].style.display = "";
  446. $("#divReqGljSummary")[0].style.display = "none";
  447. $("#divReqCommonSummaryExcel")[0].style.display = "none";
  448. $("#divReqCommonSummaryMultiExcel")[0].style.display = "none";
  449. $("#divReqCommonSummaryPDF")[0].style.display = "none";
  450. me.requestPrjFolderCommon();
  451. },
  452. requestPrjFolderForGljSummary: function () {
  453. let me = zTreeOprObj;
  454. $("#divReqBillSummary")[0].style.display = "none";
  455. $("#divReqGljSummary")[0].style.display = "";
  456. $("#divReqCommonSummaryExcel")[0].style.display = "none";
  457. $("#divReqCommonSummaryMultiExcel")[0].style.display = "none";
  458. $("#divReqCommonSummaryPDF")[0].style.display = "none";
  459. me.requestPrjFolderCommon();
  460. },
  461. requestBillsSummaryRpt: function () {
  462. let me = zTreeOprObj;
  463. let nodes = me.prjFolderTreeObj.getCheckedNodes(true);
  464. if (nodes.length > 0) {
  465. if (nodes[0].level === 0) {
  466. nodes.splice(0, 1);
  467. }
  468. hintBox.waitBox();
  469. let params = {};
  470. params.pageSize = rptControlObj.getCurrentPageSize();
  471. params.rpt_tpl_id = me.currentNode.refId;
  472. params.custCfg = me.reportPageCfg;
  473. params.prjIds = [];
  474. me.selectedPrjIDs = [];
  475. for (let node of nodes) {
  476. params.prjIds.push(node.ID);
  477. me.selectedPrjIDs.push(node.ID);
  478. }
  479. CommonAjax.postEx("report_api/getBillsSummaryReport", params, 60000, true,
  480. function(result){
  481. hintBox.unWaitBox();
  482. let pageRst = result;
  483. let canvas = document.getElementById("rptCanvas");
  484. if (pageRst && pageRst.items && pageRst.items.length > 0) {
  485. me.resetAfter(pageRst);
  486. me.currentRptPageRst = pageRst;
  487. me.maxPages = pageRst.items.length;
  488. me.currentPage = 1;
  489. me.displayPageValue();
  490. let size = JpcCanvasOutput.getReportSizeInPixel(me.currentRptPageRst, getScreenDPI());
  491. canvas.width = size[0] + 20;
  492. if (size[1] > size[0]) {
  493. canvas.height = size[1] + 100;
  494. } else {
  495. canvas.height = size[1] + 50;
  496. }
  497. me.showPage(1, canvas);
  498. } else {
  499. //返回了无数据表
  500. JpcCanvasOutput.cleanCanvas(canvas);
  501. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  502. }
  503. }, function(err){
  504. hintBox.unWaitBox();
  505. }, function(ex){
  506. hintBox.unWaitBox();
  507. }
  508. );
  509. }
  510. },
  511. requestGljSummaryRpt: function () {
  512. let me = zTreeOprObj;
  513. let nodes = me.prjFolderTreeObj.getCheckedNodes(true);
  514. if (nodes.length > 0) {
  515. if (nodes[0].level === 0) {
  516. nodes.splice(0, 1);
  517. }
  518. hintBox.waitBox();
  519. let params = {};
  520. params.pageSize = rptControlObj.getCurrentPageSize();
  521. params.rpt_tpl_id = me.currentNode.refId;
  522. params.custCfg = me.reportPageCfg;
  523. params.prjIds = [];
  524. zTreeOprObj.selectedPrjIDs = [];
  525. for (let node of nodes) {
  526. params.prjIds.push(node.ID);
  527. zTreeOprObj.selectedPrjIDs.push(node.ID);
  528. }
  529. CommonAjax.postEx("report_api/getGljSummaryReport", params, 60000, true,
  530. function(result){
  531. hintBox.unWaitBox();
  532. let pageRst = result;
  533. let canvas = document.getElementById("rptCanvas");
  534. if (pageRst && pageRst.items && pageRst.items.length > 0) {
  535. me.resetAfter(pageRst);
  536. me.currentRptPageRst = pageRst;
  537. me.maxPages = pageRst.items.length;
  538. me.currentPage = 1;
  539. me.displayPageValue();
  540. let size = JpcCanvasOutput.getReportSizeInPixel(me.currentRptPageRst, getScreenDPI());
  541. canvas.width = size[0] + 20;
  542. if (size[1] > size[0]) {
  543. canvas.height = size[1] + 100;
  544. } else {
  545. canvas.height = size[1] + 50;
  546. }
  547. me.showPage(1, canvas);
  548. } else {
  549. //返回了无数据表
  550. JpcCanvasOutput.cleanCanvas(canvas);
  551. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  552. }
  553. }, function(err){
  554. hintBox.unWaitBox();
  555. }, function(ex){
  556. hintBox.unWaitBox();
  557. }
  558. );
  559. }
  560. },
  561. requestSumAndNormalRptForPDF: function () {
  562. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  563. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  564. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  565. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  566. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  567. params.rpt_names = rpt_names;
  568. params.isOneSheet = true;
  569. CommonAjax.postEx("report_api/createPdfFiles", params, WAIT_TIME_EXPORT, true, function(result){
  570. if (result) {
  571. let uuIdUrls = [];
  572. for (let uuIdObj of result) {
  573. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/pdf";
  574. uuIdUrls.push(uuIdUrl);
  575. }
  576. downloadReport(uuIdUrls);
  577. } else {
  578. //
  579. }
  580. }, null, null
  581. );
  582. },
  583. requestSumAndNormalRptForPDF_Ex: function () {
  584. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  585. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  586. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  587. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  588. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  589. params.rpt_names = rpt_names;
  590. params.isOneSheet = true;
  591. CommonAjax.postEx("report_api/getMultiReports", params, WAIT_TIME_EXPORT, true,
  592. function(result){
  593. let pageSize = rptControlObj.getCurrentPageSize();
  594. for (let idx = 0; idx < result.length; idx++) {
  595. let pageData = result[idx];
  596. JpcJsPDFHelper.outputAsPdf(pageData, pageSize, result[idx][JV.NODE_PAGE_INFO][JV.NODE_MAIN_INFO_RPT_NAME]);
  597. }
  598. },
  599. function(failRst){
  600. console.log(failRst);
  601. },
  602. function(exceptionRst){
  603. console.log(exceptionRst);
  604. }
  605. );
  606. },
  607. requestSumAndNormalRptForMultiExcel: function () {
  608. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  609. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  610. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  611. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  612. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  613. params.rpt_names = rpt_names;
  614. params.isOneSheet = true;
  615. $.bootstrapLoading.start();
  616. CommonAjax.postEx("report_api/createExcelFiles", params, WAIT_TIME_EXPORT, true, function(result){
  617. if (result) {
  618. $.bootstrapLoading.end();
  619. let uuIdUrls = [];
  620. for (let uuIdObj of result) {
  621. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/xlsx";
  622. uuIdUrls.push(uuIdUrl);
  623. }
  624. downloadReport(uuIdUrls);
  625. } else {
  626. $.bootstrapLoading.end();
  627. }
  628. },
  629. function(failRst){
  630. $.bootstrapLoading.end();
  631. console.log(failRst);
  632. },
  633. function(exceptionRst){
  634. $.bootstrapLoading.end();
  635. console.log(exceptionRst);
  636. }
  637. );
  638. },
  639. requestSumAndNormalRptForAllInOneExcel: function () {
  640. let orgRptName = projectObj.project.projectInfo.name;
  641. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  642. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, null, null, null);
  643. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  644. params.rptName = orgRptName;
  645. $.bootstrapLoading.start();
  646. CommonAjax.postEx("report_api/createExcelFilesInOneBook", params, WAIT_TIME_EXPORT, true, function(result){
  647. if (result) {
  648. $.bootstrapLoading.end();
  649. let uuIdUrls = [];
  650. let uuIdUrl = "/report_api/getFileByUUID/" + result.uuid + "/" + stringUtil.replaceAll(result.reportName, "#", "_") + "/xlsx";
  651. uuIdUrls.push(uuIdUrl);
  652. downloadReport(uuIdUrls);
  653. } else {
  654. $.bootstrapLoading.end();
  655. }
  656. },
  657. function(failRst){
  658. $.bootstrapLoading.end();
  659. console.log(failRst);
  660. },
  661. function(exceptionRst){
  662. $.bootstrapLoading.end();
  663. console.log(exceptionRst);
  664. }
  665. );
  666. },
  667. showPage: function (pageNum, canvas) {
  668. let me = zTreeOprObj;
  669. if (pageNum >= 1 && pageNum <= me.maxPages) {
  670. me.currentPage = pageNum;
  671. JpcCanvasOutput.cleanCanvas(canvas);
  672. JpcCanvasOutput.drawPageBorder(me.currentRptPageRst, canvas, getScreenDPI());
  673. // JpcCanvasOutput.drawWaterMarks(canvas, zTreeOprObj.waterMarks);
  674. JpcCanvasOutput.drawToCanvas(me.currentRptPageRst, canvas, me.currentPage);
  675. }
  676. me.displayPageValue();
  677. },
  678. displayPageValue: function() {
  679. let me = zTreeOprObj;
  680. $("#rpt_page_num").get(0).value = me.currentPage + "/" + me.maxPages;
  681. }
  682. };
  683. let canvasOprObj = {
  684. canvasOnMouseMove: function (event) {
  685. if (zTreeOprObj.currentNode) {
  686. let x = event.offsetX - JpcCanvasOutput.offsetX, canvas = event.originalTarget;
  687. if (!(canvas)) canvas = event.target; //chrome浏览器不认event.originalTarget,只认event.target或event.currentTarget
  688. if (x < PRE_PAGE_OFFSET) {
  689. canvas.style.cursor = "url(/web/building_saas/img/PreviousPage.cur), auto";
  690. } else if ((canvas.width - x) < NEXT_PAGE_OFFSET) {
  691. canvas.style.cursor = "url(/web/building_saas/img/NextPage.cur), auto";
  692. } else {
  693. canvas.style.cursor = "";
  694. }
  695. }
  696. },
  697. canvasOnClick: function(event){
  698. if (zTreeOprObj.currentNode) {
  699. let x = event.offsetX - JpcCanvasOutput.offsetX, canvas = event.originalTarget;
  700. if (!(canvas)) canvas = event.target; //chrome浏览器不认event.originalTarget,只认event.target或event.currentTarget
  701. if (x < FIRST_PAGE_OFFSET) {
  702. zTreeOprObj.showPage(1, canvas);
  703. } else if (x < PRE_PAGE_OFFSET) {
  704. zTreeOprObj.showPage(zTreeOprObj.currentPage - 1, canvas);
  705. } else if ((canvas.width - x) < LAST_PAGE_OFFSET) {
  706. zTreeOprObj.showPage(zTreeOprObj.maxPages, canvas);
  707. } else if ((canvas.width - x) < NEXT_PAGE_OFFSET) {
  708. zTreeOprObj.showPage(zTreeOprObj.currentPage + 1, canvas);
  709. }
  710. }
  711. }
  712. };
  713. let rptControlObj = {
  714. currentOutputType: "Excel",
  715. currentDownloadUrl: null,
  716. currentDownloadIdx: 0,
  717. getCurrentPageSize: function() {
  718. // let rst = "A4";
  719. let rst = document.getElementById("btnRptPageSize").innerHTML.trim();
  720. //btnRptPageSize
  721. return rst;
  722. },
  723. getCurrentOrientation: function() {
  724. // let rst = "横向";
  725. let rst = document.getElementById("btnRptOrientation").innerHTML.trim();
  726. return rst;
  727. },
  728. getCurrentReportOption: function() {
  729. //
  730. },
  731. changeType: function(newType) {
  732. let me = rptControlObj;
  733. let excelDom = document.getElementById("EXCEL_TYPE");
  734. let pdfDom = document.getElementById("PDF_TYPE");
  735. if (newType === "Excel") {
  736. excelDom.className = "btn btn-block btn-primary";
  737. pdfDom.className = "btn btn-block btn-outline-secondary";
  738. me.currentOutputType = newType;
  739. } else if (newType === "PDF") {
  740. excelDom.className = "btn btn-block btn-outline-secondary";
  741. pdfDom.className = "btn btn-block btn-primary";
  742. me.currentOutputType = newType;
  743. } else {
  744. //me.currentOutputType = newType;
  745. }
  746. },
  747. outputRpt: function() {
  748. let me = rptControlObj;
  749. if (me.currentOutputType === "Excel") {
  750. me.getExcel();
  751. } else if (me.currentOutputType === "PDF") {
  752. me.getPDF();
  753. } else {
  754. //other types if needed.
  755. }
  756. },
  757. getTplIdsCommon: function (refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names) {
  758. for (let node of zTreeOprObj.checkedRptTplNodes) {
  759. if (node.hasOwnProperty('flags') && node.flags.hasOwnProperty('reportType') && node['flags']['reportType'] !== 'NA' && node['flags']['reportType'] !== null) {
  760. if (node['flags']['reportType'] === 'billSummary') {
  761. refBillSumPrjsIds.push(node.refId);
  762. if (bill_rpt_names) bill_rpt_names.push(node.name);
  763. } else if (node['flags']['reportType'] === 'gljSummary') {
  764. refGljSumPrjsIds.push(node.refId);
  765. if (glj_rpt_names) glj_rpt_names.push(node.name);
  766. }
  767. } else {
  768. refRptTplIds.push(node.refId);
  769. if (rpt_names) rpt_names.push(node.name);
  770. }
  771. }
  772. },
  773. creatCommonExportParam: function (refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds) {
  774. let nodes = (zTreeOprObj.prjFolderTreeObj === null)?[]:zTreeOprObj.prjFolderTreeObj.getCheckedNodes(true);
  775. let rst = {};
  776. rst.prj_id = projectObj.project.projectInfo.ID;
  777. rst.rpt_ids = refRptTplIds;
  778. rst.rpt_bill_tpl_ids = refBillSumPrjsIds;
  779. rst.rpt_glj_tpl_ids = refGljSumPrjsIds;
  780. rst.prjIds = [];
  781. zTreeOprObj.selectedPrjIDs = [];
  782. for (let node of nodes) {
  783. if (node.level > 0) {
  784. rst.prjIds.push(node.ID);
  785. zTreeOprObj.selectedPrjIDs.push(node.ID);
  786. }
  787. }
  788. // rst.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  789. // rst.rpt_names = rpt_names;
  790. // rst.isOneSheet = true;
  791. rst.pageSize = rptControlObj.getCurrentPageSize();
  792. rst.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:rptControlObj.getCurrentOrientation());
  793. rst.custCfg = zTreeOprObj.reportPageCfg;
  794. rst.option = "normal";
  795. return rst;
  796. },
  797. getAllInOneBook: function () {
  798. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  799. let me = rptControlObj;
  800. let orgRptName = projectObj.project.projectInfo.name;
  801. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  802. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  803. if (zTreeOprObj.selectedPrjIDs.length > 0 && (refBillSumPrjsIds.length > 0 || refGljSumPrjsIds.length > 0)) {
  804. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  805. params.rptName = orgRptName;
  806. $.bootstrapLoading.start();
  807. CommonAjax.postEx("report_api/createExcelFilesInOneBook", params, WAIT_TIME_EXPORT, true, function(result){
  808. if (result) {
  809. $.bootstrapLoading.end();
  810. let uuIdUrls = [];
  811. let uuIdUrl = "/report_api/getFileByUUID/" + result.uuid + "/" + stringUtil.replaceAll(result.reportName, "#", "_") + "/xlsx";
  812. uuIdUrls.push(uuIdUrl);
  813. downloadReport(uuIdUrls);
  814. } else {
  815. $.bootstrapLoading.end();
  816. }
  817. },
  818. function(failRst){
  819. $.bootstrapLoading.end();
  820. console.log(failRst);
  821. },
  822. function(exceptionRst){
  823. $.bootstrapLoading.end();
  824. console.log(exceptionRst);
  825. }
  826. );
  827. } else {
  828. if (refBillSumPrjsIds.length > 0 || refGljSumPrjsIds.length > 0) {
  829. $("#divReqBillSummary")[0].style.display = "none";
  830. $("#divReqGljSummary")[0].style.display = "none";
  831. $("#divReqCommonSummaryExcel")[0].style.display = "";
  832. $("#divReqCommonSummaryMultiExcel")[0].style.display = "none";
  833. $("#divReqCommonSummaryPDF")[0].style.display = "none";
  834. zTreeOprObj.requestPrjFolderCommon(); //先处理需要汇总的报表,走另外一个分支
  835. } else if (refRptTplIds.length > 0) {
  836. let params = {};
  837. params.prj_id = projectObj.project.projectInfo.ID;
  838. params.rpt_ids = refRptTplIds;
  839. params.rptName = orgRptName;
  840. params.pageSize = me.getCurrentPageSize();
  841. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  842. params.custCfg = zTreeOprObj.reportPageCfg;
  843. params.option = "normal";
  844. $.bootstrapLoading.start();
  845. CommonAjax.postEx("report_api/createExcelFilesInOneBook", params, WAIT_TIME_EXPORT, true, function(result){
  846. if (result) {
  847. $.bootstrapLoading.end();
  848. let uuIdUrls = [];
  849. let uuIdUrl = "/report_api/getFileByUUID/" + result.uuid + "/" + stringUtil.replaceAll(result.reportName, "#", "_") + "/xlsx";
  850. uuIdUrls.push(uuIdUrl);
  851. downloadReport(uuIdUrls);
  852. } else {
  853. $.bootstrapLoading.end();
  854. }
  855. },
  856. function(failRst){
  857. $.bootstrapLoading.end();
  858. console.log(failRst);
  859. },
  860. function(exceptionRst){
  861. $.bootstrapLoading.end();
  862. console.log(exceptionRst);
  863. }
  864. );
  865. }
  866. }
  867. }
  868. },
  869. getAllIndividualExcelBook: function () {
  870. let me = rptControlObj;
  871. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  872. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  873. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  874. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  875. if (zTreeOprObj.selectedPrjIDs.length > 0 && (glj_rpt_names.length > 0 || bill_rpt_names.length > 0)) {
  876. let params = rptControlObj.creatCommonExportParam(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds);
  877. params.prj_id = projectObj.project.projectInfo.ID;
  878. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  879. params.rpt_names = rpt_names;
  880. params.isOneSheet = true;
  881. params.rptName = projectObj.project.projectInfo.name;
  882. $.bootstrapLoading.start();
  883. CommonAjax.postEx("report_api/createExcelFiles", params, WAIT_TIME_EXPORT, true, function(result){
  884. if (result) {
  885. $.bootstrapLoading.end();
  886. let uuIdUrls = [];
  887. for (let uuIdObj of result) {
  888. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/xlsx";
  889. uuIdUrls.push(uuIdUrl);
  890. }
  891. downloadReport(uuIdUrls);
  892. } else {
  893. $.bootstrapLoading.end();
  894. }
  895. },
  896. function(failRst){
  897. $.bootstrapLoading.end();
  898. console.log(failRst);
  899. },
  900. function(exceptionRst){
  901. $.bootstrapLoading.end();
  902. console.log(exceptionRst);
  903. }
  904. );
  905. } else {
  906. if (refBillSumPrjsIds.length > 0 || refGljSumPrjsIds.length > 0) {
  907. $("#divReqBillSummary")[0].style.display = "none";
  908. $("#divReqGljSummary")[0].style.display = "none";
  909. $("#divReqCommonSummaryExcel")[0].style.display = "none";
  910. $("#divReqCommonSummaryMultiExcel")[0].style.display = "";
  911. $("#divReqCommonSummaryPDF")[0].style.display = "none";
  912. zTreeOprObj.requestPrjFolderCommon(); //先处理需要汇总的报表,走另外一个分支
  913. } else if (refRptTplIds.length > 0) {
  914. let params = {};
  915. params.prj_id = projectObj.project.projectInfo.ID;
  916. params.rpt_ids = refRptTplIds;
  917. params.rpt_names = rpt_names;
  918. params.pageSize = me.getCurrentPageSize();
  919. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  920. params.isOneSheet = true;
  921. params.custCfg = zTreeOprObj.reportPageCfg;
  922. params.option = "normal";
  923. $.bootstrapLoading.start();
  924. CommonAjax.postEx("report_api/createExcelFiles", params, WAIT_TIME_EXPORT, true, function(result){
  925. if (result) {
  926. $.bootstrapLoading.end();
  927. let uuIdUrls = [];
  928. for (let uuIdObj of result) {
  929. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/xlsx";
  930. uuIdUrls.push(uuIdUrl);
  931. }
  932. downloadReport(uuIdUrls);
  933. } else {
  934. $.bootstrapLoading.end();
  935. }
  936. },
  937. function(failRst){
  938. $.bootstrapLoading.end();
  939. console.log(failRst);
  940. },
  941. function(exceptionRst){
  942. $.bootstrapLoading.end();
  943. console.log(exceptionRst);
  944. }
  945. );
  946. }
  947. }
  948. }
  949. },
  950. checkAndGetExcel: function () {
  951. if (zTreeOprObj.isFreeUser && !commonUtil.isGLYun()) {//2020-11-25 zhang 公路云版,免费版允许打印、导出报表
  952. hintBox.versionBox('对不起,您当前使用的是学习版,不提供导出、打印报表功能,请联系我们的客服人员。');
  953. return;
  954. }
  955. if (zTreeOprObj.treeObj) {
  956. let chkNodes = zTreeOprObj.treeObj.getCheckedNodes(true);
  957. if (chkNodes.length > 0) {
  958. $("#show_excel_output_cfg").trigger("click");
  959. } else {
  960. rptControlObj.getAllIndividualExcelBook();
  961. }
  962. }
  963. },
  964. getExcel: function () {
  965. let me = rptControlObj;
  966. if ($("#excelExportType_AllInOneBook").get(0).checked) {
  967. me.getAllInOneBook();
  968. } else if ($("#excelExportType_IndividualBook").get(0).checked) {
  969. me.getAllIndividualExcelBook();
  970. }
  971. },
  972. getPDF: function () {
  973. let me = rptControlObj;
  974. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  975. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  976. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  977. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  978. if (zTreeOprObj.selectedPrjIDs.length > 0 && (glj_rpt_names.length > 0 || bill_rpt_names.length > 0)) {
  979. let params = rptControlObj.creatCommonExportParam();
  980. params.prj_id = projectObj.project.projectInfo.ID;
  981. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  982. params.rpt_ids = refRptTplIds;
  983. params.rpt_bill_tpl_ids = refBillSumPrjsIds;
  984. params.rpt_glj_tpl_ids = refGljSumPrjsIds;
  985. params.rpt_names = rpt_names;
  986. params.isOneSheet = true;
  987. params.rptName = projectObj.project.projectInfo.name;
  988. CommonAjax.postEx("report_api/createPdfFiles", params, WAIT_TIME_EXPORT, true, function(result){
  989. if (result) {
  990. let uuIdUrls = [];
  991. for (let uuIdObj of result) {
  992. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/pdf";
  993. uuIdUrls.push(uuIdUrl);
  994. }
  995. downloadReport(uuIdUrls);
  996. } else {
  997. //
  998. }
  999. }, null, null
  1000. );
  1001. } else {
  1002. if (refBillSumPrjsIds.length > 0 || refGljSumPrjsIds.length > 0) {
  1003. $("#divReqBillSummary")[0].style.display = "none";
  1004. $("#divReqGljSummary")[0].style.display = "none";
  1005. $("#divReqCommonSummaryExcel")[0].style.display = "none";
  1006. $("#divReqCommonSummaryMultiExcel")[0].style.display = "none";
  1007. $("#divReqCommonSummaryPDF")[0].style.display = "";
  1008. zTreeOprObj.requestPrjFolderCommon(); //先处理需要汇总的报表,走另外一个分支
  1009. } else if (refRptTplIds.length > 0) {
  1010. let params = {};
  1011. params.prj_id = projectObj.project.projectInfo.ID;
  1012. params.rpt_ids = refRptTplIds;
  1013. params.rpt_names = rpt_names;
  1014. params.pageSize = me.getCurrentPageSize();
  1015. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  1016. params.custCfg = zTreeOprObj.reportPageCfg;
  1017. params.option = "normal";
  1018. CommonAjax.postEx("report_api/createPdfFiles", params, WAIT_TIME_EXPORT, true, function(result){
  1019. if (result) {
  1020. let uuIdUrls = [];
  1021. for (let uuIdObj of result) {
  1022. let uuIdUrl = "/report_api/getFileByUUID/" + uuIdObj.uuid + "/" + stringUtil.replaceAll(uuIdObj.reportName, "#", "_") + "/pdf";
  1023. uuIdUrls.push(uuIdUrl);
  1024. }
  1025. downloadReport(uuIdUrls);
  1026. } else {
  1027. //
  1028. }
  1029. }, null, null
  1030. );
  1031. }
  1032. }
  1033. }
  1034. },
  1035. _hidePdfIniPage: function () {
  1036. if ($('#ini_PDF_cover').is(':visible')) {
  1037. // $("#ini_PDF_Btn_Cancel").trigger("click");
  1038. // 因在Z+可能会有冲突,所以暴力关闭初始化PDF页面!
  1039. $('#ini_PDF_cover').remove();
  1040. if ($("div.modal-backdrop.fade.show")) {
  1041. $('div.modal-backdrop.fade.show').remove();
  1042. }
  1043. }
  1044. },
  1045. getPdfFontCallback: function(fontProperty) {
  1046. let me = rptControlObj;
  1047. rptTplObj.pdfFont['SmartSimsun'].push(fontProperty);
  1048. if (rptTplObj.pdfFont['SmartSimsun'].length === 2) {
  1049. me._hidePdfIniPage();
  1050. setTimeout(function() {
  1051. me.getPDFEx();
  1052. }, 50); // 50毫秒足够关闭PDF初始化page了
  1053. }
  1054. },
  1055. getPDFPre: function () {
  1056. let me = rptControlObj;
  1057. if (zTreeOprObj.isFreeUser && !commonUtil.isGLYun()) {//2020-11-25 zhang 公路云版,免费版允许打印、导出报表
  1058. hintBox.versionBox('对不起,您当前使用的是学习版,不提供导出、打印报表功能,请联系我们的客服人员。');
  1059. return;
  1060. }
  1061. if (rptTplObj.pdfFont['SmartSimsun'].length === 2) {
  1062. me.getPDFEx();
  1063. } else {
  1064. // dynamicLoadJs('/lib/jspdf/SmartSimsun-normal.js', 'normal', me.getPdfFontCallback);
  1065. // dynamicLoadJs('/lib/jspdf/SmartSimsun-bold.js', 'bold', me.getPdfFontCallback);
  1066. $("#ini_PDF_Btn").trigger("click");
  1067. dynamicLoadJs('https://d2.smartcost.com.cn/cach/SmartSimsun-normal.js', 'normal', me.getPdfFontCallback);
  1068. dynamicLoadJs('https://d2.smartcost.com.cn/cach/SmartSimsun-bold.js', 'bold', me.getPdfFontCallback);
  1069. }
  1070. },
  1071. getPDFEx: function () {
  1072. let me = rptControlObj;
  1073. if (zTreeOprObj.checkedRptTplNodes && zTreeOprObj.checkedRptTplNodes.length > 0) {
  1074. let refRptTplIds = [], refBillSumPrjsIds = [], refGljSumPrjsIds = [];
  1075. let rpt_names = [], bill_rpt_names = [], glj_rpt_names = [];
  1076. rptControlObj.getTplIdsCommon(refRptTplIds, refBillSumPrjsIds, refGljSumPrjsIds, rpt_names, bill_rpt_names, glj_rpt_names);
  1077. // refRptTplIds获取的是
  1078. if (zTreeOprObj.selectedPrjIDs.length > 0 && (glj_rpt_names.length > 0 || bill_rpt_names.length > 0)) {
  1079. let params = rptControlObj.creatCommonExportParam();
  1080. params.prj_id = projectObj.project.projectInfo.ID;
  1081. params.sum_rpt_names = bill_rpt_names.concat(glj_rpt_names);
  1082. params.rpt_ids = refRptTplIds;
  1083. params.rpt_bill_tpl_ids = refBillSumPrjsIds;
  1084. params.rpt_glj_tpl_ids = refGljSumPrjsIds;
  1085. params.rpt_names = rpt_names;
  1086. params.isOneSheet = true;
  1087. params.rptName = projectObj.project.projectInfo.name;
  1088. $.bootstrapLoading.start();
  1089. CommonAjax.postEx("report_api/getMultiReports", params, WAIT_TIME_EXPORT, true,
  1090. function(result){
  1091. $.bootstrapLoading.end();
  1092. me._hidePdfIniPage();
  1093. let pageSize = rptControlObj.getCurrentPageSize();
  1094. let rstRptNames = [];
  1095. for (let idx = 0; idx < result.length; idx++) {
  1096. rstRptNames.push(result[idx][JV.NODE_PAGE_INFO][JV.NODE_MAIN_INFO_RPT_NAME]);
  1097. }
  1098. downloadPDFReport(result, pageSize, rstRptNames);
  1099. // for (let idx = 0; idx < result.length; idx++) {
  1100. // let pageData = result[idx];
  1101. // JpcJsPDFHelper.outputAsPdf(pageData, pageSize, result[idx][JV.NODE_PAGE_INFO][JV.NODE_MAIN_INFO_RPT_NAME]);
  1102. // }
  1103. },
  1104. function(failRst){
  1105. $.bootstrapLoading.end();
  1106. me._hidePdfIniPage();
  1107. console.log(failRst);
  1108. },
  1109. function(exceptionRst){
  1110. $.bootstrapLoading.end();
  1111. me._hidePdfIniPage();
  1112. console.log(exceptionRst);
  1113. }
  1114. );
  1115. } else {
  1116. if (refBillSumPrjsIds.length > 0 || refGljSumPrjsIds.length > 0) {
  1117. $("#divReqBillSummary")[0].style.display = "none";
  1118. $("#divReqGljSummary")[0].style.display = "none";
  1119. $("#divReqCommonSummaryExcel")[0].style.display = "none";
  1120. $("#divReqCommonSummaryMultiExcel")[0].style.display = "none";
  1121. $("#divReqCommonSummaryPDF")[0].style.display = "";
  1122. zTreeOprObj.requestPrjFolderCommon(); //先处理需要汇总的报表,走另外一个分支
  1123. } else if (refRptTplIds.length > 0) {
  1124. let params = {};
  1125. params.prj_id = projectObj.project.projectInfo.ID;
  1126. params.rpt_ids = refRptTplIds;
  1127. params.rpt_names = rpt_names;
  1128. params.pageSize = me.getCurrentPageSize();
  1129. params.orientation = ((zTreeOprObj.checkedRptTplNodes.length > 1)?null:me.getCurrentOrientation());
  1130. params.custCfg = zTreeOprObj.reportPageCfg;
  1131. params.option = "normal";
  1132. $.bootstrapLoading.start();
  1133. CommonAjax.postEx("report_api/getMultiReports", params, WAIT_TIME_EXPORT, true,
  1134. function(result){
  1135. $.bootstrapLoading.end();
  1136. me._hidePdfIniPage();
  1137. let pageSize = rptControlObj.getCurrentPageSize();
  1138. downloadPDFReport(result, pageSize, rpt_names);
  1139. // for (let idx = 0; idx < result.length; idx++) {
  1140. // let pageData = result[idx];
  1141. // JpcJsPDFHelper.outputAsPdf(pageData, pageSize, rpt_names[idx]);
  1142. // }
  1143. },
  1144. function(failRst){
  1145. $.bootstrapLoading.end();
  1146. me._hidePdfIniPage();
  1147. console.log(failRst);
  1148. },
  1149. function(exceptionRst){
  1150. $.bootstrapLoading.end();
  1151. me._hidePdfIniPage();
  1152. console.log(exceptionRst);
  1153. }
  1154. );
  1155. } else {
  1156. //这个分支是为了减少请求,用户已经点过的表,又没有勾选,那么就直接导出成PDF,不过貌似已经走不到这里了
  1157. let pageSize = rptControlObj.getCurrentPageSize();
  1158. let pageData = zTreeOprObj.currentRptPageRst;
  1159. $.bootstrapLoading.end();
  1160. me._hidePdfIniPage();
  1161. if (pageData) {
  1162. JpcJsPDFHelper.outputAsPdf(pageData, pageSize, zTreeOprObj.currentNode.name);
  1163. }
  1164. }
  1165. }
  1166. } else {
  1167. $.bootstrapLoading.end();
  1168. }
  1169. },
  1170. firstPage: function(dom) {
  1171. let canvas = document.getElementById("rptCanvas");
  1172. zTreeOprObj.showPage(1, canvas);
  1173. },
  1174. prePage: function(dom) {
  1175. let canvas = document.getElementById("rptCanvas");
  1176. zTreeOprObj.showPage(zTreeOprObj.currentPage - 1, canvas);
  1177. },
  1178. nextPage: function(dom) {
  1179. let canvas = document.getElementById("rptCanvas");
  1180. zTreeOprObj.showPage(zTreeOprObj.currentPage + 1, canvas);
  1181. },
  1182. lastPage: function(dom) {
  1183. let me = zTreeOprObj;
  1184. let canvas = document.getElementById("rptCanvas");
  1185. zTreeOprObj.showPage(me.maxPages, canvas);
  1186. },
  1187. onKeydown: function (event, dom) {
  1188. let me = zTreeOprObj, keyPressed = null;
  1189. if (window.event) {
  1190. keyPressed = window.event.keyCode; // IE/Chrome
  1191. } else {
  1192. keyPressed = event.which; // Firefox
  1193. }
  1194. if (keyPressed === 13) {
  1195. let pageNum = 1;
  1196. try {
  1197. pageNum = parseInt(dom.value);
  1198. } catch (e) {
  1199. pageNum = 1;
  1200. }
  1201. let canvas = document.getElementById("rptCanvas");
  1202. if (pageNum < 1) {
  1203. pageNum = 1;
  1204. } else if (pageNum > me.maxPages) {
  1205. pageNum = me.maxPages;
  1206. }
  1207. zTreeOprObj.showPage(pageNum, canvas);
  1208. return false;
  1209. }
  1210. },
  1211. changeMargin: function(marginPropStr, marginDom) {
  1212. zTreeOprObj.reportPageCfg.margins[marginPropStr] = marginDom.value;
  1213. },
  1214. changeFontMain: function(CfgDispName, fontProperty, fontDom) {
  1215. for (let font of zTreeOprObj.reportPageCfg.fonts) {
  1216. if (font["CfgDispName"] === CfgDispName) {
  1217. font[fontProperty] = fontDom.value;
  1218. break;
  1219. }
  1220. }
  1221. },
  1222. changeCfgOption: function (optStr, dom) {
  1223. zTreeOprObj.reportPageCfg[optStr] = dom.checked;
  1224. },
  1225. changeFontAdhoc: function(CfgDispName, fontProperty, fontDom) {
  1226. for (let font of zTreeOprObj.reportPageCfg.fonts) {
  1227. if (font["CfgDispName"] === CfgDispName) {
  1228. if (font[fontProperty] === 'T') {
  1229. font[fontProperty] = 'F';
  1230. fontDom.className = "btn btn-sm btn-outline-secondary";
  1231. } else {
  1232. font[fontProperty] = 'T';
  1233. fontDom.className = "btn btn-sm btn-outline-secondary active";
  1234. }
  1235. break;
  1236. }
  1237. }
  1238. },
  1239. restoreCustCFG: function () {
  1240. let me = this;
  1241. zTreeOprObj.renderRptCfg(zTreeOprObj.defReportPageCfg);
  1242. zTreeOprObj.extractRptCfg(zTreeOprObj.reportPageCfg);
  1243. me.saveCustCfg();
  1244. },
  1245. saveCustCfg: function() {
  1246. let params = {};
  1247. params.custCfg = zTreeOprObj.reportPageCfg;
  1248. CommonAjax.postEx("report_tpl_api/saveCustomerCfg", params, 20000, true, function(result){
  1249. // alert("Save successfully!");
  1250. $("#update_msg_response")[0].style.color = "green";
  1251. $("#update_msg_response")[0].innerHTML = " (保存成功!)";
  1252. setTimeout(function(){
  1253. $("#update_msg_response")[0].innerHTML = "";
  1254. }, 1000);
  1255. }, function (failRst) {
  1256. $("#update_msg_response")[0].style.color = "red";
  1257. $("#update_msg_response")[0].innerHTML = " (保存失败!)";
  1258. setTimeout(function(){
  1259. $("#update_msg_response")[0].innerHTML = "";
  1260. }, 1000);
  1261. }, null
  1262. );
  1263. },
  1264. confirmCfgChange: function() {
  1265. zTreeOprObj.changeCfg();
  1266. }
  1267. };
  1268. function downloadPDFReport(pageDataArr, pageSize, rpt_names) {
  1269. rptControlObj.currentDownloadIdx = 0;
  1270. const private_download = function() {
  1271. if (rptControlObj.currentDownloadIdx < pageDataArr.length) {
  1272. let pageData = pageDataArr[rptControlObj.currentDownloadIdx];
  1273. let rptName = rpt_names[rptControlObj.currentDownloadIdx];
  1274. rptControlObj.currentDownloadIdx++;
  1275. JpcJsPDFHelper.outputAsPdf(pageData, pageSize, rptName);
  1276. if (rptControlObj.currentDownloadIdx < pageDataArr.length) setTimeout(private_download, 1000);
  1277. }
  1278. }
  1279. private_download();
  1280. }
  1281. function downloadReport(urls) {
  1282. //考虑到多个报表下载,一些浏览器(如chrome)不允许一下子下载多个文件,得缓缓处理,统一在这处理
  1283. rptControlObj.currentDownloadUrl = null;
  1284. rptControlObj.currentDownloadIdx = 0;
  1285. let private_download = function() {
  1286. if (rptControlObj.currentDownloadIdx >= 0 && rptControlObj.currentDownloadIdx < urls.length) {
  1287. rptControlObj.currentDownloadUrl = urls[rptControlObj.currentDownloadIdx];
  1288. rptControlObj.currentDownloadIdx++;
  1289. window.location = rptControlObj.currentDownloadUrl;
  1290. setTimeout(private_download, 2000);
  1291. }
  1292. }
  1293. private_download();
  1294. }
  1295. function dynamicLoadJs(url, type, callback) {
  1296. let head = document.getElementsByTagName('head')[0];
  1297. let script = document.createElement('script');
  1298. script.type = 'text/javascript';
  1299. script.src = url;
  1300. if(callback) {
  1301. script.onload = script.onreadystatechange = function (event) {
  1302. // console.log('this.readyState: ' + this.readyState);
  1303. callback(type);
  1304. script.onload = script.onreadystatechange = null;
  1305. // if (this.readyState === "loaded" || this.readyState === "complete"){
  1306. // }
  1307. };
  1308. }
  1309. head.appendChild(script);
  1310. }
  1311. function dynamicLoadCss(url) {
  1312. let head = document.getElementsByTagName('head')[0];
  1313. let link = document.createElement('link');
  1314. link.type='text/css';
  1315. link.rel = 'stylesheet';
  1316. link.href = url;
  1317. head.appendChild(link);
  1318. }