<%@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.*"%>
<%@ include file="../CHECKPROFILE.jsp" %>
<jsp:useBean id="AS004_1" class="com.csc.library.system.Task" scope="page" />
<%AS004_1.setChannel(request, response);%>
<%EmvHelpEntry screen = (EmvHelpEntry) AS004_1.process("EmvHelpEntry","AS004_1");%>

<%	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;
sbu1=ck.chkNullString(request.getParameter("__bu1"),"");
sbu2=ck.chkNullString(request.getParameter("__bu2"),"");
sbu3=ck.chkNullString(request.getParameter("__bu3"),"");
String filter = "";
String 	namelist="" ;
String data_namelist="";
String 	groupName="" ;
String 	groupArr="" ;
if(!sbu1.equals(""))filter =" and bu1='"+sbu1+"'";

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

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

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

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

//DataSet dsBu3 = new DataSet("Select Distinct APSASSESSOR,BU3,MBU3.TDESC AS TDESC, MBU3.EDESC AS EDESC from TAPSTRAN, MBU3 where TAPSTRAN.bu3=MBU3.bu3id and  APSASSESSOR='"+employeeid+"'",(String)screen.getUProfile().get("dbname"),"Tapstran");
//dsBu3.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("SW002248");
			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 goConfirm1(){
				
				var groupArr = document.getElementById("groupArr");
				var arr = groupArr.value.split(",");
				var returnVal = true;
				
				for(i=0;i<arr.length;i++){

					var objSelected = document.getElementById(arr[i]);
					
					if((objSelected.options[objSelected.selectedIndex].value=="")||((objSelected.options[objSelected.selectedIndex].value==0))){
						alert("กรุณาเลือกลำดับให้ครบ");
						returnVal = false;
						break;
					}else{
						//alert(objSelected.options[objSelected.selectedIndex].value);
					}
				}
				if(returnVal){
					//alert("goConfirm()");
					goConfirm();
				}
			}
			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=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
						if(window.focus){win.focus();}
					}
			}
			function goASP700(apsid,apsassessor,apsassessy){
				with(document.cscform){	
					__orderBy.value = "";	//action="ASP700.jsp?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level=1&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=1&bu1="+__bu1.value+"&bu2="+__bu2.value+"&isread=0";
					win =window.open(param,"APP_EMV700","left=50,top=50,width=1100,height=700,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
						if(window.focus){win.focus();}
				}

			}
			function goReASP700(apsid,apsassessor,apsassessy){
				with(document.cscform){
					__orderBy.value = "";	//action="ASP700.jsp?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level=1&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=1&bu1="+__bu1.value+"&bu2="+__bu2.value+"&isread=1";
					win =window.open(param,"APP_EMV700","left=50,top=50,width=1100,height=700,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 chkSelected(Obj){
				var arrSplit = Obj.name.split(":");
				var groupName = arrSplit[4];
				var elGroupName = document.getElementById(groupName);
				var arr = elGroupName.value.split(",");
				var elArr = new Array();
				var numArr = new Array();
				var num = 0;
				var valReturn = true;
				for(i=0;i<arr.length;i++){		
					elArr[i] = arr[i].replace("'","").replace("'","");
				}
				for(i=0;i<elArr.length;i++){
					var objSelected = document.getElementById(elArr[i]);
					
					if(Obj.name!=objSelected.name){
						if(Obj.value==objSelected.options[objSelected.selectedIndex].value&&Obj.value!=0){
							alert("เลขนี้ถูกเลือกแล้ว");
							Obj.selectedIndex=0;				
							break;
						}
					}
				}

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

		</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_1">
					<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="APSSTATUS">
					<input type="hidden" name="__returnfield" value="">
					<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='SW002248'>Apprisal Information Lv1</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>
							</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="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=9 swlang code='SW002248'>Apprisal Information Lv1</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='SW000019'>Status</th>
										<th swlang code='SW001055'>Sequencing</th>
										<th swlang code='SW000013'>Score</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=9 swlang code='SW000507'>Employee Group Code&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;
										int countRow = 0;
										while(nextRec){
											countRow++;
											to_per++;
											to_per_t++;
											
											if(screen.inq.getString("apsgrade").indexOf("A")>=0){
												a_per++;
												a_per_t++;
											}else{
												if(screen.inq.getString("apsgrade").indexOf("B")>=0){
													b_per++;
													b_per_t++;
												}else{
													if(screen.inq.getString("apsgrade").indexOf("C")>=0){
														c_per++;
														c_per_t++;
													}
												}
											}
									%>
									<tr>
										<td>
											<center>
												<%if((screen.getDataLabel("apsstatus").equals(""))||(screen.getDataLabel("apsstatus").equals("0"))||(screen.getDataLabel("apsstatus").equals("R"))){%>
												<%=screen.inq.getCurrentDbRecord().getSystemCode("apsstatus")%>
												<%
													}else{
													if(screen.getDataLabel("apsstatus").equals("A")){
												%>
												<%=screen.inq.getCurrentDbRecord().getSystemCode("apsstatus")%>
												<%}else{%>
												<%=screen.inq.getCurrentDbRecord().getSystemCode("apsstatus")%>
												<%
													}
													}
												%>
											</center>
										</td>
										<td>
											<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") %>"  apsstatus='<%=screen.getDataLabel("apsstatus")%>' >	
												<option value=""></option>
											</select>
											<%
											
												namelist += ",'__lineg:"+screen.getDataLabel("mbu1","bu1id")+":"+screen.getDataLabel("mbu2","bu2id")+":"+screen.getDataLabel("mbu3","bu3id")+":"+screen.inq.getString("emp_group")+":"+screen.getDataLabel("runno")+"'";				
												data_namelist+=",'"+screen.getDataLabel("APSASSDESC")+"'";	
												groupArr+=",__lineg:"+screen.getDataLabel("mbu1","bu1id")+":"+screen.getDataLabel("mbu2","bu2id")+":"+screen.getDataLabel("mbu3","bu3id")+":"+screen.inq.getString("emp_group")+":"+screen.getDataLabel("runno");	

												groupName = screen.inq.getString("emp_group");
												
											%>
										</td>
										<td><center><%=screen.getDataLabel("apssumscore")%></center></td>
										<td>
											<%if(!screen.getDataLabel("APSSTATUS").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")){%>
												<%=screen.getDataLabel("other3")%>
											<%}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; 
										
										} // end while 
									%>
									<tr>
										<td class="table-title result" colspan="9"><label swlang code='SW012235'>Total Assessy</label> :&nbsp;&nbsp;<%=dc.format(to_per).replaceAll(".00", "")%>&nbsp;<label swlang code='SW002049'>Person</label></td>
									</tr>
									<script>
										var arr = new Array(<%=namelist.substring(1)%>);
										var data_arr = new Array(<%=data_namelist.substring(1)%>);
										var arrSize = arr.length;
										
										for(i=0;i<arrSize;i++){						
											var 	selectObj = document.getElementById(arr[i]);
													selectObj.onchange = function(){chkSelected(this);	}									
											
												for (j = 1; j<= arrSize; j++) {
													var 	optionObj = document.createElement("option");
															optionObj.value = "apsassdesc:"+j+":apsstatus:A";
															optionObj.innerHTML = j;
															selectObj.appendChild(optionObj);
												}  //End For j
												if(data_arr[i]!=''){
												//	alert(data_arr[i]);
													selectObj.selectedIndex= +data_arr[i];
													if(selectObj.apsstatus=='A'){
														selectObj.disabled="disabled";
													}
												}
											document.getElementById(arr[i]).appendChild(selectObj);
										}//End For i
									</script>
									<input type="hidden" name="<%=groupName%>" id="<%=groupName%>" value="<%=namelist.substring(1)%>">
									<% namelist = "";%>
									<% data_namelist = "";%>
									<%			
										} // while
										}// if	
									%>
									<input type="hidden" name="groupArr" id="groupArr" value="<%=groupArr.substring(1)%>">
									<%	}// if%>  
								</tbody>
							</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> 
						<%}%>
						<%=screen.endJSP()%>
					</div>
				</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>