<%@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="TAU701" class="com.csc.library.system.Task" scope="page" /><% 
	TAU701.setChannel(request,response);
	UIManager screen = (UIManager) TAU701.process("MultiEntry","TAU223");
	MultiLine multi = screen.getMultiLine("TFORGETCARD1");
        if(request.getParameter("__cmd") == null){
            screen.getTable("TFORGETCARD1").clearRecord();
        }
	multi.setLabelBox("check box");
	multi.goFirst();
	if(screen.getTable("TFORGETCARD1").recCount()==0){
		DbRecord rec1=screen.getTable("TFORGETCARD1").getNewRecord();
		screen.getTable("TFORGETCARD1").goRec(screen.getTable("TFORGETCARD1").recCount(),false);	
		rec1.set(screen.getTable("TFORGETCARD1").getMinorKey(),"1");
		rec1.set("COMPANYID",screen.getUProfile().get("companyid"));
		screen.getTable("TFORGETCARD1").putNewRecord(rec1);
	}
	if ((request.getParameter("__cmd")!=null)&&(request.getParameter("__cmd").equals("addChild"))){
		screen.getTable("TFORGETCARD1").goRec(screen.getTable("TFORGETCARD1").recCount(),false);	
		DbRecord rec=screen.getTable("TFORGETCARD1").getCurrentRecordManager();
		screen.getTable("TFORGETCARD1").goRec(screen.getTable("TFORGETCARD1").recCount()-1,false);	
		rec.set(screen.getTable("TFORGETCARD1").getMinorKey(),
			screen.getTable("TFORGETCARD1").getInt(screen.getTable("TFORGETCARD1").getMinorKey())+1); 
		rec.set("forget_date","");
		rec.set("forget_time","");
		rec.set("forget_type","");
		rec.set("remark","");
		rec.set("companyid",screen.getUProfile().get("companyid"));

	}
	CheckNull chk=new CheckNull();
	ThaiUtilities thatUtils = new ThaiUtilities();
	String docid= thatUtils.ASCII2Unicode(chk.chkNullString(request.getParameter("docid"),""));

	InitialEnvironment inv = new InitialEnvironment(screen.getUProfile().getDbName());
	String dbType = inv.getValue("datasource-dbtype");
%>
<html ng-app="myHR">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script src="../JS/VIEWCALENDAR.js"></script>
<script src="../JS/SCREEN.js"></script>
  <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 src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script>	
<script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script language="javascript">getTitleName();</script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script src="../JS/angular-1.3.15/angular.js"></script>
<!-- <script type='text/JavaScript' SRC='../JS/ANGULAR/SWAPLANG.js'></script> -->
<script language="JavaScript" type="text/JavaScript">
<!--

function GoSave(){
	if (chkEmpNull()) {
		confirmSave();
	}
}
function GoUpdate(){update();}
function GoDelete(){edelete();}
function GoSearch(){search();}

function deleteMulti(){
	with(document.cscform){
		bCon=confirm(MyCode[4]);
	 	if (bCon==true)	{	
			__cmd.value="DelChild";
			submit();
		}	
	}
}
// sin create 09-05-2007 11.00
function chkNextRec(lastrec) {
	var chk=true;
	for (var i=1; i<lastrec+1; i++) {
		var temObj = eval("document.cscform.__TFORGETCARD1$employeeid$"+i+".value");
		if (temObj=="")
			chk=false;
	}
	return chk;
}

function saveChild(lastrec){
	with(document.cscform){
		//if (chkNextRec(lastrec)) {
			__cmd.value="addChild";
			__ack.value="add";
			action="TAU223.jsp";
			submit();
		//}
	}
}

	
function childMulti(record){
	with(document.cscform){
		window.open(__childMulti.value+".jsp?__cmd=&__headMulti=TAU223&__gorec="+record+"&__ack=edit");
	}
}

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

//  End -->
function chkBox(checkval){
	with (document.cscform){
    	if(checkval.checked){
			checkAll();
		}else{
			decheckAll();
		}
  	}
}

