<%@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>&nbsp;</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>