<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.report.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*"  %>
<jsp:useBean id="SM1005" class="com.csc.library.system.Task" scope="page" />
<jsp:useBean id="SM1005SAVE" class="com.csc.library.system.Task" scope="page" />
<%
	/*
	for sqlserver
	DATEDIFF(DAY, CAST(PWDCREATE AS DATETIME),GETDATE())>90
	update MUSER set PWDCREATE=null  where ISDATE(PWDCREATE)=0
	*/
	
	SM1005.setChannel(request, response);
	UIManager screen = (UIManager) SM1005.process("SingleEntry","SM1005SAVE");

	SM1005SAVE.setChannel(request, response);
	HelpEntry screen1 = (HelpEntry) SM1005SAVE.process("HelpEntry","SM1005");
	screen1.setMaxLine(10);
	String filter="(attemp>='3' or (status='0' or status is null))";
	
	UProfile up=screen.getUProfile();
	String pwdlimit=up.get("ispwdlimit");
	if(pwdlimit.equals("1")){
		if(screen1.getUProfile().getDbType().equalsIgnoreCase("PGSQL")){
			filter+=" or (DATE_PART('day', now()- CASE when pwdcreate is not null and pwdcreate !='' THEN CAST(pwdcreate as TIMESTAMP) else now() END )>"+StaticConfig.getConfigCompany(up,"SM1002")+" and pwdstatus='1') ";
		}else{
			filter+=" or (DATEDIFF(DAY, CAST(PWDCREATE AS DATETIME),GETDATE())>"+StaticConfig.getConfigCompany(up,"SM1002")+" and pwdstatus='1')";
		}
	}
	screen1.getInquiry().setFilter("("+filter+")");
	CheckNull chk=new CheckNull();
	ThaiUtilities thai = new ThaiUtilities();
	String gopage=chk.chkNullString(request.getParameter("__goPage"),"+1");	
	String fixcon =chk.chkNullString(request.getParameter("__fixCon"));
	//out.println("filter="+filter+" "+fixcon);
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
<link href="../CSS/MENU.css" rel="stylesheet" type="text/css">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script language='javascript' src="../JS/VIEWCALENDAR.js"></script>
<script  language="JavaScript" src="../JS/SCREEN.js"></script>
<script type='text/javascript' src="../JS/ICONSMENU.js"></script>
<script language='javascript' src="../JS/HOTKEY.js"></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
<!--

	ThaiCode[220]="ต้องการคืนสถานะ users หรือไม่?";
	EngCode[220]="Do you want set Active ?";

	ThaiCode[221]="ต้องการลบ users หรือไม่?";
	EngCode[221]="Do you want delete users ?";


function GoSearch()
{
	document.cscform.__goPage.value="+1";	
	search();						
}

function addPosfix(filter){
	if(filter.length>0)
	     filter+=" and "
     return filter;
}

function goHelp(helpName,inputName){
	var helpReturn;
		 if(inputName=="__employeeid" )
		 	helpReturn="__employeeid:EMPLOYEEID,__fullname:fullname";
		else 		if(inputName=="__asset1" || inputName=="__asset2" )
		 	helpReturn=inputName+":assetid,"+inputName+"desc:tdesc";
		else 		if(inputName=="__astype1" || inputName=="__astype2" )
		 	helpReturn=inputName+":astypeid,"+inputName+"desc:tdesc";
	     linkHelp_Return(helpName,helpReturn);
}

function beforeSave(){
		with(document.cscform){
		__statuslist.value="";
		if(checkLength(__delprocess)){
				for(var v=0;v<__delprocess.length;v++){
					if(__delprocess[v].checked){
								__statuslist.value+=__delprocess[v].value+",";
						}
				}
			}else{
					if(__delprocess.checked)		
						__statuslist.value+=__delprocess.value+",";
			}	
		}
}

