<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.database.*"%>
<%@page import="com.csc.library.session.*"%>
<%@page import="com.csc.library.components.*"%>
<jsp:useBean id="WEL243" class="com.csc.library.system.Task" scope="page" />
<%
	WEL243.setChannel(request, response);
	HelpEntry screen = (HelpEntry) WEL243.process("HelpEntry","WEL238C");
	screen.setMaxLine(15);
	
	CheckNull chk = new CheckNull(); 
	CscCalendar csc = new CscCalendar();
	String[][] addstatus = SystemCode.getContent("ADVANCE_STATUS");
	String adno1 = chk.chkNullString(request.getParameter("__adno1"));
	String adno2 = chk.chkNullString(request.getParameter("__adno2"));
	String cleardate1 = chk.chkNullString(request.getParameter("__cleardate1"));
	String cleardate2 = chk.chkNullString(request.getParameter("__cleardate2"));
	String adstatus = chk.chkNullString(request.getParameter("__adstatus"));
	String empid1 = chk.chkNullString(request.getParameter("__empid1"));
	String empid2 = chk.chkNullString(request.getParameter("__empid2"));
	String filter = "(1=1) and (advance_type='3' and clearance_no is not null and clearance_no != '')";

//	if( !tano1.equals("")&& !tano2.equals("") ){
	if( !chk.chkNullString(request.getParameter("con_adno")).equals("")){
		filter +=" and (clearance_no between '"+adno1+"' and '"+adno2+"')";

	}

	if( !chk.chkNullString(request.getParameter("con_employeeid")).equals("")){
		filter +=" and (employeeid between '"+empid1+"' and '"+empid2+"')";

	}
//	if( !empid1.equals("")&& !empid2.equals("") ){
	//if( !chk.chkNullString(request.getParameter("con_employeeid")).equals("")){
		//filter +=" and (taid in (select taid from ttravel_aut where employeeid between '"+empid1+"' and '"+empid2+"'))" ;
	//}
//	if( !specialreq1.equals("")&& !specialreq2.equals("") ){
	if( !chk.chkNullString(request.getParameter("con_cleardate")).equals("")){
		CscCalendar reqdate1 = new CscCalendar(cleardate1);
		CscCalendar reqdate2 = new CscCalendar(cleardate2);
		//((DbInquiry)screen.getInquiry()).setFilter( "specialreq_ta", reqdate1.getYYYYMMDD(),reqdate2.getYYYYMMDD(), "between" );
		filter +=" and (clearing_date between '"+reqdate1.getYYYYMMDD()+"' and '"+reqdate2.getYYYYMMDD()+"')";
	}

	if( !chk.chkNullString(request.getParameter("con_status")).equals("")){
		//((DbInquiry)screen.getInquiry()).setFilter( "car_status", doc_status, "", "=" );
		filter +=" and (advance_status ='"+adstatus+"')";
	}

	((DbInquiry)screen.getInquiry()).setFilter(filter);
	//out.print(filter);
	screen.process();

%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script  language="JavaScript" src="../JS/SCREEN.js"></script>
<SCRIPT TYPE='text/JavaScript' SRC='../JS/MYNOTE_SCREEN.js'></SCRIPT>
<script src="../JS/VIEWCALENDAR.js"></script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language='javascript' src='./JS/SWAPLANG.js'></script>
<script language="JavaScript" type="text/JavaScript">

function GoSearch(){
	with(document.cscform){
		var tmp="", myText="";
		var conName=Array ("__adno1#__adno2","__empid1#__empid2","__cleardate1#__cleardate2","__adstatus");
		conList.value="";
		for(i=0;i<elements.length;i++){
			if(elements[i].type=="checkbox" && elements[i].id=="condition"){
				if(elements[i].checked){
					conList.value+=elements[i].value+"#";
					//if(elements[i].value!="8" && elements[i].value!="9"){//ไม่เช็คค่าฟิลด์ condition ที่เป็น select และ radio เพราะี default ค่าไว้แล้ว
						//tmp+=conName[(elements[i].value)-1]+"#";
					//}
				}
			}
		}
		//alert(tmp);
		if(!chkConditionValue(tmp)){
			if(getLang()=="tha"){
				myText = "ระบุเงื่อนไขการค้นหา";
			}else{
				myText = "Please insert condition value.";
			}
			alert(myText);
		}else{
			search();
		}
	}
}

//ตรวจสอบว่ามีการกรอกค่าในฟิลด์หรือไม่?
function chkConditionValue(obj){
	with(document.cscform){
		var check=true;
		var tmp=obj.split("#");
		for(i=0;i<tmp.length-1;i++){
			if(eval(tmp[i]).value==""){
				check=false;
			}
		}
		return check;
	}
}
	
