<%@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.*,com.csc.library.databean.*,com.csc.library.report.ReportUDF"  %>

<jsp:useBean id="WEL234" class="com.csc.library.system.Task" scope="page"/>
<%
WEL234.setChannel(request,response);
UIManager screen = (UIManager) WEL234.process("SingleEntry","EMVWEL001");
CheckNull chk=new CheckNull();
String employeeid=chk.chkNullString(request.getParameter("__employeeid"));
String years=chk.chkNullString(request.getParameter("__years"));
if(years.length()>0&& employeeid.length()>0){
		screen.getRecord().set("employeeid",employeeid);//screen.getUProfile().get("employeeid")
		screen.getRecord().set("companyid",screen.getUProfile().get("companyid"));
		screen.getRecord().search();
}
screen.referLangOn();
int langt=(screen.getUProfile().get("lang").toString().equalsIgnoreCase("tha"))?1:0;
%>
<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/ICONSMENU.js"></script>
<script language='javascript' src="../JS/HOTKEY.js"></script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<style type="text/css">
<!--
#Layer14 {
	position:absolute;
	left:591px;
	top:286px;
	width:115px;
	height:121px;
	z-index:8;
}
.style12 {color: #333333; font-weight: bold; font-size: 14px; }
-->
</style>
<style type="text/css">
<!--
#Layer14 {
	position:absolute;
	left:716px;
	top:15px;
	width:108px;
	height:92px;
	z-index:1;
	visibility: visible;
}
-->
</style>
</head>
<script language="javascript">
 	ThaiCode[215]="ค่าเล่าเรียนบุตร";
	EngCode[215]="Education of family";

function GoSearch()
{
	search();
	}

		function goviewReport(fill){
			with(document.cscform){
				action="WEL235.jsp";
				__filler.value=fill;
				__employeeid.value="<%=employeeid%>";
				__years.value="<%=years%>";
				submit();
				}
		}
		function goviewReport2(fill){
			with(document.cscform){
				action="WEL236.jsp";
				__filler.value=fill;
				__employeeid.value="<%=employeeid%>";
				__years.value="<%=years%>";				
				submit();
				}
		}
		
	function goHelp(helpName,inputName){
	var helpReturn;
	var fixcon=document.cscform.__fixCon.value;
	document.cscform.__fixCon.value="";
		 if(inputName=="__employeeid" )
		 	helpReturn="__employeeid:EMPLOYEEID";
					
	     linkHelp_Return(helpName,helpReturn);
		 document.cscform.__fixCon.value=fixcon;
}
		
</script><body onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')">

<form name="cscform"  method="post">
	<input type="hidden" name="__filler" value="" >
	<input type="hidden" name="__cmd" value="">
	<input type="hidden" name="__help" value="">
	<input type="hidden" name="__screen" value="WEL234">
	<input type="hidden" name="__goPage" value="">
	<input  type="hidden" name="__notNull" value="<%//=screen.getRequire()%>">
	<input type="hidden" name="__helpReturn" value="">
	<input type="hidden" name="__helpName" 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="__fixCon" type="hidden" value="">
  	<input type="hidden" name="__companyid"  value="<%=screen.getUProfile().get("companyid")%>">

<%!
         java.text.DecimalFormat df=new java.text.DecimalFormat("#,##0.00");
		 CheckNull chk=new CheckNull();
		public String calculate(String value1,String value2){
				double dvalue1=Double.parseDouble(chk.chkNullString(value1,"0").replace(",",""));
				double dvalue2=Double.parseDouble(chk.chkNullString(value2,"0").replace(",",""));				
				double dvalue3=dvalue1-dvalue2;
				if(dvalue3<0)
					dvalue3=0;
				return df.format(dvalue3);
		}
		
		public String calculate(String value1,String value2,String value3,String value4){
				double dvalue1=Double.parseDouble(chk.chkNullString(value1,"0").replace(",",""));
				double dvalue2=Double.parseDouble(chk.chkNullString(value2,"0").replace(",",""));				
				double dvalue3=Double.parseDouble(chk.chkNullString(value3,"0").replace(",",""));				
				double dvalue4=Double.parseDouble(chk.chkNullString(value4,"0").replace(",",""));		
				double dvalue5=dvalue1-(dvalue2+dvalue3+dvalue4);		
				if(dvalue5<0)
					dvalue5=0;								
				return df.format(dvalue5);
		}
%>
<div align="center">
<table class="maxsize" >
  <tr >
    	<td  colspan="4"class="header"> WEL234,&nbsp;<script language="javascript">swapLang("Employee Information");</script>&nbsp;</td>
   	</tr>
  <tr>
    <td width="84" class="columnlabel"><script language="javascript">swapLang('Year');</script></td>
    <td width="219"><input type="text" name="__years" value="" size="15" maxlength="15"> </td>
    <td width="149" class="columnlabel"><script language="javascript">swapLang('Employeeid');</script></td>
    <td width="711"><input type="text" name="__employeeid" value="" size="15" maxlength="15">
      <a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid');" 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> &nbsp;&nbsp;<a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif"  border="0" align="absmiddle"></a></td>
  </tr>
  <tr>
    <td colspan="4"><div align="center"></div></td>
    </tr>
