<%@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> </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"> </td>
<td><a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" border="0"></a></td>
</tr>
<%
screen1.process();
%>
<tr>
<td class="columnlabel"> </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>