<%@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="TAU152" class="com.csc.library.system.Task" scope="page" />
<%
	TAU152.setChannel(request,response);
	UIManager screen = (UIManager) TAU152.process("MultiEntry","TAU152");
	screen.referLangOn();
	MultiLine multi = screen.getMultiLine("TOT_M_DATE1");
        if(request.getParameter("__cmd") == null){
            screen.getTable("TOT_M_DATE1").clearRecord();
        }
	multi.setLabelBox("check box");
	//multi.goFirst();
	String idkey =""; 
	if ((request.getParameter("__cmd")!=null)&&(request.getParameter("__cmd").equals("addChild"))){
		screen.getTable("TOT_M_DATE1").goRec(screen.getTable("TOT_M_DATE1").recCount(),false);	
		DbRecord rec=screen.getTable("TOT_M_DATE1").getCurrentRecordManager();
		screen.getTable("TOT_M_DATE1").goRec(screen.getTable("TOT_M_DATE1").recCount()-1,false);	
		rec.set(screen.getTable("TOT_M_DATE1").getMinorKey(),screen.getTable("TOT_M_DATE1").getInt(screen.getTable("TOT_M_DATE1").getMinorKey())+1);
		rec.set("OTID",screen.getTable("TOT_M_DATE1").getString("OTID"));
		rec.set("START_DATE",screen.getTable("TOT_M_DATE1").getString("START_DATE"));
		rec.set("END_DATE",screen.getTable("TOT_M_DATE1").getString("END_DATE"));
		rec.set("START_TIME",screen.getTable("TOT_M_DATE1").getString("START_TIME"));
		rec.set("END_TIME",screen.getTable("TOT_M_DATE1").getString("END_TIME"));
		rec.set("COMPANYID",screen.getUProfile().get("companyid"));
	}
	
	if(screen.getTable("TOT_M_DATE1").recCount()==0){
		DbRecord rec1=screen.getTable("TOT_M_DATE1").getNewRecord();
		screen.getTable("TOT_M_DATE1").goRec(screen.getTable("TOT_M_DATE1").recCount(),false);	
		rec1.set(screen.getTable("TOT_M_DATE1").getMinorKey(),"1");
		rec1.set("COMPANYID",screen.getUProfile().get("companyid"));
		screen.getTable("TOT_M_DATE1").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 language="JavaScript" src="../JS/SCREEN.js"></script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</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 language="JavaScript" src="../JS/DateTimeDiff.js"></script>
<script type='text/javascript'  src="JS/TA_SCREEN.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" 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="TAU152.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 chk_Time(){
	var count=0;
	with(document.cscform){
    	for (j=0;j<elements.length; j++){
			if(elements[j].name.indexOf("START_DATE") > -1){
				if(!isValidDate(elements[j].value)){
					count+=1;
					elements[j].focus();
					elements[j].select();
					break;
				}
			}
			if(elements[j].name.indexOf("START_TIME") > -1){
				if(!isValidTime(elements[j].value)){
					count+=1;
					elements[j].focus();
					elements[j].select();
					break;
				}
			}
			if(elements[j].name.indexOf("END_DATE") > -1){
				if(!isValidDate(elements[j].value)){
					count+=1;
					elements[j].focus();
					elements[j].select();
					break;
				}
			}
			if(elements[j].name.indexOf("END_TIME") > -1){
				if(!isValidTime(elements[j].value)){
					count+=1;
					elements[j].focus();
					elements[j].select();
					break;
				}
			}
	    }//for
		if(count>0){
			return false;
		}else{
		  	return true;
		}
	}
}