function goHelp(helpName,inputName) {
	var helpReturn;
	var fixCon = "";
	if(inputName=="__empid1" ) {
		helpReturn="__empid1:employeeid";	
	}else if(inputName=="__empid2" ) {
		helpReturn="__empid2:employeeid";	
	}else if(inputName=="__adno1" ) {
		helpReturn="__adno1:clearance_no";	
	}else if(inputName=="__adno2" ) {
		helpReturn="__adno2:clearance_no";	
	}else if(inputName=="__agency" ) {
		fixCon="sitewelgid='AG001'";
		helpReturn="__agency:SITEWELID";	
	}	
	linkHelp_Return(helpName,helpReturn,fixCon);	
}

function GoSave(){
	alert(MyCode[150]);
}

function GoDelete(){
	alert(MyCode[150]);
}

function checkAll(){
		with(document.cscform){
			for(i=0;i<elements.length;i++){
					if(elements[i].type=="checkbox" && elements[i].name=="talist")
							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].name=="talist")
				elements[i].checked=false;				
		}//end for
	}//end with
}//end function

function goPage(page){
    with(document.cscform){
        __goPage.value=page;
        submit();
    }
}

function mailToEmployee(){
	with(document.cscform){
		alert("mail to employee");
	}
}

function mailToAgency(){
	with(document.cscform){
		alert("mail to agency");
	}
}

