queryplanaction.java

大唐电信的管理系统

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

import java.util.ArrayList;
import java.util.List;

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.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import domain.User;

import service.PlanService;
import service.TaskService;

import factory.ServiceFactory;


public class QueryPlanAction extends Action {
	TaskService taskService = ServiceFactory.getTaskService();
	PlanService planService = ServiceFactory.getPlanService();
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		
		HttpSession session=request.getSession();
		String flag=request.getParameter("flag");
	
		User loginuser=(User)session.getAttribute("loginUser");

		List tasklist=taskService.findTaskByMyUsername(loginuser.getName());
		
	    
		if("page".equals(flag)){
			request.setAttribute("tasklist", tasklist);
			request.setAttribute("planlist", new ArrayList());
		}else{
			
			String planname=""+request.getParameter("planname");
			String taskid=""+request.getParameter("taskid");
			String begintime1=""+request.getParameter("begintime1");
			
			List planlist=new ArrayList();
			
			String begintime2=""+request.getParameter("begintime2");
			String endtime1=""+request.getParameter("endtime1");
			String endtime2=""+request.getParameter("endtime2");
			String feedback=""+request.getParameter("feedback");
			
String sql="from Plan where taskId in (select id from Task where user_name="+"'"+loginuser.getName()+"')";
          
			
			
			
			if(planname.equals("")&&taskid.equals("")&&begintime1.equals("")&&begintime2.equals("")&&
					endtime1.equals("")&&endtime2.equals("")&&feedback.equals("")){


				planlist =planService.queryPlan(sql);
				
			}else{
			    if(!planname.equals("")){
			        sql=sql+" and  plan_name='"+planname+"'";
			    }

			    if(!taskid.equals("")){

			    	sql=sql+" and  task_id='"+taskid+"'";
			    }
			    if(!begintime1.equals("")&&!begintime2.equals("")){
			    	sql=sql+" and plan_begin between '"+begintime1+"'"+"and '"+begintime2+"'";
			    	
			    }
			    if(!endtime1.equals("")&&!endtime1.equals("")){
			    	sql=sql+"and plan_end between '"+endtime1+"'"+"and '"+endtime2+"'";
			    }
			    if(!feedback.equals("")){
			    	sql=sql+"and plan_feedbackstate='"+feedback+"'";
			    }

			    planlist =planService.queryPlan(sql);

			    
			}

		    request.setAttribute("tasklist", tasklist);	
			request.setAttribute("planlist", planlist);
			
		}
		return new ActionForward("queryPlanView");
	}
}