function chk_Time2(){	
	var count=0;
	var rec=0;
	var elementIdList  = new Array();
	
	with(document.cscform){
    	for (j=0;j<elements.length; j++){
			if(elements[j].name.indexOf("__TOT_M_DATE1$START_DATE$")>-1){
				//alert(elements[j].name);
				/**
				*nuiss edit 12/11/2551 
				*เก็บ elementId ไว้ใน array แทน เพราะมันอาจจะลบ item ที่ไม่ได้ เรียงลำดับออก
				*เช่น มี 2 row ลบ row 2 ออก 
				*id มันจะ เท่ากับ 1,3 ที่เหลืออยู่
				*/
				elementIdList[rec] = elements[j].name;
				rec++;
			}
		} 
			 //fields name 
			 //eval("__TOT_M_DATE1$END_DATE$"+i+".value"),
			 //eval("__TOT_M_DATE1$START_TIME$"+i+".value"),
			 //eval("__TOT_M_DATE1$END_TIME$"+i+".value"))) {
		//เอา elementIdList มาใช้
		for (i=1;i<=elementIdList.length; i++){
			//replace elementIdList[i-1] ตามชื่อ fields เลย
			//alert(elementIdList[i-1]);
			if (!datetimeDifference(eval(elementIdList[i-1]+".value"),
											eval(elementIdList[i-1].replace("START_DATE","END_DATE")+".value"),
											eval(elementIdList[i-1].replace("START_DATE","START_TIME")+".value"),
											eval(elementIdList[i-1].replace("START_DATE","END_TIME")+".value"))) {
				count+=1;
				break;
			}
		}
		
		if(count>0){
			return false;
		}else{
		  	return true;
		}
	}
	return true;
}
function beforSave(){
	with(document.cscform){
		for(i=0;i<elements.length;i++){
			if(elements[i].name.indexOf("__TOT_M_DATE0$START_DATE$")>-1){
				if(elements[i].value.indexOf("-")>-1){
			    	elements[i].value=chkDateTimeSave(elements[i].value);
				}
			}
		}
	}
}

function GoSave(){	
	with (document.cscform) {
		if(chk_Time()&&chk_Time2()){
			for(i=0;i<__docInputType.length;i++){				
					if (__docInputType[i].checked){
						if (__docInputType[i].value==0) {					
							__wf_status.value='9';
						} else if (__docInputType[i].value==1) {					
							__wf_status.value='6';
						}
				}		
			}
			confirmSave();
		}		
	}
}

function GoUpdate(){
	with (document.cscform) {
		//if(chk_Time()&&chk_Time2()){
			for(i=0;i<__docInputType.length;i++){				
					if (__docInputType[i].checked){
						if (__docInputType[i].value==0) {					
							__wf_status.value='9';
						} else if (__docInputType[i].value==1) {					
							__wf_status.value='6';		
						}
				}		
			}
			update();
		//}		
	}
 }

function GoDelete(){
	edelete();
}
 
function GoSearch(){ search(); }
 
function chBox(){
	with (document.cscform){
    	if(checkval.checked){
			checkAll();
		}else{
			decheckAll();
		}
  	}
}

function viewCal1(str){
	viewCal(str);
}

 

function goHelp(helpName,inputName) {
	var helpReturn;
	var fcon=document.cscform.__fixCon.value;
	if (inputName=="__ot_case_help" ) {
	 	helpReturn="__ot_case_help:REASON_OTID,MREASON_OT@EDESC";
	} else if (inputName=="__ot_workarea_help" ) {
	 	helpReturn="__ot_workarea_help:workareaid,MWORKAREA@EDESC";
	} else if (inputName=="__ot_salatype_help" ) {
	 	helpReturn="__ot_salatype_help:costcenterid,MCOSTCENTER0@EDESC";
	} else if (inputName=="__ot_time0_help" ) {
	 	helpReturn="__ot_time0_help:time0id,MTIME0@EDESC";
	} else if  (inputName=="__employeeid" ) {
	 	helpReturn="__employeeid:employeeid,MEMPLOYEE@FULLNAME,emp_workarea:workarea,emp_costcenter:costcenter,emp_time0:time0";
		document.cscform.__fixCon.value =" (status in('A','S','T','V')) ";
	}//end if 

	 if (inputName.indexOf("__TOT_M_DATE1$OT_CAUSE$")>-1) {
		var id = inputName.substring(inputName.length-1, inputName.length);
		if (inputName=="__TOT_M_DATE1$OT_CAUSE$"+id ) {
			helpReturn="__TOT_M_DATE1$OT_CAUSE$"+id+":reason_otid";
		} 
		linkHelp_Return(helpName,helpReturn);
	} else if (inputName.indexOf("__TOT_M_DATE1$OT_WORKAREA$")>-1) {
		var id = inputName.substring(inputName.length-1, inputName.length);
		if (inputName=="__TOT_M_DATE1$OT_WORKAREA$"+id ) {
			helpReturn="__TOT_M_DATE1$OT_WORKAREA$"+id+":workareaid";
		} 
		linkHelp_Return(helpName,helpReturn);
	} else if (inputName.indexOf("__TOT_M_DATE1$OT_SALATYPE$")>-1) {
		var id = inputName.substring(inputName.length-1, inputName.length);
		if (inputName=="__TOT_M_DATE1$OT_SALATYPE$"+id ) {
			helpReturn="__TOT_M_DATE1$OT_SALATYPE$"+id+":codeid";
		} 
		linkHelp_Return(helpName,helpReturn);
	} else if (inputName.indexOf("__TOT_M_DATE1$OT_TIME0$")>-1) {
		var id = inputName.substring(inputName.length-1, inputName.length);
		if (inputName=="__TOT_M_DATE1$OT_TIME0$"+id ) {
			helpReturn="__TOT_M_DATE1$OT_TIME0$"+id+":time0id";
		} 
		linkHelp_Return(helpName,helpReturn);
	} //end if 

	if(inputName == "__employeeid") {
		linkHelp_Return_CallFunction(helpName,helpReturn,"setRowEmpDetails");
	}else{
		linkHelp_Return(helpName,helpReturn);
	}

	document.cscform.__fixCon.value = fcon;
}//end function goHelp

