HJY
/
gxwss


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658
							<!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 type="text/javascript"
	src="${ctx}/qui/libs/js/form/datePicker/WdatePicker.js"></script>
<!-- 日期选择框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-->


<script type="text/javascript">
	  var g_pageNo = 1;
	  var g_pageSize = 10;
	  var total_rows=0;
	  //刷新记忆
	  var checkedArray = [];
	  
      //数据表格使用
        var g;
      	var gridData;
		function initComplete(){
			 g = $("#maingrid").quiGrid({
				 columns: [ 
	                { display: '单位编号', name: '2',     align: 'center', width: "6%"},
	                { display: '单位名称', name: '3',     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: '4',     align: 'center', width: "13%",
	                	render:function(rowdata, rowindex, value, column){
		                	   return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
		                   }
	                },
	                { display: '水表号', name: '25',     align: 'center', width: "13%",
	                	render:function(rowdata, rowindex, value, column){
		                	   return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
		                   }
	                },	                
	                { display: '邮寄地址', name: '24',     align: 'center', width: "13%",
	                	render:function(rowdata, rowindex, value, column){
		                	   return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
		                   }
	                },	                
	                { display: '邮编', name: '23',     align: 'center', width: "6%",
	                	render:function(rowdata, rowindex, value, column){
		                	   return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
		                   }
	                },	                
	                { display: '用户类型', name: '6',     align: 'center', width: "6%",
	                     render:function(rowdata, rowindex, value, column){
	                    	 if(value == "1"){
	                    		 return "自来水户";
	                    	 }else if(value == "2"){
	                    		 return "取水户";
	                    	 }else{
	                    		 return "";
	                    	 }
	                     }	
	                },
	                { display: '季度', name: '8',     align: 'center', width: "5%"},
	                { display: '用水计划指标', name: '9',     align: 'center', width: "5%"},
	                { display: '用水计划旧指标', name: '32',     align: 'center', width: "5%"},	                
	                { display: '实际用水量', name: '14',     align: 'center', width: "5%"},
	                { display: '实际收水量', name: '15',     align: 'center', width: "5%",
	                	render: function (rowdata, rowindex, value, column){
							return value.toFixed(0);         	   
	                	}
                	},
                	{ display: '超用率(%)', name: '16',     align: 'center', width: "5%",
	                	render: function (rowdata, rowindex, value, column){
							return value+'%';         	   
	                	}
                    },
                    { display: '应收金额', name: '18',     align: 'center', width: "5%",
                    	render: function (rowdata, rowindex, value, column){
							return Number(value).toFixed(1);           	   
	                	}
                    },
	                { display: '实收金额', name: '17',     align: 'center', width: "5%",
	                	render: function (rowdata, rowindex, value, column){
							return Number(value).toFixed(1);           	   
	                	}
    	            },
	                { display: '是否销账', name: '10',     align: 'center', width: "5%",
	                	render: function (rowdata, rowindex, value, column){
		                	if(value=='yes'){
		                		return "是";
			                }
			                if(value=='no'){
				                return "否";
				            }             	   
	                	}
		            },
	                { display: '销帐日期', name: '11',     align: 'center', width: "5%"},
	                { display: '付款方式', name: '12',     align: 'center', width: "5%",
	                	render: function (rowdata, rowindex, value, column){
		                	if(value=='1'){
		                		 return "现金";
			                }
			                if(value=='2'){
				                return "转账";
				            }             	   
	                	}
		            },
	                { display: '用水单价', name: '13',     align: 'center', width: "5%",
	                	render: function (rowdata, rowindex, value, column){
							return Number(value).toFixed(2);           	   
	                	}
		            },
	                { display: '超10-30%的水量', name: '27',     align: 'center', width: "5%"		            },		            
		            
	                { display: '超30%以上的水量', name: '28',     align: 'center', width: "5%"		            },	
	                { display: '超10-30%的金额', name: '30',     align: 'center', width: "5%",
	                	render: function (rowdata, rowindex, value, column){
							return Number(value).toFixed(1);           	   
	                	}
		            },		            
		            
	                { display: '超30%以上的金额', name: '29',     align: 'center', width: "5%",
	                	render: function (rowdata, rowindex, value, column){
							return Number(value).toFixed(1);           	   
	                	}
		            },	

	                { display: '总金额', name: '31',     align: 'center', width: "5%",
	                	render: function (rowdata, rowindex, value, column){
							return Number(value).toFixed(1);           	   
	                	}
		            },
				    { display: '操作', isAllowHide: false, align: 'center', width:"15%",
						 render: function (rowdata, rowindex, value, column){
		                 	    return '<div class="padding_top4 padding_left20">'
		                                 <@pop_perm url="/quarterAssessment/update1.do">
		                                 + '<a href="#"  onclick="onEdit('+ rowdata[0]+')"><span class="icon_edit">修改</span></a>'
		                                 </@pop_perm>
		                                 <@pop_perm url="/quarterAssessment/delete.do">
		                                 + '<a href="#"  onclick="onDelete('+ rowdata[0]+')"><span class="icon_delete">删除</span></a>'
		                                 </@pop_perm>
		                             + '</div>';
		                 }
		            }],
	              toolbar:{
	              	items:[
						<@pop_perm url="/quarterAssessment/create.do">
  							{text:'新增',click:onCreate,iconClass:'icon_add'},
						</@pop_perm>
  							
						<@pop_perm url="/quarterAssessment/update.do">
							{line:true},
							{text:'修改',click:onEdit1, iconClass:'icon_edit'},
						</@pop_perm>
							
		              	<@pop_perm url="/quarterAssessment/delete.do">
							{line:true},
							{text:'批量删除',click:batchDelete, iconClass:'icon_delete'},
						</@pop_perm>
						<@pop_perm url="/quarterAssessment/print.do">
							{line:true},
							{text:'打印',click:print, iconClass:'icon_print'},
						</@pop_perm>
						<@pop_perm url="/quarterAssessment/exportExcel.do">
							{line:true},
							{text:'导出',click:exportExcel, iconClass:'icon_export'},
						</@pop_perm>
							
							<@pop_perm url="/quarterAssessment/wx.do">
							{line:true},
							{text:'wx',click:wx, iconClass:'icon_export'},
						</@pop_perm>
	              	  	{line:true}
	             		]
	              },
                data:[],  sortName: 'showOrgName',rownumbers:true,checkbox:true,usePager: false,height: '100%', width:"100%",heightDiff:-40,pageSize:g_pageSize,
                onChangeSort : function(){
                	getData(g.options.sortName,g.options.sortOrder,g_pageNo,g_pageSize);
                	return false;
                },isChecked:checkedHandler,onCheckRow: checkRowHandler, onCheckAllRow: checkAllRowHandler
            });
	            
             //点击分页触发
		}
		
		$(function(){
			getData(g_pageNo,g_pageSize);
// 			getData(g.options.sortName,g.options.sortOrder,g_pageNo,g_pageSize);
		})
		
		//打印年度计划供水表预览
