<%@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.*,java.text.*"  %>
<jsp:useBean id="WEL238_1" class="com.csc.library.system.Task" scope="page"/>
<%
	WEL238_1.setChannel(request,response);
	UIManager screen = (UIManager) WEL238_1.process("MultiEntry","WEL238_2");

	MultiLine multi = screen.getMultiLine("ADVANCE_PAYMENT1");
	MultiLine multi2 = screen.getMultiLine("OTHER_EXPENSE");
	if((request.getParameter("__cmd")!=null)&&(request.getParameter("__cmd").equals("search"))){
		screen.getTable("ADVANCE_PAYMENT1").setKeyOff();
		//screen.getTable("ADVANCE_PAYMENT1").setFilter("companyid='"+screen.getUProfile().get("companyid")+"' and  employeeid='"+request.getParameter("__employeeid")+"'");
		screen.getTable("ADVANCE_PAYMENT1").refresh();
	}
	
	screen.getTable("ADVANCE_PAYMENT1").last();
	//String lastrec=screen.getTable("ADVANCE_PAYMENT1").getString("line_no");
	multi.setLabelBox("check box");
	multi.goFirst();



	
	CheckNull chk=new CheckNull();
	DecimalFormat fm = new DecimalFormat("#,##0.00");

	String employeeid="",adno="",companyid="",line_no="",empname="",filename="",adstatus ="",ccenter="";
	String cleardate1 = chk.chkNullString(request.getParameter("__cleardate1"));
	String[][] addstatus = SystemCode.getContent("ADVANCE_STATUS");
	employeeid = chk.chkNullString(request.getParameter("__employeeid"));
	companyid = chk.chkNullString(request.getParameter("__companyid"));
	adstatus = chk.chkNullString(request.getParameter("__adstatus"));
	adno = chk.chkNullString(request.getParameter("__adno"));
	line_no = chk.chkNullString(request.getParameter("__gorec"));
	
	ccenter = chk.chkNullString(request.getParameter("__ccenter"));	

	
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href ="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script language='javascript' src="../JS/VIEWCALENDAR.js"></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="javascript">getTitleName();</script>
<style type="text/css">
<!--
input.disabled, select.disabled, textarea.disabled {
	background: #ebebe4;
	border: 1px solid #A5ACB2;
}
-->
</style>
<script language="JavaScript" >

function GoSave() {confirmSave();}
function GoSearch() {search();}
function GoDelete() {edelete();}
function GoUpdate() {update();}
function checkCF() {checkConfirm();}

	function goHelp(helpName,inputName){
		var fixCon = "";
		 var helpReturn;
		 if(inputName=="__adno" ){
		 	helpReturn="__adno:advance_no";
		 }else if (inputName=="__employeeid") {
			helpReturn="__employeeid:employeeid";
		 }else if (inputName=="__ccenter") {
			helpReturn="__ccenter:costcenterid,__ccname:tdesc";
		 }
		 linkHelp_Return(helpName,helpReturn,fixCon);			
	}
	function setcmd1(acktion){	
		with(document.cscform){
			if(notBlankOnThisPage()){
				bCon=confirm(MyCode[1]);
				if (bCon==true){	
					__cmdchild.value="save";
				}
				submit();
			}
		}	
	}
	function back(){
		with(window.opener.cscform){
			__cmd.value="ack";
			submit();
		}
	}
	
	
	function setDecimal(obj){
		
		
		var sTotal="",temp1="",temp2="",aString="";
		var comma=0;
		var length;
		 length =obj.value; 
		aString = length.toString();
		if(aString.indexOf(".")>0){
		temp1 = aString.substring(0,(aString.indexOf(".")));
		temp2 = aString.substring((aString.indexOf("."))+1,(aString.length));
			if(temp2.length<2) temp2 += "0";
		}else{ 
			temp1 = aString;

			temp2="00";
		}
			for(i=temp1.length;i>0;i--){
			if(comma==3){
				sTotal = temp1.substring(i-1,i)+ "," + sTotal;
				comma=1;
			}else{
				sTotal = temp1.substring(i-1,i) + sTotal;
				
				comma++;
			}
			
			}
				sTotal += "."+temp2;
				obj.value = sTotal;
			
	}


</script>
</head>
<body leftmargin="0" topmargin="0"  onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif')">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<script language='javascript' src="../JS/VIEWCALENDAR.js"></script>

<form name="cscform" method="post" action="WEL238_1.jsp">


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

