/*
 * 創建日期 2005-12-11
 *
 * TODO 要更改此生成的文件的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
package bit.jeffy.tags;

import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.TagSupport;
import javax.servlet.http.HttpServletRequest;

import bit.jeffy.db.DataStore;

import org.omg.IOP.Encoding;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * @author jeffy
 *
 * TODO 要更改此生成的類型注釋的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
public class MyShareFile extends TagSupport {

	/* （非 Javadoc）
	 * @see javax.servlet.jsp.tagext.Tag#doEndTag()
	 */
	public int doEndTag() throws JspException {
		// TODO 自動生成方法存根
		
		JspWriter out = pageContext.getOut();
		HttpServletRequest request = (HttpServletRequest)pageContext.getRequest();
		DataStore ds = DataStore.getInstance();
		ResultSet rs = null;
		String dir = pageContext.getServletContext().getRealPath("/file");
		String sql_count = "select count(*) from ClientFile where IFPUBLIC='1'";
		String sql = "select * from ClientFile where IFPUBLIC='1'";
		String filename = null, user = null, tmp = null, tmp_1 = null;
		Encoding encode = new Encoding();
		byte[] f = null;
		float size=0;
		int file_count = 0, total_page = 0, page = 0, left_count = 0;
		
		try {
			file_count = ds.readCount(sql_count);
		}catch(Exception e) {
			file_count = 0;
		}
		
		total_page = file_count/6;
		left_count = file_count%6;
		
		try {
			rs = ds.read(sql);
		}catch(Exception e) {
			rs = null;
		}
		
		try {
			tmp_1 = (String)request.getParameter("page");
			if( tmp_1 == null )
				page = 0;
			else 
				page = Integer.parseInt(tmp_1);
		}catch(Exception e) {
			page = 0;
		}
		
		int i = 0;
		try {
			out.print("<table width=800 height=110 border=1 cellpadding=0 cellspacing=0 bordercolor=#0066FF>");
			out.print("<tr align=center><td height=42 colspan=4 class=BodyHeader_Middle>文件列表</td></tr>");
			out.print("<tr><td width=40% height=38 align=center class=buttonText>文件名</td>");
			out.print("<td width=30% align=center class=buttonText>上傳用戶</td>");
			out.print("<td width=20% align=center class=buttonText>大小(KB)</td>");
			out.print("<td width=10% align=center class=downloadText>下載</td></tr>");
				
			for( i = 0; i < page*6; i++ ) {
				if( rs != null && rs.next() ) {
					
				}
			}
			
			i = 0;
			while( (rs != null) && (rs.next()) && (i < 6)) {
				user = rs.getString("ZH");
				filename = rs.getString("FILENAME");
				size = rs.getFloat("FILESIZE");
				
				out.print("<tr>");
				out.print("<td height=38 align=center class=normal_1Text>"+filename+"</td>");
				out.print("<td align=center class=normal_1Text>"+user+"</td>");
				out.print("<td align=center class=normal_1Text>"+size+"</td>");
				tmp = dir+"/"+user+"/"+filename;
				out.print("<td align=center class=normal_1Text><a href="+tmp+">下載</a></td>");
				out.print("</tr>");
				i ++;
			}
			
			out.print("<tr><td align=center colspan=4><table width=60% height=27 border=0 cellpadding=0 cellspacing=0><tr>");
			
			if( page > 0 ) {
				out.print("<td align=center class=normal_1Text><a href=Share.jsp?page=0>首頁</a>");
				out.print("<td align=center class=normal_1Text><a href=Share.jsp?page="+(page-1)+">上一頁</a>");
			}else {
				out.print("<td align=center class=normal_1Text>首頁</td>");
				out.print("<td align=center class=normal_1Text>上一頁</td>");
			}
			
			if( page < (total_page-1) || ( page == (total_page-1))&&left_count>0  ) {
				out.print("<td align=center class=normal_1Text><a href=Share.jsp?page="+(page+1)+">下一頁</a></td>");
				out.print("<td align=center class=normal_1Text><a href=Share.jsp?page="+total_page+">末頁</a>");
			}else {
				out.print("<td align=center class=normal_1Text>下一頁</td>");
				out.print("<td align=center class=normal_1Text>末頁</td>");
			}
			
			out.print("</tr></table></td></tr>");
			out.print("</table>");
		
		}catch(Exception e) {
			
		}
		
		return super.doEndTag();
	}
}