<%@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>&nbsp;</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")%>&nbsp;</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>&nbsp;
					<button type="button" class="btn btn-primary width100" swlang code="SW013166" onClick="deleteMulti();">DELETE</button>&nbsp;
					<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>