<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="java.util.*,java.text.DecimalFormat"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.databean.*,com.csc.library.report.ReportUDF"  %>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<jsp:useBean id="WEL235" class="com.csc.library.system.Task" scope="page"/>
<%
WEL235.setChannel(request,response);
UIManager screen = (UIManager) WEL235.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();
DecimalFormat df=new DecimalFormat("#,##0.00");
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<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>
<script language="javascript">
	function back2Page(pages){
			with(document.cscform){
					__employeeid.value="<%=employeeid%>";
					__years.value="<%=years%>";
					action=pages;					
					submit();
			}
	}
</script>
</head>
 <table border="0" align="center" cellpadding="0" cellspacing="1" class="large">
    <tr>
      <td >
 <table align="center" cellpadding="0" cellspacing="1" class="inframe">
  <tr>
    <td colspan="6" bgcolor="#6699FF" 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%" 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">&nbsp;<b><%=screen.getLabel("job")%> :</b></td>
    <td colspan="3" bgcolor="#F4F4F4" class="Text"><%=screen.getDataLabel("bu4")%> - <%=screen.getDataLabel("bu4name")%></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">&nbsp;<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">&nbsp;<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();
		String filler=chk.chkNullString(request.getParameter("__filler"));
		sumrec.setReqFilter(filler);		
				CscCalendar cs=new CscCalendar();
		try{
				sumrec.process(false,Integer.parseInt(years));
			}catch(Exception ex){
				years=String.valueOf(cs.getYear()+543);
				sumrec.process(false,Integer.parseInt(years));
			}

		
			ReportUDF rf=new ReportUDF();
			String  reqname=rf.getSystemCode("GROUPOFREQ", screen.getUProfile().get("lang").toString(),filler);

  %>
  <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>
	  <td colspan="6"><table width="100%" align="center" cellpadding="0" cellspacing="1" class="inframe">
        <tr bgcolor="#DFDFDF">
          <td colspan="6" align="center"  ><strong><%=reqname%></strong></td>
        </tr>
        <tr bgcolor="#DFDFDF">
          <td width="25%"   class="title1" ><div align="center" class="style18"><strong><span class="style22">
            <script language="JavaScript" type="text/javascript">swapLang('Name Surname');</script>
          </span></strong></div></td>
          <td width="15%"  class="title1" ><div align="center" class="style18"><strong><span class="style22">
            <script language="JavaScript" type="text/javascript">swapLang('Bill date');</script>
          </span></strong></div></td>
          <td width="20%"  class="title1" ><div align="center" class="style18"><strong>
            <script language="JavaScript" type="text/javascript">swapLang('Disease');</script>
          </strong></div></td>
          <td width="20%"  class="title1" ><div align="center" class="style18"><strong>
            <script language="JavaScript" type="text/javascript">swapLang('Nursing home');</script>
          </strong></div></td>
          <td width="10%"  class="title1" ><div align="center" class="style18"><strong>
            <script language="JavaScript" type="text/javascript">swapLang('Request');</script>
          </strong></div></td>
          <td width="10%"  class="title1" ><div align="center" class="style18"><strong>
            <script language="JavaScript" type="text/javascript">swapLang('Cost');</script>
          </strong></div></td>
        </tr>
        <tr bgcolor="#EAEAEA">
          <td colspan="6"  class="title1" ><div class="style22">&nbsp;
            <script language="JavaScript" type="text/javascript">swapLang('Owner');</script>
          </div></td>
        </tr>
		<%
		Vector owner01=sumrec.getVdata("owner01");
		double totalcost=0,totalreqcost=0;
		double sumcost=0,sumreqcost=0;
		double cost=0,reqcost=0;
		if(owner01!=null){
		Vector vtmp=null;
		sumcost=0;
		sumreqcost=0;
		cost=0;
		reqcost=0;		
		for(int i=0;i<owner01.size();i++){
				vtmp=(Vector)owner01.get(i);
				reqcost=Double.parseDouble(String.valueOf(vtmp.get(4)));
				cost=Double.parseDouble(String.valueOf(vtmp.get(5)));
				sumcost+=cost;
				sumreqcost+=reqcost;
				totalcost+=cost;
				totalreqcost+=reqcost;
		%>
        <tr bgcolor="#F4F4F4">
          <td class="writeback"><div align="center" class="style17"><%=vtmp.get(0)%></div></td>
          <td class="writeback"><div align="center" class="style17"><%=vtmp.get(1)%></div></td>
          <td class="writeback"><div align="left" class="style17"><%=vtmp.get(2)%></div></td>
          <td class="writeback"><div align="left" class="style17"><%=vtmp.get(3)%></div></td>
          <td class="writeback"><div align="center" class="style17">
            <div align="right"><%=df.format(reqcost)%></div>
          </div></td>
          <td class="writeback"><div align="center" class="style17">
            <div align="right"><%=df.format(cost)%></div>
          </div></td>
        </tr>
	<%
		}
	}
	
	%>
        <tr bgcolor="#EAEAEA">
          <td colspan="4" class="Text"><div align="right" class="style22">
            <script language="JavaScript" type="text/javascript">swapLang('total');</script>
            <script language="JavaScript" type="text/javascript">swapLang('Government');</script>
          &nbsp;</div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(sumreqcost)%></div>
          </div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(sumcost)%></div>
          </div></td>
        </tr>
		<%
		Vector owner02=sumrec.getVdata("owner02");
		if(owner02!=null){
		sumcost=0;
		sumreqcost=0;
		cost=0;
		reqcost=0;		
		Vector vtmp=null;
		for(int i=0;i<owner02.size();i++){
				vtmp=(Vector)owner02.get(i);
				reqcost=Double.parseDouble(String.valueOf(vtmp.get(4)));
				cost=Double.parseDouble(String.valueOf(vtmp.get(5)));
				sumcost+=cost;
				sumreqcost+=reqcost;
				totalcost+=cost;
				totalreqcost+=reqcost;				
		%>
        <tr bgcolor="#F4F4F4">
          <td class="writeback"><div align="center" class="style17"><%=vtmp.get(0)%></div></td>
          <td class="writeback"><div align="center" class="style17"><%=vtmp.get(1)%></div></td>
          <td class="writeback"><div align="left" class="style17"><%=vtmp.get(2)%></div></td>
          <td class="writeback"><div align="left" class="style17"><%=vtmp.get(3)%></div></td>
          <td class="writeback"><div align="center" class="style17">
            <div align="right"><%=df.format(reqcost)%></div>
          </div></td>
          <td class="writeback"><div align="center" class="style17">
            <div align="right"><%=df.format(cost)%></div>
          </div></td>
        </tr>
	<%
		}
	}
	%>
        </tr>
        <tr bgcolor="#EAEAEA">
          <td colspan="4" class="Text"><div align="right" class="style22">
            <script language="JavaScript" type="text/javascript">swapLang('total');</script>
            <script language="JavaScript" type="text/javascript">swapLang('Individual');</script>
          &nbsp;</div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(sumreqcost)%></div>
          </div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(sumcost)%></div>
          </div></td>
        </tr>
        <tr bgcolor="#EAEAEA">
          <td colspan="4" class="Text"><div align="right" class="style22">
            <script language="JavaScript" type="text/javascript">swapLang('total');</script>
            <script language="JavaScript" type="text/javascript">swapLang('Owner');</script>
          &nbsp;</div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(totalreqcost)%></div>
          </div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(totalcost)%></div>
          </div></td>
        </tr>
        <tr bgcolor="#EAEAEA">
          <td colspan="6"  class="title1" ><div class="style22">&nbsp;
            <script language="JavaScript" type="text/javascript">swapLang('Family');</script>
          </div></td>
        </tr>
		<%
				totalcost=0;
				totalreqcost=0;

		Vector family01=sumrec.getVdata("family01");
		if(family01!=null){
		Vector vtmp=null;
		sumcost=0;
		sumreqcost=0;
		cost=0;
		reqcost=0;				
		for(int i=0;i<family01.size();i++){
				vtmp=(Vector)family01.get(i);
				reqcost=Double.parseDouble(String.valueOf(vtmp.get(4)));
				cost=Double.parseDouble(String.valueOf(vtmp.get(5)));
				sumcost+=cost;
				sumreqcost+=reqcost;
				totalcost+=cost;
				totalreqcost+=reqcost;				
		%>
        <tr bgcolor="#F4F4F4">
          <td class="Text"><div align="center" class="style17"><%=vtmp.get(0)%></div></td>
          <td class="Text"><div align="center" class="style17"><%=vtmp.get(1)%></div></td>
          <td class="Text"><div align="left" class="style17"><%=vtmp.get(2)%></div></td>
          <td class="Text"><div align="left" class="style17"><%=vtmp.get(3)%></div></td>
          <td class="Text"><div align="center" class="style17">
            <div align="right"><%=df.format(reqcost)%></div>
          </div></td>
          <td class="Text"><div align="center" class="style17">
            <div align="right"><%=df.format(cost)%></div>
          </div></td>
        </tr>
	<%
		}
	}
