rpt_main.js 37 KB

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