mmsuserstatisticsclassaction.java

来自「移动彩信管理平台」· Java 代码 · 共 212 行

package com.my7g.zj.mobile.mms.web.action;

import java.util.List;
import java.util.Map;
// 拦截session
//import org.apache.struts2.interceptor.SessionAware;

import com.my7g.zj.mobile.mms.bean.MmsSelectBean;
import com.my7g.zj.mobile.mms.bean.MmsUserStatisticsBean;
import com.my7g.zj.mobile.mms.bean.User;
import com.my7g.zj.mobile.mms.business.IMmsUserStatisticsService;
import com.my7g.zj.mobile.mms.sys.Constant;
import com.opensymphony.xwork2.ActionSupport;

public class MmsUserStatisticsClassAction extends ActionSupport{

	//**************所有request、session等属性及方法********************

	/**
	 * 初次进入此页面调用此方法　只初始化下拉框
	 * */
	public void firstExecute()
	{
		String userGroup = User.getUserInfo().getUsergroup();
		String userID = User.getUserInfo().getUserid();
		//userGroup = "4";
		//userID = "17";
		// 生成下拉框列表
		if(userGroup.equals(Constant.sUserType_CP))
			mmsSelectBeanList_Class = immsUserStatistics.getClassifyList(userID, 1);
		else
			mmsSelectBeanList_Class = immsUserStatistics.getClassifyList(userID, 2);
	}
	/**
	 * 在此页面重复请求查询调用此方法
	 * */
	public void otherExecute()
	{
		String userGroup = User.getUserInfo().getUsergroup();
		String userID = User.getUserInfo().getUserid();
		//userGroup = "4";
		//userID = "17";
		
		// 生成下拉框列表
		if(userGroup.equals(Constant.sUserType_CP))
			mmsSelectBeanList_Class = immsUserStatistics.getClassifyList(userID, 1);
		else
			mmsSelectBeanList_Class = immsUserStatistics.getClassifyList(userID, 2);
		
		// 生成判断语句
		String conditions = selectClass;
		if(conditions == null || conditions.equals("all"))
		{
			if(userGroup.equals(Constant.sUserType_CP))
			{
				
				conditions = " and (individuality = '";
				for(int i=0;i<mmsSelectBeanList_Class.size();i++)
				{
					conditions = conditions + ((MmsSelectBean)mmsSelectBeanList_Class.get(i)).getCode();
					conditions = conditions + "' or individuality = '";
				}
				conditions = conditions.substring(0, conditions.lastIndexOf("or"));
				conditions = conditions + ")";
			}
			else
				conditions = "  ";
		}
		else
		{
			if(conditions != null)
				conditions = " and individuality = '"+conditions + "'";
			else
				System.out.println("业务用户数统计->按栏目查询->根据类型代码获得名称时错误！typeCode="+conditions);
		}
		
		// 生成查询结果集
		if(userGroup.equals(Constant.sUserType_CP))
			mmsUserStatisticsBeanList_Class = immsUserStatistics.getUserStatisticsListFromHistory(conditions, endTime, 12);
		else
			mmsUserStatisticsBeanList_Class = immsUserStatistics.getUserStatisticsListFromHistory(conditions, endTime, 32);
//		if(userGroup.equals(Constant.sUserType_CP))
//			mmsUserStatisticsBeanList_Class = immsUserStatistics.getUserStatisticsList(conditions, endTime, 12);
//		else
//			mmsUserStatisticsBeanList_Class = immsUserStatistics.getUserStatisticsList(conditions, endTime, 32);
	}
	/**
	 * 将查询获得的结果保存为Excel
	 * */
	public void createExcelExecute()
	{
		String userGroup = User.getUserInfo().getUsergroup();
		String userID = User.getUserInfo().getUserid();
		//userGroup = "4";
		//userID = "17";
		
		// 生成下拉框列表
		if(userGroup.equals(Constant.sUserType_CP))
			mmsSelectBeanList_Class = immsUserStatistics.getClassifyList(userID, 1);
		else
			mmsSelectBeanList_Class = immsUserStatistics.getClassifyList(userID, 2);
		
		// 生成判断语句
		String conditions = selectClass;
		if(conditions == null || conditions.equals("all"))
		{
			if(userGroup.equals(Constant.sUserType_CP))
			{
				
				conditions = " and (individuality = ";
				for(int i=0;i<mmsSelectBeanList_Class.size();i++)
				{
					conditions = conditions + ((MmsSelectBean)mmsSelectBeanList_Class.get(i)).getCode();
					conditions = conditions + " or individuality = ";
				}
				conditions = conditions.substring(0, conditions.lastIndexOf("or"));
				conditions = conditions + ")";
			}
					
			else
				conditions = "  ";
		}
		else
		{
			if(conditions != null)
				conditions = " and individuality = "+conditions;
			else
				System.out.println("业务用户数统计->按栏目查询->根据类型代码获得名称时错误！typeCode="+conditions);
		}
		
		// 生成查询结果集
		if(userGroup.equals(Constant.sUserType_CP))
			mmsUserStatisticsBeanList_Class = immsUserStatistics.getUserStatisticsListFromHistory(conditions, endTime, 12);
		else
			mmsUserStatisticsBeanList_Class = immsUserStatistics.getUserStatisticsListFromHistory(conditions, endTime, 32);
//		if(userGroup.equals(Constant.sUserType_CP))
//			mmsUserStatisticsBeanList_Class = immsUserStatistics.getUserStatisticsList(conditions, endTime, 12);
//		else
//			mmsUserStatisticsBeanList_Class = immsUserStatistics.getUserStatisticsList(conditions, endTime, 32);
		// 生成　Excel文件
		// ...
	}
	