// 	    function print(){
// 	    	window.open("${ctx}/quarterAssessment/print.do?exportType=list&pageNo=1&pageSize="+total_rows);
// 	    }

	    //打印
	    function print(){
			var rows = g.getSelectedRows();
			var rowsLength = rows.length;
			var ids = getCheckedIdHandler();
			if(rowsLength == 0 && ids=='') {
				printByPage();
				return;
			}
			
//	 		alert(ids);
//	 		var orgIds=getCheckedOrgIdHandler();
//	 		var months=getCheckedMonthHandler();
//	 		var years=getCheckedYearHandler();
			//window.location.href="${ctx}/customerMeter/exportExcel.do?&ids="+ids+"&flag=selected&pageNo=1&pageSize="+total_rows;
			window.open("${ctx}/quarterAssessment/print.do?exportType=list&ids="+ids+"&flag=selected&pageNo=1&pageSize="+total_rows);
			return;
	    }
// 	    function print(){
//	    	window.open("${ctx}/quarterAssessment/print.do?exportType=list&pageNo=1&pageSize="+total_rows);
//	    }

    //打印
    function wx(){
		window.open("${ctx}/quarterAssessment/wx.do");
		return;
    }
	    function printByPage(){
			var orgNumber=$("#orgNumber").val();
			var orgName=$("#orgName").val();
			var address=$("#address").val();
			var year=$("#year").val();
			var busOrgCustomerNumber=$("#busOrgCustomerNumber").val();
			var busOrgMeterNumber=$("#busOrgMeterNumber").val();
			var quarter=$('#quarter').val();

			var overWaterBegin=$('#overWaterBegin').val(); 
			var overWaterEnd=$('#overWaterEnd').val(); 
			var amountReceivableBegin=$('#amountReceivableBegin').val(); 
			var amountReceivableEnd=$('#amountReceivableEnd').val(); 
			var isPlanUser=$("#isPlanUser").val();
			var userType=$("#userType").val();
			
			var url="${ctx}/quarterAssessment/print.do?";
			url +="orgNumber="+orgNumber;
			url +="&orgName="+orgName;
			url +="&address="+address;
			url +="&year="+year;
			url +="&busOrgCustomerNumber="+busOrgCustomerNumber;
			url +="&busOrgMeterNumber="+busOrgMeterNumber;
			url +="&quarter="+quarter;

			url +="&overWaterBegin="+overWaterBegin;
			url +="&overWaterEnd="+overWaterEnd;
			url +="&amountReceivableBegin="+amountReceivableBegin;
			url +="&amountReceivableEnd="+amountReceivableEnd;
			url +="&isPlanUser="+isPlanUser;
			url +="&userType="+userType;

			url +="&flag=query";
			url +="&exportType=list";
			url +="&pageNo=1";
			url +="&pageSize="+total_rows;
			url = encodeURI(encodeURI(url));
			window.open(url);
	    }
	    
		/**初始时通过向后台传递排序id、排序顺序、初始页码、每页条数**/
		function getData(pageNo,pageSize){
			jQuery.post("${ctx}/quarterAssessment/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 getData2(sort,direction,pageNo,pageSize){
        $.post("${ctx}/quarterAssessment/listPage.do",
                {
		         "pageNo":pageNo,
		         "pageSize":pageSize
                },
                function(result){
                    gridData = result;
                    //刷新表格
                    g.loadData(gridData);
                },"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 onDelete(rowid){
		top.Dialog.confirm("确定要删除该记录吗？",function(){
		  	//删除记录
		  	jQuery.post("${ctx}/quarterAssessment/delete.do",
		  			{"ids":rowid},
		  			function(responseText){
		  				if(responseText.status=="y"){
		  					top.Dialog.alert(responseText.info);
			  				resetSearch();
		  				}else{
		  					top.Dialog.alert(responseText.info);
		  				}
		  				
					},
					"json");
			});
	}

	//批量删除
	function batchDelete() {
		var rows = g.getSelectedRows();
		var rowsLength = rows.length;
		if(rowsLength == 0) {
			top.Dialog.alert("请选中要删除的记录!");
			return;
		}
		top.Dialog.confirm("确定要删除吗？",function(){
				jQuery.post("${ctx}/quarterAssessment/delete.do",
						//获取所有选中行
						getSelectId(g),
						function(responseText){
							if(responseText.status=="y"){
			  					top.Dialog.alert(responseText.info);
				  				resetSearch();
			  				}else{
			  					top.Dialog.alert(responseText.info);
			  					return false;
			  				}
						},
						"json");
			});
	
		//获取所有选中行获取选中行的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++) {
				ids += selectedRows[i][0] + ",";
			}
			return {"ids":ids};
		}
	}

	//新增
	function onCreate(){
		top.Dialog.open({
			ID:'a1',
			URL:"${ctx}/quarterAssessment/create.do?year="+$('#year').val(),
			Title:"新增季度考核",
			Width:700,
			Height:350
		});
	}

	
	//修改单位基本信息
	function onEdit1() {
		var rows = g.getSelectedRows();
		var rowsLength = rows.length;
		if(rowsLength == 0) {
			top.Dialog.alert("请选中要编辑的记录!");
			return;
		}
		if(rowsLength > 1) {
			top.Dialog.alert("请只选中一条要编辑的记录!");
			return;
		}
	
		var selectedRows = g.getSelectedRows();

		top.Dialog.open({
			URL : "${ctx}/quarterAssessment/update.do?entity_id="+selectedRows[0][0],
			Title : "编辑单位季度考核用水",
			Width : 800,
			Height : 500
		});


	}
	//修改
	function onEdit(rowId){
// 		alert(rowId);
		top.Dialog.open({
			ID:'a1',
			URL:"${ctx}/quarterAssessment/update.do?entity_id="+rowId,
			Title:"修改水表",
			Width:700,
			Height:350
		});
	}

  	//导出单位季度考核用水
  	function exportExcel() {
		var rows = g.getSelectedRows();
		var rowsLength = rows.length;
		var ids = getCheckedIdHandler();
		if(rowsLength == 0 && ids=='') {
			exportExcelByPage();
			return;
		}
		
// 		alert(ids);
		window.location.href="${ctx}/quarterAssessment/exportExcel.do?&ids="+ids+"&flag=selected&exportType=list&pageNo=1&pageSize="+total_rows;
		return;
		
	}
	
	
	//导出处理
	function exportExcelByPage(){
		var orgNumber=$("#orgNumber").val();
		var orgName=$("#orgName").val();
		var address=$("#address").val();
		var year=$("#year").val();
		var busOrgCustomerNumber=$("#busOrgCustomerNumber").val();
		var busOrgMeterNumber=$("#busOrgMeterNumber").val();
		var quarter=$('#quarter').val();

		var overWaterBegin=$('#overWaterBegin').val(); 
		var overWaterEnd=$('#overWaterEnd').val(); 
		var amountReceivableBegin=$('#amountReceivableBegin').val(); 
		var amountReceivableEnd=$('#amountReceivableEnd').val(); 
		var isPlanUser=$("#isPlanUser").val();
		var userType=$("#userType").val();
		
		var url="${ctx}/quarterAssessment/exportExcel.do?";
		url +="orgNumber="+orgNumber;
		url +="&orgName="+orgName;
		url +="&address="+address;
		url +="&year="+year;
		url +="&busOrgCustomerNumber="+busOrgCustomerNumber;
		url +="&busOrgMeterNumber="+busOrgMeterNumber;
		url +="&quarter="+quarter;

		url +="&overWaterBegin="+overWaterBegin;
		url +="&overWaterEnd="+overWaterEnd;
		url +="&amountReceivableBegin="+amountReceivableBegin;
		url +="&amountReceivableEnd="+amountReceivableEnd;
		url +="&isPlanUser="+isPlanUser;
		url +="&userType="+userType;

		url +="&flag=query";
		url +="&exportType=list";
		url +="&pageNo=1";
		url +="&pageSize="+total_rows;
		url = encodeURI(encodeURI(url));
		window.location =url;
		return false;
	}

	var checkedArray = [];
	function findCheckedArray(id){
        for(var i =0;i<checkedArray.length;i++){
            if(checkedArray[i] == id) return i;
        }
        return -1;
    }

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

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

    function checkedHandler(rowdata){
        if (findCheckedArray(rowdata[0]) == -1)
            return false;
        return true;

    }

    function checkRowHandler(checked, data){
        if (checked) addCheckedArray(data[0]);
        else removeCheckedArray(data[0]);
    }

    function checkAllRowHandler(checked){
        for (var rowid in this.records){
            if(checked)
                addCheckedArray(this.records[rowid][0]);
            else
                removeCheckedArray(this.records[rowid][0]);
        }
    }
    
  	//清空数组
    function clearArray(){
    	checkedArray.length=0;
    }
