<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,java.util.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.databean.*,com.csc.library.download.FileDownloadUtils2" %>
<jsp:useBean id="TRA0128" class="com.csc.library.system.Task" scope="page"/>
<%
TRA0128.setChannel(request,response);
CheckNull chk = new CheckNull();
UIManager screen = (UIManager) TRA0128.process("MultiEntry","TRA012",true);
MultiLine multi = screen.getMultiLine("TTRAINDOC");
multi.setLabelBox("check box");
multi.goFirst();
screen.referLangOn();
String crsid = chk.chkNullString(request.getParameter("__crsid"));
String trainingid = chk.chkNullString(request.getParameter("__trainingid"));
String version="",start_date="",tdesc="",edesc="",filename="",line_no="";
if((request.getParameter("__chknewdoc")!=null)&&(request.getParameter("__chknewdoc").equals("refresh"))){
if((request.getParameter("__line_no")!=null) && (!request.getParameter("__line_no").equals(""))){
line_no = request.getParameter("__line_no");
}else{
line_no = "1";
}
DbRecord record = new InitialRecord(screen.getUProfile()).getDbRecord("ttraindoc");
DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inq.initMyTable("mcoursedoc","","");
inq.setColumn("companyid,line_no,version,tdesc,edesc,filename,start_date,crsid");
inq.setFilter("companyid='"+screen.getUProfile().get("companyid")+"' and crsid='"+crsid+"' and status='1'");
inq.refresh();
if((inq.recCount()) >0){
while(inq.next()){
version = chk.chkNullString(inq.getString("version"),"");
tdesc = chk.chkNullString(inq.getString("tdesc"),"");
edesc = chk.chkNullString(inq.getString("edesc"),"");
filename = chk.chkNullString(inq.getString("filename"),"");
start_date = chk.chkNullString(inq.getString("start_date"),"");
record.setColumn(multi.getTable().getCurrentRecordManager().getArrayFieldList());
record.set("trainingid",trainingid);
record.set("companyid", screen.getUProfile().get("companyid"));
record.set("line_no", line_no);
record.set("version",version);
record.set("tdesc",tdesc);
record.set("edesc", edesc);
record.set("filename", filename);
record.set("start_date", start_date);
multi.getTable().putNewRecord(record);
}
}
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</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 language="javascript">
setLang('<%=screen.getUProfile().get("lang")%>');
function goSave() {confirmSave();}
function goSearch() {search();}
function goDelete() {edelete();}
function goUpdate() {update();}
function checkCF() {checkConfirm();}
function childMulti(record){
with(document.cscform){
window.open(__childMulti.value+".jsp?__cmd=&__gorec="+record+"&__ack=edit"+
"&__trainingid="+__trainingid.value+"&__line_no="+__line_no.value+
"&__headMulti="+__screen.value,"trainTrainer","left=150,top=150,width=700,height=280,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
function addMulti(){
if(notBlankOnParentPage()){
with(document.cscform){
window.open(__childMulti.value+".jsp?__cmd=&__gorec=&__ack=add"+
"&__RecNo="+__maxrec.value+
"&__trainingid="+__trainingid.value+"&__line_no="+__line_no.value+
"&__headMulti="+__screen.value,"trainTrainer","left=150,top=150,width=700,height=280,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
}
function deleteMulti(){
with(document.cscform){
bCon=confirm("ต้องการลบข้อมูลหรือไม่ ?");
if (bCon==true) {
__cmd.value="DelChild";
submit();
}
}
}
function chknewdoc(){
with(document.cscform){
__chknewdoc.value="refresh";
submit();
}
}
function setcmd1(acktion){
with(document.cscform){
if(notBlankOnThisPage()){
bCon=confirm(MyCode[1]);
if (bCon==true){
__cmdchild.value="save";
}
submit();
}
}
}
</script>
</head>
<body leftmargin="0" topmargin="0" onload="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif','../IMAGES/BUTTON/SWAP/CALENDAR_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 -------------------------->
<input name="__cmd" type="hidden" value="">
<input type="hidden" name="__calendar">
<input type="hidden" name="__currentDate" value="<%=new CscCalendar().getEngYYYY()%>">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__cmdchild" value="<%=chk.chkNullString(request.getParameter("__cmdchild"))%>">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__afterUpdate" value="">
<input type="hidden" name="__confirm" value="">
<input type="hidden" name="__screen" value="TRA012">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__childMulti" value="">
<input type="hidden" name="__gorec" value="">
<input type="hidden" name="__ack" value="">
<input type="hidden" name="__trainingid" value="<%=screen.getDataLabel("trainingid")%>">
<input type="hidden" name="__assorid" value="<%=screen.getUProfile().getUserId()%>">
<input type="hidden" name="__multiTable" value="TTRAINDOC">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__maxrec" value="<%=screen.getTable("TTRAINDOC").recCount()%>">
<input type="hidden" name="__notNull" value="<%=screen.getRequire()%>">
<input type="hidden" name="__chknewdoc" value="<%=chk.chkNullString(request.getParameter("__chknewdoc"))%>">
<input type="hidden" name="__crsid" value="<%=chk.chkNullString(request.getParameter("__crsid"))%>">
<table cellpadding="0" cellspacing="0" class="maxsize">
<tr >
<td class="header"> TRA0128, <script language="javascript">swapLang('Training document');</script> </td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="1" id="rsTable" name="rsTable" bgcolor="#333333" class="maxsize" cols="5">
<tr >
<td class="row3" width ="7%"><div align="center"><a href="javascript:sortTable(1, rsTable);"><script language='javascript'>swapLang('Order');</script></a></div></td>
<td class="row3" width="13%"><div align="center"><a href="javascript:sortTable(2, rsTable);"><script language='javascript'>swapLang('Version');</script></a></div></td>
<td class="row3" width="30%"><div align="center"><a href="javascript:sortTable(3, rsTable);"><script language='javascript'>swapLang('Start date');</script></a></div></td>
<td class="row3" width="25%"><div align="center"><a href="javascript:sortTable(4, rsTable);"><script language='javascript'>swapLang('Description');</script></a></div></td>
<td class="row3" width="25%"><div align="center"><a href="javascript:sortTable(5, rsTable);"><script language='javascript'>swapLang('Attachment list');</script></a></div></td>
</tr>
<%
for(int i=1;!multi.eof();multi.next(),i++){
String path = multi.getTable().getCurrentRecordManager().getDownloadUrl("FILENAME");
%>
<tr>
<td class="inframe"><div align="center"><input type="hidden" name="__line_no" value="<%=multi.getData("LINE_NO")%>"><%=i%></div></td>
<td class="inframe"><div align="center"><%=multi.getData("VERSION")%></div></td>
<td class="inframe"><div align="center"><%=multi.getData("START_DATE")%></div></td>
<td class="inframe"><div align="center"><%=multi.getData("TDESC")%></div></td>
<td class="inframe"><div align="center"><a href="<%=path %>"><%=multi.getData("FILENAME")%></a></div></td>
</tr>
<% }
%>
</table>
</td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td class="buttonline" colspan="7"><div align="center">
<a href="javascript:chknewdoc();"><img src="../IMAGES/BUTTON/REFRESH.gif" border="0" align="middle"></a>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
</table>
<script language="javascript">window.parent.setTabPages();</script>
</form>
</body>
</html>