wuhb
/
oa


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237
							<%@ page contentType="text/html;charset=GBK"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<HEAD>
<TITLE>访客查询</TITLE>
<link href="${pageContext.request.contextPath }/liger/lib/ligerUI/skins/${sessionScope.css}/css/ligerui-all.css" rel="stylesheet" type="text/css" />
<script src="${pageContext.request.contextPath }/liger/lib/jquery/jquery-1.3.2.min.js" type="text/javascript"></script>
<script src="${pageContext.request.contextPath }/liger/lib/ligerUI/js/core/base.js" type="text/javascript"></script>
<script src="${pageContext.request.contextPath }/liger/lib/ligerUI/js/plugins/ligerGrid.js" type="text/javascript"></script> 
<link href="${pageContext.request.contextPath}/main.css" rel="stylesheet" type="text/css" />
<script src="${pageContext.request.contextPath}/liger/lib/ligerUI/js/ligerui.all.js" type="text/javascript"></script>
<script type="text/javascript" src="/shares/js/constant.js"></script> 
<script type="text/javascript" src="/shares/js/common.js"></script>  
<script src="${pageContext.request.contextPath }/liger/lib/ligerUI/js/plugins/ligerTab.js" type="text/javascript"></script>
<script src="${pageContext.request.contextPath }/liger/lib/ligerUI/js/plugins/ligerDrag.js" type="text/javascript"></script>
<script type="text/javascript">
var grid = null; 
var jsonObject;
$(function() {
	$("#startDate").ligerDateEditor({ showTime: true,  labelAlign: 'left', width:120,height:21});
	$("#endDate").ligerDateEditor({ showTime: true,  labelAlign: 'left', width:120,height:21});      
	$("#pageloading").hide();
	grid = $("#maingrid").ligerGrid({columns : [
						{display : '来访时间',name : 'storetime',width : 140,frozen:true},
						{display : '是否注销',name : 'flat_logout',width : 50,frozen:true,
							render :function(a,b){
								var s = a["flat_logout"];
								var a = s.indexOf("0");
								var b = s.indexOf("1");
								if(s.indexOf("0") == 0){
										return "否";
								}else if(s.indexOf("1") == 0){
										return "是";
								}
							}},
						{display : '姓名',name : 'name',width : 80,frozen:true},
						{display : '性别',name : 'sex',width : 30,frozen:true},
						/* {display : '临时卡号',name : 'borrow_type',width : 70,frozen:true}, */
						{display : '进入登记人',name : 'regUserName',width : 80,frozen:true},
						{display : '进入大门名称',name : 'gateName',width : 80,frozen:true},
						{display : '民族',name : 'people',width : 50},
						{display : '出生日期',name : 'birthday',width : 100},
						{display : '住址',name : 'address',width : 200},
						{display : '被访部门',name : 'ivoffice',width : 80},
						{display : '被访人',name : 'ivname',width : 80},
						{display : '工作单位',name : 'workingplace',width : 130},
						{display : '注销时间',name : 'logoutTime',width : 140},
						{display : '签发日期',name : 'signdate',width : 80},
						{display : '有效期至',name : 'validterm',width : 70},
						{display : '证件号码',name : 'idnumber',width : 150},
						{display : '社保编号',name : 'szCodeOne',width : 80},
						{display : '电脑号',name : 'szCodeTwo',width : 80},
						{display : '注销登记人',name : 'logoutUserName',width : 80},
						{display : '注销大门名称',name : 'logoutGateName',width : 80},
						{display : '随行人数',name : 'remaindSum',width : 50},
						{display : '联系电话',name : 'mobile',width : 100}],
			usePager : true,
			pageSize : 20,
			parms: [{name: "visitors.name", value: ""}, 
						 {name: "startDate", value: ""}, 
						 {name: "endDate", value: ""},
						 {name: "visitors.sex", value: ""},
						 {name: "visitors.reason", value: ""},
						 {name: "visitors.ivoffice", value: ""},
						 {name: "visitors.ivname", value: ""},
						 {name: "visitors.flat_logout", value: ""}],
			url : 'bdvmsBdvmsAction.do?task=bdvmsBdvmsList&time='+ new Date().getTime(),
			pageParmName : 'p', //页索引参数名，(提交给服务器)
			pagesizeParmName : 'pSize', //页记录数参数名，(提交给服务器)
			width : '99.8%',
			height : '96%',
			onError: function(){alert("数据加载失败，未连接到数据库！");}
		});
});

