<%@ page buffer="4kb" autoFlush="true" errorPage="/notice/error.jsp" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<%@ page import="weaver.file.FileUpload" %>
<%@page import="java.io.File"%>
<%@page import="weaver.weaversso.ExcelUtil"%>
<%@page import="weaver.file.FileUploadToPath"%>
<jsp:useBean id="SysMaintenanceLog" class="weaver.systeminfo.SysMaintenanceLog" scope="page" />
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<%@ taglib uri="/browserTag" prefix="brow"%>
<%
if(!HrmUserVarify.checkUserRight("SystemSetEdit:Edit", user)){
	  response.sendRedirect("/notice/noright.jsp");
	  return;
}
FileUploadToPath fu = new FileUploadToPath(request) ; 

//FileUpload fu = new FileUpload(request);
String isDialog = "1";
String backto = Util.null2String(fu.getParameter("backto"));//返回类型
 String operation = Util.fromScreen(fu.getParameter("operation"),user.getLanguage());
String appid = Util.fromScreen(fu.getParameter("operation2"),user.getLanguage());
String mapid = Util.fromScreen(fu.getParameter("operation3"),user.getLanguage());

 List result = new ArrayList();
String err="";
String tbs="";

if(operation.equals("add")){
	RecordSet.execute("select 1 from weaver_sso_app  where appid= '"+appid+"'");
	if(RecordSet.next()){
		 err="11";
	}else{
	//RecordSet.writeLog("insert into weaver_sso_app(isuse,appid,appname,allow_ip,account_rules) values('"+isuse+"','"+appid+"','"+appname+"','"+allow_ip+"','"+account_rules+"')");
	//RecordSet.executeSql("insert into weaver_sso_app(isuse,appid,appname,allow_ip,account_rules) values('"+isuse+"','"+appid+"','"+appname+"','"+allow_ip+"','"+account_rules+"')");
	}
 
}
else if(operation.equals("edit")){
	String apploginid = Util.fromScreen(fu.getParameter("apploginid"),user.getLanguage());

	rs.execute("select * from weaver_sso_user_mapping where appid='"+appid+"' and   apploginid='"+apploginid+"' and id<> '"+mapid+"'");
	if(rs.next()){
		String headerReferer = Util.null2String(request.getHeader("Referer"));

		 response.sendRedirect(headerReferer+"&message=1");
		 	return;

	}
	

	RecordSet.writeLog("update weaver_sso_user_mapping set apploginid='"+apploginid+"' where id= '"+mapid+"'");
	RecordSet.execute("update weaver_sso_user_mapping set apploginid='"+apploginid+"' where id= '"+mapid+"'");

	 
}
else if(operation.equals("delete2")){
	mapid=mapid.replace(",","','");
		RecordSet.writeLog("delete from weaver_sso_user_mapping  where id in( '"+mapid+"')");

				RecordSet.execute("delete from weaver_sso_user_mapping  where id in( '"+mapid+"')");
				
	
}
else if(operation.equals("delete")){
	mapid=mapid.replace(",","','");
		RecordSet.writeLog("delete from weaver_sso_user_mapping  where id in( '"+mapid+"')");

				RecordSet.execute("delete from weaver_sso_user_mapping  where id in( '"+mapid+"')");
				
	
}
else if(operation.equals("adduser")){
	ArrayList<Object> userinfo=new ArrayList<Object>();
	String rloginid = Util.fromScreen(fu.getParameter("loginid"),user.getLanguage());
	String rapploginid = Util.fromScreen(fu.getParameter("apploginid"),user.getLanguage());
	rs.execute("select * from weaver_sso_user_mapping where   apploginid='"+rapploginid+"'");
	if(rs.next()){
		String headerReferer = Util.null2String(request.getHeader("Referer"));

		 response.sendRedirect(headerReferer+"&message=2");
		 	return;

	}
	
	
	userinfo.add(rloginid);
	userinfo.add(rapploginid);
	 ArrayList<ArrayList<Object>> e= new 	 ArrayList<ArrayList<Object>>();
	 e.add(userinfo);
	 for(ArrayList<Object> a:e){
		 if(a.size()!=2)
			 continue;
		 String loginid=(String)a.get(0);
		 String apploginid=(String)a.get(1);
		 RecordSet.execute("select * from hrmresource where loginid='"+loginid+"' ");
		 if(RecordSet.next()){
 			String id=RecordSet.getString("id");
			 rs.execute("select * from weaver_sso_user_mapping where appid='"+appid+"' and loginid='"+loginid+"'");
			 if(rs.next()){
				 
				rs.writeLog("update weaver_sso_user_mapping set LoginId= '"+loginid+"',AppLoginId='"+apploginid+"' ,userid='"+id+"' where appid='"+appid+"' and loginid='"+loginid+"'");
				 rs.execute("update weaver_sso_user_mapping set LoginId= '"+loginid+"',AppLoginId='"+apploginid+"' ,userid='"+id+"' where appid='"+appid+"' and loginid='"+loginid+"'");

			 }else{
 				 rs.execute("select max(id ) maxid from weaver_sso_user_mapping ");
				 rs.next();
				String maxid= rs.getString("maxid");
				if("".equals(maxid)){
					maxid="1";
				}else{
					maxid=(Integer.valueOf(maxid)+1)+"";
				}
				rs.writeLog("insert into  weaver_sso_user_mapping ( appid,id,LoginId ,AppLoginId,userid) values('"+appid+"','"+maxid+"','"+loginid+"','"+apploginid+"','"+id+"') ");
				 rs.execute("insert into  weaver_sso_user_mapping (appid, id,LoginId ,AppLoginId,userid) values('"+appid+"','"+maxid+"','"+loginid+"','"+apploginid+"','"+id+"') ");

			 }
		 }
	 }
	
}else if(operation.equals("excelImport")){
 String filename=fu.uploadFiles("excelfile");

	File file =  new File(filename);// new File("C:\\Users\\Administrator\\Desktop\\统一认证开发计划.xlsx");

	 ArrayList<ArrayList<Object>> e= ExcelUtil.readExcel(  file);
	 for(int i=1;i<e.size();i++){
		 ArrayList<Object> a=e.get(i);
		 
		 if(a.size()!=2)
			 continue;
		 String loginid=(String)a.get(0);
		 String apploginid=(String)a.get(1);
		 tbs+="<tr><td>"+loginid+" </td><td>"+apploginid+" </td>";
		 RecordSet.execute("select * from hrmresource where loginid='"+loginid+"' ");
		 if(RecordSet.next()){
 			String id=RecordSet.getString("id");
			 rs.execute("select * from weaver_sso_user_mapping where appid='"+appid+"' and loginid='"+loginid+"'");
			 if(rs.next()){
				 rs.execute("select * from weaver_sso_user_mapping where appid='"+appid+"' and loginid<>'"+loginid+"' and AppLoginId='"+apploginid+"' ");
				if(!rs.next()){
				rs.writeLog("update weaver_sso_user_mapping set LoginId= '"+loginid+"',AppLoginId='"+apploginid+"' ,userid='"+id+"' where appid='"+appid+"' and loginid='"+loginid+"'");
				 rs.execute("update weaver_sso_user_mapping set LoginId= '"+loginid+"',AppLoginId='"+apploginid+"' ,userid='"+id+"' where appid='"+appid+"' and loginid='"+loginid+"'");
				 tbs+="<td>更新成功 </td>";
				}else{
					 tbs+="<td>应用账号已经存在 </td>";
					
				}
			 }else{
 				 rs.execute("select max(id ) maxid from weaver_sso_user_mapping ");
				 rs.next();
				String maxid= rs.getString("maxid");
				if("".equals(maxid)){
					maxid="1";
				}else{
					maxid=(Integer.valueOf(maxid)+1)+"";
				}
				rs.writeLog("insert into  weaver_sso_user_mapping ( appid,id,LoginId ,AppLoginId,userid) values('"+appid+"','"+maxid+"','"+loginid+"','"+apploginid+"','"+id+"') ");
				 rs.execute("insert into  weaver_sso_user_mapping (appid, id,LoginId ,AppLoginId,userid) values('"+appid+"','"+maxid+"','"+loginid+"','"+apploginid+"','"+id+"') ");
				 tbs+="<td>插入成功 </td>";
			 }
		 }else{
			 tbs+="<td>账号不存在 </td>";

		 }
		 tbs+="</tr>";
	 }
 
}
if(operation.equals("excelImport")){
	
	%>
	<HTML>
<head>

<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<SCRIPT language="javascript" src="/js/weaver_wev8.js"></script>
 <link rel="stylesheet" href="/wui/theme/ecology8/weaveredittable/css/WeaverEditTable_wev8.css">
<script  src="/wui/theme/ecology8/weaveredittable/js/WeaverEditTable_wev8.js"></script>
<script language="javascript" src="/wui/theme/ecology8/jquery/js/zDialog_wev8.js"></script>
<script language="javascript" src="/wui/theme/ecology8/jquery/js/zDrag_wev8.js"></script>
</head>
	<BODY>
 	<wea:layout>
<wea:group context='导入日志' attributes="{'samePair':'ExportInfo','groupOperDisplay':'none','itemAreaDisplay':'block'}">
		<wea:item attributes="{'colspan':'2','isTableList':'true'}">
 			<TABLE class=ListStyle cellspacing=1 >
			  <COLGROUP>
			  <COL width="20%">
			  <COL width="60%">
			  <COL width="20%">
			  </COLGROUP>
			
			  <TBODY>
			  <TR class=header>
			    <Th>OA<%=SystemEnv.getHtmlLabelName(83594,user.getLanguage())%></Th>
			    <Th><%=SystemEnv.getHtmlLabelName(25432,user.getLanguage())+SystemEnv.getHtmlLabelName(83594,user.getLanguage())%></Th>
			    <Th><%=SystemEnv.getHtmlLabelName(24960,user.getLanguage())%></Th>
			  </TR>
			
			<%=tbs	%>
			 </TBODY></TABLE>
 		</wea:item>
	</wea:group>
</wea:layout>
 	<div id="zDialog_div_bottom" class="zDialog_div_bottom">
		<input type="button" style="display:none;" class=zd_btn_submit accessKey=S  id=btnsearch value="S-<%=SystemEnv.getHtmlLabelName(197,user.getLanguage())%>"></input>
		<wea:layout needImportDefaultJsAndCss="false">
			<wea:group context=""  attributes="{'groupDisplay':'none'}">
				<wea:item type="toolbar">
					<input type="button" class=zd_btn_cancle accessKey=T  id=btncancel value="T-<%=SystemEnv.getHtmlLabelName(309,user.getLanguage())%>" onclick='onBack();'></input>
				</wea:item>
			</wea:group>
		</wea:layout>
		<script type="text/javascript">
			jQuery(document).ready(function(){
				resizeDialog(document);
			});
			function onBack(){
 	var parentWin = parent.parent.getParentWindow(parent);
	parentWin.location.href="AppDataMapingDetail.jsp?backto=<%=backto%>&err=<%=err%>&appid=<%=appid%>";
	parentWin.closeDialog();
			}
		</script>
  </div>
</BODY>
</HTML>
	<%
	
}else if("1".equals(isDialog)&&(operation.equals("delete2")||operation.equals("edit")||operation.equals("adduser"))){
%>
<script language=javascript >
try{
	//var parentWin = parent.getParentWindow(window);
	var parentWin = parent.parent.getParentWindow(parent);
	parentWin.location.href="AppDataMapingDetail.jsp?backto=<%=backto%>&err=<%=err%>&appid=<%=appid%>";
	parentWin.closeDialog();
}
catch(e){
}
</script>
<%
}
else
response.sendRedirect("AppDataMapingDetail.jsp?urlType=3&isdialog=1&backto=&appid="+appid);
%>