mmsuserstatisticsareareport.jsp

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

<%@ page contentType="text/html;charset=utf-8"%>
<%@page import="java.util.List"%>
<%@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();
	//userGroup = "4";	
	
	// 生成判断语句
	String conditions = request.getParameter("selectArea");
	String endTime = request.getParameter("endTime");
	
	if(conditions == null || conditions.equals("all"))
		conditions = "  ";
	else
		conditions = " and city_id = "+conditions;
	
	System.out.println("userGroup = "+userGroup);
	
	List<MmsUserStatisticsBean> mmsUserStatisticsBeanList_Area;// 地市查询
	//List<MmsSelectBean> mmsSelectBeanList_Area;// 地市下拉框列表
	
	// 生成下拉框列表
	//mmsSelectBeanList_Area = immsUserStatistics.getAreaList();
	
	// 生成查询结果集
	if(userGroup.equals(Constant.sUserType_CP))
		mmsUserStatisticsBeanList_Area = immsUserStatistics.getUserStatisticsListFromHistory(conditions, endTime, 22);
	else
		mmsUserStatisticsBeanList_Area = immsUserStatistics.getUserStatisticsListFromHistory(conditions, endTime, 42);
//	if(userGroup.equals(Constant.sUserType_CP))
//		mmsUserStatisticsBeanList_Area = immsUserStatistics.getUserStatisticsList(conditions, endTime, 22);
//	else
//		mmsUserStatisticsBeanList_Area = immsUserStatistics.getUserStatisticsList(conditions, endTime, 42);
	
	// 生成　Excel文件
	immsUserStatistics.createWorkbook(mmsUserStatisticsBeanList_Area,response.getOutputStream());
	
	// 输出　Excel文件
	out.clear();
	out = pageContext.pushBody();
%>