	//***************execute()方法************************************
	@Override
	public String execute() throws Exception {
		if(argument == null)
			argument = "first";	
		
		if(argument.equals("other"))
			otherExecute();
		else if(argument.equals("ourput"))
			createExcelExecute();
		else
			firstExecute();
		
		return SUCCESS;
	}

	//*****************业务属性及方法**************************************
	IMmsUserStatisticsService immsUserStatistics;
	List<MmsUserStatisticsBean> mmsUserStatisticsBeanList_Class;// 地市查询
	List<MmsSelectBean> mmsSelectBeanList_Class;// 地市下拉框列表

	
	public IMmsUserStatisticsService getImmsUserStatistics() {
		return immsUserStatistics;
	}
	public void setImmsUserStatistics(IMmsUserStatisticsService immsUserStatistics) {
		this.immsUserStatistics = immsUserStatistics;
	}
	
	public List<MmsUserStatisticsBean> getMmsUserStatisticsBeanList_Class() {
		return mmsUserStatisticsBeanList_Class;
	}
	public void setMmsUserStatisticsBeanList_Class(
			List<MmsUserStatisticsBean> mmsUserStatisticsBeanList_Class) {
		this.mmsUserStatisticsBeanList_Class = mmsUserStatisticsBeanList_Class;
	}
	
	public List<MmsSelectBean> getMmsSelectBeanList_Class() {
		return mmsSelectBeanList_Class;
	}
	public void setMmsSelectBeanList_Class(List<MmsSelectBean> mmsSelectBeanList_Class) {
		this.mmsSelectBeanList_Class = mmsSelectBeanList_Class;
	}

	//******************页面数据属性及方法****************************************
	String selectClass;
	String argument;
	String endTime;

	public String getSelectClass() {
		return selectClass;
	}
	public void setSelectClass(String selectClass) {
		this.selectClass = selectClass;
	}
	
	public String getArgument() {
		return argument;
	}
	public void setArgument(String argument) {
		this.argument = argument;
	}
	public String getEndTime() {
		return endTime;
	}
	public void setEndTime(String endTime) {
		this.endTime = endTime;
	}	
}