yxh
/
CNG


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559
							<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="com.runzhixing.tool.Util" %>
<%@ page import="com.runzhixing.bean.CityPlace" %>
<%@ page import="com.runzhixing.bean.CountryPlace" %>
<%@ page import="com.runzhixing.bean.Station" %>
<%@ page import="com.runzhixing.bean.AuthorityRegionPlace" %>
<%@ page import="com.runzhixing.bean.User" %>
<%@ page import="com.runzhixing.constant.Constant" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";


User user = (User)session.getAttribute(Constant.userMark); 
List<AuthorityRegionPlace> arplist = user.getPrivilegePlaces1();

List<CityPlace> cplist = new ArrayList<CityPlace>();
List<CountryPlace> cyplist = new ArrayList<CountryPlace>();
List<Station> slist = new ArrayList<Station>();
%>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>车辆数据查询</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<meta http-equiv="X-UA-Compatible" content="IE=9"/>
	<meta http-equiv="X-UA-Compatible" content="IE=10"/>
	<link rel="stylesheet" type="text/css" href="css/easyui/themes/default/easyui.css">
	<link rel="stylesheet" type="text/css" href="css/easyui/themes/icon.css">
	<link rel="stylesheet" type="text/css" href="css/easyui/demo/demo.css">
	<script type="text/javascript" src="css/easyui/jquery.min.js"></script>
	<script type="text/javascript" src="css/easyui/jquery.easyui.min.js"  charset="utf-8"></script>
	<script type="text/javascript" src="css/easyui/locale/easyui-lang-zh_CN.js"  charset="utf-8"></script>
	<link rel="stylesheet" type="text/css" href="css/common/hzbstyle.css">
	<style type="text/css">
		 a:HOVER{
			color: red;
			text-decoration: none;
		}
		 a{
			color: #f08300;
			text-decoration: none;
		}
	</style>
	<script type="text/javascript" src="js/easyui/export.js"></script>
	<script type="text/javascript">
		var hiddenP='<%=(String)session.getAttribute("hiddenphone") %>';
		var grid;
		var exportString="";
		var i = 1;//第几页
		var sum;//总条数
		var pageSize =10;
		var totalpage;//总页数
		$(document).ready(function(){
			fLoadTable();
			
			selectCountry();
			selectCompany();
			selectinstallStation();
		});
		function fLoadTable(){
				grid=$('#tt').datagrid({
				  fit: true,//自动大小   
					title: '',
					width: '100%',
					height: 580,
					toolbar: '#toolbar',
					fitColumns: true,
					loadMsg:'正在加载, 请稍等 …',
	            	nowrap : true,//设置为true，当数据长度超出列宽时将会自动截取
	            	striped : true,//设置为true将交替显示行背景
					collapsible : false,//显示可折叠按钮
	            	fitColumns:true,//允许表格自动缩放，以适应父容器
	            	rownumbers:true,
	            	pagination:true,//分页控件 
					columns:[[
						{field:'carGuid',align:'left',title:'操作',width:'120px',formatter: function(value, row, index){
							return '<a href="carAudit?carNo='+row.carNo+'&carGuid='+value+'&districtNo='+row.districtNo+'" target="_blank">'+"审核信息"+'</a>';
						}},
						{field:'districtName',align:'left',title:'所属地区',width:'120px'},
						{field:'carNo',align:'left',title:'车牌号',width:'120px',formatter: function(value, row, index){
							return '<a href="machineDetail?carNo='+value+'&appType='+row.appType+'&operState='+row.operState+'&plateType='+row.plateType+'&carGuid='+row.carGuid+'" target="_blank">'+value+'</a>';
						}},
						{field:'plateTypeName',align:'left',title:'车牌类型',width:'120px'},
						{field:'appTypeName',align:'left',title:'应用类型',width:'120px'},
						{field:'installNum',align:'left',title:'气瓶安装数量',width:'120px'},
						{field:'districtNo',align:'left',title:'地区编号',width:'120px'},
						{field:'districtName',align:'left',title:'地区名称',width:'180px'},
						{field:'engineNo',align:'left',title:'发动机号',width:'120px'},
						{field:'vin',align:'left',title:'底盘号',width:'160px'},
						{field:'carType',align:'left',title:'厂牌型号',width:'160px'},
						{field:'carProduct',align:'left',title:'汽车厂家',width:'120px'},
						{field:'carName',align:'left',title:'汽车名称',width:'120px'},
						{field:'carUnit',align:'left',title:'所属单位',width:'120px'},
						{field:'carUnitMana',align:'left',title:'负责人',width:'120px'},
						{field:'addcarUnitPhoner',align:'left',title:'单位电话',width:'120px'},
						{field:'carOwnerName',align:'left',title:'车主姓名',width:'180px'},
						{field:'phone',align:'left',title:'联系电话',width:'120px'},
						{field:'post',align:'left',title:'邮编',width:'120px'},
						{field:'addr',align:'left',title:'联系地址',width:'120px'},
						{field:'regNo',align:'left',title:'使用登记证编号',width:'140px'},
						{field:'manaUnitName',align:'left',title:'发证单位,管理部门',width:'180px'},
						{field:'regTime1',align:'left',title:'发证日期',width:'120px'},
						{field:'carStateName',align:'left',title:'车辆状态',width:'120px'},
						{field:'fillTimes',align:'left',title:'充装次数',width:'120px'},
						{field:'operStateName',align:'left',title:'操作状态',width:'120px'},
						{field:'installStation',align:'left',title:'安装单位',width:'180px'},
						{field:'tagStation',align:'left',title:'发标签站点编号',width:'180px'},
						{field:'tagOperator',align:'left',title:'发标签操作员编号',width:'120px'},
						{field:'tagOperTime1',align:'left',title:'发标签时间',width:'160px'},
						{field:'tagOperStateName',align:'left',title:'发标签状态',width:'120px'},
						{field:'tagNo',align:'left',title:'标签编号',width:'160px'},
						{field:'tagUid',align:'left',title:'标签UID',width:'160px'},
						{field:'tagAppTypeName',align:'left',title:'标签主类型',width:'120px'},
						{field:'tagTypeName',align:'left',title:'标签类型',width:'120px'},
						{field:'editStation',align:'left',title:'登记,修改站点编号',width:'180px'},
						{field:'editOperator',align:'left',title:'登记,修改操作员编号',width:'140px'},
						{field:'editOperTime1',align:'left',title:'最后操作时间',width:'160px'},
						{field:'auditStation',align:'left',title:'审核站点编号',width:'180px'},
						{field:'auditOperator',align:'left',title:'审核操作员编号',width:'120px'},
						{field:'auditOperTime1',align:'left',title:'审核时间',width:'160px'},
						{field:'unitName',align:'left',title:'单位编号',width:'120px'},
						{field:'time2',align:'left',title:'设置黑名单',width:'120px'}
						
					]]
				});	
				if(hiddenP!="0"){
					$('#tt').datagrid('hideColumn','phone');
					$('#tt').datagrid('hideColumn','addcarUnitPhoner');
				}
		}
		function fLoadData(page,rows){
		if(!$('#company option:selected').text()){
			return false;
		}
		if(!$('#installStation option:selected').text()){
			return false;
		}
			    $.messager.progress({ 
			        title: '请等待', 
			        msg: '正在加载数据...', 
			        text: '查询中.......' 
			    }); 
				$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					data:$('#carform').serialize(),
					url:"ajax/carsDataQuery?page="+page+"&psize="+rows,
					success:function (data){
							$.messager.progress('close'); 
							var vData = $.parseJSON(data);
							sum = vData.total;
							if(sum==0){
								show("没有查询到相关信息!!!");
							}
							totalpage = Math.ceil(sum/rows);
							$('#tt').datagrid('loadData', vData); //将数据绑定到datagrid   
							

var p = $('#tt').datagrid('getPager'); 
							$(p).pagination({ 
						        pageList: [10,20,30,100,200,400],//可以设置每页记录条数的列表 
						        beforePageText: '第',//页数文本框前显示的汉字 
						        afterPageText: '页    共 {pages} 页', 
						        displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录', 
								onSelectPage: function (pageNumber, pageSize) { 
					                fLoadData(pageNumber, pageSize); 
           						 } 
							
							});
											}
				});
	
			
		}
		
		function selectCountry(){
			var id=document.getElementById("city").value;
			var select = document.getElementById("country");
			for(var i=select.options.length-1;i>=0;i--) {
				select.options.remove(i);
			}
			$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					url:"ajax/hiddenCity?cityId="+id,
					success:function (data){
						var obj=eval("(" + data + ")");
						$.each(obj.rows, function(i,item){      
							select.options.add(new Option(item.name, item.id));
  						});
						      
							
					}
			});
		}
		
		function selectCountry1(){
				selectCountry();
				selectCompany();
				selectinstallStation();
		}
		
	function changeSize(){
		fLoadData(1,10);
	}
	
		function selectCompany(){
			var ii=1;
			var select = document.getElementById("company");
			for(var i=select.options.length-1;i>=0;i--) {
				select.options.remove(i);
			}
			$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					data:$('#carform').serialize(),
					url:"ajax/hiddenUnit",
					success:function (data){
						if(ii==1){
								select.options.add(new Option("全部", ""));
								ii++;
							} 
						var obj=eval("(" + data + ")");
						$.each(obj.rows, function(i,item){  
							select.options.add(new Option(item.name, item.id));
  						});
						      
							
					}
			});
		}
		
		function selectCompany1(){
			selectCompany();
			selectinstallStation();
		}
		
		function expt1(){
		expt(grid);
	}
	function exptSingle(){
		if(!grid){
			alert("数据为空");
			return false;
		}else{
			expt(grid);
		}
		
	}
	function exptAll(){
		fLoadDataAll(1,5000);
	}
	function show(message) {  
	            $.messager.show({  
	                title: '提示信息',  
	                msg: message,  
	                timeout: 2000,  
	                showType: 'slide'  
	            });  
	        }
	function fLoadDataAll(page,rows){
				var startTime1 = $('#startTime').datebox('getValue');
				var endTime1 = $('#endTime').datebox('getValue');
			
			
				document.getElementById("pageNumber").innerText = i;
				document.getElementById("from").innerText = (page-1)*rows;
				document.getElementById("to").innerText = page*rows;
			    $.messager.progress({ 
			        title: '请等待', 
			        msg: '正在加载数据...', 
			        text: '查询中.......' 
			    }); 
				$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
				data:$('#carform').serialize(),
					url:"ajax/carsDataQuery?page="+page+"&psize="+rows,
					success:function (data){
							$.messager.progress('close'); 
							var vData = $.parseJSON(data);
							sum = vData.total;
							if(sum==0){
								show("没有查询到相关信息!!!");
							}
							totalpage = Math.ceil(sum/rows);
							document.getElementById("total").innerText = sum;
							document.getElementById("totalpage").innerText = totalpage;
							var vData = $.parseJSON(data);
							$('#tt').datagrid('loadData', vData); //将数据绑定到datagrid   
							

var p = $('#tt').datagrid('getPager'); 
							$(p).pagination({ 
						        pageList: [10,20,30,100,200,400],//可以设置每页记录条数的列表 
						        beforePageText: '第',//页数文本框前显示的汉字 
						        afterPageText: '页    共 {pages} 页', 
						        displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录', 
								onSelectPage: function (pageNumber, pageSize) { 
					                fLoadData(pageNumber, pageSize); 
           						 } 
							
							});
						if(!grid){
			alert("数据为空");
			return false;
		}else{
			expt(grid);
		}
											}
				});
	
			
		}
		
		function selectinstallStation(){
			var ii=1;
			var select = document.getElementById("installStation");
			for(var i=select.options.length-1;i>=0;i--) {
				select.options.remove(i);
			}
			$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					//url:"ajax/modifyStationInfoCheck",
					//url:"ajax/hiddenspeStation",
					data:$('#carform').serialize(),
					url:"ajax/hiddenspeStation?type=3",
					success:function (data){
						var obj=eval("(" + data + ")");
						var sum = obj.total;
						select.options.add(new Option("全部", ""));
						$.each(obj.rows, function(i,item){   
							select.options.add(new Option(item.name, item.id));
  						});
						      
							
					}
			});
		}
		
		
	</script>
	
	   
  </head>
  
  <body>
    <!-- 查询结果：数据表格 -->
  	<table id="tt"  cellspacing="0" cellpadding="0" >
	</table>
	<div id="toolbar" style="padding-top: 10px;height: auto;">
	
  		 <form id="carform" action="ajax/car" method="post">
			
			<table>
			<tr>
				<td>
					<span class="hzbspan">省:</span>
				</td>
				<td>
					<select  name="province" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select">
						<%for(AuthorityRegionPlace arp:arplist){
							cplist = arp.getCityPlace();
						 %>
							<option value="<%=arp.getId() %>">
								<%=arp.getName() %>
							</option>
						<%} %>
					</select>
				</td>
				<td>
					<span class="hzbspan">市:</span>
				</td>
				<td>
					<select  name="city" id="city" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select" onchange="selectCountry1()">
				
						<%
							
							for(CityPlace cp:cplist){
							cyplist = cp.getSubPlaceList();
						%>		
							
							<option value="<%=cp.getId() %>">
								<%=cp.getName() %>
							</option>
							
						 
						<%} %>
					</select>
				</td>
				<td>
					<span class="hzbspan">县:</span>
				</td>
				<td>
					<select  name="country" id = "country" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select"  onchange="selectCompany1();" >
					</select>
				</td>
			</tr>
			<tr>
				<td>
					<span class="hzbspan">企业:</span>
				</td>
				<td>
					<select  name="company" id = "company" style="width: 150px;height: 34px;min-width: 100px; min-width: 100px" class="hzbspan select"  >
					</select>
				</td>
				<td>
					<span class="hzbspan">安装单位:</span>
				</td>
				<td>
					<select  name="installStation" id = "installStation" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select"  >
					</select>
				</td>
			</tr>
			
			<tr><td>
  		<span  style="cursor: default"><span class="hzbspan">车牌号:</span></span></td>
			<td><input type="text" name="carNo" id="carNo" style="width: 150px;height: 34px;"  class="hzbspan">
			</td>
			<td>
			<span  style="cursor: default"><span class="hzbspan">车主：</span></span></td>
			<td><input type="text" name="carOwnerName" id="carOwnerName"  style="width: 150px;height: 34px;"  class="hzbspan">
			</td>
			<td><span  style="cursor: default"><span class="hzbspan">使用登记证号:</span></span></td>
			<td><input type="text" name="regNo" id="regNo"   style="width: 150px;height: 34px;"  class="hzbspan">
			
			</td>
			<td>
			<span  style="cursor: default"><span class="hzbspan">发证开始时间：</span></span></td>
			<td><input type="text"  class="easyui-datebox" name="startTime" id="startTime" style="width: 150px;height: 34px;"  class="hzbspan">
			</td>			
			</tr><tr>
			
			<td>
			<span  style="cursor: default"><span class="hzbspan">发动机号：</span></span></td>
			<td><input type="text" name="engineNo" id="engineNo"   style="width: 150px;height: 34px;"  class="hzbspan">
			</td>
			<td><span  style="cursor: default"><span class="hzbspan">车架号:</span></span></td>
			<td><input type="text" name="vin" id="vin" style="width: 150px;height: 34px;"  class="hzbspan">
			</td>
			<td>
			<span  style="cursor: default"><span class="hzbspan">应用类型：</span></span></td>
			<td><select  name="appType" id="appType" style="width: 150px;height: 34px;" class="hzbspan select">
					<option value="-1" selected="selected">全部</option>
					<option value="0">其他</option>
					<option value="1">出租</option>
					<option value="2">公交</option>
					<option value="3">私用</option>
					<option value="4">货运</option>
					<option value="5">客运</option>
					<option value="6">营转非</option>
					<option value="9">外地车</option>
				</select></td>
			<td>
			<span  style="cursor: default"><span class="hzbspan">发证结束时间：</span></span></td>
			<td><input type="text" name="endTime" id="endTime" class="easyui-datebox"  style="width: 150px;height: 34px;"  class="hzbspan">
			</td></tr><tr>
			
			<td>
			<span  style="cursor: default"><span class="hzbspan">车主单位：</span></span></td>
			<td><input type="text"  name="carOwnerUnit" id="carOwnerUnit"  style="width: 150px;height: 34px;"  class="hzbspan">
			</td>
			<td>
			<span  style="cursor: default"><span class="hzbspan">车牌类型：</span></span></td>
			<td><select  name="plateType" id="plateType" style="width: 150px;height: 34px;" class="hzbspan select" >
					<option value="-1" se>全部</option>
					<option value="0">其它</option>
					<option value="1">大型汽车</option>
					<option value="2">小型汽车</option>
					<option value="3">使馆汽车</option>
					<option value="4">领馆汽车</option>
					<option value="5">境外汽车</option>
					<option value="6">外籍汽车</option>
					<option value="7">两、三轮摩托车</option>
					<option value="8">轻便摩托车</option>
					<option value="9">使馆摩托车</option>
					<option value="10">领馆摩托车</option>
					<option value="11">境外摩托车</option>
					<option value="12">外籍摩托车</option>
					<option value="13">农用运输车</option>
					<option value="14">拖拉机</option>
					<option value="15">挂车</option>
					<option value="16">教练汽车</option>
					<option value="17">教练摩托车</option>
					<option value="18">试验汽车</option>
					<option value="19">试验摩托车</option>
					<option value="20">临时入境汽车</option>
					<option value="21">临时入境摩托车</option>
					<option value="22">临时行驶车</option>
					<option value="23">警用汽车</option>
					<option value="24">警用摩托车</option>
				</select></td>
				
				<td>
				
				
				<span class="hzbspan">气瓶类型：</span></td>
				<td>
				<select  name="cylinderType" id="cylinderType" style="width: 150px;height: 34px;" class="hzbspan select"  >
					<option value="-1" selected="selected">全部</option>
					<option value="0">其他</option>
					<option value="1">钢质气瓶</option>
					<option value="2">钢质内胆环向缠绕气瓶</option>
					<option value="3">铝合金内胆全缠绕气瓶</option>
					<option value="4">塑料内胆全缠绕气瓶</option>
					<option value="5">LNG液化天然气气瓶</option>
				</select>
			
			
			</td>
			<td>
			<span  style="cursor: default"><span class="hzbspan">操作状态:</span></span></td>
			<td><select  name="opeState" id="opeState" style="width: 150px;height: 34px;" class="hzbspan select" >
					<option value="-1" selected="selected">全部</option>
					<option value="0">新数据,要求审核</option>
					<option value="1">安装完成,要求监检</option>
					<option value="2">监检完成,要求审核</option>
					<option value="3">检验完成,要求审核或复装</option>
					<option value="4">审核完成</option>
					<option value="5">已经发标签</option>
					<option value="6">数据审核不通过</option>
					<option value="7">检验后数据不通过</option>
					
					<option value="8">过户后审核不通过</option>
					<option value="9">监检不通过</option>
					<option value="10">未发标签</option>
					<option value="21">申请加瓶</option>
					<option value="22">申请减瓶</option>
					<option value="31">过户,要求审核</option>
					<option value="41">已注销</option>
				</select>
					</td>
			<td>	
			
			
			<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> 
		 
		</td>
		<td>
		<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>
		</td>
		</tr>
		</table>
		</form>	
	</div>
	<div id="dialog2"></div> 
  </body>
</html>