<%@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="TR007" class="com.csc.library.system.Task" scope="page"/>
<jsp:useBean id="TR007H" class="com.csc.library.system.Task" scope="page"/>
<%
	TR007.setChannel(request,response);
	UIManager screen = (UIManager) TR007.process("SingleEntry","TR007_LPN");

	screen.referLangOn();

	TR007H.setChannel(request,response);
	HelpEntry screen1 = (HelpEntry) TR007H.process("HelpEntry","TR007_LPNHELP");	
	screen1.process();
	screen1.nextRec();
	screen1.referLangOn();

	CheckNull chk = new CheckNull();
	
	FileDownloadUtils downloadutils = null;

	String picture_aca = screen1.getString("macademy","photo");
	if (picture_aca.equals("")){picture_aca = "DEFAULT.jpg";}
	downloadutils = new FileDownloadUtils("TRAINING_UPLOAD", "dir", picture_aca, "PICTURE/ACADEMY");
	picture_aca = downloadutils.getViewURL();

	String picture_loc = screen1.getString("mtrlocation","photo");
	if (picture_loc.equals("")){picture_loc = "DEFAULT.jpg";} 
	downloadutils = new FileDownloadUtils("TRAINING_UPLOAD", "dir", picture_loc, "PICTURE/LOCATION");
	picture_loc = downloadutils.getViewURL();

	String picture_room = screen1.getString("mtrroom","photo");
	if (picture_room.equals("")){picture_room = "DEFAULT.jpg";}
	downloadutils = new FileDownloadUtils("TRAINING_UPLOAD", "dir", picture_room, "PICTURE/ROOM");
	picture_room = downloadutils.getViewURL();
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script language='javascript'>setLang('<%=screen1.getUProfile().get("lang")%>');</script>
<script  type='text/javascript'  src="../JS/VIEWCALENDAR.js"></script>
<script language="JavaScript" >

var altTh = new Array(); 
var altEn = new Array(); 
var altMy = new Array();
altTh[0] = "คุณมีชื่ออยู่ในรายชื่อผู้เข้าอบรมรุ่นนี้แล้ว";
altEn[0] = "you in trainee list for this training";

altTh[1] = "คุณได้จองการอบรมรุ่นนี้ไปแล้ว";
altEn[1] = "you have reserved this training";

altTh[2] = "ต้องการจองการอบรมรุ่นนี้หรือไม่";
altEn[2] = "would you want to reserve this course";

altTh[3] = "คุณมีประวัติการอบรมหลักสูตรนี้แล้ว ต้องการจองการอบรมรุ่นนี้หรือไม่";
altEn[3] = "In your training history have this course. would you want to reserve this course.";

altTh[4] = "ไม่สามารถจองได้ เนื่องจากยังไม่ถึงวันจอง";
altEn[4] = "Can't reserver becourse this date less then resdate.";

altTh[5] = "ไม่สามารถจองได้ เนื่องจากเลยเวลาจอง";
altEn[6] = "Can't reserver becourse this date morethan resdate.";

function setAltCode(){
	if(getLang()=="tha"){
		altMy=altTh;
	}else{
		altMy=altEn;
	}
}
function GoSave(){
	with(document.cscform){
		setAltCode();
		if(trneeCount.value==0){
				if(!__reserved.value){
						if(chkRes.value=="between"){
								if(__issamecrs.value==0&&__issamecrs_tran.value==0){
									bCon=confirm(altMy[2]);
									if(bCon){
										GoMyNote();
										//confirmSave();
									}
								}else{
									if(__issamecrs_tran.value!=0){
											var tmp="";
											if(getLang()=="tha"){
												tmp = "รุ่นที่คุณต้องการจอง มีหลักสูตรซํ้ากับ รุ่น "+__issamecrs_tran.value+"ต้องการจองการอบรมรุ่นนี้หรือไม่";
											}else{
												tmp = "This training class have course as same as Training class ID "+__issamecrs_tran.value+"would you want to reserve this course";
											}
											bCon=confirm(tmp);
											if(bCon){
												//confirmSave();
												GoMyNote();
											}
									}else{
										if(__issamecrs.value==1){
											bCon=confirm(altMy[3]);
											if(bCon){
												//confirmSave();
												GoMyNote();
											}
										}
									}
								}
						}else{
							if(chkRes.value=="after"){
								alert(altMy[5]);
							}else{
								alert(altMy[4]);
							}
						}
				}else{
					alert(altMy[1]);
				}
		}else{
			alert(altMy[0]);
		}
	}
}
function GoUpdate(){update();}
function GoDelete(){edelete();}
function GoSearch(){search();}

