<%@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="TRA0130H" class="com.csc.library.system.Task" scope="page"/>
<%
TRA0130H.setChannel(request,response);
HelpEntry screen = (HelpEntry) TRA0130H.process("HelpEntry","TRA0128H");
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("__valueSearch")));
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(__searchIn.equalsIgnoreCase("memployee.EMP_POSITION")){
screen.getInquiry().setFilter("status in ('A','V') and emp_position in (select positionid from mposition where tdesc "+symcon+" )");
}else if(__searchIn.equalsIgnoreCase("memployee.BU1") ){
screen.getInquiry().setFilter("status in ('A','V') and bu1 in (select bu1id from mbu1 where tdesc "+symcon+" )");
}else if(__searchIn.equalsIgnoreCase("memployee.BU2") ){
screen.getInquiry().setFilter("status in ('A','V') and bu2 in (select bu2id from mbu2 where tdesc "+symcon+" )");
}else if(__searchIn.equalsIgnoreCase("memployee.BU3") ){
screen.getInquiry().setFilter("status in ('A','V') and bu3 in (select bu3id from mbu3 where tdesc "+symcon+" )");
}
screen.setOrder();
screen.getInquiry().refresh();
screen.countRec(screen.getInquiry());
}else{
screen.process();
}
screen.referLangOn();
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 = chk.chkNullString(ds.getString("precrs"));
if(!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>
<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">
<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 language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="javascript">getTitleName();</script>
<script language="javascript">
function addMulti(){
with(document.cscform){
setEmp();
window.open("TRA0130T.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 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");
}
</script>
</head>
<body leftmargin="0" topmargin="0" >
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<form name="cscform" method="post" action="TRA0130H.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<%screen.referLangOn();%>
<input type="hidden"name="__screen" value="TRA0130H">
<input type="hidden" name="__fixCon" value="status in ('A','V')">
<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"))%>">
<br>
<div align="center">
<table cellpadding="0" cellspacing="0" class="maxsize">
<tr >
<td class="header"> TRA0130H,
<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()%> <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 align="center"><b><script language="JavaScript">swapLang('Select')</script></b></td>
<td align="left"> <b><script language="JavaScript">swapLang('Employee ID')</script></b></td>
<td align="left"> <b><script language="JavaScript">swapLang('Name Surname')</script></b></td>
<td align="left"> <b><script language="JavaScript">swapLang('Position')</script></b></td>
<!--td align="left"> <b><script language="JavaScript">swapLang('Level')</script></b></td-->
<td align="left"> <b><script language="JavaScript">swapLang('BU1')</script></b></td>
<td align="left"> <b><script language="JavaScript">swapLang('BU2')</script></b></td>
<td align="left"> <b><script language="JavaScript">swapLang('Boss')</script></b></td>
</tr>
<%
while(screen.nextRec()){
%>
<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("MJOBGRADE0","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("V1MEMPLOYEE","FULLNAME")%></td>
</tr>
<%
}
%>
</table>
</td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td align="center"><a href="javascript:checkAll();"><img src="../IMAGES/BUTTON/SELECTALL.gif" border="0" align="middle"></a>
<a href="javascript:decheckAll();"><img src="../IMAGES/BUTTON/DESELECTALL.gif" border="0" align="middle"></a>
<a href="javascript:addMulti();" ><img src="../IMAGES/BUTTON/ADD.gif" border="0" align="middle"></a>
<a href="javascript:window.close();" ><img src="../IMAGES/BUTTON/BACK.gif" border="0" align="middle"></a>
</td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td class="bottom"></td>
</tr>
</table>
<script language="javascript">chkTrueBox();</script>
</div>
</form>
</body>
</html>