HJY
/
gxwss


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437
							<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>单位月用水量信息列表</title>
<!--框架必需start-->
<script type="text/javascript" src="${ctx}/qui/libs/js/jquery.js"></script>
<script type="text/javascript" src="${ctx}/qui/libs/js/framework.js"></script>
<link href="${ctx}/qui/libs/css/import_basic.css" rel="stylesheet"
	type="text/css" />
<link rel="stylesheet" type="text/css" id="skin" prePath="${ctx}/qui/" />
<link rel="stylesheet" type="text/css" id="customSkin" />
<!--框架必需end-->

<!--数据表格start-->
<script src="${ctx}/qui/libs/js/table/quiGrid.js" type="text/javascript"></script>
<!--数据表格end-->

<!--箭头分页start-->
<script type="text/javascript" src="${ctx}/qui/libs/js/nav/pageArrow.js"></script>
<!--箭头分页end-->

<!--表单异步提交start-->
<script src="${ctx}/qui/libs/js/form/form.js" type="text/javascript"></script>
<!--表单异步提交end-->

<!-- 日期选择框start -->
<script type="text/javascript"
	src="${ctx}/qui/libs/js/form/datePicker/WdatePicker.js"></script>
<!-- 日期选择框end -->


<script type="text/javascript">
	  var g_pageNo = 1;
	  var g_pageSize = 10;
	  var total_rows=0;
      //数据表格使用
        var g;
      	var gridData;
		function initComplete(){
			 g = $("#maingrid").quiGrid({
				 columns: [ 
                    { display: '单位编号', name: 'orgNumber', align: 'center', width: "6%"},
                    { display: '单位名称', name: 'orgName', align: 'center', width: "8%",
                    	render:function(rowdata, rowindex, value, column){
		                	  return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
		                  }		
                    },
                    { display: '单位地址', name: 'address', align: 'center', width: "8%",
                    	render:function(rowdata, rowindex, value, column){
		                	  return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
		                  }		
                    },
                    { display: '水表编号', name: 'meterNumber', align: 'center', width: "6%"},
                    { display: '年度', name: 'year', align: 'center', width: "5%"},
                    { display: '年用水量', name: 'yearWaterConsumption', align: 'center', width: "6%"},
                    { display: '1月份用水量', name: 'janWaterConsumption', align: 'center', width: "6%"},
                    { display: '2月份用水量', name: 'febWaterConsumption', align: 'center', width: "6%"},
                    { display: '3月份用水量', name: 'marWaterConsumption', align: 'center', width: "6%"},
                    { display: '4月份用水量', name: 'aprWaterConsumption', align: 'center', width: "6%"},
                    { display: '5月份用水量', name: 'mayWaterConsumption', align: 'center', width: "6%"},
                    { display: '6月份用水量', name: 'junWaterConsumption', align: 'center', width: "6%"},
                    { display: '7月份用水量', name: 'julWaterConsumption', align: 'center', width: "6%"},
                    { display: '8月份用水量', name: 'augWaterConsumption', align: 'center', width: "6%"},
                    { display: '9月份用水量', name: 'sepWaterConsumption', align: 'center', width: "6%"},
                    { display: '10月份用水量', name: 'octWaterConsumption', align: 'center', width: "6%"},
                    { display: '11月份用水量', name: 'novWaterConsumption', align: 'center', width: "6%"},
                    { display: '12月份用水量', name: 'decWaterConsumption', align: 'center', width: "6%"},
                    { display: '备注', name: 'remark', align: 'center', width: "6%"}
	              ], 
	              toolbar:{
	              	items:[
						<@pop_perm url="/meterReadInfo/viewDetails.do">
						{line:true},
						{text: '查看详情', click: viewDetail, iconClass: 'icon_view'},
						</@pop_perm>
						<@pop_perm url="/meterReadInfo/exportWaterConsumptionExcel.do">
						{line:true},
						{text: '导出', click: exportMonthWaterExcel, iconClass: 'icon_export'},
						</@pop_perm>
						<@pop_perm url="/meterReadInfo/printWaterConsumption.do">
						{line:true},
						{text: '打印', click: onPrint, iconClass: 'icon_print'},
						</@pop_perm>
		              	{line:true}
	             		]
	              },
                data:[],rownumbers:true,dataAction:'local',checkbox:true,usePager: false,
                height: '100%', width:"100%",heightDiff:-40,
                isChecked:checkedHandler,onCheckRow: checkRowHandler, onCheckAllRow: checkAllRowHandler
            });
		}
		
		$(function(){
			getData(g_pageNo,g_pageSize);
		});
		
		/**初始时通过向后台传递排序id、排序顺序、初始页码、每页条数**/
		function getData(pageNo,pageSize){
			var year=$("#year").val();
			if(year.length<=0){
				$("#remind").html("<font color=red>年度不能为空</font>");
				return false;
			}
			jQuery.post("${ctx}/meterReadInfo/listPage.do",
					getFormParams(pageNo,pageSize),
					function(result){
						gridData = result;
						//刷新表格
						g.loadData(gridData);
						total_rows=gridData["pager.totalRows"];
						//设置左边内容页
						var content ="共有" + gridData["pager.totalRows"] + "条记录";
						$("#letfContent").html("");
						$("#letfContent").html(content);
						//取得分页组件
						var pager=$("#pager");
						//设置总页页数
				 		pager.attr("total",gridData["pager.totalRows"]);
						pager.render();
						//绑定翻页事件
						pager.unbind("pageChange");
						pager.bind("pageChange",function(e,index){
							g_pageNo = index + 1;
							getData(g_pageNo,g_pageSize);			
						});
						//绑定选择每页显示记录数事件
						pager.bind("sizeChange",function(e,num){
							g_pageSize = num;
							getData(g_pageNo,g_pageSize);
						});
					},"json");
		}
		
		
		//查询
	function searchHandler(){
		//清空数组
		clearArray();
		//重新加载数据,设置当前页面为1
		getData(1,g_pageSize);
	}
	
	/**获得查询表单的提交查询的值**/
	function getFormParams(pageNo,pageSize){
		$("#pageNo").val(pageNo);
		$("#pageSize").val(pageSize);
		return $("#searchForm").formToArray(); 
	}
	
	/**重置于查询表单,然后重新加载表格数据**/
	function resetSearch(){
		//清空数组
		clearArray();
		$("#searchForm")[0].reset();
		//重新加载数据,设置当前页面为1
		getData(1,g_pageSize);
	}

	//导出单位月用水量信息
	function exportMonthWaterExcel() {
		var rows = g.getSelectedRows();
		var rowsLength = rows.length;
		var ids=getCheckedHandler();
		var year=getCheckedYearHandler();
		if(rowsLength == 0 && ids=='') {
			exportTotalData();
			return;
		}
		
		window.location.href="${ctx}/meterReadInfo/exportWaterConsumptionExcel.do?orgIds="+ids+"&year="+year+"&flag=selected";
		return;
		
		
		/* $(function($){
			   $.post("${ctx}/meterReadInfo/exportWaterConsumptionExcel.do",
					   {ids:ids,flag:"selected"},
					   function(data){
						   
			   			}
			   		 );
				
			}); */
		
	}
	
	//导出处理
	function exportTotalData(){
		var orgNumber=$("#orgNumber").val();
		var orgName=$("#orgName").val();
		var meterNumber=$("#meterNumber").val();
		var year=$("#year").val();
		var address=$("#address").val();
		var isPlanUser=$("#isPlanUser").val();
		var userType=$("#userType").val();
		var minWater=$("#minWater").val();
		var maxWater=$("#maxWater").val();
		var url="${ctx}/meterReadInfo/exportWaterConsumptionExcel.do?";
		url +="orgNumber="+orgNumber;
		url +="&orgName="+orgName;
		url +="&meterNumber="+meterNumber;
		url +="&year="+year;
		url +="&address="+address;
		url +="&isPlanUser="+isPlanUser;
		url +="&userType="+userType;
		url +="&minWater="+minWater;
		url +="&maxWater="+maxWater;
		url +="&flag=query";
		
		url +="&pageNo=1";
		url +="&pageSize="+total_rows;
		
		window.location =url;
		return false;
	}
	
	
	var checkedArray = [];
	var checkedYearArray = [];
	function findCheckedArray(id){
        for(var i =0;i<checkedArray.length;i++){
            if(checkedArray[i] == id) return i;
        }
        return -1;
    }

    function addCheckedArray(id,year){
        if(findCheckedArray(id) == -1){
          checkedArray.push(id);
          checkedYearArray.push(year);
        }
    }

    function removeCheckedArray(id){
        var i = findCheckedArray(id);
        if(i==-1) return;
        checkedArray.splice(i,1);
        checkedYearArray.splice(i,1);
    }

    function checkedHandler(rowdata){
        if (findCheckedArray(rowdata.orgId) == -1)
            return false;
        return true;

    }

    function checkRowHandler(checked, data){
        if (checked) addCheckedArray(data.orgId,data.year);
        else removeCheckedArray(data.orgId,data.year);
    }

    function checkAllRowHandler(checked){
        for (var rowid in this.records){
            if(checked)
                addCheckedArray(this.records[rowid]['orgId'],this.records[rowid]['year']);
            else
                removeCheckedArray(this.records[rowid]['orgId'],this.records[rowid]['year']);
        }
    }
    
    function getCheckedHandler()
    {
        return checkedArray.join(',');
    }
	
    function getCheckedYearHandler(){
		return checkedYearArray.join(',');
	}
    
    //打印单位月用水量
    function onPrint(){
    	var rows = g.getSelectedRows();
		var rowsLength = rows.length;
		var ids=getCheckedHandler();
		var year=getCheckedYearHandler();
		if(rowsLength == 0&&ids=='') {
			printTotal();
			return;
		}
		
		window.open("${ctx}/meterReadInfo/printWaterConsumption.do?orgIds="+ids+"&year="+year+"&flag=selected");
		return;
		
    }
    
  	//打印全部
	function printTotal(){
		var orgNumber=$("#orgNumber").val();
		var orgName=$("#orgName").val();
		var meterNumber=$("#meterNumber").val();
		var year=$("#year").val();
		var address=$("#address").val();
		var isPlanUser=$("#isPlanUser").val();
		var userType=$("#userType").val();
		var minWater=$("#minWater").val();
		var maxWater=$("#maxWater").val();
		var url="${ctx}/meterReadInfo/printWaterConsumption.do?";
		url +="orgNumber="+orgNumber;
		url +="&orgName="+orgName;
		url +="&meterNumber="+meterNumber;
		url +="&year="+year;
		url +="&address="+address;
		url +="&isPlanUser="+isPlanUser;
		url +="&userType="+userType;
		url +="&minWater="+minWater;
		url +="&maxWater="+maxWater;
		url +="&flag=query";
		
		url +="&pageNo=1";
		url +="&pageSize="+total_rows;
		
		window.open(url);
		return false;
	}
    
    
    $(function($){
    	var old_min;
    	var old_max;
		//获得之前的值
		$("#minWater").focus( function() {
			old_min=$(this).val();
		});
		$("#maxWater").focus( function() {
			old_max=$(this).val();
		});
		$("#minWater").change( function() {
			var water=$(this).val();
			if(isNaN(water)){
				$(this).val(old_min);
				return;
			}
		});
		$("#maxWater").change( function() {
			var water=$(this).val();
			if(isNaN(water)){
				$(this).val(old_max);
				return;
			}
		});
	});
    
    //查看单位月用水量详情
    function viewDetail(){
    	var rows = g.getSelectedRows();
		var rowsLength = rows.length;
		if(rowsLength == 0) {
			top.Dialog.alert("请选中一行!");
			return;
		}else if(rowsLength>1){
			top.Dialog.alert("每次只可查看一条数据!");
			return;
		}
		
		var orgId=rows[0].orgId;
		var year=rows[0].year;
		top.Dialog.open({
			URL : "${ctx}/meterReadInfo/viewDetails.do?orgId="+orgId+"&year="+year,
			Title : "单位月用水量详情",
			Width : 800,
			Height : 550
		});
    }
    
  	//清空数组
    function clearArray(){
    	checkedArray.length=0;
    	checkedYearArray.length=0;
    }
