/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package kignbi.dong.action;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import kignbi.dong.*;
import kignbi.dong.form.AddBorrowForm;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

/** 
 * MyEclipse Struts
 * Creation date: 01-31-2008
 * 
 * XDoclet definition:
 * @struts.action path="/addBorrow" name="addBorrowForm" input="/admin/addborrow.jsp" scope="request" validate="true"
 * @struts.action-forward name="success" path="/admin/borrowlist.jsp"
 * @struts.action-forward name="false" path="/admin/addborrow.jsp"
 */
public class AddBorrowAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception{
		AddBorrowForm addBorrowForm = (AddBorrowForm) form;// TODO Auto-generated method stub
		String bid=addBorrowForm.getBid();
		String uid=addBorrowForm.getUid();
		//String dt_borrow=addBorrowForm.getDt_borrow();
		//String dt_return=addBorrowForm.getDt_return();
		String remark=addBorrowForm.getRemark();
		int number=0+Integer.parseInt(addBorrowForm.getNumber());
		int not_num=0+Integer.parseInt(addBorrowForm.getNumber());
		int days=0+Integer.parseInt(addBorrowForm.getDays());
		ActionMessages errors = new ActionMessages();
		String PageForward = "false";
		ServletContext context = servlet.getServletContext();
		DataSource dataSource = (DataSource) context.getAttribute(Constants.DATASOURCE_KEY);
		DB db = new DB(dataSource);
		String str="select *"
			+"from borrow where not_num!=0 and state!=0";//數據庫中有效借書記錄
	    String sql="insert into borrow (uid,bid,number,not_num,days,remark ) values ('"
	    	   +uid+"','"+bid+"',"+number+","+number+","+days+",'"+remark+" ')";//插入借書記錄
	    
	    
	    String sql2="insert into dayflow (uid,bid,ftype,fnum) values ('"+uid+"','"+bid+"','借',"+number+")";//寫日志
	    String p1="select bnumber from books where dbo.trim(bid)='"+bid+"'";//查詢圖書數量
	    String per="select * from users where dbo.trim(uid)='"+uid+"'";
	    ResultSet rr1=db.OpenSql(per);
	    if(rr1.next()){
	    	
	   
	    ResultSet r1=db.OpenSql(p1);
	     if( r1.next()){//p1
	    		 int a=r1.getInt("bnumber");
	    		 int c=a-number;
	    		 if(c>=0){//借的數量不大于圖書剩余的數量
	             String sql3="update books set bnumber="+c+"where bid='"+bid+"'";
	            
	             int status=db.ExecSql(sql);//借書
	             System.out.print("str:"+sql+"\n");
	             int state=db.ExecSql(sql2);//插入流水記錄
	             System.out.print("str:"+sql2+"\n");
	             int sta1=db.ExecSql(sql3);
	             System.out.print("str:"+sql3+"\n");
	             if(state==1){
	    	        ResultSet rs=db.OpenSql(str); //查詢借書記錄
	    	        ArrayList res=new ArrayList();
	    	        int i=0;
	    	        while(rs.next()&i<10){
	    		       i=i+1;
		    		Borrow borrow = new Borrow();
		    		borrow.setId(rs.getString("id"));
					borrow.setUid(rs.getString("uid"));
					borrow.setBid(rs.getString("bid"));
				    borrow.setDt_borrow(rs.getString("dt_borrow"));
					borrow.setDt_return(rs.getString("dt_return"));
		            borrow.setNumber(rs.getInt("number"));
		            borrow.setNot_num(rs.getInt("not_num"));
		            borrow.setDays(rs.getInt("days"));
		            borrow.setRemark(rs.getString("remark"));
		            res.add(borrow);
	    	      }
			    	String count=Integer.toString(i);
			        request.setAttribute("count", count);
			        request.setAttribute("borrows",res);
			        PageForward="success";
	             }
	    		
	     else {
			  errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("add.borrow.failture"));
	         if (!errors.isEmpty()) {
		       saveErrors(request, errors);
		     }
	     }
	    		 }
	    		 else{
	    			  errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("add.borrow.noenoughnumber"));
	    		 
		            if (!errors.isEmpty()) {
				       saveErrors(request, errors);
	    			 }
	    		 }
	     }
	     else {
	    	 errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("add.borrow.nothisbook"));
	         if (!errors.isEmpty()) {
		       saveErrors(request, errors);
	         }
			
		 }
	    }
	    else {
	    	errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage("add.borrow.nothisuser"));
	         if (!errors.isEmpty()) {
		       saveErrors(request, errors);
	         }
	    }
			db.close();
			return mapping.findForward(PageForward);
  }
}