baozhangfang/WebRoot/WEB-INF/jsp/subsidiesPayable/subsidiesPayableList_export.jsp

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<jsp:include page="../../common/include.jsp" />
<% String basePath = request.getScheme()+ "://" + request.getServerName() + ":" +request.getServerPort() + request.getContextPath(); %>

<script type="text/javascript"><!--
	//人员类别
	var personTypeObj = null;

	var personType_array = null;

	/**用户显示区*/
	$(function() {
        $('#subsidiesPayableDataGrid').datagrid({
            rownumbers:true,
			fit:true,
			pageSize:20,
			pageList : [ 10, 20, 30, 40, 50 ],
			border:false,
			fitColumns:false,
			pagination:true,
			url:whzl.basePath + '/subsidiesPayableAction_listSubsidiesPayable?state=5',
			toolbar:'#searchtool',
			checkOnSelect:true,
			selectOnCheck:true,
			loadFilter:function(result){
				if(result.success){
					return result.obj;
				}else{
					$.messager.alert("提示",result.message);
    				return ;
				}							
			}
		});
		//人员类别
		$.ajax({
		    type: "post",//使用post方法访问后台
		    dataType: "json",//返回json格式的数据
		    url: "aa10Action_listAa10All",//要访问的后台地址
		    data:{"aa10.letter":"personType" ,"aa10.name":"保障人员类别" },
		    complete :function(){$("#load").hide();},//AJAX请求完成时隐藏loading提示
		    success: function(msg){//msg为返回的数据，在这里做数据绑定
		    	if(msg.success){
		    		personTypeObj = msg.obj.rows;
		    		var select_arr = [];
					var data = personTypeObj;
					for(var nItem = 0; nItem < data.length; nItem++ ){
						if(data[nItem].value!='新就业' && data[nItem].value!='外来务工' ){
							select_arr.push("<option value="+data[nItem].code+">"+data[nItem].value+"</option>");
						}
					}
					personType_array = select_arr.join("");
		    	}
		    }
		});
		
	});
	
	/**查询*/
	function searchFun(){
		$("#subsidiesPayableDataGrid").datagrid("load", {
			 "subsidiesPayable.yearAndMonth":$("#tblQuery").find("input[id='yearAndMonth']").val(),
			 "subsidiesPayable.securityPerson.name":$("#tblQuery").find("input[id='name']").val(),
             "subsidiesPayable.securityPerson.idCard":$("#tblQuery").find("input[id='idCard']").val()
        });
	}
	
	/*清除查询条件**/
    function ClearQuery() {
        $("#tblQuery").find("input").val("");
        $("#tblQuery").find("select").val("-1");
    }
	/**名称格式化*/
    var nameFormatter = function(value , row , index){
        return "<a href='javascript:' onclick=subsidiesPayableDetails('" + row.id + "','" + row.securityPerson.id + "')>"+row.securityPerson.name +"</a>";
    };
    /**身份证号格式化*/
    var idCardFormatter = function(value , row , index){
        return row.securityPerson.idCard;
    };
	var numFormatter = function(val,rowData,rowIndex){
        if(val!=null)
            return val.toFixed(2);
   }
	/**人员类别格式化*/
    var personTypeFormatter = function(value , row , index){
        var personType = "";
        for(var nItem = 0; nItem < personTypeObj.length; nItem++ ){
            if(personTypeObj[nItem].code == row.securityPerson.personType){
                personType = personTypeObj[nItem].value;
                break;
            }
        }
        return personType;  
    };
	
    function subsidiesPayableExport(){
    	searchFun();
    	var params = encodeURI("subsidiesPayable.securityPerson.name="+$("#tblQuery").find("input[id='name']").val()+
                 "&subsidiesPayable.securityPerson.idCard="+$("#tblQuery").find("input[id='idCard']").val()+ 
                 "&subsidiesPayable.yearAndMonth="+$("#tblQuery").find("input[id='yearAndMonth']").val()
        );
    	window.location.href =  whzl.basePath+"/subsidiesPayableAction_export?"+params;
    }
--></script>

<div class="easyui-layout" data-options="fit:true,border:false">

	<div data-options="region:'center',border:false">
		<div id="searchtool" data-options="region:'north' , border:false">
			<div class="clear"></div>
			<table id="tblQuery" style="width:100%;">
				<tr>
					<td align="right" style="width: 10%;"><span>姓名</span></td><td style="width: 10%;"><input id="name" name="securityPerson.name" type="text" style="width: 100px;"/></td>
					<td align="right" style="width: 6%;"><span>身份证号</span></td><td style="width: 10%;"><input id="idCard" name="securityPerson.idCard" type="text" style="width: 140px;"/></td>
					<td align="right" style="width: 7%;"><span>供应年月</span></td><td style="width: 18%;">
					<input type="text" id="yearAndMonth" onfocus="WdatePicker({skin:'whyGreen',dateFmt:'yyyy-MM'})" class="Wdate"/>
					</td>
					<td align="left" style="width: 39%;">
						<a href="javascript:searchFun();" class="easyui-linkbutton" data-options="iconCls:'icon-search',plain:true">查询</a>
						<a href="javascript:ClearQuery();" class="easyui-linkbutton" data-options="iconCls:'icon-emptied',plain:true">清空</a>
						<a href="javascript:subsidiesPayableExport();" class="easyui-linkbutton" data-options="iconCls:'icon-print',plain:true">导出</a>
					</td>
				</tr>
				
			</table>
			<div class="clear"></div>
		</div>
	
		<table id="subsidiesPayableDataGrid">
			<thead frozen="true">
        		<tr>
        			<th data-options="field:'id',checkbox:true,width:30">ID</th>
            		<th data-options="field:'name',sortable:true,width:55,formatter:nameFormatter">姓名</th>
            		<th data-options="field:'idCard',sortable:true,width:140,formatter:idCardFormatter">身份证号</th>
            		<th data-options="field:'bankAccount',sortable:true,width:140">银行账号</th>
        		</tr>
        	</thead>
        	<thead>  
        		<tr>
        			<th data-options="field:'yearAndMonth',align:'center',width:60">供应年月</th>
        			<th data-options="field:'subsidyMoney',align:'center',width:80,formatter:numFormatter">应发金额</th>
        			<th data-options="field:'securityNum',align:'center',width:80">保障人口数量</th>
        			<th data-options="field:'personType',align:'center',sortable:true,width:90,formatter:personTypeFormatter">人员类别</th>
            	    <th data-options="field:'accountMoney',align:'center',sortable:true,width:80,formatter:numFormatter">账户余额</th>
        		</tr>  
    		</thead>
		</table>
		
	</div>
</div>

<script type="text/javascript">
<!--
	parent.$.messager.progress('close');
//-->
</script>