LoginLog.jsp 8.46 KB
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.conn.*" %>
<%@ page import="weaver.dateformat.DateTransformer" %>

<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="xssUtil" class="weaver.filter.XssUtil" scope="page" />
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<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="/css/ecology8/request/requestTopMenu_wev8.css" type="text/css" />
<link rel="stylesheet" href="/wui/theme/ecology8/jquery/js/zDialog_e8_wev8.css" type="text/css" />
<script type="text/javascript" src="/js/dragBox/parentShowcol_wev8.js"></script>
<link rel="stylesheet" href="/css/ecology8/request/requestView_wev8.css" type="text/css" />
</head>
<%
if(!HrmUserVarify.checkUserRight("sso:ssosetting", user)){
 	response.sendRedirect("/notice/noright.jsp");
 	return;
}
String isDialog="1";
String imagefilename = "/images/hdMaintenance_wev8.gif";
String titlename = SystemEnv.getHtmlLabelName(20961,user.getLanguage());
String needfav ="1";
String needhelp ="";
String cmd = Util.null2String(request.getParameter("cmd"));
String chartType = Util.null2String(request.getParameter("chartType"));
String srid = Util.null2String(request.getParameter("srid"));

String fromdate = Util.null2String(request.getParameter("fromdate"));
String todate = Util.null2String(request.getParameter("todate"));
String dateselect =Util.fromScreen(request.getParameter("dateselect"),user.getLanguage());
if(cmd.equals("sr") && !srid.equals("1")){
	if(chartType.equals("all")){
		dateselect = "";
	}else if(chartType.equals("day")){
		dateselect = "1";
	}else if(chartType.equals("week")){
		dateselect = "2";
	}else if(chartType.equals("month")){
		dateselect = "3";
	}else if(chartType.equals("quarter")){
		dateselect = "4";
	}else if(chartType.equals("year")){
		dateselect = "5";
	}
}
if(!dateselect.equals("") && !dateselect.equals("0")&& !dateselect.equals("6")){
	fromdate = TimeUtil.getDateByOption(dateselect,"0");
	todate = TimeUtil.getDateByOption(dateselect,"1");
}

String loginid=Util.null2String(request.getParameter("loginid"));
String lastname=Util.null2String(request.getParameter("lastname"));

%>
<BODY>
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<table id="topTitle" cellpadding="0" cellspacing="0">
	<tr>
		<td></td>
		<td class="rightSearchSpan" style="text-align:right; width:500px!important">
		 
				<input type="button" value="<%=SystemEnv.getHtmlLabelName(197,user.getLanguage())%>" class="e8_btn_top" onclick="doRefresh()"/> 
	
<span id="advancedSearch" class="advancedSearch" style='display:none;'><%=SystemEnv.getHtmlLabelName(21995 ,user.getLanguage()) %></span>&nbsp;&nbsp;
			<span title="<%=SystemEnv.getHtmlLabelName(23036 ,user.getLanguage()) %>" class="cornerMenu"></span>

		</td>
	</tr>
</table>
<%
String backto = Util.null2String(request.getParameter("backto"));
if(HrmUserVarify.checkUserRight("sso:ssosetting", user)){
 
	RCMenu += "{"+SystemEnv.getHtmlLabelName(197,user.getLanguage())+",javascript:doRefresh(),_self} " ;
	RCMenuHeight += RCMenuHeightStep ;
	 
}

String id = Util.null2String(request.getParameter("id"));
rs.execute("SELECT * FROM weaver_sso_app WHERE id='"+id+"'");
rs.next();

String appid = rs.getString("appid");
String appname = Util.null2String(request.getParameter("appname"));
String err = Util.null2String(request.getParameter("err"));

String sqlwhere = "where 1=1 ";
String tableString="";
 	
	sqlwhere+=" and appid='"+appid+"'";
if(!"".equals(loginid)){	
	sqlwhere+=" and loginid='"+loginid+"'";
}
if(!"".equals(fromdate))
{
//	sqlwhere += " and createdate >= '" + fromdate + "'";
    sqlwhere += " and "+weaver.integration.util.StringUtils.getTimeSqlWhere(new RecordSet().getDBType(),"createdate","createtime")+" >= '" + new DateTransformer().getServerDateTime(fromdate+" 00:00:00") + "'";
}
if(!"".equals(todate))
{
//	sqlwhere += " and createdate <= '" + todate + "'";
    sqlwhere += " and "+weaver.integration.util.StringUtils.getTimeSqlWhere(new RecordSet().getDBType(),"createdate","createtime")+" <= '" + new DateTransformer().getServerDateTime(todate+" 23:59:59") + "'";
}

String backfields=" * " ;
 String PageConstId = "WEAVER_SSO_login_log";
String fromSql="  WEAVER_SSO_login_log "; 