function setRowEmpDetails(){
	setRowEmpDetailByIndex(getFirstRowLineNo());
	setAllRowEmpDetails();
}

function setNewRowEmpDetails(){
	setRowEmpDetailByIndex(getLastRowLineNo());
}

function setAllRowEmpDetails(){
	var trtrans = document.getElementById("tbl_ottrans");
	var line = trtrans.rows.length ;
	
	for(i=2; i < line; i++){
		setRowEmpDetailByIndex(getRowLineNo(i));
	}
}

function setRowEmpDetailByIndex(row){
	var otw = document.getElementsByName("__TOT_M_DATE1$OT_WORKAREA$" + row);
	var otc = document.getElementsByName("__TOT_M_DATE1$OT_SALATYPE$" + row);
	var ott = document.getElementsByName("__TOT_M_DATE1$OT_TIME0$" + row);

	with(document.cscform){
		if(__employeeid.value != ""){
			otw[0].value = emp_workarea.value ;
			otc[0].value = emp_costcenter.value ;
			ott[0].value = emp_time0.value ;
		}
	}
}

function getRowLineNo(line){
	var trtrans = document.getElementById("tbl_ottrans");
	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_ottrans");
	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_ottrans").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 changeData(inputName) { //v3.0
	if (inputName=='__ot_case_help') {
		for (j=0;j<document.cscform.elements.length; j++){
			if(document.cscform.elements[j].name.indexOf("__TOT_M_DATE1$OT_CAUSE$") != -1)
				document.cscform.elements[j].value = document.cscform.__ot_case_help.value;
		}
	} else if (inputName=='__ot_workarea_help') {
		for (j=0;j<document.cscform.elements.length; j++){
			if(document.cscform.elements[j].name.indexOf("__TOT_M_DATE1$OT_WORKAREA$") != -1)
				document.cscform.elements[j].value = document.cscform.__ot_workarea_help.value;
		}
	} else if (inputName=='__ot_salatype_help') {
		for (j=0;j<document.cscform.elements.length; j++){
			if(document.cscform.elements[j].name.indexOf("__TOT_M_DATE1$OT_SALATYPE$") != -1)
				document.cscform.elements[j].value = document.cscform.__ot_salatype_help.value;
		}
	} else if (inputName=='__ot_time0_help') {
		for (j=0;j<document.cscform.elements.length; j++){
			if(document.cscform.elements[j].name.indexOf("__TOT_M_DATE1$OT_TIME0$") != -1)
				document.cscform.elements[j].value = document.cscform.__ot_time0_help.value;
		}
	} 
}

