statqueryservice.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr;

import java.util.HashMap;
import java.util.Map;

import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;

import com.doone.data.DataTable;
import com.doone.fj1w.fjmgr.faq.ClientService;
import com.doone.fj1w.fjmgr.order.ConsomerDAO;
import com.doone.fj1w.fjmgr.order.FailureDAO;
import com.doone.fj1w.fjmgr.order.FamilyBrandDAO;
import com.doone.fj1w.fjmgr.order.ProdorderDAO;
import com.doone.uurm.WebAuth;

public class StatQueryService {
	public static String getCountByService(ServletRequest request,
			ServletResponse response, Map param) {
		WebAuth auth = WebAuth.getInstance((HttpServletRequest) request);
		String serviceName = (String) param.get("SERVERNAME");

		return getCountByService(serviceName, auth.getCityCode());
	}

	public static String getAllCount(ServletRequest request,
			ServletResponse response, Map param) {
		WebAuth auth = WebAuth.getInstance((HttpServletRequest) request);

		StringBuffer str = new StringBuffer();
		str.append(getCountByService(StatQueryService.QUERY_ACCEPTORDER, auth
				.getCityCode()));
		str.append(",").append(
				getCountByService(StatQueryService.QUERY_SERVICEORDER, auth
						.getCityCode()));
		str.append(",").append(
				getCountByService(StatQueryService.QUERY_FAULTORDER, auth
						.getCityCode()));
		str.append(",").append(
				getCountByService(StatQueryService.QUERY_FAQ, auth
						.getCityCode()));
		str.append(",").append(
				getCountByService(StatQueryService.QUERY_FAMILY, auth
						.getCityCode()));
		return str.toString();
	}

	private static String getCountByService(String serviceName, String cityCode) {
		HashMap _map = new HashMap();
		_map.put("CITY", cityCode);
		DataTable _dt = null;
		if (StatQueryService.QUERY_ACCEPTORDER.equalsIgnoreCase(serviceName)) {

			try {
				_dt = ProdorderDAO.getOrderMethod(_map, "1");
				if (_dt != null && _dt.getRows().getCount() > 0) {
					int count = _dt.getRow(0).getInt("count");
					return String.valueOf(count) + "个业务受理单";
				}
			} catch (Exception ex) {
			}
			return "0个业务受理单";

		} else if (StatQueryService.QUERY_SERVICEORDER
				.equalsIgnoreCase(serviceName)) {

			try {
				_dt = ConsomerDAO.getOrderMethod(_map, "1");
				if (_dt != null && _dt.getRows().getCount() > 0) {
					int count = _dt.getRow(0).getInt("count");
					return String.valueOf(count) + "个客户服务单";
				}
			} catch (Exception ex) {
			}
			return "0个客户服务单";

		} else if (StatQueryService.QUERY_FAULTORDER
				.equalsIgnoreCase(serviceName)) {

			try {
				_dt = FailureDAO.getOrderMethod(_map, "1");
				if (_dt != null && _dt.getRows().getCount() > 0) {
					int count = _dt.getRow(0).getInt("count");
					return String.valueOf(count) + "个故障申告单";
				}
			} catch (Exception ex) {
			}
			return "0个故障申告单";

		} else if (StatQueryService.QUERY_FAQ.equalsIgnoreCase(serviceName)) {
		
			try {
				_dt = ClientService.getFaqListByCond(_map, "1");

				int count = 0;
				if (_dt != null && _dt.getRows().getCount() == 1) {
					count = _dt.getRow(0).getInt(0);
				}
				return String.valueOf(count) + "个业务咨询单";
			} catch (Exception ex) {
			}
			return "0个业务咨询单";
		} else if (StatQueryService.QUERY_FAMILY.equalsIgnoreCase(serviceName)) {

			try {
				int count = 0;
				count =  FamilyBrandDAO.getFamilyBrandListCount(_map, "1");
				return String.valueOf(count) + "个品牌客户单";
			} catch (Exception ex) {
			}
			return "0个品牌客户单";
		} else {
			return null;
		}
	}

	public static final String QUERY_ACCEPTORDER = "ACCEPTORDER";

	public static final String QUERY_SERVICEORDER = "SERVICEORDER";

	public static final String QUERY_FAULTORDER = "FAULTORDER";

	public static final String QUERY_FAQ = "FAQORDER";
	
	public static final String QUERY_FAMILY = "FAMILYORDER";
	
}