function chkEmpNull(){
	with(document.cscform){
		for(i=0;i<elements.length;i++){
			if(elements[i].name.indexOf("employee")>-1) {
				if (elements[i].value=="") {
					ThaiCode[27]	= " กรุณากรอกรหัสพนักงานด้วย !!! ";
					EngCode[27]	= " Please Input EmployeeID too !!! ";
					alert(MyCode[27]);
					elements[i].focus;
					return false;
				}
			}
		}//end for
	}//end with
	return true;
}//end function

<!--
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 goHelp(helpName,inputName) {
	var helpReturn;
	if (inputName=="__employeeid" ) {
	 	helpReturn="__employeeid:employeeid,MEMPLOYEE@FULLNAME";		
	} else if (inputName.indexOf("__TFORGETCARD1$employeeid$" )>-1) {
		var id = inputName.substring(23,inputName.length);
	 	helpReturn="__TFORGETCARD1$employeeid$"+id+":employeeid,";		
	} else if (inputName.indexOf("__TFORGETCARD1$reasonid$" )>-1) {
		var id = inputName.substring(inputName.lastIndexOf("$")+1, inputName.length); 
	 	helpReturn="__TFORGETCARD1$reasonid$"+id+":reasonid,__TFORGETCARD1$remark$"+id+":tdesc";
	} 

	linkHelp_Return(helpName,helpReturn);				
} 

function refreshPage(value){  
	with(document.cscform){
		__help .value=value;
		submit();
	}
}
function initPage(){
	//var value="__fscardid#2009-0000020;__companyid#100;__employeeid#110266;"; 
	var value="<%=docid%>"; 
	if(value!=""){
		//alert(value);
		value="__fscardid#"+value+";";
		refreshPage(value);	
	}
}
 
</script>
</head>
<body   leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif','../IMAGES/BUTTON/SWAP/NEW_SWAP24.gif','../IMAGES/BUTTON/SWAP/EDIT_SWAP24.gif','../IMAGES/BUTTON/SWAP/DEL_SWAP24.gif','../IMAGES/BUTTON/SWAP/SEARCH_SWAP24.gif','../IMAGES/BUTTON/SWAP/PROCESS_SWAP24.gif','../IMAGES/BUTTON/SWAP/HELP_SWAP24.gif','../IMAGES/BUTTON/SWAP/EXIT_SWAP24.gif','../IMAGES/BUTTON/SWAP/COPY_SWAP20.gif')" >
<div class="centered">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="TAU223.jsp" ng-controller="Swaplang as sw">
 

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