function showOT(i){
	with(document.cscform){
		st = eval("__TOT_M_DATE1$START_DATE$"+i+".value");
		en = eval("__TOT_M_DATE1$END_DATE$"+i+".value");
		var param="SHOWOT.jsp?__emp="+__employeeid.value+"&start_date_ot="+st+"&end_date_ot="+en;
		//alert(param);
		window.open(param,"Help","left=150,top=150,width=600,height=400,resizable=yes,scrollbars=yes,toolbar=no,status=yes");
	}
}

function chkTotal() {
		with(document.cscform){
			for (j=0;j<elements.length; j++){
				if(elements[j].name.indexOf("__TOT_M_DATE1$TOTAL_TIME$")>-1){
					i=elements[j].name.substring(25,elements[j].name.length);				
					chkTime(eval("__TOT_M_DATE1$START_TIME$"+i));
					chkTime(eval("__TOT_M_DATE1$END_TIME$"+i));
					
					elements[j].value = timeDiff(eval("__TOT_M_DATE1$START_TIME$"+i+".value"),eval("__TOT_M_DATE1$END_TIME$"+i+".value"));
				}
			}
		}
}

/**
*Author : Nuiss
*Date : 24/08/2552
*Logic : function เดิม[gettimeDiff2] ผิดอยู่ตรง ถ้า นาที
*มันน้อยกว่า 10 มันจะไม่เติม 0 ข้างหน้าให้ เช่น
*1.06 นาที มันจะแสดง 1.6 ซึ่งผิด
*/

function timeDiff(ftime,sdtime){
	if( isValidTime(ftime)&&( isValidTime(sdtime))){
			var tPat = /^(\d{1,}).(\d{1,})$/;
            var  totalHou=0;
			var totalMinute=0;
			var totalHM;
			var mArray1=ftime.match(tPat);
			var mArray2=sdtime.match(tPat);
			
			var hr1 = parseFloat(mArray1[1])*60;
			var min1 = parseFloat(mArray1[2])+hr1;

			var hr2 = parseFloat(mArray2[1])*60;
			var min2 = parseFloat(mArray2[2])+hr2;

			if(min1>min2){
			    min1=(24*60)-min1;
			    totalMinute=min2+min1;
			}else{
				totalMinute=min2-min1;
			}//end if 

			totalHour=(totalMinute/60)+"";

			if(totalHour.indexOf(".")>-1){
				totalHour=totalHour.substring(0,totalHour.indexOf("."));
				var minuteValue = (totalMinute%60);
				var minuteStr ="";
				if(eval(minuteValue)<10){
					minuteStr ="0"+minuteValue;
				}else{
					minuteStr=minuteValue;
				}
				totalHour+="."+minuteStr;	
				totalHM=totalHour;					
			}else{
				totalHM=totalHour+".00";	
			}//end if 
            return totalHM; 
   }//end if 
}//end function

function checkConfirm(){
	var conCode="";
	var conDesc="";
	with(document.cscform){
	//	alert(__confirm.value);
	 conCode=getConfirmIndex(__confirm.value,"0");
	 conDesc=getConfirmIndex(__confirm.value,"1");
	 if(__confirm.value=="4")alert(MyCode[19]);
	 if(__confirm.value=="1" || __confirm.value=="2")alert(MyCode[18]);
	 if(__confirm.value=="-1" || __confirm.value=="-2")alert(MyCode[17]);
	 if(__confirm.value=="-21" ) alert("Old password invalid");
	  if(__confirm.value=="-11" ) {
		alert("ไม่สามารถขอโอทีตามวัน-เวลา ที่ระบุได้ \nเนื่องจากมีการขอ โอที ตามวัน-เวลาดังกล่าวไปแล้ว \nหรือ ยังไม่ได้ระบุแผนการทำงานในวันนั้นๆ");
	  }//end if
		if(conCode=="-99"){
			updateRecord();
		}
	}
}
//-->
</script>