%>       
        <tr bgcolor="#EAEAEA">
          <td colspan="4" class="Text"><div align="right" class="style22">
            <script language="JavaScript" type="text/javascript">swapLang('total');</script>
            <script language="JavaScript" type="text/javascript">swapLang('Government');</script>
          &nbsp;</div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(sumreqcost)%></div>
          </div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(sumcost)%></div>
          </div></td>
        </tr>
		<%
		Vector family02=sumrec.getVdata("family02");
		if(family02!=null){
		Vector vtmp=null;
		sumcost=0;
		sumreqcost=0;
		cost=0;
		reqcost=0;				
		for(int i=0;i<family02.size();i++){
				vtmp=(Vector)family02.get(i);
				reqcost=Double.parseDouble(String.valueOf(vtmp.get(4)));
				cost=Double.parseDouble(String.valueOf(vtmp.get(5)));
				sumcost+=cost;
				sumreqcost+=reqcost;
				totalcost+=cost;
				totalreqcost+=reqcost;				
		%>
        <tr bgcolor="#F4F4F4">
          <td class="Text"><div align="center" class="style17"><%=vtmp.get(0)%></div></td>
          <td class="Text"><div align="center" class="style17"><%=vtmp.get(1)%></div></td>
          <td class="Text"><div align="left" class="style17"><%=vtmp.get(2)%></div></td>
          <td class="Text"><div align="left" class="style17"><%=vtmp.get(3)%></div></td>
          <td class="Text"><div align="center" class="style17">
            <div align="right"><%=df.format(reqcost)%></div>
          </div></td>
          <td class="Text"><div align="center" class="style17">
            <div align="right"><%=df.format(cost)%></div>
          </div></td>
        </tr>
	<%
		}
	}