function reserveDetail(ta_no,employeeid,line_no,gorac){
	with(document.cscform){
		window.open("WEL243_1.jsp?__ack=edit&__cmd=search&__CLEARANCE_NO="+ta_no+"&__line_no="+line_no+"&__gorec="+gorac+
		"&__employeeid="+employeeid+"&__companyid="+__companyid.value,"","left=150,top=150,width=800,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
	}
}

/*function reserveDetail2(ta_no,employeeid,line_no,gorac){
	with(document.cscform){
		window.open("WEL243_2.jsp?__ack=edit&__cmd=search&__CLEARANCE_NO="+ta_no+"&__line_no="+line_no+"&__gorec="+gorac+
		"&__employeeid="+employeeid+"&__companyid="+__companyid.value,"","left=150,top=150,width=800,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
	}
}*/

//set ค่า checkbox เมื่อมีการ refresh หน้าจอ
function setChkbox(){
	with(document.cscform){
		var val=conList.value.split("#");
		for(i=0;i<elements.length;i++){
			if(elements[i].type=="checkbox" && elements[i].id=="condition"){
				for(j=0;j<val.length;j++){
					if(elements[i].value==val[j]){
						elements[i].checked=true;
					}
				}
			}
		}
	}
}



</script>
</head>
<%
		String helpReturn="";
		if(request.getParameter("__helpReturn")!=null){
			helpReturn=request.getParameter("__helpReturn");
		}
%>
<body leftmargin="0" topmargin="0">
<p>&nbsp;</p>
<form name="cscform" method="post" action="WEL243.jsp" >


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

<%=screen.InitialVariable()%>

<!----------END CSC INITIAL ZONE -------------------------->
	<input type="hidden" name="__cmd" value="<%//=chk.chkNullString(request.getParameter("__cmd"))%>">
	<input type="hidden" name="__help" value="">
	<input type="hidden" name="__goPage" value="">
	<input type="hidden" name="__helpReturn" value="">
	<input type="hidden" name="__helpName" value="">
	<input  type="hidden" name="__notNull" value="">
	<input type="hidden" name="__pageCall" value="">
	<input type="hidden" name="__referPage" value="">
	<input  type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
	<input type="hidden" name="__lockPage" value="">
    <input type="hidden" name="__calendar">
	<input name="__employeeid" type="hidden" value="0">
	<input name="__docno" type="hidden" value="0">
    <input type="hidden" name="__screen" value="WEL243">
    <script language="javascript">getInputFormatDate();</script>
	<input type="hidden" name="__fixCon" value="">
	<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
  	<input type="hidden" name="__companyid"  value="<%=screen.getUProfile().get("companyid")%>">
	<input type="hidden" name="conList" value="<%=chk.chkNullString(request.getParameter("conList"))%>">

 <div align="center">
 <table height="" align="center" cellpadding="0" cellspacing="0" border="0" class="large">
    <tr bgcolor="#3366CC">
      <td  height="20" class="header">WEL243, <script language="JavaScript">swapLang('Clear Abroad Trip');</script>&nbsp;</td>
  </tr> 
  <tr>             
		<td><table width="100%" border="0" cellpadding="0" cellspacing="0" class="maxsize">        
                <tr>
                  <td class="blankspace"> </td>
                </tr>
				 <tr>
				  <td width="150" align="center"><b><script language="JavaScript">swapLang('Condition');</script></b>&nbsp;</td>
                  <td class="columnlabel"><script language="JavaScript">swapLang('Order By');</script>&nbsp;</td>
                  <td><%=screen.getTagOrder()%></td>
                </tr>
                <tr>
				  <td align="center"><input type="checkbox" id="condition" name="con_adno" value="1">&nbsp;</td>
                  <td class="columnlabel"><%=screen.getLabel("CLEARANCE_NO")%>&nbsp;</td>
                  <td>
                    <input name="__adno1" type="text" size="15" value="<%=adno1%>">
                    <a href="javascript:goHelp('CLEARANCE0HELP','__adno1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image3" width="20"  border="0" align="absmiddle"></a> -
                    <input name="__adno2" type="text" size="15" value="<%=adno2%>">
                    <a href="javascript:goHelp('CLEARANCE0HELP','__adno2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image31','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image31" width="20"  border="0" align="absmiddle" id="Image31"></a></td>
                </tr>
				<tr>
				  <td align="center"><input type="checkbox" id="condition" name="con_employeeid" value="2">&nbsp;</td>
                  <td class="columnlabel"><%=screen.getLabel("EMPLOYEEID")%>&nbsp;</td>
                  <td>
                    <input name="__empid1" type="text" size="15" value="<%=empid1%>">
                    <a href="javascript:goHelp('MEMPLOYEEHELP','__empid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image6','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image3" width="20"  border="0" align="absmiddle"></a> -
                    <input name="__empid2" type="text" size="15" value="<%=empid2%>">
                    <a href="javascript:goHelp('MEMPLOYEEHELP','__empid2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image61','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image31" width="20"  border="0" align="absmiddle" id="Image31"></a></td>
                </tr>
				<tr>
				  <td align="center"><input type="checkbox" id="condition" name="con_cleardate" value="3">&nbsp;</td>
                  <td class="columnlabel"><%=screen.getLabel("CLEARING_DATE")%>&nbsp;</td>
                  <td>
                    <input name="__cleardate1" type="text" size="15"  maxlength="10" value="<%=cleardate1%>" onKeyPress="chkInteger()" onKeyUp="formatDate(this)" onBlur="chkInputDate2(this,__cleardate2)" />
					<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image12','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image12" width="20"  border="0" align="absmiddle" id="Image12" onClick="viewCal('__cleardate1')" /></a> -
					<input name="__cleardate2" type="text" size="15" maxlength="10" value="<%=cleardate2%>" onKeyPress="chkInteger()" onKeyUp="formatDate(this)" onBlur="chkInputDate2(__cleardate1,this)" />
					<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image121','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image121" width="20"  border="0" align="absmiddle" id="Image12" onClick="viewCal('__cleardate2')" /></a>&nbsp;&nbsp;</td>
                </tr>
				
				<tr>
				  <td align="center"><input type="checkbox" id="condition" name="con_status" value="4">&nbsp;</td>
                  <td class="columnlabel"><%=screen.getLabel("ADVANCE_STATUS")%>&nbsp;</td>
                  <td>
				  <select name="__adstatus" onChange="setFilter()">
				<%
					for(int i=0;i<addstatus.length;i++){
				%>					
						<option value="<%=addstatus[i][0]%>"><%=addstatus[i][1].substring(addstatus[i][1].indexOf(",") + 1)%></option>
				<%				
					}
				%>                                 
                  </select></td>
                </tr> 
				<tr> 
				  <td class="blankspace" ></td>
				</tr>
                <tr>
                  <td colspan="3" align="center">
                    <a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif"  border="0"></a></td>
                </tr>
				<tr> 
				  <td class="blankspace" ></td>
				</tr>
				<tr> 
				  <td colspan="3"><div align="right"><%=screen.getPageTag()%></div></td>
				</tr>
			  </table>
		</td>
	</tr>
	<tr>
		<td  colspan="3"> 
		  <table height="" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="inframe" >
				<tr bgcolor="#3366CC">
                    <td class="title1"><div align="center"><script language="JavaScript">swapLang('Order by');</script></div></td>
                    <td class="title1"><div align="center"><script language="JavaScript">swapLang('Clearance');</script></div></td>
					<td class="title1"><div align="center"><script language="JavaScript">swapLang('Employee ID');</script></div></td>
					<td class="title1"><div align="center"><script language="JavaScript">swapLang('Name');</script></div></td>
					<td class="title1"><div align="center"><script language="JavaScript">swapLang('Approve Date');</script></div></td>
					<td class="title1"><div align="center"><script language="JavaScript">swapLang('Destination');</script></div></td>
					<td class="title1"><div align="center"><script language="JavaScript">swapLang('Amount');</script></div></td>
					<td class="title1"><div align="center"><script language="JavaScript">swapLang('Status');</script></div></td>
					<td class="title1"><div align="center"><script language="JavaScript">swapLang('Tranfer Date');</script></div></td>
                </tr>
		 
		   <% 
				int i = 1;
				Double sumLenge=0.00;
				String lenge="";
		   		while(screen.nextRec()){ 
					if(screen.checkLinePage()){
						screen.referLangOn();
						lenge = chk.chkNullString(screen.getString("car_length"),"0.00");
					
						while(lenge.indexOf(",")>0){
							lenge = lenge.replace(",","");
						}
						
						sumLenge=sumLenge+(Double.parseDouble(lenge));
						
					
				
			   %>
			   
			  <tr>   
				<td nowrap  class="forborder2"><div align="center"><input type="checkbox" name="talist" value=""></div></td>
				<td nowrap  class="forborder2">
				<div align="center"><a href="javaScript:reserveDetail('<%=screen.getString("CLEARANCE_NO")%>',
				'<%=screen.getString("EMPLOYEEID")%>','<%=i%>','<%=screen.getString("LINE_NO")%>')">
				<%=screen.getString("CLEARANCE_NO")%></a></td>
				<td nowrap  class="forborder2"><div align="center"><%=chk.chkNullString(screen.getString("EMPLOYEEID"),"-")%></div></td>
				<td nowrap  class="forborder2"><div align="center"><%=chk.chkNullString(screen.getDataLabel("MEMPLOYEE","FULLNAME"),"-")%></div></td>
				<td nowrap  class="forborder2"><div align="center"><%=chk.chkNullString(screen.getString("APPROVE_DATE"),"-")%></div></td>
				<td nowrap  class="forborder2"><div align="center"><%=chk.chkNullString(screen.getString("CLEARANCE1","DESTINATION"),"-")%></div></td>
				<td nowrap  class="forborder2"><div align="center"><%=chk.chkNullString(screen.getString("ALL_AMOUNT"),"0.00")%></div></td>
				<td nowrap  class="forborder2"><div align="center"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("ADVANCE_STATUS")%></div></td>
				<td nowrap  class="forborder2"><div align="center"><%=chk.chkNullString(screen.getString("TRANFER_DATE"),"-")%></div></td>
		    </tr>
		   <%
					i++;
					screen.referLangOff();   
				 }
				 //if(screen.outLinePage()){ break; }
				 }%>
			<!--tr> 
				<%
					String sTotal="",temp1="",temp2="",aString="";
					int comma=0;
					aString = sumLenge.toString();
					temp1 = aString.substring(0,(aString.indexOf(".")));
					temp2 = aString.substring((aString.indexOf("."))+1,(aString.length()));
					if(temp2.length()<2){
						temp2 += "0";
					}
						for(int j=temp1.length();j>0;j--){
							if(comma==3){
								sTotal = temp1.substring(j-1,j)+ "," + sTotal;
								comma=1;
							}else{
								sTotal = temp1.substring(j-1,j) + sTotal;
								comma++;
							}
						}
					sTotal += "."+temp2;
				%>
				<td nowrap  class="forborder2" colspan="12"><div align="right"><b><script language="JavaScript">swapLang('Total');</script></b>&nbsp;</div></td>
				<td nowrap  class="forborder2"><div align="center"><b><%=sTotal%></b></div></td>
				<td nowrap  class="forborder2" colspan="2">&nbsp;</td>
		    </tr-->
		  </table>
		  </td>
		  </tr>
		  <tr><td >
				<table class="maxsize">
					<tr> 
						<td colspan="8"   class="blankspace"></td>
                    </tr>
                    <tr> 
						<td colspan="8"  class="noborder"><div align="center" > 
                              <a href="#" onClick="checkAll()"><img src="../IMAGES/BUTTON/TRANSFER.gif" border="0"></a></div>
						</td>
                   </tr>
				   <tr> 
						<td colspan="8"   class="blankspace"></td>
                   </tr>
				</table>
			</td></tr>
		  <tr><td class="bottom">
		  </td></tr>
  </table>
<script language="javascript">  
  setValue('__adstatus','<%=chk.chkNullString(request.getParameter("__adstatus"))%>');
  setChkbox();
</script>
</div>
<!----------BEGIN CSC ENDING ZONE ------------------------>

<%=screen.endJSP()%>

<!----------END CSC ENDING ZONE -------------------------->
</form>
</body>
</html>