</script>

</head>
<body>
	<div class="box2" panelTitle="单位月用水量信息列表">
		<form action="" id="searchForm" method="post">
			<input type="hidden" id="pageNo" name="pageNo" value="1" /> <input
				type="hidden" id="pageSize" name="pageSize" value="20" />
			<table>
				<tr>
					<td>单位编号：</td>
					<td><input type="text" id="orgNumber" name="orgNumber" /></td>
					<td>单位名称：</td>
					<td><input type="text" id="orgName" name="orgName" /></td>
					<td>水表编号：</td>
					<td><input type="text" id="meterNumber" name="meterNumber" /></td>
				</tr>
				<tr>
					<td>是否计划户：</td>
					<td><select id="isPlanUser" name="isPlanUser">
							<option value="">全部</option>
							<option value="yes">计划户</option>
							<option value="no">非计划户</option>
					</select></td>
					<td>单位地址：</td>
					<td><input type="text" id="address" name="address" /></td>
					<td>年度：</td>
					<td><input type="text" id="year" name="year" class="date"
						dateFmt="yyyy" value="${year!'' }" /></td>
				</tr>
				<tr>
					<td>年用水量(m³)：(≥)</td>
					<td><input type="text" id="minWater" name="minWater" /></td>
					<td>并且(≤)：</td>
					<td><input type="text" id="maxWater" name="maxWater" /></td>
					<td>用户类型：</td>
					<td><select id="userType" name="userType"
						data='{"list":${userTypeData}}' prompt="全部"></select></td>
					<td colspan="4">
						<button type="button" onclick="searchHandler()">
							<span class="icon_find">查询</span>
						</button>
						<button type="button" onclick="resetSearch()">
							<span class="icon_reload">重置</span>
						</button>
					</td>
				</tr>
			</table>
		</form>
	</div>
	<div id="scrollContent">
		<div class="padding_right5">
			<div id="maingrid"></div>
		</div>
	</div>
	<!-- 分页组件 -->
	<div style="height: 35px;">
		<div id="letfContent" class="float_left padding5"></div>
		<div class="float_right padding5">
			<div id="pager" total="0" class="pageArrow" showSelect="true"
				inputPosition="right"></div>
		</div>
		<div class="clear"></div>
	</div>

</body>
</html>