package com.logistic.taglib;

import com.logistic.data.DataConnect;

import com.logistic.business.WareHouseManager;
import com.logistic.model.WareHouseInfo;
import java.util.Vector;
import javax.servlet.jsp.tagext.TagSupport;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.http.HttpServletRequest;
import java.sql.ResultSet;
import java.sql.Statement;

public class WareHouseAdmin extends TagSupport {
	
	private static final long serialVersionUID = 7766184319541530720L;
	
	DataConnect dc=new DataConnect();
	Statement stat=null;
	ResultSet rs=null;
	String    chargename=null;
	
	public int doEndTag() throws JspException{
		
		JspWriter out=pageContext.getOut();
		HttpServletRequest request=(HttpServletRequest)pageContext.getRequest();
    
		String str=(String)request.getQueryString();
		int page;
		if(str==null||str.equals("")){
			page=1;
		}else{
			String[] aa=str.split("=");
			page=Integer.parseInt(aa[1]);
		}
    
       try{
    	   		String sqls=new String("select * from warehouseinfotable order by ID ASC");
    	   		int count=dc.selectdata(sqls);
    	   		int totalpages=0;
    	   		if(count%5==0){
    	   			totalpages=count/5;
    	   		}else{
    	   			totalpages=count/5+1;
    	   		}	
    	
    	   		int currentpage=1;
    	   		if(page==-4){
    	   			currentpage=totalpages;
    	   		}else if(page==-3){
    	   			currentpage=currentpage+1;
    	   		}else if(page==-2){
    	   			if(currentpage==1){
    	   				currentpage=1;
    	   			}else{
    	   				currentpage=currentpage-1; 
    	   			}
    	   		}else{
    	   			currentpage=1;
    	   			}
    	   		
    	       WareHouseManager whm=new WareHouseManager();
    	       Vector items=whm.WareHouseSearch(sqls, page);
    	       
    	       //輸出倉庫信息表格頭
    	       out.println("<table width=\"580\" height=\"22\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
    	       out.println("<tr>");
    	       out.println("<td width=\"565\" height=\"20\" align=\"center\" class=\"style14\">&nbsp;&nbsp;&nbsp;&nbsp;倉庫信息列表</td>");
    	       out.println("</tr>");
    	       out.println("</table>");

    	       int span=5,j=0;//span標識每頁顯示5條信息，j是一個計數器
    	 	   String path=request.getContextPath();
    	 	   for(int i=0;i<items.size();i++){
    	 		   
    	 		   WareHouseInfo whi=(WareHouseInfo)items.elementAt(i);
    	 		   
    	 		   //根據倉庫負責人的編號取得其姓名
    	 		   try{
    	 			   String strsql="select * from employeeinfotable where EmployeeId="+whi.getChargeid();
    	 			   stat=dc.getStmtread();
    	 			   rs  =stat.executeQuery(strsql);
    	 			   while(rs.next()){
    	 				   chargename=rs.getString("EmployeeName");
    	 			   }
    	 			   
    	 		   }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
    	 		   
    	 		   //輸出詳細的倉庫信息
    	 		   out.println("<table width=\"580\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
    	 		   out.println("<tr>");
    	 		   out.println("<td width=\"72\" align=\"right\" class=\"code\" bgcolor=\"#FFCCCC\">倉庫名稱:</td>");
    	 		   out.println("<td width=\"147\" align=\"center\" class=\"code\">"+whi.getWarehousename()+"</td>");
    	 		   out.println("<td width=\"85\" align=\"right\" class=\"code\" bgcolor=\"#FFCCCC\">倉庫負責人:</td>");
    	 		   out.println("<td width=\"132\" align=\"center\" class=\"code\">"+chargename+"</td>");
    	 		   out.println("<td width=\"172\" align=\"center\">&nbsp;&nbsp;<a href=\""+path+"/viewpage/datamodify/warehousemodify?wid="+whi.getWarehouseid()+"\"><img src=\""+path+"/image/edit.gif\" border=\"0\"></a>&nbsp;&nbsp;&nbsp;" +
	    	   		           "<a href=\"adminwarehouse.jsp?warehouseid="+whi.getWarehouseid()+"\" onClick=\"{if(confirm('此操作將刪除當前記錄!刪除后將不能恢復,您確定執行的操作嗎?')){return true;}return false;}\"><img src=\""+path+"/image/delete.gif\" border=\"0\"></a></td>");
    	 		   out.println("</tr>");
    	 		   out.println("<tr>");
    	 		   out.println("<td align=\"right\" class=\"code\" bgcolor=\"#FFCCCC\">倉庫位置:</td>");
    	 		   out.println("<td colspan=\"4\" align=\"center\" class=\"code\">"+whi.getWarehouseadd()+"</td>");
    	 		   out.println("</tr>");
    	 		   out.println("</table>");
    	 		   out.println("<table width=\"580\" height=\"10\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
    	 		   out.println("<tr>");
    	 		   out.println("<td bgcolor=\"#999999\">&nbsp;</td>");
    	 		   out.println("</tr>");
    	 		   out.println("</table>");
    	 		  
    	 		   j++;
    	 		   if(j==span)break;
    	 	   }
    	       
    	 	   
	 		       out.println("<table width=\"580\" height=\"22\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	 		       out.println("<tr>");
	 		       out.println("<td width=\"203\" height=\"20\" align=\"left\" class=\"code\">頁次:"+currentpage+"/"+totalpages+"頁;每頁5條信息共"+count+"條</td>");
	 		       out.println("<td width=\"367\" height=\"20\" align=\"center\"><a href=\"adminwarehouse.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		               "<a href=\"adminwarehouse.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		               "<a href=\"adminwarehouse.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		               "<a href=\"adminwarehouse.jsp?arg4=-4\"><img src=\""+path+"/image/end.jpg\" border=\"0\"></a></td>");	
	 		       out.println("</tr>");
	 		       out.println("</table>");
	 		       
       }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
    
       return SKIP_BODY;   
	}

}