yxh
/
CNG


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539
							<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ 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.tool.Util" %>
<%@ 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">
	<script type="text/javascript" src="js/easyui/export.js"></script>
	<script type="text/javascript" src="js/common/area.js"></script>
	<style type="text/css">
		 a:HOVER{
			color: red;
			text-decoration: none;
		}
		 a{
			color: #f08300;
			text-decoration: none;
		}
	</style>
	
	<script type="text/javascript">
		var grid="";
		var exportString="";
		var i = 1;//第几页
		var sum;//总条数
		
var pageSize =10;
		var totalpage;//总页数
		$(document).ready(function(){
			
			pageSize = $('#pageSize').val();
			
			selectCountry();
			selectstation();
			fLoadTable();
			//selectjqjandop();
			//fLoadData(i,pageSize);
			
		});
		
function show(message) {  
	            $.messager.show({  
	                title: '提示信息',  
	                msg: message,  
	                timeout: 2000,  
	                showType: 'slide'  
	            });  
	        }
		function fLoadTable(){
				grid=$('#tt').datagrid({
				  fit: true,//自动大小   
					title: '充装数据',
					width: '100%',
					height: 580,
					toolbar: '#toolbar',
					fitColumns: true,
					singleSelect:false,
					loadMsg:'正在加载, 请稍等 …',
	            	nowrap : true,//设置为true，当数据长度超出列宽时将会自动截取
	            	striped : true,//设置为true将交替显示行背景
					collapsible : true,//显示可折叠按钮
					singleSelect:true,//为true时只能选择单行
	            	fitColumns:true,//允许表格自动缩放，以适应父容器
	            	rownumbers:true,
	            	pagination:true,//分页控件 
					columns:[[
						{field:'stationNo',align:'center',title:'充装站',width:'160px'},
						{field:'machineNo',align:'center',title:'加气机',width:'120px'},
						{field:'gunNo',align:'center',title:'加气枪',width:'120px'},
						{field:'operatorName',align:'center',title:'操作员',width:'120px'},
						{field:'fillTime1',align:'center',title:'充装时间',width:160},
						{field:'endTime1',align:'center',title:'结束时间',width:160},
						{field:'carNo',align:'center',title:'车牌号',width:'120px',formatter: function(value, row, index){
							if(value){
								var v=0;
								if(row.appType.indexOf("其他")!=-1) {v=0;}else
								if(row.appType.indexOf("出租")!=-1) {v=1;}else
								if(row.appType.indexOf("公交")!=-1) {v=2;}else
								if(row.appType.indexOf("私用")!=-1){v=3;}else
								if(row.appType.indexOf("货运")!=-1){v=4;}else
								if(row.appType.indexOf("客运")!=-1) {v=5;}else
								if(row.appType.indexOf("外地车")!=-1) {v=9;}else
								if(row.appType.indexOf("营转非")!=-1) {v=6;}
								return '<a href="machineDetailfill?carNo='+value+'&appType='+v+'&operState=-1'+'&plateType='+row.plateType+'&fixCarNo='+row.fixCarNo+'&fillTimes='+row.fillTime1+'" target="_blank">'+value+'</a>';
							}
							return value;
							
						}},
						{field:'plateTypeName',align:'center',title:'车牌类型',width:'120px'},
						{field:'appType',align:'center',title:'应用类型',width:'120px'},
						{field:'fillState',align:'center',title:'充装状态',width:'120px',formatter: function(value, row, index){
							if(value=="超期未检"){
						        return '<div  style="background-color: #f08300;">'+value+'</div>';
						        }
	    					return value;	
						}},
						{field:'cylinderNum',align:'center',title:'气瓶数量',width:'120px'},
						{field:'regNo',align:'center',title:'使用登记证',width:'120px'},
						{field:'nowNumber',align:'center',title:'已充装次数',width:'120px'},
						{field:'lowPress',align:'center',title:'充装前压',width:'120px',formatter: function(value, row, index){
							if(value){
						        return value.toFixed(1);
						        }
	    					return value;	
						}},
						{field:'highPress',align:'center',title:'充装后压',width:'120px',formatter: function(value, row, index){
							if(value){
						        return value.toFixed(1);
						        }
	    					return value;	
						}},
						{field:'flux',align:'center',title:'流量',width:'120px',formatter: function(value, row, index){
							if(value){
						        return value.toFixed(1);
						        }
	    					return value;	
						}},
						{field:'money',align:'center',title:'金额(元)',width:'120px',formatter: function(value, row, index){
							if(value){
						        return value.toFixed(1);
						        }
	    					return value;	
						}}
						
					]]
				});	
				$('#tt').datagrid('hideColumn','endTime1');
		}
		function fLoadData(page,rows){
		if(!$('#station option:selected').text()){
			return false;
		}
			    $.messager.progress({ 
			        title: '请等待', 
			        msg: '正在加载数据...', 
			        text: '查询中.......' 
			    }); 
				$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					data:$('#fillingform').serialize(),
					url:"ajax/fillingDataQuery?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 + ")");
						if(obj.rows.length==1){
						select.options.add(new Option("请选择县", ""));
						}
						$.each(obj.rows, function(i,item){      
							select.options.add(new Option(item.name, item.id));
  						});
						      
							
					}
			});
		}
		
		function selectCountry1(){
				selectCountry();
				selectstation();
		}
		
	function changeSize(){
		fLoadData(1,10);
	}
	
	function selectstation(){
	var ii=1;
			var id=document.getElementById("country").value;
			var select = document.getElementById("station");
			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:$('#fillingform').serialize(),
					//url:"ajax/hiddenCNGStation?cityId="+id,
					url:"ajax/hiddenspeStation?type=2",
					success:function (data){
						var obj=eval("(" + data + ")");
						$.each(obj.rows, function(i,item){  
						if(ii==1){
							if(obj.rows.length>1){
								select.options.add(new Option("全部", ""));
							}
							ii++;
						}     
							select.options.add(new Option(item.name, item.id));
  						});
						      
							
					}
			});
	}
	function selectstation1(){
	selectstation();
	//changeSize();
	}
	
	function selectjqjandop(){
		selectjqj();
		selectoperatorNo();
	}
	function selectjqj(){
	var ii=1;
			var id=document.getElementById("station").value;
			var select = document.getElementById("jqj");
			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/hiddenjqj?stationId="+id,
					success:function (data){
						var obj=eval("(" + data + ")");
						select.options.add(new Option("全部", ""));
						$.each(obj.rows, function(i,item){   
							select.options.add(new Option(item.manu+item.type, item.machineNo));
							
  						});
						      
							
					}
			});
	}
	function selectoperatorNo(){
	var ii=1;
			var id=document.getElementById("station").value;
			var select = document.getElementById("operatorNo");
			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/hiddenoperatorNo?stationId="+id,
					success:function (data){
						var obj=eval("(" + data + ")");
						select.options.add(new Option("全部", ""));
						$.each(obj.rows, function(i,item){   
							select.options.add(new Option(item.name, item.operatorNo));
  						});
						      
							
					}
			});
	}
	function expt1(){
		expt(grid);
	}
	function exptSingle(){
		if(!grid){
			alert("数据为空");
			return false;
		}else{
			expt(grid);
		}
		
	}
	function exptAll(){
		fLoadDataAll(1,5000);
	}
	
	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:$('#fillingform').serialize(),
					url:"ajax/fillingDataQuery?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 selectpage(){
	var selectpage = $('#selectpage').val();
	if(selectpage>=1&&selectpage<=totalpage){
		i = selectpage;
		$("#selectpage").val("");
		pageSize = $('#pageSize').val();
		fLoadData(i,pageSize);
	}else{
		$("#selectpage").val("");
		return false;
	}
}
function selectjqjandop22(){
	selectjqjandop();
	//changeSize();
}
function selectoperatorNo22(){
	//selectoperatorNo();
	//changeSize();
}

	</script>
	
  </head>
  
  <body>
    <!-- 查询结果：数据表格 -->
  	<table id="tt"  cellspacing="0" cellpadding="0" >
	</table>
	<div id="toolbar" style="padding-top: 0px;height: auto;">
	
  		 <form id="fillingform" action="ajax/filling" method="post">
			<span class="easyui-linkbutton"    style="cursor: default;margin-bottom:  5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >查询条件:</span></span>
  		 
  			<span class="easyui-linkbutton"    style="cursor: default;margin-bottom:  5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >省:</span></span>
				<select  name="province" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan">
				<%for(AuthorityRegionPlace arp:arplist){
					cplist = arp.getCityPlace();
				 %>
					<option value="<%=arp.getId() %>">
						<%=arp.getName() %>
					</option>
				<%} %>
			</select>
  		
			<span class="easyui-linkbutton"    style="cursor: default;margin-bottom:  5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >市:</span></span>
			<select  name="city" id="city" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan" onchange="selectCountry1()">
				
				<%
					
					for(CityPlace cp:cplist){
					cyplist = cp.getSubPlaceList();
				%>		
					
					<option value="<%=cp.getId() %>">
						<%=cp.getName() %>
					</option>
					
				 
				<%} %>
			</select>
			<span class="easyui-linkbutton"    style="cursor: default;margin-bottom:  5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >县:</span></span>
			<select  name="country" id = "country" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan"  onchange="selectstation1();" >
				<option value="">全部</option>
			</select>
			<br/>
			<span class="easyui-linkbutton"    style="cursor: default;margin-bottom:  5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >充装站点:</span></span>
			<select  name="station" id ="station" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan"  onchange="selectjqjandop22();" >
				<option value="">全部</option>
			</select>
			<span class="easyui-linkbutton"    style="cursor: default;margin-bottom:  5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >加气机:</span></span>
			<select  name="jqj" id ="jqj" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan"  onchange="selectoperatorNo22();" >
				<option value="">全部</option>
			</select>
			<table>
			<tr>
			<td>
			<span  style="cursor: default"><span class="hzbspan">应用类型：</span></span></td>
			<td><select  name="appType" id="appType" style="width: 120px;height: 24px;" class="hzbspan" >
						<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="startTime" id="startTime" class="easyui-datebox"  style="width: 100px;height: 24px;"  class="hzbspan">
			
			</td>
			<td>
			<span  style="cursor: default"><span class="hzbspan">气枪编号：</span></span></td>
			<td><input type="text" name="gunNo" id="gunNo"   style="width: 100px;height: 24px;"  class="hzbspan">
			</td>
			<td><span  style="cursor: default"><span class="hzbspan">操作员:</span></span></td>
			<td><select  name="operatorNo" id ="operatorNo" style="width: auto;height: 24px;min-width: 100px;" class="hzbspan" >
				<option value="">全部</option>
			</select>
			</td>
			</tr>
			
			<tr><td>
			<span  style="cursor: default"><span class="hzbspan">充装状态：</span></span></td>
			<td><select  name="fillState" id="fillState" style="width: 120px;height: 24px;" class="hzbspan" >
					<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="11">加气枪不匹配</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: 100px;height: 24px;"  class="hzbspan">
			</td>
			<td><span  style="cursor: default"><span class="hzbspan">车牌号:</span></span></td>
			<td><input type="text" name="carNo" id="carNo"  style="width: 100px;height: 24px;"  class="hzbspan">
			
			</td>
			<td>
			<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;">查询</span></a> 
		
		</td>
		<td>
		<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;">导出</span></a> 
		</td>
		</tr>
		</table>
		</form>	
	</div>
	<div id="dialog2"></div> 
  </body>
</html>