</table>
<br>
<%
if(years.length()>0&& employeeid.length()>0){
%>
<table width="900" border="0" cellpadding="0" cellspacing="0" align="center" class="large">
  <tr>
    <td align="center" valign="top">
<table width="900" align="center" cellpadding="0" cellspacing="1" class="inframe">
  
  <tr>
    <td colspan="6"  class="title1"><div align="center" class="style12"><strong>
      <script language="JavaScript" type="text/javascript">swapLang('Welfare of employee');</script>
    </strong></div></td>
  </tr>
  <tr >
    <td width="18%" nowrap="nowrap"  bgcolor="#EAEAEA" class="Text">&nbsp;<b><%=screen.getLabel("employeeid")%> :</b></td>
    <td width="32%" bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("employeeid")%></td>
    <td width="12%" nowrap="nowrap" bgcolor="#EAEAEA" class="Text">&nbsp;<b><%=screen.getLabel("swipecardid")%> :</b></td>
    <td width="14%" bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("swipecardid")%></td>
    <td width="12%" nowrap="nowrap" bgcolor="#EAEAEA" class="Text">&nbsp;<b><%=screen.getLabel("status")%> :</b></td>
    <td width="12%" bgcolor="#F4F4F4" class="Text"><%=screen.getRecord().getSystemCode("status")%></td>
  </tr>
  <tr>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text">&nbsp;<b><%=screen.getLabel("fname")%> :</b></td>
    <td bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("tfullname")%></td>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text">&nbsp;<b><%=screen.getLabel("efname")%>:</b></td>
    <td colspan="3" bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("efullname")%></td>
  </tr>
  <tr>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text">&nbsp;<b><%=screen.getLabel("emp_position")%> :</b></td>
    <td bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("emp_position")%> - <%=screen.getDataLabel("positionname")%></td>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text">&nbsp;<b><script language="JavaScript" type="text/javascript">swapLang('Executive position');</script> 
      :</b></td>
    <td colspan="3" bgcolor="#F4F4F4" class="Text">-</td>
  </tr>
  <tr>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text"><b>
      <script language="JavaScript" type="text/javascript">swapLang('Office');</script> 
      :</b></td>
    <td bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("bu1")%> - <%=screen.getDataLabel("bu1name")%></td>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text"><b>
      <script language="JavaScript" type="text/javascript">swapLang('Center');</script> 
      :</b></td>
    <td colspan="3" bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("bu2")%> - <%=screen.getDataLabel("bu2name")%></td>
  </tr>
  <tr>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text"><b>
      <script language="JavaScript" type="text/javascript">swapLang('Division or Project Data');</script> 
      :</b></td>
    <td bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("bu3")%> - <%=screen.getDataLabel("bu3name")%></td>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text"><b><%=screen.getLabel("job")%> :</b></td>
    <td colspan="3" bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("job")%> - <%=screen.getDataLabel("mjobcode","tdesc")%></td>
  </tr>
  <tr>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text">&nbsp;<b><%=screen.getLabel("workarea")%> :</b></td>
    <td bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("workarea")%> - <%=screen.getDataLabel("mworkarea","tdesc")%></td>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text"><b><%=screen.getLabel("time0")%> :</b></td>
    <td colspan="3" bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("time0")%> - <%=screen.getDataLabel("mtime0","tdesc")%></td>
  </tr>
  <tr>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text">&nbsp;<b><%=screen.getLabel("startdate")%> :</b></td>
    <td bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("startdate")%></td>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text"><b><%=screen.getLabel("firsthiredate")%> :</b></td>
    <td colspan="3" bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("firsthiredate")%></td>
  </tr>
  <tr>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text">&nbsp;<b><%=screen.getLabel("approve_date")%> :</b></td>
    <td bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("approve_date")%></td>
    <td nowrap="nowrap" bgcolor="#EAEAEA" class="Text"><b>
      <script language="JavaScript" type="text/javascript">swapLang('work ages');</script> 
      :</b></td>
    <td colspan="3" bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("empworkages")%></td>
  </tr>
  <tr>
    <td colspan="6" bgcolor="#F4F4F4" class="Text">&nbsp;</td>
  </tr>
  <%
  		Simsummarywelfare_report sumrec=(Simsummarywelfare_report)screen.getRecord();
		CscCalendar cs=new CscCalendar();
		try{
				sumrec.process(true,Integer.parseInt(years));
			}catch(Exception ex){
				years=String.valueOf(cs.getYear()+543);
				sumrec.process(true,Integer.parseInt(years));
			}
		
  %>
  <tr bgcolor="#6699FF">
    <td colspan="6" bgcolor="#6699FF" class="title1"><div align="center" class="style19 style21"><strong>
      <script language="JavaScript" type="text/javascript">swapLang('Budget year');</script>
    </strong><%=years%>
    </div></td>
  </tr>
	<tr class="Text" bgcolor="#F4F4F4">
		<td colspan="6">
			<table  align="center" cellpadding="0" cellspacing="1" class="inframe" bgcolor="#666666">
				  <tr bgcolor="#333333">
				    <td width="24%" rowspan="3" class="title1"><div align="center" class="Text"><strong>
				      <script language="JavaScript" type="text/javascript">swapLang('Welfare');</script>
			        </strong></div></td>
				    <td width="16%" rowspan="3" class="title1"><div align="center" class="Text"><strong>
				      <script language="JavaScript" type="text/javascript">swapLang('Government');</script>
			        </strong></div></td>
				    <td colspan="3" class="title1"><div align="center" class="Text"><strong>
				      <script language="JavaScript" type="text/javascript">swapLang('Individual');</script>
			        </strong></div></td>
				    <td width="12%" rowspan="3" class="title1"><div align="center" class="Text"><strong>
				      <script language="JavaScript" type="text/javascript">swapLang('Detail');</script>
			        </strong></div></td>
			      </tr>
				  <tr bgcolor="#333333">
				    <td width="16%" rowspan="2" align="center" class="title1"><strong>
				    <script language="JavaScript" type="text/javascript">swapLang('Used');</script>
				  </strong>&nbsp;</td>
				  <td colspan="2" align="center" class="title1"><strong>
				    <script language="JavaScript" type="text/javascript">swapLang('Remain');</script>
				  </strong></td>
				  </tr>
				<tr bgcolor="#EAEAEA">
				  <td width="14%" align="center" class="title1"><div align="center" class="Text"><span class="style22"><strong>
					  <script language="JavaScript" type="text/javascript">swapLang('Owner');</script>
					</strong></span></div></td>
					<td width="18%" class="title1"><div align="center" class="Text"><strong><span class="style22">
					  <script language="JavaScript" type="text/javascript">swapLang('Family');</script>
					</span></strong></div></td>
				</tr>
				<tr bgcolor="#FFFFFF">
					<td bgcolor="#F4F4F4" class="writeback"><div align="center" class="Text">
					  <div align="left"> <script language="JavaScript" type="text/javascript">document.write(MyCode[215]);</script></div>
					</div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel("edu04")%></div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel("edu05")%></div></td>
					<td align="right"  class="title1">&nbsp;</td>
					<td align="right" class="writeback"><%=this.calculate(screen.getDataLabel("sumall_edu"),screen.getDataLabel("sumedu"))%></td>
					<td class="writeback"><div align="center" class="Text"><a href="javascript:goviewReport2('000');"><img src="../IMAGES/BUTTON/VIEW.gif" width="73" height="23" border="0" /></a></div></td>
				</tr>
				<%
			ReportUDF rf=new ReportUDF();
			String [] reqtype=rf.getSystemCode("GROUPOFREQ", screen.getUProfile().get("lang").toString());
			String [] code=null;			
				//for(int index=0;index<reqtype.length;index++){
				%>
				<tr bgcolor="#FFFFFF">
				<%
						code=reqtype[0].split(",");
				%>
					<td bgcolor="#F4F4F4" class="writeback"><div align="center" class="Text">
					  <div align="left"><%=code[1]%></div>
					</div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s01")%></div></td>
					<td  align="right" class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s02")%></div></td>
					<td align="right" class="writeback"><%=this.calculate(screen.getDataLabel("sumallm_01"),screen.getDataLabel("sumowner01"))%></td>
					<td  valign="middle" align="right" class="writeback">
					<%//=this.calculate(screen.getDataLabel("sumallf_01"),screen.getDataLabel("sumfm01"))%>
					<%//=this.calculate(screen.getDataLabel("sumallf_05"),screen.getDataLabel("sumfm05"))%>
					<%//=this.calculate(screen.getDataLabel("sumallf_04"),screen.getDataLabel("sumfm04"))%>
					<%=this.calculate("30000",screen.getDataLabel("sumfm01"),screen.getDataLabel("sumfm05"),screen.getDataLabel("sumfm04"))%>					</td>
					<td class="writeback"><div align="center" class="Text"><a href="javascript:goviewReport('<%=code[0]%>');"><img src="../IMAGES/BUTTON/VIEW.gif" width="73" height="23" border="0"/></a></div></td>
				</tr>
				<tr bgcolor="#FFFFFF">
				<%
						code=reqtype[4].split(",");
				%>
					<td bgcolor="#F4F4F4" class="writeback"><div align="center" class="Text">
					  <div align="left"><%=code[1]%></div>
					</div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s01")%></div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s02")%></div></td>
					<td align="right" class="writeback">0.00<%//=this.calculate(screen.getDataLabel("sumallm_05"),screen.getDataLabel("sumowner05"))%></td>
					<td rowspan="3" align="right"  valign="middle" class="title1">&nbsp;</td>
					<td class="writeback"><div align="center" class="Text"><a href="javascript:goviewReport('<%=code[0]%>');"><img src="../IMAGES/BUTTON/VIEW.gif" width="73" height="23"  border="0"/></a></div></td>
				</tr>				
				<tr bgcolor="#FFFFFF">
				<%
						code=reqtype[3].split(",");
				%>
					<td bgcolor="#F4F4F4" class="writeback"><div align="center" class="Text">
					  <div align="left"><%=code[1]%></div>
					</div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s01")%></div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s02")%></div></td>
					<td align="right" class="writeback">0.00<%//=this.calculate(screen.getDataLabel("sumallm_04"),screen.getDataLabel("sumowner04"))%></td>
					<td class="writeback"><div align="center" class="Text"><a href="javascript:goviewReport('<%=code[0]%>');"><img src="../IMAGES/BUTTON/VIEW.gif" width="73" height="23"  border="0" /></a></div></td>
				</tr>
				<tr bgcolor="#FFFFFF">
				<%
						code=reqtype[5].split(",");
				%>
					<td bgcolor="#F4F4F4" class="writeback"><div align="center" class="Text">
					  <div align="left"><%=code[1]%></div>
					</div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s01")%></div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s02")%></div></td>
					<td align="right"  class="title1">&nbsp;</td>
					<td class="writeback"><div align="center" class="Text"><a href="javascript:goviewReport('<%=code[0]%>');"><img src="../IMAGES/BUTTON/VIEW.gif" width="73" height="23"   border="0"/></a></div></td>
				</tr>				
				<tr bgcolor="#FFFFFF">
				<%
						code=reqtype[1].split(",");
				%>
					<td bgcolor="#F4F4F4" class="writeback"><div align="center" class="Text">
					  <div align="left"><%=code[1]%></div>
					</div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s01")%></div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s02")%></div></td>
					<td align="right" class="writeback"><%=this.calculate(screen.getDataLabel("sumall_02"),screen.getDataLabel("sumowner02"),screen.getDataLabel("sumfm02"),screen.getDataLabel(code[0]+"_s01"))%></td>
					<td align="right" class="title1"><%//=this.calculate(screen.getDataLabel("sumallf_02"),screen.getDataLabel("sumfm02"))%>					</td>					
					<td class="writeback"><div align="center" class="Text"><a href="javascript:goviewReport('<%=code[0]%>');"><img src="../IMAGES/BUTTON/VIEW.gif" width="73" height="23"   border="0"/></a></div></td>
				</tr>
				<tr bgcolor="#FFFFFF">
				<%
						code=reqtype[2].split(",");
				%>
					<td bgcolor="#F4F4F4" class="writeback"><div align="center" class="Text">
					  <div align="left"><%=code[1]%></div>
					</div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s01")%></div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s02")%></div></td>
					<td align="right" class="writeback"><%=this.calculate(screen.getDataLabel("sumallm_03"),screen.getDataLabel("sumowner03"))%></td>
					<td align="right" class="writeback">0.00<%//=this.calculate(screen.getDataLabel("sumallf_03"),screen.getDataLabel("sumfm03"))%></td>				
					<td class="writeback"><div align="center" class="Text"><a href="javascript:goviewReport('<%=code[0]%>');"><img src="../IMAGES/BUTTON/VIEW.gif" width="73" height="23"  border="0" /></a></div></td>
				</tr>				
				<tr bgcolor="#FFFFFF">
				<%
						code=reqtype[6].split(",");
				%>
					<td bgcolor="#F4F4F4" class="writeback"><div align="center" class="Text">
					  <div align="left"><%=code[1]%></div>
					</div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s01")%></div></td>
					<td class="writeback"><div align="right" class="Text"><%=screen.getDataLabel(code[0]+"_s02")%></div></td>
					<td  align="right"  class="title1">&nbsp;</td>
					<td  align="right" class="title1">&nbsp;</td>
					<td class="writeback"><div align="center" class="Text"><a href="javascript:goviewReport('<%=code[0]%>');"><img src="../IMAGES/BUTTON/VIEW.gif" width="73" height="23"   border="0"/></a></div></td>
				</tr>
				<%
				   // }
				%>
			</table>	</tr>
  <tr bgcolor="#FFFFFF">
    <td colspan="6">&nbsp;</td>
  </tr>
</table></td>
  </tr>
</table>
<%}%>
</div>
</form>