carcyNumStatistics.jsp 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316
  1. <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
  2. <%@ page import="com.runzhixing.tool.Util" %>
  3. <%@ page import="com.runzhixing.bean.CityPlace" %>
  4. <%@ page import="com.runzhixing.bean.CountryPlace" %>
  5. <%@ page import="com.runzhixing.bean.Station" %>
  6. <%@ page import="com.runzhixing.bean.AuthorityRegionPlace" %>
  7. <%@ page import="com.runzhixing.bean.User" %>
  8. <%@ page import="com.runzhixing.constant.Constant" %>
  9. <%
  10. String path = request.getContextPath();
  11. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
  12. User user = (User)session.getAttribute(Constant.userMark);
  13. List<AuthorityRegionPlace> arplist = user.getPrivilegePlaces1();
  14. List<CityPlace> cplist = new ArrayList<CityPlace>();
  15. List<CountryPlace> cyplist = new ArrayList<CountryPlace>();
  16. List<Station> slist = new ArrayList<Station>();
  17. %>
  18. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  19. <html>
  20. <head>
  21. <base href="<%=basePath%>">
  22. <title>车辆气瓶数量统计</title>
  23. <meta http-equiv="pragma" content="no-cache">
  24. <meta http-equiv="cache-control" content="no-cache">
  25. <meta http-equiv="expires" content="0">
  26. <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  27. <meta http-equiv="description" content="This is my page">
  28. <meta http-equiv="X-UA-Compatible" content="IE=9"/>
  29. <meta http-equiv="X-UA-Compatible" content="IE=10"/>
  30. <link rel="stylesheet" type="text/css" href="css/easyui/themes/default/easyui.css">
  31. <link rel="stylesheet" type="text/css" href="css/easyui/themes/icon.css">
  32. <link rel="stylesheet" type="text/css" href="css/easyui/demo/demo.css">
  33. <script type="text/javascript" src="css/easyui/jquery.min.js"></script>
  34. <script type="text/javascript" src="css/easyui/jquery.easyui.min.js" charset="utf-8"></script>
  35. <script type="text/javascript" src="css/easyui/locale/easyui-lang-zh_CN.js" charset="utf-8"></script>
  36. <link rel="stylesheet" type="text/css" href="css/common/hzbstyle.css">
  37. <script type="text/javascript" src="js/common/area.js"></script>
  38. <script src="js/highcharts.js"></script>
  39. <script src="js/exporting.js"></script>
  40. <script src="http://cdn.hcharts.cn/highcharts/modules/offline-exporting.js"></script>
  41. <script type="text/javascript">
  42. var i = 1;//第几页
  43. var sum;//总条数
  44. var totalpage;//总页数
  45. $(document).ready(function(){
  46. fLoadTable();
  47. //fLoadData(1,10);
  48. selectCountry();
  49. });
  50. function fLoadTable(){
  51. $('#tt').datagrid({
  52. fit: true,//自动大小
  53. title: '',
  54. width: '100%',
  55. height: 580,
  56. toolbar: '#toolbar',
  57. fitColumns: true,
  58. singleSelect:false,
  59. loadMsg:'正在加载, 请稍等 …',
  60. nowrap : true,//设置为true,当数据长度超出列宽时将会自动截取
  61. striped : true,//设置为true将交替显示行背景
  62. collapsible : false,//显示可折叠按钮
  63. singleSelect:true,//为true时只能选择单行
  64. fitColumns:true//允许表格自动缩放,以适应父容器
  65. });
  66. }
  67. function fLoadData(page,rows){
  68. var st = $("#startTime").datebox("getValue");
  69. var et = $("#endTime").datebox("getValue");
  70. if(!st||!et){
  71. show("请输入开始时间结束时间!")
  72. return;
  73. }
  74. $.messager.progress({
  75. title: '请等待',
  76. msg: '正在加载数据...',
  77. text: '查询中.......'
  78. });
  79. $.ajax({
  80. type:"POST",
  81. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  82. data:$('#carDateStatistform').serialize(),
  83. url:"ajax/CarCyNumStatistics",
  84. success:function (data){
  85. var vData = $.parseJSON(data);
  86. $.messager.progress('close');
  87. document.getElementById("cngCarRegNum").innerHTML = vData.cngCarRegNum;
  88. document.getElementById("cngCarOutNum").innerHTML = vData.cngCarOutNum;
  89. document.getElementById("cngCyRegNum").innerHTML = vData.cngCyRegNum;
  90. document.getElementById("cngCyOutNum").innerHTML = vData.cngCyOutNum;
  91. document.getElementById("lngCarRegNum").innerHTML = vData.lngCarRegNum;
  92. document.getElementById("lngCarOutNum").innerHTML = vData.lngCarOutNum;
  93. document.getElementById("lngCyRegNum").innerHTML = vData.lngCyRegNum;
  94. document.getElementById("lngCyOutNum").innerHTML = vData.lngCyOutNum;
  95. document.getElementById("carRegNum").innerHTML = vData.cngCarRegNum+vData.lngCarRegNum;
  96. document.getElementById("carOutNum").innerHTML = vData.cngCarOutNum+vData.lngCarOutNum;
  97. document.getElementById("cyRegNum").innerHTML = vData.cngCyRegNum+vData.lngCyRegNum;
  98. document.getElementById("cyOutNum").innerHTML = vData.cngCyOutNum+vData.lngCyOutNum;
  99. }
  100. });
  101. }
  102. function selectCountry(){
  103. var id=document.getElementById("city").value;
  104. var select = document.getElementById("country");
  105. for(var i=select.options.length-1;i>=0;i--) {
  106. select.options.remove(i);
  107. }
  108. $.ajax({
  109. type:"POST",
  110. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  111. url:"ajax/hiddenCity?cityId="+id,
  112. success:function (data){
  113. var obj=eval("(" + data + ")");
  114. $.each(obj.rows, function(i,item){
  115. select.options.add(new Option(item.name, item.id));
  116. });
  117. }
  118. });
  119. }
  120. function selectCountry1(){
  121. selectCountry();
  122. //changeSize();
  123. }
  124. function changeSize(){
  125. fLoadData(1,10);
  126. }
  127. function show(message) {
  128. $.messager.show({
  129. title: '提示信息',
  130. msg: message,
  131. timeout: 2000,
  132. showType: 'slide'
  133. });
  134. }
  135. </script>
  136. </head>
  137. <body>
  138. <!-- 查询结果:数据表格 -->
  139. <table id="tt" cellspacing="0" cellpadding="0" >
  140. </table>
  141. <div id="toolbar" style="padding-top:0px;height: auto;overflow: hidden;">
  142. <form id="carDateStatistform" action="ajax/carDateStatist" method="post">
  143. <table>
  144. <tr>
  145. <td>
  146. <span class="hzbspan">省:</span>
  147. </td>
  148. <td>
  149. <select name="province" id="province" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select">
  150. <%for(AuthorityRegionPlace arp:arplist){
  151. cplist = arp.getCityPlace();
  152. %>
  153. <option value="<%=arp.getId() %>">
  154. <%=arp.getName() %>
  155. </option>
  156. <%} %>
  157. </select>
  158. </td>
  159. <td>
  160. <span class="hzbspan">市:</span>
  161. </td>
  162. <td>
  163. <select name="city" id="city" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select" onchange="selectCountry1();">
  164. <%
  165. for(CityPlace cp:cplist){
  166. cyplist = cp.getSubPlaceList();
  167. %>
  168. <option value="<%=cp.getId() %>">
  169. <%=cp.getName() %>
  170. </option>
  171. <%} %>
  172. </select>
  173. </td>
  174. <td>
  175. <span class="hzbspan">县:</span>
  176. </td>
  177. <td>
  178. <select name="country" id = "country" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select" >
  179. </select>
  180. </td>
  181. </tr>
  182. <tr><td>
  183. <span class="hzbspan">时间范围:从</span>
  184. </td>
  185. <td><input type="text" class="easyui-datebox" id="startTime" name="startTime" style="width: 150px;height: 34px;" class="hzbspan" data-options="prompt:'- - - - - - -'">
  186. </td>
  187. <td><span class="hzbspan">到:</span>
  188. </td>
  189. <td><input type="text" class="easyui-datebox" id="endTime" name="endTime" style="width: 150px;height: 34px;" class="hzbspan" data-options="prompt:'- - - - - - -'">
  190. </td>
  191. <td></td>
  192. <td>
  193. <a id="btninfosearch" class="easyui-linkbutton" icon="icon-search" style="width: 150px;height: 34px;" onclick="fLoadData(1,10);" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">查询</span></a>
  194. </td>
  195. </tr>
  196. </table>
  197. </form>
  198. </div>
  199. <div id="container" style="position: absolute;top:150px;width: 100%; height: auto;text-align: center;overflow:auto; ">
  200. <center>
  201. <table border="1px solid #ccc" cellspacing="0" cellpadding="30" style="color:#000;">
  202. <tr style="font-weight: bold;">
  203. <td>统计</td>
  204. <td>
  205. <span>CNG</span>
  206. </td>
  207. <td>
  208. <span>LNG</span>
  209. </td>
  210. <td>
  211. <span>合计</span>
  212. </td>
  213. </tr>
  214. <tr>
  215. <td style="color:grey;">
  216. <span>注册车辆:</span>
  217. </td>
  218. <td>
  219. <span id="cngCarRegNum">0</span>
  220. </td>
  221. <td>
  222. <span id="lngCarRegNum">0</span>
  223. </td>
  224. <td>
  225. <span id="carRegNum">0</span>
  226. </td>
  227. </tr>
  228. <tr>
  229. <td style="color:grey;">
  230. <span>注册气瓶:</span>
  231. </td>
  232. <td>
  233. <span id="cngCyRegNum">0</span>
  234. </td>
  235. <td>
  236. <span id="lngCyRegNum">0</span>
  237. </td>
  238. <td>
  239. <span id="cyRegNum">0</span>
  240. </td>
  241. </tr>
  242. <tr>
  243. <td style="color:grey;">
  244. <span>注销车辆:</span>
  245. </td>
  246. <td>
  247. <span id="cngCarOutNum">0</span>
  248. </td>
  249. <td>
  250. <span id="lngCarOutNum">0</span>
  251. </td>
  252. <td>
  253. <span id="carOutNum">0</span>
  254. </td>
  255. </tr>
  256. </tr>
  257. <tr>
  258. <td style="color:grey;">
  259. <span>注销气瓶:</span>
  260. </td>
  261. <td>
  262. <span id="cngCyOutNum">0</span>
  263. </td>
  264. <td>
  265. <span id="lngCyOutNum">0</span>
  266. </td>
  267. <td>
  268. <span id="cyOutNum">0</span>
  269. </td>
  270. </tr>
  271. </tr>
  272. </tr>
  273. </table>
  274. </center>
  275. </div>
  276. </body>
  277. </html>