<%=screen.InitialVariable()%>

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

	<input type="hidden" name="__screen" value="WEL238_1">
	<input type="hidden" name="__cmd" value="">
	<input type="hidden" name="__language" value="<%//=screen.getUProfile().get("lang")%>">
  	<input type="hidden" name ="__ack" value="<%//=request.getParameter("__ack")%>">  	
 	<input type="hidden" name="__calendar">
  	<input type="hidden" name ="__companyid" value="<%//=chk.chkNullString(request.getParameter("__companyid"))%>">
	<input type="hidden" name="__cmdChild" value="">
	<input type="hidden" name="__help" value="">
	<script language="javascript">getInputFormatDate();</script>
	<input type="hidden" name="__fixCon" value="">
	<input type="hidden" name="__user" value="<%//=screen.getUProfile().getUserId()%>">
	<input type="hidden" name="__gorec" value="<%//=chk.chkNullString(request.getParameter("__gorec"))%>">
	<input type="hidden" name="__referPage" value="">
	<input type="hidden" name="__notNull" value="<%//=screen.getRequire()%>">
	<input type="hidden" name="__taid" value="<%//=chk.chkNullString(request.getParameter("__taid"))%>">
	<input type="hidden" name="__employeeid" value="<%//=chk.chkNullString(request.getParameter("__employeeid"))%>">
	<input type="hidden" name="empname" value="<%//=screen.getDataLabel("MEMPLOYEE","FULLNAME")%>">

	