</script>

</head>
<body>
	<div class="box2" panelTitle="单位季度考核用水信息列表">
		<form action="" id="searchForm" method="post">
			<input type="hidden" id="Q_importStatus_S_LK"
				name="Q_importStatus_S_LK" value="normal" /> <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>单位地址：</td>
					<td><input type="text" id="address" name="address" /></td>
					<td>年度：</td>
					<td><input class="date" dateFmt="yyyy" type="text" id="year"
						name="year" value="${year!''}" /></td>
				</tr>
				<tr>
					<td>超用水量(≥):：</td>
					<td><input type="text" id="overWaterBegin"
						name="overWaterBegin" /></td>
					<td>并且(≤)：</td>
					<td><input type="text" id="overWaterEnd" name="overWaterEnd" /></td>
					<td>应收金额(≥):：</td>
					<td><input type="text" id="amountReceivableBegin"
						name="amountReceivableBegin" /></td>
					<td>并且(≤)：</td>
					<td><input type="text" id="amountReceivableEnd"
						name="amountReceivableEnd" /></td>
				</tr>
				<tr>
					<td>客户号：</td>
					<td><input type="text" id="customerNumber"
						name="customerNumber" /></td>
					<td>水表编号：</td>
					<td><input type="text" id="meterNumber" name="meterNumber" /></td>
					<td>季度：</td>
					<td><select prompt="请选择" id="quarter" name="quarter"
						data='{"list":[{"value":"1","key":"第一季度"},{"value":"2","key":"第二季度"},{"value":"3","key":"第三季度"},{"value":"4","key":"第四季度"}]}'></select></td>
					<td>是否计划户：</td>
					<td><select prompt="请选择" id="isPlanUser"
						data='{"list":[{"value":"yes","key":"计划户"},{"value":"no","key":"非计划户"}]}'
						name="isPlanUser"></select></td>
				</tr>
				<tr>
					<td>用户类型：</td>
					<td><select prompt="请选择" id="userType" data='${userType}'
						name="userType"></select></td>
					<td>用水单价：</td>
					<td><select id="waterPrice" name="waterPrice">
							<option value="">请选择</option>
							<option value="0.00">0.00</option>
							<option value="0.10">0.10</option>
							<option value="1.14">1.14</option>
							<option value="1.21">1.21</option>
							<option value="1.45">1.45</option>
							<option value="1.49">1.49</option>
							<option value="2.20">2.20</option>
							<option value="4.97">4.97</option>
					</select></td>
					<td style="padding-left: 15px;"><button type="reset"
							onclick="resetSearch()">
							<span class="icon_find">重置</span>
						</button></td>
					</td>
					<td style="padding-left: 15px;"><button type="button"
							onclick="searchHandler()">
							<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 id="pageContent" style="height:35px;"></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>