function showFile_aca(){
	with(document.cscform){
		window.open(pic_aca.src,'Picture','width=800,height=600,status=yes,scrollbars=yes,resizable=yes');
	}
}
function showFile_loc(){
	with(document.cscform){
		window.open(pic_loc.src,'Picture','width=800,height=600,status=yes,scrollbars=yes,resizable=yes');
	}
}
function showFile_room(){
	with(document.cscform){
		window.open(pic_room.src,'Picture','width=800,height=600,status=yes,scrollbars=yes,resizable=yes');
	}
}
function setOnPicError(pic){
	pic.value = "DEFAULT.jpg";
}
function backhead(){
	with(window.opener.cscform){
	   submit();	
	}
	window.close();
}
function setIssameCrs(){
	with(document.cscform){
		__issamecrs.value = 1;
	}
}
function setIssameCrs_tran(trid){
	with(document.cscform){
		__issamecrs_tran.value = trid;
	}
}
function GoMyNote(){
	var tmp="";
	with(document.cscform){
		var ttri = '<%=screen1.getString("TRTITLE")%>';
		ttri = ttri.replace(" ","$");
		var crs = '<%=screen1.getString("MCOURSE","CRSEDESC")%>';
		crs = crs.replace(" ","$");
		var loc = '<%=screen1.getString("MTRLOCATION","LOCEDESC")%>';
		loc = loc.replace(" ","$");
		tmp = "?__trainingid="+__trainingid.value+
		"&__trtitle="+ttri+
		"&__classfrom="+__classfrom.value+
		"&__classto="+__classto.value+
		"&__timestart="+__timestart.value+
		"&__timestop="+__timestop.value+
		"&__crsdesc="+crs+
		"&__loca="+loc+
		"&__setTrnid=yes";
	}
	with(window.opener.cscform){
		target = "_top";
		action = "./TRA200.jsp"+tmp;
		submit();
	}
	window.close();
}
function viewCourse(courseid){
	with(document.cscform){
		window.open("TRH003_3H.jsp?"+
			"&__crsid="+courseid+
			"&__companyid="+__companyid.value,"","left=150,top=150,width=600,height=550,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
	}	
}
</script>
<STYLE type=text/css>
	FONT.wait {
	FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
	font-size: 12px;
	color: #E85C00;
	}
	FONT.free {
	FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
	font-size: 12px;
	color: #339900;
	}
	FONT.stop {
	FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
	font-size: 12px;
	color: #FF0000;
	}
</STYLE>
</head>
<body leftmargin="0" topmargin="0"  onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP24.gif','../IMAGES/BUTTON/SWAP/EXIT_SWAP24.gif','../IMAGES/BUTTON/SWAP/HELP_SWAP24.gif','../IMAGES/BUTTON/SWAP/NEW_SWAP24.gif','../IMAGES/BUTTON/SWAP/EDIT_SWAP24.gif','../IMAGES/BUTTON/SWAP/DEL_SWAP24.gif','../IMAGES/BUTTON/SWAP/PROCESS_SWAP24.gif','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
  <form name="cscform" method="post" action="#">
 

<!----------BEGIN CSC INITIAL ZONE ------------------------>

<%=screen.InitialVariable()%>

<!----------END CSC INITIAL ZONE -------------------------->
   
   <script language="javascript">getInputFormatDate();</script>   
	<input type="hidden" name="__screen"  value="TR007_LPN">
	<input type="hidden" name="__help" value="">
	<input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>">
	<input type="hidden" name="__cmd"  value="">
	<input type="hidden" name="__calendar">
	<input type="hidden" name="__status" value="1">
	<input type="hidden" name="__tconfirm" value="2">
	<input type="hidden" name="__restype" value="1">
	<input type="hidden" name="__resdate" value="<%=new CscCalendar().getYYYYMMDD()%>">
    <input type="hidden" name="__trainingid" value="<%=screen1.getString("TRAININGID")%>">
    <input type="hidden" name="__trtitle" value="<%=screen1.getString("TRTITLE")%>">
    <input type="hidden" name="__classfrom" value="<%=screen1.inq.getCurrentDbRecord().getCscCalendar("CLASSDATEFRM").getDDMMYYYY()%>">
    <input type="hidden" name="__classto" value="<%=screen1.inq.getCurrentDbRecord().getCscCalendar("CLASSDATETO").getDDMMYYYY()%>">
    <input type="hidden" name="__trtitle" value="<%=screen1.getString("TRTITLE")%>">
    <input type="hidden" name="__timestart" value="<%=screen1.getString("TIMESTART")%>">
    <input type="hidden" name="__timestop" value="<%=screen1.getString("TIMESTOP")%>">
    <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
    <input type="hidden" name="__notNull" value="<%=screen.getRequire()%>">
    <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
    <input type="hidden" name="__reserverid" value="<%=screen.getUProfile().get("employeeid")%>">
    <input type="hidden" name="__reserved" value="<%=chk.chkNullString(request.getParameter("__reserved"))%>">
    <input type="hidden" name="__issamecrs" value="0">
	<input type="hidden" name="__issamecrs_tran" value="0">
  <%
	DbInquiry db =  new InitialInquiry(screen.getUProfile()).getDbInquiry();
	db.initMyTable("memployee","employeeid='"+screen.getUProfile().get("employeeid")+"' and companyid='"+screen.getUProfile().get("companyid")+"'","");
	db.setColumn("employeeid,emp_prefix,fname,lname,efname,elname,bu1,bu2,bu3,bu4,bu5,job,emp_group,emp_level,emp_position,branch,bossid,salatype,workarea");
	db.refresh();
	if(db.next()){
  %>
   <input type="hidden" name="__bu1" value="<%=db.getString("bu1")%>">
   <input type="hidden" name="__bu2" value="<%=db.getString("bu2")%>">
   <input type="hidden" name="__bu3" value="<%=db.getString("bu3")%>">
   <input type="hidden" name="__bu4" value="<%=db.getString("bu4")%>">
   <input type="hidden" name="__bu5" value="<%=db.getString("bu5")%>">
   <input type="hidden" name="__job" value="<%=db.getString("job")%>">
   <input type="hidden" name="__emp_group" value="<%=db.getString("emp_group")%>">
   <input type="hidden" name="__emp_position" value="<%=db.getString("emp_position")%>">
   <input type="hidden" name="__emp_level" value="<%=db.getString("emp_position")%>">
   <input type="hidden" name="__branch" value="<%=db.getString("branch")%>">
   <input type="hidden" name="__bossid" value="<%=db.getString("bossid")%>">
   <input type="hidden" name="__workarea" value="<%=db.getString("workarea")%>">
<%
	}
	db.initMyTable("htraintrnee","traineeid='"+screen.getUProfile().get("employeeid")+"' and companyid='"+screen.getUProfile().get("companyid")+"'","");
	db.setColumn("traineeid,trainingid,companyid");
	DbInquiry dbi =  new InitialInquiry(screen.getUProfile()).getDbInquiry("htraining");
	dbi.setColumn("trainingid,companyid,crsid");
	db.putChild(dbi);
	db.refresh();
	if(db.recCount()>0){
		while(db.next()){
			if(dbi.getString("crsid").equals(chk.chkNullString(request.getParameter("__crsid")))){
			%>
				<script language="JavaScript">setIssameCrs()</script>
			<%
			}
		}
	}

	db.initMyTable("ttraintrnee","traineeid='"+screen.getUProfile().get("employeeid")+"' and companyid='"+screen.getUProfile().get("companyid")+"'","");
	db.setColumn("traineeid,trainingid,companyid");
	dbi.initMyTable("ttraining","","");
	dbi.setColumn("trainingid,companyid,crsid");
	db.putChild(dbi);
	db.refresh();
	if(db.recCount()>0){
		while(db.next()){
			if(dbi.getString("crsid").equals(chk.chkNullString(request.getParameter("__crsid")))){
			%>
				<script language="JavaScript">setIssameCrs_tran('<%=dbi.getString("trainingid")%>')</script>
			<%
			}
		}
	}
%>	
<div align="center">
	<br>
	<table border="0" cellspacing="0" cellpadding="0">
      <tr> 
			<td class="header">TR007,<script language="JavaScript">swapLang('Training Reserve')</script>&nbsp;</td>
      </tr>
      <tr> 
			<td> 
					<table  border="1" cellspacing="0" cellpadding="0" class="maxsize">
							<tr> 
									<td class="blankspace" colspan="2"></td>
							</tr>
							<tr> 
									<td class="columnlabel"><%=screen1.getLabel("TRAININGID")%>&nbsp;</td>
									<td class="columnlabelfree"><div align="left"><font class="normal"><%=screen1.getString("TRAININGID")%></font></div></td>
							</tr>
							<tr> 
									<td class="columnlabel"><%=screen1.getLabel("TRTITLE")%>&nbsp;</td>
									<td class="columnlabelfree"> <div align="left"><font class="normal"><%=screen1.getString("TRTITLE")%></font></div></td>
							</tr>
							<tr> 
									<td class="columnlabel"><script language="JavaScript">swapLang('Course')</script>&nbsp;</td>
									<td class="columnlabelfree"><div align="left"><font class="normal"><%=screen1.getString("MCOURSE","CRSEDESC")%></font>&nbsp;&nbsp;<a href="javascript:viewCourse('<%=screen1.getString("CRSID")%>');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image41','','../IMAGES/BUTTON/SWAP/HELP_SWAP20.gif',1)"><img SRC="../IMAGES/BUTTON/MAIN/HELP20.gif" alt="รายละเอียดหลักสูตร" name="Image41" width="20" height="20" border="0" align="absmiddle" id="Image41"></a></div></td>
							</tr>
							<tr> 
									<td class="columnlabel"><script language="JavaScript">swapLang('Training Type')</script>&nbsp;</td>
									<td class="columnlabelfree"> <div align="left"><font class="normal"><%=screen1.getInquiry().getCurrentDbRecord().getSystemCode("TRAIN_TYPE")%></font></div></td>
							</tr>
							<%
										if(new CscCalendar().afterDate(new CscCalendar(screen1.inq.getCurrentDbRecord().getCscCalendar("RESDATETO").getYYYYMMDD()))) {
							%>
										<tr> 
												<td class="columnlabel"><%=screen1.getLabel("RESDATEFRM")%>&nbsp;</td>
												<td class="columnlabelfree"> <font class="warnning"><%=screen1.inq.getCurrentDbRecord().getCscCalendar("RESDATEFRM").getDDMMYYYY()%></font>&nbsp;&nbsp; <%=screen1.getLabel("RESDATETO")%>&nbsp; <font class="warnning"><%=screen1.inq.getCurrentDbRecord().getCscCalendar("RESDATETO").getDDMMYYYY()%></font> </td>
										</tr>
										 <input type="hidden" name="chkRes" value="after">
							<%
								}else if(new CscCalendar().beforeDate(new CscCalendar(screen1.inq.getCurrentDbRecord().getCscCalendar("RESDATEFRM").getYYYYMMDD()))) {
							%>
										<tr> 
												<td class="columnlabel"><%=screen1.getLabel("RESDATEFRM")%>&nbsp;</td>
												<td class="columnlabelfree"> <font class="wait"><%=screen1.inq.getCurrentDbRecord().getCscCalendar("RESDATEFRM").getDDMMYYYY()%></font>&nbsp;&nbsp; <%=screen1.getLabel("RESDATETO")%>&nbsp; <font class="wait"><%=screen1.inq.getCurrentDbRecord().getCscCalendar("RESDATETO").getDDMMYYYY()%></font> </td>
										</tr>
										<input type="hidden" name="chkRes" value="before">
							<%
								}else{
							%>
										<tr> 
												<td class="columnlabel"><%=screen1.getLabel("RESDATEFRM")%>&nbsp;</td>
												<td class="columnlabelfree"> <font class="free"><%=screen1.inq.getCurrentDbRecord().getCscCalendar("RESDATEFRM").getDDMMYYYY()%></font>&nbsp;&nbsp; <%=screen1.getLabel("RESDATETO")%>&nbsp; <font class="free"><%=screen1.inq.getCurrentDbRecord().getCscCalendar("RESDATETO").getDDMMYYYY()%></font> </td>
										</tr>
										<input type="hidden" name="chkRes" value="between">
							<%
								}
							%>
							<tr> 
									<td class="columnlabel"><%=screen1.getLabel("CLASSDATEFRM")%>&nbsp;</td>
									<td><font class="normal"><%=screen1.inq.getCurrentDbRecord().getCscCalendar("CLASSDATEFRM").getDDMMYYYY()%> </font>&nbsp;&nbsp;<%=screen1.getLabel("CLASSDATETO")%>&nbsp; <font class="normal"><%=screen1.inq.getCurrentDbRecord().getCscCalendar("CLASSDATETO").getDDMMYYYY()%> </font></td>
							</tr>
							<tr> 
									<td class="columnlabel"><%=screen1.getLabel("TIMESTART")%>&nbsp;</td>
									<td><div align="left"> <font class="normal"><%=screen1.getString("TIMESTART")%></font>&nbsp;&nbsp;<%=screen1.getLabel("TIMESTOP")%>&nbsp; <font class = "normal"><%=screen1.getString("TIMESTOP")%></font></div></td>
							</tr>
							<tr> 
									<td class="columnlabel"><script language="JavaScript">swapLang('Venue')</script> &nbsp;</td>
									<td class="columnlabelfree"><div align="left"><font class = "normal"><%=screen1.getString("MTRLOCATION","LOCEDESC")%></font></div></td>
							</tr>
							<tr> 
									<td class="columnlabel"><script language="JavaScript">swapLang('Room')</script> &nbsp;</td>
									<td class="columnlabelfree"><div align="left"><font class = "normal"><%=screen1.getString("MTRROOM","ROOMEDESC")%></font></div></td>
							</tr>
							<tr> 
									<td class="columnlabel"><script language="JavaScript">swapLang('Academy')</script>&nbsp;</td>
									<td class="columnlabelfree"><div align="left"><font class = "normal"><%=screen1.getString("MACADEMY","INSTEDESC")%></font></div></td>
							</tr>
							<tr> 
									<td class="columnlabel"><%=screen1.getLabel("CLASSHOUR")%>&nbsp;</td>
									<td class="columnlabelfree"><div align="left"><font class = "normal"><%=screen1.getString("CLASSHOUR")%></font></div></td>
							</tr>
							<tr> 
									<td class="columnlabel"><script language="JavaScript">swapLang('Remark')</script>  &nbsp;</td>
									<td> <font class="warnning"><%=screen1.getString("MEMO")%> </font></td>
							</tr>
							<tr> 
									<td class="blankspace" colspan="2"></td>
							</tr>
					</table>
			</td>
	</tr>
	<%
							screen1.inq.getCurrentDbRecord().refreshChild("TTRAINRESP");
                            db=(DbInquiry)screen1.inq.getCurrentDbRecord().getChild("TTRAINRESP");
							if(db.recCount()>0){
	%>
    <tr> 
			<td> 
					<table border="0" cellspacing="0" cellpadding="0" class="maxsize" >
							<tr> 
									<td class="blankspace"></td>
							</tr> 
							<tr> 
									<td class="header"><div align="right"> <script language='javascript'>swapLang('Train Response List');</script>&nbsp;</div></td>
							</tr>
							<tr> 
									<td> 
											<table  border="1" cellpadding="0" cellspacing="1" id="rsTable" name="rsTable" class="maxsize" bgcolor="#333333" cols="3">
													<tr > 
														  <td width="148" class="row3"><div align="center"><%=screen1.getLabel("TTRAINRESP","RESPID")%></div></td>
														  <td width="190" class="row3"><div align="center"><script language='javascript'>swapLang('Name Surname');</script></div></td>
														  <td width="154" class="row3"><div align="center"><%=screen1.getLabel("TTRAINRESP","MAINRESP")%></div></td>
													</tr>
													<%
															do{
													%>
													<tr> 
														  <td class="inframe"><div align="center"><%=db.getString("RESPID")%></div></td>
														  <td class="inframe"><div align="center"><%=db.getString("V2MEMPLOYEE","FULLNAME")%> </div></td>
														  <td class="inframe"><div align="center"> <%=db.getCurrentDbRecord().getSystemCode("MAINRESP")%> </div></td>
													</tr>
													<%
															}while(db.next());
													%>
											</table>
									</td>
							</tr>
					</table>
			</td>
	</tr>
	<%
							}
							screen1.inq.getCurrentDbRecord().refreshChild("TTRAINTRNER");
                            db=(DbInquiry)screen1.inq.getCurrentDbRecord().getChild("TTRAINTRNER");
							if(db.recCount()>0){
	%>
	<tr> 
			<td> 
					<table border="0" cellspacing="0" cellpadding="0" class="maxsize" >
							<tr> 
									<td class="blankspace"></td>
							</tr>
							<tr>
									<td class="header"><div align="right"><script language='javascript'>swapLang('Trainers List');</script>&nbsp;</div></td>
							</tr>
							<tr> 
									<td> 
											<table  border="1" cellpadding="0" cellspacing="1" id="rsTable" name="rsTable" class="maxsize" bgcolor="#333333" cols="3">
													<tr > 
														  <td width="148" class="row3"><div align="center"><%=screen1.getLabel("TTRAINTRNER","TRAINERID")%></div></td>
														  <td width="190" class="row3"><div align="center"><script language='javascript'>swapLang('Name Surname');</script></div></td>
														  <td width="154" class="row3"><div align="center"><%=screen1.getLabel("TTRAINTRNER","MAINTRNER")%></div></td>
													</tr>
													<%
															do{
													%>
													<tr> 
														  <td class="inframe"><div align="center"><%=db.getString("TRAINERID")%></div></td>
														  <td class="inframe"><div align="center"><%=db.getString("MTRAINER","FULLNAME")%></div></td>
														  <td class="inframe"><div align="center"> <%=db.getCurrentDbRecord().getSystemCode("MAINTRNER")%></div></td>
													</tr>
													<%
															}while(db.next());
													%>
											  	</table>
									</td>
							</tr>
					</table>
			</td>
	</tr>
	<%
						}
							screen1.inq.getCurrentDbRecord().getChild("TTRAINTRNEE").setFilter("TRAINEEID = '"+screen.getUProfile().get("employeeid")+"'");
							screen1.inq.getCurrentDbRecord().refreshChild("TTRAINTRNEE");
                            db=(DbInquiry)screen1.inq.getCurrentDbRecord().getChild("TTRAINTRNEE");
	%>
							<input type="hidden" name="trneeCount" value="<%=db.recCount()%>">
	<%

							screen1.inq.getCurrentDbRecord().refreshChild("MCOURSE");
							db=(DbInquiry)screen1.inq.getCurrentDbRecord().getChild("MCOURSE").getChild("SIMMKC_COURSE");
							if(db.recCount()>0){
	%>
	<tr> 
			<td> 
					<table border="0" cellspacing="0" cellpadding="0" class="maxsize" >
							<tr> 
									<td class="blankspace"></td>
							</tr>
							<tr> 
									<td class="header"><div align="right"><script language='javascript'>swapLang('Involved in KC');</script>&nbsp;</div></td>
							</tr>
							<tr> 
									<td> 
											<table  border="1" cellpadding="0" cellspacing="1" id="rsTable" name="rsTable" class="maxsize" bgcolor="#333333" cols="3">
													<tr > 
														  <td width="148" class="row3"><div align="center"><script language='javascript'>swapLang('KC ID');</script></div></td>
														  <td width="190" class="row3"><div align="center"><script language='javascript'>swapLang('Description');</script></div></td>
														  <td width="154" class="row3"><div align="center"><script language='javascript'>swapLang('Group');</script></div></td>
													</tr>
													<%
															do{
													%>
													<tr> 
														  <td class="inframe"><div align="center"><%=db.getString("KCID")%></div></td>
														  <td class="inframe"><div align="center"><%=db.getString("MKEYASS","TDESC")%></div></td>
														  <td class="inframe"><div align="center"><%=db.getString("MKEYASSGROUP","TDESC")%></div></td>
													</tr>
													<%
															}while(db.next());
													%>
											  </table>
									</td>
							</tr>
					</table>
			</td>
	</tr>
	<%
						}

						db=(DbInquiry)screen1.inq.getCurrentDbRecord().getChild("MCOURSE").getChild("SIMMKPI_COURSE");
						if(db.recCount()>0){
	%>
	<tr> 
			<td> 
					<table border="0" cellspacing="0" cellpadding="0" class="maxsize" >
							<tr> 
									<td class="blankspace"></td>
							</tr>
							<tr>
									<td class="header"><div align="right"><script language='javascript'>swapLang('Involved in KPI');</script>&nbsp;</div></td>
							</tr>
							<tr> 
									<td> 
											<table  border="1" cellpadding="0" cellspacing="1" id="rsTable" name="rsTable" class="maxsize" bgcolor="#333333" cols="3">
													<tr > 
														  <td width="148" class="row3"><div align="center"><script language='javascript'>swapLang('KPI ID');</script></div></td>
														  <td width="190" class="row3"><div align="center"><script language='javascript'>swapLang('Description');</script></div></td>
														  <td width="154" class="row3"><div align="center"><script language='javascript'>swapLang('Group');</script></div></td>
													</tr>
													<%
															do{
													%>
													<tr> 
														  <td class="inframe"><div align="center"><%=db.getString("KPIID")%></div></td>
														  <td class="inframe"><div align="center"><%=db.getString("MKEYASS","TDESC")%></div></td>
														  <td class="inframe"><div align="center"><%=db.getString("MKEYASSGROUP","TDESC")%></div></td>
													</tr>
													<%
															}while(db.next());
													%>
											  </table>
									</td>
							</tr>
					</table>
			</td>
	</tr>
	<%
						}
	%>
    <tr> 
        <td> 
			<table border="0" cellspacing="0" cellpadding="0" class="maxsize" >
				 <tr> 
						 <td class="blankspace"></td>
                 </tr> 
                 <tr> 
						 <td> 
								<table border="1" cellspacing="0" cellpadding="0" class="maxsize">
										<tr rowspan = "5">
											<td width="30%" height="102" align="left" valign="top">
														<div align="right">
															<a href="javaScript:showFile_aca();"><img src="<%=picture_aca%>" name="pic_aca" width="62" height="70" border="1"></a>
														</div>
											</td>
											<td width = "10%" align = "right"><script language="JavaScript">swapLang('Academy')</script>&nbsp;&nbsp;</td>
											<td  width = "60%"><div align="left"><font class = "normal"><%=screen1.getString("MACADEMY","INSTEDESC")%></font></div></td>
										<tr>
										<tr rowspan = "5">
											<td width="30%" height="102" align="left" valign="top">
														<div align="right">
															<a href="javaScript:showFile_loc();"><img src="<%=picture_loc%>" name="pic_loc" width="62" height="70" border="1" ></a>
														</div>
											</td>
											<td width = "10%" align = "right"><script language="JavaScript">swapLang('Location')</script>&nbsp;&nbsp;</td>
											<td  width = "60%"><div align="left"><font class = "normal"><%=screen1.getString("MTRLOCATION","LOCEDESC")%></font></div></td>
										<tr>
										<tr rowspan = "5">
											<td width="30%" height="102" align="left" valign="top">
														<div align="right">
															<a href="javaScript:showFile_room();"><img src="<%=picture_room%>" name="pic_room" width="62" height="70" border="1" ></a>
														</div>
											</td>
											<td width = "10%" align = "right"><script language="JavaScript">swapLang('Room')</script>&nbsp;&nbsp;</td>
											<td  width = "60%"><div align="left"><font class = "normal"><%=screen1.getString("MTRROOM","ROOMEDESC")%></font></div></td>
										<tr>
								</table>
						</td>
				</tr>
			</table>
		</td>
	</tr>
	<tr> 
			<td class="blankspace"></td>
	</tr>
	<tr>
			<td><div align="center"><a href="javascript:GoSave();"><img src="../IMAGES/BUTTON/CONFIRM.gif" border="0"></a>
					&nbsp;&nbsp;<a href="javaScript:backhead();"><img src="../IMAGES/BUTTON/BACK.gif" border="0"></a></div></td>
			</tr>
	<tr> 
			<td class="blankspace"></td>
	</tr>
	<tr> 
			<td class="bottom"></td>
	</tr>
  </table>
</div>
						
<!----------BEGIN CSC ENDING ZONE ------------------------>

<%=screen.endJSP()%>

<!----------END CSC ENDING ZONE -------------------------->

</form>
</body>
</html>