toStatement.jsp 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251
  1. <%@ page language="java" contentType="text/html;charset=GBK" pageEncoding="GBK"%>
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  3. <html>
  4. <head>
  5. <meta http-equiv="Content-Type" content="text/html;charset=GBK">
  6. <title>车辆图形报表</title>
  7. <link href="/shares/js/yw/master1/liger/skins/ynet/css/ligerui-all.css" rel="stylesheet" type="text/css" />
  8. <link href="/shares/css/yw/master1/reset.css" rel="stylesheet" type="text/css" />
  9. <script type="text/javascript" src="/shares/datePicker/WdatePicker.js"></script>
  10. <script type="text/javascript" src="/shares/js/jquery-1.9.0.min.js"></script>
  11. <script type="text/javascript" src="/shares/highcharts/js/highcharts.js"></script>
  12. <script type="text/javascript" src="/shares/highcharts/js/modules/exporting.js"></script>
  13. <script type="text/javascript" src="/shares/highcharts/js/modules/data.js"></script>
  14. <!-- <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script> -->
  15. <!-- <script src="http://code.highcharts.com/highcharts.js"></script> -->
  16. <link href="/shares/css/yw/master1/reset.css" rel="stylesheet" type="text/css" />
  17. <style type="text/css">
  18. body {
  19. overflow: hidden;
  20. background: #fff;
  21. }
  22. .default_search li{height:25px}
  23. .default_search ul{display:inline;width:250px;float:left;}
  24. .default_search li.text{float:left;width:151px;padding-top:5px;}
  25. .default_search li.title{float:left;width:90px;padding-top:9px;text-align: right;padding-left: 5px; font-size: 13px;font-weight: normal;}
  26. .search-button {padding-top:5px;float:left;}
  27. .default_search li input[type='text']{width:100px;background:#fff; height:18px;border-style: inherit; line-height: 18px}
  28. .default_search li select{height:20px;border-style: inherit; line-height: 21px; }
  29. </style>
  30. <script type="text/javascript">
  31. $(function (){
  32. createQuarterChartForOut();
  33. });
  34. function createQuarterChartForOut() {
  35. changeQuarterChart();
  36. var plate_number = new Array();
  37. var car_count = [];
  38. var car_date = [];
  39. var car_mileage = [];
  40. $.ajax({
  41. type : "POST",
  42. url : "carStatisticReportAction.do?task=getChartDataForOut",
  43. dataType : 'json',
  44. async : false,
  45. success : function(data) {
  46. if (data != null && data.length != 0) {
  47. for (var i = 0; i < data.length; i++) {
  48. plate_number[i] = new Array(data[i].plate_number);
  49. car_count[i] = data[i].car_count;
  50. car_date[i] = data[i].car_date==undefined?0:data[i].car_date;
  51. car_mileage[i] = data[i].car_mileage==undefined?0:data[i].car_mileage;
  52. }
  53. }
  54. }
  55. });
  56. $('#container').highcharts({
  57. chart: {
  58. type: 'column'
  59. },
  60. lang : {
  61. printChart : '打印图表',
  62. downloadJPEG : '下载JPEG图片',
  63. downloadPDF : '下载PDF文件',
  64. downloadPNG : '下载PNG图片',
  65. downloadSVG : '下载SVG矢量图'
  66. },
  67. credits : {
  68. enabled : false
  69. },
  70. title: {
  71. text: '出车详细报表',
  72. style: {
  73. fontSize: "28px"
  74. }
  75. },
  76. xAxis: {
  77. categories: plate_number
  78. },
  79. yAxis: {
  80. min: 0,
  81. title: {
  82. text: '数值'
  83. }
  84. },
  85. tooltip: {
  86. headerFormat: '<span style="font-size:10px">{point.key}</span><table>',
  87. pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' +
  88. '<td style="padding:0"><b>{point.y:.0f}</b></td></tr>',
  89. footerFormat: '</table>',
  90. shared: true,
  91. useHTML: true
  92. },
  93. plotOptions: {
  94. column: {
  95. pointPadding: 0.2,
  96. borderWidth: 0
  97. }
  98. },
  99. series: [{
  100. name: '出车次数',
  101. data: car_count
  102. }, {
  103. name: '行驶里程',
  104. data: car_mileage
  105. }, {
  106. name: '出车天数',
  107. data: car_date
  108. }]
  109. });
  110. }
  111. function createQuarterChartForCost() {
  112. var dictionary_name = [];
  113. var money = [];
  114. var contributions_date = $("#contributions_date").val();
  115. if("" == contributions_date){
  116. document.getElementById("msg").innerHTML="<font color='red'>&nbsp;请选择年份!</font>";
  117. return;
  118. }else{
  119. document.getElementById("msg").innerHTML="";
  120. }
  121. $.ajax({
  122. type : "POST",
  123. url : "carStatisticReportAction.do?task=getChartDataForCost&contributions_date="+contributions_date,
  124. dataType : 'json',
  125. async : false,
  126. success : function(data) {
  127. if (data != null && data.length != 0) {
  128. for (var i = 0; i < data.length; i++) {
  129. dictionary_name[i] = data[i].dictionary_name;
  130. money[i] = data[i].money;
  131. }
  132. }
  133. }
  134. });
  135. $('#container').highcharts({
  136. chart: {
  137. type: 'line'
  138. },
  139. lang : {
  140. printChart : '打印图表',
  141. downloadJPEG : '下载JPEG图片',
  142. downloadPDF : '下载PDF文件',
  143. downloadPNG : '下载PNG图片',
  144. downloadSVG : '下载SVG矢量图'
  145. },
  146. credits : {
  147. enabled : false
  148. },
  149. title: {
  150. text: contributions_date+'年度车辆费用统计',
  151. style: {
  152. fontSize: "28px"
  153. }
  154. },
  155. xAxis: {
  156. categories: dictionary_name
  157. },
  158. yAxis: {
  159. title: {
  160. text: '金额'
  161. }
  162. },
  163. tooltip: {
  164. enabled: false,
  165. formatter: function() {
  166. return '<b>'+ this.series.name +'</b><br/>'+this.x +': '+ this.y;
  167. }
  168. },
  169. plotOptions: {
  170. line: {
  171. dataLabels: {
  172. enabled: true
  173. },
  174. enableMouseTracking: false
  175. }
  176. },
  177. series: [{
  178. name: '金额',
  179. data: money
  180. }]
  181. });
  182. }
  183. function changeQuarterChart(type){
  184. document.getElementById("container").innerHTML="";
  185. if(type == '0'){
  186. document.getElementById("year").style.display="";
  187. createQuarterChartForCost();
  188. }else{
  189. document.getElementById("year").style.display="none";
  190. }
  191. }
  192. </script>
  193. </head>
  194. <body>
  195. <div class="s_title b10 f6">
  196. <img src="/shares/images/master1/fqlc.png" width="27" height="26" /> 报表分析
  197. </div>
  198. <div class="container-layout" style="margin-top: 50px;">
  199. <div class="lc_b_div">
  200. <div class="lc_btn">
  201. <a href="#" class="f8" onclick="createQuarterChartForOut();" title="出车详细报表">
  202. <img src="/shares/images/master1/lc_ico.png" width="19" height="21" />出车详细报表
  203. </a>
  204. </div>
  205. <div class="lc_btn">
  206. <a href="#" class="f8" onclick="changeQuarterChart('0');" title="年度车辆费用统计">
  207. <img src="/shares/images/master1/lc_ico.png" width="19" height="21" />年度车辆费用统计
  208. </a>
  209. </div>
  210. </div>
  211. <div id="year" class="default_search" style="margin: 0;display: none;">
  212. <ul class="list_search">
  213. <li class="title" style="width: 100px;font-family:'新宋体';font-size:9pt;">年度:</li>
  214. <li class="text" style="width: 135px;">
  215. <input type="text" class="Wdate" name="contributions_date" id="contributions_date" onclick="WdatePicker({dateFmt:'yyyy'})"
  216. value="${requestScope.currentYear }">
  217. </li>
  218. </ul>
  219. <div style="float: left;">
  220. <input type="button" class="l-button" value="生成报表" onclick="createQuarterChartForCost()" style="width: 80px;" />
  221. </div>
  222. <div id="msg" style="float: left;"></div>
  223. </div>
  224. <div id="container" style="min-width: 700px; height: 400px"></div>
  225. </div>
  226. </body>
  227. </html>