CylinderdataQuery11.jsp 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390
  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. %>
  16. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  17. <html>
  18. <head>
  19. <base href="<%=basePath%>">
  20. <title>气瓶数据查询</title>
  21. <meta http-equiv="pragma" content="no-cache">
  22. <meta http-equiv="cache-control" content="no-cache">
  23. <meta http-equiv="expires" content="0">
  24. <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
  25. <meta http-equiv="description" content="This is my page">
  26. <meta http-equiv="X-UA-Compatible" content="IE=9"/>
  27. <meta http-equiv="X-UA-Compatible" content="IE=10"/>
  28. <link rel="stylesheet" type="text/css" href="css/easyui/themes/default/easyui.css">
  29. <link rel="stylesheet" type="text/css" href="css/easyui/themes/icon.css">
  30. <link rel="stylesheet" type="text/css" href="css/easyui/demo/demo.css">
  31. <script type="text/javascript" src="css/easyui/jquery.min.js"></script>
  32. <script type="text/javascript" src="css/easyui/jquery.easyui.min.js" charset="utf-8"></script>
  33. <script type="text/javascript" src="css/easyui/locale/easyui-lang-zh_CN.js" charset="utf-8"></script>
  34. <link rel="stylesheet" type="text/css" href="css/common/hzbstyle.css">
  35. <style type="text/css">
  36. a:HOVER{
  37. color: red;
  38. text-decoration: none;
  39. }
  40. a{
  41. color: #f08300;
  42. text-decoration: none;
  43. }
  44. </style>
  45. <script type="text/javascript" src="js/easyui/export.js"></script>
  46. <script type="text/javascript">
  47. var grid="";
  48. var exportString="";
  49. var i = 1;//第几页
  50. var pageSize =10;
  51. var sum;//总条数
  52. var totalpage;//总页数
  53. $(document).ready(function(){
  54. fLoadTable();
  55. });
  56. function fLoadTable(){
  57. grid=$('#tt').datagrid({
  58. fit: true,//自动大小
  59. title: '气瓶数据查询',
  60. width: '120%',
  61. height: 580,
  62. toolbar: '#toolbar',
  63. singleSelect:false,
  64. loadMsg:'正在加载, 请稍等 …',
  65. nowrap : true,//设置为true,当数据长度超出列宽时将会自动截取
  66. striped : true,//设置为true将交替显示行背景
  67. collapsible : true,//显示可折叠按钮
  68. singleSelect:true,//为true时只能选择单行
  69. fitColumns:false,//允许表格自动缩放,以适应父容器
  70. rownumbers:true,
  71. pagination:true,//分页控件
  72. frozenColumns:[[ //选择框
  73. {field:'ck',checkbox:true}
  74. ]],
  75. columns:[[
  76. {field:'cylinderno1',align:'center',title:'操作',width:75,formatter: function(value, row, index){
  77. return '<a href="jsp/rzx/dataQuery/CylinderFollow?cylinderguid='+row.cylinderGuid+'" target="_blank">'+"追踪气瓶"+'</a>';
  78. }},
  79. {field:'unitName',align:'center',title:'气瓶隶属单位',width:100},
  80. {field:'carNo',align:'center',title:'车牌号',width:85,formatter: function(value, row, index){
  81. return '<a href="machineDetail?carNo='+value+'&appType='+row.appType+'&operState='+row.operState+'&plateType='+row.plateType+'&carGuid='+row.carGuid+'" target="_blank">'+value+'</a>';
  82. }},
  83. {field:'plateTypeName',align:'center',title:'车牌类型',width:60},
  84. {field:'appTypeName',align:'center',title:'应用类型',width:85},
  85. {field:'cylinderNo',align:'center',title:'气瓶出厂编号',width:80},
  86. {field:'cylinderTypeName',align:'center',title:'类型',width:135},
  87. {field:'productNo',align:'center',title:'厂家简称',width:60},
  88. {field:'productDate1',align:'center',title:'生产年月',width:95},
  89. {field:'cylinderState',align:'center',title:'使用状态',width:60,formatter: function(value, row, index){
  90. if (value == "0") {
  91. return '<font style="color:green;font-weight: bold;">'+"在用"+'</font>';
  92. }
  93. else if(value == "1") {
  94. return '<font style="color:red;font-weight: bold;">'+"报废"+'</font>';
  95. }else if(value == "2") {
  96. return '<font style="color:red;font-weight: bold;">'+"超期未检"+'</font>';
  97. }else if(value == "3") {
  98. return '<font style="color:red;font-weight: bold;">'+"周转"+'</font>';
  99. }}},
  100. {field:'productLicence',align:'center',title:'许可证号',width:125},
  101. {field:'cylinderRegNo',align:'center',title:'气瓶使用编号',width:105},
  102. {field:'timesAvailable',align:'center',title:'可充装次数',width:95},
  103. {field:'yearLimit',align:'center',title:'使用年限',width:'100px'},
  104. {field:'startUseDate1',align:'center',title:'开始投用时间',width:95},
  105. {field:'productType',align:'center',title:'型号',width:'160px'},
  106. {field:'weight',align:'center',title:'重量',width:'100px',formatter: function(value, row, index){
  107. return value;
  108. }
  109. },
  110. {field:'vol',align:'center',title:'容积',width:'100px',formatter: function(value, row, index){
  111. return value;
  112. }},
  113. {field:'thickness',align:'center',title:'壁厚',width:'100px',formatter: function(value, row, index){
  114. return value;
  115. }},
  116. {field:'press',align:'center',title:'压力',width:'100px',formatter: function(value, row, index){
  117. return value;
  118. }},
  119. {field:'material',align:'center',title:'材质',width:'100px'},
  120. {field:'fibre',align:'center',title:'纤维',width:'100px'},
  121. {field:'resin',align:'center',title:'树脂',width:'100px'},
  122. {field:'cylinderStateName',align:'center',title:'状态',width:'100px'},
  123. {field:'fillTimes',align:'center',title:'充装次数',width:'100px'},
  124. {field:'operStateName',align:'center',title:'操作状态',width:'120px'},
  125. {field:'installStation',align:'center',title:'安装单位',width:'180px'},
  126. {field:'installDate1',align:'center',title:'安装日期',width:'100px'},
  127. {field:'checkState',align:'center',title:'检验状态',width:'100px',formatter: function(value, row, index){
  128. if (value == "0") {
  129. return '<font style="color:green;font-weight: bold;">'+"合格"+'</font>';
  130. }
  131. else if(value == "1") {
  132. return '<font style="color:red;font-weight: bold;">'+"不合格"+'</font>';
  133. }}},
  134. {field:'installLicence',align:'center',title:'安装许可',width:'120px'},
  135. {field:'installCert',align:'center',title:'安装合格证',width:'120px'},
  136. {field:'installTypeName',align:'center',title:'安装类别',width:'100px'},
  137. {field:'installLoc',align:'center',title:'安装位置',width:'100px'},
  138. {field:'installWorkerName',align:'center',title:'安装人员',width:'100px'},
  139. {field:'monitorStation',align:'center',title:'安装监检单位',width:'160px'},
  140. {field:'monitorDate1',align:'center',title:'安装监检日期',width:'100px'},
  141. {field:'installLoc',align:'center',title:'安装位置',width:'100px'},
  142. {field:'installWorkerName',align:'center',title:'安装人员' ,width:'100px'},
  143. {field:'monitorStation',align:'center',title:'安装监检单位' ,width:'100px'},
  144. {field:'monitorDate1',align:'center',title:'安装监检日期' ,width:'100px'},
  145. {field:'monitorLicence',align:'center',title:'安装监检许可' ,width:'100px'},
  146. {field:'monitorCert',align:'center',title:'安装监检证书' ,width:'100px'},
  147. {field:'monitorWorkername',align:'center',title:'安装监检人员' ,width:'100px'},
  148. {field:'checkStation',align:'center',title:'检验单位' ,width:'100px'},
  149. {field:'checkDate1',align:'center',title:'最后一次检验时间' ,width:'100px'},
  150. {field:'checkLicence',align:'center',title:'检验许可' ,width:'100px'},
  151. {field:'checkCert',align:'center',title:'检验证书' ,width:'100px'},
  152. {field:'checkState',align:'center',title:'检验状态' ,width:'100px'},
  153. {field:'nextCheckDate1',align:'center',title:'下次检验时间' ,width:'100px'},
  154. {field:'checkWorkerName',align:'center',title:'检验人员' ,width:'100px'},
  155. {field:'tagno',align:'center',title:'标签编号' ,width:'100px'},
  156. {field:'tagUid',align:'center',title:'标签UID' ,width:'100px'},
  157. {field:'tagAppTypeName',align:'center',title:'标签主类型' ,width:'100px'},
  158. {field:'tagTypeName',align:'center',title:'标签类型' ,width:'100px'},
  159. {field:'tagStation',align:'center',title:'发标签站点编号' ,width:'100px'},
  160. {field:'tagOperator',align:'center',title:'发标签操作员编号' ,width:'100px'},
  161. {field:'tagOperTime1',align:'center',title:'发标签时间',width:'100px'},
  162. {field:'tagOperStateName',align:'center',title:'发标签状态' ,width:'100px'},
  163. {field:'editStation',align:'center',title:'登记,修改站点编号' ,width:'160px'},
  164. {field:'editOperator',align:'center',title:'登记,修改操作员编号' ,width:'120px'},
  165. {field:'editOperTime1',align:'center',title:'登记,修改时间',width:'160px'},
  166. {field:'auditStation',align:'center',title:'审核站点编号' ,width:'100px'},
  167. {field:'auditOperator',align:'center',title:'审核操作员编号' ,width:'100px'},
  168. {field:'auditOperTime1',align:'center',title:'审核时间',width:'100px'}
  169. ]]
  170. });
  171. }
  172. </script>
  173. </head>
  174. <body>
  175. <!-- 查询结果:数据表格 -->
  176. <table id="tt" cellspacing="0" cellpadding="0" >
  177. </table>
  178. <div id="toolbar" style="padding-top: 0px;height: auto;">
  179. <form id="Cylinder11form" action="ajax/Cylinder11form" method="post">&nbsp;&nbsp;
  180. <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >查询条件:</span></span>&nbsp;&nbsp;
  181. <span class="hzbspan" >省:</span>&nbsp;&nbsp;
  182. <select name="province" id="province" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan">
  183. <%for(AuthorityRegionPlace arp:arplist){
  184. cplist = arp.getCityPlace();
  185. %>
  186. <option value="<%=arp.getId() %>">
  187. <%=arp.getName() %>
  188. </option>
  189. <%} %>
  190. </select>&nbsp;&nbsp;
  191. <span class="hzbspan" >市:</span>&nbsp;&nbsp;
  192. <select name="city" id="city" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan" onchange="selectCountry1()">
  193. <%
  194. for(CityPlace cp:cplist){
  195. cyplist = cp.getSubPlaceList();
  196. %>
  197. <option value="<%=cp.getId() %>">
  198. <%=cp.getName() %>
  199. </option>
  200. <%} %>
  201. </select>&nbsp;&nbsp;
  202. <span class="hzbspan" >县:</span>&nbsp;&nbsp;
  203. <select name="country" id = "country" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan" onchange="selectCompany1();" >
  204. </select>&nbsp;&nbsp;
  205. <span class="hzbspan">企业:</span>&nbsp;&nbsp;
  206. <select name="company" id = "company" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan" onchange="changeSize();">
  207. <option value="">全部</option>
  208. </select>
  209. <table style="margin-left: 120px;padding-top: 0px;">
  210. <tr>
  211. <td>
  212. <span style="cursor: default"><span class="hzbspan">车牌号:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<input type="text" name="carNo" id="carNo" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  213. </td>
  214. <td>
  215. <span style="cursor: default"><span class="hzbspan">下次检验开始时间:</span></span>&nbsp;&nbsp;<input type="text" id="searchst" name ="searchst" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  216. </td>
  217. <td>
  218. <span style="cursor: default"><span class="hzbspan">气瓶出厂编号:</span></span>&nbsp;&nbsp;<input type="text" name="cylinderNo" id="cylinderNo" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  219. </td>
  220. <input type="hidden" name="regNo" value="" />
  221. </tr>
  222. <tr>
  223. <td>
  224. <span style="cursor: default"><span class="hzbspan">气瓶类型:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<select name="cylinderType" id="cylinderType" style="width: 100px;height: 24px;" class="hzbspan" onchange="changeSize();">
  225. <option value="-1" selected="selected">全部</option>
  226. <option value="0">其他</option>
  227. <option value="1">钢质气瓶</option>
  228. <option value="2">钢质内胆环向缠绕气瓶</option>
  229. <option value="3">铝合金内胆全缠绕气瓶</option>
  230. <option value="4">塑料内胆全缠绕气瓶</option>
  231. <option value="5">LNG液化天然气气瓶</option>
  232. </select>&nbsp;&nbsp;
  233. </td>
  234. <td>
  235. <span style="cursor: default"><span class="hzbspan">下次检验结束时间:</span></span>&nbsp;&nbsp;<input type="text" id="searchet" name="searchet" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  236. </td>
  237. <td>
  238. <span style="cursor: default"><span class="hzbspan">气瓶厂家简称:</span></span>&nbsp;&nbsp;<input type="text" name="productNo" id="productNo" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  239. </td>
  240. </tr>
  241. <tr>
  242. <td>
  243. <span style="cursor: default"><span class="hzbspan">安装开始时间:</span></span>&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="installStartTime" id="installStartTime" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  244. </td>
  245. <td>
  246. <span style="cursor: default"><span class="hzbspan">安装结束时间:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<input type="text" name="installEndTime" id="installEndTime" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  247. </td>
  248. <td>
  249. <span style="cursor: default"><span class="hzbspan">应用类型:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<select name="appType" id="appType" style="width: 100px;height: 24px;" class="hzbspan" onchange="changeSize();">
  250. <option value="-1" selected="selected">全部</option>
  251. <option value="0">其他</option>
  252. <option value="1">出租</option>
  253. <option value="2">公交</option>
  254. <option value="3">私用</option>
  255. <option value="4">货运</option>
  256. <option value="5">客运</option>
  257. <option value="6">营转非</option>
  258. <option value="9">外地车</option>
  259. </select>&nbsp;&nbsp;
  260. </td>
  261. </tr>
  262. <tr><td>
  263. <span style="cursor: default"><span class="hzbspan">车主单位:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<input type="text" name="carOwenerUnit" id="carOwenerUnit" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  264. </td>
  265. <td>
  266. <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" name="installStation" id="installStation" style="width: 100px;height: 24px;" class="hzbspan">&nbsp;&nbsp;
  267. </td>
  268. <td>
  269. <span style="cursor: default"><span class="hzbspan">操作状态:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<select name="opeState" id="opeState" style="width: auto;height: 24px;" class="hzbspan" onchange="changeSize();">
  270. <option value="-1" selected="selected">全部</option>
  271. <option value="0">新数据,要求审核</option>
  272. <option value="1">安装完成,要求监检</option>
  273. <option value="2">监检完成,要求审核</option>
  274. <option value="3">检验完成,要求审核或复装</option>
  275. <option value="4">审核完成</option>
  276. <option value="5">已经发标签</option>
  277. <option value="6">数据审核不通过</option>
  278. <option value="7">检验后数据不通过</option>
  279. <option value="8">过户后审核不通过</option>
  280. <option value="9">监检不通过</option>
  281. <option value="10">未发标签</option>
  282. <option value="21">申请加瓶</option>
  283. <option value="22">申请减瓶</option>
  284. <option value="31">过户,要求审核</option>
  285. <option value="41">已注销</option>
  286. </select>&nbsp;&nbsp;
  287. </td></tr>
  288. <tr><td>
  289. <span style="cursor: default"><span class="hzbspan">状态:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<select name="state" id="state" style="width: 100px;height: 24px;" class="hzbspan" onchange="changeSize();">
  290. <option value="-1">全部</option>
  291. <option value="0">在用</option>
  292. <option value="1">报废</option>
  293. <option value="2">超期未检</option>
  294. <option value="3">周转</option>
  295. </select>&nbsp;&nbsp;
  296. </td>
  297. <td>
  298. <span style="cursor: default"><span class="hzbspan">安装类型:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<select name="installType" id="installType" style="width: 100px;height: 24px;" class="hzbspan" onchange="changeSize();">
  299. <option value="-1">全部</option>
  300. <option value="0">第一次安装</option>
  301. <option value="1">复装</option>
  302. <option value="2">整车出厂</option>
  303. </select>&nbsp;&nbsp;
  304. </td>
  305. <td>
  306. <span style="cursor: default"><span class="hzbspan">车牌类型:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>&nbsp;&nbsp;<select name="plateType" id="plateType" style="width: 100px;height: 24px;" class="hzbspan" onchange="changeSize();">
  307. <option value="-1" se>全部</option>
  308. <option value="0">其它</option>
  309. <option value="1">大型汽车</option>
  310. <option value="2">小型汽车</option>
  311. <option value="3">使馆汽车</option>
  312. <option value="4">领馆汽车</option>
  313. <option value="5">境外汽车</option>
  314. <option value="6">外籍汽车</option>
  315. <option value="7">两、三轮摩托车</option>
  316. <option value="8">轻便摩托车</option>
  317. <option value="9">使馆摩托车</option>
  318. <option value="10">领馆摩托车</option>
  319. <option value="11">境外摩托车</option>
  320. <option value="12">外籍摩托车</option>
  321. <option value="13">农用运输车</option>
  322. <option value="14">拖拉机</option>
  323. <option value="15">挂车</option>
  324. <option value="16">教练汽车</option>
  325. <option value="17">教练摩托车</option>
  326. <option value="18">试验汽车</option>
  327. <option value="19">试验摩托车</option>
  328. <option value="20">临时入境汽车</option>
  329. <option value="21">临时入境摩托车</option>
  330. <option value="22">临时行驶车</option>
  331. <option value="23">警用汽车</option>
  332. <option value="24">警用摩托车</option>
  333. </select>&nbsp;&nbsp;
  334. <a id="btninfosearch" onclick="changeSize();" 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>
  335. <a id="btninfosearch" onclick="exptSingle();" class="easyui-linkbutton" icon="icon-save" href="javascript:void(0)" style="margin-bottom: 5px;" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">导&nbsp;&nbsp;出&nbsp;&nbsp;</span></a>
  336. </td></tr>
  337. </table>
  338. </form>
  339. </div>
  340. <div id="dialog2"></div>
  341. <input id = "st" type="hidden" value="<%=session.getAttribute("st") %>"/>
  342. <input id = "et" type="hidden" value="<%=session.getAttribute("et") %>"/>
  343. </body>
  344. </html>