<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%> <%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %> <jsp:useBean id="ZK_DEVICE" class="com.csc.library.system.Task" scope="page" /> <% ZK_DEVICE.setChannel(request,response); UIManager screen = (UIManager) ZK_DEVICE.process("MultiEntry","ZK_DEVICE"); String cmd = request.getParameter("__cmd") ; if(cmd == null || cmd.equals("")){ screen.getRecord().set("companyid","100"); screen.getRecord().search(); } screen.referLangOn(); MultiLine multi = screen.getMultiLine("MFPDEVICE1"); multi.setLabelBox("check box"); String idkey =""; if (cmd != null && cmd.equals("addChild")) { screen.getTable("MFPDEVICE1").goRec(screen.getTable("MFPDEVICE1").recCount(),false); DbRecord rec = screen.getTable("MFPDEVICE1").getCurrentRecordManager(); screen.getTable("MFPDEVICE1").goRec(screen.getTable("MFPDEVICE1").recCount()-1,false); rec.set(screen.getTable("MFPDEVICE1").getMinorKey(),screen.getTable("MFPDEVICE1").getInt(screen.getTable("MFPDEVICE1").getMinorKey())+1); rec.set("COMPANYID",screen.getUProfile().get("companyid")); /*rec.set("DEVICE_NO",screen.getTable("MFPDEVICE1").getString("DEVICE_NO")); rec.set("SERIAL_NO",screen.getTable("MFPDEVICE1").getString("SERIAL_NO")); rec.set("FPEMPGROUP",screen.getTable("MFPDEVICE1").getString("FPEMPGROUP")); rec.set("ZONEGROUP",screen.getTable("MFPDEVICE1").getString("ZONEGROUP")); rec.set("PASSWORD",screen.getTable("MFPDEVICE1").getString("PASSWORD")); rec.set("AUTH_TYPE",screen.getTable("MFPDEVICE1").getString("AUTH_TYPE")); rec.set("INSTALLED",screen.getTable("MFPDEVICE1").getString("INSTALLED")); rec.set("LOCKINS",screen.getTable("MFPDEVICE1").getString("LOCKINS")); rec.set("IPADDRESS",screen.getTable("MFPDEVICE1").getString("IPADDRESS")); rec.set("FPMEMO",screen.getTable("MFPDEVICE1").getString("FPMEMO"));*/ }else{ } if(screen.getTable("MFPDEVICE1").recCount() == 0){ DbRecord rec1 = screen.getTable("MFPDEVICE1").getNewRecord(); screen.getTable("MFPDEVICE1").goRec(screen.getTable("MFPDEVICE1").recCount(),false); rec1.set(screen.getTable("MFPDEVICE1").getMinorKey(),"1"); rec1.set("COMPANYID",screen.getUProfile().get("companyid")); screen.getTable("MFPDEVICE1").putNewRecord(rec1); } CheckNull chk = new CheckNull(); ThaiUtilities thatUtils = new ThaiUtilities(); String lastaction = chk.chkNullString(request.getParameter("__ack")); %> <html ng-app="myHR"> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css"> <script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script> <script type='text/javascript' src="../JS/bootstrap.js"></script> <script type='text/javascript' src='../TA/JS/TA_SCREEN.js'></script> <script type='text/javascript' src='../JS/SCREEN.js'></script> <script type='text/javascript' src='../JS/DATEINPUT.js'></script> <script type='text/javascript' src='../JS/VIEWCALENDAR.js'></script> <script type='text/javascript' src='../JS/ICONSMENU.js'></script> <script type='text/javascript' src='../JS/TIMEUTIL.js'></script> <script src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script> <script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script> <script language="JavaScript" src="../JS/DateTimeDiff.js"></script> <script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script> <script language="JavaScript" type="text/JavaScript"> <!-- function hotLink(page){ window.open(page,"Help","left=150,top=150,width=700,height=300,toolbar=no,status=no,scrollbars=yes"); } function deleteMulti(){ with(document.cscform){ bCon=confirm(MyCode[4]); if (bCon==true) { __cmd.value="DelChild"; submit(); } } } function saveChild(){ with(document.cscform){ __cmd.value="addChild"; __ack.value="add"; __clean.value = "1"; action="ZK_DEVICE.jsp"; submit(); } } function childMulti(record){ with(document.cscform){ window.open(__childMulti.value+".jsp?__cmd=&__gorec="+record+ "&__ack=edit&__codeid="+window.parent.cscform.__codeid.value+ "&__companyid="+window.parent.cscform.__companyid.value); } } function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } function GoSave(){ with (document.cscform) { confirmSave(); } } function GoUpdate(){ with (document.cscform) { update(); } } function GoDelete(){ edelete(); } function GoSearch(){ search(); } function chBox(){ with (document.cscform){ if(checkval.checked){ checkAll(); }else{ decheckAll(); } } } function goHelp(helpName,inputName) { var helpReturn; var fcon = document.cscform.__fixCon.value; if (helpName=="MEMPFP_MEMBER0HELP"){ helpReturn = inputName + ":EMPGROUP"; } linkHelp_Return(helpName,helpReturn); document.cscform.__fixCon.value = fcon; }//end function goHelp function getRowLineNo(line){ var trtrans = document.getElementById("tbl_fpdevice"); var td0 = trtrans.rows[line].cells[1]; var inputname = td0.getElementsByTagName( 'input' )[0].name ; var rtn = inputname.split("$") ; return rtn[rtn.length - 1]; } function getLastRowLineNo(){ var trtrans = document.getElementById("tbl_fpdevice"); var td0 = trtrans.rows[trtrans.rows.length-1].cells[1]; var inputname = td0.getElementsByTagName( 'input' )[0].name ; var rtn = inputname.split("$") ; return rtn[rtn.length - 1]; } function getFirstRowLineNo(){ var td0 = document.getElementById("tbl_fpdevice").rows[1].cells[1]; var inputname = td0.getElementsByTagName( 'input' )[0].name ; var rtn = inputname.split("$") ; return rtn[rtn.length - 1]; } function initTransEmpDetail(){ with(document.cscform){ if(lastaction.value == "add"){ setNewRowEmpDetails(); } } } function showEmpList(device_no, device_group){ var width = screen.availWidth ; var height = screen.availHeight - 50 ; var param = "ZK_EMPLIST.jsp?__cmd=search&__device_no="+device_no+"&__device_group="+device_group; if(device_no != ''){ window.open(param,"Help","width="+width+",height="+height+",top=0,left=0,fullscreen=yes,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); }else{ var devObj = document.getElementById(""); } } function AllowEmpList(){ var width = screen.availWidth ; var height = screen.availHeight - 50 ; var param = "ZK_ALLOWEMPLIST.jsp?__cmd=search"; window.open(param,"Help","width="+width+",height="+height+",top=0,left=0,fullscreen=yes,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } //--> </script> </head> <body onload="initTransEmpDetail()"> <form name="cscform" method="post" action="ZK_DEVICE.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__calendar"> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__notNull" value='<%=screen.getRequire()%>'> <input type="hidden" name="__screen" value="ZK_DEVICE"> <input type="hidden" name="__help" value=""> <input type="hidden" name="__childMulti" value="ZK_DEVICE"> <input type="hidden" name="__gorec" value=""> <input type="hidden" name="__ack" value=""> <input type="hidden" name="__multiTable" value="MFPDEVICE1"> <input type="hidden" name="__helpReturn" value=""> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="__cmdchild" value=""> <input type="hidden" name="__wf_status" value="<%=chk.chkNullString(request.getParameter("__wf_status"))%>"> <input type="hidden" name="__fixCon" value=""> <input type="hidden" name="__autonum" value="otid, "> <input type="hidden" name="document_no" value="otid, "> <input type="hidden" name="__wfcmd" value="false"> <input type="hidden" name="__clean" value="1"> <input type="hidden" name="lastaction" value="<%=lastaction%>"> <div align="center"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <script src="../JS/HOTKEY.js"></script> </div> <div align="center"> <script language="javascript"> var swap = new swaplang(); var titlename = swap.swap2String("SW012748"); document.write(Icons("ZK_DEVICE,"+titlename)); </script> <br> <table cellpadding="0" cellspacing="0" class="maxsize"> <tr > <td class="header">ZK_DEVICE, <span swlang code="SW012748">Entry Finger Scan</span> </td> </tr> <tr > <td> <table class="maxsize " cellpadding="0" cellspacing="0" style="display:none"> <tr> <td class="blankspace"></td> </tr> <tr> <td> <table class="maxsize" border="0" cellpadding="0" cellspacing="0" bgcolor="#666666"> <tr> <td class="columnlabel"><div align="right"><%=screen.getLabel("COMPANYID")%> </div></td> </tr> <% String cmdValue = chk.chkNullString(request.getParameter("__cmd")); String causeID="", causeName=""; String workareaID="", workareaName=""; String salatypeID="", salatypeName=""; String time0ID="", time0Name=""; if (cmdValue.equals("addChild")||cmdValue.equals("DelChild")) { /* causeID = chk.chkNullString(request.getParameter("__ot_case_help")); causeName = thatUtils.ASCII2Unicode(chk.chkNullString(request.getParameter("MREASON_OT@EDESC"))); workareaID = chk.chkNullString(request.getParameter("__ot_workarea_help")); workareaName = thatUtils.ASCII2Unicode(chk.chkNullString(request.getParameter("MWORKAREA@EDESC"))); salatypeID = chk.chkNullString(request.getParameter("__ot_salatype_help")); salatypeName = thatUtils.ASCII2Unicode(chk.chkNullString(request.getParameter("MCOSTCENTER0@EDESC"))); time0ID = chk.chkNullString(request.getParameter("__ot_time0_help")); time0Name = thatUtils.ASCII2Unicode(chk.chkNullString(request.getParameter("MTIME0@EDESC")));*/ } %> </table> </td> </tr> </table> <table id="tbl_fpdevice" border="0" cellpadding="1" cellspacing="1" bgcolor="#666666" class="maxsize tablewithborder"> <tr> <td align="center" valign="middle" class="title1"> <%=multi.getInputCheckBox()%> </td> <td class="title1" ><div align="center"><%=multi.getLabel("MFPDEVICE1","DEVICE_NO")%></div></td> <td class="title1"><div align="center"><%=multi.getLabel("MFPDEVICE1","SERIAL_NO")%></div></td> <td class="title1"><div align="center"><%=multi.getLabel("MFPDEVICE1","PASSWORD")%></div></td> <td class="title1"><div align="center"><%=multi.getLabel("MFPDEVICE1","IPADDRESS")%></div></td> <td class="title1"><div align="center"><%=multi.getLabel("MFPDEVICE1","ENROLL")%></div></td> <td class="title1"><div align="center"><%=multi.getLabel("MFPDEVICE1","DEVICE_TYPE")%></div></td> <td class="title1"><div align="center"><%=multi.getLabel("MFPDEVICE1","DEVICE_GROUP")%></div></td> <td class="title1"><div align="center"><%=multi.getLabel("MFPDEVICE1","DEVICE_STATUS")%></div></td> <td class="title1"><div align="center"><span swlang code="SW012747">EMP LIST</span></div></td> </tr> <% int linecount=0; screen.getTable("MFPDEVICE1").goRec(1,false); for(int i=1;!multi.eof();i++){ %> <tr id="tblRow<%=i%>"> <td align="center" valign="middle" > <%=multi.getInputCheckBox()%> </td> <td> <div align="center"><%=multi.getInput("MFPDEVICE1","DEVICE_NO")%></div> </td> <td> <div align="center"><%=multi.getInput("MFPDEVICE1","SERIAL_NO")%></div> </td> <td> <div align="center"><%=multi.getInput("MFPDEVICE1","PASSWORD")%></div> </td> <td> <div align="center"><%=multi.getInput("MFPDEVICE1","IPADDRESS")%></div> </td> <td> <div align="center"><%=multi.getInput("MFPDEVICE1","ENROLL")%></div> </td> <td> <div align="center"><%=multi.getInput("MFPDEVICE1","DEVICE_TYPE")%></div> </td> <td> <div align="center"><%=multi.getInput("MFPDEVICE1","DEVICE_GROUP")%></div> </td> <td> <div align="center"><%=multi.getInput("MFPDEVICE1","DEVICE_STATUS")%></div> </td> <td> <div align="center"> <%if(!multi.getDataLabel("device_no").equals("")){%> <a href="javascript:showEmpList('<%=multi.getDataLabel("device_no")%>','<%=multi.getDataLabel("device_group")%>');"> <img src="../IMAGES/BUTTON/MAIN/EDIT24.gif" border="0"> </a> <%}%> </div> </td> </tr> <% multi.next(); } %> </table> </td> </tr> <tr> <td class="blankspace"></td> </tr> <tr> <td class="buttonline" colspan="7"><div align="center"> <button type="button" class="btn btn-primary width100" swlang code="SW013162" onClick="saveChild();">ADD</button> <button type="button" class="btn btn-primary width100" swlang code="SW013166" onClick="deleteMulti();">DELETE</button> <button type="button" class="btn btn-primary width100" swlang code="SW002340" onClick="AllowEmpList();">EMP TRAN LIST</button> </div> </td> </tr> <tr> <td class="blankspace"></td> </tr> <%if(screen.getDataLabel("CREATE_BY")!=""){ %> <tr> <td align="right"> <% //-----------Error Here--------------- String SQL = ""; if(screen.getUProfile().getDbType().equals("PGSQL")){ SQL = "select mus.usernameid,mem.employeeid,mp.tdesc||' '||mem.fname||' '||mem.lname as fullname from memployee mem inner join muser mus on mem.employeeid = mus.empid left join mprefix mp on mem.emp_prefix = mp.prefixid where employeeid ='"+screen.getDataLabel("CREATE_BY")+"'"; }else{ SQL = "select mus.usernameid,mem.employeeid,mp.tdesc+' '+mem.fname+' '+mem.lname as fullname from memployee mem inner join muser mus on mem.employeeid = mus.empid left join mprefix mp on mem.emp_prefix = mp.prefixid where employeeid ='"+screen.getDataLabel("CREATE_BY")+"'"; } //-----------Edit Here---------------- By Tanapol.Y ---For PostgreSQL //String SQL = "select mus.usernameid,mem.employeeid,mp.tdesc,mem.fname,mem.lname from memployee mem inner join muser mus on mem.employeeid = mus.empid left join mprefix mp on mem.emp_prefix = mp.prefixid where employeeid ='"+screen.getDataLabel("CREATE_BY")+"'"; //-------------------------------------- String dbName = screen.getUProfile().getDbName(); String tableName = "MEMPLOYEE"; String userNameID = ""; String EmpID = ""; String mprefix = ""; String Fname = ""; String Lname = ""; DataSet ds = new DataSet(SQL, dbName,tableName); try { ds.initConnection(screen.getUProfile()); while(ds.next()){ userNameID = chk.chkNullString(ds.getString("usernameid"),"--"); EmpID = chk.chkNullString(ds.getString("employeeid"),"--"); mprefix = chk.chkNullString(ds.getString("tdesc"),"--"); Fname = chk.chkNullString(ds.getString("fname"),"--"); Lname = chk.chkNullString(ds.getString("lname"),"--"); } }catch(Exception e){ ds.closeConnection(); } %> Create By : <%=userNameID%> , <%=EmpID%> , <%=mprefix+" "+Fname+" "+Lname%> : <%=screen.getDataLabel("CREATE_DATE")%> : <%=screen.getDataLabel("CREATE_TIME")%> </td> </tr> <%}%> <tr> <td class="bottom" colspan="2"></td> </tr> </table> </div> <!----------BEGIN CSC ENDING ZONE ------------------------> <%=screen.endJSP()%> <!----------END CSC ENDING ZONE --------------------------> </form> </body> </html>