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

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import bit.jeffy.db.DataStore;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.File;

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

	/* （非 Javadoc）
	 * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping, org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	 */
	public ActionForward execute(ActionMapping map, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		// TODO 自動生成方法存根
		ActionErrors errors = new ActionErrors();
		HttpSession session = request.getSession();
		
		String str_1 = (String)request.getParameter("t_page");
		
		String filename = (String)request.getParameter("file");
		String user = (String)session.getAttribute("current_user");
		
		if( filename == null ) {
			errors.add("fail_1",new ActionError("file.delete.action.a"));
			saveErrors(request,errors);
			return (map.findForward("filedeletefail"));
		}else {
			filename = new String(filename.getBytes("ISO-8859-1"),"GB2312");
		}
		
		if( user == null ) {
			errors.add("fail_2",new ActionError("file.delete.action.b"));
			saveErrors(request,errors);
			return (map.findForward("filedeletefail"));
		}else {
			user = new String(user.getBytes("ISO-8859-1"),"GB2312");
		}
		
		DataStore ds = DataStore.getInstance();
		ResultSet rs = null;
		float filesize = 0;
		String sql_0 = "select * from ClientFile where ZH='"+user+"' and FILENAME='"+
		filename+"'";
	
		try {
			rs = ds.read(sql_0);
			if( rs != null && rs.next() ) {
				filesize = rs.getFloat("FILESIZE");
			}
		}catch(SQLException e) {
			errors.add("fail_3",new ActionError("file.delete.action.c"));
			saveErrors(request,errors);
			return (map.findForward("filedeletefail"));
		}
		
		
		String sql_1 = "delete from ClientFile where ZH='"+user+"' and FILENAME='"+
		filename+"'";
		String sql_2 = "update ClientFileSpace " +
					   "set FILEEXIST=FILEEXIST-"+filesize+
					   ",FILECOUNT=FILECOUNT-1 "+
					   "where ZH='"+user+"'";
		
		ds.beginTransaction();
		
		try {
			ds.execute(sql_1);
			ds.execute(sql_2);
		}catch(Exception e) {
			ds.ErrorOccur();
			ds.commitTransaction();
			errors.add("fail_3",new ActionError("file.delete.action.c"));
			saveErrors(request,errors);
			return (map.findForward("filedeletefail"));
		}
		
		String dir = servlet.getServletContext().getRealPath("/file/"+user);
		File f = null;
		
		try {
			f = new File(dir+"/"+filename);
			if( f.isFile() ) {
				f.delete();
			}
		}catch(Exception e) {
			errors.add("fail_4",new ActionError("file.delete.action.d"));
			saveErrors(request,errors);
			ds.ErrorOccur();
			ds.commitTransaction();
			return (map.findForward("filedeletefail"));
		}
		
		ds.commitTransaction();		
		
		if( str_1 != null ){
			request.setAttribute("page",str_1);
		}
		request.setAttribute("view","2");
		return (map.findForward("filedeleteok"));
	}
}