wuhb
/
oa


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205
							<%@ include file="/include/head.jsp"%>
<%@ page contentType="text/html;charset=GBK"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<HEAD>
<TITLE>Excel导入</TITLE>
<link href="main.css" rel="stylesheet" type="text/css"></link>
<link href="./liger/lib/ligerUI/skins/${sessionScope.css}/css/ligerui-all.css"
	rel="stylesheet" type="text/css"></link>
<script type="text/javascript" src="/shares/js/jquery-1.3.2.min.js"></script>
<script src="${pageContext.request.contextPath}/liger/lib/ligerUI/js/ligerui.all.js"
	type="text/javascript"></script>
<script type="text/javascript" src="/shares/js/common.js"></script>
<script type="text/javascript" src="/shares/js/constant.js"></script>
<script type="text/javascript">
	$(function(){
		if(top.importWaitDlg)top.importWaitDlg.close();
		<c:if test="${result ne null}">
			var result = "${result}";
			if(result == "0"){
				showInfoDiv();
			}
			if(result == "-2"){
				showErrorDiv();
				//top.$.ligerDialog.error('数据验证不通过，请查询模板格式是否正确！');
			}
			
		</c:if>
	});
	function importExcel(operner){
		var rs = $.validate({name:"files",model:[{type:"require",msg:"Excel文件不能为空!"}]});
		if(!rs)return;	
		var mess = "确定要导入吗？";
		top.$.ligerDialog.confirm(mess, function (yes){ 
			if(yes){
				top.importWaitDlg = top.$.ligerDialog.waitting('正在导入中,请稍候...');
				var radioImportType = document.getElementsByName("radioImportType");
				for(var i=0;i<radioImportType.length;i++){
			     	if(radioImportType[i].checked)
			     	radioImportType = radioImportType[i].value;
			    }
				var chkNames = document.getElementsByName("chkName");
				var chkName = "";
				for(var i=0;i<chkNames.length;i++){
			     	if(chkNames[i].checked){
			     		if(chkName != ""){
			     			chkName += ",";
			     		}
			     		chkName += chkNames[i].value;
			     	}
			    }
				
				document.excelForm.action="hrImportStaffAction.do?task=excelImporthrStaffInfo&staffType=${staffType }&radioImportType="+radioImportType+"&chkName="+chkName;
				$("#excelForm").submit();
			}}
		);
	}	
	function showErrorDiv(){
		top.$.ligerDialog.open({ title:"数据验证不通过",height: 100, target : errorDiv , width: 400, slide: false, buttons: [ { text: '确定', onclick: function (item, dialog) { dialog.hidden(); } } ] });
	}
	function showInfoDiv(){
		top.$.ligerDialog.open({ title:"导入执行完毕",height: 200, target : infoDiv , width: 400, slide: false, buttons: [ { text: '确定', onclick: function (item, dialog) { dialog.hidden(); } } ] });
	}
	
	
	function chkSelect(obj){
		if(obj == '0'){
			$("input[type='checkbox'][id='chk2']").attr("checked", true);  
		}else{
			$("input[type='checkbox'][id='chk2']").attr("checked", false);  
		}
	}
	
	//复选框事件  
	//全选
	function selectAll(){  
		$("input[type='checkbox'][id='chk1']").attr("checked", true);  
	}
	 
	// 全不选
	function unAllCkb(){
		$("input[type='checkbox'][id='chk1']").attr("checked", false);  
	}
	
	//反选
	function inverseCkb(){
		$("input[type='checkbox'][id='chk1']").each(function(){
	        //此处用jq写法颇显啰嗦。体现不出JQ飘逸的感觉。
	     //$(this).attr("checked", !$(this).attr("checked"));
	    
	     //直接使用js原生代码，简单实用
	     this.checked=!this.checked;
	     });
	}
