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

import java.sql.ResultSet;

import javax.servlet.jsp.JspWriter;
import javax.servlet.http.HttpServletRequest;

import bit.jeffy.db.DataStore;

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

	private JspWriter out;

	private String ZH = null;

	private DataStore ds = null;
	
	private int page = 0;
	
	private HttpServletRequest request = null;

	public ClientFileManagement(JspWriter jw, String user, String pg,
			HttpServletRequest re ) {
		out = jw;
		ZH = user;
		
		if (ds == null)
			ds = DataStore.getInstance();
		
		if( pg != null )
			page = Integer.parseInt(pg);
		
		request = re;
	}

	public void doplay() throws Exception {

		ResultSet st_1 = null, st_2 = null;;
		String sql_1 = "select * from ClientFileSpace where ZH='" + ZH + "'";
		String sql_2 = "select * from ClientFile where ZH='" + ZH + "'";
 		String tmp = " ", str_page = "", tmp_attri = null;
 		int total_count = 0, turn_count = 0, i, total_page = 0, left_count = 0;
 		float itmp = 0;
 		boolean page_up = true, page_down = true;
 		float total_space = 0, exist_space = 0;
 		
		if (ds != null){
			st_1 = ds.read(sql_1);
		}

		if(st_1 != null && st_1.next()) {
			total_space = st_1.getFloat("FILESPACE");
			exist_space = st_1.getFloat("FILEEXIST");
			total_count = st_1.getInt("FILECOUNT");	
		}
		
		turn_count = 5*page;
		total_page = total_count/5;
		left_count = total_count%5;
		
		if( (turn_count>total_count) && (turn_count>(total_count-5)) ){
			page_down = false;
		}
		if( (turn_count-5 < 0) ){
			page_up = false;
		}
			
			
		if( ds != null )
			st_2 = ds.read(sql_2);
		
		for( i = 0; i < turn_count; i ++ ){
			if( !st_2.next() )
				break;
		}
	
		out.print("<table width=97% height=300 border=1 cellpadding=1 cellspacing=0 bordercolor=#0099FF>");
		out.print("<tr><td colspan=4 class=bookText>&nbsp;&nbsp;&nbsp;用戶剩余空間:");
    	out.print(" "+(int)(total_space-exist_space)+"KB</td></tr>");
		out.print("<tr align=center><td colspan=4 class=BodyHeader_Middle>用戶文件列表</td></tr>");
    	out.print("<tr><td width=30% height=25 class=bookText>文件名</td>");
    	out.print("<td width=25% class=bookText>上傳日期</td>");
    	out.print("<td width=15% class=bookText>大小(KB)</td>");
    	out.print("<td width=30% class=bookText>操作</td></tr>");
    	
    	String filename = null;
    	int ifshare = 0;
    	
	    for( i = 0; i < 5; i ++ ){
	    	out.print("<tr>");
	    	if( st_2.next() ){
	    		tmp = st_2.getString("FILENAME");
	    		filename = tmp;
	    		out.print("<td><a href=/PersonalPlatform/file/"+ZH+"/"+tmp+">"+tmp+"</a></td>");
	    		itmp = st_2.getFloat("FILESIZE");
	    		tmp = st_2.getString("UPLOADTIME");
	    		ifshare = st_2.getInt("IFPUBLIC");
	    		out.print("<td class=bookText>"+tmp+"</td>");	
	    		out.print("<td class=bookText>"+itmp+"</td>");
	    		out.print("<td class=bookText><a href=/PersonalPlatform/FileDelete.do?t_page="+page+"&file="+filename+">[刪除]</a>");
	    		out.print("&nbsp&nbsp&nbsp");
	    		if( ifshare == 0)
	    			out.print("<a href=/PersonalPlatform/FileShare.do?t_page="+page+"&file="+filename+"&activity=share>[共享]</a>"); 			
		    	else
		    		out.print("<a href=/PersonalPlatform/FileShare.do?t_page="+page+"&file="+filename+"&activity=noshare>[撤消共享]</a>");
	    		out.print("</td></tr>");
	    	}
	    	else{
	    		out.print("<td>&nbsp</td><td>&nbsp</td><td>&nbsp</td><td>&nbsp</td>");
	    	}
	    	
	    }
	    
	    out.print("<tr><td colspan=4><table width=756 border=0 cellspacing=0><tr>");
	    out.print("<td width=156 align=center valign=middle class=bookText>");
	    if( page > 0 ) {
	    	out.print("<a href=/PersonalPlatform/ChooseView.do?target=2&t_page=0>首頁</a></td>");
	    	out.print("<td width=160 align=center valign=middle class=bookText>");
		    out.print("<a href=/PersonalPlatform/ChooseView.do?target=2&t_page="+(page-1)+">");
		    out.print("上一頁</a></td>");
	    }else {
	    	out.print("首頁</td>");
	    	out.print("<td width=160 align=center valign=middle class=bookText>上一頁</td>");
	    }
	    
	    if( page < (total_page-1) || ( page == (total_page-1))&&left_count>0 ){
	    	out.print("<td width=179 align=center valign=middle class=bookText>");
	    	out.print("<a href=/PersonalPlatform/ChooseView.do?target=2&t_page="+(page+1)+">");
		    out.print("下一頁</a></td>");
		    out.print("<td width=108 align=center valign=middle class=bookText>");
		    out.print("<a href=/PersonalPlatform/ChooseView.do?target=2&t_page="+total_page+">末頁</a></td>");
		    
	    }
	    else{
	    	out.print("<td width=179 align=center valign=middle class=bookText>下一頁</td>");
	    	out.print("<td width=108 align=center valign=middle class=bookText>");
	    	out.print("末頁</td>");
	    }
	       	
	    out.print("<td width=143 align=center valign=middle class=bookText>");
	    out.print("<a href=/PersonalPlatform/FileUpload.jsp>上傳新文件</a></td>");
	    out.print("</tr></table></td></tr></table>");
	    
	    
	    
	}
}