<%@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>