yxh
/
CNG


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496
							<%@ 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">
	<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" src="js/easyui/export.js"></script>
	<script type="text/javascript">
		var grid="";
		var exportString="";
		var i = 1;//第几页
		var sum;//总条数
		
var pageSize =10;
var pageSize1 =10;
		var totalpage;//总页数
		$(document).ready(function(){
			fLoadTable();
			pageSize = $('#pageSize').val();
			//fLoadData(i,pageSize);
			selectCountry();
			selsectCheckStation();
		});
		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 : false,//显示可折叠按钮
					singleSelect:true,//为true时只能选择单行
	            	fitColumns:true,//允许表格自动缩放，以适应父容器
	            	rownumbers:true,
	            	pagination:true,//分页控件 
	            	pageList: [10,20,30,100,200,400,600,800,1000],
					columns:[[
						{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:'ownerName',align:'left',title:'车主姓名',width:'120px'},
						{field:'phone',align:'left',title:'车主电话',width:'120px'},
						{field:'plateTypeName',align:'left',title:'车牌类型',width:'120px'},
						{field:'cylinderNo',align:'left',title:'气瓶出厂编号',width:'120px'},
						{field:'cylinderTypeName',align:'left',title:'气瓶类型',width:'160px'},
						{field:'vol',align:'left',title:'容积',width:'120px'},
						{field:'appTypeName',align:'left',title:'应用类型',width:60},
						{field:'productNo',align:'left',title:'厂家',width:40},
						{field:'productDate1',align:'left',title:'生产日期',width:'120px'},
						{field:'checkStation',align:'left',title:'检验单位',width:'180px'},
						{field:'checkDate1',align:'left',title:'最后一次检验',width:'120px'},
						{field:'checkLicence',align:'left',title:'检验许可',width:'160px'},
						
						{field:'checkCert',align:'left',title:'检验证书',width:'160px'},
						{field:'checkStateName',align:'left',title:'检验结论',width:60},
						{field:'nextCheckDate1',align:'left',title:'下次检验',width:'120px'},
						{field:'checkWorkerName',align:'left',title:'检验人员',width:'120px'},
						{field:'editStation',align:'left',title:'登记/修改站点',width:'180px'},
						{field:'editOperator',align:'left',title:'登记/修改操作人员',width:'120px'},
						{field:'editOperTime1',align:'left',title:'录入时间',width:'160px'}
						
					]]
				});	
		}
		function show(message) {  
	            $.messager.show({  
	                title: '提示信息',  
	                msg: message,  
	                timeout: 2000,  
	                showType: 'slide'  
	            });  
	        }
		function fLoadData(page,rows){
		if(!$('#checkStation option:selected').text()){
			return false;
		}
			    $.messager.progress({ 
			        title: '请等待', 
			        msg: '正在加载数据...', 
			        text: '查询中.......' 
			    }); 
				$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					data:$('#checkStationform').serialize(),
					url:"ajax/testingdataQuery?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,600,800,1000],
						        beforePageText: '第',//页数文本框前显示的汉字 
						        afterPageText: '页    共 {pages} 页', 
						        displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录', 
								onSelectPage: function (pageNumber, pageSize) { 
					                fLoadData(pageNumber, pageSize); 
					                pageSize1 = 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();
				selsectCheckStation();
				//changeSize();
		}
		
	function changeSize(){
		fLoadData(1,pageSize1);
	}
	
	function selsectCheckStation(){
			var ii=1;
			var select = document.getElementById("checkStation");
			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:$('#checkStationform').serialize(),
					//url:"ajax/hiddencheckStation",
					//url:"ajax/hiddenspeStation",
					url:"ajax/hiddenspeStation?type=1",
					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));
  						});
						      
							
					}
			});
	}
	function selsectCheckStation1(){
			selsectCheckStation();
			changeSize();
	}
	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:$('#checkStationform').serialize(),
					url:"ajax/testingdataQuery?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,600,800,1000],
						        beforePageText: '第',//页数文本框前显示的汉字 
						        afterPageText: '页    共 {pages} 页', 
						        displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录', 
								onSelectPage: function (pageNumber, pageSize) { 
					                fLoadData(pageNumber, pageSize); 
					                pageSize1 = pageSize;
           						 } 
							
							});
							  
							if(!grid){
			alert("数据为空");
			return false;
		}else{
			expt(grid);
		}
											}
				});
	
			
		}
		
		function add(divID,divID1){
	  		$("#"+divID).dialog("open").dialog('setTitle', "导出");
	  		
	  		$("#"+divID).panel("move",{top:$(document).scrollTop() + ($(window).height()-370) * 0.5});  
	}
	
	function export123(){
		var startNumber = $('#startNumber').numberbox('getValue');
		var endNumber = $('#endNumber').numberbox('getValue');
		if(startNumber&&endNumber){
			var checkGuid="";
		var cylinderGuid="";
		var province=document.getElementById("province").value;
		
		var city = document.getElementById("city").value;
		var country = document.getElementById("country").value;
		var checkStation = document.getElementById("checkStation").value;
		var carNo=document.getElementById("carNo").value;
		var cylinderType = document.getElementById("cylinderType").value;
		var productNo = document.getElementById("productNo").value;
		var cylinderNo = document.getElementById("cylinderNo").value;
		var checkState = document.getElementById("checkState").value;
		var startTime = $('#startTime').datebox('getValue');
		var endTime = $('#endTime').datebox('getValue');
		
		var params = "page="+startNumber+"&psize="+endNumber+"&checkGuid="+checkGuid+"&cylinderGuid="+cylinderGuid+"&province="+province+"&city="+city+"&country="+country+"&checkStation="+checkStation;
		var params1 = "&carNo="+carNo+"&cylinderType="+cylinderType+"&productNo="+productNo+"&cylinderNo="+cylinderNo+"&checkState="+checkState+"&startTime="+startTime+"&endTime="+endTime;
		
		$("#add").dialog("close");
		
		location.href="servlet/exportServlet.do?"+params+params1;	
		$.messager.show({
                                    title: '提示',
                                    msg: '正在按检索条件，查询并导出数据到浏览器，请等待!'
                                });	
		}else{
			$.messager.show({
                                    title: '提示',
                                    msg: '第几页和每页条数需要输入!'
                                });	
		}
			
	}
	</script>
	
  </head>
  
  <body>
    <!-- 查询结果：数据表格 -->
  	<table id="tt"  cellspacing="0" cellpadding="0" >
	</table>
	<div id="toolbar" style="padding-top: 10px;height: auto;">
	
  		 <form id="checkStationform" action="ajax/checkStation" method="post">
			
			<table>
			<tr>
				<td>
					<span class="hzbspan">省:</span>
				</td>
				<td>
					<select  name="province" id="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="selsectCheckStation1();" >
					</select>
				</td>
			</tr>
			<tr>
				<td>
					<span class="hzbspan">检验站点:</span>
				</td>
				<td>
					<select  name="checkStation" id = "checkStation" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select"  >
						<option value="">全部</option>
					</select>
				</td>
			</tr>
			<tr>
			<td>
			<span  style="cursor: default"><span class="hzbspan">气瓶类型：</span></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><input type="text"  name="startTime" id="startTime" class="easyui-datebox"  style="width: 150px;height: 34px;"  class="hzbspan" data-options="prompt:'-   -   -   -   -   -   -'">
			</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" data-options="prompt:'-   -   -   -   -   -   -'">
			
			
			</td>
			<td><span  style="cursor: default"><span class="hzbspan">检验状态：</span></span>
			<select  name="checkState" id="checkState" 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>
				</select>		</td>	
			</tr>
			
			<tr>
			<td>
			<span  style="cursor: default"><span class="hzbspan">气瓶厂家编号:</span></span></td>
			<td><input type="text" name="productNo" id="productNo" style="width: 150px;height: 34px;"  class="hzbspan" placeholder="-   -   -   -   -   -   -">
			</td>
			<td><span  style="cursor: default"><span class="hzbspan">气瓶出厂编号:</span></span></td>
			<td><input type="text" name="cylinderNo" id="cylinderNo"  style="width: 150px;height: 34px;"  class="hzbspan" placeholder="-   -   -   -   -   -   -">
			
			</td>
			<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" placeholder="-   -   -   -   -   -   -">
			
			</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> 
			<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> 
			<a href="javascript:void(0)" class="easyui-linkbutton" iconcls="icon-save" onclick="add('add','regionNo')" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">条目导出</span></a>
			</td>
			</tr>
		</table>
		</form>	
	</div>
	<div id="dialog2"></div> 
	
	<div id="add" class="easyui-dialog" style="width: 400px; height: 200px; padding: 10px 40px;"  shadow="false"  closed="true" modal="true" buttons="#dlg-buttons">
      
	      <div  style="float: left;padding-top: 20px;">
       <form id="addfm" method="post">
       <table>
       	<tr>
       		<td>
       			<label>第 几 页</label>
       		</td>
       		<td>
       			<input name="startNumber" id="startNumber" class="easyui-numberbox" min="1" editable="true"  required="true" style="width: 200px;" />
       		</td>
       	</tr>
       	<tr>
       		<td>
       			<label>每页条数</label>
       		</td>
       		<td>
       			<input name="endNumber" id="endNumber" class="easyui-numberbox"  min="1" max="2000" editable="true"  required="true" style="width: 200px;" />
       		</td>
       	</tr>
       </table>
	        
       </form>
       </div>
 	<div id="dlg-buttons">
        <a href="javascript:void(0)" class="easyui-linkbutton" onclick="export123()" iconcls="icon-add">确定</a>
        <a href="javascript:void(0)" class="easyui-linkbutton" onclick="javascript:$('#add').dialog('close')"
            iconcls="icon-cancel">取消</a>
    </div> 
    </div>
  </body>
</html>