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

<%	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,sap1,sSwork,sEwork,sSage,sEage;  //apsapprove1
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"),"");
sap1=ck.chkNullString(request.getParameter("__ap1"),"");

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(!sap1.equals(""))filter =filter+" and apsapprove1='"+sap1+"'";

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 APSAPPROVE2='"+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 apsapprove2,BU1 ,MBU1.TDESC AS TDESC, MBU1.EDESC AS EDESC from TAPSTRAN , MBU1 where  "+dateExp+" and TAPSTRAN.astid='AP10' and TAPSTRAN.bu1=MBU1.bu1id and  apsapprove2='"+employeeid+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
// "030099"+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
dsBu1.initConnection(screen.getUProfile());

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


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

DataSet dsPos = new DataSet("Select Distinct apsapprove2,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  apsapprove2='"+employeeid+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
dsPos.initConnection(screen.getUProfile());


DataSet dsSor = new DataSet("Select Distinct apsapprove2,APSASSESSOR,MEMPLOYEE.FNAME AS TDESC, MEMPLOYEE.EFNAME AS EDESC from TAPSTRAN, MEMPLOYEE where  "+dateExp+" and TAPSTRAN.astid='AP10' and TAPSTRAN.APSASSESSOR=MEMPLOYEE.EMPLOYEEID and  apsapprove2='"+employeeid+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
dsSor.initConnection(screen.getUProfile());

DataSet dsAp1 = new DataSet("Select Distinct apsapprove1 ,MEMPLOYEE.FNAME AS TDESC, MEMPLOYEE.EFNAME AS EDESC from TAPSTRAN, MEMPLOYEE where   "+dateExp+" and TAPSTRAN.astid='AP10' and TAPSTRAN.apsapprove1=MEMPLOYEE.EMPLOYEEID and  apsapprove2='"+employeeid+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
dsAp1.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("SW002250");
			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); 
					__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+"&__appfield="+"APSAPPROVE2&__bu1="+__bu1.value+"&__bu2="+__bu2.value;
						win = window.open(param,"AS004_3C1","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=3&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=3&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=3&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=3&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" method="post" action="?">
						<input type="hidden"name="__screen"  value="AS004_3">
						<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="APSAPPSTATUS2">
						<input type="hidden" name="__returnfield" value="APSAPPSTATUS1">
						<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='SW002250'>Apprisal Information Lv3</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" swlang code='SW002014'>Order by</label>
										</div>
										<div class="col-md-2 col-sm-2 col-xs-2">
											<label class="control-label">
												<A href="javaScript:setOrder('APSGRADE')"><label swlang code='SW000069'>เกรด </label> 1</A>
												&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; 
												<A href="javaScript:setOrder('APSAPPGRADE1')"><label swlang code='SW000069'>เกรด </label> 2</A>
											</label>
										</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","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 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>
								</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","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 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>
								</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='SW012258'>assessor 1</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 class="col-md-2 col-sm-2 col-xs-2">
											<label class="control-label label-right" swlang code='SW012259'>assessor 2</label>
										</div>
										<div class="col-md-2 col-sm-2 col-xs-2">
											<select class="form-control"name="__ap1" id="__ap1"">
												<option value=""></option>
													<%while(dsAp1.next()){				
													%><option value="<%=dsAp1.getString("apsapprove1")%>" <%=(sap1.equals(dsAp1.getString("apsapprove1")))?"selected":""%>><%=dsAp1.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>
							
							<div class="center">
								<a class="btn btn-primary" href="javascript:fixSearch();" swlang code='SW003537'>Search</a>
							</div>
							
						</div><!-- csc-block -->
					
						
						
					<div class="csc-block-white">
						<div class="table-responsive">
							<table class="table table-head table-hover table-bordered table-title-left table-content-center">
								<tr>
									<th class="table-title " colspan=14 swlang code='SW002250'>Apprisal Information Lv3</th>
								</tr>
								<% 
											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++;	
								 %>
								
								<tr>
									<th swlang code='SW000015'>Select</th>
									<th swlang code='SW000019'>Status</th>
									<th swlang code='SW000069'>grade</th>
									<th swlang code='SW012260'>Grade No.2</th>
									<th swlang code='SW012254'>Grade No.1</th>
									<th swlang code='SW000013'>Score</th>
									<th swlang code='SW012261'>Assess 2</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=14><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("apsappgrade2").indexOf("A")>=0){
														a_per++;
														a_per_t++;
													}else{
														if(screen.inq.getString("apsappgrade2").indexOf("B")>=0){
															b_per++;
															b_per_t++;
														}else{
															if(screen.inq.getString("apsappgrade2").indexOf("C")>=0){
																c_per++;
																c_per_t++;
															}
														}
													}
								 %>
								<tr>
									<td>
										<%if((screen.getDataLabel("APSAPPSTATUS1").equals("A"))&&(screen.getDataLabel("APSAPPSTATUS2").equals("W"))){%>
											<input type="checkbox" name="__ch<%=(++running)%>:APSID:APSASSESSOR:APSASSESSY:APSSTATUS:APSAPPGRADE2" value="<%=screen.getDataLabel("APSID")+":"+screen.getDataLabel("APSASSESSOR")+":"+screen.getDataLabel("APSASSESSY")+":"+screen.getDataLabel("APSSTATUS")+":"+screen.getDataLabel("APSAPPGRADE2")%>" id="__ch<%=running++%>:APSID:APSASSESSOR:APSASSESSY:APSSTATUS:APSAPPGRADE2" 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;
										<%}%> 
									</td>
									<td>
										<%if((screen.getDataLabel("apsappstatus2").equals(""))||(screen.getDataLabel("apsappstatus2").equals("0"))||(screen.getDataLabel("apsappstatus1").equals("R"))){%>
											<span class="style1"><%=screen.inq.getCurrentDbRecord().getSystemCode("apsappstatus2")%></span>
										<%}else{if(screen.getDataLabel("apsappstatus2").equals("A")){%>
											<span class="style2"><%=screen.inq.getCurrentDbRecord().getSystemCode("apsappstatus2")%></span>
										 <%}else{%>
											<%=screen.inq.getCurrentDbRecord().getSystemCode("apsappstatus2")%>
										<%}
											 }
										%>
									</td>
									<td>
										<%if((screen.getDataLabel("APSAPPSTATUS1").equals("A"))&&(screen.getDataLabel("APSAPPSTATUS2").equals("W"))){%>  
										<select class="form-control" id="__lineg:<%=screen.getDataLabel("mbu1","bu1id")+":"+screen.getDataLabel("mbu2","bu2id")+":"+screen.getDataLabel("mbu3","bu3id")+":"+screen.inq.getString("emp_group")+":"+screen.getDataLabel("runno") %>" name="__lineg:<%=screen.getDataLabel("mbu1","bu1id")+":"+screen.getDataLabel("mbu2","bu2id")+":"+screen.getDataLabel("mbu3","bu3id")+":"+screen.inq.getString("emp_group")+":"+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("apsappgrade2").equals("A1")){
														A1="selected";
													}else
														if(screen.getDataLabel("apsappgrade2").equals("A2")){
														A2="selected";
													}else
														if(screen.getDataLabel("apsappgrade2").equals("A3")){
														A3="selected";
													}else	if(screen.getDataLabel("apsappgrade2").equals("B1")){
														B1="selected";
													}else
														if(screen.getDataLabel("apsappgrade2").equals("B2")){
														B2="selected";
													}else
														if(screen.getDataLabel("apsappgrade2").equals("B3")){
														B3="selected";
													}else
													if(screen.getDataLabel("apsappgrade2").equals("B4")){
														B4="selected";
													}else
														if(screen.getDataLabel("apsappgrade2").equals("B5")){
														B5="selected";
													}else
														if(screen.getDataLabel("apsappgrade2").equals("C1")){
														C1="selected";
													}else
													if(screen.getDataLabel("apsappgrade2").equals("C2")){
														C2="selected";
													}
											%>	
											<option value=""></option>                       
											<option value="apsappgrade2:A1"  <%=A1%> >A1</option>
											<option value="apsappgrade2:A2"  <%=A2%> >A2</option>
											<option value="apsappgrade2:A3"  <%=A3%> >A3</option>
											<option value="apsappgrade2:B1"  <%=B1%> >B1</option>
											<option value="apsappgrade2:B2"  <%=B2%> >B2</option>
											<option value="apsappgrade2:B3"  <%=B3%> >B3</option>
											<option value="apsappgrade2:B4"  <%=B4%> >B4</option>
											<option value="apsappgrade2:B5"  <%=B5%> >B5</option>
											<option value="apsappgrade2:C1"  <%=C1%> >C1</option>
											<option value="apsappgrade2:C2"  <%=C2%> >C2</option>
										</select>
										<%}else{%>		
										<%if(!screen.getDataLabel("apsappgrade2").equals(screen.getDataLabel("apsappgrade1"))){%>
											<span class="style1"><%=screen.getDataLabel("apsappgrade2")%></span>
										<%}else{%>
											<%=screen.getDataLabel("apsappgrade2")%>
										<%}%>
										<%}%> 
									</td>
									<td>
										<%if(screen.getDataLabel("apsappgrade1").indexOf(screen.getDataLabel("apsgrade"))<0){%>
											<span class="style1"><%=screen.getDataLabel("apsappgrade1")%></span>
										<%}else{%>
											<%=screen.getDataLabel("apsappgrade1")%>
										<%}%>
									</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.getDataLabel("v1memployee","fname")%></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="6"><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 More</a></td>
								</tr>
								<%			
										} // 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><!-- container csc-content -->
					<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>