HJY
/
gxwss


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267
							<!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 g;

      	var gridData;

		function initComplete(){

			 g = $("#maingrid").quiGrid({

				 columns: [ 

	                { display: '单位编号', name: 'orgNumber',     align: 'center', width: "6%"},

	                { display: '单位名称', name: 'orgName',     align: 'center', width: "10%",

	                  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: "10%",

		                   render:function(rowdata, rowindex, value, column){

		                	   return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";

		                   }	

		             },	                

	                { display: '年份', name: 'year',     align: 'center', width: "4%"},

	                { display: '全年计划批复水量', name: 'planOfWater',     align: 'center', width: "9%"},

	                { display: '全年实际批复水量', name: 'replyOfWater',     align: 'center', width: "9%"},

	                { display: '全年实际用水量', name: 'yearUseWater',     align: 'center', width: "8%"},

	                { display: '全年超计划用水量', name: 'yearOverWater',     align: 'center', width: "9%",

	                   render:function(rowdata, rowindex, value, column){

	                	     var a = Number(rowdata.yearUseWater)-Number(rowdata.planOfWater);

	                	     if(a<=0){

	                	    	 return "0";

	                	     }else{

	                	    	 return a;

	                	     }

	           
	                   }

	                },

	                { display: '全年节约用水量', name: 'yearSaveWater',     align: 'center', width: "8%",

	                   render:function(rowdata, rowindex, value, column){

	                	   var a = Number(rowdata.replyOfWater)-Number(rowdata.yearUseWater); 

	                	   if(a<=0){

	                		  return "0"; 

	                	   }else{

	                		   return a;

	                	   }

	                   }

	                },

	                { display: '超计划用水量比率(%)', name: 'overPlanWater', align: 'center', width: "10%",

	                   render:function(rowdata, rowindex, value, column){

	                	   if(rowdata.planOfWater == 0){

	                		   return "0.00%";

	                	   }else{

		                	   var a = Number(rowdata.yearUseWater)-Number(rowdata.planOfWater);

		                	   if(a<0){

		                		   return "0.00%";

		                	   }else{

		                		   return ((a/Number(rowdata.planOfWater))*100).toFixed(2)+"%";

		                	   } 

	                	   }	              	      	   

	                   }	

	                },

	                { display: '实际超(节)用水量', name: 'saveAndOverWater',     align: 'center', width: "9%",

	                   render:function(rowdata, rowindex, value, column){

	                	   return Number(rowdata.yearUseWater)-Number(rowdata.replyOfWater)+"";

	                   }

	                },

	                {display:'罚款金额(元)',name:'fineMoney',align:'center',width:"7%"},

	                {display:'备注',name:'remark',align:'center',width:"10%"}

	              ], 

	              toolbar:{

	              	items:[

						<@pop_perm url="/busInit/importYearCountUnitWater.do">

		              	    {text:'导出',click:importCountOrgWater,iconClass:'icon_add'},

		              	    {line:true}

	  					</@pop_perm>

	              	  	
	             		]

	              },

                data:[],  sortName: 'userId',rownumbers:true,dataAction:'local',checkbox:true,usePager: false,

                height: '100%', width:"100%",heightDiff:-40,

                onChangeSort : function(){

                	getData(g.options.sortName,g.options.sortOrder,g_pageNo,g_pageSize);

                	return false;

                }

			 
            });

	            
             //点击分页触发

		}

		
		$(function(){	

			getData(g_pageNo,g_pageSize);

		})

		
		/**初始时通过向后台传递排序id、排序顺序、初始页码、每页条数**/

		function getData(pageNo,pageSize){

			jQuery.post("${ctx}/busInit/listCountReplyWater.do",

					getFormParams(pageNo,pageSize),

					function(result){

						gridData = result;

						//刷新表格

						g.loadData(gridData);

						//设置左边内容页

						var content ="共有" + gridData["pager.totalRows"] + "条记录";

						$("#letfContent").html("");

						$("#letfContent").html(content);

						//取得分页组件

						var pager=$("#pager");

						//设置总页页数

				 		pager.attr("total",gridData["pager.totalRows"]);

						pager.render();

						//绑定翻页事件

						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(){

		//重新加载数据,设置当前页面为1

		getData(1,g_pageSize);

	}

	
	/**获得查询表单的提交查询的值**/

	function getFormParams(pageNo,pageSize){

		$("#pageNo").val(pageNo);

		$("#pageSize").val(pageSize);

		return $("#searchForm").formToArray(); 

	}

	
	/**重置于查询表单,然后重新加载表格数据**/

	function resetSearch(){

		$("#searchForm")[0].reset();

		//重新加载数据,设置当前页面为1

		getData(1,g_pageSize);

	}

	
	//生成年度初值化

	function importCountOrgWater() {

		var orgNumber = $("#orgNumber").val();

		var orgName = $("#orgName").val();

		var year = $("#year").val();

		var address = $("#address").val();

		var busOrgCustomerNumber = $("#busOrgCustomerNumber").val();

		var userType = $("#userType").val();

		var url = "${ctx}/busInit/importYearCountUnitWater.do?year="+year;

		url += "&orgNumber="+orgNumber+"&orgName="+orgName+"&address="+address;

		url += "&busOrgCustomerNumber="+busOrgCustomerNumber+"&userType="+userType;

		location.href=url;

	}


	//获取所有选中行获取选中行的id 格式为 ids=1&ids=2 

	function getSelectId(grid) {

		var selectedRows = grid.getSelectedRows();

		var selectedRowsLength = selectedRows.length;

		var ids = "";

		for(var i = 0;i<selectedRowsLength;i++) {

			if(ids.length<=0){

				ids +=selectedRows[i].orgId;

			}else{

				ids +=","+ selectedRows[i].orgId;	

			}

		}

		return {"ids":ids};

	}

	
</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="10" />
			<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 align="right">年度：</td>
					<td><input class="date" dateFmt="yyyy" type="text" id="year"

						name="year" value="${year}" /></td>
					<td style="padding-left: 15px;"><button type="button"

							onclick="searchHandler()">
							<span class="icon_find">查询</span>
						</button></td>
					</td>
				</tr>
				<tr>
					<td>单位地址：</td>
					<td><input type="text" id="address" name="address" /></td>
					<td align="right">客户号：</td>
					<td><input type="text" id="busOrgCustomerNumber"

						name="busOrgCustomerNumber" /></td>
					<td>用户类型：</td>
					<td><select prompt="请选择" id="userType"

						data='${userType}' name="userType"></select></td>
					<td style="padding-left: 15px;"><button type="reset"

							onclick="resetSearch()">
							<span class="icon_find">重置</span>
						</button></td>
					</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>