BlacklistQuery.jsp 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368
  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. <style type="text/css">
  38. a:HOVER{
  39. color: red;
  40. text-decoration: none;
  41. }
  42. a{
  43. color: #f08300;
  44. text-decoration: none;
  45. }
  46. </style>
  47. <script type="text/javascript" src="js/easyui/export.js"></script>
  48. <script type="text/javascript">
  49. var grid="";
  50. var exportString="";
  51. var i = 1;//第几页
  52. var sum;//总条数
  53. var pageSize =10;
  54. var totalpage;//总页数
  55. $(document).ready(function(){
  56. fLoadTable();
  57. pageSize = $('#pageSize').val();
  58. //fLoadData(i,pageSize);
  59. selectCountry();
  60. });
  61. function fLoadTable(){
  62. grid=$('#tt').datagrid({
  63. fit: true,//自动大小
  64. title: '',
  65. width: '100%',
  66. height: 580,
  67. toolbar: '#toolbar',
  68. fitColumns: true,
  69. singleSelect:false,
  70. loadMsg:'正在加载, 请稍等 …',
  71. nowrap : true,//设置为true,当数据长度超出列宽时将会自动截取
  72. striped : true,//设置为true将交替显示行背景
  73. collapsible : false,//显示可折叠按钮
  74. singleSelect:true,//为true时只能选择单行
  75. fitColumns:true,//允许表格自动缩放,以适应父容器
  76. rownumbers:true,
  77. pagination:true,//分页控件
  78. columns:[[
  79. {field:'carNo',align:'left',title:'车牌号',width:'180px'},
  80. {field:'tagNo',align:'left',title:'标签编号',width:'180px'},
  81. {field:'blackLevelName',align:'left',title:'黑名单级别',width:'180px'},
  82. {field:'createTime1',align:'left',title:'创建时间',width:'180px'},
  83. {field:'createTypeName',align:'left',title:'创建类型',width:'180px'},
  84. {field:'state',align:'left',title:'状态',width:'180px',formatter:function(value,row,index){
  85. if(value==0){
  86. return "有效";
  87. }else{
  88. return "无效";
  89. }
  90. }},
  91. {field:'downArea',align:'left',title:'下载地区',width:'180px'},
  92. {field:'downTypeName',align:'left',title:'下载类型',width:'180px'}
  93. ]]
  94. });
  95. }
  96. function show(message) {
  97. $.messager.show({
  98. title: '提示信息',
  99. msg: message,
  100. timeout: 2000,
  101. showType: 'slide'
  102. });
  103. }
  104. function fLoadData(page,rows){
  105. $.messager.progress({
  106. title: '请等待',
  107. msg: '正在加载数据...',
  108. text: '查询中.......'
  109. });
  110. $.ajax({
  111. type:"POST",
  112. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  113. data:$('#BlackListform').serialize(),
  114. url:"ajax/blackListQuery?page="+page+"&psize="+rows,
  115. success:function (data){
  116. $.messager.progress('close');
  117. var vData = $.parseJSON(data);
  118. sum = vData.total;
  119. if(sum==0){
  120. show("没有查询到相关信息!!!");
  121. }
  122. totalpage = Math.ceil(sum/rows);
  123. $('#tt').datagrid('loadData', vData); //将数据绑定到datagrid
  124. var p = $('#tt').datagrid('getPager');
  125. $(p).pagination({
  126. pageList: [10,20,30,100,200,400],//可以设置每页记录条数的列表
  127. beforePageText: '第',//页数文本框前显示的汉字
  128. afterPageText: '页 共 {pages} 页',
  129. displayMsg: '当前显示 {from} - {to} 条记录 共 {total} 条记录',
  130. onSelectPage: function (pageNumber, pageSize) {
  131. fLoadData(pageNumber, pageSize);
  132. }
  133. });
  134. }
  135. });
  136. }
  137. function selectCountry(){
  138. var id=document.getElementById("city").value;
  139. var select = document.getElementById("country");
  140. for(var i=select.options.length-1;i>=0;i--) {
  141. select.options.remove(i);
  142. }
  143. $.ajax({
  144. type:"POST",
  145. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  146. url:"ajax/hiddenCity?cityId="+id,
  147. success:function (data){
  148. var obj=eval("(" + data + ")");
  149. $.each(obj.rows, function(i,item){
  150. select.options.add(new Option(item.name, item.id));
  151. });
  152. }
  153. });
  154. }
  155. function selectCountry1(){
  156. selectCountry();
  157. //changeSize();
  158. }
  159. function changeSize(){
  160. fLoadData(1,10);
  161. }
  162. function expt1(){
  163. expt(grid);
  164. }
  165. function exptSingle(){
  166. if(!grid){
  167. alert("数据为空"+grid.length);
  168. return false;
  169. }else{
  170. expt(grid);
  171. }
  172. }
  173. function exptAll(){
  174. fLoadDataAll(1,5000);
  175. }
  176. function fLoadDataAll(page,rows){
  177. document.getElementById("pageNumber").innerText = i;
  178. document.getElementById("from").innerText = (page-1)*rows;
  179. document.getElementById("to").innerText = page*rows;
  180. $.messager.progress({
  181. title: '请等待',
  182. msg: '正在加载数据...',
  183. text: '查询中.......'
  184. });
  185. $.ajax({
  186. type:"POST",
  187. contentType: "application/x-www-form-urlencoded; charset=UTF-8",
  188. data:$('#BlackListform').serialize(),
  189. url:"ajax/blackListQuery?page="+page+"&psize="+rows,
  190. success:function (data){
  191. $.messager.progress('close');
  192. var vData = $.parseJSON(data);
  193. sum = vData.total;
  194. if(sum==0){
  195. show("没有查询到相关信息!!!");
  196. }
  197. totalpage = Math.ceil(sum/rows);
  198. document.getElementById("total").innerText = sum;
  199. document.getElementById("totalpage").innerText = totalpage;
  200. var vData = $.parseJSON(data);
  201. $('#tt').datagrid('loadData', vData); //将数据绑定到datagrid
  202. var p = $('#tt').datagrid('getPager');
  203. $(p).pagination({
  204. pageList: [10,20,30,100,200,400],//可以设置每页记录条数的列表
  205. beforePageText: '第',//页数文本框前显示的汉字
  206. afterPageText: '页 共 {pages} 页',
  207. displayMsg: '当前显示 {from} - {to} 条记录 共 {total} 条记录',
  208. onSelectPage: function (pageNumber, pageSize) {
  209. fLoadData(pageNumber, pageSize);
  210. }
  211. });
  212. if(!grid){
  213. alert("数据为空");
  214. return false;
  215. }else{
  216. expt(grid);
  217. }
  218. }
  219. });
  220. }
  221. </script>
  222. </head>
  223. <body>
  224. <!-- 查询结果:数据表格 -->
  225. <table id="tt" cellspacing="0" cellpadding="0" >
  226. </table>
  227. <div id="toolbar" style="padding-top: 10px;height: auto;">
  228. <form id="BlackListform" action="ajax/BlackList" method="post">
  229. <table>
  230. <tr>
  231. <td>
  232. <span class="hzbspan">省:</span>
  233. </td>
  234. <td>
  235. <select name="province" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select">
  236. <%for(AuthorityRegionPlace arp:arplist){
  237. cplist = arp.getCityPlace();
  238. %>
  239. <option value="<%=arp.getId() %>">
  240. <%=arp.getName() %>
  241. </option>
  242. <%} %>
  243. </select>
  244. </td>
  245. <td>
  246. <span class="hzbspan">市:</span>
  247. </td>
  248. <td>
  249. <select name="city" id="city" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select" onchange="selectCountry1()">
  250. <%
  251. for(CityPlace cp:cplist){
  252. cyplist = cp.getSubPlaceList();
  253. %>
  254. <option value="<%=cp.getId() %>">
  255. <%=cp.getName() %>
  256. </option>
  257. <%} %>
  258. </select>
  259. </td>
  260. <td>
  261. <span class="hzbspan">县:</span>
  262. </td>
  263. <td>
  264. <select name="country" id = "country" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select" >
  265. </select>
  266. </td>
  267. </tr>
  268. <tr><td>
  269. <span style="cursor: default"><span class="hzbspan">车牌号:</span></span></td>
  270. <td><input type="text" name="carNo" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan" placeholder="- - - - - - -">
  271. </td>
  272. <td><span style="cursor: default"><span class="hzbspan">底盘号:</span></span></td>
  273. <td><input type="text" name="vin" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan" placeholder="- - - - - - -">
  274. </td>
  275. </tr><tr>
  276. <td>
  277. <span style="cursor: default"><span class="hzbspan">应用类型:</span></span></td>
  278. <td><select name="appType" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select" >
  279. <option value="-1" selected="selected">全部</option>
  280. <option value="0">其他</option>
  281. <option value="1">出租</option>
  282. <option value="2">公交</option>
  283. <option value="3">私用</option>
  284. <option value="4">货运</option>
  285. <option value="5">客运</option>
  286. <option value="6">营转非</option>
  287. <option value="9">外地车</option>
  288. </select></td>
  289. <td>
  290. <span style="cursor: default"><span class="hzbspan">车牌类型:</span></span></td>
  291. <td><select name="plateType" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select" >
  292. <option value="-1" se>全部</option>
  293. <option value="0">其它</option>
  294. <option value="1">大型汽车</option>
  295. <option value="2">小型汽车</option>
  296. <option value="3">使馆汽车</option>
  297. <option value="4">领馆汽车</option>
  298. <option value="5">境外汽车</option>
  299. <option value="6">外籍汽车</option>
  300. <option value="7">两、三轮摩托车</option>
  301. <option value="8">轻便摩托车</option>
  302. <option value="9">使馆摩托车</option>
  303. <option value="10">领馆摩托车</option>
  304. <option value="11">境外摩托车</option>
  305. <option value="12">外籍摩托车</option>
  306. <option value="13">农用运输车</option>
  307. <option value="14">拖拉机</option>
  308. <option value="15">挂车</option>
  309. <option value="16">教练汽车</option>
  310. <option value="17">教练摩托车</option>
  311. <option value="18">试验汽车</option>
  312. <option value="19">试验摩托车</option>
  313. <option value="20">临时入境汽车</option>
  314. <option value="21">临时入境摩托车</option>
  315. <option value="22">临时行驶车</option>
  316. <option value="23">警用汽车</option>
  317. <option value="24">警用摩托车</option>
  318. </select></td>
  319. <td colspan="2">
  320. <a id="btninfosearch" onclick="changeSize();" class="easyui-linkbutton" icon="icon-search" href="javascript:void(0)" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">查询</span></a>
  321. <a id="btninfosearch" onclick="exptSingle();" class="easyui-linkbutton" icon="icon-save" href="javascript:void(0)" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">导出</span></a>
  322. </td></tr>
  323. </table>
  324. </form>
  325. </div>
  326. <div id="dialog2"></div>
  327. </body>
  328. </html>