<div align="center">
	 <br>
    <table border="0" cellpadding="0" cellspacing="0" class="large">
      <tr> 
        <td class="header" >WEL238_1, 
          <script language='javascript'>swapLang('WEL_ADVANCE_PAYMENT_DETAIL');</script>&nbsp;</td>
      </tr>
	  <%
			int lineno=0;
			/*lineno = Integer.parseInt(chk.chkNullString(request.getParameter("__line_no"),"0"));
			
			if (request.getParameter("__ack").trim().equals("edit")) {
			   	lineno = Integer.parseInt(chk.chkNullString(request.getParameter("__gorec"),"1"));
				
			}else if(request.getParameter("__ack").equals("add")){
				lineno++;
		   }
		   */
	   %>
	   <input type="hidden" name="__line_no" value="<%=lineno%>">
      <tr> 
        <td > 
          <div align="center"> 
            <center>
              <table cellpadding="0"  cellspacing="0" colspan="4" class="large">
                <tr> 
						<td class="blankspace"></td>
                </tr>
				<tr>
					<td colspan="2">
					<!---------------------------->
					<table width="100%" border="0" cellpadding="0" cellspacing="0" class="maxsize">
	  <tr bgcolor="#3366CC"> 
	  <td class="columnlabel"><%=screen.getLabel("ADVANCE_NO")%>&nbsp;</td>
	   <td>
       <input name="__adno1" type="text" size="15" value="<%=screen.getDataLabel("ADVANCE_NO")%>" readonly class = 'disabled'></td>
	  </tr>
	  <tr> 
                      <td align="right"><%=screen.getLabel("EMPLOYEEID")%>&nbsp;</td>
                      <td><input name="__employeeid" type="text" size="15" value="<%=screen.getDataLabel("EMPLOYEEID")%>" readonly class="disabled">   <input name="" type="text" size="30" value="<%=screen.getDataLabel("MEMPLOYEE","FULLNAME")%>" readonly class="disabled"></td>
       </tr>
	   <tr bgcolor="#3366CC"> 
	   <td align="right"><%=screen.getLabel("COSTCENTER")%>&nbsp;</td>
		<td><input name="__ccenter" type="text" size="15" value="<%=screen.getDataLabel("COSTCENTER")%>">
                    <a href="javascript:goHelp('MCOSTCENTER0HELP','__ccenter');" 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="__ccname" type="text" size="30" value="<%=screen.getDataLabel("MCOSTCENTER0","TDESC")%>" readonly class="disabled"></td>
	  </tr>
		<tr bgcolor="#3366CC">
			<td class="columnlabel"><%=screen.getLabel("CLEARING_DATE")%>&nbsp;</td>
                  <td>
                    <input name="__cleardate1" type="text" size="15"  maxlength="10" value="<%=screen.getDataLabel("CLEARING_DATE")%>" onKeyPress="chkInteger()" onKeyUp="formatDate(this)"/>
					<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></td>
		</tr>

	   <tr bgcolor="#3366CC"> 
		<td class="columnlabel"><div><%=screen.getLabel("REMARK")%></div></td>
		<td><div><textarea name="__memo" rows='5' cols='50'><%=screen.getDataLabel("REMARK")%></textarea></div></td>
	  </tr>

	  <tr>
                  <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  colspan="3"> 
		<tr>
			<td>
			</td>
		</tr>
		  <table height="" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="inframe" >
		  <tr bgcolor="#3366CC">
                    <td colspan="13" class="title1"><div align="left"><script language="JavaScript">swapLang('Other Expense');</script></div></td>
                </tr>
				<tr bgcolor="#3366CC">
                    <td class="title1" colspan=""><div align="center"><script language="JavaScript">swapLang('Date');</script></div></td>
					<td class="title1" colspan=""><div align="center"><script language="JavaScript">swapLang('Item Name');</script></div></td>
                    <td class="title1" colspan=""><div align="center"><script language="JavaScript">swapLang('Vendor Name');</script></div></td>
                    <td class="title1" colspan=""><div align="center"><script language="JavaScript">swapLang('Tax');</script></div></td>
					<td class="title1" colspan=""><div align="center"><script language="JavaScript">swapLang('With Hold Tax');</script></div></td>
					<td class="title1" colspan=""><div align="center"><script language="JavaScript">swapLang('Amount');</script></div></td>
                </tr>
				 <% 
				//int x = 1;
				Double sumLenge2=0.00;
				String lenge2="";
		  
				for(int i=1;!multi2.eof();multi2.next(),i++){ 
					lenge2 = multi2.getData("OTHER_EXPENSE","EXPENSE_AMOUNT");
					lenge2 = lenge2.replace(",","");
					sumLenge2=sumLenge2+(Double.parseDouble(lenge2));
				
				 %>
 
				<tr>
                  <td>
                    <div align="center"><input name="__cleardate" type="text" size="15"  maxlength="10" value="<%=multi2.getData("OTHER_EXPENSE","EXPENSE_DATE")%>" onKeyPress="chkInteger()" onKeyUp="formatDate(this)"/>
					<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></div></td>
					<td><input name="__item" type="text" size="15" value="<%=multi2.getData("OTHER_EXPENSE","EXPENSE_ITEM")%>">
                    <a href="javascript:goHelp('MACCOUNTHELP','__item');" 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></td>
					<td><div><textarea name="__memo" rows='5' cols='50'><%=multi2.getData("OTHER_EXPENSE","VENDOR_NAME")%></textarea></div></td>
					<td nowrap  class="forborder2"><div align="center"><input name="__amount" type="text" size="15" value="<%=multi2.getData("OTHER_EXPENSE","EXPENSE_TAX")%>"></div></td>
					<td nowrap  class="forborder2"><div align="center"><input name="__amount" type="text" size="15" value="<%=multi2.getData("OTHER_EXPENSE","EXPENSE_HOLD_TAX")%>"></div></td>
					<td nowrap  class="forborder2"><div align="center"><input name="__amount" type="text" size="15" value="<%=multi2.getData("OTHER_EXPENSE","EXPENSE_AMOUNT")%>"></div></td>
                </tr>

				<%
				}	
				%>
				<tr> 
				<% 
					Double NetTotal;
					String sTotal2="",temp12="",temp22="",aString2="";
					int comma2=0;
					aString2 = sumLenge2.toString();
					temp12 = aString2.substring(0,(aString2.indexOf(".")));
					temp22 = aString2.substring((aString2.indexOf("."))+1,(aString2.length()));
					if(temp22.length()<2){
						temp22 += "0";
					}
						for(int j=temp12.length();j>0;j--){
							if(comma2==3){
								sTotal2 = temp12.substring(j-1,j)+ "," + sTotal2;
								comma2=1;
							}else{
								sTotal2 = temp12.substring(j-1,j) + sTotal2;
								comma2++;
							}
						}
					sTotal2 += "."+temp22;
					NetTotal=(Double.parseDouble(sTotal2.replace(",","")));
				%>
				<td nowrap  class="title1" colspan="5"><div align="right"><b><script language="JavaScript">swapLang('Total');</script></b>&nbsp;</div></td>
				<td nowrap  class="title1" colspan=""><div align="center"><input name="__amount" type="text" size="15" value="<%=sTotal2%>" readonly class="disabled"></div></td>
				</tr>
		  </table>
		  </td>
		  </tr>

		<!--%
				for(int i=1;!multi.eof();multi.next(),i++){ 				

				}
			%-->
							  
                      
                      
                      
                    </table>
					<!----------------------->
					</td>
                </tr>
				<tr> 
					  <td class="blankspace"></td>
                </tr>
				<tr> 
					  <td colspan="2" class="bottom" ></td>
				</tr>
				<tr> 
					  <td class="blankspace"></td>
                </tr>
				</tr>
				
				<tr>
                  <td colspan="2" align="center">
                    <a href="javascript:GoSave();"><img src="../IMAGES/BUTTON/SAVE.gif"  border="0"></a>
					<a href="javascript:backhead();"><img src="../IMAGES/BUTTON/BACK.gif"  border="0"></a>
				  </td>
                </tr>
			    <tr> 
					  <td class="blankspace"></td>
               </tr>
			   <tr> 
					  <td class="blankspace"></td>
               </tr>
              </table>
            </center>
          </div></td>
      </tr>
      <tr> 
       <td class="bottom" ></td>
      </tr>
    </table>
    </center>
</div>

<!--<script language="javascript">setDisabledField();</script-->
<% 
if((request.getParameter("__cmd")!=null)&&(request.getParameter("__cmd").equals("save"))){%>
<script language="javascript">window.opener.cscform.submit();</script>
<%}%>
<!----------BEGIN CSC ENDING ZONE ------------------------>

<%=screen.endJSP()%>

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