<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.databean.*,com.csc.library.session.*,com.csc.library.database.*,com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.utilities.*,java.text.*"%>
<jsp:useBean id="AS004_2" class="com.csc.library.system.Task" scope="page" />
<%@ include file="../CHECKPROFILE.jsp" %>
<%AS004_2.setChannel(request, response);%>
<%EmvHelpEntry screen = (EmvHelpEntry) AS004_2.process("EmvHelpEntry","AS004_2");%>

<%	CheckNull ck = new CheckNull(); 
String employeeid=screen.getUProfile().get("employeeid");
String fullname=screen.getUProfile().get("fullname");
if(!ck.chkNullString(request.getParameter("__employeeid"),"").equals("")){
	employeeid= request.getParameter("__employeeid");
	DbInquiry emp_full = new InitialInquiry(screen.getUProfile()).getDbInquiry("MEMPLOYEE");
	emp_full.setColumn("employeeid,prefix,fname,lname");
	emp_full.setFilter("employeeid='"+employeeid+"'");

	emp_full.refresh();
	emp_full.next();
	fullname = emp_full.getString("fullname");
}
String sbu1,sbu2,sbu3,spos,ssor,sSwork,sEwork,sSage,sEage;  //APSASSESSOR
sbu1=ck.chkNullString(request.getParameter("__bu1"),"");
sbu2=ck.chkNullString(request.getParameter("__bu2"),"");
sbu3=ck.chkNullString(request.getParameter("__bu3"),"");
spos=ck.chkNullString(request.getParameter("__pos"),"");
ssor=ck.chkNullString(request.getParameter("__sor"),"");

sSwork=ck.chkNullString(request.getParameter("__startWorkAge"),"");
sEwork=ck.chkNullString(request.getParameter("__endWorkAge"),"");

sSage=ck.chkNullString(request.getParameter("__startAge"),"");
sEage=ck.chkNullString(request.getParameter("__endAge"),"");

ThaiUtilities thai = new ThaiUtilities();

String filter = "";
if(!sbu1.equals(""))filter =" and bu1='"+sbu1+"'";

if(!sbu2.equals(""))filter =filter+" and bu2='"+sbu2+"'";

if(!sbu3.equals(""))filter =filter+" and bu3='"+sbu3+"'";

if(!spos.equals(""))filter =filter+" and emp_position='"+spos+"'";

if(!ssor.equals(""))filter =filter+" and apsassessor='"+ssor+"'";

if((!sSwork.equals(""))&&(!sEwork.equals(""))){
	filter =filter+" and  APSASSESSY in (select employeeid from memployee where startdate <='"+sSwork+"'  and startdate >='"+sEwork+"' and  status='A') ";

}

