package com.logistic.taglib;

import com.logistic.data.DataConnect;
import com.logistic.business.MessageManager;
import com.logistic.model.MessageInfo;
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;
import java.sql.SQLException;
public class MessageAdmin extends TagSupport {
	
	private static final long serialVersionUID = 7766184319541530720L;
	
	DataConnect dc=new DataConnect();
	Statement stat=null;
	ResultSet rs=null;
	String sqlemploy;
	String employeename;
	
	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 messageinfotable order by MessageTime desc");
	    	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;
		    	   }
	    	MessageManager mm=new MessageManager();
	        Vector items=mm.MessageSearch(sqls, page);
	        
	        out.println("<table width=\"748\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#6699CC\">");
	        //輸出公告信息表格頭
	        out.println("<tr align=\"center\" valign=\"middle\">");
	        out.println("<td colspan=\"9\" class=\"code style25\">公告信息管理</td>");
	        out.println("</tr>");
	        int span=5,j=0;//span標(biāo)識(shí)每頁(yè)顯示5條信息，j是一個(gè)計(jì)數(shù)器
	        
	        for(int i=0;i<items.size();i++){
	        	
	        	MessageInfo mbean=(MessageInfo)items.elementAt(i);
	        	try{
	        	sqlemploy="select *from employeeinfotable where EmployeeId="+mbean.getEmployeeid();
				stat=dc.getStmtread();
				rs=stat.executeQuery(sqlemploy);
				while(rs.next()){
				 employeename=rs.getString("EmployeeName");
				}
	        	}catch(SQLException ex){
	        		ex.printStackTrace();
	        		}finally{dc.close();}
				//輸出公告留言人，留言主題，留言時(shí)間，公告內(nèi)容

				out.println("<tr>");
	        	out.println("<td width=\"60\" height=\"24\" align=\"center\" class=\"code\">留言人:</td>");
	        	out.println("<td width=\"60\" align=\"left\" class=\"code\">"+employeename+"</td>");
	        	out.println("<td width=\"82\" align=\"right\" class=\"code\">留言主題:</td>");
	        	out.println("<td colspan=\"2\" align=\"left\" class=\"code\">"+mbean.getMessagetitle()+"</td>");
	        	out.println("<td width=\"72\" align=\"right\" class=\"code\">留言時(shí)間:</td>");
	        	out.println("<td colspan=\"2\" align=\"left\" class=\"code\">"+mbean.getMessagetime()+"</td>");
	        	out.println("<td width=\"10\" align=\"center\" class=\"code\"><a href=\"adminmessage.jsp?messageid="+mbean.getMessageid()+"\" onClick=\"{if(confirm('此操作將刪除當(dāng)前記錄!刪除后將不能恢復(fù)，您確定執(zhí)行的操作嗎?')){return true;}return false;}\"><img src=\"../../image/delete.gif\" border=\"0\"></a></td>");
	        	out.println("</tr>");
	        	out.println("<tr>");
	        	out.println("<td height=\"45\" align=\"right\" class=\"code\">公告內(nèi)容:</td>");
	        	out.println("<td colspan=\"8\" align=\"center\" class=\"code\">"+mbean.getMessagecontent()+"</td>");
	        	out.println("</tr>");
	        	j++;
	        	if(j==span)break;
	        }
	        out.println("<tr align=\"center\" bgcolor=\"#FF9999\" class=\"code\">");
	        out.println("<td height=\"20\" colspan=\"3\" align=\"left\">頁(yè)次:"+currentpage+"/"+totalpages+"頁(yè)&nbsp;每頁(yè)5條信息"+count+"</td>");
	        out.println("<td width=\"73\" align=\"center\" class=\"style5\"><a href=\"adminmessage.jsp?arg1=-1\"><img src=\"../../image/begin.jpg\" width=\"63\"s height=\"18\"border=\"0\"></a></td>");
	        out.println("<td width=\"73\" align=\"center\" height=\"20\" class=\"style5\"><a href=\"adminmessage.jsp?arg2=-2\"><img src=\"../../image/1-prev.gif\" border=\"0\"></a></td>");
	        out.println("<td width=\"73\" align=\"center\" height=\"20\" class=\"style5\"><a href=\"adminmessage.jsp?arg3=-3\"><img src=\"../../image/1-next.gif\" border=\"0\"></a></td>");
	        out.println("<td width=\"73\" align=\"center\" class=\"style5\"><a href=\"adminmessage.jsp?arg4=-4\"><img src=\"../../image/end.jpg\" width=\"63\"s height=\"18\" border=\"0\"></a></td>");
	        out.println("<td height=\"20\" width=\"100\"></td>");
	        out.println("</tr>");
	        out.println("</table>");
	        
	       
	        }catch(Exception ex){
	    	     ex.printStackTrace();
	        }finally{dc.close();}
		return SKIP_BODY;
	}

}