<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,java.util.*"%>
<%@page import="com.csc.library.util.ManageDocument"%>
<%@page import="java.text.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.report.ReportUDF"  %>
<%@page import="java.util.*,com.csc.library.approve.Actor"%>
<jsp:useBean id="TEMPLATE_WORKFLOW1" class="com.csc.library.system.Task" scope="page" />
<%
TEMPLATE_WORKFLOW1.setChannel(request,response);
TEMPLATE_WORKFLOW1.checkProfile();
if( TEMPLATE_WORKFLOW1.getUProfile() != null ){
	TEMPLATE_WORKFLOW1.getUProfile().set("appname","TRAINING");
	UIManager screenSingle = (UIManager) TEMPLATE_WORKFLOW1.process("SingleEntry","TEMPLATE_WORKFLOW");
 
 	DecimalFormat df = new DecimalFormat("#,##0.00");
 
 	CheckNull chkNull = new CheckNull();
	CscCalendar date = new CscCalendar();
	String screen_value = chkNull.chkNullString(screenSingle.getDataLabel("SCREEN_VALUE"));
	HashMap hm = new HashMap();
	ManageDocument md = new ManageDocument();
	
	hm.put("WF_ID",request.getParameter("wf_id"));
	hm.put("WF_VER",request.getParameter("wf_ver"));
	hm.put("WF_SEQ_NO",request.getParameter("wf_seq_no"));
	hm.put("DOC_NO",request.getParameter("wf_doc_no"));
	hm.put("STEP_ID",request.getParameter("step_id"));
	hm.put("STEP_SEQ_NO",request.getParameter("step_seq_no"));
	hm.put("ACTOR_ID",screenSingle.getUProfile().getActor());
	hm.put("POSITION_CODE",screenSingle.getUProfile().get("job"));
	
	md.setUProfile(screenSingle.getUProfile());
	md.setParam(hm);
	md.setVW_Incident();
	md.setWFDataValue(screen_value);
	
	
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" href="../css/printpage.css" type="text/css">
  <script type='text/javascript' src='/hr/dwr/interface/SearchDWR.js'></script>
  <script type='text/javascript' src='/hr/dwr/engine.js'></script>
  <script type='text/javascript' src='/hr/dwr/util.js'></script>
  <script type="text/javascript" src="/hr/dwr/interface/SystemCode.js"></script>
  <script type="text/javascript" src="/hr/dwr/interface/CscCalendar.js"></script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script src="../JS/PRINTPAGE.js"></script>
<script src="../JS/SCREEN.js"></script>
<script language='javascript'>setLang('<%=screenSingle.getUProfile().get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
<!--
var objwin=1;

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 opennewwin(page){
 with(document.cscform){
        open(page,"help","height=500,width=600,resizable=1,scrollbars=yes");
   }
}

function setSpanEmp(empid){	
		SearchDWR.search1(new Array("memployee","employeeid,companyid,fname,lname,efname,elname,emp_prefix,fullname,tel_ext,bossid,bu1,bu2,bu3,positionname,bu2name,emp_type,emp_position","employeeid = '"+empid+"'","employeeid","langon"),spanEmp);
}
var spanEmp=function (data){ 
		DWRUtil.setValue("spfullname",data[7]);
		DWRUtil.setValue("spfullname2",data[7]);
		DWRUtil.setValue("spfullname3",data[7]);
		DWRUtil.setValue("sppositionname",data[13]);
		DWRUtil.setValue("sppositionname2",data[13]);
		DWRUtil.setValue("spbu2name",data[14]);
		var lodesc="(สำหรับส่วนงานกลาง)";
		if(data[10]=="1"){
				lodesc="(สำหรับสำนักงานภาค)";
		}else{
				lodesc="(สำหรับส่วนงานกลาง)";
		}
		DWRUtil.setValue("locationdesc",lodesc);		
}

var setChild1= function(data){
	DWRUtil.setValue("child1name",data[0]);
}
var setChild2= function(data){
	DWRUtil.setValue("child2name",data[0]);
}
var setChild3= function(data){
	DWRUtil.setValue("child3name",data[0]);
}
var setChild4= function(data){
	DWRUtil.setValue("child4name",data[0]);
}

var setDegree1= function(data){
	DWRUtil.setValue("degree1name",data[1]);
}

var setDegree2= function(data){
	DWRUtil.setValue("degree2name",data[1]);
}

var setDegree3= function(data){
	DWRUtil.setValue("degree3name",data[1]);
}

var setDegree4= function(data){
	DWRUtil.setValue("degree4name",data[1]);
}

//-->
</script>

<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.style2 {
	            font-family:Tahoma; 
	            font-size: 12px
}
.header { font-family:Tahoma; 
	            font-size: 14;
			}

.tablelayout{
	width:800;
	text-align:inherit;
}

.tablelayout300{
	width:288;
	text-align:inherit;
}
.tablelayout200{
	text-align:inherit;	
	vertical-align: text-top;
}
.text-column { 
	text-align: left;
	font-family:Tahoma; 
     font-size: 12;
	padding:  0 2px;
	text-indent:100px;
	line-height: 20px;
}

table.noline
{
    border-color: #FFFFFF;
    border-width: 0 0 0 0;
    border-style:none;
}


td.noline
{
    border-color: #FFFFFF;
    border-width: 0 0 0 0;
    border-style:none;
}

table
{
    border-color: #000;
    border-width: 0 0 1px 1px;
    border-style: solid;
}


td
{
    border-color: #000;
    border-width: 1px 1px 0 0;
    border-style: solid;
    margin: 0;
    padding: 1px;
}

.text-column2 { 
	text-align: left;
	font-family:Tahoma; 
     font-size: 12;
	padding:  0 2px;
	text-indent:600px;
	line-height: 20px;		
}
.style5 {font-family: Tahoma; font-size: 14; font-weight: bold; }

-->

</style>
<style type="text/css" media="print">
  .menuitems{visibility:hidden}
</style>
</head>
<body onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/edit_swap24.gif')" >
<form name="cscform" method="post" action="">


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

<%=screenSingle.InitialVariable()%>

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

<input name="__cmd" type="hidden" value="">
	<input type="hidden" name="__calendar">
  	<input type="hidden" name="__dateformat" value="DD/MM/YYYY">
  	<input type="hidden" name="__language" value="eng">

<div class="menuitems">
       <div><a href="javascript:window.print()"><IMG SRC="IMAGES/MENUPRINT.gif" WIDTH="12" HEIGHT="12" BORDER="0" HSPACE="0" VSPACE="0" ALIGN="absmiddle">&nbsp;Print</a></div>
		<div><a href="javascript:window.close()"><font color=red><b>X</b></font>&nbsp;Close</a></div>
</div>
<div align="center" >	
  <div class="tablelayout" >
<table width="100%" border="0" class="noline">
  <tr>
    <td width="30%" rowspan="3" class="noline"><div align="right"><img src="../IMAGES/LOGO/LOGO_CODI2.jpg" width="80" height="70"></div></td>
    <td width="40%" class="noline"> <div align="center" class="header"><strong>แบบขอรับเงินช่วยเหลือค่าการศึกษาบุตร</strong></div></td>
    <td width="30%" class="noline"><div align="right" class="style2">แบบ บค.04-2</div></td>
  </tr>
  <tr>
    <td width="40%" class="noline"> <div align="center" class="style5"><span id="locationdesc"/></div></td>
    <td width="30%" class="noline"><div align="right" class="style2">เลขที่ <%=screenSingle.getDataLabel("DOC_NO")%></div></td>
  </tr>
  <tr>
    <td width="40%" class="noline"> <div align="center" class="style5">สถาบันพัฒนาองค์กรชุมชน(องค์กรมหาชน)</div></td>
    <td width="30%" class="noline"><div align="right" class="style2"></div></td>
  </tr>
</table>

	 
			
			<br>
			<div align="left" class="style2"><strong>เรียน หัวหน้าส่วนบุคลากร(บริหารสำนักงาน)/ผู้จัดการภาค  </strong></div>
		    <br>
		    <div class="text-column">
		    ข้าพเจ้า   <span id="spfullname"></span> &nbsp;ตำแหน่ง&nbsp; <span id="sppositionname"></span> &nbsp;สังกัด&nbsp; <span id="spbu2name"></span><br>ขอรับเงินช่วยเหลือค่าการศึกษาบุตร ในปีการศึกษา&nbsp;<%=md.getWFDataValue("__wf__term1").substring(md.getWFDataValue("__wf__term1").indexOf("/")+1)%>&nbsp;	ตามระเบียบ พอช. </div>
			  <div class="style2">
			    <table cellspacing="0" cellpadding="0" class="tablelayout">
                    <tr class="style2"  bgcolor="#CCCCCC">
                    <td colspan="7" align="center" class="tablelayout200"><strong>ส่วนที่1 เฉพาะผู้ขอเบิก </strong></td>
                    <td colspan="2" align="center" class="tablelayout200"><strong>ส่วนที่2<br>
                    เฉพาะงานบริหาร สนง.ภาค </strong></td>
                    </tr>
                  <tr class="style2"  bgcolor="#CCCCCC">
                      <td width="67" rowspan="2" align="center" class="tablelayout200"><strong>บุตรคนที่</strong></td>
                      <td width="98" rowspan="2" align="center"  class="tablelayout200"><strong>ชื่อบุตร</strong></td>
                      <td width="180" rowspan="2" align="center" class="tablelayout200"><strong>ชื่อสถานศึกษา</strong></td>
                      <td width="133" rowspan="2" align="center" class="tablelayout200"><strong>ระดับการศึกษา</strong></td>
                      <td width="49" rowspan="2" align="center" class="tablelayout200"><strong>ประจำ<br>
                    ภาค</strong></td>
                    <td colspan="2" align="center" class="tablelayout200"><strong>เงินที่จ่ายจริง</strong></td>
                    <td colspan="2" align="center" class="tablelayout200"><strong>ส่วนนี้เฉพาะงานบุคคล<br>
                      เงินที่ได้รับตามสิทธิ์</strong></td>
                  </tr>
                  <tr class="style2"  bgcolor="#CCCCCC">
                    <td width="97" height="18" align="center" class="tablelayout200">บาท</td>
                    <td width="21" align="center" class="tablelayout200">สต.</td>
                    <td width="132" align="center" class="tablelayout200">บาท</td>
                    <td width="21" align="center" class="tablelayout200">สต.</td>
                  </tr>
				  <%
				    double totalAmt=0,totalReal=0;
					String a_amount1="";
					String r_amount1="";

				  	for(int i=1;i<=4;i++){
					if(md.getWFDataValue("__wf__term"+i).trim().length()>0){
				  %>
                  <tr class="style2">
                    <td height="23"  class="style2"><%=md.getWFDataValue("__wf__fromfather"+i)%></td>
                    <td class="style2" ><span id="child<%=i%>name"></span><script language="javascript">SearchDWR.search1(new Array("mempl_family","fullname,employeeid,companyid,relationid,fnameid,lname,efname,elname,line_no","employeeid = '<%= md.getWFDataValue("__wf__employeeid") %>' and line_no='<%= md.getWFDataValue("__wf__child"+i) %>'","employeeid","langon"),setChild<%=i%>);</script></td>
                    <td ><% if(screenSingle.getUProfile().get("lang").equalsIgnoreCase("THA")){out.print(md.getWFDataValue("__wf__institute"+i+"t"));}else{out.print(md.getWFDataValue("__wf__institute"+i+"e"));}%></td>                    
                    <td class="style2" ><span id="degree<%=i%>name"></span><script language="javascript">SearchDWR.search1(new Array("mdegree","degreeid,tdesc,edesc","degreeid = '<%= md.getWFDataValue("__wf__educate"+i) %>' ","degreeid","langon"),setDegree<%=i%>);</script></td>
                    <td class="style2" ><div align="center"><%=md.getWFDataValue("__wf__term"+i).substring(0,md.getWFDataValue("__wf__term"+i).indexOf("/"))%>	</div></td>                    
                    <td class="style2" > <div align="right">
                      <%
									a_amount1=md.getWFDataValue("__wf__actual_amount"+i).replaceAll(",", "");
									r_amount1=md.getWFDataValue("__wf__request_amount"+i).replaceAll(",", "");
									if(a_amount1.length()==0)
										a_amount1="0.00";
									if(r_amount1.length()==0)
										r_amount1="0.00";
										totalAmt+=Double.parseDouble(a_amount1);
										totalReal+=Double.parseDouble(r_amount1);
										r_amount1=df.format(Double.parseDouble(r_amount1));
										a_amount1=df.format(Double.parseDouble(a_amount1));
										
						%>		
                      <%=a_amount1.substring(0,a_amount1.indexOf(".")) %></div></td>
                    <td class="style2" ><div align="right"><%=a_amount1.substring(a_amount1.indexOf(".")+1) %></div></td>
                    <td class="style2" ><div align="right"><%=r_amount1.substring(0,r_amount1.indexOf(".")) %></div></td>
                    <td class="style2" ><div align="right"><%=r_amount1.substring(r_amount1.indexOf(".")+1) %></div></td>
                  </tr>
				  <%
				  }else{
				  %>
                  <tr class="style2">
                    <td height="23"  class="style2">&nbsp;</td>
                    <td class="style2" >&nbsp;</td>
                    <td class="style2" >&nbsp;</td>                    
                    <td class="style2" >&nbsp;</td>
                    <td class="style2" >&nbsp;</td>                    
                    <td class="style2" >&nbsp;</td>
                    <td class="style2" >&nbsp;</td>
                    <td class="style2" >&nbsp;</td>
                    <td class="style2" >&nbsp;</td>
                  </tr>
				  <%
				  }
			}
				  %> 
                  <tr class="style2">
                    <td height="23" colspan="5" align="center"  class="style2"   bgcolor="#CCCCCC"><div align="right">รวมเป็นเงิน</div></td>
					<%r_amount1=df.format(totalReal);a_amount1=df.format(totalAmt);%>
                    <td class="style2" align="center"><div align="right"><%=a_amount1.substring(0,a_amount1.indexOf(".")) %></div></td>
                    <td class="style2" ><div align="right"><%=a_amount1.substring(a_amount1.indexOf(".")+1) %></div></td>
                    <td class="style2" ><div align="right"><%=r_amount1.substring(0,r_amount1.indexOf(".")) %></div></td>
                    <td class="style2" ><div align="right"><%=r_amount1.substring(r_amount1.indexOf(".")+1) %></div></td>
                  </tr>
				  <%CurrencyToThai ct=new CurrencyToThai();%>
                  <tr class="style2">
                    <td height="23" colspan="7" align="center"  class="style2" >(<%=ct.getStringAvancedDesc(totalAmt,"###.00")%>)&nbsp;</td>
                    <td class="tablelayout200" >&nbsp;</td>
                    <td class="tablelayout200" >&nbsp;</td>
                  </tr>
                </table>
			  </div>
			  <br>
			  <table width="272" cellpadding="0" cellspacing="0" class="tablelayout">
                <tr class="style2" >
                  <td width="50%"class="tablelayout200">
				  <div ><strong>ข้าพเจ้ารับรองว่าข้อความดังกล่าวข้างต้นเป็นจริงทุกประการ<br>
				    และได้แนบเอสารประกอบการจ่ายดังนี้ </strong></div>
				 <div class="style2"> &nbsp;<input type="checkbox" name="c1">ในเสร็จรับเงิน จำนวน.......ฉบับ</div>
				 <div class="style2" >&nbsp;<input type="checkbox" name="c1">หนังสือรับรอง/ประกาศอัตราค่าเล่าเรียนของสถานศึกษา จำนวน.......ฉบับ</div>
				 <div class="style2"> &nbsp;<input type="checkbox" name="c1">สำเนาสูติบัตร (กรณีเบิกครั้งแรก) จำนวน.......ฉบับ</div>
				  <div class="style2">&nbsp;<input type="checkbox" name="c1">อื่นๆ  ระบุ......................................................................</div>		
				  <br>
				  <br>
				  <div class="style2" align="center">ลงชื่อ..................................................</div>
				  <div class="style2" align="center">(<span id="spfullname2"></span>)</div>
				  <div class="style2" align="center">วันที่.......................................</div></td>
                </tr>
              </table>    
			  <br>
			    <%
										DbInquiry history_di = (DbInquiry)screenSingle.getRecord().getChild("VW_INCIDENT");
										history_di.next();
					  %>
			  <table width="272" cellpadding="0" cellspacing="0" class="tablelayout">
                <tr class="style2"  align="center">
                  <td width="36%"class="tablelayout200"><div ><strong>การตรวจสอบเอกสารของงานบุคคล</strong></div>
                      <div class="style2" align="left">เรียน ผช.ผู้จัดการ/ผู้จัดการภาค </div>
                      <div class="style2" &nbsp;>ได้ตรวจสอบเอกสารหลักฐานที่เสนอมาแล้วเห็นควรอนุมัติ</div>
					<br>
                     <br>
                     <br>
                    <div class="style2">
                      <div class="style2">ลงชื่อ.....................................</div>
                      <div class="style2">(<%
					  							String posname="";	
					  							if(history_di.getString("ai_status").equals("2") &&history_di.getString("step_id").equals("2") ){
														DbRecord vwactor = new InitialRecord(screenSingle.getUProfile()).getDbRecord("Memployee");
														vwactor.setColumn("employeeid,fname,lname,efname,elname,emp_prefix,emp_position");
														vwactor.set("COMPANYID",screenSingle.getUProfile().get("companyid"));
														vwactor.set("EMPLOYEEID",history_di.getString("ACTOR_ID"));
														vwactor.search();		
														out.print(vwactor.getString("fullname"));
														posname=vwactor.getString("positionname");
										}
										%>)</div>
                      <div class="style2">ตำแหน่ง&nbsp;<%=posname%></div>
                      <div class="style2">วันที่.....................................</div>
                    </div><br>
				</td>
                  <td width="32%" align="center"  class="tablelayout200"><div><strong>การอนุมัติ</strong></div>
                      <div class="style2">อนุมัติให้เบิกจ่ายได้</div>
                      <br>
                       <br>
                       <br>
                       <br>
                    <div class="style2">ลงชื่อ.....................................</div>
                    <div class="style2">(<% history_di.next();
												if(history_di.getString("ai_status").equals("2") &&history_di.getString("step_id").equals("2") ){
														DbRecord vwactor = new InitialRecord(screenSingle.getUProfile()).getDbRecord("Memployee");
														vwactor.setColumn("employeeid,fname,lname,efname,elname,emp_prefix,emp_position");
														vwactor.set("COMPANYID",screenSingle.getUProfile().get("companyid"));
														vwactor.set("EMPLOYEEID",history_di.getString("ACTOR_ID"));
														vwactor.search();		
														out.print(vwactor.getString("fullname"));
														posname=vwactor.getString("positionname");
										}
					%>)</div>
                    <div class="style2">ตำแหน่ง&nbsp;<%=posname%>)</div>
                    <div class="style2">วันที่.....................................</div>
                    <br>
				</td>
                  <td width="32%" align="center"  class="tablelayout200">
				  <div><strong>ผู้รับเงิน</strong></div>
				   <div class="style2">ข้าพเจ้าได้รับเงินช่วยเหลือค่าการศึกษาบุตร</div>
				   <div class="style2">จำนวนเงิน <%=df.format(totalReal)%> บาท </div>
				   <div class="style2">(<%=ct.getStringAvancedDesc(totalReal,"###.00")%>)</div>
				   <br>
				   <br>
				   <div class="style2">ลงชื่อ.....................................</div>				 
				   <div class="style2">(<span id="spfullname3"></span>)</div>
				   <div class="style2">ตำแหน่ง <span id="sppositionname2"></span></div>
				   <div class="style2">วันที่.....................................</div>
				   <br>
				</td>					
                </tr>
              </table>
			   <script language="Javascript">setSpanEmp('<%=md.getWFDataValue("__wf__employeeid")%>');</script>
			   <br>
			   <div align="left">
               <table width="288" cellpadding="0" cellspacing="0" class="tablelayout300" >
                 <tr class="style2"  align="center">
                   <td width="36%"class="tablelayout200">
				   <%
    	    	           AdjustBudget adj=new AdjustBudget(screenSingle.getUProfile());
	    	    	        String str[]=adj.getBudgetUsed(md.getWFDataValue("__wf__employeeid"),screenSingle.getDataLabel("DOC_NO"),"");
				   %>
				   <div class="style2" align="left">รหัสโครงการ&nbsp;&nbsp;<%=str[0]%></div>
				   <div class="style2" align="left">งบปรมาณ&nbsp;&nbsp;<%=df.format(Double.parseDouble(str[1]))%></div>
				   <div class="style2" align="left">ใช้ไปสะสม&nbsp;&nbsp;<%=df.format(Double.parseDouble(str[2]))%></div>
				   <div class="style2" align="left">เบิกจ่ายครั้งนี้&nbsp;&nbsp;<%=df.format(Double.parseDouble(str[4]))%></div>
				   <div class="style2" align="left">งบประมาณคงเหลือ&nbsp;&nbsp;<%=df.format(Double.parseDouble(str[3]))%></div>
				   <div class="style2" align="left">(<%=ct.getStringAvancedDesc(totalReal,"###.00")%>)</div>
                   </td>
                 </tr>
               </table>
			   </div>
  </div>
  
</div>
</form>
</body>
<%}%>
</html>