<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %>
<jsp:useBean id="TRA0128H_PHATRA" class="com.csc.library.system.Task" scope="page"/>
<%
TRA0128H_PHATRA.setChannel(request,response);
HelpEntry screen = (HelpEntry) TRA0128H_PHATRA.process("HelpEntry","TRA0128H_PHATRA");
CheckNull chk = new CheckNull();
int maxLine = 20;
int goPage = 1;
try{
goPage = Integer.parseInt(chk.chkNullString(request.getParameter("__goPage"),"1").replace("+","").replace("-",""));
}catch(Exception e){
}
int stop = maxLine * goPage;
int start = stop - (maxLine-1);
String __orderIn = chk.chkNullString(request.getParameter("__listOrder"));
String __searchIn = chk.chkNullString(request.getParameter("__searchBy"));
String __conIn = chk.chkNullString(request.getParameter("__conSearch"));
String __valueIn = new ThaiUtilities().ASCII2Unicode(chk.chkNullString(request.getParameter("__valueSearch2")));
String strquery = "1=1";
screen.getInquiry().clearOldCondition();
screen.setMaxLine(maxLine);
screen.getInquiry().setBetween(start, stop);
if(__searchIn.equalsIgnoreCase("memployee.EMP_POSITION") || __searchIn.equalsIgnoreCase("memployee.BU1") || __searchIn.equalsIgnoreCase("memployee.BU2") || __searchIn.equalsIgnoreCase("memployee.BU3")){
String symcon = null;
if(__conIn.equals("like")){
symcon = __conIn+" '%"+__valueIn+"%'";
}else{
symcon = __conIn+" '"+__valueIn+"'";
}
if(!__valueIn.equals("")){
if(__searchIn.equalsIgnoreCase("memployee.EMP_POSITION")){
strquery = strquery + " and emp_position in (select positionid from mposition where tdesc "+symcon+" )";
}else if(__searchIn.equalsIgnoreCase("memployee.BU1") ){
strquery = strquery + " and bu1 in (select bu1id from mbu1 where tdesc "+symcon+" )";
}else if(__searchIn.equalsIgnoreCase("memployee.BU2") ){
strquery = strquery + " and bu2 in (select bu2id from mbu2 where tdesc "+symcon+" )";
}else if(__searchIn.equalsIgnoreCase("memployee.BU3") ){
strquery = strquery + " and bu3 in (select bu3id from mbu3 where tdesc "+symcon+" )";
}
}
}
screen.inq.setFilter(strquery);
screen.process();
screen.countRec(screen.getInquiry());
int count = 0;
String precrs = "";
DataSet ds = new DataSet();
ds.setInfo("select precrs from mcourse where crsid = '"+chk.chkNullString(request.getParameter("__crsid"))+"'", (String)screen.getUProfile().get("dbname"), "mcourse");
ds.initConnection(screen.getUProfile());
if(ds.next()){
precrs = ds.getString("precrs");
if(precrs!= null && !precrs.equals("")){
String tmp[] = precrs.split("#");
precrs = "";
for(int i=0; i<tmp.length; i++){
if(!tmp[i].equals("") && precrs.indexOf("'"+tmp[i].split(" ")[0]+"'")<0){
precrs += (count > 0)?",":"";
precrs += "'"+tmp[i].split(" ")[0]+"'";
++count;
}
}
}
}
ds.closeConnection();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html ng-app='myHR'>
<head>
<title>Training - add trainee</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"/>
<link href="../CSS/MENU.css" rel="stylesheet" type="text/css"/>
<link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css"/>
<link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css"/>
<script language='javascript' src="../JS/VIEWCALENDAR.js"></script>
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type='text/javascript' src="../JS/bootstrap.js"></script>
<script type="text/javascript" src="../public/lib/angular/angular.min.js"></script>
<script type="text/javascript" src="../JS/ANGULAR/SCREEN_ANGULAR.js"></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="javascript">getTitleName();</script>
<script language="javascript">
function addMulti(){
with(document.cscform){
if( chkSelectEmp() ) {
setEmp();
window.location.href = "TRA0126T_PHATRA.jsp?__chkEmp="+__chkEmp.value+"&__trainingid="+__trainingid.value+"&status=1","Trainee","left=150,top=150,width=150,height=100,toolbar=no,status=yes,scrollbars=yes,resizable=yes";
}
}
}
function chkSelectEmp(){
with(document.cscform){
var result = false;
var checkNewEmp = parseInt($('input[name="__empChk"]:checkbox:checked:not(":disabled")').length);
var reserve_approve = parseInt(__reserve_approve.value);
var selectEmpNow = checkNewEmp + reserve_approve;
var qtyvalid = parseInt(__qtyvalid.value);
if( selectEmpNow <= qtyvalid ) {
result = true;
} else {
var msg = getLang().toUpperCase() === "THA" ?
"ไม่สามารถเพิ่มได้เนื่องจาก\nผู้เข้าอบรมที่เลือกมี "+selectEmpNow+" คน\nซึ่งมีมากกว่าจำนวนผู้เข้าอบรมสูงสุด "+qtyvalid+" คน" :
"Can't add new trainee because\nYou select trainee "+selectEmpNow+" persons\nhas more than max trainee "+qtyvalid+" persons" ;
alert(msg);
}
return result;
}
}
function chkTrueBox(){
var tmp;
with(document.cscform){
tmp = __chkEmpOld.value;
var obj = document.getElementsByName("__empChk");
if(typeof obj!="undefined"){
for(i=0;i<obj.length;i++){
if(tmp.indexOf("$"+obj[i].value+"$")>=0){
obj[i].checked=true;
obj[i].disabled=true;
}
}
tmp = __chkEmp.value;
for(i=0;i<obj.length;i++){
if(tmp.indexOf("$"+obj[i].value+"$")>=0){
obj[i].checked=true;
}
}
}
}
}
function setEmp(){
var tmp;
var tmpEmp = "";
var obj = document.getElementsByName("__empChk");
with(document.cscform){
if(typeof obj!="undefined"){
for(i=0;i<obj.length;i++){
tmp = __chkEmp.value;
if(!obj[i].disabled){
if(!obj[i].checked && tmp.indexOf("$"+obj[i].value+"$")>=0){
tmpEmp = __chkEmp.value;
__chkEmp.value = tmpEmp.replace("$"+obj[i].value+"$","$");
if(__chkEmp.value=="$"){
__chkEmp.value="";
}
}else{
if(obj[i].checked && tmp.indexOf("$"+obj[i].value+"$")<0){
if(__chkEmp.value==""){
__chkEmp.value+="$";
}
__chkEmp.value+=obj[i].value+"$";
}
}
}
}
}
}
}
function checkAll(){
var obj = document.getElementsByName("__empChk");
if(typeof obj!="undefined"){
for(i=0;i<obj.length;i++){
if(!obj[i].disabled){
obj [i].checked=true;
}
}
}
setEmp();
}
function decheckAll(){
var obj = document.getElementsByName("__empChk");
if(typeof obj!="undefined"){
for(i=0;i<obj.length;i++){
if(!obj[i].disabled){
obj [i].checked=false;
}
}
}
setEmp();
}
function setOnClick(data,chk){
with(document.cscform){
if(chk){
if(__chkEmp.value==""){
__chkEmp.value="$";
}
__chkEmp.value+=data+"$";
}else{
var tmpEmp = __chkEmp.value;
if(tmpEmp.indexOf("$"+data+"$")>=0){
__chkEmp.value = tmpEmp.replace("$"+data+"$","$");
if(__chkEmp.value=="$"){
__chkEmp.value="";
}
}
}
}
}
function search(){
with(document.cscform){
setEmp();
__cmd.value="search";
submit();
}
}
function setOrderby(){
with(document.cscform){
setEmp();
__orderBy.value=__listOrder.options[__listOrder.selectedIndex].value;
submit();
}
}
function goPage(page){
with(document.cscform){
setEmp();
__goPage.value=page;
submit();
}
}
function viewHistory(empid){
window.open("TRH011.jsp?__help=__employeeid$"+empid+"&viewonly=true","viewhistory","left=150,top=150,width=700,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
$('document').ready(function() {
var con = $('[name=__searchBy]').val();
if(con=='memployee.EMP_POSITION' || con=='memployee.BU1' || con=='memployee.BU2' || con=='memployee.BU3'){
$('[name=__valueSearch]').hide();
$('[name=__valueSearch2]').show();
}else{
$('[name=__valueSearch]').show();
$('[name=__valueSearch2]').hide();
}
$('[name=__searchBy]').on('change', function() {
var con = $('[name=__searchBy]').val();
if(con=='memployee.EMP_POSITION' || con=='memployee.BU1' || con=='memployee.BU2' || con=='memployee.BU3'){
$('[name=__valueSearch]').hide();
$('[name=__valueSearch2]').show();
}else{
$('[name=__valueSearch]').show();
$('[name=__valueSearch2]').hide();
}
});
});
</script>
</head>
<body leftmargin="0" topmargin="0" >
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<form name="cscform" method="post" action="?">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden"name="__screen" value="TRA0128H_PHATRA"/>
<input type="hidden" name="__fixCon" value=""/>
<input type="hidden" name="__cmd" value=""/>
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"/>
<input type="hidden" name="__user" value="<%=screen.getUProfile().get("employeeid")%>"/>
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"/>
<input type="hidden" name="__chkEmp" value="<%=chk.chkNullString(request.getParameter("__chkEmp"))%>"/>
<input type="hidden" name="__chkEmpOld" value="<%=chk.chkNullString(request.getParameter("__chkEmpOld"))%>"/>
<input type="hidden" name="__help" value=""/>
<input type="hidden" name="__trainingid" value="<%=chk.chkNullString(request.getParameter("__trainingid"))%>"/>
<input type="hidden" name="__orderBy" value="<%=chk.chkNullString(request.getParameter("__listOrder"))%>"/>
<input type="hidden" name="__goPage" value=""/>
<input type="hidden" name="__pageCall" value="<%=chk.chkNullString(request.getParameter("__screen"))%>"/>
<input type="hidden" name="__crsid" value="<%=chk.chkNullString(request.getParameter("__crsid"))%>"/>
<input type="hidden" name="__reserve_approve" value="<%=chk.chkNullString(request.getParameter("__reserve_approve"))%>"/>
<input type="hidden" name="__qtyvalid" value="<%=chk.chkNullString(request.getParameter("__qtyvalid"))%>"/>
<br/>
<div align="center">
<table cellpadding="0" cellspacing="0" class="maxsize">
<tr>
<td class="header">TRA0128H_PHATRA, <script language="javascript">swapLang('Trainee List');</script> </td>
</tr>
<tr>
<td>
<table class="maxsize" border="1" cellspacing="1" cellpadding="1" colspan="4">
<tr>
<td colspan="4" class="blankspace" ></td>
</tr>
<tr>
<td width="15%"><div align="right"><script language="javascript">swapLang('Order By');</script> </div></td>
<td><%=screen.getTagOrder()%></td>
<td width="20%"><div align="right"><script language="javascript">swapLang('Search By');</script> </div></td>
<td><%=screen.getTagSearchBy()%></td>
</tr>
<tr>
<td><div align="right"><script language="javascript">swapLang('Condition');</script> </div></td>
<td><%=screen.getTagConSearch()%></td>
<td> <div align="right"><script language="javascript">swapLang('Key Value');</script> </div></td>
<td>
<%=screen.getTagValueSearch()%>
<input type="text" name="__valueSearch2" size="20" maxlength="30" value="<%=chk.chkNullString(request.getParameter("__valueSearch2"))%>" onkeypress="javaScript:chonKeyPress(this,this.value,event);" onkeyup="sysIsEdit();javaScript:chonKeyup(this,this.value);" onblur="javaScript:chonBlur(this,this.value);" onfocus="javaScript:chonFocus(this,this.value);">
<a href="javascript:search();"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" width="20" height="20" border="0" align="middle"></a></td>
</tr>
<tr>
<td colspan="4" class="blankspace" ></td>
</tr>
<tr>
<td colspan="2"> <script language="javascript">swapLang('Found Data');</script> <%=screen.getRecCount()%></td>
<td colspan="2"><div align="right"><%=screen.getPageTag()%></div></td>
</tr>
</table>
</td>
</tr>
</table>
<br/>
<table cellpadding="0" cellspacing="0" class="maxsize">
<tr>
<td>
<table class="maxsize" cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="5%" align="center"><b><script language="JavaScript">swapLang('Select')</script></b></td>
<td width="7%" align="center"><b><script language="JavaScript">swapLang('Employee ID')</script></b></td>
<td width="15%" align="center"><b><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"ชื่อ - นามสกุล":"Name - Surname"%></b></td>
<td width="20%" align="center"><b><script language="JavaScript">swapLang('Position')</script></b></td>
<td width="14%" align="center"><b><%=screen.getLabel("BU1")%></b></td>
<td width="13%" align="center"><b><%=screen.getLabel("BU2")%></b></td>
<td width="13%" align="center"><b><%=screen.getLabel("BU2")%></b></td>
<td width="8%" align="center"><b><%=screen.getLabel("BIRTHDAY")%></b></td>
<td width="5%" style="display:none;" align="center"><b><script language="javascript">swapLang("Qualified");</script></b></td>
</tr>
<%
while(screen.nextRec()){
screen.referLangOn();
%>
<tr>
<td class="forborder" align="center">
<input name="__empChk" type="checkbox" value = '<%=screen.getString("employeeid")%>' onclick="setOnClick(this.value,this.checked);">
</td>
<td class="forborder" align="left"> <a href="javascript:viewHistory('<%=screen.getString("EMPLOYEEID")%>');"><%=screen.getString("EMPLOYEEID")%></a></td>
<td class="forborder" align="left"> <%=screen.getString("EFNAME")%> <%=screen.getString("ELNAME")%></td>
<td class="forborder" align="left"> <%=screen.getString("MPOSITION","TDESC")%></td>
<td class="forborder" align="left"> <%=screen.getString("MBU1","TDESC")%></td>
<td class="forborder" align="left"> <%=screen.getString("MBU2","TDESC")%></td>
<td class="forborder" align="left"> <%=screen.getString("MBU3","TDESC")%></td>
<td class="forborder" align="left"> <%=screen.getString("BIRTHDAY")%></td>
<%
int total = 0;
if(precrs!=null && !precrs.equals("")){
ds.setInfo("select count(distinct crsid) total from vw_htraintrnee where traineeid = '"+screen.getString("EMPLOYEEID")+"' and crsid in ("+precrs+")", (String)screen.getUProfile().get("dbname"), "vw_htraintrnee");
ds.initConnection(screen.getUProfile());
if(ds.next()){
total = Integer.parseInt(ds.getString("total"));
}
}
%>
<td style="display:none;" class="forborder" align="left"> <%=(total >= count)?"<script language='javascript'>swapLang('YES');</script>":"<font class='warnning'><script language='javascript'>swapLang('NO');</script></font>"%></td>
</tr>
<%
}
ds.closeConnection();
%>
</table>
</td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td class="buttonline" colspan="7">
<div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW013163" onClick="checkAll();">Select All</button>
<button type="button" class="btn btn-primary width100" swlang code="SW013164" onClick="decheckAll();">Deselect All</button>
<button type="button" class="btn btn-primary width100" swlang code="SW013165" onClick="addMulti();">Add</button>
<button type="button" class="btn btn-primary width100" swlang code="SW013174" onClick="window.close();">Back</button>
</div>
</td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td class="bottom"></td>
</tr>
</table>
<script language="javascript">chkTrueBox();</script>
</div>
</form>
</body>
</html>