actionent_plan_following.java

公司CRM部分原代码,采用的是java技术.

	   return this.getTargetPage("summary");
	  }
  public String viewStationDay(HttpServletRequest request, HttpServletResponse response)throws Exception {
	    
		java.util.Calendar test = Calendar.getInstance(java.util.Locale.CHINA);
	    java.sql.Date  now = new java.sql.Date(System.currentTimeMillis());
	    test.setTime(now);
	    now.getTime();
	    SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd",
				Locale.SIMPLIFIED_CHINESE);
		String timestamp = sdf.format(now);
		String name = new String (request.getParameter("station").getBytes("iso-8859-1"),"GBK");
	    
		String where = " Ent_Plan_Following.chStation like '%" +name.trim()+"%'"+" and Ent_Plan_Following.dtTrackingDate between TO_DATE('" + timestamp.trim() + "','yyyy-MM-dd')"+" and TO_DATE('" + timestamp.trim() + "','yyyy-MM-dd')";
	    String order = "id desc";
	    EnEnt_Plan_Following[] aEnEnt_Plan_Following = (EnEnt_Plan_Following[]) (DAOBase
			.findByCondition(new DbAccess(), EnEnt_Plan_Following.class
					.getName(), where, order));
	    //System.out.println("--name--"+name);
	    for (int i = 0; i < aEnEnt_Plan_Following.length; i++) {
		if (!aEnEnt_Plan_Following[i].getDtTrackingDate().equals("")) {
			String year = aEnEnt_Plan_Following[i].getDtTrackingDate().substring(0, 4);
			String month = aEnEnt_Plan_Following[i].getDtTrackingDate().substring(5, 7);
			String day = aEnEnt_Plan_Following[i].getDtTrackingDate().substring(8, 10);
			aEnEnt_Plan_Following[i].setDtTrackingDate(year + month + day);
		}
		if (!aEnEnt_Plan_Following[i].getDtPlanTrackingDate().equals("")) {
    		String year = aEnEnt_Plan_Following[i].getDtPlanTrackingDate()
			.substring(0, 4);
	     String month = aEnEnt_Plan_Following[i].getDtPlanTrackingDate()
			.substring(5, 7);
	     String day = aEnEnt_Plan_Following[i].getDtPlanTrackingDate()
			.substring(8, 10);
	     aEnEnt_Plan_Following[i].setDtPlanTrackingDate(year + month + day);
        }
	   }
	    //System.out.println("tttttday");
	    if(aEnEnt_Plan_Following!=null) {
	    	//System.out.println("ttttt222");
	        for(int i=0; i<aEnEnt_Plan_Following.length;i++) {
	        	aEnEnt_Plan_Following[i] = GDPE.follow.plan.ActionEnt_Plan_Following.viewInfo(aEnEnt_Plan_Following[i]);
	        }}
	   request.setAttribute("aEnEnt_Plan_Following", aEnEnt_Plan_Following);
	   return this.getTargetPage("summary");
	  }
  public String viewFollow(HttpServletRequest request,
			HttpServletResponse response) throws Exception {

		//HttpSession session = request.getSession(false);
		User user = (User)UserInfo.getInstance(request);
		String idstr = user.getId();
		
		DAODisplay dd = new DAODisplay();
		Vector vt = dd.queryStationFollow();
		request.setAttribute("vt",vt);
		
		return this.getTargetPage("viewFollow");
	}
  
  public String viewFollowDay(HttpServletRequest request,
			HttpServletResponse response) throws Exception {

		//HttpSession session = request.getSession(false);
		User user = (User)UserInfo.getInstance(request);
		String idstr = user.getId();
		
		DAODisplayDay dd = new DAODisplayDay();
		Vector vt = dd.queryStationFollow();
		request.setAttribute("vt",vt);
		
		return this.getTargetPage("viewFollowDay");
	}
  public String hebingDay(HttpServletRequest request,
			HttpServletResponse response) throws Exception {

		//HttpSession session = request.getSession(false);
		User user = (User)UserInfo.getInstance(request);
		String idstr = user.getId();
		
		DAODisplayDay dd = new DAODisplayDay();
		Vector vt = dd.queryAuditorFollow();
		
		DAODisplayDay dd2 = new DAODisplayDay();
		Vector vt2 = dd2.queryStationFollow();
		
		
		DAODisplayDay dd3 = new DAODisplayDay();
		Vector vt3 = dd3.queryEnterCount();
		
		request.setAttribute("vt",vt);
		request.setAttribute("vt2",vt2);
		request.setAttribute("vt3",vt3);
		return this.getTargetPage("hebingDay");
	}
  
  public String tiXing(HttpServletRequest request,
			HttpServletResponse response) throws Exception {

		//HttpSession session = request.getSession(false);
		User user = (User)UserInfo.getInstance(request);
		String idstr = user.getId();
		DAODisplayDay dd = new DAODisplayDay();
		Vector vt = dd.queryTiXing(idstr);
	
		request.setAttribute("vt",vt);
		return this.getTargetPage("tiXing");
				
	}

  
  public String searchQian(HttpServletRequest request, HttpServletResponse response) throws Exception
  {
	 // System.out.println("fid----------------"+request.getParameter("fid"));
	HttpSession session = request.getSession(false);
	UserInfo userInfor = (UserInfo) session.getAttribute("UserInfo_Object");
	String chCommitCode = userInfor.getId();
	//String chCommitName = request.getParameter("chCommitName");// 带上自己的工号
	boolean isAdmin = false;
	EnAuditorRole[] cEnAuditorRole = (EnAuditorRole[]) DAOBase
			.findByCondition(new DbAccess(), EnAuditorRole.class.getName(),
					"chAuditorCode='" + chCommitCode + "'", "");
	for (int i = 0; i < cEnAuditorRole.length; i++) {
		if (cEnAuditorRole[i].getChRoleCode().equals("0000"))
			isAdmin = true;
	}
	String where = "chCommitCode ="+ chCommitCode;
	DbAccess db = new DbAccess();
	EnEnt_Plan_Following aEnEnt_Plan_Following[]=null;
	
	aEnEnt_Plan_Following = (EnEnt_Plan_Following [])(DAOBase.findByCondition(db, EnEnt_Plan_Following.class.getName(), where, "id desc"));
	for (int i = 0; i < aEnEnt_Plan_Following.length; i++) {

    	if (!aEnEnt_Plan_Following[i].getDtTrackingDate().equals("")) {
    		String year = aEnEnt_Plan_Following[i].getDtTrackingDate()
    				.substring(0, 4);
    		String month = aEnEnt_Plan_Following[i].getDtTrackingDate()
    				.substring(5, 7);
    		String day = aEnEnt_Plan_Following[i].getDtTrackingDate()
    				.substring(8, 10);
    		aEnEnt_Plan_Following[i].setDtTrackingDate(year + month + day);
    	}
    	if (!aEnEnt_Plan_Following[i].getDtPlanTrackingDate().equals("")) {
    		String year = aEnEnt_Plan_Following[i].getDtPlanTrackingDate()
    				.substring(0, 4);
    		String month = aEnEnt_Plan_Following[i].getDtPlanTrackingDate()
    				.substring(5, 7);
    		String day = aEnEnt_Plan_Following[i].getDtPlanTrackingDate()
    				.substring(8, 10);
    		aEnEnt_Plan_Following[i].setDtPlanTrackingDate(year + month + day);
    	}
    }
	if(aEnEnt_Plan_Following!=null) {
	    for(int i=0; i<aEnEnt_Plan_Following.length;i++) {
	    	aEnEnt_Plan_Following[i] = GDPE.follow.plan.ActionEnt_Plan_Following.viewInfo(aEnEnt_Plan_Following[i]);
	    }}
	request.setAttribute("aEnEnt_Plan_Following", aEnEnt_Plan_Following);
    return this.getTargetPage("searchQian");
  }
  
  
  public String search(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		levin.util.DbAccess db = new levin.util.DbAccess();

		String chStation = request.getParameter("chStation");

		String startTime = request.getParameter("startTime");
		String endTime = request.getParameter("endTime");		//
		String chFollowResult = request.getParameter("chFollowResult");
		//在省不补齐的情况下要求修改成模糊查询城市或者区域,

		HttpSession session = request.getSession(false);
		UserInfo userInfor = (UserInfo) session.getAttribute("UserInfo_Object");
		String chCommitCode = userInfor.getId();
		String chCommitName = request.getParameter("chCommitName");// 客户负责人
				
		
		String idstr = userInfor.getId();
		String flag = checkFlag(idstr);
		
		EnEnt_Plan_Following aEnEnt_Plan_Following[];
		EnEnt_Plan_Following searchContract = new EnEnt_Plan_Following();

		searchContract.setChCommitName(chCommitName);
		searchContract.setChStation(chStation);
		searchContract.setChFollowResult(chFollowResult);

		//System.out.println("---chStation-------"+chStation);
		//System.out.println("---1-------"+idstr);
		if (flag.equals("isAdmin")) {
			aEnEnt_Plan_Following = (EnEnt_Plan_Following[]) (GDPE.follow.plan.DAOCustomer
					.searcheEnContract(db,  searchContract,startTime,endTime));
		} else if (flag.equals("isStation")) {
			EnAuditor cEnAuditor = (EnAuditor) DAOBase.findByPK(new DbAccess(),
					EnAuditor.class.getName(), idstr);
			String chStationCode = cEnAuditor.getChDeptCode();
			
//			searchContract.setChStationCode(chStationCode);
//			searchContract.setChAreacode(chStationCode);
//			searchContract.setChCommitCode(idstr);
			
			aEnEnt_Plan_Following = (EnEnt_Plan_Following[]) (GDPE.follow.plan.DAOCustomer
					.searcheEnContract2(db, searchContract,startTime,endTime,chStationCode,idstr));
			//System.out.println("---2-------"+idstr);
		} else {
			searchContract.setChCommitCode(chCommitCode);// 如果不是系统管理员只能查自己的客户
			searchContract.setChCommitName(chCommitName);
			aEnEnt_Plan_Following = (EnEnt_Plan_Following[]) (GDPE.follow.plan.DAOCustomer
					.searcheEnContract(db,  searchContract,startTime,endTime));
		}
		
		for (int i = 0; i < aEnEnt_Plan_Following.length; i++) {

	    	if (!aEnEnt_Plan_Following[i].getDtTrackingDate().equals("")) {
	    		String year = aEnEnt_Plan_Following[i].getDtTrackingDate()
	    				.substring(0, 4);
	    		String month = aEnEnt_Plan_Following[i].getDtTrackingDate()
	    				.substring(5, 7);
	    		String day = aEnEnt_Plan_Following[i].getDtTrackingDate()
	    				.substring(8, 10);
	    		aEnEnt_Plan_Following[i].setDtTrackingDate(year + month + day);
	    	}
	    	if (!aEnEnt_Plan_Following[i].getDtPlanTrackingDate().equals("")) {
	    		String year = aEnEnt_Plan_Following[i].getDtPlanTrackingDate()
	    				.substring(0, 4);
	    		String month = aEnEnt_Plan_Following[i].getDtPlanTrackingDate()
	    				.substring(5, 7);
	    		String day = aEnEnt_Plan_Following[i].getDtPlanTrackingDate()
	    				.substring(8, 10);
	    		aEnEnt_Plan_Following[i].setDtPlanTrackingDate(year + month + day);
	    	}
	    }
		
		if(aEnEnt_Plan_Following!=null) {
		    for(int i=0; i<aEnEnt_Plan_Following.length;i++) {
		    	aEnEnt_Plan_Following[i] = GDPE.follow.plan.ActionEnt_Plan_Following.viewInfo(aEnEnt_Plan_Following[i]);
		    }}
		
		
		request.setAttribute("aEnEnt_Plan_Following",
				aEnEnt_Plan_Following);

		request.setAttribute("doType", "searchQian");
		//logger.info("查询时使用的帐号:"+chCommitCode);
		return this.getTargetPage("searchQian");

	}
  
}