<%@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 : <%=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> : <%=dc.format(to_per).replaceAll(".00", "")%> <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>