tableString =  					"<table pagesize=\""+PageIdConst.getPageSize(PageIdConst.SYS_LOGLIST,user.getUID(),PageIdConst.DOC)+"\" tabletype=\"none\">"+

 		 " <sql backfields=\""+backfields+"\" sqlform=\""+fromSql+"\" sqlwhere=\""+Util.toHtmlForSplitPage(sqlwhere)+"\"  sqlorderby=\"id\"  sqlprimarykey=\"id\" sqlsortway=\"Desc\" sqlisdistinct=\"true\" />"+
         "       <head>"+
         "           <col width=\"16%\"  text=\""+SystemEnv.getHtmlLabelName(381923,user.getLanguage())+"\" column=\"appid\"   transmethod=\"weaver.weaversso.HtmlUtil.getAPPname\"    />"+
         "           <col width=\"16%\"  text=\""+SystemEnv.getHtmlLabelName(381997,user.getLanguage())+"\" column=\"appid\"    transmethod=\"weaver.weaversso.HtmlUtil.getrulename\"      />"+
          "           <col width=\"16%\"  text=\""+SystemEnv.getHtmlLabelName(674,user.getLanguage())+SystemEnv.getHtmlLabelName(83594,user.getLanguage())+"\" column=\"LoginId\"      />"+
          "           <col width=\"16%\"  text=\""+SystemEnv.getHtmlLabelName(28153,user.getLanguage())+"\" column=\"createdate\"   otherpara=\"column:createtime\" transmethod=\"weaver.splitepage.transform.SptmForCowork.combineDateTime\"    />"+
 
         "           <col width=\"16%\"  text=\""+SystemEnv.getHtmlLabelName(17484,user.getLanguage())+"\" column=\"ip\"     />"+

         "       </head>"+
         " </table>";
%>	
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>

<form  method="post" name="datalist" id="datalist" >

<div id="tabDiv" >
   <span style="font-size:14px;font-weight:bold;"><%=titlename%></span> 
</div>

<div class="cornerMenuDiv"></div>
<div class="advancedSearchDi" id="advancedSearchDi">
	<wea:layout type="4col">
		<wea:group context='<%= SystemEnv.getHtmlLabelName(20331,user.getLanguage())%>'>
			<wea:item><%=SystemEnv.getHtmlLabelName(674,user.getLanguage())+SystemEnv.getHtmlLabelName(83594,user.getLanguage())%></wea:item>
			<wea:item><input  type="text" name="loginid" value='<%=loginid%>' _noMultiLang='true' ></wea:item>
	 	<wea:item><%=SystemEnv.getHtmlLabelName(28153,user.getLanguage())%></wea:item>
				<wea:item>
					<span class="wuiDateSpan">
					    <input class=wuiDateSel type="hidden" name="fromdate" value="<%=fromdate%>">
					    <input class=wuiDateSel  type="hidden" name="todate" value="<%=todate%>">
					</span>
				</wea:item>
		</wea:group>
			<wea:group context='<%=SystemEnv.getHtmlLabelName(32940,user.getLanguage())%>' attributes="{'groupOperDisplay':'none'}">
				<wea:item attributes="{'isTableList':'true','colspan':'full'}">
					<!--================== 显示列表 ==================-->					
								<input type="hidden" name="pageId" id="pageId" value="<%= PageConstId%>"/>
					
					<wea:SplitPageTag  tableString='<%=tableString%>'  mode="run" isShowTopInfo="true"/> 
				</wea:item>
			</wea:group>
	</wea:layout>
</div>
 
</form>
 <%if("1".equals(isDialog)){ %>
 <script type="text/javascript">
 var parentWin = parent.parent.getParentWindow(parent);
			var dialog = parent.parent.getDialog(parent);
			if(!dialog){
				dialog = parent.getDialog(this);
			}
 function onBack(){
	parentWin.closeDialog();
}
 
 </script>
		<div id="zDialog_div_bottom" class="zDialog_div_bottom">
				<wea:layout type="2col">
					<wea:group context="">
						<wea:item type="toolbar">
							<input type="button" value="<%=SystemEnv.getHtmlLabelName(309,user.getLanguage())%>" id="zd_btn_cancle"  class="zd_btn_cancle" onclick="onBack();">
						</wea:item>
					</wea:group>
				</wea:layout>
			</div>
			<script type="text/javascript">
				jQuery(document).ready(function(){
					window.notExecute = true;
					resizeDialog(document);
				});
			</script>
 <%} %>
</BODY>
</HTML>
<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>
<script type="text/javascript">
 
function doRefresh(){
	$("#datalist").submit(); 
}
  
</script>
	<SCRIPT language="javascript" src="/js/datetime_wev8.js"></script>
	<SCRIPT language="javascript" src="/js/JSDateTime/WdatePicker_wev8.js"></script>