RptHome.html 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  5. <title>Report Demo!</title>
  6. </head>
  7. <body>
  8. <!--
  9. <script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
  10. -->
  11. <script src="/lib/jquery/jquery.min.js"></script>
  12. <script type="text/javascript" src="/web/report/js/Jpc_Output_ValueDefine.js"></script>
  13. <script type="text/javascript" src="/web/report/js/Jpc_Output.js"></script>
  14. <table id="forPrintHide">
  15. <tr>
  16. <td width="5"></td>
  17. <td>
  18. <select name="select1" id="select_k1" onchange="ajaxCall()">
  19. <option value="SC;07_1">07-1表</option>
  20. <option value="SC;08_2">08-2表</option>
  21. <option value="MEASURE;M_ZB03_QDZF_09">计量-清单支付09表</option>
  22. </select>
  23. <select name="select2" id="select_k2" onchange="ajaxCall()">
  24. <option value="A4">A4</option>
  25. <option value="A3">A3</option>
  26. </select>
  27. </td>
  28. <td>
  29. <input type="button" value="显示报表" onclick="ajaxCall()"/>
  30. <input type="button" value="< 前一页" onclick="showPage(-1)"/>
  31. <input type="button" value="后一页 >" onclick="showPage(1)"/>
  32. <input type="button" value="打印" onclick="printCurrentPage()"/>
  33. <input type="button" value="Excel" onclick="getExcel()"/>
  34. </td>
  35. </tr>
  36. </table>
  37. <canvas id="myCanvas" width="2000" height="1280">
  38. </canvas>
  39. </body>
  40. <style>
  41. body {
  42. margin: 0px;
  43. padding: 0px;
  44. }
  45. #myCanvas {
  46. border: 0px solid #9C9898;
  47. }
  48. </style>
  49. <script>
  50. var currentPage = 1;
  51. var pageRst = null;
  52. var currentRptTpl = null;
  53. var maxPages = 20;
  54. var defProperties = null;
  55. var rpt_grp = null;
  56. var rpt_id = null;
  57. var rpt_size = null;
  58. function printCurrentPage() {
  59. if (currentRptTpl) {
  60. //$("table#forPrintHide").css
  61. $("table#forPrintHide").css("display","none");
  62. window.print();
  63. //$("canvas#myCanvas").printArea();
  64. }
  65. }
  66. function getScreenDPI() {
  67. var me = this, arrDPI = [];
  68. if (window.screen.deviceXDPI != undefined) {
  69. arrDPI.push(window.screen.deviceXDPI);
  70. arrDPI.push(window.screen.deviceYDPI);
  71. } else {
  72. var tmpNode = document.createElement("DIV");
  73. tmpNode.style.cssText = "width:1in;height:1in;position:absolute;left:0px;top:0px;z-index:99;visibility:hidden";
  74. document.body.appendChild(tmpNode);
  75. arrDPI.push(parseInt(tmpNode.offsetWidth));
  76. arrDPI.push(parseInt(tmpNode.offsetHeight));
  77. tmpNode.parentNode.removeChild(tmpNode);
  78. }
  79. return arrDPI;
  80. }
  81. function setupReport() {
  82. var rst = false;
  83. var rpt = document.getElementById("select_k1");
  84. var size = document.getElementById("select_k2");
  85. if (rpt.selectedIndex >= 0 && size.selectedIndex >= 0) {
  86. var strs = rpt.options[rpt.selectedIndex].value.split(';');
  87. rpt_grp = strs[0];
  88. rpt_id = strs[1];
  89. rpt_size = size.options[size.selectedIndex].value;
  90. rst = true;
  91. }
  92. return rst;
  93. }
  94. function showPage(pageStep, cv) {
  95. if (currentPage + pageStep >= 1 && currentPage + pageStep <= maxPages) {
  96. currentPage = currentPage + pageStep;
  97. var canvas = null;
  98. if (cv) {
  99. canvas = cv;
  100. } else canvas = document.getElementById("myCanvas");
  101. JpcCanvasOutput.cleanCanvas(canvas);
  102. JpcCanvasOutput.drawPageBorder(currentRptTpl, canvas, getScreenDPI());
  103. JpcCanvasOutput.drawToCanvas(pageRst, canvas, currentPage);
  104. }
  105. }
  106. function getDummyExcel() {
  107. var id = "dummy_request_id";
  108. var p1 = "dummy_paramm_2";
  109. var url = "/report_api/getDummyExcel/" + id + "/" + p1;
  110. window.location = url;//这里不能使用get方法跳转,否则下载不成功
  111. }
  112. function getExcel() {
  113. var rpt = document.getElementById("select_k1");
  114. var size = document.getElementById("select_k2");
  115. var rpt_name = rpt.options[rpt.selectedIndex].text;
  116. if (rpt.selectedIndex >= 0 && size.selectedIndex >= 0) {
  117. var strs = rpt.options[rpt.selectedIndex].value.split(';');
  118. rpt_grp = strs[0];
  119. rpt_id = strs[1];
  120. rpt_size = size.options[size.selectedIndex].value;
  121. }
  122. var url = "/report_api/getExcel/" + rpt_grp + "/" + rpt_id + "/" + rpt_size + "/" + rpt_name;
  123. window.location = url;//这里不能使用get方法跳转,否则下载不成功
  124. }
  125. function ajaxCall() {
  126. if (setupReport()) {
  127. var canvas = document.getElementById("myCanvas");
  128. canvas.style.cursor = "wait";
  129. $.ajax({
  130. type:"POST",
  131. url: 'http://localhost:6060/report_api/getReport',
  132. //url: 'http://www.smart_cost_tony.cn:3010/api/getReport',
  133. data: {"grp_id": rpt_grp, "tpl_id": rpt_id, "pageSize": rpt_size},
  134. dataType: 'json',
  135. cache: false,
  136. timeout: 15000,
  137. success: function(result){
  138. canvas.style.cursor = "default";
  139. currentPage = 1;
  140. pageRst = result.data;
  141. if (pageRst) {
  142. maxPages = pageRst.items.length;
  143. currentRptTpl = pageRst;
  144. if (rpt_size === "A4") {
  145. canvas.width = 1200;
  146. canvas.height = 900;
  147. } else if (rpt_size === "A3") {
  148. canvas.width = 1880;
  149. canvas.height = 1200;
  150. }
  151. showPage(0, canvas);
  152. }
  153. },
  154. error: function(jqXHR, textStatus, errorThrown){
  155. canvas.style.cursor = "default";
  156. alert('error ' + textStatus + " " + errorThrown);
  157. }
  158. });
  159. }
  160. }
  161. </script>
  162. </html>