</head>
<body onload="initTransEmpDetail()">
<form name="cscform" method="post" action="TAU152.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="TAU152_VIV">
	<input type="hidden" name="__help" value="">
	<input type="hidden" name="__childMulti" value="TAU152">
	<input type="hidden" name="__gorec" value="">
	<input type="hidden" name="__ack" value="">
	<input type="hidden" name="__multiTable" value="TOT_M_DATE1">
	<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="<%=screen.getDataLabel("wf_status")%>"-->
	<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("SW008521");
    	document.write(Icons("SWAPLANGEDIT,"+titlename)); 
	</script>
	<br>	  
  	<table cellpadding="0"  cellspacing="0" class="maxsize">		 
    <tr >
    	<td class="header">SWAPLANGEDIT,&nbsp;<span swlang code="SW008521">Entry OT Many Day</span>&nbsp;</td>
    </tr>
    <tr >
     	<td>
        	<table  class="maxsize" cellpadding="0" cellspacing="0" >
		  	<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("OTID")%>&nbsp;</div></td>
						<td><%=screen.getInput("OTID")%>&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> 
					<tr>
						<td><div align="right"><%=screen.getLabel("EMPLOYEEID")%>&nbsp;</div></td>
						<td>
							<%=screen.getInput("EMPLOYEEID")%><input type="text" name="MEMPLOYEE@FULLNAME" value="<%=screen.getDataLabel("MEMPLOYEE","FULLNAME")%>" disabled size="40">
							<input type="hidden" name="emp_workarea" value="<%=chk.chkNullString(request.getParameter("emp_workarea"))%>">
							<input type="hidden" name="emp_costcenter" value="<%=chk.chkNullString(request.getParameter("emp_costcenter"))%>">
							<input type="hidden" name="emp_time0" value="<%=chk.chkNullString(request.getParameter("emp_time0"))%>">
						</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")));
						}	
					%>
					<tr>
						<td ><div align="right"><span swlang code="SW008615">OT Cause</span>&nbsp;</div></td>
						<td>
							<input type="text" name="__ot_case_help" size="15" value="<%=causeID%>" onMouseOver="toolTip('รหัสเหตุผลและความจำเป็น')" onMouseOut="toolTip()">&nbsp;<a href="javascript:goHelp('MREASON_OTHELP','__ot_case_help')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image2" width="20" height="20" border="0" align="absmiddle"></a>
							<input type="text" name="MREASON_OT@EDESC" value="<%=causeName%>" readonly size="40" onMouseOver="toolTip('ข้อมูลเหตุผลและความจำเป็น')" onMouseOut="toolTip()">
							&nbsp;<a href="javascript:changeData('__ot_case_help');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image5','','../IMAGES/BUTTON/SWAP/COPY_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/COPY20.gif" alt="Copy All" name="Image5" width="20" height="20" border="0"></a>			</td>
					</tr>
					<tr>
						<td ><div align="right"><span swlang code="SW008675">OT Workarea</span>&nbsp;</div></td>
						<td>
							<input type="text" name="__ot_workarea_help" size="15" value="<%=workareaID%>" onMouseOver="toolTip('รหัสสถานที่ทำโอที')" onMouseOut="toolTip()">&nbsp;<a href="javascript:goHelp('MWORKAREAHELP','__ot_workarea_help')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image21','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image21" width="20" height="20" border="0" align="absmiddle"></a>
							<input type="text" name="MWORKAREA@EDESC" value="<%=workareaName%>" readonly size="40" onMouseOver="toolTip('ข้อมูลสถานที่ทำโอที')" onMouseOut="toolTip()">
							&nbsp;<a href="javascript:changeData('__ot_workarea_help');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image51','','../IMAGES/BUTTON/SWAP/COPY_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/COPY20.gif" alt="Copy All" name="Image51" width="20" height="20" border="0"></a>			</td>
					</tr>
					<tr>
						<td ><div align="right"><span swlang code="SW008676">OT Salatype</span>&nbsp;</div></td>
						<td>
							<input type="text" name="__ot_salatype_help" size="15" value="<%=salatypeID%>" onMouseOver="toolTip('รหัสงบประมาณ')" onMouseOut="toolTip()">&nbsp;<a href="javascript:goHelp('MCOSTCENTER0HELP','__ot_salatype_help')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image22','','../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>
							<input type="text" name="MCOSTCENTER0@EDESC" value="<%=salatypeName%>" readonly size="40" onMouseOver="toolTip('ข้อมูลงบประมาณ')" onMouseOut="toolTip()">
							&nbsp;<a href="javascript:changeData('__ot_salatype_help');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image52','','../IMAGES/BUTTON/SWAP/COPY_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/COPY20.gif" alt="Copy All" name="Image52" width="20" height="20" border="0"></a>			</td>
					</tr>
					<tr>
						<td ><div align="right"><span swlang code="SW008780">OT Time0</span>&nbsp;</div></td>
						<td>
							<input type="text" name="__ot_time0_help" size="15" value="<%=time0ID%>" onMouseOver="toolTip('รหัสกะ')" onMouseOut="toolTip()">&nbsp;<a href="javascript:goHelp('MTIME0HELP','__ot_time0_help')" 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>
							<input type="text" name="MTIME0@EDESC" value="<%=time0Name%>" readonly size="40" onMouseOver="toolTip('รหัสกะ')" onMouseOut="toolTip()">
							&nbsp;<a href="javascript:changeData('__ot_time0_help');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image53','','../IMAGES/BUTTON/SWAP/COPY_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/COPY20.gif" alt="Copy All" name="Image52" width="20" height="20" border="0"></a>			</td>
					</tr>
					<tr>
						<td><div align="right"><%=screen.getLabel("REMARK")%>&nbsp;</div></td>
						<td><%=screen.getInput("REMARK")%></td>
					</tr>
					<tr>              		
						<td><div align="right"><span swlang code="SW012304">Edit by</span>&nbsp;</div></td> 
              			<td>
							<% if (screen.getDataLabel ("wf_status").equalsIgnoreCase("9")) { %>
							<input name="__docInputType" type="radio" value="0" checked><span swlang code="SW000307">Employee</span>&nbsp; 
							<input name="__docInputType" type="radio" value="1"><span swlang code="SW012305">Create / Edit By HR</span> 
							<% } else { %>
							<input name="__docInputType" type="radio" value="0"><span swlang code="SW000307">Employee</span>&nbsp;
							<input name="__docInputType" type="radio" value="1" checked><span swlang code="SW012305">Create / Edit By HR</span>
							<% } %>
              			</td>    
            		</tr>
					<tr>
						<td class="blankspace" colspan="2"></td>
					</tr>
					</table>
				</td>
			</tr>            
			</table>
			
			<table id="tbl_ottrans" border="0" cellpadding="1" cellspacing="1" bgcolor="#666666" class="maxsize tablewithborder">
           	<tr>
				<td width="" align="center" valign="middle" class="title1"><input type="checkbox" name="checkval" value="all" onClick="chBox();" ></td>
				<td width="" class="title1" ><div align="center"><%=multi.getLabel("TOT_M_DATE1","START_DATE")%></div></td>
                <td width="" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","START_TIME")%></div></td>
			    <td width="" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","END_DATE")%></div></td>
			    <td width="" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","END_TIME")%></div></td>
			    <td width="" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","TOTAL_TIME")%></div></td>
				<!--td width="16%" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","STATUS")%></div></td-->
			    <td width="" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","OT_CAUSE")%></div></td>
			    <td width="" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","OT_WORKAREA")%></div></td>
			    <td width="" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","OT_SALATYPE")%></div></td>
			    <!-- <td width="6%" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","OT_TYPE")%></div></td> -->
			    <td width="" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","OT_TIME0")%></div></td>
			    <td width="" class="title1"><div align="center"><%=multi.getLabel("TOT_M_DATE1","REMARK")%></div></td>

        <!--==========remark by Nuiss 11/08/2551==========-->
				<!--td width="16%" class="title1">
					<div align="center">
						<script language="javascript">swapLang("Show OT");</script>
					</div>
				</td-->

           	</tr>
			<%
				int linecount=0;
				screen.getTable("TOT_M_DATE1").goRec(1,false);	
				for(int i=1;!multi.eof();i++){
			%>
            <tr>
				<td  align="center" valign="middle" >
					<%=multi.getInputCheckBox()%>
					<!--input type="hidden" name="__tot_m_date1$otid$<%=multi.getData(multi.getTable().getMinorKey())%>" >
					<input name="__tot_m_date1$line_no$<%=multi.getData(multi.getTable().getMinorKey())%>" type="hidden" value="<%=multi.getData(multi.getTable().getMinorKey())%>" -->
				</td>
                <td>
					<div align="center">
					<%=multi.getInput("TOT_M_DATE1","START_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('__TOT_M_DATE1$START_DATE$<%=multi.getData(multi.getTable().getMinorKey())%>')"></a></div>
				</td>
                <td> 
				 	<div align="center"><%=multi.getInput("TOT_M_DATE1","START_TIME")%></div>
				</td>
               	<td> 
					<div align="center"><%=multi.getInput("TOT_M_DATE1","END_DATE")%>&nbsp;
					<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image16<%=i%>','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image16<%=i%>" width="20" height="20" border="0" align="absmiddle" id="Image16<%=i%>" onClick="viewCal('__TOT_M_DATE1$END_DATE$<%=multi.getData(multi.getTable().getMinorKey())%>')"></a></div>
				</td>
				<td> 
					<div align="center"><%=multi.getInput("TOT_M_DATE1","END_TIME")%></div>
				</td>
				<td> 
				 	<div align="center"><%=multi.getInput("TOT_M_DATE1","TOTAL_TIME")%></div>
				</td>
				<!--td> 
				 	<div align="center"><%=multi.getInput("TOT_M_DATE1","STATUS")%></div>
				</td-->
				<td> 
					<div align="center"><%=multi.getInput("TOT_M_DATE1","OT_CAUSE")%></div>
				</td>
				<td> 
					<div align="center"><%=multi.getInput("TOT_M_DATE1","OT_WORKAREA")%></div>
				</td>
				<td> 
					<div align="center"><%=multi.getInput("TOT_M_DATE1","OT_SALATYPE")%></div>
				</td>
				<!-- <td> 
					<div align="center"><%=multi.getInput("TOT_M_DATE1","OT_TYPE")%></div>
				</td> -->
				<td> 
					<div align="center"><%=multi.getInput("TOT_M_DATE1","OT_TIME0")%></div>
				</td>
				<td> 
				 	<div align="center">
					<input name="__tot_m_date1$remark$<%=multi.getData("Tot_m_date1","line_no")%>" value="<%=multi.getData("Tot_m_date1","remark")%>" type="hidden">
					<input type="button" name="Submit" value="..." size="2" onClick="hotLink('REMARKABLE.jsp?__remark=+<%=multi.getData("Tot_m_date1","remark")%>&__remarkname=__tot_m_date1$remark$<%=multi.getData("Tot_m_date1","line_no")%>&__lang=<%=screen.getUProfile().get("lang")%>');">
					</div>
				</td>
				<!--==========remark by Nuiss 11/08/2551==========-->
				<!--td> 
				 	<div align="center">
					<a href="javascript:showOT(<%=i%>);" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image70','','../IMAGES/BUTTON/SWAP/UPOAD_SWAP20.gif',1)" onClick=""><img src="../IMAGES/BUTTON/MAIN/UPOAD20.gif" alt="Show OT" name="Image70" width="20" height="20" border="0" align="absmiddle"></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>
				</div>
				</td>
			</tr>
	<tr>
		<td class="blankspace"></td>
	</tr>
	  <%if(screen.getDataLabel("CREATE_BY")!=""){ %>
			<tr>
				<td align="right">
					<%
					//-----------Error Here---------------
					
					//String 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";
					DataSet ds = new DataSet(SQL, dbName,tableName); 
					ds.initConnection(screen.getUProfile());
					String userNameID = "";
					String EmpID = "";
					//String FullName = "";
					String mprefix = "";
					String Fname = "";
					String Lname = "";
					while(ds.next()){
						userNameID = chk.chkNullString(ds.getString("usernameid"),"--");
						EmpID = chk.chkNullString(ds.getString("employeeid"),"--");
						//FullName = chk.chkNullString(ds.getString("fullname"),"--");
						mprefix = chk.chkNullString(ds.getString("tdesc"),"--");
						Fname = chk.chkNullString(ds.getString("fname"),"--");
						Lname = chk.chkNullString(ds.getString("lname"),"--");
					}

					%>
					Create By : <%//=screen.getDataLabel("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>