<%=screen.InitialVariable()%>

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

  <input type="hidden" name="__screen" value="TAU223">
  <input type="hidden" name="__help" value="">
  <input type="hidden" name="__referPage" value="">
  <input type="hidden" name="__cmd" value="">
  <input type="hidden" name="__notNull" value='<%=screen.getRequire()%>'>
  <input name="__headMulti" type="hidden" value="TAU223">
  <input type="hidden" name="__childMulti" value="TAU223">
  <input type="hidden" name="__gorec" value="">
  <input type="hidden" name="__ack" value="">
  <input type="hidden" name="__calendar" value="">
  <script language="javascript">getInputFormatDate();</script>
  <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
  <input type="hidden" name="__type" value="1">
  <input type="hidden" name="__maxrec" value="<%=screen.getTable("TFORGETCARD1").recCount()%>">
  <input type="hidden" name="__multiTable" value="TFORGETCARD1">
  <input name="__companyid" type="hidden" value="<%=screen.getUProfile().get("companyid")%>">
  <input name="__fixCon" type="hidden" value="">
  <input type="hidden" name="__cmdchild" value="">
  <input type="hidden" name="wf_status" value="7">
  <input type="hidden" name="source" value="7">
  <input type="hidden" name="__clean" value="1">
  <script language="JavaScript" src="../JS/HOTKEY.js"></script>
  <script language="javascript"> 
	var swap = new swaplang();
	var titlename = swap.swap2String("WF8005");
    	document.write(Icons("TAU223,"+titlename));  
	</script>
  <br>
  <table cellspacing="0" cellpadding="0" class="medium">
    <tr >
      <td class="header" colspan="2" >TAU223,
       <span swlang code="WF8005">Working Time Request Form</span>
        &nbsp; </td>
    </tr>
    <tr >
      <td colspan="2">
      <table border="0" align="center" cellpadding="0" cellspacing="0" class="maxsize">
        <tr>
          <td class="blankspace" colspan="2"></td>
        </tr>
        <tr>
          <td class="columnlabel"><%=screen.getLabel("fscardid")%>&nbsp;</td>        
			<td ><%=screen.getInput("fscardid")%> <span swlang code="SW008631">Auto Run</span><!-- <script language="javascript">swapLang('Auto Run');</script> -->,&nbsp;
					<span swlang code="SW008997">Workflow ID</span>
					&nbsp;<input type="text" name="__textdoc" value="<%=screen.getDataLabel("wf_ref_doc")%>" readOnly="true" disabled></td>
        </tr>
		<%
				String cmdValue = chk.chkNullString(request.getParameter("__cmd"));
				String eID="";
				String eName=screen.getDataLabel("memployee","fullname");
				if (cmdValue.equals("addChild")||cmdValue.equals("DelChild")) {
					eID = chk.chkNullString(request.getParameter("__employeeid"));
					eName = thatUtils.ASCII2Unicode(chk.chkNullString(request.getParameter("MEMPLOYEE@FULLNAME")));
				}	 
			%>
		<tr>
          	<td class="columnlabel"><swaplang code='SW000350'></swaplang>&nbsp;</td>
			<td><%=screen.getInput("employeeid")%><input type="text" name="MEMPLOYEE@FULLNAME" value="<%=eName%>" readonly size="40">&nbsp; 
		</td>
        </tr> 
        <tr>
          <td class="blankspace" colspan="2"></td>
        </tr>
      </table>
      <table border="0" cellspacing="0" cellpadding="0" class="maxsize tablewithborder">
        <tr>
          <td colspan="2"><table width="618" align="center" cellpadding="0"  cellspacing="0" class="maxsize">
              <tr bgcolor="#999999">
                <td width="5%" class="row3"><div align="center">
                  <input type="checkbox" name="chBox" value="" onClick="chkBox(this)">                  
                </div></td>
                <td width="8%" class="row3">
                    <div align="center">
                      <span swlang code="SW001393">No.</span>
                    </div></td> 
                <td width="20%" class="row3">
                    <div align="center">
                     <span swlang code="SW000002">Date</span>
                    </div></td>
                <td width="13%" class="row3">
                    <div align="center"><span swlang code="SW008850">Time In Out</span>
                    </div></td>
                <td width="20%" class="row3">
                    <div align="center"><span swlang code="SW012767">Punch Type</span>
                    </div></td>
                <td width="31%" class="row3">
                    <div align="center">
                      <span swlang code="SW000049">Reason</span>
                    </div></td>
              </tr>
              <%
				    	int linecount=0;
						screen.getTable("TFORGETCARD1").goRec(1,false);	
						for(int i=1;!multi.eof();i++){ 
					%>
              <tr>
                <td class="forborder"><div align="center"><%=multi.getInputCheckBox()%></div></td>
                <td class="forborder"><div align="center">
                    <input name="__ttimetemp$line_no$<%=multi.getData(multi.getTable().getMinorKey())%>" type="hidden" value="<%=multi.getData(multi.getTable().getMinorKey())%>" >
                    <%=multi.getData(multi.getTable().getMinorKey())%> </div></td>
                <td class="forborder"><div align="center"><%=multi.getInput("TFORGETCARD1","forget_date")%>&nbsp;<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image15<%=i%>','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image15<%=i%>" width="20" height="20" border="0" align="absmiddle" id="Image15<%=i%>" onClick="viewCal('__TFORGETCARD1$forget_date$<%=multi.getData(multi.getTable().getMinorKey())%>')"></a></div></td>
                <td class="forborder"><div align="center"><%=multi.getInput("TFORGETCARD1","forget_time")%></div></td>
                <td class="forborder"><div align="center"><%=multi.getInput("TFORGETCARD1","forget_type")%></div></td> 
				<td class="forborder">
					<div align="center"><%=multi.getInput("TFORGETCARD1","remark")%>
						<input type="hidden" name="__TFORGETCARD1$reasonid$<%=i%>" value="<%=multi.getDataLabel("TFORGETCARD1","reasonid")%>">
						<a href="javascript:goHelp('MREASONCHANGEHELP','__TFORGETCARD1$reasonid$<%=i%>')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image23','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image22" width="20" height="20" border="0" align="absmiddle"></a>
					</div>
				</td>    
              </tr>
              <%
				    	linecount++;
						multi.next();
						}
				  	%>
            </table></td>
        </tr>
        <tr>

        <tr>
          <td  class="buttonline" colspan="7"><div align="center">
            <button type="button" class="btn btn-primary width100" swlang code="SW002185" onClick="checkAll();">Select All</button>&nbsp;
            <button type="button" class="btn btn-primary width100" swlang code="SW013164" onClick="decheckAll();">Deselect All</button>&nbsp;
            <button type="button" class="btn btn-primary width100" swlang code="SW013165" onClick="saveChild(<% out.print(linecount); %>);">Add</button>&nbsp;
            <button type="button" class="btn btn-primary width100" swlang code="SW013166" onClick="deleteMulti();">Delete</button>
          </div>
          </td>
        </tr>
        <tr>
          <td class="blankspace" colspan="2"></td>
        </tr>
		<!--<tr>
          <td align="right" colspan="2"><script language="javascript">printEditCheck('<%=screen.getDataLabel("edit_by")%>','<%=screen.getDataLabel("edit_date")%>','<%=screen.getDataLabel("edit_time")%>','<%=screen.getDataLabel("approve")%>');</script>&nbsp;&nbsp;</td>
        </tr>-->
		<%if(screen.getDataLabel("CREATE_BY")!=""){ %>
			<tr>
				<td align="right">
					<%

					String dbName = screen.getUProfile().getDbName();

					String SQL = "";
				
					if(dbType.equalsIgnoreCase("MSSQL")){ // for SQLServer
						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 { // for Oracle,PostgreSQL EditBy Tanapol.Y
						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")+"'";
					}

					String tableName = "MEMPLOYEE";
					DataSet ds = new DataSet(SQL, dbName,tableName); 
					ds.initConnection(screen.getUProfile());
					String userNameID = "";
					String EmpID = "";
					String FULLname = "";
					String Lname = "";
					while(ds.next()){
						userNameID = chk.chkNullString(ds.getString("usernameid"),"--");
						EmpID = chk.chkNullString(ds.getString("employeeid"),"--");
						FULLname = chk.chkNullString(ds.getString("fullname"),"--");
					}
					%>
					Create By : <%//=screen.getDataLabel("CREATE_BY")%> <%=userNameID%> , <%=EmpID%> , <%=FULLname%> : <%=screen.getDataLabel("CREATE_DATE")%> : <%=screen.getDataLabel("CREATE_TIME")%>
				</td>
			</tr>
		<%}%>
      </table>
      </td>
    </tr>
    <tr>
      <td class="bottom" ></td>
    </tr>
    <tr>
      <td class="bottom" ></td>
    </tr>
  </table>
  <input type="hidden" name="__helpReturn" value="">

<!----------BEGIN CSC ENDING ZONE ------------------------>

<%=screen.endJSP()%>

<!----------END CSC ENDING ZONE -------------------------->
 <script>window.setTimeout("initPage()",0)</script>
</form>
</body>
</html>