function searchByKword(){
	grid.set("parms", [ {
			name : "visitors.name",
			value : encodeURI($("#name").val())
		}, {
			name : "startDate",
			value : $("#startDate").val()
		}, {
			name : "endDate",
			value : $("#endDate").val()
		}, {
			name : "visitors.sex",
			value : $("#sex").val()
		}, {
			name : "visitors.reason",
			value : encodeURI($("#reason").val())
		}, {
			name : "visitors.ivoffice",
			value : encodeURI($("#ivoffice").val())
		}, {
			name : "visitors.ivname",
			value : encodeURI($("#ivname").val())
		}, {
			name : "visitors.flat_logout",
			value : $("#flat_logout").val()
		}]);
	grid.set("newPage", "1");
	grid.loadData(true);
}

function searchAll() {
	$("#name").val("");
	$("#startDate").val("");
	$("#endDate").val("");
	$("#sex").val("");
	$("#reason").val("");
	$("#ivoffice").val("");
	$("#ivname").val("");
	$("#flat_logout").val("");
	searchByKword();
}

var initDialog;
function advancedQuery(){
		$.ligerDialog.open({
			title : '高级查询',
			width : 500,
			height : 175,
			url : 'bdvmsBdvmsAction.do?task=toAdvancedQuery',
			buttons : [ {text : '查询',onclick : f_importOK}, {text : '取消',onclick : f_importCancel}]
		}); 
}
//取消选择
function f_importCancel(item, dialog){ 
    dialog.close();
}

function f_importOK(item, dialog){
	var sex = dialog.frame.sex(); 
	if (sex != "" && typeof (sex) != "undefined") {
		$("#sex").val(sex);
	}
	var reason = dialog.frame.reason(); 
	if (reason != "" && typeof (reason) != "undefined") {
		$("#reason").val(reason);
	}
	var ivoffice = dialog.frame.ivoffice(); 
	if (ivoffice != "" && typeof (ivoffice) != "undefined") {
		$("#ivoffice").val(ivoffice);
	}
	var ivname = dialog.frame.ivname(); 
	if (ivname != "" && typeof (ivname) != "undefined") {
		$("#ivname").val(ivname);
	}
	var flat_logout = dialog.frame.flat_logout(); 
	if (flat_logout != "" && typeof (flat_logout) != "undefined") {
		$("#flat_logout").val(flat_logout);
	}
	searchByKword();//搜索
	dialog.close();
}

//导出来访数据excel
function deriveExcel(){
	$("#report").submit();
}

</script>
<style type="text/css">
body {
	padding: 5px;
	margin: 0;
}

#layout1 {
	width: 100%;
	margin: 0;
	padding: 0;
}

.l-button {
	margin-left: 1px;
	width:100px;
}

#deptBtn {
	width: 100%;
	background: #e5ecf9;
	text-align: center;
	height: 25px;
	padding-top: 3px
}

.l-layout-left {
	overflow-y: auto;
}
</style>
</HEAD>
<BODY>
	<%@ include file="/include/button.jsp"%>
	<%@ include file="/include/message.jsp"%>
<form id="report" action="bdvmsBdvmsAction.do" method="post" target="_blank">
	<input type="hidden" id="task" name="task" value="deriveExcel">
	<div class="container">
		<div class="default_search" style="margin: 0;">
			<ul class="list_search">
				<li class="title">访客姓名：</li>
				<li class="text"><input type="text" name="visitors.name" id="name" value=""/></li>
			</ul>
			<ul class="list_search" style="width:450px;">
				<li class="title">访客时间：</li>
				<li class="text">
					<input type="text" id="startDate" name="startDate" style="width: 130px;">
				</li>
				<li class="title" style="width:10px; text-align: center; padding-left: 0px; padding-right: 3px;">
					至
				</li>
				<li class="text">
					<input type="text" id="endDate" name="endDate" style="width: 130px;">
				</li>
			</ul>
			<ul>
				<li class="search-button" style="width:350px;">
					<input type="button" class='l-button' name="search" onclick="searchByKword()" value="查询"/>
					<input type="button" class='l-button' name="search" onclick="searchAll()" value="查询全部"/>
					<input type="button" class='l-button' name="search" onclick="advancedQuery()" value="高级查询"/>
					<input type="button" class='l-button' name="search" onclick="deriveExcel()" value="导出Excel"/>
					<input type="hidden"  name="sex" id="sex" value=""/>
					<input type="hidden"  name="reason" id="reason" value=""/>
					<input type="hidden"  name="ivoffice" id="ivoffice" value=""/>
					<input type="hidden"  name="ivname" id="ivname" value=""/>
					<input type="hidden"  name="flat_logout" id="flat_logout" value=""/>
				</li>
			</ul>
		</div>
		<div id="maingrid" style="margin: 0; padding: 0;clear: both;"></div>
		<div style="display: none;">
		</div>
	</div>
	</form>
</BODY>
</HTML>