if((!sSage.equals(""))&&(!sEage.equals(""))){
		filter =filter+" and  APSASSESSY in (select employeeid from memployee where BIRTHDAY <='"+sSage+"'  and BIRTHDAY >='"+sEage+"'  and  status='A') ";
}

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

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='AP10' AND APSAPPROVE1='"+employeeid+"'"+filter);	
if(!ck.chkNullString(request.getParameter("__orderBy"),"").equals("")){
	screen.inq.setOrderBy(request.getParameter("__orderBy"));
}
((Simtapstran_kkb)screen.inq.getCurrentDbRecord()).approveConfirm();		
 String desc ="tdesc";
 if(!screen.getUProfile().get("lang").equals("tha"))desc="edesc";
 DataSet dsBu1 = new DataSet("Select Distinct apsapprove1,BU1 ,MBU1.TDESC AS TDESC, MBU1.EDESC AS EDESC from TAPSTRAN , MBU1 where  "+dateExp+" and TAPSTRAN.astid='AP10' and TAPSTRAN.bu1=MBU1.bu1id and  apsapprove1='"+employeeid+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
// "032299"+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
dsBu1.initConnection(screen.getUProfile());

 DataSet dsBu2 = new DataSet("Select Distinct apsapprove1,BU2,MBU2.TDESC AS TDESC, MBU2.EDESC AS EDESC from TAPSTRAN, MBU2 where  "+dateExp+" and TAPSTRAN.astid='AP10' and TAPSTRAN.bu2=MBU2.bu2id and  apsapprove1='"+employeeid+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
//"032299"+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
dsBu2.initConnection(screen.getUProfile()); 


DataSet dsBu3 = new DataSet("Select Distinct apsapprove1,BU3,MBU3.TDESC AS TDESC, MBU3.EDESC AS EDESC from TAPSTRAN, MBU3 where  "+dateExp+" and TAPSTRAN.astid='AP10' and TAPSTRAN.bu3=MBU3.bu3id and  apsapprove1='"+employeeid+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
dsBu3.initConnection(screen.getUProfile());

DataSet dsPos = new DataSet("Select Distinct apsapprove1,emp_position,POSITIONID,MPOSITION.TDESC AS TDESC, MPOSITION.EDESC AS EDESC from TAPSTRAN, MPOSITION where  "+dateExp+" and TAPSTRAN.astid='AP10' and TAPSTRAN.emp_position=MPOSITION.POSITIONID and  apsapprove1='"+employeeid+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
dsPos.initConnection(screen.getUProfile());


DataSet dsSor = new DataSet("Select Distinct apsapprove1,APSASSESSOR,MEMPLOYEE.FNAME AS TDESC, MEMPLOYEE.EFNAME AS EDESC from TAPSTRAN, MEMPLOYEE where  "+dateExp+" and TAPSTRAN.astid='AP10' and TAPSTRAN.APSASSESSOR=MEMPLOYEE.EMPLOYEEID and  apsapprove1='"+employeeid+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
dsSor.initConnection(screen.getUProfile());
%>
<!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("SW002249");
			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";	
				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){
					chkDate(__workage1,__workage2,__startWorkAge,__endWorkAge);
					genDate(__workage1,__startWorkAge);
					genDate(__workage2,__endWorkAge); 

					chkDate(__age1,__age2,__startAge,__endAge);
					genDate(__age1,__startAge); 
					genDate(__age2,__endAge); 
					//__age1
					__shown.value="1";		
					submit();
				}
			}
				function chAll(){
					with(document.cscform){
						for(i=0;i<elements.length;i++){
								if(elements[i].type=="checkbox"){
									if(elements[i].checked){
										var listData = elements[i].value.split(":");							
										if((listData[6]=='')||(listData[6]=='0')){								
											return false;
										}

									}
								}
						}//end for
						return true;
					}//end with
				}//end function
			function goConfirm(){
			if(chAll()){
				with(document.cscform){
					__status.value="A";
					__cmd.value="ack";		
					submit();	
				}
			}else{
				alert("ไม่สามารถยืนยันพนักงานที่ไม่มีเกรดได้");
			}
			}
			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+"&__appfield="+"APSAPPROVE1&__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 goASP700(apsid,apsassessor,apsassessy){
				with(document.cscform){
					//action="ASP700.jsp?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level=2&bu1="+__bu1.value+"&bu2="+__bu2.value+"&isread=0";
					//submit();
					var param="APP_EMV700.jsp?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level=2&bu1="+__bu1.value+"&bu2="+__bu2.value+"&isread=0";
					win =window.open(param,"APP_EMV700","left=50,top=50,width=1100,height=750,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
						if(window.focus){win.focus();}

				}

			}
			function goReASP700(apsid,apsassessor,apsassessy){
				with(document.cscform){
					//action="ASP700.jsp?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level=2&bu1="+__bu1.value+"&bu2="+__bu2.value+"&isread=1";
					//submit();
					var param="APP_EMV700.jsp?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level=2&bu1="+__bu1.value+"&bu2="+__bu2.value+"&isread=1";
					win =window.open(param,"APP_EMV700","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);
			}

			function setOrder(field){
				with(document.cscform){
					__orderBy.value+=","+field;
					fixSearch();
				}
			}

			function goConfirm1(){

				var returnVal = true;
				with(document.cscform){

					for(i=0;i<elements.length;i++){
						if(elements[i].name.indexOf("__lineg")>=0){				
							if(elements[i].options[elements[i].selectedIndex].value==""){
								elements[i].disabled="disabled";
							}
						}
					}
				}
				
				goConfirm();
				
			}

			 function genDate(obj,nameOut){	
				with(document.cscform){
				var sYear,sMonth,sDate;
					var nDate= new Date();
					var outDate= new Date();
					sDate= nDate.getDate();

					sMonth=nDate.getMonth()+1;
					sYear=nDate.getFullYear();
					var sAge = obj.value.split(".");
					if(sAge[1]>sMonth){
						sYear = sYear-1; 
						sMonth = (sMonth+12)-sAge[1];
						sYear = sYear-sAge[0] ;
						outDate.setFullYear(sYear,sMonth-1,1);	
					}else{
						if(sAge[1]==sMonth){
							sYear = sYear-1; 
							sYear = sYear-sAge[0] ;
							outDate.setFullYear(sYear,12,1);	
						}else{
							sMonth =sMonth-sAge[1];
							sYear = sYear-sAge[0] ;			
							outDate.setFullYear(sYear,sMonth,1);				
						}
					}
					sMonth=outDate.getMonth();
					if(sMonth<10)sMonth='0'+sMonth;
					nameOut.value=outDate.getFullYear()+'-'+sMonth+'-0'+outDate.getDate();		

				}
			}
			function chMonth(sInput){
				with(document.cscform){
					var data = sInput.value.split(".");
					if(data[1]>11){
						sInput.value=data[0]+"."+"0"+data[1];
						sInput.value=sInput.value.substring(0,sInput.value.length-1)	;	
					}
				}
			}
			function chkDate(start,end,setStart,senEnd){
				with(document.cscform){
					if(!((start.value=='0.00')&&(end.value=='0.00'))){
							chMonth(start);
							chMonth(end);				
							if(start.value==end.value){
								start.value='0.00';
							}
					}else{
						setStart.disabled='disabled';
						senEnd.disabled='disabled';
					}

				}
			}
			function chk(inbo,grad){
				with(document.cscform){
				//	alert(inbo.value);
									var grad_1 ="";		
									for(i=0;i<elements.length;i++){	
										if(elements[i].name==grad){
											grad_1=elements[i].value.split(':')[1];
			//								alert(grad_1);
											if(inbo.checked){
												if((typeof grad_1)=="undefined"){						
														alert('  โปรดให้เกรดพนักงาน  ');
														inbo.checked='';
												}else{
												elements[i].disabled='disabled';
												}
											}else{
												elements[i].disabled='';
											}
										}
									}				
						if((typeof grad_1)!="undefined"){						
							
						var tmp =inbo.value.split(':');
						var data='';
						for(i=0;i<tmp.length;i++){
								if(i==tmp.length-1){
								data=data+grad_1;
								}else{
									data=data+tmp[i]+':';
								}				
						}
					inbo.value=data;	
				//	alert(inbo.value);
					}
				}
			}
			

		</script>
		
		<section>
			<div class="container csc-content">
				<form name="cscform" class="form-horizontal" method="post" action="?">
					<%=screen.InitialVariable()%>
					<input type="hidden"name="__screen"  value="AS004_2">
					<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="emp_group">
					<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="APSAPPSTATUS1">
					<input type="hidden" name="__returnfield" value="APSSTATUS">
					<input type="hidden" name="__status" value="">
					<input type="hidden" name="__employeeid" value="<%=ck.chkNullString(request.getParameter("__employeeid"),"")%>">
					<input type="hidden" name="__update" value="">
					
					<div class="csc-block">
						<div class="center">
							<h2 class="csc-block-head" swlang code='SW002249'>Apprisal Information Lv2</h2> 
						</div>
					
						<div class="form-horizontal">
							<div class="row">
								<div class="form-group">
									<div class="col-md-1 col-sm-1 col-xs-1"></div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label label-right" swlang code='SW000020'>Assessor</label> 
									</div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label"><%=fullname%></label>
									</div>
									
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label label-right"><%=screen.getLabel("memployee","bu1")%></label>
									</div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<select class="form-control" name="__bu1" id="select">
											<option value=""></option>
											<%while(dsBu1.next()){	%>
											<option value="<%=dsBu1.getString("bu1")%>" <%=(sbu1.equals(dsBu1.getString("bu1")))?"selected":""%>><%=dsBu1.getString(desc)%></option>
											<%}%>
										</select>  
									</div>
								</div>
							</div>
							
							<div class="row">
								<div class="form-group">
									<div class="col-md-1 col-sm-1 col-xs-1"></div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label label-right"><%=screen.getLabel("memployee","bu2")%></label>
									</div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<select class="form-control" name="__bu2" id="select">
											<option value=""></option>
											<%while(dsBu2.next()){	%>
											<option value="<%=dsBu2.getString("bu2")%>" <%=(sbu2.equals(dsBu2.getString("bu2")))?"selected":""%>><%=dsBu2.getString(desc)%></option>
											<%}%>
										</select>
									</div>
									
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label label-right"><%=screen.getLabel("memployee","bu3")%></label>
									</div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<select class="form-control" name="__bu3" id="select">
											<option value=""></option>
											<%while(dsBu3.next()){	%>
											<option value="<%=dsBu3.getString("bu3")%>" <%=(sbu3.equals(dsBu3.getString("bu3")))?"selected":""%>><%=dsBu3.getString(desc)%></option>
											<%}%>
										</select>
									</div>
								</div>
							</div>
							
							<div class="row">
								<div class="form-group">
									<div class="col-md-1 col-sm-1 col-xs-1"></div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label label-right"><%=screen.getLabel("emp_position")%> </label>
									</div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<select class="form-control" name="__pos" id="__pos">
											<option value=""></option>
											<%while(dsPos.next()){	%>
											<option value="<%=dsPos.getString("positionid")%>" <%=(spos.equals(dsPos.getString("positionid")))?"selected":""%>><%=dsPos.getString(desc)%></option>
											<%}%>
										</select>
									</div>
									
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label label-right" swlang code='SW000020'>assessor</label>
									</div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<select class="form-control" name="__sor" id="__sor">
											<option value=""></option>
											<%while(dsSor.next()){	%>
											<option value="<%=dsSor.getString("apsassessor")%>" <%=(ssor.equals(dsSor.getString("apsassessor")))?"selected":""%>><%=dsSor.getString(desc)%></option>
											<%}%>
										</select>
									</div>
								</div>
							</div>
							
							<div class="row">
								<div class="form-group">
									<div class="col-md-1 col-sm-1 col-xs-1"></div>
									<div class="col-md-2 col-sm-2 col-xs-2"> 
										<label class="control-label label-right" swlang code='SW000230'>Service Year</label>
									</div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<INPUT class="form-control" TYPE='text' Name='__workage1' id='__workage1' MAXLENGTH='6' VALUE='0.00'  onClick="" onChange=""  onKeyPress="checkWordNumber(this.value);" onKeyUp="sysIsEdit();checkComma(this,2);" dir="" onBlur="chkLengthFloat1(this,__workage2,90)" onFocus="callDelComma(this);" alt="อายุงาน" >
									</div>
									
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label label-right" swlang code='SW002095'>to</label>
									</div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<INPUT class="form-control" TYPE='text' Name='__workage2' id='__workage2' MAXLENGTH='6' VALUE='0.00'  onClick="" onChange=""  onKeyPress="checkWordNumber(this.value);" onKeyUp="sysIsEdit();checkComma(this,2);" dir="" onBlur="chkLengthFloat2(this,__workage1,90);" onFocus="callDelComma(this);" alt="อายุ"  >
									</div>
									<input type="hidden" name="__startWorkAge" id="__startWorkAge">
									<input type="hidden" name="__endWorkAge" id="__endWorkAge">
								</div>
							</div>
							
							<div class="row">
								<div class="form-group">
									<div class="col-md-1 col-sm-1 col-xs-1"></div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label label-right" swlang code='SW000172'>Age</label>
									</div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<INPUT class="form-control" TYPE='text' Name='__age1' MAXLENGTH='6' VALUE='0.00'  onChange="javaScript:genDate(this,'__startWorkAge');"  onKeyPress="checkWordNumber(this.value);" onKeyUp="sysIsEdit();checkComma(this,2);" dir="" onBlur="chkLengthFloat1(this,__age2,90);" onFocus="callDelComma(this);" alt="อายุ"  >
									</div>
									
									<div class="col-md-2 col-sm-2 col-xs-2">
										<label class="control-label label-right" swlang code='SW002095'>to</label>
									</div>
									<div class="col-md-2 col-sm-2 col-xs-2">
										<INPUT class="form-control" TYPE='text' Name='__age2' MAXLENGTH='6' VALUE='0.00'  onClick="javaScript:genDate(this,'__endkAge');" onChange=""  onKeyPress="checkWordNumber(this.value);" onKeyUp="sysIsEdit();checkComma(this,2);" dir="" onBlur="chkLengthFloat2(this,__age1,90);" onFocus="callDelComma(this);" alt="อายุ"  >
									</div>
									<input type="hidden" name="__startAge" id="__startAge">
									<input type="hidden" name="__endAge" id="__endAge">
								</div>
							</div>
							
							<div class="center">
								<a class="btn btn-primary" href="javascript:fixSearch();" swlang code='SW003537'>Search</a>
							</div>
						</div>
					</div>
					
					<div class="csc-block-white">
						<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='SW002249'>Apprisal Information Lv2</th>
									</tr>
								</thead>
								<% 
										int  recCount=0;
										if(ck.chkNullString(request.getParameter("__shown"),"").equals("1")){
											
											screen.inq.refresh();
											screen.inq.next();
											int running=0;
											double a_per,b_per,c_per,to_per;
											a_per=0.00;
											b_per=0.00;
											c_per=0.00;
											to_per=0.00;
											double a_per_t,b_per_t,c_per_t,to_per_t;
											a_per_t=0.00;
											b_per_t=0.00;
											c_per_t=0.00;
											to_per_t=0.00;						
											String old_group,cur_group;
											String workage="";
											boolean nextRec,end;
											recCount =screen.inq.recCount();
											DecimalFormat dc = new DecimalFormat();
											dc.applyPattern("#0.00");
											if(recCount>0){
												nextRec=true;
												end=true;
												int rowCount = 0;
												while(end){
													rowCount++;
												
								%>
								<tbody>
									<tr>
										<th swlang code='SW000015'>Select</th>
										<th swlang code='SW000019'>Status</th>
										<th swlang code='SW000069'>grade</th>
										<th swlang code='SW000193'>Seq</th>
										<th swlang code='SW012254'>Grade No.1</th>
										<th swlang code='SW000013'>Score</th>
										<th swlang code='SW012255'>Assess 1</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>
										<th swlang code='SW012223'>Discipline</th>
									</tr>
									<tr>
										<td class="table-title " colspan=13><label swlang code='SW000507'>Employee Group Code</label>&nbsp;&nbsp;:&nbsp;<%=screen.getDataLabel("mgroup","tdesc")%></td>
									</tr>
									<%
										old_group = screen.inq.getString("emp_group");	
										cur_group = screen.inq.getString("emp_group");	
										nextRec=true;
										a_per=0;
										b_per=0;
										c_per=0;
										to_per=0;
										while(nextRec){
											
											to_per++;
											to_per_t++;
											if(screen.inq.getString("apsappgrade1").indexOf("A")>=0){
												a_per++;
												a_per_t++;
											}else{
												if(screen.inq.getString("apsappgrade1").indexOf("B")>=0){
													b_per++;
													b_per_t++;
												}else{
													if(screen.inq.getString("apsappgrade1").indexOf("C")>=0){
														c_per++;
														c_per_t++;
													}
												}
											}
									%>
									<tr>
										<td>
											<center>
												<%if(((screen.getDataLabel("APSAPPSTATUS1").equals("R"))||((screen.getDataLabel("APSSTATUS").equals("A"))))&&(!screen.getDataLabel("APSAPPSTATUS1").equals("A"))){%>                    
												<input type="checkbox" name="__ch<%=(++running)%>:APSID:APSASSESSOR:APSASSESSY:APSSTATUS:APSAPPGRADE1" value="<%=screen.getDataLabel("APSID")+":"+screen.getDataLabel("APSASSESSOR")+":"+screen.getDataLabel("APSASSESSY")+":"+screen.getDataLabel("APSSTATUS")+":"+screen.getDataLabel("APSAPPGRADE1")%>" id="__ch<%=running++%>:APSID:APSASSESSOR:APSASSESSY:APSSTATUS:APSAPPGRADE1" align="absmiddle"   onChange="chk(this,'__lineg:<%=screen.getDataLabel("mbu1","bu1id")+":"+screen.getDataLabel("mbu2","bu2id")+":"+screen.getDataLabel("mbu3","bu3id")+":"+screen.inq.getString("emp_group")+":"+screen.inq.getString("APSASSESSY")+":"+screen.getDataLabel("runno") %>')">
												<%}else{%>
												&nbsp;
												<%}%> 
											</center>
										</td>
										<td>
											<%if((screen.getDataLabel("apsappstatus1").equals(""))||(screen.getDataLabel("apsappstatus1").equals("0"))||(screen.getDataLabel("apsappstatus1").equals("R"))){%>
											<span class="style1"><%=screen.getDataLabel("apsappstatus1")%></span>
											<%}else{ if(screen.getDataLabel("apsappstatus1").equals("A")){%>
											<span class="style2"><%=screen.getDataLabel("apsappstatus1")%></span>
											<%}else{%>
											<%=screen.getDataLabel("apsappstatus1")%>
											<%
													}
												}
											%>
										</td>
										<td>
											<%if(((screen.getDataLabel("APSAPPSTATUS1").equals("R"))||((screen.getDataLabel("APSSTATUS").equals("A"))))&&(!screen.getDataLabel("APSAPPSTATUS1").equals("A"))){%>  
											<select class="form-control" id="__lineg:<%=screen.getDataLabel("mbu1","bu1id")+":"+screen.getDataLabel("mbu2","bu2id")+":"+screen.getDataLabel("mbu3","bu3id")+":"+screen.inq.getString("emp_group")+":"+screen.inq.getString("APSASSESSY")+":"+screen.getDataLabel("runno") %>" name="__lineg:<%=screen.getDataLabel("mbu1","bu1id")+":"+screen.getDataLabel("mbu2","bu2id")+":"+screen.getDataLabel("mbu3","bu3id")+":"+screen.inq.getString("emp_group")+":"+screen.inq.getString("APSASSESSY")+":"+screen.getDataLabel("runno") %>" >
												<%
													String  select =""; //selected
													String  A1,A2,A3,B1,B2,B3,B4,B5,C1,C2;
													A1=A2=A3=B1=B2=B3=B4=B5=C1=C2="";
														if(screen.getDataLabel("apsappgrade1").equals("A1")){
															A1="selected";
														}else
															if(screen.getDataLabel("apsappgrade1").equals("A2")){
															A2="selected";
														}else
															if(screen.getDataLabel("apsappgrade1").equals("A3")){
															A3="selected";
														}else	if(screen.getDataLabel("apsappgrade1").equals("B1")){
															B1="selected";
														}else
															if(screen.getDataLabel("apsappgrade1").equals("B2")){
															B2="selected";
														}else
															if(screen.getDataLabel("apsappgrade1").equals("B3")){
															B3="selected";
														}else
														if(screen.getDataLabel("apsappgrade1").equals("B4")){
															B4="selected";
														}else
															if(screen.getDataLabel("apsappgrade1").equals("B5")){
															B5="selected";
														}else
															if(screen.getDataLabel("apsappgrade1").equals("C1")){
															C1="selected";
														}else
														if(screen.getDataLabel("apsappgrade1").equals("C2"))
															C2="selected";

												%>	
												<option value=""></option>                       
												<option value="apsappgrade1:A1"  <%=A1%> >A1</option>
												<option value="apsappgrade1:A2"  <%=A2%> >A2</option>
												<option value="apsappgrade1:A3"  <%=A3%> >A3</option>
												<option value="apsappgrade1:B1"  <%=B1%> >B1</option>
												<option value="apsappgrade1:B2"  <%=B2%> >B2</option>
												<option value="apsappgrade1:B3"  <%=B3%> >B3</option>
												<option value="apsappgrade1:B4"  <%=B4%> >B4</option>
												<option value="apsappgrade1:B5"  <%=B5%> >B5</option>
												<option value="apsappgrade1:C1"  <%=C1%> >C1</option>
												<option value="apsappgrade1:C2"  <%=C2%> >C2</option>											
											</select>
											<%}else{%>
											<%if(screen.getDataLabel("apsappgrade1").indexOf(screen.getDataLabel("apsgrade"))<0){%>
											<span class="style1"><%=screen.getDataLabel("apsappgrade1")%></span>
											<%}else{%>
											<%=screen.getDataLabel("apsappgrade1")%>
											<%}%>
											<%}%>
										</td>
										<td><center><%=screen.getDataLabel("apsassdesc")%></center></td>
										<td>
											<%if(screen.getDataLabel("apsappgrade1").indexOf(screen.getDataLabel("apsgrade"))<0){%>
											<span class="style1"><%=screen.getDataLabel("apsgrade")%></span>
											<%}else{%>
											<%=screen.getDataLabel("apsgrade")%>
											<%}%>
										</td>
										<td><%=screen.getDataLabel("apssumscore")%></td>
										<td><%=screen.inq.getChild("memployee").getString("fname")%></td>
										<td> 
											<%if((screen.getDataLabel("APSSTATUS").equals("A"))&&(!screen.getDataLabel("APSAPPSTATUS1").equals("A"))){%>
											<%="<A  href=\"javascript:goASP700('"+screen.getDataLabel("APSID")+"','"+screen.getDataLabel("APSASSESSOR")+"','"+screen.getDataLabel("APSASSESSY")+"');\">"+screen.getDataLabel("simemp","fullname")+"</A>"%>
											<%}else{%>
											<%="<A  href=\"javascript:goReASP700('"+screen.getDataLabel("APSID")+"','"+screen.getDataLabel("APSASSESSOR")+"','"+screen.getDataLabel("APSASSESSY")+"');\">"+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>
										<td>
											<%if(screen.getDataLabel("other3").equals("Y")){%>
											<span class="style1"><%=screen.getDataLabel("other3")%></span>
											<%}else{%>
											<%=screen.getDataLabel("other3")%>
											<%}%>
										</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;
										} // while
									%>
									<tr>
										<td class="table-title result" colspan="4"><label swlang code='SW012235'>Total Assessy</label> :&nbsp;&nbsp;<%=dc.format(to_per).replaceAll(".00", "")%>&nbsp;<label swlang code='SW002049'>Person</label></td>
										<td class="result-right" colspan="5"><label swlang code='SW000024'>Total</label> :</td> 
										<td class="result" >A = <%=dc.format((a_per/to_per)*100)%> %</td>
										<td class="result">B = <%=dc.format((b_per/to_per)*100)%> %</td>
										<td class="result">C = <%=dc.format((c_per/to_per)*100)%> %</td>
										<td class="result"><a class="csc-link" href="javascript:goCheck('<%=old_group%>','apsappgrade1');" swlang code='SW012142'>View</a></td> 
									</tr>
								</tbody>
								<%			
											} // while
										}// if	
								%>
								<%	}// if%>  
							</table>
						</div>
						
						<% if((ck.chkNullString(request.getParameter("__shown"),"").equals("1"))&&(recCount>0)){%>
						<div class="center">	
							<a class="btn btn-primary" href="javascript:goConfirm1();" swlang code='SW012098'>Submit</a>
						</div> 
						<%}%>
					</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>