<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.databean.*,com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.system.*,com.csc.library.utilities.*,java.text.*,com.csc.library.session.*"%>
<jsp:useBean id="AS004_1" class="com.csc.library.system.Task" scope="page" />

<%@ include file="../CHECKPROFILE.jsp" %>
<%AS004_1.setChannel(request, response);%>
<%EmvHelpEntry screen = (EmvHelpEntry) AS004_1.process("EmvHelpEntry","AS004_5");%>


<%	CheckNull ck = new CheckNull(); 
        

	String filter = "";


	CscCalendar cDate = new CscCalendar();
	DbInquiry taps0 = new InitialInquiry(screen.getUProfile()).getDbInquiry("TAPSTRAN0");
	taps0.setColumn("apsid,apsperiodstart,apsperiodend");
	String f1="apsperiodend >= '"+cDate.getYYYYMMDD()+"'   AND";
		f1+=" apsperiodstart <='"+cDate.getYYYYMMDD()+"'  ";
	taps0.setFilter("");

	taps0.refresh();
	String dateExp = "apsid=''";
	while(taps0.next()){
		if(taps0.recNo()==1){
			dateExp = "(apsid='"+taps0.getString("apsid")+"'";
		}else{
			dateExp +=" OR apsid='"+taps0.getString("apsid")+"' ";
		}
	}

	if(!dateExp.equals("apsid=''")){dateExp+=")";}
		screen.inq.setFilter(dateExp+"  AND astid = 'AP30' AND (apsassessor='"+screen.getUProfile().get("employeeid")+"' OR  APSAPPROVE1='"+screen.getUProfile().get("employeeid")+"'  OR APSAPPROVE2='"+screen.getUProfile().get("employeeid")+"') "+filter);
		((Simtapstran_kkb1)screen.inq.getCurrentDbRecord()).approveConfirm();	
	 String desc ="tdesc";
	 if(!screen.getUProfile().get("lang").equals("tha"))desc="edesc";


	//out.println("<br><br>filter : " + screen.getInquiry().getFilter());

