mmsuserstatisticsclassreport.jsp

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

<%@ page contentType="text/html;charset=utf-8"%>
<%@page import="java.util.List"%>
<%@page import="com.my7g.zj.mobile.mms.bean.MmsSelectBean"%>
<%@page import="com.my7g.zj.mobile.mms.bean.MmsUserStatisticsBean"%>
<%@page import="com.my7g.zj.mobile.mms.bean.User"%>
<%@page import="com.my7g.zj.mobile.mms.sys.Constant"%>

<%@page import="com.my7g.zj.mobile.mms.sys.AppContext"%>
<%@page import="com.my7g.zj.mobile.mms.business.IMmsUserStatisticsService"%>
<%@ include file="../common/taglibs.jsp"%>

<%
	response.reset();
	response.setContentType("application/vnd.ms-excel");
	IMmsUserStatisticsService immsUserStatistics = (IMmsUserStatisticsService)AppContext
			.getBean("IMmsUserStatisticsService");
	String userGroup = User.getUserInfo().getUsergroup();
	String userID = User.getUserInfo().getUserid();
	//userGroup = "4";
	//userID = "17";
	
	String conditions = request.getParameter("selectClass");
	String endTime = request.getParameter("endTime");
	List<MmsUserStatisticsBean> mmsUserStatisticsBeanList_Class;// 栏目查询
	List<MmsSelectBean> mmsSelectBeanList_Class;// 栏目下拉框列表
	
	// 生成下拉框列表
	if(userGroup.equals(Constant.sUserType_CP))
		mmsSelectBeanList_Class = immsUserStatistics.getClassifyList(userID, 1);
	else
		mmsSelectBeanList_Class = immsUserStatistics.getClassifyList(userID, 2);
	
	// 生成判断语句
	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文件
	immsUserStatistics.createWorkbook(mmsUserStatisticsBeanList_Class,response.getOutputStream());
	
	// 输出　Excel文件
	out.clear();
	out = pageContext.pushBody();
%>