<%@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>