%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" ng-app="myHR">
	<head>

		<title>Employee View</title>

		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

	</head>
	<body>
		<div class="bg-com"></div>	
		<jsp:include page="EMV_HEADMENU.jsp" flush="true" />

		<script type="text/javascript">
		<!--
			setLang("<%=screen.getUProfile().get("lang")%>");
			var swap = new swaplang();
            var titlename = swap.swap2String("SW002251");
			setPageTitle(titlename);
			
			function goHelp(helpName,inputName){
				var helpReturn;
				var temp_fixCon;
				if(inputName=="__bu1" )
					helpReturn="__bu1:bu1id,MBU1@TDESC";
				else if(inputName=="__bu2" )
					helpReturn="__bu2:bu2id,MBU2@TDESC";	
				else if(inputName=="__bu3" )
					helpReturn="__bu3:bu3id,MBU3@TDESC";	
			temp_fixCon = document.cscform.__fixCon.value;
			document.cscform.__fixCon.value="";
			linkHelp_Return(helpName,helpReturn);
			
			document.cscform.__fixCon.value=temp_fixCon;
			
			
			}
			function fixSearch(){
				with(document.cscform){
					__shown.value="1";
					submit();
				}
			}
			function goConfirm(){
				with(document.cscform){
					__status.value="A";
					__cmd.value="ack";		
					submit();
			
				}
			}

			function goReturn(){
				with(document.cscform){
					__status.value="R";	
					__cmd.value="ack";		
					submit();
				}
			}
			function goCheck(emp_group,fieldName){
					with(document.cscform){
						var param="AS004_2C1.jsp?__emp_group="+emp_group+"&__fieldName="+fieldName+"&__bu1="+__bu1.value+"&__bu2="+__bu2.value;	
						win = window.open(param,"AS004_2C1","left=50,top=50,width=750,height=650,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
						if(window.focus){win.focus();}
					}
			}
			function goASP(apsid,apsassessor,apsassessy,tid){
				with(document.cscform){		//action="ASP705.jsp?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level="+level+"&bu1="+__bu1.value+"&bu2="+__bu2.value+"&isread=0"+"&astid="+tid;	

				//	submit();
					var param="APP_EMV705.jsp?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level=1&bu1=&bu2=&isread=0"+"&astid="+tid;	
					win =window.open(param,"APP_EMV705","left=50,top=50,width=1100,height=750,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
					if(window.focus){win.focus();}
				}

			}
			function goReASP(apsid,apsassessor,apsassessy,tid){
				with(document.cscform){		//action="ASP705.jsp?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level="+level+"&bu1="+__bu1.value+"&bu2="+__bu2.value+"&isread=1"+"&astid="+tid;	
				//	submit();
					var param="APP_EMV705.jsp?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level=1&bu1=&bu2=&isread=1"+"&astid="+tid;	
					win =window.open(param,"APP_EMV705","left=50,top=50,width=1100,height=750,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
					if(window.focus){win.focus();}
				}

			}
			function calAge(strDate){
				var currentYear = parseInt(new Date().getYear());
				var birthdateYear = parseInt(strDate.substring(6,10));
				var age = currentYear-birthdateYear;
				document.write(age);
			}	
		//-->
		</script>
		
		<section>
			<div class="container csc-content">
				<form name="cscform" class="form-horizontal" method="post" action="?">
					<input type="hidden"name="__screen"  value="AS004_5">
					<input type="hidden" name="__help" value="">
					<input type="hidden" name="__cmd"  value="">
					<input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>"> 
					<input type="hidden" name="__fixCon" value="">
					<input type="hidden" name="__orderBy" value="">
					<input type="hidden" name="__tdesc" value="">
					<input type="hidden" name="__apsobjective" value="">
					<input type="hidden" name="__shown" value="<%=ck.chkNullString(request.getParameter("__shown"),"")%>">
				    <input type="hidden" name="__updatefield" value="APSSTATUS">
					<input type="hidden" name="__returnfield" value="">
					<input type="hidden" name="__status" value="">
				    <input type="hidden" name="__apsid" value="<%=ck.chkNullString(request.getParameter("__apsid"),"")%>">

					<div class="table-responsive">
						<table class="table table-head table-hover table-bordered table-title-left table-content-center">
							<thead>
								<tr>
									<th class="table-title " colspan=13 swlang code='SW002251'>Apprisal Information Competency</th>
								</tr>
							</thead>
						
								<tr>
									<th swlang code='SW000193'>Seq</th>
									<th swlang code='SW000019'>Status</th>
									<th swlang code='SW000021'>Assessy</th>
									<th><%=screen.getLabel("memployee","bu1")%></th>
									<th><%=screen.getLabel("memployee","bu2")%></th>
									<th swlang code='SW000230'>Service Year</th>
									<th swlang code='SW000172'>Age</th>
								</tr>
							<% 
								int  recCount=0;
								int checkAPS=1;

			
								screen.inq.refresh();
								screen.inq.next();
								int running=0;
								double a_per,b_per,c_per,to_per;
								String old_group,cur_group;
								String workage="";
								String sty="",fieldN="";
								boolean nextRec,end;
								recCount =screen.inq.recCount();
								DecimalFormat dc = new DecimalFormat();
								dc.applyPattern("#0.00");
								if(recCount>0){
									nextRec=true;
									end=true;
									while(end){
									 checkAPS=1;
							%>
				
								<tr>
									<td colspan="8" class="table-title"> 
										<label swlang code='SW000507'>Employee Group Code </label>
										&nbsp;&nbsp;:&nbsp;<%=screen.getDataLabel("mgroup","tdesc")%>
									</td>         
								
									<%
										old_group = screen.inq.getString("bu1");	
										cur_group = screen.inq.getString("bu1");	
										nextRec=true;
										old_group = screen.inq.getString("emp_group");	
										cur_group = screen.inq.getString("emp_group");	
										running=0;
											while(nextRec){
		
									%>

								<tr>
									<td>
									<%=++running%>
									</td>
									<td>
										<%if((screen.getDataLabel("apsstatus").equals(""))||(screen.getDataLabel("apsstatus").equals("0"))||(screen.getDataLabel("apsstatus").equals("R"))){%>			
											 <span class="style1"><%=screen.inq.getCurrentDbRecord().getSystemCode("apsstatus")%></span>
										<%}else{
											if(screen.getDataLabel("apsstatus").equals("A")){%>
												<span class="style2"><%=screen.inq.getCurrentDbRecord().getSystemCode("apsstatus")%></span>
											<%}else{%>
												<%=screen.inq.getCurrentDbRecord().getSystemCode("apsstatus")%>
											<%}
										}%>
									</td>
									<td>
										<%if(!screen.getDataLabel("APSSTATUS").equals("A")){%>
											<%="<A  href=\"javascript:goASP('"+screen.getDataLabel("APSID")+"','"+screen.getDataLabel("APSASSESSOR")+"','"+screen.getDataLabel("APSASSESSY")+"','"+screen.getDataLabel("ASTID")+"');\">"+screen.getDataLabel("simemp","fullname")+"</A>"%>
										<%}else{%>
											<%="<A  href=\"javascript:goReASP('"+screen.getDataLabel("APSID")+"','"+screen.getDataLabel("APSASSESSOR")+"','"+screen.getDataLabel("APSASSESSY")+"','"+screen.getDataLabel("ASTID")+"');\">"+screen.getDataLabel("simemp","fullname")+"</A>"%>
										<%}%>
									</td>

									
									<td><%=screen.getDataLabel("mbu2","tdesc")%></td>
									<td><%=screen.getDataLabel("mposition","tdesc")%></td>
										 <%
											workage=screen.getDataLabel("simemp","empworkages");
											String[] y = workage.split(" ");	
										 %>

									<td>
										<%=y[0]+"/"+y[2] %>
									</td>
									<td><script>calAge("<%=screen.getDataLabel("simemp","birthday")%>");</script></td>

								</tr>

								<%
				 					if(!screen.inq.next()){
									end=false;
									nextRec = false;
									}
									cur_group= screen.inq.getString("emp_group");
									if(!cur_group.equals(old_group))nextRec = false;
					
					
											 } // end while
											 %>

							
							 <%			
					
											 } // while
										}// if	
									%>
						</table>
					</div>
					<%=screen.endJSP()%>
					
				</form>
			</div>
			<a href="#top" id="top-button">
				<i class="fa fa-angle-up"></i>
				<div class="top-word">Back to top</div>
			</a>
		</section>
		<jsp:include page="FOOTER.jsp" flush="true" />
	</body>
</html>