CylinderdataQuery.jsp 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379
  1. <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
  2. <%@ page import="com.runzhixing.bean.CityPlace" %>
  3. <%@ page import="com.runzhixing.bean.CountryPlace" %>
  4. <%@ page import="com.runzhixing.bean.Station" %>
  5. <%@ page import="com.runzhixing.bean.AuthorityRegionPlace" %>
  6. <%@ page import="com.runzhixing.bean.User" %>
  7. <%@ page import="com.runzhixing.constant.Constant" %>
  8. <%
  9. String path = request.getContextPath();
  10. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
  11. User user = (User)session.getAttribute(Constant.userMark);
  12. List<AuthorityRegionPlace> arplist = user.getPrivilegePlaces1();
  13. List<CityPlace> cplist = new ArrayList<CityPlace>();
  14. List<CountryPlace> cyplist = new ArrayList<CountryPlace>();
  15. List<Station> slist = new ArrayList<Station>();
  16. %>
  17. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  18. <html>
  19. <head>
  20. <base href="<%=basePath%>">
  21. <title>气瓶数据查询</title>
  22. <meta http-equiv="pragma" content="no-cache">
  23. <meta http-equiv="cache-control" content="no-cache">
  24. <meta http-equiv="expires" content="0">
  25. <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  26. <meta http-equiv="description" content="This is my page">
  27. <meta http-equiv="X-UA-Compatible" content="IE=9"/>
  28. <meta http-equiv="X-UA-Compatible" content="IE=10"/>
  29. <link rel="stylesheet" type="text/css" href="css/easyui/themes/default/easyui.css">
  30. <link rel="stylesheet" type="text/css" href="css/easyui/themes/icon.css">
  31. <link rel="stylesheet" type="text/css" href="css/easyui/demo/demo.css">
  32. <script type="text/javascript" src="css/easyui/jquery.min.js"></script>
  33. <script type="text/javascript" src="css/easyui/jquery.easyui.min.js" charset="utf-8"></script>
  34. <script type="text/javascript" src="css/easyui/locale/easyui-lang-zh_CN.js" charset="utf-8"></script>
  35. <link rel="stylesheet" type="text/css" href="css/common/hzbstyle.css">
  36. <script type="text/javascript">
  37. var i = 1;//第几页
  38. var sum;//总条数
  39. var totalpage;//总页数
  40. $(document).ready(function(){
  41. fLoadTable();
  42. pageSize = $('#pageSize').val();
  43. fLoadData(i,pageSize);
  44. selectCountry();
  45. });
  46. function fLoadTable(){
  47. var st = $('#st').val();
  48. var et = $('#et').val();
  49. if(st!=null&&st!=""){
  50. $("#searchst").datebox("setValue", st);
  51. }
  52. if(et!=null&&et!=""){
  53. $("#searchet").datebox("setValue", et);
  54. }
  55. $('#tt').datagrid({
  56. fit: true,//自动大小
  57. title: '参数表',
  58. width: '100%',
  59. height: 580,
  60. toolbar: '#toolbar',
  61. fitColumns: true,
  62. singleSelect:false,
  63. loadMsg:'正在加载, 请稍等 …',
  64. nowrap : true,//设置为true,当数据长度超出列宽时将会自动截取
  65. striped : true,//设置为true将交替显示行背景
  66. collapsible : true,//显示可折叠按钮
  67. singleSelect:true,//为true时只能选择单行
  68. fitColumns:true,//允许表格自动缩放,以适应父容器
  69. rownumbers:true,
  70. pagination:true,//分页控件
  71. frozenColumns:[[ //选择框
  72. {field:'ck',checkbox:true}
  73. ]],
  74. columns:[[
  75. {field:'carNo',title:'所属车辆',width:'7%'},
  76. {field:'cylinderNo',title:'气瓶使用编号',width:'7%'},
  77. {field:'productNo',title:'生产厂家',width:'7%'},
  78. {field:'cylinderNo',title:'气瓶出厂编号',width:'7%'},
  79. {field:'cylinderTypeName',title:'气瓶类型',width:'7%'},
  80. {field:'productDate',title:'生产年月',width:'7%',formatter:function(value,row,index){
  81. var unixTimestamp = new Date(value);
  82. return unixTimestamp.toLocaleString();
  83. }},
  84. {field:'productType',title:'型号',width:'7%'},
  85. {field:'cylinderState',title:'使用状态',width:'7%',formatter: function(value, row, index){
  86. if (value == "0") {
  87. return '<font style="color:green;font-weight: bold;">'+"在用"+'</font>';
  88. }
  89. else if(value == "1") {
  90. return '<font style="color:red;font-weight: bold;">'+"报废"+'</font>';
  91. }else if(value == "2") {
  92. return '<font style="color:red;font-weight: bold;">'+"超期未检"+'</font>';
  93. }else if(value == "3") {
  94. return '<font style="color:red;font-weight: bold;">'+"周转"+'</font>';
  95. }}},
  96. {field:'nextCheckDate',title:'下次检验日期',width:'7%',formatter:function(value,row,index){
  97. var unixTimestamp = new Date(value);
  98. return unixTimestamp.toLocaleString();
  99. }},
  100. {field:'checkDate',title:'最后检验日期',width:'7%',formatter:function(value,row,index){
  101. var unixTimestamp = new Date(value);
  102. return unixTimestamp.toLocaleString();
  103. }},
  104. {field:'startUseDate',title:'开始投用日期',width:'7%',formatter:function(value,row,index){
  105. var unixTimestamp = new Date(value);
  106. return unixTimestamp.toLocaleString();
  107. }},
  108. {field:'installDate',title:'安装日期',width:'7%',formatter:function(value,row,index){
  109. var unixTimestamp = new Date(value);
  110. return unixTimestamp.toLocaleString();
  111. }},
  112. {field:'yearLimit',title:'使用年限',width:'7%'},
  113. {field:'timesAvailable',title:'可充装次数',width:'7%'},
  114. {field:'fillTimes',title:'已充装次数',width:'7%'},
  115. {field:'checkStation',title:'检验单位',width:'7%'},
  116. {field:'checkState',title:'检验状态',width:'7%',formatter: function(value, row, index){
  117. if (value == "0") {
  118. return '<font style="color:green;font-weight: bold;">'+"合格"+'</font>';
  119. }
  120. else if(value == "1") {
  121. return '<font style="color:red;font-weight: bold;">'+"不合格"+'</font>';
  122. }}},
  123. {field:'installStation',title:'安装单位',width:'7%'},
  124. {field:'installLicence',title:'安装许可',width:'7%'},
  125. {field:'monitorStation',title:'安装监检单位',width:'7%'},
  126. {field:'weight',title:'重量',width:'7%'},
  127. {field:'vol',title:'容积',width:'7%'},
  128. {field:'thickness',title:'壁厚',width:'7%'},
  129. {field:'press',title:'压力',width:'7%'},
  130. {field:'material',title:'材质',width:'7%'},
  131. {field:'installLoc',title:'安装位置',width:'7%'}
  132. ]]
  133. });
  134. }
  135. function fLoadData(page,rows){
  136. document.getElementById("pageNumber").innerText = i;
  137. document.getElementById("from").innerText = (page-1)*rows;
  138. document.getElementById("to").innerText = page*rows;
  139. $.messager.progress({
  140. title: '请等待',
  141. msg: '正在加载数据...',
  142. text: '查询中.......'
  143. });
  144. $.ajax({
  145. type:"POST",
  146. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  147. url:"ajax/cylinderDataQuery?page="+page+"&psize="+rows,
  148. success:function (data){
  149. $.messager.progress('close');
  150. var vData = $.parseJSON(data);
  151. sum = vData.total;
  152. totalpage = Math.ceil(sum/rows);
  153. document.getElementById("total").innerText = sum;
  154. document.getElementById("totalpage").innerText = totalpage;
  155. $('#tt').datagrid('loadData', vData); //将数据绑定到datagrid
  156. $('#pp').pagination({
  157. total:sum,
  158. pageList: [2,10,50,100],
  159. beforePageText: '第',//页数文本框前显示的汉字
  160. afterPageText: '页 共 {pages} 页',
  161. displayMsg: '当前显示 {from} - {to} 条记录 共 {total} 条记录',
  162. onSelectPage:function(pageNumber, pageSize){
  163. fLoadData();
  164. }
  165. });
  166. }
  167. });
  168. }
  169. function paginationpre(){
  170. pageSize = $('#pageSize').val();
  171. if(i<=1){
  172. return false;
  173. }else{
  174. i--;
  175. fLoadData(i,pageSize);
  176. }
  177. }
  178. function paginationnext(){
  179. //先跟总页数相比,看看有没得下一页
  180. pageSize = $('#pageSize').val();
  181. if(i<totalpage){
  182. i++;
  183. fLoadData(i,pageSize);
  184. }else{
  185. return false;
  186. }
  187. }
  188. function changeSize(){
  189. var changeSize = $('#pageSize').val();
  190. pageSize = $('#pageSize').val();
  191. fLoadData(i,changeSize);
  192. }
  193. function selectCountry(){
  194. var id=document.getElementById("city").value;
  195. var select = document.getElementById("country");
  196. for(var i=select.options.length-1;i>=0;i--) {
  197. select.options.remove(i);
  198. }
  199. $.ajax({
  200. type:"POST",
  201. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  202. url:"ajax/hiddenCity?cityId="+id,
  203. success:function (data){
  204. var obj=eval("(" + data + ")");
  205. $.each(obj.rows, function(i,item){
  206. select.options.add(new Option(item.name, item.id));
  207. });
  208. }
  209. });
  210. }
  211. function selectCountry1(){
  212. selectCountry();
  213. fLoadData(1,10);
  214. }
  215. function selectpage(){
  216. var selectpage = $('#selectpage').val();
  217. if(selectpage>=1&&selectpage<=totalpage){
  218. i = selectpage;
  219. $("#selectpage").val("");
  220. pageSize = $('#pageSize').val();
  221. fLoadData(i,pageSize);
  222. }else{
  223. $("#selectpage").val("");
  224. return false;
  225. }
  226. }
  227. </script>
  228. </head>
  229. <body>
  230. <!-- 查询结果:数据表格 -->
  231. <table id="tt" cellspacing="0" cellpadding="0" >
  232. </table>
  233. <div id="" style="background:#efefef;width:100%; border:1px solid #ccc;position: absolute;bottom: 0px;float: left;">
  234. <!--<input type="text" id="pageNumber">-->
  235. <div style="float: left;text-align: left;padding-left: 20px;">
  236. <span class="hzbspan">第</span><span id="pageNumber" class="hzbspan"></span><span class="hzbspan">页 共</span><span class="hzbspan" id="totalpage"></span><span class="hzbspan">页 </span>
  237. <select onchange="changeSize();" id="pageSize">
  238. <option value="5">5</option>
  239. <option value="10" selected="selected">10</option>
  240. <option value="20">20</option>
  241. <option value="30">30</option>
  242. </select>
  243. <a id="prepage" onclick="paginationpre()" class="easyui-linkbutton easyui-tooltip" title="上一页" data-options="iconCls:'icon-undo',plain:true" ></a>
  244. <input type="text" id="selectpage" style="width: 30px;" onchange="selectpage();"/>
  245. <a id="nextpage" onclick="paginationnext()" class="easyui-linkbutton easyui-tooltip" title="下一页" data-options="iconCls:'icon-redo',plain:true" ></a>
  246. </div>
  247. <div style="float: left;text-align: right;position: absolute;right: 20px;padding-top: 2px" ><span class="hzbspan">当前显示</span><span class="hzbspan" id="from"></span>-<span class="hzbspan" id="to"></span><span class="hzbspan"> 记录 共</span><span class="hzbspan" id ="total"></span><span class="hzbspan">条记录</span></div>
  248. </div>
  249. <div id="toolbar" style="padding-top: 10px;height: auto;"><!--
  250. <form name="form1" method="post" runat="server">
  251. <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >查询条件:</span></span>&nbsp;&nbsp;
  252. <span class="hzbspan">气瓶所属城市:</span>
  253. <select name="s1" onChange="changeselect1(this.value)" style="width: 100px;height: 24px;" class="hzbspan">
  254. <option>==请选择==</option>
  255. <option value="中文">中文</option>
  256. <option value="英语">英语</option>
  257. <option value="英语">法语</option>
  258. </select> &nbsp;&nbsp;
  259. <span class="hzbspan">气瓶所属县:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>
  260. <select name="s2" style="width: 100px;height: 24px;" class="hzbspan">
  261. <option>==请选择==</option>
  262. </select> &nbsp;&nbsp;
  263. -->
  264. <form id="Supervisormanagementform" action="ajax/Supervisormanagement" method="post">&nbsp;&nbsp;
  265. <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >查询条件:</span></span>&nbsp;&nbsp;
  266. <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >省:</span></span>&nbsp;&nbsp;
  267. <select name="province" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan">
  268. <%for(AuthorityRegionPlace arp:arplist){
  269. cplist = arp.getCityPlace();
  270. %>
  271. <option value="<%=arp.getId() %>">
  272. <%=arp.getName() %>
  273. </option>
  274. <%} %>
  275. </select>&nbsp;&nbsp;
  276. <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >市:</span></span>&nbsp;&nbsp;
  277. <select name="city" id="city" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan" onchange="selectCountry1()">
  278. <%
  279. for(CityPlace cp:cplist){
  280. cyplist = cp.getSubPlaceList();
  281. %>
  282. <option value="<%=cp.getId() %>">
  283. <%=cp.getName() %>
  284. </option>
  285. <%} %>
  286. </select>&nbsp;&nbsp;
  287. <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >县:</span></span>&nbsp;&nbsp;
  288. <select name="country" id = "country" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan" onchange="fLoadData(1,10)" >
  289. </select>&nbsp;&nbsp;
  290. <span style="cursor: default"><span class="hzbspan">生产厂家简称:</span></span>&nbsp;&nbsp;<input type="text" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  291. <br/>
  292. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  293. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  294. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  295. <span style="cursor: default"><span class="hzbspan">车牌号:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<input type="text" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  296. <span style="cursor: default"><span class="hzbspan">下次检验开始时间:</span></span>&nbsp;&nbsp;<input type="text" id="searchst" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  297. <span style="cursor: default"><span class="hzbspan">气瓶出厂编号:</span></span>&nbsp;&nbsp;<input type="text" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  298. <br/>
  299. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  300. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  301. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  302. <span style="cursor: default"><span class="hzbspan">气瓶类型:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<select name="address" style="width: 100px;height: 24px;" class="hzbspan">
  303. <option>全部</option>
  304. <option>成都市</option>
  305. <option>全部</option>
  306. <option>全部</option>
  307. <option>全部</option>
  308. </select>&nbsp;&nbsp;
  309. <span style="cursor: default"><span class="hzbspan">下次检验结束时间:</span></span>&nbsp;&nbsp;<input type="text" id="searchet" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  310. <span style="cursor: default"><span class="hzbspan">改装单位:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<input type="text" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  311. <br/>
  312. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  313. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  314. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  315. <span style="cursor: default"><span class="hzbspan">改装开始时间:</span></span>&nbsp;&nbsp;<input type="text" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  316. <span style="cursor: default"><span class="hzbspan">改装结束时间:&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<input type="text" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  317. <span style="cursor: default"><span class="hzbspan">气瓶状态:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<select name="address" style="width: 100px;height: 24px;" class="hzbspan">
  318. <option>全部</option>
  319. <option>成都市</option>
  320. <option>全部</option>
  321. <option>全部</option>
  322. <option>全部</option>
  323. </select>&nbsp;&nbsp;
  324. <a id="btninfosearch" class="easyui-linkbutton" icon="icon-search" href="javascript:void(0)" style="margin-bottom: 5px;" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">查&nbsp;&nbsp;询&nbsp;&nbsp;</span></a>
  325. </form>
  326. </div>
  327. <input id = "st" type="hidden" value="<%=session.getAttribute("st") %>"/>
  328. <input id = "et" type="hidden" value="<%=session.getAttribute("et") %>"/>
  329. </body>
  330. </html>