function goHelp1(helpName,inputName,listName){
	var helpReturn;
	var key;
	var tdesc="empid",edesc="";
	if (inputName=="__usernameList" ) {
		helpReturn="usernameid";
		key="usernameid";
	}
	 with(document.cscform){
		if (__fixCon.value!="") 
			__fixCon.value=__fixCon.value;
		var param="PRU085.jsp?__helpName="+helpName+"&__helpReturn="+helpReturn
		+"&__pageCall="+__screen.value+"&__fixCon="+__fixCon.value+"&__checkVerify=off"		
		+"&__listName="+listName+"&__key="+key+"&__tdesc="+tdesc+"&__edesc="+edesc;
		window.open(param,"Help","left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
		}	
}


function checkAll(){
		with(document.cscform){
			for(i=0;i<elements.length;i++){
					if(elements[i].type=="checkbox" )
							elements[i].checked=true;
			}//end for
		}//end with
	}//end function

	function decheckAll(){
		with(document.cscform){
			for(i=0;i<elements.length;i++){
					if(elements[i].type=="checkbox" )
							elements[i].checked=false;
			}//end for
		}//end with
	}//end function

function setValue(){
		with(document.cscform){
			__userlist.value="";
			for(i=0;i<elements.length;i++){
					if(elements[i].type=="checkbox" && elements[i].checked){
								__userlist.value+=elements[i].value+",";							
				}
			}//end for
		}//end with
	}//end function

function GoReturn(){
		setValue();
		with(document.cscform){
				var bcon=confirm(MyCode[220]);
				if(bcon){
					__process.value="return";
					__cmd.value="save";
					__confirm.value="s";
					submit();
				}				
		}
}

function GoDel(){
		setValue();
		with(document.cscform){
				var bcon=confirm(MyCode[221]);
				if(bcon){
					__process.value="delete";
					__cmd.value="save";
					__confirm.value="s";
					submit();
				}				
		}
}

//-->
</script>

<style type="text/css">
<!--
.style1 {color: #FF0000}
.layout {
	width: 100px;
	table-layout: fixed;
}

span.label1{
	 color:#FFFFFF;	
	background-color:#FF0000;
	position:absolute;
	left:90%;
	top:0px;
}  

}

-->
</style>
</head>
<body >
<div id="disabledZone" style="position:absolute; left:92%;top:0px;visibility: hidden"><span id="messageZone" class="label1"></span></div>
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post">
 

<!----------BEGIN CSC INITIAL ZONE ------------------------>

<%=screen.InitialVariable()%>

<!----------END CSC INITIAL ZONE -------------------------->

<input type="hidden" name="__calendar">
   <input type="hidden" name="__screen" value="SM1005SAVE">
	<input type="hidden" name="__cmd" value="">
	<input type="hidden" name="__help" value="">
	<input type="hidden" name="__goPage" value="<%=gopage%>">
	  <input name="__notNull" type="hidden" value="<%//=screen.getRequire()%>">
	<input type="hidden" name="__helpReturn" value="">
	<input type="hidden" name="__helpName" value="">
	<input type="hidden" name="__pageCall" value="">
	<input type="hidden" name="__referPage" value="">
	<input name="__language" type="hidden" value="<%=screen.getUProfile().get("lang")%>">
	<input type="hidden" name="__lockPage" value="">
	<input name="__fixCon" type="hidden" value="<%//=SM1005.getValue("__fixCon")%>">
	<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
  	<input type="hidden" name="__company"  value="<%=screen.getUProfile().get("companyid")%>">
	<input type="hidden" name="__confirm" value="">
	<input type="hidden" name="__userlist">
	<input type="hidden" name="__process">
	<input type="hidden" name="__usernameid" value="none">
	<input type="hidden" name="__empid" value="none">
	<input type="hidden" name="__genpwd" value="1">
	<input type="hidden" name="__sendpwd" value="1">	
	<input type="hidden" name="__fixpwdstatus" value="1">	
  <script language="JavaScript" src="./JS/HOTKEY.js"></script>
          <script language="javascript">
	 var titlename=swap2String('User no active');
	 </script>
  <br>
    <table cellpadding="0" cellspacing="0" class="inframe">
      <tr >
        <td colspan="2" class="header" >SM1005, 
          <script language="javascript">swapLang(titlename);</script>&nbsp;</td>
      </tr>
      <tr >
        <td >
		<table  border="0" align="center" cellpadding="0" cellspacing="1" class="inframe">
          <tr>
            <td >
			<table width="638" border="0" align="center" cellpadding="0" cellspacing="1" class="inframe">
                <tr>
                  <td class="columnlabel"><script language="javascript">swapLang('Order By');</script></td>
                  <td width="1024"><%=screen1.getTagOrder()%></td>
              </tr>
                <tr>
                  <td width="165" class="columnlabel"><script language="javascript">swapLang('Search By');</script></td>
                  <td><%=screen1.getTagSearchBy()%></td>
                </tr>
                <tr class="maxsize">
                  <td  class="columnlabel"><script language="javascript">swapLang('Condition');</script></td>
                  <td><%=screen1.getTagConSearch()%></td>
                </tr>
                <tr class="maxsize">
                  <td  class="columnlabel"><script language="javascript">swapLang('Key Value');</script></td>
                  <td><%=screen1.getTagValueSearch()%></td>
                </tr>
                <tr>
                  <td class="columnlabel">&nbsp;</td>
                  <td><a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif"  border="0"></a></td>
                </tr>
				<%
        	screen1.process();		
				%>
                <tr>
                  <td class="columnlabel">&nbsp;</td>
                  <td align="right"><%=screen1.getPageTag()%></td>
                </tr>
              </table>			</td>
			</tr>
          <tr>
            <td >
<table border="0" align="center" cellpadding="0" cellspacing="1"class="inframe">
                  <tr class="title1">
                    <td width="3%"  class="title1"><div align="center">
                        <script language="javascript">swapLang('Select');</script>
                    </div></td>
                    <td  width="12%"  class="title1"><div align="center"><%=screen1.getLabel("usernameid")%></div></td>
                    <td  width="25%"  class="title1"><div align="center"><script language="javascript">swapLang('Name-Surname');</script></div></td>
                    <td  width="16%"  class="title1"><div align="center"><%=screen1.getLabel("user_level")%></div></td>
                    <td  width="12%"  class="title1"><div align="center"><%=screen1.getLabel("status")%></div></div></td>
                    <td  width="15%"  class="title1"><div align="center"><%=screen1.getLabel("attemp")%></div></td>
                    <td  width="17%"  class="title1"><div align="center"><%=screen1.getLabel("lstupdate")%></div></td>
              </tr>
				  <%
				  String cls="";
				  int i=0;
				  		while(screen1.nextRec()){
						cls="";
									if(screen1.checkLinePage()){
									if(i%2==0) cls="class='writeback' ";
									i++;
				  %>
                  <tr >
                    <td <%=cls%> width="3%" ><input type="checkbox" value="<%=screen1.getString("usernameid")%>#<%=screen1.getString("memployee","email")%>"></td>
                    <td <%=cls%> width="12%"><%=screen1.getString("usernameid")%></td>
                    <td <%=cls%> width="25%"><%=screen1.getString("memployee","fullname")%></td>
                    <td <%=cls%> width="16%" style="text-align:center;"><%=screen1.getString("muser_level","tdesc")%></td>
                    <td <%=cls%> width="12%" style="text-align:center;"><%=screen1.getInquiry().getCurrentDbRecord().getSystemCode("status")%></div></td>
                    <td <%=cls%> width="15%" style="text-align:center;"><%=screen1.getString("attemp")%></td>
                    <td <%=cls%> width="17%"><%=screen1.getString("lstupdate")%></td>
                  </tr>
				  <%
				  }
				 if(screen1.outLinePage()){ break; }
				  }
				  
				  %>
                  </table>			</td>
			</tr>
          <tr>
            <td align="center">
		      <a href="javascript:checkAll()"><br>
		      <img src="../IMAGES/BUTTON/SELECTALL.gif" width="73" height="23" border="0"></a><a href="javascript:decheckAll();"><img src="../IMAGES/BUTTON/DESELECTALL.gif" width="73" height="23" border="0"></a><a href="javascript:GoReturn();"><img src="../IMAGES/BUTTON/RETURN.gif" width="73" height="23" border="0"></a><a href="javascript:GoDel()"><img src="../IMAGES/BUTTON/DELETE.gif" width="73" height="23" border="0"></a><br>			</td>
          </tr>
          <tr>
            <td  class="bottom" ></td>
          </tr>
        </table>
		<!--/td>
      </tr>
    </table-->
</form>
</body>
</html>