%>       
        <tr bgcolor="#EAEAEA">
          <td colspan="4" class="Text"><div align="right" class="style22">
            <script language="JavaScript" type="text/javascript">swapLang('total');</script>
            <script language="JavaScript" type="text/javascript">swapLang('Individual');</script>
          &nbsp;</div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(sumreqcost)%></div>
          </div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(sumcost)%></div>
          </div></td>
        </tr>
        <tr bgcolor="#EAEAEA">
          <td colspan="4" class="Text"><div align="right" class="style22">
            <script language="JavaScript" type="text/javascript">swapLang('total');</script>
            <script language="JavaScript" type="text/javascript">swapLang('Family');</script>
          &nbsp;</div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(totalreqcost)%></div>
          </div></td>
          <td class="Text"><div align="center" class="style22">
            <div align="right"><%=df.format(totalcost)%></div>
          </div></td>
        </tr>
      </table>	</tr>
  <tr bgcolor="#FFFFFF">
    <td colspan="6"><div align="right"><a href="javascript:back2Page('WEL234.jsp')"><img src="../IMAGES/BUTTON/BACK.gif" width="73" height="23"  border="0"/></a></div></td>
  </tr>
  <tr>
    <td colspan="6" bgcolor="#EAEAEA">&nbsp;</td>
  </tr>
</table>
<form name="cscform" method="post" >
<input type="hidden" name="__filler" value="<%=filler%>" >
<input type="hidden" name="__employeeid" value="<%=employeeid%>">
<input type="hidden" name="__years" value="<%=years%>">
</form>	  </td>
    </tr>
    <tr>
      <td></td>
    </tr>
</table>
</body>
</html>