</script>
</HEAD>
<BODY>
	<%@ include file="/include/message.jsp"%>
	<div class="l-content">
		<FORM method="post" name="excelForm" id="excelForm" action="" enctype="multipart/form-data">
			<div class="forum-container"> 
				<center>
					<table border="0" cellspacing="1" cellpadding="0"  class="l-table-edit line">
						<tr>
							<td><b>Excel文件</b><font color="red">*</font>：</td>
							<td><input type="file" name="files" id="files" /></td>
							<%--<td class="l-table-edit-td"><input type="button" onclick="submitExcelForm('supplier')" class="l-button" value="导入" /></td> --%>
							<td ><a href="${pageContext.request.contextPath}/yw/hr/import/${staffType }.xls" >下载模版</a> </td>
						</tr>
						<tr>
							<td >数据导入模式：</td>
							<td>
								<input type="radio" name="radioImportType" value="0" checked="checked" onclick="chkSelect('0')"/> 新增
								<input type="radio" name="radioImportType" value="1" style="margin-left: 18px;" onclick="chkSelect('1')"/> 修改(以工号为依据)
							</td>
							<td ></td>
						</tr>
						<tr>
							<td >选择导入项：</td>
							<td>
								<a href="#" onclick="selectAll();">全选</a>
								<a href="#" style="margin-left: 18px;" onclick="unAllCkb();">全不选</a>
								<a href="#" style="margin-left: 18px;" onclick="inverseCkb();">反选</a>
							</td>
							<td ></td>
						</tr>
						<tr>
							<td colspan="3">
								<table border="0" cellspacing="0" cellpadding="0">
									<tr>
										<td><input type="checkbox" name="chkName" value="job_number" checked="checked" disabled="disabled"/> 工号</td>
										<td><input type="checkbox" id="chk2" name="chkName" value="staff_name" checked="checked" disabled="disabled"/> 员工姓名</td>
										<td><input type="checkbox" id="chk2" name="chkName" value="branch_company_name" checked="checked" disabled="disabled"/> 所属部门</td>
										<td><input type="checkbox" id="chk2" name="chkName" value="is_dimission" checked="checked" disabled="disabled"/> 员工状态</td>
										<td><input type="checkbox" id="chk2" name="chkName" value="position_name" checked="checked" disabled="disabled"/> 职务/岗位</td>
									</tr>
									<tr>
										<td><input type="checkbox" id="chk2" name="chkName" value="staff_sex" checked="checked" disabled="disabled"/> 性别</td>
										<td><input type="checkbox" id="chk2" name="chkName" value="register_time" checked="checked" disabled="disabled"/> 入司日期</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="att_user_id"/> 考勤编号</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="id_number"/> 身份证号</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="blood_type"/> 血型</td>
									</tr>
									<tr>
										<td><input type="checkbox" id="chk1" name="chkName" value="body_height"/> 身高</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="body_weight"/> 体重</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="staff_birthday"/> 出生年月</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="ethnic_group"/> 民族</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="political_landscape"/> 政治面貌</td>
									</tr>
									<tr>
										<td><input type="checkbox" id="chk1" name="chkName" value="is_party"/> 是否党员</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="marital_status"/> 婚姻状况</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="study_educational_background"/> 学历</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="study_school_name"/> 毕业院校</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="study_subject"/> 专业</td>
									</tr>
									<tr>
										<td><input type="checkbox" id="chk1" name="chkName" value="job_title"/> 职称</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="file_num" /> 档案号</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="self_phone"/> 手机号</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="_native"/> 籍贯</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="anmelden_pro"/> 户口性质</td>
									</tr>
									<tr>
										<td><input type="checkbox" id="chk1" name="chkName" value="census_address"/> 户籍地址</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="home_address"/> 家庭住址</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="agreement_time"/> 劳动合同有效期至</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="social_time"/> 社保起始日期</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="health_time"/> 医保起始日期</td>
									</tr>
									<tr>
										<td><input type="checkbox" id="chk1" name="chkName" value="fund_time"/> 住房公积金起始日期</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="contact_person"/> 联系人</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="contact_person_phone"/> 联系人电话</td>
										<td><input type="checkbox" id="chk1" name="chkName" value="shift_name"/> 班次</td>
										<td colspan="5"><input type="checkbox" id="chk1" name="chkName" value="remark"/> 备注</td>
									</tr>
								</table>
							</td>
						</tr>
					</table>
				</center>
			</div>
		</FORM>
	</div>
	<div id="errorDiv" style="display: none;">
<%--    		<div style="color: red;margin:10px 0 10px 0 ">总共有${fn:length(errList)}条数据有问题，请修复后重新导入：</div> --%>
		<c:forEach items="${errList}" var="err">
			<div style="color: red;">${err}</div>
		</c:forEach>
	</div>
	<div id="infoDiv" style="display: none;">
		<div style="margin:10px 0 10px 0 ">其中成功导入${fn:length(infoList)}条，导入失败<font color="red">${fn:length(errList)}</font>条，请整理后重新导入；</div>
		<c:forEach items="${errList}" var="err">
			<div style="color: red;">${err}</div>
		</c:forEach>
		<c:forEach items="${infoList}" var="info">
			<div style="color: green;">${info}</div>
		</c:forEach>
	</div>
</BODY>
</HTML>