dianwangAdm/src/main/java/com/minpay/common/service/impl/ReportServiceImpl.java

package com.minpay.common.service.impl;


import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.commons.fileupload.FileItem;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

import com.minpay.common.constant.Constant;
import com.minpay.common.service.IReportService;
import com.minpay.common.util.CommonUtil;
import com.minpay.common.util.DateUtil;
import com.minpay.common.util.FilesUtil;
import com.minpay.db.table.mapper.DwDdyFxbDetailMapper;
import com.minpay.db.table.mapper.DwDdyFxbMapper;
import com.minpay.db.table.mapper.DwFileDetail00Mapper;
import com.minpay.db.table.mapper.DwFileDetail01Mapper;
import com.minpay.db.table.mapper.DwFileDetail03Mapper;
import com.minpay.db.table.mapper.DwFileDetail04Mapper;
import com.minpay.db.table.mapper.DwFileDetail07Mapper;
import com.minpay.db.table.mapper.DwReportDataMapper;
import com.minpay.db.table.mapper.DwReportInfMapper;
import com.minpay.db.table.mapper.PubAppparMapper;
import com.minpay.db.table.model.DwDdyFxb;
import com.minpay.db.table.model.DwDdyFxbDetail;
import com.minpay.db.table.model.DwDdyFxbDetailExample;
import com.minpay.db.table.model.DwDdyFxbExample;
import com.minpay.db.table.model.DwFileDetail00;
import com.minpay.db.table.model.DwFileDetail00Example;
import com.minpay.db.table.model.DwFileDetail01;
import com.minpay.db.table.model.DwFileDetail01Example;
import com.minpay.db.table.model.DwFileDetail03;
import com.minpay.db.table.model.DwFileDetail03Example;
import com.minpay.db.table.model.DwFileDetail04;
import com.minpay.db.table.model.DwFileDetail04Example;
import com.minpay.db.table.model.DwFileDetail07;
import com.minpay.db.table.model.DwFileDetail07Example;
import com.minpay.db.table.model.DwReportData;
import com.minpay.db.table.model.DwReportInf;
import com.minpay.db.table.model.PubApppar;
import com.minpay.db.table.model.PubAppparExample;
import com.minpay.db.table.own.mapper.ReportServiceMapper;
import com.startup.minpay.frame.business.MINHttpServletRequestContext;
import com.startup.minpay.frame.exception.MINBusinessException;
import com.startup.minpay.frame.jdbc.MINRowBounds;
import com.startup.minpay.frame.service.base.IMINDataBaseService;
import com.startup.minpay.frame.service.base.Service;
import com.startup.minpay.frame.target.MINComponent;

import net.sf.json.JSONArray;


@MINComponent
public class ReportServiceImpl implements IReportService {
	static Map<String, String> totalMap = new HashMap<String, String>();
	
	//各区客户数
	static Map<String, String> customerMap = new HashMap<String, String>();
	// 各区域管辖台区数
	static Map<String, String> guanxiaTaiqu = new HashMap<String, String>();
	// 台区停电停电时长
	static List<Map<String, String>> fenduanList = new ArrayList<Map<String, String>>();
	static {
		totalMap.put("xintai", "8382");
		totalMap.put("daiyue", "4188");
		totalMap.put("ningyang", "6292");
		totalMap.put("taishan", "3784");
		totalMap.put("dongping", "6212");
		totalMap.put("feicheng", "6547");
		totalMap.put("taishanjingqu", "1474");
		totalMap.put("gaoxin", "1945");
		totalMap.put("heji", "38824");
		
		//客户数
		customerMap.put("xintai", "593100");
		customerMap.put("daiyue", "323455");
		customerMap.put("ningyang", "301682");
		customerMap.put("taishan", "376298");
		customerMap.put("dongping", "298683");
		customerMap.put("feicheng", "375994");
		customerMap.put("jingqu", "120623");
		customerMap.put("gaoxin", "162627");
		customerMap.put("heji", "2552462");
		
		// 管辖台区数
		guanxiaTaiqu.put("gaoxin", "2308");
		guanxiaTaiqu.put("daiyue", "3043");
		guanxiaTaiqu.put("xintai", "4286");
		guanxiaTaiqu.put("dongping", "4000");
		guanxiaTaiqu.put("ningyang", "3913");
		guanxiaTaiqu.put("feicheng", "1000");
		guanxiaTaiqu.put("jingqu", "2000");
		guanxiaTaiqu.put("taishan", "1950");
		guanxiaTaiqu.put("heji", "22500");
		
		// 0-1小时
		Map<String, String> map0To60 = new HashMap<String, String>();
		map0To60.put("start", "0");
		map0To60.put("end", "60");
		map0To60.put("desc", "0-1小时");
		fenduanList.add(map0To60);
		// 1-6小时
		Map<String, String> map60To360 = new HashMap<String, String>();
		map60To360.put("start", "60");
		map60To360.put("end", "360");
		map60To360.put("desc", "1-6小时");
		fenduanList.add(map60To360);
		// 6-12小时
		Map<String, String> map360To720 = new HashMap<String, String>();
		map360To720.put("start", "360");
		map360To720.put("end", "720");
		map360To720.put("desc", "6-12小时");
		fenduanList.add(map360To720);
		// 12-24小时
		Map<String, String> map720To1440 = new HashMap<String, String>();
		map720To1440.put("start", "720");
		map720To1440.put("end", "1440");
		map720To1440.put("desc", "12-24小时");
		fenduanList.add(map720To1440);
		// 24小时以上
		Map<String, String> mapGT1440 = new HashMap<String, String>();
		mapGT1440.put("start", "1440");
		mapGT1440.put("desc", "24小时以上");
		fenduanList.add(mapGT1440);
	}

	
	@Override
	public Map<String, Object> reportNeedDetail(Map<String, Object> param)
			throws MINBusinessException, ParseException, NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException, InvalidFormatException, IOException {
		String range = (String)param.get("range");
		String timeRange = (String)param.get("timeRange");
		String reportTypeId = (String)param.get("reportTypeId");
		String firstFileId = (String)param.get("firstFileId");
		String secondFileId = (String)param.get("secondFileId");
		String FADateRange = (String)param.get("FADateRange");
		String yearChoose = (String)param.get("yearChoose");
		String DdyDateRange = (String)param.get("DdyDateRange");
		String ddyFxbId = (String)param.get("ddyFxbId");
		MINHttpServletRequestContext request = (MINHttpServletRequestContext)param.get("request");
		
		Map<String, Object> resMap = new HashMap<String, Object>();
    	// 台区停电日报
    	if (Constant.REPORT_TYPE_00.equals(reportTypeId)) {
    		String monthNum = (String)param.get("monthNum");
    		String countNum = (String)param.get("countNum");
    		
    		return reportTypeTQTDRB(range, timeRange, monthNum, countNum);
    	// 台区停电周报
    	} else if (Constant.REPORT_TYPE_01.equals(reportTypeId)) {
    		return reportTypeTQTDZB(range, timeRange);
    	// 台区停电月报
    	} else if (Constant.REPORT_TYPE_02.equals(reportTypeId)) {
    		return reportTypeTQTDYB(range, timeRange);
    	// 终端投托运报表
    	} else if (Constant.REPORT_TYPE_03.equals(reportTypeId)) {
    		List<List<String>> resList = reportTypeZDDTYBB(firstFileId, secondFileId);
    		resMap.put("resList", resList);
    	// FA动作正确率
    	} else if (Constant.REPORT_TYPE_04.equals(reportTypeId)) {
    		List<List<String>> resList = reportTypeFADZBB(FADateRange, yearChoose);
    		resMap.put("resList", resList);
    	// 低电压分析表
    	} else if (Constant.REPORT_TYPE_05.equals(reportTypeId)){
    		return reportTypeDDYZLFXB(range, reportTypeId, 1, 100);
    	// 低电压日报	
    	} else if (Constant.REPORT_TYPE_06.equals(reportTypeId)){
    		List<List<String>> resList = reportTypeDDYRB(DdyDateRange,yearChoose,range, reportTypeId);
    		resMap.put("resList", resList);
    	// 过电压分析表
    	} else if (Constant.REPORT_TYPE_07.equals(reportTypeId)){
    		List<List<String>> resList = reportTypeGDYZLFXB(range, reportTypeId);
    		resMap.put("resList", resList);
    	// 95598工单月报
    	} else if (Constant.REPORT_TYPE_08.equals(reportTypeId)){
    		return reportType95598YB(range);
    	// 低电压未治理完成
    	} else if (Constant.REPORT_TYPE_09.equals(reportTypeId)) {
    		List<List<String>> resList = reportTypeDDYWZL(ddyFxbId);
    		resMap.put("resList", resList);
    	// 低电压昨日新增
    	} else if (Constant.REPORT_TYPE_10.equals(reportTypeId)) {
    		List<List<String>> resList = reportTypeDDYZRXZ(ddyFxbId);
    		resMap.put("resList", resList);
    	// 低电压周报
		} else if (Constant.REPORT_TYPE_11.equals(reportTypeId)) {
			return reportTypeDDYZB(ddyFxbId, range);
		// 低电压超30天
		} else if (Constant.REPORT_TYPE_12.equals(reportTypeId)) {
			List<List<String>> resList = reportTypeDDY30T(ddyFxbId);
			resMap.put("resList", resList);
		// 低电压月报
		} else if (Constant.REPORT_TYPE_13.equals(reportTypeId)) {
			return reportTypeDDYYB(ddyFxbId);
		// 计停非计停周报
		} else if (Constant.REPORT_TYPE_14.equals(reportTypeId)) {
			return reportTypeJTFJTRB(range,timeRange);
		// 终端投退运报表II
		} else if (Constant.REPORT_TYPE_15.equals(reportTypeId)) {
			List<List<String>> resList = reportTypeZDDTYBBII(firstFileId, request);
    		resMap.put("resList", resList);
		}
		return resMap;
	}


	/**
	 * 台区停电日报
	 * @param range			日期范围
	 * @param timeRange		时间段范围
	 * @param monthNum		几个月内停电
	 * @param countNum		停电次数
	 * @return
	 * @throws MINBusinessException
	 * @throws ParseException 
	 */
	public Map<String, Object> reportTypeTQTDRB(String range, String timeRange, String monthNum, String countNum) throws MINBusinessException, ParseException {
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		Map<String, Object> resMap = new HashMap<String, Object>();
		List<List<String>> resList = new ArrayList<List<String>>();
		resMap.put("excelList", resList);
		
		Map<String, Object> param = new HashMap<String, Object>();
		String beginTime = null;
		String endTime = null;
		range = range.replaceAll(" ", "");
		String[] rangeArray = range.split("-");
		timeRange = timeRange.replaceAll(" ", "");
		if (CommonUtil.isEmpty(timeRange)) {
			beginTime = rangeArray[0] + "000000";
			endTime = rangeArray[1] + "235959";
		} else {
			String[] timeRangeArray = timeRange.split("-");
			beginTime = rangeArray[0] + timeRangeArray[0];
			endTime = rangeArray[1] + timeRangeArray[1];
		}
		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		List<Map<String, String>> fileList00 = db.getMybatisMapper(ReportServiceMapper.class).selectReportType00(param);
		
		Map<String, String> countMap = new HashMap<String, String>();
		countMap.put("xintai", "0");
		countMap.put("daiyue", "0");
		countMap.put("ningyang", "0");
		countMap.put("taishan", "0");
		countMap.put("dongping", "0");
		countMap.put("feicheng", "0");
		countMap.put("taishanjingqu", "0");
		countMap.put("gaoxin", "0");
		countMap.put("heji", "0");
		
		
		Map<String, String> shihuMap = new HashMap<String, String>();
		shihuMap.put("xintai", "0");
		shihuMap.put("daiyue", "0");
		shihuMap.put("ningyang", "0");
		shihuMap.put("taishan", "0");
		shihuMap.put("dongping", "0");
		shihuMap.put("feicheng", "0");
		shihuMap.put("taishanjingqu", "0");
		shihuMap.put("gaoxin", "0");
		shihuMap.put("heji", "0");
		
		for (Map<String, String> map : fileList00) {
			String minute = map.get("time");
			if ("新泰".equals(map.get("area"))) {
				countMap.put("xintai",CommonUtil.add(countMap.get("xintai"), "1"));
				shihuMap.put("xintai",CommonUtil.add(shihuMap.get("xintai"), minute));
			} else if ("岱岳".equals(map.get("area"))) {
				countMap.put("daiyue",CommonUtil.add(countMap.get("daiyue"), "1"));
				shihuMap.put("daiyue",CommonUtil.add(shihuMap.get("daiyue"), minute));
			} else if ("宁阳".equals(map.get("area"))) {
				countMap.put("ningyang",CommonUtil.add(countMap.get("ningyang"), "1"));
				shihuMap.put("ningyang",CommonUtil.add(shihuMap.get("ningyang"), minute));
			} else if ("泰山".equals(map.get("area"))) {
				countMap.put("taishan",CommonUtil.add(countMap.get("taishan"), "1"));
				shihuMap.put("taishan",CommonUtil.add(shihuMap.get("taishan"), minute));
			} else if ("东平".equals(map.get("area"))) {
				countMap.put("dongping",CommonUtil.add(countMap.get("dongping"), "1"));
				shihuMap.put("dongping",CommonUtil.add(shihuMap.get("dongping"), minute));
			} else if ("肥城".equals(map.get("area"))) {
				countMap.put("feicheng",CommonUtil.add(countMap.get("feicheng"), "1"));
				shihuMap.put("feicheng",CommonUtil.add(shihuMap.get("feicheng"), minute));
			} else if ("泰山景区".equals(map.get("area"))) {
				countMap.put("taishanjingqu",CommonUtil.add(countMap.get("taishanjingqu"), "1"));
				shihuMap.put("taishanjingqu",CommonUtil.add(shihuMap.get("taishanjingqu"), minute));
			} else if ("高新".equals(map.get("area"))) {
				countMap.put("gaoxin",CommonUtil.add(countMap.get("gaoxin"), "1"));
				shihuMap.put("gaoxin",CommonUtil.add(shihuMap.get("gaoxin"), minute));
			} else {
				break;
			}
			countMap.put("heji",CommonUtil.add(countMap.get("heji"), "1"));
			shihuMap.put("heji",CommonUtil.add(shihuMap.get("heji"), minute));
		}
		
		List<String> childList0 = new ArrayList<String>();
		childList0.add("分类\\单位");
		childList0.add("新泰");
		childList0.add("岱岳");
		childList0.add("宁阳");
		childList0.add("泰山");
		childList0.add("东平");
		childList0.add("肥城");
		childList0.add("泰山景区");
		childList0.add("高新");
		childList0.add("合计");
		resList.add(childList0);
		
		List<String> childList1 = new ArrayList<String>();
		childList1.add("管辖台区数量");
		childList1.add(totalMap.get("xintai"));
		childList1.add(totalMap.get("daiyue"));
		childList1.add(totalMap.get("ningyang"));
		childList1.add(totalMap.get("taishan"));
		childList1.add(totalMap.get("dongping"));
		childList1.add(totalMap.get("feicheng"));
		childList1.add(totalMap.get("taishanjingqu"));
		childList1.add(totalMap.get("gaoxin"));
		childList1.add(totalMap.get("heji"));
		resList.add(childList1);
		
		List<String> childList2 = new ArrayList<String>();
		childList2.add("台区停电次数");
		childList2.add(countMap.get("xintai"));
		childList2.add(countMap.get("daiyue"));
		childList2.add(countMap.get("ningyang"));
		childList2.add(countMap.get("taishan"));
		childList2.add(countMap.get("dongping"));
		childList2.add(countMap.get("feicheng"));
		childList2.add(countMap.get("taishanjingqu"));
		childList2.add(countMap.get("gaoxin"));
		childList2.add(countMap.get("heji"));
		resList.add(childList2);
		
		List<String> childList9 = new ArrayList<String>();
		childList9.add("台区停电时户数");
		childList9.add(CommonUtil.divide(shihuMap.get("xintai"), "60", 2));
		childList9.add(CommonUtil.divide(shihuMap.get("daiyue"), "60", 2));
		childList9.add(CommonUtil.divide(shihuMap.get("ningyang"), "60", 2));
		childList9.add(CommonUtil.divide(shihuMap.get("taishan"), "60", 2));
		childList9.add(CommonUtil.divide(shihuMap.get("dongping"), "60", 2));
		childList9.add(CommonUtil.divide(shihuMap.get("feicheng"), "60", 2));
		childList9.add(CommonUtil.divide(shihuMap.get("taishanjingqu"), "60", 2));
		childList9.add(CommonUtil.divide(shihuMap.get("gaoxin"), "60", 2));
		childList9.add(CommonUtil.divide(shihuMap.get("heji"), "60", 2));
		resList.add(childList9);
		
		List<String> childList3 = new ArrayList<String>();
		childList3.add("台区停运率");
		childList3.add(CommonUtil.multiply(CommonUtil.divide(countMap.get("xintai"), totalMap.get("xintai"), 4), "100", 2) + "%");
		childList3.add(CommonUtil.multiply(CommonUtil.divide(countMap.get("daiyue"), totalMap.get("daiyue"), 4), "100", 2) + "%");
		childList3.add(CommonUtil.multiply(CommonUtil.divide(countMap.get("ningyang"), totalMap.get("ningyang"), 4), "100", 2) + "%");
		childList3.add(CommonUtil.multiply(CommonUtil.divide(countMap.get("taishan"), totalMap.get("taishan"), 4), "100", 2) + "%");
		childList3.add(CommonUtil.multiply(CommonUtil.divide(countMap.get("dongping"), totalMap.get("dongping"), 4), "100", 2) + "%");
		childList3.add(CommonUtil.multiply(CommonUtil.divide(countMap.get("feicheng"), totalMap.get("feicheng"), 4), "100", 2) + "%");
		childList3.add(CommonUtil.multiply(CommonUtil.divide(countMap.get("taishanjingqu"), totalMap.get("taishanjingqu"), 4), "100", 2) + "%");
		childList3.add(CommonUtil.multiply(CommonUtil.divide(countMap.get("gaoxin"), totalMap.get("gaoxin"), 4), "100", 2) + "%");
		childList3.add(CommonUtil.multiply(CommonUtil.divide(countMap.get("heji"), totalMap.get("heji"), 4), "100", 2) + "%");
		resList.add(childList3);
		
		// 台区停电个数统计
		Map<String, String> tqtdGsMap = new HashMap<String, String>();
		tqtdGsMap.put("xintai", "0");
		tqtdGsMap.put("daiyue", "0");
		tqtdGsMap.put("ningyang", "0");
		tqtdGsMap.put("taishan", "0");
		tqtdGsMap.put("dongping", "0");
		tqtdGsMap.put("feicheng", "0");
		tqtdGsMap.put("taishanjingqu", "0");
		tqtdGsMap.put("gaoxin", "0");
		tqtdGsMap.put("heji", "0");
		
		List<Map<String, String>> tqtdGsList = db.getMybatisMapper(ReportServiceMapper.class).selectReportType00TqtdGS(param);
		for (Map<String, String> map : tqtdGsList) {
			if ("新泰".equals(map.get("area"))) {
				tqtdGsMap.put("xintai", map.get("num"));
			} else if ("岱岳".equals(map.get("area"))) {
				tqtdGsMap.put("daiyue", map.get("num"));
			} else if ("宁阳".equals(map.get("area"))) {
				tqtdGsMap.put("ningyang", map.get("num"));
			} else if ("泰山".equals(map.get("area"))) {
				tqtdGsMap.put("taishan", map.get("num"));
			} else if ("东平".equals(map.get("area"))) {
				tqtdGsMap.put("dongping", map.get("num"));
			} else if ("肥城".equals(map.get("area"))) {
				tqtdGsMap.put("feicheng", map.get("num"));
			} else if ("泰山景区".equals(map.get("area"))) {
				tqtdGsMap.put("taishanjingqu", map.get("num"));
			} else if ("高新".equals(map.get("area"))) {
				tqtdGsMap.put("gaoxin", map.get("num"));
			}
			tqtdGsMap.put("heji",CommonUtil.add(tqtdGsMap.get("heji"), map.get("num")));
		}
		List<String> childList4 = new ArrayList<String>();
		childList4.add("台区停电个数");
		childList4.add(tqtdGsMap.get("xintai"));
		childList4.add(tqtdGsMap.get("daiyue"));
		childList4.add(tqtdGsMap.get("ningyang"));
		childList4.add(tqtdGsMap.get("taishan"));
		childList4.add(tqtdGsMap.get("dongping"));
		childList4.add(tqtdGsMap.get("feicheng"));
		childList4.add(tqtdGsMap.get("taishanjingqu"));
		childList4.add(tqtdGsMap.get("gaoxin"));
		childList4.add(tqtdGsMap.get("heji"));
		resList.add(childList4);
		
		// monthNum个月内停电 countNum次以上的台区
		String beginDay = DateUtil.dateAddMonth(rangeArray[1], Integer.parseInt("-" + monthNum));
		param.put("beginDay", beginDay);
		param.put("endDay", rangeArray[1]);
		param.put("countNum", countNum);
		List<Map<String, String>> mountCountList = db.getMybatisMapper(ReportServiceMapper.class).selectMountCount00(param);
		Map<String, Integer> taiQuMap = new HashMap<String, Integer>();
		taiQuMap.put("xintai", 0);
		taiQuMap.put("daiyue", 0);
		taiQuMap.put("ningyang", 0);
		taiQuMap.put("taishan", 0);
		taiQuMap.put("dongping", 0);
		taiQuMap.put("feicheng", 0);
		taiQuMap.put("taishanjingqu", 0);
		taiQuMap.put("gaoxin", 0);
		taiQuMap.put("heji", 0);
		for (Map<String, String> map : mountCountList) {
			if ("新泰".equals(map.get("area"))) {
				taiQuMap.put("xintai",taiQuMap.get("xintai") + 1);
			} else if ("岱岳".equals(map.get("area"))) {
				taiQuMap.put("daiyue",taiQuMap.get("daiyue") + 1);
			} else if ("宁阳".equals(map.get("area"))) {
				taiQuMap.put("ningyang",taiQuMap.get("ningyang") + 1);
			} else if ("泰山".equals(map.get("area"))) {
				taiQuMap.put("taishan",taiQuMap.get("taishan") + 1);
			} else if ("东平".equals(map.get("area"))) {
				taiQuMap.put("dongping",taiQuMap.get("dongping") + 1);
			} else if ("肥城".equals(map.get("area"))) {
				taiQuMap.put("feicheng",taiQuMap.get("feicheng") + 1);
			} else if ("泰山景区".equals(map.get("area"))) {
				taiQuMap.put("taishanjingqu",taiQuMap.get("taishanjingqu") + 1);
			} else if ("高新".equals(map.get("area"))) {
				taiQuMap.put("gaoxin",taiQuMap.get("gaoxin") + 1);
			}
			taiQuMap.put("heji",taiQuMap.get("heji") + 1);
		}
		List<String> childList6 = new ArrayList<String>();
		childList6.add(monthNum+"个月停电" + countNum + "次及以上台区");
		childList6.add(taiQuMap.get("xintai").toString());
		childList6.add(taiQuMap.get("daiyue").toString());
		childList6.add(taiQuMap.get("ningyang").toString());
		childList6.add(taiQuMap.get("taishan").toString());
		childList6.add(taiQuMap.get("dongping").toString());
		childList6.add(taiQuMap.get("feicheng").toString());
		childList6.add(taiQuMap.get("taishanjingqu").toString());
		childList6.add(taiQuMap.get("gaoxin").toString());
		childList6.add(taiQuMap.get("heji").toString());
		resList.add(childList6);
		
		// 查询昨日停电的数据
		param.put("yesterday", DateUtil.dateAddDay(rangeArray[1], -1));
		List<Map<String, String>> yesterdayList = db.getMybatisMapper(ReportServiceMapper.class).queryYesterdayDetail(param);
		
		param.put("yesterdayDetail", yesterdayList);
		List<Map<String, String>> yesterdayAndTDData = null;
		if (yesterdayList.size() != 0) {
			yesterdayAndTDData = db.getMybatisMapper(ReportServiceMapper.class).selectMountCount00(param);
		} else {
			yesterdayAndTDData = new ArrayList<Map<String, String>>();
		}
				
		Map<String, Integer> yesterdayTaiQuMap = new HashMap<String, Integer>();
		yesterdayTaiQuMap.put("xintai", 0);
		yesterdayTaiQuMap.put("daiyue", 0);
		yesterdayTaiQuMap.put("ningyang", 0);
		yesterdayTaiQuMap.put("taishan", 0);
		yesterdayTaiQuMap.put("dongping", 0);
		yesterdayTaiQuMap.put("feicheng", 0);
		yesterdayTaiQuMap.put("taishanjingqu", 0);
		yesterdayTaiQuMap.put("gaoxin", 0);
		yesterdayTaiQuMap.put("heji", 0);
		for (Map<String, String> map : yesterdayAndTDData) {
			if ("新泰".equals(map.get("area"))) {
				yesterdayTaiQuMap.put("xintai",yesterdayTaiQuMap.get("xintai") + 1);
			} else if ("岱岳".equals(map.get("area"))) {
				yesterdayTaiQuMap.put("daiyue",yesterdayTaiQuMap.get("daiyue") + 1);
			} else if ("宁阳".equals(map.get("area"))) {
				yesterdayTaiQuMap.put("ningyang",yesterdayTaiQuMap.get("ningyang") + 1);
			} else if ("泰山".equals(map.get("area"))) {
				yesterdayTaiQuMap.put("taishan",yesterdayTaiQuMap.get("taishan") + 1);
			} else if ("东平".equals(map.get("area"))) {
				yesterdayTaiQuMap.put("dongping",yesterdayTaiQuMap.get("dongping") + 1);
			} else if ("肥城".equals(map.get("area"))) {
				yesterdayTaiQuMap.put("feicheng",yesterdayTaiQuMap.get("feicheng") + 1);
			} else if ("泰山景区".equals(map.get("area"))) {
				yesterdayTaiQuMap.put("taishanjingqu",yesterdayTaiQuMap.get("taishanjingqu") + 1);
			} else if ("高新".equals(map.get("area"))) {
				yesterdayTaiQuMap.put("gaoxin",yesterdayTaiQuMap.get("gaoxin") + 1);
			}
			yesterdayTaiQuMap.put("heji",yesterdayTaiQuMap.get("heji") + 1);
		}
		List<String> childList7 = new ArrayList<String>();
		childList7.add(monthNum+"个月停电" + countNum + "次及以上台区且昨日停电");
		childList7.add(yesterdayTaiQuMap.get("xintai").toString());
		childList7.add(yesterdayTaiQuMap.get("daiyue").toString());
		childList7.add(yesterdayTaiQuMap.get("ningyang").toString());
		childList7.add(yesterdayTaiQuMap.get("taishan").toString());
		childList7.add(yesterdayTaiQuMap.get("dongping").toString());
		childList7.add(yesterdayTaiQuMap.get("feicheng").toString());
		childList7.add(yesterdayTaiQuMap.get("taishanjingqu").toString());
		childList7.add(yesterdayTaiQuMap.get("gaoxin").toString());
		childList7.add(yesterdayTaiQuMap.get("heji").toString());
		resList.add(childList7);
		
		// 2个月停电1次及以上台区且昨日停电的台区数据
		beginDay = DateUtil.dateAddMonth(rangeArray[1], -2);
		param.put("beginDay", beginDay);
		param.put("countNum", 1);
		List<Map<String, String>> yiciData = db.getMybatisMapper(ReportServiceMapper.class).selectMountCount00(param);
		
		Map<String, Integer> yiciMap = new HashMap<String, Integer>();
		yiciMap.put("xintai", 0);
		yiciMap.put("daiyue", 0);
		yiciMap.put("ningyang", 0);
		yiciMap.put("taishan", 0);
		yiciMap.put("dongping", 0);
		yiciMap.put("feicheng", 0);
		yiciMap.put("taishanjingqu", 0);
		yiciMap.put("gaoxin", 0);
		yiciMap.put("heji", 0);
		for (Map<String, String> map : yiciData) {
			if ("新泰".equals(map.get("area"))) {
				yiciMap.put("xintai",yiciMap.get("xintai") + 1);
			} else if ("岱岳".equals(map.get("area"))) {
				yiciMap.put("daiyue",yiciMap.get("daiyue") + 1);
			} else if ("宁阳".equals(map.get("area"))) {
				yiciMap.put("ningyang",yiciMap.get("ningyang") + 1);
			} else if ("泰山".equals(map.get("area"))) {
				yiciMap.put("taishan",yiciMap.get("taishan") + 1);
			} else if ("东平".equals(map.get("area"))) {
				yiciMap.put("dongping",yiciMap.get("dongping") + 1);
			} else if ("肥城".equals(map.get("area"))) {
				yiciMap.put("feicheng",yiciMap.get("feicheng") + 1);
			} else if ("泰山景区".equals(map.get("area"))) {
				yiciMap.put("taishanjingqu",yiciMap.get("taishanjingqu") + 1);
			} else if ("高新".equals(map.get("area"))) {
				yiciMap.put("gaoxin",yiciMap.get("gaoxin") + 1);
			}
			yiciMap.put("heji",yiciMap.get("heji") + 1);
		}
		List<String> childList8 = new ArrayList<String>();
		childList8.add("2个月停电1次及以上台区且昨日停电");
		childList8.add(yiciMap.get("xintai").toString());
		childList8.add(yiciMap.get("daiyue").toString());
		childList8.add(yiciMap.get("ningyang").toString());
		childList8.add(yiciMap.get("taishan").toString());
		childList8.add(yiciMap.get("dongping").toString());
		childList8.add(yiciMap.get("feicheng").toString());
		childList8.add(yiciMap.get("taishanjingqu").toString());
		childList8.add(yiciMap.get("gaoxin").toString());
		childList8.add(yiciMap.get("heji").toString());
		resList.add(childList8);
		
		String tingdianNum = countMap.get("heji");
		String tingdianNumDesc = "";
		for (Map.Entry<String, String> entry : countMap.entrySet()) {
			String mapKey = entry.getKey();
		    String mapValue = entry.getValue();
		    // 新泰
		    if ("xintai".equals(mapKey)) {
		    	tingdianNumDesc += "新泰" + mapValue + "个，";
		    } else if ("daiyue".equals(mapKey)) {
		    	tingdianNumDesc += "岱岳" + mapValue + "个，";
		    } else if ("ningyang".equals(mapKey)) {
		    	tingdianNumDesc += "宁阳" + mapValue + "个，";
		    } else if ("taishan".equals(mapKey)) {
		    	tingdianNumDesc += "泰山" + mapValue + "个，";
		    } else if ("dongping".equals(mapKey)) {
		    	tingdianNumDesc += "东平" + mapValue + "个，";
		    } else if ("feicheng".equals(mapKey)) {
		    	tingdianNumDesc += "肥城" + mapValue + "个，";
		    } else if ("taishanjingqu".equals(mapKey)) {
		    	tingdianNumDesc += "泰山景区" + mapValue + "个，";
		    } else if ("gaoxin".equals(mapKey)) {
		    	tingdianNumDesc += "高新" + mapValue + "个，";
		    }
		}
		
		String sanciyishangNum = String.valueOf(taiQuMap.get("heji"));
		String sanciyishangNumDesc = "";
		for (Map.Entry<String, Integer> entry : taiQuMap.entrySet()) {
			String mapKey = entry.getKey();
		    Integer mapValue = entry.getValue();
		    // 新泰
		    if ("xintai".equals(mapKey)) {
		    	sanciyishangNumDesc += "新泰" + mapValue + "个，";
		    } else if ("daiyue".equals(mapKey)) {
		    	sanciyishangNumDesc += "岱岳" + mapValue + "个，";
		    } else if ("ningyang".equals(mapKey)) {
		    	sanciyishangNumDesc += "宁阳" + mapValue + "个，";
		    } else if ("taishan".equals(mapKey)) {
		    	sanciyishangNumDesc += "泰山" + mapValue + "个，";
		    } else if ("dongping".equals(mapKey)) {
		    	sanciyishangNumDesc += "东平" + mapValue + "个，";
		    } else if ("feicheng".equals(mapKey)) {
		    	sanciyishangNumDesc += "肥城" + mapValue + "个，";
		    } else if ("taishanjingqu".equals(mapKey)) {
		    	sanciyishangNumDesc += "泰山景区" + mapValue + "个，";
		    } else if ("gaoxin".equals(mapKey)) {
		    	sanciyishangNumDesc += "高新" + mapValue + "个，";
		    }
		}
		
		// 恢复供电时间
		DwFileDetail00Example example = new DwFileDetail00Example();
		example.createCriteria().andStartTimeGreaterThanOrEqualTo(beginTime).andEndTimeLessThanOrEqualTo(endTime);
		List<DwFileDetail00> selectByExample = db.selectByExample(DwFileDetail00Mapper.class, example, new MINRowBounds(1, 1));
		String huifu = "";
		if (selectByExample.size() != 0) {
			String hour = selectByExample.get(0).getEndTime().substring(8, 10);
			String min = selectByExample.get(0).getEndTime().substring(10, 12);
			if ("00".equals(min)) {
				huifu = hour;
			} else {
				huifu = CommonUtil.add(hour, "1");
			}
		}
		
		Map<String, Object> dataMap = new HashMap<String, Object>();
		dataMap.put("tingdianNum", tingdianNum);
		dataMap.put("tingdianNumDesc", tingdianNumDesc);
		dataMap.put("monthNum", monthNum);
		dataMap.put("countNum", countNum);
		dataMap.put("sanciyishangNum", sanciyishangNum);
		dataMap.put("sanciyishangNumDesc", sanciyishangNumDesc);
		dataMap.put("huifu", huifu);
		String descStr = "监测发现台区停电${tingdianNum}个，按单位分：${tingdianNumDesc}其中${monthNum}个月内重复停电${countNum}次及以上的台区${sanciyishangNum}，按单位分：${sanciyishangNumDesc}截止今日${huifu}时已全部恢复送电。";
		resMap.put("dataMap", dataMap);
		resMap.put("descStr", descStr);
		
		return resMap;
	}
	
	/**
	 * 台区停电周报
	 * @param range
	 * @param timeRange
	 * @return
	 * @throws MINBusinessException
	 * @throws ParseException
	 */
	public Map<String, Object> reportTypeTQTDZB(String range, String timeRange) throws MINBusinessException, ParseException {
		Map<String, Object> resMap = new HashMap<String, Object>();
		
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		Map<String, Object> param = new HashMap<String, Object>();
		String beginTime = null;
		String endTime = null;
		range = range.replaceAll(" ", "");
		String[] rangeArray = range.split("-");
		timeRange = timeRange.replaceAll(" ", "");
		if (CommonUtil.isEmpty(timeRange)) {
			beginTime = rangeArray[0] + "000000";
			endTime = rangeArray[1] + "235959";
		} else {
			String[] timeRangeArray = timeRange.split("-");
			beginTime = rangeArray[0] + timeRangeArray[0];
			endTime = rangeArray[1] + timeRangeArray[1];
		}
		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		
		List<List<String>> resList = new ArrayList<List<String>>();
		List<String> title = new ArrayList<String>();
		title.add("单位\\分类");
		title.add("管理台区总数");
		title.add("本周累计停电台次");
		title.add("停电时户数");
		title.add("本周平均停电时长（小时）");
		title.add("本周重复停电台区数");
		title.add("本周督办频繁停电台次");
		title.add("本周督办频繁停电台区数");
		resList.add(title);
		List<String> xintai = new ArrayList<String>();
		xintai.add("新泰");
		xintai.add(totalMap.get("xintai"));
		List<String> daiyue = new ArrayList<String>();
		daiyue.add("岱岳");
		daiyue.add(totalMap.get("daiyue"));
		List<String> ningyang = new ArrayList<String>();
		ningyang.add("宁阳");
		ningyang.add(totalMap.get("ningyang"));
		List<String> taishan = new ArrayList<String>();
		taishan.add("泰山");
		taishan.add(totalMap.get("taishan"));
		List<String> dongping = new ArrayList<String>();
		dongping.add("东平");
		dongping.add(totalMap.get("dongping"));
		List<String> feicheng = new ArrayList<String>();
		feicheng.add("肥城");
		feicheng.add(totalMap.get("feicheng"));
		List<String> taishanjingqu = new ArrayList<String>();
		taishanjingqu.add("泰山景区");
		taishanjingqu.add(totalMap.get("taishanjingqu"));
		List<String> gaoxin = new ArrayList<String>();
		gaoxin.add("高新");
		gaoxin.add(totalMap.get("gaoxin"));
		List<String> heji = new ArrayList<String>();
		heji.add("合计");
		heji.add(totalMap.get("heji"));
		
		resList.add(xintai);
		resList.add(daiyue);
		resList.add(ningyang);
		resList.add(taishan);
		resList.add(dongping);
		resList.add(feicheng);
		resList.add(taishanjingqu);
		resList.add(gaoxin);
		resList.add(heji);
		
		//累计停电台次
		List<Map<String, String>> areaCountList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail00ByArea(param);
		String totalCount = "0";
		for (Map<String, String> map : areaCountList) {
			String area = map.get("area");
			String count = map.get("count");
			if ("新泰".equals(area)) {
				xintai.add(count);
			} else if ("岱岳".equals(area)) {
				daiyue.add(count);
			} else if ("宁阳".equals(area)) {
				ningyang.add(count);
			} else if ("泰山".equals(area)) {
				taishan.add(count);
			} else if ("东平".equals(area)) {
				dongping.add(count);
			} else if ("肥城".equals(area)) {
				feicheng.add(count);
			} else if ("泰山景区".equals(area)) {
				taishanjingqu.add(count);
			} else if ("高新".equals(area)) {
				gaoxin.add(count);
			}
			totalCount = CommonUtil.add(totalCount, count);
		}
		heji.add(totalCount);
		// 没有数据的区域数值为0
		for (List<String> list : resList) {
			if (list.size() == 2) {
				list.add("0");
			}
		}
		
		// 平均停电时长
		String totalHour = "0";	//总时长
		String totalCountSC = "0";
		List<Map<String, String>> areaTimeList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail00ByArea(param);
		for (Map<String, String> map : areaTimeList) {
			String area = map.get("area");
			String timeMinute = map.get("timeMinute");
			String count = map.get("count");
			// 平均停电小时
			String hour = CommonUtil.divide(timeMinute, "60", 2);
			String hourPJ = CommonUtil.divide(hour, count, 2);
			if ("新泰".equals(area)) {
				xintai.add(hour);
				xintai.add(hourPJ);
			} else if ("岱岳".equals(area)) {
				daiyue.add(hour);
				daiyue.add(hourPJ);
			} else if ("宁阳".equals(area)) {
				ningyang.add(hour);
				ningyang.add(hourPJ);
			} else if ("泰山".equals(area)) {
				taishan.add(hour);
				taishan.add(hourPJ);
			} else if ("东平".equals(area)) {
				dongping.add(hour);
				dongping.add(hourPJ);
			} else if ("肥城".equals(area)) {
				feicheng.add(hour);
				feicheng.add(hourPJ);
			} else if ("泰山景区".equals(area)) {
				taishanjingqu.add(hour);
				taishanjingqu.add(hourPJ);
			} else if ("高新".equals(area)) {
				gaoxin.add(hour);
				gaoxin.add(hourPJ);
			} else {
				continue;
			}
			totalHour = CommonUtil.add(totalHour, hour);
			totalCountSC = CommonUtil.add(totalCountSC, count);
		}
		heji.add(totalHour);
		heji.add(CommonUtil.divide(totalHour, totalCountSC, 2));
		
		// 没有数据的区域数值为0
		for (List<String> list : resList) {
			if (list.size() == 3) {
				list.add("0");
				list.add("0");
			}
		}
		
		// 本周重复停电台区数
		param.put("beginDay", beginTime);
		param.put("endDay", endTime);
		param.put("countNum", "2");
		
		// 停电次数最多的台区
		String mostAddressNumDesc = "";
		// 停电最多的次数
		String mostAddressNum = "";
		String totalChongfu = "0";
		List<Map<String, String>> twiceCountList = db.getMybatisMapper(ReportServiceMapper.class).selectMountCount00(param);
		for (Map<String, String> map : twiceCountList) {
			String area = map.get("area");
			String num = map.get("num");
			String addressName = map.get("addressName");
			if ("新泰".equals(area)) {
				if (xintai.size() >= 6) {
					xintai.set(5, CommonUtil.add(xintai.get(5), "1"));
				} else {
					xintai.add(5, "1");
				}
			} else if ("岱岳".equals(area)) {
				if (daiyue.size() >= 6) {
					daiyue.set(5, CommonUtil.add(daiyue.get(5), "1"));
				} else {
					daiyue.add(5, "1");
				}
			} else if ("宁阳".equals(area)) {
				if (ningyang.size() >= 6) {
					ningyang.set(5, CommonUtil.add(ningyang.get(5), "1"));
				} else {
					ningyang.add(5, "1");
				}
			} else if ("泰山".equals(area)) {
				if (taishan.size() >= 6) {
					taishan.set(5, CommonUtil.add(taishan.get(5), "1"));
				} else {
					taishan.add(5, "1");
				}
			} else if ("东平".equals(area)) {
				if (dongping.size() >= 6) {
					dongping.set(5, CommonUtil.add(dongping.get(5), "1"));
				} else {
					dongping.add(5, "1");
				}
			} else if ("肥城".equals(area)) {
				if (feicheng.size() >= 6) {
					feicheng.set(5, CommonUtil.add(feicheng.get(5), "1"));
				} else {
					feicheng.add(5, "1");
				}
			} else if ("泰山景区".equals(area)) {
				if (taishanjingqu.size() >= 6) {
					taishanjingqu.set(5, CommonUtil.add(taishanjingqu.get(5), "1"));
				} else {
					taishanjingqu.add(5, "1");
				}
			} else if ("高新".equals(area)) {
				if (gaoxin.size() >= 6) {
					gaoxin.set(5, CommonUtil.add(gaoxin.get(5), "1"));
				} else {
					gaoxin.add(5, "1");
				}
			} else {
				continue;
			}
			totalChongfu = CommonUtil.add(totalChongfu, "1");
			
			if (CommonUtil.isEmpty(mostAddressNum)) {
				mostAddressNum = num;
			}
			if (mostAddressNum.equals(num)) {
				mostAddressNumDesc += addressName + "、";
			}
		}
		// 去除最后一个符号
		mostAddressNumDesc = mostAddressNumDesc.substring(0, mostAddressNumDesc.length() - 1);
		heji.add(totalChongfu);
		// 没有数据的区域数值为0
		for (List<String> list : resList) {
			if (list.size() == 5) {
				list.add("0");
			}
		}
		
		// 最长时长
		List<Map<String, String>> zuichangTaiquList = db.getMybatisMapper(ReportServiceMapper.class).selectReportType00ZuichangTaiqu(param);
		String zuichangTaiqu = "";
		String zuichangSj = "";
		if (zuichangTaiquList.size() > 1) {
			zuichangTaiqu = zuichangTaiquList.get(0).get("addressName");
			zuichangSj = CommonUtil.divide(zuichangTaiquList.get(0).get("timeMinute"), "60", 2);
		}
		
		String totalMonthChongfuTaici = "0";
		String totalMonthChongfuTaishu = "0";
		beginTime = DateUtil.dateAddDay(DateUtil.dateAddMonth(rangeArray[1], -2), 1);
		if (CommonUtil.isEmpty(timeRange)) {
			param.put("beginDay", beginTime = DateUtil.dateAddDay(DateUtil.dateAddMonth(rangeArray[1], -2), 1) + "000000");
		} else {
			String[] timeRangeArray = timeRange.split("-");
			param.put("beginDay", DateUtil.dateAddDay(DateUtil.dateAddMonth(rangeArray[1], -2), 1) + timeRangeArray[0]);
		}
		param.put("endDay", endTime);
		param.put("countNum", "3");
		List<Map<String, String>> twiceMonthCountList = db.getMybatisMapper(ReportServiceMapper.class).selectMountCount00(param);
		
		// 停电次数最多的台区
		String liangyueMostAddressNumDesc = "";
		// 停电最多的次数
		String liangyueMostAddressNum = "";
		
		// 本周督办频繁停电台次/本周督办频繁停电台区数
		for (Map<String, String> map : twiceMonthCountList) {
			String area = map.get("area");
			String addressName = map.get("addressName");
			String num = map.get("num");
			if ("新泰".equals(area)) {
				if (xintai.size() >= 7) {
					xintai.set(6, CommonUtil.add(xintai.get(6), num));
				} else {
					xintai.add(6, num);
				}
				if (xintai.size() >= 8) {
					xintai.set(7, CommonUtil.add(xintai.get(7), "1"));
				} else {
					xintai.add(7, "1");
				}
			} else if ("岱岳".equals(area)) {
				if (daiyue.size() >= 7) {
					daiyue.set(6, CommonUtil.add(daiyue.get(6), num));
				} else {
					daiyue.add(6, num);
				}
				if (daiyue.size() >= 8) {
					daiyue.set(7, CommonUtil.add(daiyue.get(7), "1"));
				} else {
					daiyue.add(7, "1");
				}
			} else if ("宁阳".equals(area)) {
				if (ningyang.size() >= 7) {
					ningyang.set(6, CommonUtil.add(ningyang.get(6), num));
				} else {
					ningyang.add(6, num);
				}
				if (ningyang.size() >= 8) {
					ningyang.set(7, CommonUtil.add(ningyang.get(7), "1"));
				} else {
					ningyang.add(7, "1");
				}
			} else if ("泰山".equals(area)) {
				if (taishan.size() >= 7) {
					taishan.set(6, CommonUtil.add(taishan.get(6), num));
				} else {
					taishan.add(6, num);
				}
				if (taishan.size() >= 8) {
					taishan.set(7, CommonUtil.add(taishan.get(7), "1"));
				} else {
					taishan.add(7, "1");
				}
			} else if ("东平".equals(area)) {
				if (dongping.size() >= 7) {
					dongping.set(6, CommonUtil.add(dongping.get(6), num));
				} else {
					dongping.add(6, num);
				}
				if (dongping.size() >= 8) {
					dongping.set(7, CommonUtil.add(dongping.get(7), "1"));
				} else {
					dongping.add(7, "1");
				}
			} else if ("肥城".equals(area)) {
				if (feicheng.size() >= 7) {
					feicheng.set(6, CommonUtil.add(feicheng.get(6), num));
				} else {
					feicheng.add(6, num);
				}
				if (feicheng.size() >= 8) {
					feicheng.set(7, CommonUtil.add(feicheng.get(7), "1"));
				} else {
					feicheng.add(7, "1");
				}
			} else if ("泰山景区".equals(area)) {
				if (taishanjingqu.size() >= 7) {
					taishanjingqu.set(6, CommonUtil.add(taishanjingqu.get(6), num));
				} else {
					taishanjingqu.add(6, num);
				}
				if (taishanjingqu.size() >= 8) {
					taishanjingqu.set(7, CommonUtil.add(taishanjingqu.get(7), "1"));
				} else {
					taishanjingqu.add(7, "1");
				}
			} else if ("高新".equals(area)) {
				if (gaoxin.size() >= 7) {
					gaoxin.set(6, CommonUtil.add(gaoxin.get(6), num));
				} else {
					gaoxin.add(6, num);
				}
				if (gaoxin.size() >= 8) {
					gaoxin.set(7, CommonUtil.add(gaoxin.get(7), "1"));
				} else {
					gaoxin.add(7, "1");
				}
			} else {
				continue;
			}
			totalMonthChongfuTaici= CommonUtil.add(totalMonthChongfuTaici, num);
			totalMonthChongfuTaishu = CommonUtil.add(totalMonthChongfuTaishu, "1");
			
			if (CommonUtil.isEmpty(liangyueMostAddressNum)) {
				liangyueMostAddressNum = num;
			}
			if (liangyueMostAddressNum.equals(num)) {
				liangyueMostAddressNumDesc += addressName + "、";
			}
		}
		// 去除最后一个符号
		liangyueMostAddressNumDesc = liangyueMostAddressNumDesc.substring(0, liangyueMostAddressNumDesc.length() - 1);
		heji.add(totalMonthChongfuTaici);
		heji.add(totalMonthChongfuTaishu);
		
		// 环比
		String huanbi = "0";
		String huanbiBeginTime = DateUtil.dateAddMonth(rangeArray[1], -4);	// 减四个月加一天
		String huanbiEndTime = DateUtil.dateAddMonth(rangeArray[1], -2);							// 减两个月
		if (CommonUtil.isEmpty(timeRange)) {
			huanbiBeginTime = huanbiBeginTime + "000000";
			huanbiEndTime = huanbiEndTime + "235959";
		} else {
			String[] timeRangeArray = timeRange.split("-");
			huanbiBeginTime = huanbiBeginTime + timeRangeArray[0];
			huanbiEndTime = huanbiEndTime + timeRangeArray[1];
		}
		
		param.put("beginDay", huanbiBeginTime);
		param.put("endDay", huanbiEndTime);
		List<Map<String, String>> huanbiTwiceMonthCountList = db.getMybatisMapper(ReportServiceMapper.class).selectMountCount00(param);
		for (Map<String, String> map : huanbiTwiceMonthCountList) {
			String num = map.get("num");
			huanbi = CommonUtil.add(huanbi, num);
		}
		// 同比
		String tongbi = "0";
		String tongbiBeginTime = DateUtil.dateAddMonth(DateUtil.dateAddYear(rangeArray[1], -1), -2);	// 减一年两个月
		String tongbiEndTime = DateUtil.dateAddYear(rangeArray[1], -1);															// 减一年
		if (CommonUtil.isEmpty(timeRange)) {
			tongbiBeginTime = tongbiBeginTime + "000000";
			tongbiEndTime = tongbiEndTime + "235959";
		} else {
			String[] timeRangeArray = timeRange.split("-");
			tongbiBeginTime = tongbiBeginTime + timeRangeArray[0];
			tongbiEndTime = tongbiEndTime + timeRangeArray[1];
		}
		
		param.put("beginDay", tongbiBeginTime);
		param.put("endDay", tongbiEndTime);
		List<Map<String, String>> tongbiTwiceMonthCountList = db.getMybatisMapper(ReportServiceMapper.class).selectMountCount00(param);
		for (Map<String, String> map : tongbiTwiceMonthCountList) {
			String num = map.get("num");
			tongbi = CommonUtil.add(tongbi, num);
		}
		
		// 返回excel数据
		resMap.put("excelList", resList);
		
		// 描述数据
		Map<String, Object> dataMap = new HashMap<String, Object>();
		dataMap.put("totalCount", totalCount);
		dataMap.put("pingjun", CommonUtil.divide(totalHour, totalCount, 2));
		dataMap.put("twiceCount", totalChongfu);
		dataMap.put("mostAddressNumDesc", mostAddressNumDesc);
		dataMap.put("mostAddressNum", mostAddressNum);
		dataMap.put("dubanCount", totalMonthChongfuTaici);
		dataMap.put("zuichangTaiqu", zuichangTaiqu);
		dataMap.put("zuichangSj", zuichangSj);
		dataMap.put("liangyueMostAddressNumDesc", liangyueMostAddressNumDesc);
		dataMap.put("liangyueMostAddressNum", liangyueMostAddressNum);
		// 停电两次描述
		String twiceCountDesc = "";
		// 督办台次
		String dubantaiciDesc = "";
		// 重复停电台区描述
		for (int i = 1; i < resList.size(); i ++) {
			List<String> childList = resList.get(i);
			String area = childList.get(0);
			String num = childList.get(5);
			if (CommonUtil.compare(num, "0") != 0) {
				twiceCountDesc += area + num + "个，";
			}
			num = childList.get(6);
			if (CommonUtil.compare(num, "0") != 0) {
				dubantaiciDesc += area + num + "次，";
			}
			
		}
		dataMap.put("twiceCountDesc", twiceCountDesc);
		dataMap.put("dubantaiciDesc", dubantaiciDesc);

		
		// 环比
		if (CommonUtil.compare(huanbi, "0") != 0) {
			if (CommonUtil.compare(totalMonthChongfuTaici, huanbi) == 1) {
				dataMap.put("huanbi", "环比增加" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(totalMonthChongfuTaici, huanbi), huanbi, 4), "100", 2) + "%");
			} else {
				dataMap.put("huanbi", "环比减少" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(huanbi, totalMonthChongfuTaici), huanbi, 4), "100", 2) + "%");
			}
		} else {
			dataMap.put("huanbi", "");
		}
		
		// 同比
		if (CommonUtil.compare(tongbi, "0") != 0) {
			if (CommonUtil.compare(totalMonthChongfuTaici, tongbi) == 1) {
				if (CommonUtil.compare(tongbi, "0") == 0) {
					dataMap.put("tongbi", "");
				} else {
					dataMap.put("tongbi", "同比增加" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(totalMonthChongfuTaici, tongbi), tongbi, 4), "100", 2) + "%。");
				}
			} else {
				dataMap.put("tongbi", "同比减少" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(tongbi, totalMonthChongfuTaici), tongbi, 4), "100", 2) + "%。");
			}
		} else {
			dataMap.put("tongbi", "");
		}
		
		resMap.put("dataMap", dataMap);
		
		String descStr = "<p>上周，台区累计停电${totalCount}台次，平均停电时长${pingjun}小时/台。停电两次及以上台区${twiceCount}个,${twiceCountDesc}${mostAddressNumDesc}重复停电次数最多为${mostAddressNum}次。${zuichangTaiqu}停电时长最长为${zuichangSj}小时。</p>"
				+"上周，督办频繁停电（两个月内三次及以上）共计${dubanCount}台次，${huanbi}，${tongbi}${dubantaiciDesc}${liangyueMostAddressNumDesc}两个月内频繁停电次数最多为${liangyueMostAddressNum}次。";
		resMap.put("descStr", descStr);
		
		return resMap;
	}
	
	
	
	/**
	 * 台区停电月报
	 * @param range
	 * @param timeRange
	 * @return
	 * @throws MINBusinessException 
	 * @throws ParseException 
	 */
	public Map<String, Object> reportTypeTQTDYB(String range, String timeRange) throws MINBusinessException, ParseException{
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		Map<String, Object> param = new HashMap<String, Object>();
		String beginTime = null;
		String endTime = null;
		range = range.replaceAll(" ", "");
		String[] rangeArray = range.split("-");
		timeRange = timeRange.replaceAll(" ", "");
		if (CommonUtil.isEmpty(timeRange)) {
			beginTime = rangeArray[0] + "000000";
			endTime = rangeArray[1] + "235959";
		} else {
			String[] timeRangeArray = timeRange.split("-");
			beginTime = rangeArray[0] + timeRangeArray[0];
			endTime = rangeArray[1] + timeRangeArray[1];
		}
		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		
		/** 本月数据---- start ----*/
		//停电台次
		List<Map<String, String>> areaCountList = db.getMybatisMapper(ReportServiceMapper.class).selectReportType00TqtdGS(param);
		//停电时长
		List<Map<String, String>> areaTimeList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail00ByArea(param);
		//停电台区数
		param.put("beginDay", beginTime);
		param.put("endDay", endTime);
		param.put("countNum", "1");
		List<Map<String, String>> taiquCountList = db.getMybatisMapper(ReportServiceMapper.class).selectMountCount00(param);
		/** 本月数据---- end ----*/
		/** 去年同月数据---- start ----*/
		if (CommonUtil.isEmpty(timeRange)) {
			beginTime = DateUtil.dateAddYear(rangeArray[0], -1) + "000000";
			endTime = DateUtil.dateAddYear(rangeArray[1], -1) + "235959";
		} else {
			String[] timeRangeArray = timeRange.split("-");
			beginTime = DateUtil.dateAddYear(rangeArray[0], -1) + timeRangeArray[0];
			endTime = DateUtil.dateAddYear(rangeArray[1], -1) + timeRangeArray[1];
		}
		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		List<Map<String, String>> tbAreaCountList = db.getMybatisMapper(ReportServiceMapper.class).selectReportType00TqtdGS(param);
		List<Map<String, String>> tbAreaTimeList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail00ByArea(param);
		/** 去年同月数据---- end ----*/
		/** 上月月数据---- start ----*/
		if (CommonUtil.isEmpty(timeRange)) {
			beginTime = DateUtil.dateAddMonth(rangeArray[0], -1) + "000000";
			endTime = DateUtil.dateAddMonth(rangeArray[1], -1) + "235959";
		} else {
			String[] timeRangeArray = timeRange.split("-");
			beginTime = DateUtil.dateAddMonth(rangeArray[0], -1) + timeRangeArray[0];
			endTime = DateUtil.dateAddMonth(rangeArray[1], -1) + timeRangeArray[1];
		}
		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		List<Map<String, String>> hbAreaCountList = db.getMybatisMapper(ReportServiceMapper.class).selectReportType00TqtdGS(param);
		List<Map<String, String>> hbAreaTimeList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail00ByArea(param);
		/** 上月月数据---- end ----*/
		
		/** 停电台区数 ----start----*/
		String totalCount = "0";
		for (int i = 0; i < taiquCountList.size(); i++) {
			totalCount = CommonUtil.add(taiquCountList.get(i).get("num"), totalCount);
		}
		/** 停电台区数 ---- end ----*/
		
		/**停电次数数据处理----start----*/
		Integer month = Integer.parseInt(rangeArray[1].substring(4,6));
		
		String benyueCount = "0";
		String tbCount = "0";
		String hbCount = "0";
		
		for (int i = 0; i < areaCountList.size(); i++) {
			benyueCount = CommonUtil.add(areaCountList.get(i).get("num"), benyueCount);
		}
		for (int i = 0; i < tbAreaCountList.size(); i++) {
			tbCount = CommonUtil.add(tbAreaCountList.get(i).get("num"), tbCount);
		}
		for (int i = 0; i < hbAreaCountList.size(); i++) {
			hbCount = CommonUtil.add(hbAreaCountList.get(i).get("num"), hbCount);
		}
		
		// 同比描述
		String tongbi = "";
		if (CommonUtil.compare(tbCount, "0") != 0) {
			if (CommonUtil.compare(benyueCount, tbCount) == 1) {
				tongbi = "增加" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(benyueCount, tbCount), tbCount,4), "100", 2) + "%";
			} else {
				tongbi = "减少" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(tbCount, benyueCount), tbCount,4), "100", 2) + "%";
			}
		}
		
		// 环比描述
		String huanbi = "";
		if (CommonUtil.compare(hbCount, "0") != 0) {
			if (CommonUtil.compare(benyueCount, hbCount) == 1) {
				huanbi = "增加" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(benyueCount, hbCount), hbCount,4), "100", 2) + "%";
			} else {
				huanbi = "减少" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(hbCount, benyueCount), hbCount,4), "100", 2) + "%";
			}
		}
		int shejiNum = areaCountList.size();
		String shejiDesc = "";
		for (int i = 0; i < areaCountList.size(); i++) {
			if (i == areaCountList.size() - 1) {
				shejiDesc += areaCountList.get(i).get("area") +areaCountList.get(i).get("num")+"台次,占比"+CommonUtil.multiply(CommonUtil.divide(areaCountList.get(i).get("num"), benyueCount, 4), "100", 2)+"%。";
			} else {
				shejiDesc += areaCountList.get(i).get("area") +areaCountList.get(i).get("num")+"台次,占比"+CommonUtil.multiply(CommonUtil.divide(areaCountList.get(i).get("num"), benyueCount, 4), "100", 2)+"%,";
			}
		}
		/**停电次数数据处理----end----*/
		
		/**停电时长数据处理----start----*/
		String benyueTime = "0";
		String tbTime = "0";
		String hbTime = "0";
		for (int i = 0; i < areaTimeList.size(); i++) {
			benyueTime = CommonUtil.add(areaTimeList.get(i).get("timeMinute"), benyueTime);
		}
		for (int i = 0; i < tbAreaTimeList.size(); i++) {
			tbTime = CommonUtil.add(tbAreaTimeList.get(i).get("timeMinute"), tbTime);
		}
		for (int i = 0; i < hbAreaTimeList.size(); i++) {
			hbTime = CommonUtil.add(hbAreaTimeList.get(i).get("timeMinute"), hbTime);
		}
		// sql算的是分钟,转换成小时
		benyueTime = CommonUtil.divide(benyueTime, "60", 2);
		tbTime = CommonUtil.divide(tbTime, "60", 2);
		hbTime = CommonUtil.divide(hbTime, "60", 2);
		// 平均时长
		String pingjunHour = CommonUtil.divide(benyueTime, totalCount, 2);
		// 同比数据
		String tongbiPingjunHour = "";
		if (CommonUtil.compare(tbTime, "0") != 0) {
			if (CommonUtil.compare(benyueTime, tbTime) == 1) {
				tongbiPingjunHour = "增加" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(benyueTime, tbTime), tbTime, 4), "100", 2)+"%";
			} else {
				tongbiPingjunHour = "下降" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(tbTime, benyueTime), tbTime, 4), "100", 2)+"%";
			}
		}
		
		// 环比数据
		String huanbiPingjunHour = "";
		if (CommonUtil.compare(hbTime, "0") != 0) {
			if (CommonUtil.compare(benyueTime, hbTime) == 1) {
				huanbiPingjunHour = "增加" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(benyueTime, hbTime), hbTime, 4), "100", 2)+"%";
			} else {
				huanbiPingjunHour = "下降" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(hbTime, benyueTime), hbTime, 4), "100", 2)+"%";
			}
		}
		// 台区平均停电时长描述
		String areaPingjunDesc = "";
		for (int i = 0; i < areaTimeList.size(); i++) {
			String pingjunTime =  CommonUtil.divide(CommonUtil.divide(areaTimeList.get(i).get("timeMinute"), areaTimeList.get(i).get("count"), 2),"60", 2);
			if (areaTimeList.size() - 1 == i) {
				areaPingjunDesc += areaTimeList.get(i).get("area")+pingjunTime+"小时；";
			} else {
				areaPingjunDesc += areaTimeList.get(i).get("area")+pingjunTime+"小时、";
			}
		}
		// 区域平均时长同比
		String tbAreaPingjunDesc = "";
		for (int i = 0; i < areaTimeList.size(); i++) {
			String pingjunTime =  CommonUtil.divide(CommonUtil.divide(areaTimeList.get(i).get("timeMinute"), areaTimeList.get(i).get("count"), 2),"60", 2);
			for (int j = 0; j < tbAreaTimeList.size(); j++) {
				if (areaTimeList.get(i).get("area").equals(tbAreaTimeList.get(j).get("area"))) {
					String tbPingjunTime =  CommonUtil.divide(CommonUtil.divide(tbAreaTimeList.get(j).get("timeMinute"), tbAreaTimeList.get(j).get("count"), 2),"60", 2);
					if (CommonUtil.compare(pingjunTime, tbPingjunTime) == 1) {
						if (i == areaTimeList.size() - 1) {
							tbAreaPingjunDesc += areaTimeList.get(i).get("area") + "同比上升" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(pingjunTime, tbPingjunTime), tbPingjunTime, 4), "100", 2)+"%。";
						}  else {
							tbAreaPingjunDesc += areaTimeList.get(i).get("area") + "同比上升" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(pingjunTime, tbPingjunTime), tbPingjunTime, 4), "100", 2)+"%、";
						}
					} else {
						if (i == areaTimeList.size() - 1) {
							tbAreaPingjunDesc += areaTimeList.get(i).get("area") + "同比下降" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(tbPingjunTime, pingjunTime), tbPingjunTime, 4), "100", 2)+"%。";
						}  else {
							tbAreaPingjunDesc += areaTimeList.get(i).get("area") + "同比下降" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(tbPingjunTime, pingjunTime), tbPingjunTime, 4), "100", 2)+"%、";
						}
					}
					break;
				}
			}
		}
		// 重新计算开始时间和结束时间
		if (CommonUtil.isEmpty(timeRange)) {
			beginTime = rangeArray[0] + "000000";
			endTime = rangeArray[1] + "235959";
		} else {
			String[] timeRangeArray = timeRange.split("-");
			beginTime = rangeArray[0] + timeRangeArray[0];
			endTime = rangeArray[1] + timeRangeArray[1];
		}
		
		// 分段台区数
		String fenduanDesc = "";
		for (int i = 0; i < fenduanList.size(); i ++) {
			Map<String, String> shiduanMap = fenduanList.get(i);
			shiduanMap.put("beginTime", beginTime);
			shiduanMap.put("endTime", endTime);
			String num = db.getMybatisMapper(ReportServiceMapper.class).selectReportType00FenDuan(shiduanMap);
			String zhanbi = CommonUtil.multiply(CommonUtil.divide(num, totalCount, 4), "100", 2);
			if (i == fenduanList.size() - 1) {
				fenduanDesc += shiduanMap.get("desc")+ "的" + num+ "台，占比"+zhanbi+"%。";
			} else {
				fenduanDesc += shiduanMap.get("desc")+ "的" + num+ "台，占比"+zhanbi+"%；";
			}
		}

		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		// 最长停电台区
		List<Map<String, String>> zuichangTaiquList = db.getMybatisMapper(ReportServiceMapper.class).selectReportType00ZuichangTaiqu(param);
		String zuichangTaiQu = "";
		String zuichangTaiQuTime = "";
		String qiciTaiQu = "";
		String qiciTaiQuTime = "";
		if (zuichangTaiquList.size() > 0) {
			zuichangTaiQu = zuichangTaiquList.get(0).get("addressName");
			zuichangTaiQuTime = CommonUtil.divide(zuichangTaiquList.get(0).get("timeMinute"), "60", 2);
			if (zuichangTaiquList.size() > 1) {
				qiciTaiQu = zuichangTaiquList.get(1).get("addressName");
				qiciTaiQuTime = CommonUtil.divide(zuichangTaiquList.get(1).get("timeMinute"), "60", 2);
			}
		}

		// 两个月内停电2次以上的数据
		String beginDay = DateUtil.dateAddMonth(rangeArray[1], Integer.parseInt("-2"));
		param.put("beginDay", beginDay);
		param.put("endDay", rangeArray[1]);
		param.put("countNum", "2");
		List<Map<String, String>> twiceMountCountList = db.getMybatisMapper(ReportServiceMapper.class).selectMountCount00(param);
		Map<String, Integer> taiQuMapTwice = new HashMap<String, Integer>();//区域统计
		String totalCountTwice = "0";
		for (Map<String, String> map : twiceMountCountList) {
			String area = map.get("area");
			// 已存在
			if (taiQuMapTwice.containsKey(area)) {
				taiQuMapTwice.put(map.get("area"), taiQuMapTwice.get(map.get("area"))+1);
			} else {
				taiQuMapTwice.put(map.get("area"), 1);
			}
			totalCountTwice = CommonUtil.add(totalCountTwice, "1");
		}
		
		String totalCountTwiceDesc = "";
		for (Map.Entry<String, Integer> entry : taiQuMapTwice.entrySet()) {
			totalCountTwiceDesc += entry.getKey() + entry.getValue()+"台，占比"+CommonUtil.multiply(CommonUtil.divide(entry.getValue().toString(), totalCountTwice, 4), "100", 2)+"%；";
		}
		totalCountTwiceDesc = totalCountTwiceDesc.substring(0,totalCountTwiceDesc.length() - 1) + "。";
		
		Map<String, Integer> countMapTwice = new HashMap<String, Integer>();
		for (Map<String, String> map : twiceMountCountList) {
			String num = map.get("num");
			// 已存在
			if (countMapTwice.containsKey(num)) {
				countMapTwice.put(num, countMapTwice.get(num) + 1);
			} else {
				countMapTwice.put(num, 1);
			}
		}
		String countMapTwiceDesc = "";
		for (Map.Entry<String, Integer> entry : countMapTwice.entrySet()) {
			countMapTwiceDesc += "停电" + entry.getKey() + "次的" + entry.getValue() + "台，占比" + CommonUtil.multiply(CommonUtil.divide(entry.getValue().toString(), totalCountTwice, 4), "100", 2)+"%；";
		}
		countMapTwiceDesc = countMapTwiceDesc.substring(0,countMapTwiceDesc.length() - 1) + "。";
		
		// 两个月内停电3次以上的数据
		param.put("countNum", "3");
		List<Map<String, String>> thipleMountCountList = db.getMybatisMapper(ReportServiceMapper.class).selectMountCount00(param);
		String totalCountthiple = String.valueOf(thipleMountCountList.size());
		
		/**停电次数数据处理----end----*/
		
		String descStr = "<p>（1）台区停电总体情况${month}月份，台区累计停电${benyueCount}台次，同比${tongbi}，环比${huanbi}，涉及${shejiNum}个台区，${shejiDesc}</p>"
				+ "<p>（2）台区停电时长情况${totalCount}个台区累计停电时间${benyueTime}小时，平均停电时长${pingjunHour}小时，同比${tongbiPingjunHour}，环比${huanbiPingjunHour}。台区平均停电时间为${areaPingjunDesc}从同比情况看，${tbAreaPingjunDesc}</p>"
				+ "<p>台区停电时长在${fenduanDesc}停电时长最长的为${zuichangTaiQu}，停电${zuichangTaiQuTime}小时，其次是${qiciTaiQu}，停电时长${qiciTaiQuTime}小时。</p>"
				+ "<p>（3）台区重复停电情况两个月内停电2次及以上的台变${totalCountTwice}个，其中${totalCountTwiceDesc}${totalCountTwice}个重复停电台变中，${countMapTwiceDesc}两个月内停电3次及以上的台变${totalCountthiple}个。</p>";
		
		Map<String, Object> dataMap = new HashMap<String, Object>();
		dataMap.put("month", month);
		dataMap.put("benyueCount", benyueCount);
		dataMap.put("tongbi", tongbi);
		dataMap.put("huanbi", huanbi);
		dataMap.put("shejiNum", shejiNum);
		dataMap.put("shejiDesc", shejiDesc);
		dataMap.put("totalCount", totalCount);
		dataMap.put("benyueTime", benyueTime);
		dataMap.put("pingjunHour", pingjunHour);
		dataMap.put("tongbiPingjunHour", tongbiPingjunHour);
		dataMap.put("huanbiPingjunHour", huanbiPingjunHour);
		dataMap.put("areaPingjunDesc", areaPingjunDesc);
		dataMap.put("tbAreaPingjunDesc", tbAreaPingjunDesc);
		dataMap.put("fenduanDesc", fenduanDesc);
		dataMap.put("zuichangTaiQu", zuichangTaiQu);
		dataMap.put("zuichangTaiQuTime", zuichangTaiQuTime);
		dataMap.put("qiciTaiQu", qiciTaiQu);
		dataMap.put("qiciTaiQuTime", qiciTaiQuTime);
		dataMap.put("totalCountTwice", totalCountTwice);
		dataMap.put("totalCountTwiceDesc", totalCountTwiceDesc);
		dataMap.put("countMapTwiceDesc", countMapTwiceDesc);
		dataMap.put("totalCountthiple", totalCountthiple);
		
		Map<String, Object> resMap = new HashMap<String, Object>();
		resMap.put("dataMap", dataMap);
		resMap.put("descStr", descStr);
		return resMap; 
	}
	
	public List<List<String>> reportTypeZDDTYBB(String firstFileId, String secondFileId) throws MINBusinessException{
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		List<List<String>> resList = new ArrayList<List<String>>();
		
		List<String> titleList = new ArrayList<String>();
		titleList.add("ID");
		titleList.add("TNAME");
		titleList.add("SRC");
		resList.add(titleList);
		
		DwFileDetail01Example fileDetail01Example = new DwFileDetail01Example();
		fileDetail01Example.createCriteria().andFileIdEqualTo(firstFileId);
		// 选择文件
		List<DwFileDetail01> firstList = db.selectByExample(DwFileDetail01Mapper.class, fileDetail01Example);
		fileDetail01Example.clear();
		// 对比文件
		fileDetail01Example.createCriteria().andFileIdEqualTo(secondFileId);
		List<DwFileDetail01> secondList = db.selectByExample(DwFileDetail01Mapper.class, fileDetail01Example);
		
		for (DwFileDetail01 first : firstList) {
			String firstExcelId = first.getExcelId();
			boolean flag = false;
			for (DwFileDetail01 second : secondList) {
				String secondExcelId = second.getExcelId();
				if (firstExcelId.equals(secondExcelId)) {
					flag = true;
					break;
				}
			}
			if (!flag) {
				List<String> resChildList = new ArrayList<String>();
				resChildList.add(first.getExcelId());
				resChildList.add(first.getExcelTname());
				resChildList.add("退出");
				resList.add(resChildList);
			}
		}
		for (DwFileDetail01 second : secondList) {
			String secondExcelId = second.getExcelId();
			boolean flag = false;
			for (DwFileDetail01 first : firstList) {
				String firstExcelId = first.getExcelId();
				if (secondExcelId.equals(firstExcelId)) {
					flag = true;
					break;
				}
			}
			if (!flag) {
				List<String> resChildList = new ArrayList<String>();
				resChildList.add(second.getExcelId());
				resChildList.add(second.getExcelTname());
				resChildList.add("投入");
				resList.add(resChildList);
			}
		}
		return resList;
	}
	
	public List<List<String>> reportTypeFADZBB(String FADateRange, String yearChoose) throws MINBusinessException, ParseException{
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		List<List<String>> resList = new ArrayList<List<String>>();
		
		List<String> titleList = new ArrayList<String>();
		titleList.add("故障区间判断正确率");
		titleList.add("故障区间判断正确环比");
		titleList.add("故障前后段恢复正确率");
		titleList.add("故障前后段恢复正确环比");
		titleList.add("配电线路故障自愈成功率");
		titleList.add("配电线路故障自愈成功环比");
		resList.add(titleList);
		
		Date beginTimeDate = DateUtil.parseDate(yearChoose + FADateRange.substring(0, 4), "yyyyMMdd");
		String beginTime = DateUtil.format(beginTimeDate, "yyyyMMdd");
		String endTime = yearChoose + FADateRange.substring(4, 8);
		// 开始月份是12,年份取下一年
		if ("12".equals(beginTime.substring(0, 2))) {
			endTime = CommonUtil.add(yearChoose, "1") + FADateRange.substring(4, 8);
		}
		
		Map<String, String> param = new HashMap<String, String>();
		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		List<Map<String, String>> GZQJPDList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail02ByGZQJPD(param);
		List<Map<String, String>> GZQHDHFList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail02ByGZQHDHF(param);
		List<Map<String, String>> GZQJPDAndGZQHDHFList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail02ByGZQJPDAndGZQHDHF(param);
		
		// 环比日期
		String huanbiEndTime = DateUtil.dateAddDay(beginTime, -1);
		PubAppparExample appparExample = new PubAppparExample();
		appparExample.createCriteria().andCodeEqualTo("FADateRange").andValueLike("%"+huanbiEndTime.substring(4, 8));
		List<PubApppar> appparList = db.getMybatisMapper(PubAppparMapper.class).selectByExample(appparExample);
		if (appparList.size() != 1) {
			throw new MINBusinessException("FA动作正确率日期区间获取错误!");
		}
		PubApppar apppar = appparList.get(0);
		String value = apppar.getValue();
		String huanbiBeginTime = huanbiEndTime.substring(0, 4) + value.substring(0, 4);
		// 结束月是1月,年份取上一年
		if ("01".equals(huanbiBeginTime.substring(4, 6))) {
			huanbiBeginTime = CommonUtil.subtract(huanbiEndTime.substring(0, 4), "1") + value.substring(0, 4);
		}
		List<Map<String, String>> huanbiGZQJPDList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail02ByGZQJPD(param);
		List<Map<String, String>> huanbiGZQHDHFList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail02ByGZQHDHF(param);
		List<Map<String, String>> huanbiGZQJPDAndGZQHDHFList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail02ByGZQJPDAndGZQHDHF(param);
		
		List<String> childList = new ArrayList<String>();
		// 故障区间判断正确率
		if (GZQJPDList.size() == 0) {
			childList.add("无数据");
		} else {
			String zhengqueCount = "0";
			String totalNum = "0";
			for (Map<String, String> dataMap : GZQJPDList) {
				if ("正确".equals(dataMap.get("gzqjpd").trim())) {
					zhengqueCount = dataMap.get("num");
				}
				totalNum = CommonUtil.add(totalNum, dataMap.get("num"));
			}
			childList.add(CommonUtil.multiply(CommonUtil.divide(zhengqueCount, totalNum, 4), "100", 2) + "%");
		}
		
		// 故障区间判断正确环比
		if (huanbiGZQJPDList.size() == 0) {
			childList.add("无数据");
		} else {
			String zhengqueCount = "0";
			String totalNum = "0";
			for (Map<String, String> dataMap : huanbiGZQJPDList) {
				if ("正确".equals(dataMap.get("gzqjpd").trim())) {
					zhengqueCount = dataMap.get("num");
				}
				totalNum = CommonUtil.add(totalNum, dataMap.get("num"));
			}
			childList.add(CommonUtil.multiply(CommonUtil.divide(zhengqueCount, totalNum, 4), "100", 2) + "%");
		}
		
		// 故障前后段恢复正确率
		if (GZQHDHFList.size() == 0) {
			childList.add("无数据");
		} else {
			String zhengqueCount = "0";
			String totalNum = "0";
			for (Map<String, String> dataMap : GZQHDHFList) {
				if ("正确".equals(dataMap.get("gzqhdhf").trim())) {
					zhengqueCount = dataMap.get("num");
				}
				totalNum = CommonUtil.add(totalNum, dataMap.get("num"));
			}
			childList.add(CommonUtil.multiply(CommonUtil.divide(zhengqueCount, totalNum, 4), "100", 2) + "%");
		}
		
		// 故障前后段恢复正确环比
		if (huanbiGZQHDHFList.size() == 0) {
			childList.add("无数据");
		} else {
			String zhengqueCount = "0";
			String totalNum = "0";
			for (Map<String, String> dataMap : huanbiGZQHDHFList) {
				if ("正确".equals(dataMap.get("gzqhdhf").trim())) {
					zhengqueCount = dataMap.get("num");
				}
				totalNum = CommonUtil.add(totalNum, dataMap.get("num"));
			}
			childList.add(CommonUtil.multiply(CommonUtil.divide(zhengqueCount, totalNum, 4), "100", 2) + "%");
		}
		
		// 配电线路故障自愈成功率
		if (GZQJPDAndGZQHDHFList.size() == 0) {
			childList.add("无数据");
		} else {
			String zhengqueCount = "0";
			String totalNum = "0";
			for (Map<String, String> dataMap : huanbiGZQHDHFList) {
				// 故障区间判断、故障前后段恢复均为正确的数量/总数量
				if ("正确".equals(dataMap.get("gzqhdhf")) && "正确".equals(dataMap.get("gzqjpd"))) {
					zhengqueCount = dataMap.get("num");
				}
				totalNum = CommonUtil.add(totalNum, dataMap.get("num"));
			}
			childList.add(CommonUtil.multiply(CommonUtil.divide(zhengqueCount, totalNum, 4), "100", 2) + "%");
		}
		
		// 配电线路故障自愈成功环比
		if (huanbiGZQJPDAndGZQHDHFList.size() == 0) {
			childList.add("无数据");
		} else {
			String zhengqueCount = "0";
			String totalNum = "0";
			for (Map<String, String> dataMap : huanbiGZQJPDAndGZQHDHFList) {
				// 故障区间判断、故障前后段恢复均为正确的数量/总数量
				if ("正确".equals(dataMap.get("gzqhdhf").trim()) && "正确".equals(dataMap.get("gzqjpd").trim())) {
					zhengqueCount = dataMap.get("num");
				}
				totalNum = CommonUtil.add(totalNum, dataMap.get("num"));
			}
			childList.add(CommonUtil.multiply(CommonUtil.divide(zhengqueCount, totalNum, 4), "100", 2) + "%");
		}
		resList.add(childList);
		
		return resList;
	}
	
	/**
	 * 低电压治理分析表
	 * @param range
	 * @param reportTypeId
	 * @return
	 * @throws MINBusinessException
	 * @throws ParseException
	 * @throws InvocationTargetException 
	 * @throws IllegalArgumentException 
	 * @throws IllegalAccessException 
	 * @throws SecurityException 
	 * @throws NoSuchMethodException 
	 */
	public Map<String, Object> reportTypeDDYZLFXB(String range, String reportTypeId, int page, int limit) throws MINBusinessException, ParseException, NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException{
		Map<String, Object> resMap = new HashMap<String, Object>();
		
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		List<List<String>> resList = new ArrayList<List<String>>();
		resMap.put("resList", resList);
		
		List<String> titleList = new ArrayList<String>();
		titleList.add("序号");
		titleList.add("县公司名称");
		titleList.add("用户管理单位名称");
		titleList.add("线路名称");
		titleList.add("台区ID");
		titleList.add("变压器名称");
		titleList.add("用户编号");
		titleList.add("低电压时长");
		titleList.add("累计天数");
		titleList.add("低电压主要原因（点选)");
		titleList.add("具体原因");
		titleList.add("治理措施");
		titleList.add("是否治理（点选）");
		titleList.add("治理完成时间");
		titleList.add("是否消除");
		titleList.add("昨日新增");
		titleList.add("全年累计天数");
		range = range.replaceAll(" ", "");
		String[] rangeArray = range.split("-");
		String beginTime = rangeArray[0];
		String endTime = rangeArray[1];
		List<String> childLists = new ArrayList<String>();
		childLists.add("1.数据来源：智能化供电服务指挥系统；因系统数据滞后，统计时间为："+CommonUtil.dateFormat(beginTime,"yyyy年MM月dd日")+"——"+CommonUtil.dateFormat(endTime,"yyyy年MM月dd日")+"，每日发生低电压客户已标红，受考核用户已标黄，累计时长≥15小时的预警用户标褐红色需重点治理。每日新增预警及考核用户编号已标红。2.反馈要求：请各单位照实填写，按时反馈，具体原因请填写详细，治理完成的填写治理完成时间。未填写或填写不详细的一律列入考核，请知悉。3.低电压是否消除：以供电服务指挥系统数据为依据，连续7天未发生低电压视为低电压消除。");
		resList.add(childLists);
		int count = DateUtil.diffDate(beginTime, endTime);
		//日期集合
		List<String> dateList = new ArrayList<String>();
		for(int i=0;i<=count;i++){
			String beginDate = DateUtil.dateAddDay(endTime,-i);
			dateList.add(beginDate);
			beginDate = beginDate.substring(4,6)+"/"+beginDate.substring(6);
			titleList.add(beginDate+"低电压时长");
		}
		//子类数据
		resList.add(titleList);
		//查询累计天数以及累计时长
		Map<String, Object> param = new HashMap<String, Object>();
		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		
		// 分析表数据过大,分页处理
		MINRowBounds rows = new MINRowBounds(page, limit);
		rows.setSeparateSql(true);
		
		List<Map<String, String>>  DDYZLFXBList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYZLFXB(param, rows);
		
		resMap.put("resList", resList);
		resMap.put("count", rows.getCount());
		
		List<String> yhidList = CommonUtil.getIdFromList(DDYZLFXBList, "yhid");
		DwFileDetail03Example example03 = new DwFileDetail03Example();
		example03.createCriteria().andSjrqBetween(beginTime, endTime).andYhidIn(yhidList);
		example03.setOrderByClause("DFD3_YHID,DFD3_SJRQ desc");
		List<DwFileDetail03> detailList = db.selectByExample(DwFileDetail03Mapper.class, example03);
		
		// 获取全年累计天数
		String year = endTime.substring(0, 4);
		param.put("beginTime", CommonUtil.subtract(year, "1") + "1226");
		param.put("endTime", year + "1225");
		param.put("yhidList", yhidList);
		List<Map<String, String>> yearDataList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYZLFXB(param, new MINRowBounds());
		
		int a = 0;
		for(Map<String, String> map :DDYZLFXBList){
			List<String> childList = Arrays.asList(new String[titleList.size()]);
			String dysc = map.get("dysc");
			String ljts = map.get("ljts");
			a++;
			childList.set(0, a+"");
			childList.set(1, map.get("xgsmc"));
			childList.set(2, map.get("yhgldw"));
			childList.set(3, map.get("xlmc"));
			childList.set(4, map.get("tqid"));
			childList.set(5, map.get("byqmc"));
			childList.set(6, map.get("yhid"));
			childList.set(7, dysc);
			childList.set(8, ljts);
			childList.set(9, "");
			childList.set(10, "");
			childList.set(11, "");
			childList.set(12, "");
			childList.set(13, "");
			childList.set(14, "");
			
			String yhid = String.valueOf(map.get("yhid"));
			
			int num = 0;
			
			// 最后一日时长
			String zuoriSc = "0";
			// 总时长,不含最后一日
			String scNozuori = "0";
			
			for (int i = 0; i < detailList.size(); i ++) {
				// 是同一用户
				if (detailList.get(i).getYhid().equals(yhid)) {
					num ++;
					
					String sjrq = detailList.get(i).getSjrq();
					
					// 首条数据判断是否消除
					if (num == 1) {
						int countJg = DateUtil.diffDate(sjrq, endTime);
						//查询是否低电压已消除
						if(countJg >= 7){
							if (CommonUtil.compare(dysc, "48") != -1) {
								childList.set(12, "是");
								childList.set(14, "是");
							} else if (CommonUtil.compare(dysc, "15") != -1) {
								childList.set(14, "是");
							}
						}else{
							childList.set(14, "");
						}
					}
					int index = DateUtil.diffDate(sjrq, endTime);
					childList.set(17 + index, detailList.get(i).getDysc());
					
					// 获取昨日时长
					if (index == 0) {
						zuoriSc = detailList.get(i).getDysc();
					} else {
						scNozuori = CommonUtil.add(scNozuori, detailList.get(i).getDysc());
					}
					// 移除已计算数据,减少循环次数
					detailList.remove(i);
					i --;
				// 排序顺序一致,用户编号不一样退出循环
				} else {
					if (num != 0) {
						break;
					}
				}
			}
			
			// 获取全年数
			for (int i = 0; i < yearDataList.size(); i ++) {
				if (yhid.equals(yearDataList.get(i).get("yhid"))) {
					childList.set(16, yearDataList.get(i).get("ljts"));
					yearDataList.remove(i);
					break;
				}
			}
			
			// 昨日有时长 且 昨日之前总时长小于48小时 且 昨日+之前时长大于48小时
			if (CommonUtil.compare(zuoriSc, "0") != 0 && CommonUtil.compare(scNozuori, "48") == -1 && CommonUtil.compare(CommonUtil.add(zuoriSc, scNozuori), "48") != -1) {
				childList.set(15, "是");
			} else {
				childList.set(15, "否");
			}
			
			resList.add(childList);
		}
		
		return resMap;
	}
	/**
	 * 低电压日报
	 * @param range
	 * @param reportTypeId
	 * @return
	 * @throws MINBusinessException
	 * @throws ParseException
	 */
	public List<List<String>> reportTypeDDYRB(String DdyDateRange, String yearChoose,String range, String reportTypeId) throws MINBusinessException, ParseException{
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		List<List<String>> resList = new ArrayList<List<String>>();
		Date beginTimeDate = DateUtil.parseDate(yearChoose + DdyDateRange.substring(0, 4), "yyyyMMdd");
		String beginTime = DateUtil.format(beginTimeDate, "yyyyMMdd");
		String endTime = yearChoose + DdyDateRange.substring(4, 8);
		// 开始月份是12,年份取下一年
		if ("12".equals(beginTime.substring(0, 2))) {
			endTime = CommonUtil.add(yearChoose, "1") + DdyDateRange.substring(4, 8);
		}
		Map<String, String> countMap = new HashMap<String, String>();
		countMap.put("xintai", "0");
		countMap.put("daiyue", "0");
		countMap.put("ningyang", "0");
		countMap.put("taishan", "0");
		countMap.put("dongping", "0");
		countMap.put("feicheng", "0");
		countMap.put("taishanjingqu", "0");
		countMap.put("gaoxin", "0");
		countMap.put("heji", "0");
		
		List<String> title = new ArrayList<String>();

		//标题
		List<String> childList0 = new ArrayList<String>();
		childList0.add("分类\\单位");
		childList0.add("岱岳");
		childList0.add("新泰");
		childList0.add("高新");
		childList0.add("泰山");
		childList0.add("宁阳");
		childList0.add("景区");
		childList0.add("东平");
		childList0.add("肥城");
		childList0.add("合计");
//		resList.add(childList0);
		//客户总数
		List<String> childList1 = new ArrayList<String>();
		childList1.add("客户总数");
		childList1.add(customerMap.get("daiyue"));
		childList1.add(customerMap.get("xintai"));
		childList1.add(customerMap.get("gaoxin"));
		childList1.add(customerMap.get("taishan"));
		childList1.add(customerMap.get("ningyang"));
		childList1.add(customerMap.get("jingqu"));
		childList1.add(customerMap.get("dongping"));
		childList1.add(customerMap.get("feicheng"));
		childList1.add(customerMap.get("heji"));
//		resList.add(childList1);
		//低电压客户数
		List<String> childList2 = new ArrayList<String>();
		childList2.add("低电压客户数");
		for(String name:childList0){
			if("分类\\单位".equals(name)){
				continue;
			}
			DwFileDetail03Example example03 = new DwFileDetail03Example();
			
			if("合计".equals(name)){
				example03.createCriteria().andSjrqBetween(beginTime, endTime);
			}else{
				example03.createCriteria().andSjrqBetween(beginTime, endTime).andXgsmcLike(name+"%");
			}
			
			List<DwFileDetail03> DateList = db.selectByExample(DwFileDetail03Mapper.class, example03);
			childList2.add(DateList.size()+"");
		}
//		resList.add(childList2);
		//低电压客户占比
		List<String> childList3 = new ArrayList<String>();
		childList3.add("低电压客户占比");
		for(int i=1;i<childList1.size();i++){
			//客户总数
			String count = childList1.get(i);
			//昨日客户数
			String dayCount = childList2.get(i);
			childList3.add(CommonUtil.multiply(CommonUtil.divide(dayCount, count, 4), "100", 2) + "%");
		}
//		resList.add(childList3);
		//昨日新增考核数
		List<String> childList4 = new ArrayList<String>();
		childList4.add("昨日新增考核户数");
		for(int i=1;i<childList0.size();i++){
			String endTimes = DateUtil.dateAddDay(range,-1);
			Map<String, Object> map = new HashMap<String, Object>();
			if(!"合计".equals(childList0.get(i))){
				map.put("area", childList0.get(i));
			}
			map.put("beginTime", beginTime);
			map.put("endTime", endTimes);
			List<Map<String, String>> fileList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYRB(map, new MINRowBounds());
			map.put("endTime", endTime);
			List<Map<String, String>> fileList1 = db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYRB(map, new MINRowBounds());
			childList4.add((fileList1.size()-fileList.size())+"");
		}
//		resList.add(childList4);
		//截至目前未治理完成户数
		List<String> childList5 = new ArrayList<String>();
		childList5.add("截至目前未治理完成户数");
		//用户id
		List<String> childList6 = new ArrayList<String>();
		for(int i=1;i<childList0.size();i++){
			int dayCount = DateUtil.diffDate(range,beginTime);
			String beginTimes = DateUtil.dateAddDay(range,-6);
			DwFileDetail03Example example = new DwFileDetail03Example();
			Map<String, Object> map = new HashMap<String, Object>();
			if(!"合计".equals(childList0.get(i))){
				map.put("area", childList0.get(i));
			}
			map.put("beginTime", beginTime);
			map.put("endTime", range);
			List<Map<String, String>> fileList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYRB(map, new MINRowBounds());
			if(dayCount<6){
				childList5.add(fileList.size()+"");
			}else{
				for(Map<String, String> maps:fileList){
					childList6.add(maps.get("yhid"));
				}
				example.createCriteria().andSjrqBetween(beginTimes, range).andYhidIn(childList6);
				List<DwFileDetail03> DateList = db.selectByExample(DwFileDetail03Mapper.class, example);
				childList5.add(DateList.size()+"");
			}
			
		}
		String content = "昨日新增受考核低电压客户"+childList4.get(childList4.size()-1)+"户，按单位分：";
		for(int i=1;i<childList0.size()-1;i++){
			content=content+childList0.get(i)+childList4.get(i)+"户，";
			if(childList0.size()-1==i){
				content=content+childList0.get(i)+childList4.get(i)+"户。";
			}
		}
		content = content+"昨日新增未治理完成客户_户，截至目前未治理完成"+childList5.get(childList5.size()-1)+"户，_户正在治理；_户治理后再次出现，其中_各_户；"
				+ "_户未开始治理，其中__户。其中全年累计受考核30天及以上且未治理完成的_户：为_户（户号：_）。";
		title.add(content);
		resList.add(title);
		resList.add(childList0);
		resList.add(childList1);
		resList.add(childList2);
		resList.add(childList3);
		resList.add(childList4);
		resList.add(childList5);
		return resList;
	}
	/**
	 * 过电压治理分析表
	 * @param range
	 * @param reportTypeId
	 * @return
	 * @throws MINBusinessException
	 * @throws ParseException
	 */
	public List<List<String>> reportTypeGDYZLFXB(String range, String reportTypeId) throws MINBusinessException, ParseException{
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		List<List<String>> resList = new ArrayList<List<String>>();
		List<String> titleList = new ArrayList<String>();
		titleList.add("序号");
		titleList.add("县公司名称");
		titleList.add("用户管理单位名称");
		titleList.add("线路名称");
		titleList.add("台区ID");
		titleList.add("变压器名称");
		titleList.add("用户编号");
		titleList.add("过电压时长");
		titleList.add("低电压主要原因（点选)");
		titleList.add("具体原因");
		titleList.add("治理措施");
		titleList.add("是否治理（点选）");
		titleList.add("治理完成时间");
		titleList.add("是否消除");
		range = range.replaceAll(" ", "");
		String[] rangeArray = range.split("-");
		String beginTime = rangeArray[0];
		String endTime = rangeArray[1];
		List<String> childLists = new ArrayList<String>();
		String content = "1.数据来源：智能化供电服务指挥系统；因系统数据滞后，统计时间为："
				+ CommonUtil.dateFormat(beginTime,"yyyy年MM月dd日")+"——"+CommonUtil.dateFormat(endTime,"yyyy年MM月dd日")+"；每日过电压时长24小时客户已标红，受考核用户已标黄（连续48小时过电压），需重点治理。2.反馈要求："
				+ "请各单位照实填写，按时反馈，具体原因请详细填写，现场治理完成的填写现场治理时间(格式为20200101)，未填写或填写不详细的一律列入考核，请知悉。"
				+ "3.过电压是否消除：以供电服务指挥系统数据为依据，连续7天未发生过电压视为过电压消除。";
		childLists.add(content);
		resList.add(childLists);
		int count = DateUtil.diffDate(beginTime, endTime);
		//日期集合
		List<String> dateList = new ArrayList<String>();
		for(int i=0;i<=count;i++){
			String beginDate = DateUtil.dateAddDay(endTime,-i);
			dateList.add(beginDate);
			beginDate = beginDate.substring(4,6)+"/"+beginDate.substring(6);
			titleList.add(beginDate+"过电压时长");
		}
		//子类数据
		resList.add(titleList);
		//查询累计天数以及累计时长
		Map<String, String> param = new HashMap<String, String>();
		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		List<Map<String, String>>  GDYZLFXBList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail04ByGDYZLFXB(param);
		int a = 0;
		for(Map<String, String> map :GDYZLFXBList){
			List<String> childList = new ArrayList<String>();
			String dysc = String.format("%.0f",map.get("gdysc"));
			a++;
			childList.add(a+"");
			childList.add(map.get("xgsmc"));
			childList.add(map.get("yhgldw"));
			childList.add(map.get("xlmc"));
			childList.add(map.get("tqid"));
			childList.add(map.get("byqmc"));
			childList.add(map.get("yhid"));
			childList.add(dysc);
			childList.add("");
			childList.add("");
			childList.add("");
			childList.add("");
			childList.add("");
			//查询该用户低电压明细
			DwFileDetail04Example example04 = new DwFileDetail04Example();
			example04.createCriteria().andYhidEqualTo(map.get("yhid")).andSjrqBetween(beginTime, endTime);
			example04.setOrderByClause("DFD4_SJRQ desc");
			List<DwFileDetail04> DateList = db.selectByExample(DwFileDetail04Mapper.class, example04);
			int countJg = DateUtil.diffDate(DateList.get(0).getSjrq(), endTime);
			//查询是否低电压已消除
			if(countJg>=7){
				childList.add("是");
			}else{
				childList.add("");
			}
			int bs=0;
			//循环加载低电压时长
			for(String date:dateList){
				int b = 0;
				for(DwFileDetail04 detail:DateList){
					if(date.equals(detail.getSjrq())){
						childList.add(detail.getGdysc());
						b=1;
						bs++;
						break;
					}
				}
				if(b == 0){
					if(bs<2){
						bs=0;
					}
					childList.add("");
				}
				
			}
			childList.add(bs+"");
			resList.add(childList);
		}
		
//		resList.add(DDYZLFXBList);
		
		return resList;
	}
	
	public Map<String, Object> reportType95598YB(String range) throws MINBusinessException, ParseException{
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		
		Map<String, Object> resMap = new HashMap<String, Object>();
		
		range = range.replaceAll(" ", "");
		String[] rangeArray = range.split("-");
		String beginTime = rangeArray[0];
		String endTime = rangeArray[1];
		
		// 类型列表
		List<String> typeList = new ArrayList<String>();
		
		// 统计表格
		List<List<String>> tongjiList = new ArrayList<List<String>>();
		List<String> titleList = new ArrayList<String>();
		titleList.add("类型");
		titleList.add("去年同月");
		titleList.add("上月");
		titleList.add("本月");
		titleList.add("同比");
		titleList.add("环比");
		tongjiList.add(titleList);
		
		Map<String, Object> param = new HashMap<String, Object>();
		
		String totalBenyueNum = "0";
		String totalShangyueNum = "0";
		String totalQunianNum = "0";
		
		// 本月数据
		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		// 类型统计数据
		List<Map<String, Object>> benyueTongjiMap = db.getMybatisMapper(ReportServiceMapper.class).selectDetail05ByType(param);
		// 区域统计数据
		List<Map<String, Object>> benyueByAreaMap = db.getMybatisMapper(ReportServiceMapper.class).selectDetail05ByArea(param);
		
		for (Map<String, Object> map : benyueTongjiMap) {
			String type = String.valueOf(map.get("type"));
			String num = String.valueOf(map.get("num"));
			// 不包含该类型,新增一个类型
			if (!typeList.contains(type)) {
				typeList.add(type);
				List<String> typeDataList = Arrays.asList(new String[6]);
				typeDataList.set(0,type);
				typeDataList.set(3, num);
				tongjiList.add(typeDataList);
			// 已包含该类型,原数据中增加数据
			} else {
				int index = typeList.indexOf(type);
				List<String> typeDataList = tongjiList.get(index + 1);
				typeDataList.set(3, num);
			}
			
			totalBenyueNum = CommonUtil.add(totalBenyueNum, num);
		}
		
		// 上月数据
		String lastBeginTime = DateUtil.dateAddMonth(beginTime, -1);
		String lastEndTime = DateUtil.dateAddMonth(endTime, -1);
		param.put("beginTime", lastBeginTime);
		param.put("endTime", lastEndTime);
		List<Map<String, Object>> shangyueTongjiMap = db.getMybatisMapper(ReportServiceMapper.class).selectDetail05ByType(param);
		// 区域统计数据
		List<Map<String, Object>> shangyueByAreaMap = db.getMybatisMapper(ReportServiceMapper.class).selectDetail05ByArea(param);
		for (Map<String, Object> map : shangyueTongjiMap) {
			String type = String.valueOf(map.get("type"));
			String num = String.valueOf(map.get("num"));
			// 不包含该类型,新增一个类型
			if (!typeList.contains(type)) {
				typeList.add(type);
				List<String> typeDataList = Arrays.asList(new String[6]);
				typeDataList.set(0,type);
				typeDataList.set(2, num);
				tongjiList.add(typeDataList);
			// 已包含该类型,原数据中增加数据
			} else {
				int index = typeList.indexOf(type);
				List<String> typeDataList = tongjiList.get(index + 1);
				typeDataList.set(2, num);
			}
			
			totalShangyueNum = CommonUtil.add(totalShangyueNum, num);
		}
		
		// 去年同期数据
		String qinianBeginTime = DateUtil.dateAddYear(beginTime, -1);
		String qunianEndTime = DateUtil.dateAddYear(endTime, -1);
		param.put("beginTime", qinianBeginTime);
		param.put("endTime", qunianEndTime);
		List<Map<String, Object>> qunianTongjiMap = db.getMybatisMapper(ReportServiceMapper.class).selectDetail05ByType(param);
		// 区域统计数据
		List<Map<String, Object>> qunianByAreaMap = db.getMybatisMapper(ReportServiceMapper.class).selectDetail05ByArea(param);
		for (Map<String, Object> map : qunianTongjiMap) {
			String type = String.valueOf(map.get("type"));
			String num = String.valueOf(map.get("num"));
			// 不包含该类型,新增一个类型
			if (!typeList.contains(type)) {
				typeList.add(type);
				List<String> typeDataList = Arrays.asList(new String[6]);
				typeDataList.set(0,type);
				typeDataList.set(1, num);
				tongjiList.add(typeDataList);
			// 已包含该类型,原数据中增加数据
			} else {
				int index = typeList.indexOf(type);
				List<String> typeDataList = tongjiList.get(index + 1);
				typeDataList.set(1, num);
			}
			
			totalQunianNum = CommonUtil.add(totalQunianNum, num);
		}
		
		// 合计
		List<String> hejiList = new ArrayList<String>();
		hejiList.add("总计");
		hejiList.add(totalQunianNum);
		hejiList.add(totalShangyueNum);
		hejiList.add(totalBenyueNum);
		hejiList.add("");
		hejiList.add("");
		tongjiList.add(hejiList);
		
		// 计算同比环比
		for (int i = 1; i < tongjiList.size(); i ++) {
			List<String> childList = tongjiList.get(i);
			String qunianNum = CommonUtil.isEmpty(childList.get(1))?"0":childList.get(1);
			String shangyueNum = CommonUtil.isEmpty(childList.get(2))?"0":childList.get(2);
			String benyueNum = CommonUtil.isEmpty(childList.get(3))?"0":childList.get(3);
			// 本月有数据
			if (CommonUtil.compare(benyueNum, "0") != 0) {
				// 去年有数据
				if (CommonUtil.compare(qunianNum, "0") != 0) {
					String tongbi = CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(benyueNum, qunianNum), qunianNum, 4), "100", 2) + "%";
					childList.set(4, tongbi);
				}
				// 上月有数据
				if (CommonUtil.compare(shangyueNum, "0") != 0) {
					String huanbi = CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(benyueNum, shangyueNum), shangyueNum, 4), "100", 2) + "%";
					childList.set(5, huanbi);
				}
			}
		}
		
		resMap.put("tongjiList", tongjiList);
		
		// 详细数据
		param.put("benyueBeginTime", beginTime);
		param.put("benyueEndTime", endTime);
		param.put("lastBeginTime", lastBeginTime);
		param.put("lastEndTime", lastEndTime);
		param.put("qinianBeginTime", qinianBeginTime);
		param.put("qunianEndTime", qunianEndTime);
		List<String> areaList = db.getMybatisMapper(ReportServiceMapper.class).selectDetail05GetArea(param);
		
		List<List<List<String>>> areaDetailList = new ArrayList<List<List<String>>>();
		resMap.put("areaDetailList", areaDetailList);
		for (String type : typeList) {
			List<List<String>> benyueDetailList = new ArrayList<List<String>>();
			List<String> benyueTitleList = new ArrayList<String>();
			benyueTitleList.add(beginTime + "-" + endTime);
			benyueTitleList.add("业务类型");
			benyueTitleList.add("一级分类");
			benyueTitleList.add("二级分类");
			benyueTitleList.add("业务子类");
			benyueDetailList.add(benyueTitleList);
			List<List<String>> shangyueDetailList = new ArrayList<List<String>>();
			List<String> shangyueTitleList = new ArrayList<String>();
			shangyueTitleList.add(lastBeginTime + "-" + lastEndTime);
			shangyueTitleList.add("业务类型");
			shangyueTitleList.add("一级分类");
			shangyueTitleList.add("二级分类");
			shangyueTitleList.add("业务子类");
			shangyueDetailList.add(shangyueTitleList);
			List<List<String>> qunianDetailList = new ArrayList<List<String>>();
			List<String> qunianTitleList = new ArrayList<String>();
			qunianTitleList.add(qinianBeginTime + "-" + qunianEndTime);
			qunianTitleList.add("业务类型");
			qunianTitleList.add("一级分类");
			qunianTitleList.add("二级分类");
			qunianTitleList.add("业务子类");
			qunianDetailList.add(qunianTitleList);
			// 区域数据
			for (String area : areaList) {
				benyueTitleList.add(area);
				shangyueTitleList.add(area);
				qunianTitleList.add(area);
			}
			benyueTitleList.add("总计");
			shangyueTitleList.add("总计");
			qunianTitleList.add("总计");
			
			areaDetailList.add(benyueDetailList);
			areaDetailList.add(shangyueDetailList);
			areaDetailList.add(qunianDetailList);
			// 报表详情生成
			until95598(benyueByAreaMap, type, benyueDetailList);
			until95598(shangyueByAreaMap, type, shangyueDetailList);
			until95598(qunianByAreaMap, type, qunianDetailList);
		}
		
		// 计算总计
		for (int i = 0; i < areaDetailList.size(); i ++) {
			List<List<String>> excelList = areaDetailList.get(i);
			List<String> zongji = new ArrayList<String>();
			zongji.add("总计");
			zongji.add("");
			zongji.add("");
			zongji.add("");
			zongji.add("");
			
			// 合计汇总
			String[] zongjiNum = new String[excelList.get(0).size()- 5];
			
			String totalNum = "0";
			for (int j = 1; j < excelList.size(); j ++) {
				
				List<String> childList = excelList.get(j);
				int index = 0;
				String zongjiType = "0";
				for (int k = 5; k < childList.size(); k ++) {
					zongjiType = CommonUtil.add(zongjiType, childList.get(k));
					zongjiNum[index] = CommonUtil.add(zongjiNum[index], childList.get(k));
					index ++;
				}
				childList.set(childList.size() - 1, zongjiType);
				totalNum = CommonUtil.add(totalNum, zongjiType);
			}
			
			zongjiNum[zongjiNum.length - 1] = totalNum;
			
			for (int j = 0; j < zongjiNum.length; j++) {
				zongji.add(zongjiNum[j]);
			}
			
			excelList.add(zongji);
		}
		
		return resMap;
	}
	
	/**
	 * 报表数据处理
	 * @param areaMap
	 * @param type
	 * @param detailList
	 */
	public void until95598(List<Map<String, Object>> areaMap, String type, List<List<String>> detailList) {
		for (int i = 0; i < areaMap.size(); i ++) {
			Map<String, Object> map = areaMap.get(i);
			String dataType = String.valueOf(map.get("type"));
			// 同一类型的数据
			if (dataType.equals(type)) {
				// 供电单位
				String gddw = String.valueOf(map.get("gddw"));
				// 数量
				String num = String.valueOf(map.get("num"));
				// 业务类型
				String ywlx = String.valueOf(map.get("ywlx"));
				// 一级分类
				String yjfl = String.valueOf(map.get("yjfl"));
				// 二级分类
				String ejfl = String.valueOf(map.get("ejfl"));
				// 业务子类
				String ywzl = String.valueOf(map.get("ywzl"));
				
				// 不是第一条数据
				if (i != 0) {
					// 下一条数据
					Map<String, Object> lastMap = areaMap.get(i - 1);
					// 业务类型
					String lastYwlx = String.valueOf(lastMap.get("ywlx"));
					// 一级分类
					String lastYjfl = String.valueOf(lastMap.get("yjfl"));
					// 二级分类
					String lastEjfl = String.valueOf(lastMap.get("ejfl"));
					// 业务子类
					String lastYwzl = String.valueOf(lastMap.get("ywzl"));
					// 业务类型等数据相同,是同一行数据
					if (lastYwlx.equals(ywlx) && lastYjfl.equals(yjfl) && lastEjfl.equals(ejfl) && lastYwzl.equals(ywzl)) {
						// 获取区域位置
						int index = detailList.get(0).indexOf(gddw);
						// 获取最后一条数据
						List<String> childList = detailList.get(detailList.size() - 1);
						childList.set(index, num);
					// 数据不同,新增一条数据
					} else {
						List<String> childList = Arrays.asList(new String[detailList.get(0).size()]);
						childList.set(0, dataType);
						childList.set(1, ywlx);
						childList.set(2, yjfl);
						childList.set(3, ejfl);
						childList.set(4, ywzl);
						// 获取区域位置
						int index = detailList.get(0).indexOf(gddw);
						childList.set(index, num);
						detailList.add(childList);
					}
				} else {
					List<String> childList = Arrays.asList(new String[detailList.get(0).size()]);
					childList.set(0, dataType);
					childList.set(1, ywlx);
					childList.set(2, yjfl);
					childList.set(3, ejfl);
					childList.set(4, ywzl);
					// 获取区域位置
					int index = detailList.get(0).indexOf(gddw);
					childList.set(index, num);
					detailList.add(childList);
				}
			}
		}
	}
	
	private List<List<String>> reportTypeDDYWZL(String ddyFxbId) throws MINBusinessException, ParseException, NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		
		// 报告信息
		DwReportInf reportInf = db.selectByPrimaryKey(DwReportInfMapper.class, ddyFxbId);
		String range = reportInf.getDayInterval();
    	String beginTime = range.split("-")[0];
    	String endTime = range.split("-")[1];
		
		List<List<String>> resList = new ArrayList<List<String>>();
		
    	List<String> titleList = new ArrayList<String>();
		titleList.add("序号");
		titleList.add("县公司名称");
		titleList.add("用户管理单位名称");
		titleList.add("线路名称");
		titleList.add("台区ID");
		titleList.add("变压器名称");
		titleList.add("用户编号");
		titleList.add("低电压时长");
		titleList.add("累计天数");
		titleList.add("低电压主要原因（点选)");
		titleList.add("具体原因");
		titleList.add("治理措施");
		titleList.add("是否治理（点选）");
		titleList.add("治理完成时间");
		titleList.add("是否消除");
		
    	int count = DateUtil.diffDate(beginTime, endTime);
		//日期集合
		List<String> dateList = new ArrayList<String>();
		for(int i=0;i<=count;i++){
			String beginDate = DateUtil.dateAddDay(endTime,-i);
			dateList.add(beginDate);
			beginDate = beginDate.substring(4,6)+"/"+beginDate.substring(6);
			titleList.add(beginDate+"低电压时长");
		}
		resList.add(titleList);
		
		DwDdyFxbExample ddyFxbExample = new DwDdyFxbExample();
		ddyFxbExample.createCriteria().andReportIdEqualTo(ddyFxbId).andSfxcNotEqualTo("是").andDdysjGreaterThanOrEqualTo(48);
		ddyFxbExample.setOrderByClause("DDF_ID");
		List<DwDdyFxb> ddyFxbList = db.selectByExample(DwDdyFxbMapper.class, ddyFxbExample);
		
		List<String> fxbIdList = CommonUtil.getIdFromList(ddyFxbList, "id");
		if (fxbIdList.size() == 0) {
			return resList;
		}
		
		DwDdyFxbDetailExample ddyFxbDetailExample = new DwDdyFxbDetailExample();
		ddyFxbDetailExample.createCriteria().andFxbIdIn(fxbIdList);
		ddyFxbDetailExample.setOrderByClause("DDFD_FXB_ID");
		List<DwDdyFxbDetail> detailList = db.selectByExample(DwDdyFxbDetailMapper.class, ddyFxbDetailExample);
		
		for (DwDdyFxb ddyFxb : ddyFxbList) {
			List<String> childList = Arrays.asList(new String[titleList.size()]);
			childList.set(0, ddyFxb.getXh());
			childList.set(1, ddyFxb.getXgsmc());
			childList.set(2, ddyFxb.getYhgldwmc());
			childList.set(3, ddyFxb.getXlmc());
			childList.set(4, ddyFxb.getTqid());
			childList.set(5, ddyFxb.getByqmc());
			childList.set(6, ddyFxb.getYhbh());
			childList.set(7, String.valueOf(ddyFxb.getDdysj()));
			childList.set(8, String.valueOf(ddyFxb.getLjts()));
			childList.set(9, ddyFxb.getDdyzymc());
			childList.set(10, ddyFxb.getJtyy());
			childList.set(11, ddyFxb.getZlcs());
			childList.set(12, ddyFxb.getSfzl());
			childList.set(13, ddyFxb.getZlwcsj());
			childList.set(14, ddyFxb.getSfxc());
			
			String fxbId = ddyFxb.getId();
			for (int i = 0; i < detailList.size(); i++) {
				// 分析表id一致
				if (fxbId.equals(detailList.get(i).getFxbId())) {
					String sjrq = detailList.get(i).getDate();
					int index = DateUtil.diffDate(sjrq, endTime);
					childList.set(15 + index, detailList.get(i).getSc());
					detailList.remove(i);
					i --;
				} else {
					break;
				}
			}
			resList.add(childList);
		}
		
		return resList;
	}
	
	private List<List<String>> reportTypeDDYZRXZ(String ddyFxbId) throws MINBusinessException, ParseException, NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		
		// 报告信息
		DwReportInf reportInf = db.selectByPrimaryKey(DwReportInfMapper.class, ddyFxbId);
		String range = reportInf.getDayInterval();
		String beginTime = range.split("-")[0];
		String endTime = range.split("-")[1];
		
		List<List<String>> resList = new ArrayList<List<String>>();
		
		List<String> titleList = new ArrayList<String>();
		titleList.add("序号");
		titleList.add("县公司名称");
		titleList.add("用户管理单位名称");
		titleList.add("线路名称");
		titleList.add("台区ID");
		titleList.add("变压器名称");
		titleList.add("用户编号");
		titleList.add("低电压时长");
		titleList.add("累计天数");
		titleList.add("低电压主要原因（点选)");
		titleList.add("具体原因");
		titleList.add("治理措施");
		titleList.add("是否治理（点选）");
		titleList.add("治理完成时间");
		titleList.add("是否消除");
		
		int count = DateUtil.diffDate(beginTime, endTime);
		//日期集合
		List<String> dateList = new ArrayList<String>();
		for(int i=0;i<=count;i++){
			String beginDate = DateUtil.dateAddDay(endTime,-i);
			dateList.add(beginDate);
			beginDate = beginDate.substring(4,6)+"/"+beginDate.substring(6);
			titleList.add(beginDate+"低电压时长");
		}
		resList.add(titleList);
		
		DwDdyFxbExample ddyFxbExample = new DwDdyFxbExample();
		ddyFxbExample.createCriteria().andReportIdEqualTo(ddyFxbId).andZrxzEqualTo("是");
		ddyFxbExample.setOrderByClause("DDF_ID");
		List<DwDdyFxb> ddyFxbList = db.selectByExample(DwDdyFxbMapper.class, ddyFxbExample);
		
		List<String> fxbIdList = CommonUtil.getIdFromList(ddyFxbList, "id");
		if (fxbIdList.size() == 0) {
			return resList;
		}
		
		DwDdyFxbDetailExample ddyFxbDetailExample = new DwDdyFxbDetailExample();
		ddyFxbDetailExample.createCriteria().andFxbIdIn(fxbIdList);
		ddyFxbDetailExample.setOrderByClause("DDFD_FXB_ID");
		List<DwDdyFxbDetail> detailList = db.selectByExample(DwDdyFxbDetailMapper.class, ddyFxbDetailExample);
		
		for (DwDdyFxb ddyFxb : ddyFxbList) {
			List<String> childList = Arrays.asList(new String[titleList.size()]);
			childList.set(0, ddyFxb.getXh());
			childList.set(1, ddyFxb.getXgsmc());
			childList.set(2, ddyFxb.getYhgldwmc());
			childList.set(3, ddyFxb.getXlmc());
			childList.set(4, ddyFxb.getTqid());
			childList.set(5, ddyFxb.getByqmc());
			childList.set(6, ddyFxb.getYhbh());
			childList.set(7, String.valueOf(ddyFxb.getDdysj()));
			childList.set(8, String.valueOf(ddyFxb.getLjts()));
			childList.set(9, ddyFxb.getDdyzymc());
			childList.set(10, ddyFxb.getJtyy());
			childList.set(11, ddyFxb.getZlcs());
			childList.set(12, ddyFxb.getSfzl());
			childList.set(13, ddyFxb.getZlwcsj());
			childList.set(14, ddyFxb.getSfxc());
			
			String fxbId = ddyFxb.getId();
			for (int i = 0; i < detailList.size(); i++) {
				// 分析表id一致
				if (fxbId.equals(detailList.get(i).getFxbId())) {
					String sjrq = detailList.get(i).getDate();
					int index = DateUtil.diffDate(sjrq, endTime);
					childList.set(15 + index, detailList.get(i).getSc());
					detailList.remove(i);
					i --;
				} else {
					break;
				}
			}
			resList.add(childList);
		}
		
		return resList;
	}
	
	/**
	 * 低电压周报
	 * @param ddyFxbId
	 * @param range
	 * @return
	 * @throws MINBusinessException
	 * @throws ParseException
	 * @throws NoSuchMethodException
	 * @throws SecurityException
	 * @throws IllegalAccessException
	 * @throws IllegalArgumentException
	 * @throws InvocationTargetException
	 */
	public Map<String, Object> reportTypeDDYZB(String ddyFxbId, String range) throws MINBusinessException, ParseException, NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException{
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		
		Map<String, Object> resMap = new HashMap<String, Object>();
		
		// 本周开始时间和结束时间
		range = range.replaceAll(" ", "");
		String weekBegin = range.split("-")[0];
		String weekEnd = range.split("-")[1];
		
		DwReportInf reportInf = db.selectByPrimaryKey(DwReportInfMapper.class, ddyFxbId);
		// 当月开始时间和结束时间
		String monthBegin = reportInf.getDayInterval().split("-")[0];
		
		// 全年开始时间和结束时间
		String yearBegin = CommonUtil.subtract(monthBegin.substring(0,  4), "1") + "1226";
		// 
		if ("12".equals(monthBegin.substring(4,6))) {
			yearBegin = monthBegin.substring(0,  4) + "1226";
		}
		
		// 全年累计考核数
		Map<String, Object> param = new HashMap<String, Object>();
		param.put("reportId", ddyFxbId);
		
		param.put("beginTime", yearBegin);
		param.put("endTime", weekEnd);
		List<Map<String, String>> yearTotal = db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYRB(param, new MINRowBounds());
		
		// 本月之前全年考核数
		param.put("beginTime", yearBegin);
		param.put("endTime", DateUtil.dateAddDay(monthBegin, -1));
		List<Map<String, String>> yearTotalNoBenyue = db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYRB(param, new MINRowBounds());
		
		// 本周之前全年考核数
		param.put("beginTime", yearBegin);
		param.put("endTime", DateUtil.dateAddDay(weekBegin, -1));
		List<Map<String, String>> yearTotalNoBenzhou = db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYRB(param, new MINRowBounds());
		
		// 本月新增考核数
		int benyueXZ = yearTotal.size() - yearTotalNoBenyue.size();
		// 本周新增考核数
		int benzhouXZ = yearTotal.size() - yearTotalNoBenzhou.size();
		
		// 本周之前用户编号集合
		List<String> bzzqYhbhList = CommonUtil.getIdFromList(yearTotalNoBenzhou, "yhid");
		
		// 本周新增明细
		List<Map<String, String>> bzzxmxDescList = new ArrayList<Map<String, String>>();
		for (int i = 0; i < yearTotal.size(); i ++) {
			String yhbh = yearTotal.get(i).get("yhid");
			String xgsmc = yearTotal.get(i).get("xgsmc");
			// 本周新增数据
			if (!bzzqYhbhList.contains(yhbh)) {
				boolean isContain = false;
				for (int j = 0; j < bzzxmxDescList.size(); j ++) {
					String name = bzzxmxDescList.get(j).get("name");
					String num = bzzxmxDescList.get(j).get("num");
					// 数量+1
					if (xgsmc.contains(name)) {
						isContain = true;
						bzzxmxDescList.get(j).put("num", CommonUtil.add(num, "1"));
					}
				}
				if (!isContain) {
					Map<String, String> descMap = new HashMap<String, String>();
					if (xgsmc.contains("新泰")) {
						descMap.put("name", "新泰");
					} else if (xgsmc.contains("高新")) {
						descMap.put("name", "高新");
					} else if (xgsmc.contains("岱岳")) {
						descMap.put("name", "岱岳");
					} else if (xgsmc.contains("泰山")) {
						descMap.put("name", "泰山");
					} else if (xgsmc.contains("宁阳")) {
						descMap.put("name", "宁阳");
					} else if (xgsmc.contains("东平")) {
						descMap.put("name", "东平");
					} else if (xgsmc.contains("景区")) {
						descMap.put("name", "景区");
					} else if (xgsmc.contains("肥城")) {
						descMap.put("name", "肥城");
					} else {
						continue;
					}
					descMap.put("num", "1");
					bzzxmxDescList.add(descMap);
				}
			}
		}
		String danweiDesc = "";
		
		for (int j = 0; j < bzzxmxDescList.size(); j ++) {
			String name = bzzxmxDescList.get(j).get("name");
			String num = bzzxmxDescList.get(j).get("num");
			if (j == bzzxmxDescList.size() - 1) {
				danweiDesc += (name + num + "户。");
			} else {
				danweiDesc += (name + num + "户，");
			}
		}
		
		// 正在治理用户数
		String zzliNum = db.getMybatisMapper(ReportServiceMapper.class).selectDdyFxbZZZL(param).get("num");
		// 治理后再次出现
		List<Map<String, String>> zlhzccxList = db.getMybatisMapper(ReportServiceMapper.class).selectDdyFxbZlhzccx(param);
		String zlhzccxNum = "0";
		String zlhzccxDesc = "";
		for (int i = 0; i < zlhzccxList.size(); i ++) {
			Map<String, String> map = zlhzccxList.get(i);
			String area = map.get("area").substring(0, 2);
			String num = map.get("num");
			if ("新泰".equals(area)) {
			} else if ("高新".equals(area)) {
			} else if ("岱岳".equals(area)) {
			} else if ("泰山".equals(area)) {
			} else if ("宁阳".equals(area)) {
			} else if ("东平".equals(area)) {
			} else if ("景区".equals(area)) {
			} else if ("肥城".equals(area)) {
			} else {
				continue;
			}
			zlhzccxNum = CommonUtil.add(zlhzccxNum, num);
			// 最后一条数据
			if (i == zlhzccxList.size() - 1) {
				zlhzccxDesc += area + num + "户；";
			} else {
				zlhzccxDesc += area + num + "户，";
			}
		}
		// 未开始治理用户区域分组
		List<Map<String, String>> wkszlList = db.getMybatisMapper(ReportServiceMapper.class).selectDdyFxbWKSZL(param);
		String wkszlNum = "0";
		String wkszlDesc = "";
		for (int i = 0; i < wkszlList.size(); i ++) {
			Map<String, String> map = wkszlList.get(i);
			String area = map.get("area").substring(0, 2);
			String num = map.get("num");
			if ("新泰".equals(area)) {
			} else if ("高新".equals(area)) {
			} else if ("岱岳".equals(area)) {
			} else if ("泰山".equals(area)) {
			} else if ("宁阳".equals(area)) {
			} else if ("东平".equals(area)) {
			} else if ("景区".equals(area)) {
			} else if ("肥城".equals(area)) {
			} else {
				continue;
			}
			wkszlNum = CommonUtil.add(wkszlNum, num);
			// 最后一条数据
			if (i == wkszlList.size() - 1) {
				wkszlDesc += area + num + "户。";
			} else {
				wkszlDesc += area + num + "户，";
			}
		}
		
		String wzlwcNum = CommonUtil.add(CommonUtil.add(zzliNum, zlhzccxNum), wkszlNum);
		String desc = "本月新增受考核低电压客户${benyueXZ}户，其中本周新增${benzhouXZ}户，按单位分${danweiDesc}截至目前未治理完成${wzlwcNum}户，${zzliNum}户正在治理；${zlhzccxNum}户治理后再次出现，${zlhzccxDesc}${wkszlNum}户未开始治理，${wkszlDesc}";
		
		Map<String, String> reportMap = new HashMap<String, String>();
		reportMap.put("benyueXZ", String.valueOf(benyueXZ));
		reportMap.put("benzhouXZ", String.valueOf(benzhouXZ));
		reportMap.put("danweiDesc", danweiDesc);
		reportMap.put("wzlwcNum", wzlwcNum);
		reportMap.put("zzliNum", zzliNum);
		reportMap.put("zlhzccxNum", zlhzccxNum);
		reportMap.put("zlhzccxDesc", zlhzccxDesc);
		reportMap.put("wkszlNum", wkszlNum);
		reportMap.put("wkszlDesc", wkszlDesc);
		resMap.put("reportMap", reportMap);
		resMap.put("descStr", desc);
		
		List<List<String>> excelList = new ArrayList<List<String>>();
		
		// 表头
		List<String> titleList = new ArrayList<String>();
		titleList.add("分类\\单位");
		titleList.add("新泰");
		titleList.add("高新");
		titleList.add("岱岳");
		titleList.add("泰山");
		titleList.add("宁阳");
		titleList.add("东平");
		titleList.add("景区");
		titleList.add("肥城");
		titleList.add("合计");
		excelList.add(titleList);
		
		// 合计栏
		List<String> child0 = new ArrayList<String>();
		child0.add("管理客户总数");
		child0.add(customerMap.get("xintai"));
		child0.add(customerMap.get("gaoxin"));
		child0.add(customerMap.get("daiyue"));
		child0.add(customerMap.get("taishan"));
		child0.add(customerMap.get("ningyang"));
		child0.add(customerMap.get("dongping"));
		child0.add(customerMap.get("jingqu"));
		child0.add(customerMap.get("feicheng"));
		child0.add(customerMap.get("heji"));
		excelList.add(child0);
		
		// 本月之前用户编号集合
		List<String> byzqYhbhList = CommonUtil.getIdFromList(yearTotalNoBenyue, "yhid");
		
		// 本月新增明细
		List<Map<String, String>> byzxmxDescList = new ArrayList<Map<String, String>>();
		Map<String, String> byzxTaian = new HashMap<String, String>();
		byzxTaian.put("name", "新泰");
		byzxTaian.put("num", "0");
		byzxmxDescList.add(byzxTaian);
		Map<String, String> byzxGaoxin = new HashMap<String, String>();
		byzxGaoxin.put("name", "高新");
		byzxGaoxin.put("num", "0");
		byzxmxDescList.add(byzxGaoxin);
		Map<String, String> byzxDaiyue = new HashMap<String, String>();
		byzxDaiyue.put("name", "岱岳");
		byzxDaiyue.put("num", "0");
		byzxmxDescList.add(byzxDaiyue);
		Map<String, String> byzxTaishan = new HashMap<String, String>();
		byzxTaishan.put("name", "泰山");
		byzxTaishan.put("num", "0");
		byzxmxDescList.add(byzxTaishan);
		Map<String, String> byzxNingyang = new HashMap<String, String>();
		byzxNingyang.put("name", "宁阳");
		byzxNingyang.put("num", "0");
		byzxmxDescList.add(byzxNingyang);
		Map<String, String> byzxDongping = new HashMap<String, String>();
		byzxDongping.put("name", "东平");
		byzxDongping.put("num", "0");
		byzxmxDescList.add(byzxDongping);
		Map<String, String> byzxJingqu = new HashMap<String, String>();
		byzxJingqu.put("name", "景区");
		byzxJingqu.put("num", "0");
		byzxmxDescList.add(byzxJingqu);
		Map<String, String> byzxFeicheng = new HashMap<String, String>();
		byzxFeicheng.put("name", "肥城");
		byzxFeicheng.put("num", "0");
		byzxmxDescList.add(byzxFeicheng);

		for (int i = 0; i < yearTotal.size(); i ++) {
			String yhbh = yearTotal.get(i).get("yhid");
			String xgsmc = yearTotal.get(i).get("xgsmc");
			// 本月新增数据
			if (!byzqYhbhList.contains(yhbh)) {
				
				for (int j = 0; j < byzxmxDescList.size(); j ++) {
					String name = byzxmxDescList.get(j).get("name");
					String num = byzxmxDescList.get(j).get("num");
					// 数量+1
					if (xgsmc.contains(name)) {
						byzxmxDescList.get(j).put("num", CommonUtil.add(num, "1"));
					} 
				}
			}
		}
		
		List<String> child1 = new ArrayList<String>();
		child1.add("本月新增受考核客户数");
		for (int j = 0; j < byzxmxDescList.size(); j ++) {
			String num = byzxmxDescList.get(j).get("num");
			child1.add(num);
		}
		child1.add(String.valueOf(benyueXZ));
		excelList.add(child1);
		
		// 全年数据
		List<Map<String, String>> quanianDetailList = new ArrayList<Map<String, String>>();
		Map<String, String> quannianTaian = new HashMap<String, String>();
		quannianTaian.put("name", "新泰");
		quannianTaian.put("num", "0");
		quanianDetailList.add(quannianTaian);
		Map<String, String> quannianGaoxin = new HashMap<String, String>();
		quannianGaoxin.put("name", "高新");
		quannianGaoxin.put("num", "0");
		quanianDetailList.add(quannianGaoxin);
		Map<String, String> quannianDaiyue = new HashMap<String, String>();
		quannianDaiyue.put("name", "岱岳");
		quannianDaiyue.put("num", "0");
		quanianDetailList.add(quannianDaiyue);
		Map<String, String> quannianTaishan = new HashMap<String, String>();
		quannianTaishan.put("name", "泰山");
		quannianTaishan.put("num", "0");
		quanianDetailList.add(quannianTaishan);
		Map<String, String> quannianNingyang = new HashMap<String, String>();
		quannianNingyang.put("name", "宁阳");
		quannianNingyang.put("num", "0");
		quanianDetailList.add(quannianNingyang);
		Map<String, String> quannianDongping = new HashMap<String, String>();
		quannianDongping.put("name", "东平");
		quannianDongping.put("num", "0");
		quanianDetailList.add(quannianDongping);
		Map<String, String> quannianJingqu = new HashMap<String, String>();
		quannianJingqu.put("name", "景区");
		quannianJingqu.put("num", "0");
		quanianDetailList.add(quannianJingqu);
		Map<String, String> quannianFeicheng = new HashMap<String, String>();
		quannianFeicheng.put("name", "肥城");
		quannianFeicheng.put("num", "0");
		quanianDetailList.add(quannianFeicheng);
		
		for (int i = 0; i < yearTotal.size(); i ++) {
			String xgsmc = yearTotal.get(i).get("xgsmc");
			for (int j = 0; j < quanianDetailList.size(); j ++) {
				String name = quanianDetailList.get(j).get("name");
				String num = quanianDetailList.get(j).get("num");
				// 数量+1
				if (xgsmc.contains(name)) {
					quanianDetailList.get(j).put("num", CommonUtil.add(num, "1"));
				} 
			}
		}
		
		List<String> child2 = new ArrayList<String>();
		child2.add("全年累计受考核客户数");
		for (int j = 0; j < quanianDetailList.size(); j ++) {
			String num = quanianDetailList.get(j).get("num");
			child2.add(num);
		}
		child2.add(String.valueOf(yearTotal.size()));
		excelList.add(child2);
		
		resMap.put("excelList", excelList);
		
		return resMap;
	}
	
	/**
	 * 低电压超30天
	 * @param ddyFxbId
	 * @return
	 * @throws MINBusinessException
	 * @throws ParseException
	 * @throws NoSuchMethodException
	 * @throws SecurityException
	 * @throws IllegalAccessException
	 * @throws IllegalArgumentException
	 * @throws InvocationTargetException
	 */
	private List<List<String>> reportTypeDDY30T(String ddyFxbId) throws MINBusinessException, ParseException, NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		
		// 报告信息
		DwReportInf reportInf = db.selectByPrimaryKey(DwReportInfMapper.class, ddyFxbId);
		String range = reportInf.getDayInterval();
    	String beginTime = range.split("-")[0];
    	String endTime = range.split("-")[1];
		
		List<List<String>> resList = new ArrayList<List<String>>();
		
    	List<String> titleList = new ArrayList<String>();
		titleList.add("序号");
		titleList.add("县公司名称");
		titleList.add("用户管理单位名称");
		titleList.add("线路名称");
		titleList.add("台区ID");
		titleList.add("变压器名称");
		titleList.add("用户编号");
		titleList.add("低电压时长");
		titleList.add("累计天数");
		titleList.add("低电压主要原因（点选)");
		titleList.add("具体原因");
		titleList.add("治理措施");
		titleList.add("是否治理（点选）");
		titleList.add("治理完成时间");
		titleList.add("是否消除");
		titleList.add("全年累计天数");
		
    	int count = DateUtil.diffDate(beginTime, endTime);
		//日期集合
		List<String> dateList = new ArrayList<String>();
		for(int i=0;i<=count;i++){
			String beginDate = DateUtil.dateAddDay(endTime,-i);
			dateList.add(beginDate);
			beginDate = beginDate.substring(4,6)+"/"+beginDate.substring(6);
			titleList.add(beginDate+"低电压时长");
		}
		resList.add(titleList);
		
		DwDdyFxbExample ddyFxbExample = new DwDdyFxbExample();
		ddyFxbExample.createCriteria().andReportIdEqualTo(ddyFxbId).andSfxcNotEqualTo("是").andDdysjGreaterThanOrEqualTo(48).andQnljtsGreaterThan(30);
		ddyFxbExample.setOrderByClause("DDF_ID");
		List<DwDdyFxb> ddyFxbList = db.selectByExample(DwDdyFxbMapper.class, ddyFxbExample);
		
		List<String> fxbIdList = CommonUtil.getIdFromList(ddyFxbList, "id");
		if (fxbIdList.size() == 0) {
			return resList;
		}
		
		DwDdyFxbDetailExample ddyFxbDetailExample = new DwDdyFxbDetailExample();
		ddyFxbDetailExample.createCriteria().andFxbIdIn(fxbIdList);
		ddyFxbDetailExample.setOrderByClause("DDFD_FXB_ID");
		List<DwDdyFxbDetail> detailList = db.selectByExample(DwDdyFxbDetailMapper.class, ddyFxbDetailExample);
		
		for (DwDdyFxb ddyFxb : ddyFxbList) {
			List<String> childList = Arrays.asList(new String[titleList.size()]);
			childList.set(0, ddyFxb.getXh());
			childList.set(1, ddyFxb.getXgsmc());
			childList.set(2, ddyFxb.getYhgldwmc());
			childList.set(3, ddyFxb.getXlmc());
			childList.set(4, ddyFxb.getTqid());
			childList.set(5, ddyFxb.getByqmc());
			childList.set(6, ddyFxb.getYhbh());
			childList.set(7, String.valueOf(ddyFxb.getDdysj()));
			childList.set(8, String.valueOf(ddyFxb.getLjts()));
			childList.set(9, ddyFxb.getDdyzymc());
			childList.set(10, ddyFxb.getJtyy());
			childList.set(11, ddyFxb.getZlcs());
			childList.set(12, ddyFxb.getSfzl());
			childList.set(13, ddyFxb.getZlwcsj());
			childList.set(14, ddyFxb.getSfxc());
			childList.set(15, String.valueOf(ddyFxb.getQnljts()));
			
			String fxbId = ddyFxb.getId();
			for (int i = 0; i < detailList.size(); i++) {
				// 分析表id一致
				if (fxbId.equals(detailList.get(i).getFxbId())) {
					String sjrq = detailList.get(i).getDate();
					int index = DateUtil.diffDate(sjrq, endTime);
					childList.set(16 + index, detailList.get(i).getSc());
					detailList.remove(i);
					i --;
				} else {
					break;
				}
			}
			resList.add(childList);
		}
		
		return resList;
	}
	
	/**
	 * 
	 * @param ddyFxbId
	 * @return
	 * @throws MINBusinessException
	 * @throws ParseException
	 * @throws NoSuchMethodException
	 * @throws SecurityException
	 * @throws IllegalAccessException
	 * @throws IllegalArgumentException
	 * @throws InvocationTargetException
	 */
	private Map<String, Object> reportTypeDDYYB(String ddyFxbId) throws MINBusinessException, ParseException, NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		
		Map<String, Object> resMap = new HashMap<String, Object>();
		// 报告信息
		DwReportInf reportInf = db.selectByPrimaryKey(DwReportInfMapper.class, ddyFxbId);
		String range = reportInf.getDayInterval();
		String beginTime = range.split("-")[0];
		String endTime = range.split("-")[1];
		
		// 报表月份
		String month = Integer.parseInt(endTime.substring(4, 6)) + "月";
		String year = Integer.parseInt(beginTime.substring(0, 4)) + "年";
		
		Map<String, Object> param = new HashMap<String, Object>();
		param.put("reportId", ddyFxbId);
		List<Map<String, String>> areaNum = db.getMybatisMapper(ReportServiceMapper.class).selectDdyFxbByXgsmc(param);
		// 公司低电压用户数
		String totalNum = "0";
		
		String totalNumDetailDesc = "";
		for (int i = 0; i < areaNum.size(); i ++) {
			Map<String, String> map = areaNum.get(i);
			String area = map.get("area").substring(0, 2);
			String num = map.get("num");
			String areaKey = null;
			
			if ("新泰".equals(area)) {
				areaKey = "xintai";
			} else if ("岱岳".equals(area)) {
				areaKey = "daiyue";
			} else if ("东平".equals(area)) {
				areaKey = "dongping";
			} else if ("高新".equals(area)) {
				areaKey = "gaoxin";
			} else if ("宁阳".equals(area)) {
				areaKey = "ningyang";
			} else if ("肥城".equals(area)) {
				areaKey = "feicheng";
			} else if ("泰山".equals(area)) {
				areaKey = "taishang";
			} else if ("景区".equals(area)) {
				areaKey = "jingqu";
			} else {
				continue;
			}
			if (i == areaNum.size() - 1) {
				totalNumDetailDesc += area+ num + "户，占所辖营业户数" + CommonUtil.multiply(CommonUtil.divide(num, this.customerMap.get(areaKey), 4), "100", 2)+ "%。";
			} else {
				totalNumDetailDesc += area + num + "户，占所辖营业户数" + CommonUtil.multiply(CommonUtil.divide(num, this.customerMap.get(areaKey), 4), "100", 2)+ "%；";
			}
			totalNum = CommonUtil.add(totalNum, num);
		}
		
		// 公司低电压用户数占比
		String totalNumZb = CommonUtil.multiply(CommonUtil.divide(totalNum, this.customerMap.get("heji"), 4), "100", 2);
		
		// 去年同期数
		param.put("beginTime", DateUtil.dateAddYear(beginTime, -1));
		param.put("endTime", DateUtil.dateAddYear(endTime, -1));
		
		MINRowBounds rows = new MINRowBounds();
		rows.setSeparateSql(true);
		db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYZLFXB(param, rows);
		String qunianTotalNum = String.valueOf(rows.getCount());
		
		// 上月数
		param.put("beginTime", DateUtil.dateAddMonth(beginTime, -1));
		param.put("endTime", DateUtil.dateAddMonth(endTime, -1));
		db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYZLFXB(param, rows);
		String shangyueTotalNum = String.valueOf(rows.getCount());
		
		String totalNumHB = "";
		if (CommonUtil.compare(shangyueTotalNum, "0") != 0) {
			if (CommonUtil.compare(totalNum, shangyueTotalNum) == 1) {
				totalNumHB = "环比增加" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(totalNum, shangyueTotalNum), shangyueTotalNum, 4), "100", 2) + "%，";
			} else {
				totalNumHB = "环比减少" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(shangyueTotalNum, totalNum), shangyueTotalNum, 4), "100", 2) + "%，";
			}
		}
		String totalNumTB = "";
		if (CommonUtil.compare(qunianTotalNum, "0") != 0) {
			if (CommonUtil.compare(totalNum, qunianTotalNum) == 1) {
				totalNumTB = "同比增加" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(totalNum, qunianTotalNum), qunianTotalNum, 4), "100", 2) + "%，";
			} else {
				totalNumTB = "同比减少" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(qunianTotalNum, totalNum), qunianTotalNum, 4), "100", 2) + "%，";
			}
		}
		
		// 受考核数
		List<Map<String, String>> kaoheArea = db.getMybatisMapper(ReportServiceMapper.class).selectDdyFxbByXgsmcAndZl(param);
		// 公司低电压用户数
		String kaoheNum = "0";
		
		String kaoheAreaDesc = "";
		Map<String, String> keheAreaMap = new HashMap<String, String>();
		for (int i = 0; i < kaoheArea.size(); i ++) {
			Map<String, String> map = kaoheArea.get(i);
			String area = map.get("area").substring(0, 2);
			String num = map.get("num");
			keheAreaMap.put(area, num);
			
			String areaKey = null;
			
			if ("新泰".equals(area)) {
				areaKey = "xintai";
			} else if ("岱岳".equals(area)) {
				areaKey = "daiyue";
			} else if ("东平".equals(area)) {
				areaKey = "dongping";
			} else if ("高新".equals(area)) {
				areaKey = "gaoxin";
			} else if ("宁阳".equals(area)) {
				areaKey = "ningyang";
			} else if ("肥城".equals(area)) {
				areaKey = "feicheng";
			} else if ("泰山".equals(area)) {
				areaKey = "taishang";
			} else if ("景区".equals(area)) {
				areaKey = "jingqu";
			} else {
				continue;
			}
			if (i == areaNum.size() - 1) {
				kaoheAreaDesc += area + num + "户，占比" + CommonUtil.multiply(CommonUtil.divide(num, this.customerMap.get(areaKey), 4), "100", 4)+ "%。";
			} else {
				kaoheAreaDesc += area + num + "户，占比" + CommonUtil.multiply(CommonUtil.divide(num, this.customerMap.get(areaKey), 4), "100", 4)+ "%；";
			}
			kaoheNum = CommonUtil.add(kaoheNum, num);
		}
		// 受考核数占比
		String kaoheNumZb = CommonUtil.multiply(CommonUtil.divide(kaoheNum, this.customerMap.get("heji"), 4), "100", 4);
		
		// 去年受考核数
		param.put("beginTime", DateUtil.dateAddYear(beginTime, -1));
		param.put("endTime", DateUtil.dateAddYear(endTime, -1));
		db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYRB(param, rows);
		String kaoheNumQunian = String.valueOf(rows.getCount());
		// 上月受考核数
		param.put("beginTime", DateUtil.dateAddMonth(beginTime, -1));
		param.put("endTime", DateUtil.dateAddMonth(endTime, -1));
		db.getMybatisMapper(ReportServiceMapper.class).selectDetail03ByDDYRB(param, rows);
		String kaoheNumShangyue = String.valueOf(rows.getCount());
		String kaoheNumHB = "";
		if (CommonUtil.compare(kaoheNumShangyue, "0") != 0) {
			if (CommonUtil.compare(kaoheNum, kaoheNumShangyue) == 1) {
				kaoheNumHB = "环比增加" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(kaoheNum, kaoheNumShangyue), kaoheNumShangyue, 4), "100", 2) + "%，";
			} else {
				kaoheNumHB = "环比减少" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(kaoheNumShangyue, kaoheNum), kaoheNumShangyue, 4), "100", 2) + "%，";
			}
		}
		String kaoheNumTB = "";
		if (CommonUtil.compare(kaoheNumQunian, "0") != 0) {
			if (CommonUtil.compare(kaoheNum, kaoheNumQunian) == 1) {
				kaoheNumTB = "同比增加" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(kaoheNum, kaoheNumQunian), kaoheNumQunian, 4), "100", 2) + "%。";
			} else {
				kaoheNumTB = "同比减少" + CommonUtil.multiply(CommonUtil.divide(CommonUtil.subtract(kaoheNumQunian, kaoheNum), kaoheNumQunian, 4), "100", 2) + "%。";
			}
		}
		
		// 治理完成数
		param.put("zlwc", "是");
		List<Map<String, String>> kaoheZlArea = db.getMybatisMapper(ReportServiceMapper.class).selectDdyFxbByXgsmcAndZl(param);
		String kaoheZlNum = "0";
		String kaoheZlDesc = "";
		for (int i = 0; i < kaoheZlArea.size(); i ++) {
			Map<String, String> map = kaoheZlArea.get(i);
			String area = map.get("area").substring(0, 2);
			String num = map.get("num");
			String wanchenglv = CommonUtil.multiply(CommonUtil.divide(num, keheAreaMap.get(area), 4), "100", 2);
			if (i == areaNum.size() - 1) {
				kaoheZlDesc += area + "治理完成" + num + "户，治理完成率" + wanchenglv+ "%。";
			} else {
				kaoheZlDesc += area + "治理完成" + num + "户，治理完成率" + wanchenglv+ "%；";
			}
			kaoheZlNum = CommonUtil.add(kaoheZlNum, num); 
		}
		
		String kaoheZlNumLv = "0";
		if (CommonUtil.compare(kaoheNum, "0") != 0) {
			kaoheZlNumLv = CommonUtil.multiply(CommonUtil.divide(kaoheZlNum, kaoheNum, 4), "100", 2);
		}
		
		
		String desc1 = "<p>1.用户低电压情况</p>" +
						"<p>（1）总体情况（说明：用户电压低于198伏且持续超过1小时为低电压）</p>" +
						"<p>${month}，公司低电压用户${totalNum}户，占公司总营业户数${totalNumZb}%，${totalNumHB}${totalNumTB}其中，${totalNumDetailDesc}</p>" +
						"<p>（2）受考核情况（说明：月度累计低电压时长超过48小时低电压用户为受考核用户）</p>" +
						"<p>6月，公司低电压受考核客户${kaoheNum}户，占公司总营业户数${kaoheNumZb}，${kaoheNumHB}${kaoheNumTB}其中，${kaoheAreaDesc}治理完成${kaoheZlNum}户，治理完成率${kaoheZlNumLv}%，其中${kaoheZlDesc} ${year}${month}各单位低电压受考核及预警情况统计见表3-1。</p>" +
						"<p>图表3-1  ${year}${month}各单位低电压受考核及预警情况统计</p>";
		
		List<List<String>> tableArray1 = new ArrayList<List<String>>();
		List<String> tableArray1Title = new ArrayList<String>();
		tableArray1Title.add("单位");
		tableArray1Title.add("总户数");
		tableArray1Title.add("预警户数（≥15h）");
		tableArray1Title.add("预警治理完成");
		tableArray1Title.add("预警治理完成率");
		tableArray1Title.add("受考核低电压户数");
		tableArray1Title.add("考核低电压客户占比");
		tableArray1Title.add("考核治理完成户数");
		tableArray1Title.add("考核治理完成率");
		tableArray1.add(tableArray1Title);
		// 预警数据
		List<Map<String, String>> yujingNum = db.getMybatisMapper(ReportServiceMapper.class).selectDdyFxbByXgsmcYuJing(param);
		List<String> tableArrayDaiyue = new ArrayList<String>();
		tableArrayDaiyue.add("岱岳");
		tableArrayDaiyue.add(customerMap.get("daiyue"));
		tableArrayDaiyue.add("0");
		tableArrayDaiyue.add("0");
		tableArrayDaiyue.add("0");
		tableArrayDaiyue.add("0");
		tableArrayDaiyue.add("0");
		tableArrayDaiyue.add("0");
		tableArrayDaiyue.add("0");
		tableArray1.add(tableArrayDaiyue);
		List<String> tableArrayDongping = new ArrayList<String>();
		tableArrayDongping.add("东平");
		tableArrayDongping.add(customerMap.get("dongping"));
		tableArrayDongping.add("0");
		tableArrayDongping.add("0");
		tableArrayDongping.add("0");
		tableArrayDongping.add("0");
		tableArrayDongping.add("0");
		tableArrayDongping.add("0");
		tableArrayDongping.add("0");
		tableArray1.add(tableArrayDongping);
		List<String> tableArrayGaoxin = new ArrayList<String>();
		tableArrayGaoxin.add("高新");
		tableArrayGaoxin.add(customerMap.get("gaoxin"));
		tableArrayGaoxin.add("0");
		tableArrayGaoxin.add("0");
		tableArrayGaoxin.add("0");
		tableArrayGaoxin.add("0");
		tableArrayGaoxin.add("0");
		tableArrayGaoxin.add("0");
		tableArrayGaoxin.add("0");
		tableArray1.add(tableArrayGaoxin);
		List<String> tableArrayXintai = new ArrayList<String>();
		tableArrayXintai.add("新泰");
		tableArrayXintai.add(customerMap.get("xintai"));
		tableArrayXintai.add("0");
		tableArrayXintai.add("0");
		tableArrayXintai.add("0");
		tableArrayXintai.add("0");
		tableArrayXintai.add("0");
		tableArrayXintai.add("0");
		tableArrayXintai.add("0");
		tableArray1.add(tableArrayXintai);
		List<String> tableArrayNingyang = new ArrayList<String>();
		tableArrayNingyang.add("宁阳");
		tableArrayNingyang.add(customerMap.get("ningyang"));
		tableArrayNingyang.add("0");
		tableArrayNingyang.add("0");
		tableArrayNingyang.add("0");
		tableArrayNingyang.add("0");
		tableArrayNingyang.add("0");
		tableArrayNingyang.add("0");
		tableArrayNingyang.add("0");
		tableArray1.add(tableArrayNingyang);
		List<String> tableArrayFeicheng = new ArrayList<String>();
		tableArrayFeicheng.add("肥城");
		tableArrayFeicheng.add(customerMap.get("feicheng"));
		tableArrayFeicheng.add("0");
		tableArrayFeicheng.add("0");
		tableArrayFeicheng.add("0");
		tableArrayFeicheng.add("0");
		tableArrayFeicheng.add("0");
		tableArrayFeicheng.add("0");
		tableArrayFeicheng.add("0");
		tableArray1.add(tableArrayFeicheng);
		List<String> tableArrayTaishang = new ArrayList<String>();
		tableArrayTaishang.add("泰山");
		tableArrayTaishang.add(customerMap.get("taishan"));
		tableArrayTaishang.add("0");
		tableArrayTaishang.add("0");
		tableArrayTaishang.add("0");
		tableArrayTaishang.add("0");
		tableArrayTaishang.add("0");
		tableArrayTaishang.add("0");
		tableArrayTaishang.add("0");
		tableArray1.add(tableArrayTaishang);
		List<String> tableArrayJingqu = new ArrayList<String>();
		tableArrayJingqu.add("景区");
		tableArrayJingqu.add(customerMap.get("jingqu"));
		tableArrayJingqu.add("0");
		tableArrayJingqu.add("0");
		tableArrayJingqu.add("0");
		tableArrayJingqu.add("0");
		tableArrayJingqu.add("0");
		tableArrayJingqu.add("0");
		tableArrayJingqu.add("0");
		tableArray1.add(tableArrayJingqu);
		List<String> tableArrayHeji = new ArrayList<String>();
		tableArrayHeji.add("合计");
		tableArrayHeji.add(customerMap.get("heji"));
		tableArrayHeji.add("0");
		tableArrayHeji.add("0");
		tableArrayHeji.add("0");
		tableArrayHeji.add("0");
		tableArrayHeji.add("0");
		tableArrayHeji.add("0");
		tableArrayHeji.add("0");
		tableArray1.add(tableArrayHeji);
		
		// 预警合计
		String yujingHeji = "0";
		String yujingHejiZl = "0";
		// 预警情况
		for (Map<String, String> map : yujingNum) {
			String area = map.get("area").substring(0, 2);
			String num = map.get("num");
			String sfxc = map.get("sfxc");
			if ("新泰".equals(area)) {
				tableArrayXintai.set(2, CommonUtil.add(tableArrayXintai.get(2), num));
				if ("是".equals(sfxc)) {
					tableArrayXintai.set(3, num);
				}
			} else if ("岱岳".equals(area)) {
				tableArrayDaiyue.set(2, CommonUtil.add(tableArrayDaiyue.get(2), num));
				// 
				if ("是".equals(sfxc)) {
					tableArrayDaiyue.set(3, num);
				}
			} else if ("东平".equals(area)) {
				tableArrayDongping.set(2, CommonUtil.add(tableArrayDongping.get(2), num));
				// 
				if ("是".equals(sfxc)) {
					tableArrayDongping.set(3, num);
				}
			} else if ("高新".equals(area)) {
				tableArrayGaoxin.set(2, CommonUtil.add(tableArrayGaoxin.get(2), num));
				// 
				if ("是".equals(sfxc)) {
					tableArrayGaoxin.set(3, num);
				}
			} else if ("宁阳".equals(area)) {
				tableArrayNingyang.set(2, CommonUtil.add(tableArrayNingyang.get(2), num));
				// 
				if ("是".equals(sfxc)) {
					tableArrayNingyang.set(3, num);
				}
			} else if ("肥城".equals(area)) {
				tableArrayFeicheng.set(2, CommonUtil.add(tableArrayFeicheng.get(2), num));
				// 
				if ("是".equals(sfxc)) {
					tableArrayFeicheng.set(3, num);
				}
			} else if ("泰山".equals(area)) {
				tableArrayTaishang.set(2, CommonUtil.add(tableArrayTaishang.get(2), num));
				// 
				if ("是".equals(sfxc)) {
					tableArrayTaishang.set(3, num);
				}
			} else if ("景区".equals(area)) {
				tableArrayJingqu.set(2, CommonUtil.add(tableArrayJingqu.get(2), num));
				// 
				if ("是".equals(sfxc)) {
					tableArrayJingqu.set(3, num);
				}
			} else {
				continue;
			}
			if ("是".equals(sfxc)) {
				yujingHejiZl = CommonUtil.add(yujingHejiZl, num);
			}
			yujingHeji = CommonUtil.add(yujingHeji, num);
		}
		tableArrayHeji.set(2, yujingHeji);
		tableArrayHeji.set(3, yujingHejiZl);
		
		// 考核合计
		String kaoheHeji = "0";
		// 考核情况
		for(Map.Entry<String, String> entry : keheAreaMap.entrySet()){
		    String area = entry.getKey();
		    String num = entry.getValue();
		    if ("新泰".equals(area)) {
				tableArrayXintai.set(5, num);
				tableArrayXintai.set(6, CommonUtil.multiply(CommonUtil.divide(num, customerMap.get("xintai"), 6), "100", 4) + "%");
			} else if ("岱岳".equals(area)) {
				tableArrayDaiyue.set(5, num);
				tableArrayDaiyue.set(6, CommonUtil.multiply(CommonUtil.divide(num, customerMap.get("daiyue"), 6), "100", 4) + "%");
			} else if ("东平".equals(area)) {
				tableArrayDongping.set(5, num);
				tableArrayDongping.set(6, CommonUtil.multiply(CommonUtil.divide(num, customerMap.get("dongping"), 6), "100", 4) + "%");
			} else if ("高新".equals(area)) {
				tableArrayGaoxin.set(5, num);
				tableArrayGaoxin.set(6, CommonUtil.multiply(CommonUtil.divide(num, customerMap.get("gaoxin"), 6), "100", 4) + "%");
			} else if ("宁阳".equals(area)) {
				tableArrayNingyang.set(5, num);
				tableArrayNingyang.set(6, CommonUtil.multiply(CommonUtil.divide(num, customerMap.get("ningyang"), 6), "100", 4) + "%");
			} else if ("肥城".equals(area)) {
				tableArrayFeicheng.set(5, num);
				tableArrayFeicheng.set(6, CommonUtil.multiply(CommonUtil.divide(num, customerMap.get("feicheng"), 6), "100", 4) + "%");
			} else if ("泰山".equals(area)) {
				tableArrayTaishang.set(5, num);
				tableArrayTaishang.set(6, CommonUtil.multiply(CommonUtil.divide(num, customerMap.get("taishan"), 6), "100", 4) + "%");
			} else if ("景区".equals(area)) {
				tableArrayJingqu.set(5, num);
				tableArrayJingqu.set(6, CommonUtil.multiply(CommonUtil.divide(num, customerMap.get("jingqu"), 6), "100", 4) + "%");
			} else {
				continue;
			}
		    kaoheHeji = CommonUtil.add(kaoheHeji, num);
		}
		tableArrayHeji.set(5, kaoheHeji);
		tableArrayHeji.set(6, CommonUtil.multiply(CommonUtil.divide(kaoheHeji, customerMap.get("heji"), 6), "100", 4) + "%");
		
		// 考核治理合计
		String kaoheHejiZl = "0";
		// 考核治理情况
		for (int i = 0; i < kaoheZlArea.size(); i ++) {
			Map<String, String> map = kaoheZlArea.get(i);
			String area = map.get("area").substring(0, 2);
			String num = map.get("num");
			if ("新泰".equals(area)) {
				tableArrayXintai.set(7, num);
				String kaohe = tableArrayXintai.get(5);
				if (CommonUtil.compare(kaohe, "0") != 0) {
					tableArrayXintai.set(8, CommonUtil.multiply(CommonUtil.divide(num, kaohe, 4), "100", 2) + "%");
				}
			} else if ("岱岳".equals(area)) {
				tableArrayDaiyue.set(7, num);
				String kaohe = tableArrayDaiyue.get(5);
				if (CommonUtil.compare(kaohe, "0") != 0) {
					tableArrayDaiyue.set(8, CommonUtil.multiply(CommonUtil.divide(num, kaohe, 4), "100", 2) + "%");
				}
			} else if ("东平".equals(area)) {
				tableArrayDongping.set(7, num);
				String kaohe = tableArrayDongping.get(5);
				if (CommonUtil.compare(kaohe, "0") != 0) {
					tableArrayDongping.set(8, CommonUtil.multiply(CommonUtil.divide(num, kaohe, 4), "100", 2) + "%");
				}
			} else if ("高新".equals(area)) {
				tableArrayGaoxin.set(7, num);
				String kaohe = tableArrayGaoxin.get(5);
				if (CommonUtil.compare(kaohe, "0") != 0) {
					tableArrayGaoxin.set(8, CommonUtil.multiply(CommonUtil.divide(num, kaohe, 4), "100", 2) + "%");
				}
			} else if ("宁阳".equals(area)) {
				tableArrayNingyang.set(7, num);
				String kaohe = tableArrayNingyang.get(5);
				if (CommonUtil.compare(kaohe, "0") != 0) {
					tableArrayNingyang.set(8, CommonUtil.multiply(CommonUtil.divide(num, kaohe, 4), "100", 2) + "%");
				}
			} else if ("肥城".equals(area)) {
				tableArrayFeicheng.set(7, num);
				String kaohe = tableArrayFeicheng.get(5);
				if (CommonUtil.compare(kaohe, "0") != 0) {
					tableArrayFeicheng.set(8, CommonUtil.multiply(CommonUtil.divide(num, kaohe, 4), "100", 2) + "%");
				}
			} else if ("泰山".equals(area)) {
				tableArrayTaishang.set(7, num);
				String kaohe = tableArrayTaishang.get(5);
				if (CommonUtil.compare(kaohe, "0") != 0) {
					tableArrayTaishang.set(8, CommonUtil.multiply(CommonUtil.divide(num, kaohe, 4), "100", 2) + "%");
				}
			} else if ("景区".equals(area)) {
				tableArrayJingqu.set(7, num);
				String kaohe = tableArrayJingqu.get(5);
				if (CommonUtil.compare(kaohe, "0") != 0) {
					tableArrayJingqu.set(8, CommonUtil.multiply(CommonUtil.divide(num, kaohe, 4), "100", 2) + "%");
				}
			} else {
				continue;
			}
			kaoheHejiZl = CommonUtil.add(kaoheHejiZl, num);
		}
		tableArrayHeji.set(7, kaoheHejiZl);
		if (CommonUtil.compare(kaoheHeji, "0") != 0) {
			tableArrayHeji.set(8, CommonUtil.multiply(CommonUtil.divide(kaoheHejiZl, kaoheHeji, 4), "100", 2) + "%");
		}
		
		for (int i = 1; i < tableArray1.size(); i ++) {
			List<String> childList = tableArray1.get(i);
			String yujingzl = childList.get(3);
			String yujing = childList.get(2);
			if (CommonUtil.compare(yujingzl, "0") != 0 && CommonUtil.compare(yujing, "0") != 0) {
				childList.set(4, CommonUtil.multiply(CommonUtil.divide(yujingzl, yujing, 4), "100", 2) + "%");
			}
		}
		
		List<String> tubiaoData1Array1 = new ArrayList<String>();
		List<String> tubiaoData1Array2 = new ArrayList<String>();
		List<String> tubiaoData1Array3 = new ArrayList<String>();
		for (int i = 1; i < tableArray1.size() - 1; i ++) {
			tubiaoData1Array1.add(tableArray1.get(i).get(7));
			tubiaoData1Array2.add(tableArray1.get(i).get(8));
			tubiaoData1Array3.add(tableArray1.get(i).get(6));
		}
		
		List<Map<String, Object>> tubiaoData1 = new ArrayList<Map<String, Object>>();
		Map<String, Object> zlwcMap = new HashMap<String, Object>();
		zlwcMap.put("name", "治理完成户数");
		zlwcMap.put("type", "bar");
		zlwcMap.put("yAxisIndex", 0);
		zlwcMap.put("data", tubiaoData1Array1);
		tubiaoData1.add(zlwcMap);
		Map<String, Object> zlwcLvMap = new HashMap<String, Object>();
		zlwcLvMap.put("name", "治理完成率");
		zlwcLvMap.put("type", "bar");
		zlwcLvMap.put("yAxisIndex", 1);
		zlwcLvMap.put("data", tubiaoData1Array2);
		tubiaoData1.add(zlwcLvMap);
		Map<String, Object> kaoheZbMap = new HashMap<String, Object>();
		kaoheZbMap.put("name", "考核低压占比");
		kaoheZbMap.put("type", "line");
		kaoheZbMap.put("yAxisIndex", 2);
		kaoheZbMap.put("data", tubiaoData1Array3);
		tubiaoData1.add(kaoheZbMap);
		
		String desc2 = "<p>（3）重复发生情况</p>" +
				"<p>${month}，公司重复低电压15天以上用户${ljtsGt15}户，${ljtsGt15Desc}${year}${month}公司低电压重复发生15天以上用户明细见表3-2。</p>" +
				"<p>表3-2 ${year}${month}公司低电压重复发生15天以上明细</p>";

		
		// 重复停电15天以上数据
		DwDdyFxbExample ddyFxbExample = new DwDdyFxbExample();
		ddyFxbExample.createCriteria().andReportIdEqualTo(ddyFxbId).andLjtsGreaterThan(15);
		ddyFxbExample.setOrderByClause("DDF_XGSMC");
		List<DwDdyFxb> ddyFxb15List = db.selectByExample(DwDdyFxbMapper.class, ddyFxbExample);
		
		int numFlag = 0;
		String ljtsGt15Desc = "";
		String ljtsGt15 = String.valueOf(ddyFxb15List.size());
		for (int i = 0; i < ddyFxb15List.size(); i ++) {
			DwDdyFxb dq = ddyFxb15List.get(i);
			// 不是最后一条数据
			if (i != ddyFxb15List.size() - 1) {
				// 获取下一条数据
				DwDdyFxb next = ddyFxb15List.get(i + 1);
				// 县公司名称相同
				if (dq.getXgsmc().equals(next.getXgsmc())) {
					numFlag ++;
				} else {
					ljtsGt15Desc += dq.getXgsmc().substring(0, 2) + numFlag + "户，";
					numFlag = 0;
				}
			} else {
				ljtsGt15Desc += dq.getXgsmc().substring(0, 2) + numFlag + "户。";
			}
		}
		
		List<List<String>> tableArray2 = new ArrayList<List<String>>();
		List<String> tableArray2Title = new ArrayList<String>();
		tableArray2Title.add("序号");
		tableArray2Title.add("单位");
		tableArray2Title.add("用户管理单位");
		tableArray2Title.add("台区ID");
		tableArray2Title.add("变压器名称");
		tableArray2Title.add("用户编号");
		tableArray2Title.add("低电压时长");
		tableArray2Title.add("累计天数");
		tableArray2.add(tableArray2Title);
		
		for (int i = 0; i < ddyFxb15List.size(); i ++) {
			DwDdyFxb dq = ddyFxb15List.get(i);
			List<String> child = new ArrayList<String>();
			child.add(i + 1 + "");
			child.add(dq.getXgsmc().substring(0, 2));
			child.add(dq.getYhgldwmc());
			child.add(dq.getTqid());
			child.add(dq.getByqmc());
			child.add(dq.getYhbh());
			child.add(dq.getDdysj() + "");
			child.add(dq.getLjts() + "");
			tableArray2.add(child);
		}
		
		
		String desc3 = "<p>（4）涉及台区情况</p>" +
				"<p>${month}，公司低电压涉及台区数量${tqIdTotalNum}个，其中存在受考核用户的台区${tqIdKaoheTotalNum}个，占比${tqIdKaoheTotalNumZB}%，其中${tqIdKaoheDesc}</p>" +
				"<p>表3-3 ${year}${month}公司低电压考核用户涉及台区情况统计</p>";
		List<List<String>> tableArray3 = new ArrayList<List<String>>();
		List<String> tableArray3Title = new ArrayList<String>();
		tableArray3Title.add("单位");
		tableArray3Title.add("管理的台区数");
		tableArray3Title.add("存在低电压用户的台区数量");
		tableArray3Title.add("存在受考核用户的台区");
		tableArray3Title.add("受考核用户涉及台区占比");
//		tableArray3Title.add("严重台区数量");
//		tableArray3Title.add("严重台区占比");
		tableArray3.add(tableArray3Title);
		List<String> tableArray3Gaoxin = new ArrayList<String>();
		tableArray3Gaoxin.add("高新");
		tableArray3Gaoxin.add(guanxiaTaiqu.get("gaoxin"));
		List<String> tableArray3Daiyue = new ArrayList<String>();
		tableArray3Daiyue.add("岱岳");
		tableArray3Daiyue.add(guanxiaTaiqu.get("daiyue"));
		List<String> tableArray3Xintai = new ArrayList<String>();
		tableArray3Xintai.add("新泰");
		tableArray3Xintai.add(guanxiaTaiqu.get("xintai"));
		List<String> tableArray3Dongping = new ArrayList<String>();
		tableArray3Dongping.add("东平");
		tableArray3Dongping.add(guanxiaTaiqu.get("dongping"));
		List<String> tableArray3Ningyang = new ArrayList<String>();
		tableArray3Ningyang.add("宁阳");
		tableArray3Ningyang.add(guanxiaTaiqu.get("ningyang"));
		List<String> tableArray3Feicheng = new ArrayList<String>();
		tableArray3Feicheng.add("肥城");
		tableArray3Feicheng.add(guanxiaTaiqu.get("feicheng"));
		List<String> tableArray3Jingqu = new ArrayList<String>();
		tableArray3Jingqu.add("景区");
		tableArray3Jingqu.add(guanxiaTaiqu.get("jingqu"));
		List<String> tableArray3Taishan = new ArrayList<String>();
		tableArray3Taishan.add("泰山");
		tableArray3Taishan.add(guanxiaTaiqu.get("taishan"));
		List<String> tableArray3Heji = new ArrayList<String>();
		tableArray3Heji.add("合计");
		tableArray3Heji.add(guanxiaTaiqu.get("heji"));
		tableArray3.add(tableArray3Gaoxin);
		tableArray3.add(tableArray3Daiyue);
		tableArray3.add(tableArray3Xintai);
		tableArray3.add(tableArray3Dongping);
		tableArray3.add(tableArray3Ningyang);
		tableArray3.add(tableArray3Feicheng);
		tableArray3.add(tableArray3Jingqu);
		tableArray3.add(tableArray3Taishan);
		tableArray3.add(tableArray3Heji);
		 
		List<Map<String, String>> tqIdList = db.getMybatisMapper(ReportServiceMapper.class).selectDdyFxbByTQID(param);
		String tqIdTotalNum = "0";
		for (Map<String, String> map : tqIdList) {
		    String area = map.get("area").substring(0, 2);
		    String num = map.get("num");
		    if ("新泰".equals(area)) {
		    	tableArray3Xintai.add(num);
			} else if ("岱岳".equals(area)) {
				tableArray3Daiyue.add(num);
			} else if ("东平".equals(area)) {
				tableArray3Dongping.add(num);
			} else if ("高新".equals(area)) {
				tableArray3Gaoxin.add(num);
			} else if ("宁阳".equals(area)) {
				tableArray3Ningyang.add(num);
			} else if ("肥城".equals(area)) {
				tableArray3Feicheng.add(num);
			} else if ("泰山".equals(area)) {
				tableArray3Taishan.add(num);
			} else if ("景区".equals(area)) {
				tableArray3Jingqu.add(num);
			} else {
				continue;
			}
		    tqIdTotalNum = CommonUtil.add(tqIdTotalNum, num);
		}
		tableArray3Heji.add(tqIdTotalNum);
		
		// 没有数据的补零
		for (List<String> child : tableArray3) {
			if (child.size() < 3) {
				child.add("0");
			}
		}
		
		param.put("taiQuKaohe", "1");
		String tqIdKaoheTotalNum = "0";
		String tqIdKaoheDesc = "";
		List<Map<String, String>> tqIdKaoheList = db.getMybatisMapper(ReportServiceMapper.class).selectDdyFxbByTQID(param);
		for (int i = 0; i < tqIdKaoheList.size(); i ++) {
			Map<String, String> map = tqIdKaoheList.get(i);
		    String area = map.get("area").substring(0, 2);
		    String num = map.get("num");
		    
		    String guanxiaNum = null;
		    String zb = null;
		    if ("新泰".equals(area)) {
		    	tableArray3Xintai.add(num);
		    	guanxiaNum = tableArray3Xintai.get(1);
		    	zb = CommonUtil.multiply(CommonUtil.divide(num, guanxiaNum, 4), "100", 2);
		    	tableArray3Xintai.add(zb + "%");
			} else if ("岱岳".equals(area)) {
				tableArray3Daiyue.add(num);
				guanxiaNum = tableArray3Daiyue.get(1);
				zb = CommonUtil.multiply(CommonUtil.divide(num, guanxiaNum, 4), "100", 2);
				tableArray3Daiyue.add(zb + "%");
			} else if ("东平".equals(area)) {
				tableArray3Dongping.add(num);
				guanxiaNum = tableArray3Dongping.get(1);
				zb = CommonUtil.multiply(CommonUtil.divide(num, guanxiaNum, 4), "100", 2);
				tableArray3Dongping.add(zb + "%");
			} else if ("高新".equals(area)) {
				tableArray3Gaoxin.add(num);
				guanxiaNum = tableArray3Gaoxin.get(1);
				zb = CommonUtil.multiply(CommonUtil.divide(num, guanxiaNum, 4), "100", 2);
				tableArray3Gaoxin.add(zb + "%");
			} else if ("宁阳".equals(area)) {
				tableArray3Ningyang.add(num);
				guanxiaNum = tableArray3Ningyang.get(1);
				zb = CommonUtil.multiply(CommonUtil.divide(num, guanxiaNum, 4), "100", 2);
				tableArray3Ningyang.add(zb + "%");
			} else if ("肥城".equals(area)) {
				tableArray3Feicheng.add(num);
				guanxiaNum = tableArray3Feicheng.get(1);
				zb = CommonUtil.multiply(CommonUtil.divide(num, guanxiaNum, 4), "100", 2);
				tableArray3Feicheng.add(zb + "%");
			} else if ("泰山".equals(area)) {
				tableArray3Taishan.add(num);
				guanxiaNum = tableArray3Taishan.get(1);
				zb = CommonUtil.multiply(CommonUtil.divide(num, guanxiaNum, 4), "100", 2);
				tableArray3Taishan.add(zb + "%");
			} else if ("景区".equals(area)) {
				tableArray3Jingqu.add(num);
				guanxiaNum = tableArray3Jingqu.get(1);
				zb = CommonUtil.multiply(CommonUtil.divide(num, guanxiaNum, 4), "100", 2);
				tableArray3Jingqu.add(zb + "%");
			} else {
				continue;
			}
		    tqIdKaoheTotalNum = CommonUtil.add(tqIdKaoheTotalNum, num);
		    
		    if (i != tqIdKaoheList.size() - 1) {
		    	tqIdKaoheDesc += area + num + "个，占比" + zb + "%，";
		    } else {
		    	tqIdKaoheDesc += area + num + "个，占比" + zb + "%。";
		    }
		    
		}
		// 占比
		String tqIdKaoheTotalNumZB = CommonUtil.multiply(CommonUtil.divide(tqIdKaoheTotalNum, guanxiaTaiqu.get("heji"), 4), "100", 2);
		tableArray3Heji.add(tqIdKaoheTotalNum);
		tableArray3Heji.add(tqIdKaoheTotalNumZB);
		// 没有数据的补零
		for (List<String> child : tableArray3) {
			if (child.size() < 5) {
				child.add("0");
				child.add("0.00%");
			}
		}
		
		String desc4 = "<p>（5）原因分析</p>" +
				"<p>按受考核低电压用户原因分：${ddyzymcDesc}${year}${month}公司受考核低电压用户原因分类情况统计见图表3-4。</p>" +
				"<p>图表3-4 ${year}${month}公司受考核低电压用户原因分类情况统计</p>";
		
		List<List<String>> tableArray4 = new ArrayList<List<String>>();
		List<String> tableArray4Title = new ArrayList<String>();
		tableArray4Title.add("原因分类");
		tableArray4Title.add("受考核低电压户数");
		tableArray4Title.add("原因占比");
		tableArray4.add(tableArray4Title);
		
		String ddyzymcNumTotal = "0";
		List<Map<String, String>> ddyzymcList = db.getMybatisMapper(ReportServiceMapper.class).selectDdyFxbByDDYZYMC(param);
		for (Map<String, String> map : ddyzymcList) {
			List<String> child = new ArrayList<String>();
			child.add(map.get("ddyzymc"));
			child.add(map.get("num"));
			tableArray4.add(child);
			ddyzymcNumTotal = CommonUtil.add(ddyzymcNumTotal, map.get("num"));
		}
		String ddyzymcDesc = "";
		
		
		List<Map<String, Object>> tubiaoData2Data = new ArrayList<Map<String, Object>>(); // 饼状图数据
		for (int i = 1; i < tableArray4.size(); i ++) {
			List<String> child = tableArray4.get(i);
			String zb = CommonUtil.multiply(CommonUtil.divide(child.get(1), ddyzymcNumTotal, 4), "100", 2) + "%";
			child.add(zb);
			if (i != tableArray4.size() - 1) {
				ddyzymcDesc += child.get(0) + child.get(1) + "户，占比" + zb + "；";
			} else {
				ddyzymcDesc += child.get(0) + child.get(1) + "户，占比" + zb + "。";
			}
			// 饼状图数据
			Map<String, Object> dataMap = new HashMap<String, Object>();
			dataMap.put("name", child.get(0));
			dataMap.put("value", Integer.parseInt(child.get(1)));
			tubiaoData2Data.add(dataMap);
		}
		
		List<Map<String, Object>> tubiaoData2 = new ArrayList<Map<String, Object>>();
		Map<String, Object> tubiaoData2Map = new HashMap<String, Object>();
		tubiaoData2Map.put("name", "受考核低电压用户原因");
		tubiaoData2Map.put("type", "pie");
		tubiaoData2Map.put("radius", "55%");
		List<String> centerList = new ArrayList<String>();
		centerList.add("50%");
		centerList.add("60%");
		tubiaoData2Map.put("center", centerList);
		tubiaoData2Map.put("data", tubiaoData2Data);
		Map<String, Object> emphasisMap = new HashMap<String, Object>();
		Map<String, Object> itemStyle = new HashMap<String, Object>();
		itemStyle.put("shadowBlur", 10);
		itemStyle.put("shadowOffsetX", 0);
		itemStyle.put("shadowColor", "rgba(1, 1, 0, 0.5)");
		emphasisMap.put("itemStyle", itemStyle);
		tubiaoData2Map.put("emphasisMap", emphasisMap);
		tubiaoData2.add(tubiaoData2Map);
		
		Map<String, Object> dataMap = new HashMap<String, Object>();
		dataMap.put("month", month);
		dataMap.put("year", year);
		dataMap.put("totalNum", totalNum);
		dataMap.put("totalNumZb", totalNumZb);
		dataMap.put("totalNumTB", totalNumTB);
		dataMap.put("totalNumHB", totalNumHB);
		dataMap.put("totalNumDetailDesc", totalNumDetailDesc);
		dataMap.put("kaoheNum", kaoheNum);
		dataMap.put("kaoheNumZb", kaoheNumZb);
		dataMap.put("kaoheNumHB", kaoheNumHB);
		dataMap.put("kaoheNumTB", kaoheNumTB);
		dataMap.put("kaoheAreaDesc", kaoheAreaDesc);
		dataMap.put("kaoheZlNum", kaoheZlNum);
		dataMap.put("kaoheZlNumLv", kaoheZlNumLv);
		dataMap.put("kaoheZlDesc", kaoheZlDesc);
		dataMap.put("ljtsGt15Desc", ljtsGt15Desc);
		dataMap.put("ljtsGt15", ljtsGt15);
		dataMap.put("ddyzymcDesc", ddyzymcDesc);
		dataMap.put("tqIdTotalNum", tqIdTotalNum);
		dataMap.put("tqIdKaoheTotalNum", tqIdKaoheTotalNum);
		dataMap.put("tqIdKaoheTotalNumZB", tqIdKaoheTotalNumZB);
		dataMap.put("tqIdKaoheDesc", tqIdKaoheDesc);
		resMap.put("dataMap", dataMap);
		resMap.put("desc1", desc1);
		resMap.put("tableArray1", tableArray1);
		resMap.put("tubiaoData1", tubiaoData1);
		resMap.put("desc2", desc2);
		resMap.put("desc3", desc3);
		resMap.put("desc4", desc4);
		resMap.put("tableArray2", tableArray2);
		resMap.put("tableArray3", tableArray3);
		resMap.put("tableArray4", tableArray4);
		resMap.put("tubiaoData2", tubiaoData2);
		
		return resMap;
	}
	/**
	 * 计停非计停日报
	 * @param range
	 * @param timeRange
	 * @return
	 * @throws MINBusinessException 
	 * @throws ParseException 
	 */
	public Map<String, Object> reportTypeJTFJTRB(String range, String timeRange) throws MINBusinessException, ParseException{
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		Map<String, Object> param = new HashMap<String, Object>();
		String beginTime = null;
		String endTime = null;
		range = range.replaceAll(" ", "");
		String[] rangeArray = range.split("-");
		timeRange = timeRange.replaceAll(" ", "");
		if (CommonUtil.isEmpty(timeRange)) {
			beginTime = rangeArray[0] + "000000";
			endTime = rangeArray[1] + "235959";
		} else {
			String[] timeRangeArray = timeRange.split("-");
			beginTime = rangeArray[0] + timeRangeArray[0];
			endTime = rangeArray[1] + timeRangeArray[1];
		}
		param.put("beginTime", beginTime);
		param.put("endTime", endTime);
		
		/** --计停--start--*/
		//主线
		DwFileDetail07Example example = new DwFileDetail07Example();
		example.createCriteria().andTimeBetween(beginTime, endTime).andTypeEqualTo("计停").andTriptypeLike("主线%");
		List<DwFileDetail07> listZx = db.selectByExample(DwFileDetail07Mapper.class, example);
		//支线
		DwFileDetail07Example example1 = new DwFileDetail07Example();
		example1.createCriteria().andTimeBetween(beginTime, endTime).andTypeEqualTo("计停").andTriptypeLike("支线%");
		List<DwFileDetail07> listZx1 = db.selectByExample(DwFileDetail07Mapper.class, example1);
		String descStr ="<P>国网泰安供电公司供电服务指挥中心（配网调控中心）</P><p>工单日报("+beginTime.substring(0, 4)+"年"+beginTime.substring(4, 6)+"月"+beginTime.substring(6, 8)+"日)</p><p>一、当日直供区配网运行情况</p>";
		descStr = descStr+ "<p>当日配网10kV主线计划停电"+listZx.size()+"项，支线计划停电"+listZx1.size()+"项，启动送电 项。因线路计停造成停电高压用户 户，停电低压用户 户。</p>";
		descStr = descStr +"<table border=\"1\">";
		if(listZx.size()>0 || listZx1.size()>0){
			descStr = descStr +"<tr><th>设备名称</th><th>管理单位</th><th>停电高压用户数</th><th>停电居民用户数</th><th>执行情况</th></tr>";
		}
		for(int i=0;i<listZx.size();i++){
			descStr = descStr+"<tr><td>"+listZx.get(i).getDevice()+"</td><td>"+listZx.get(i).getUnit()+"</td><td></td><td></td><td></td></tr>";	
		}
		for(int i=0;i<listZx1.size();i++){
			descStr = descStr+"<tr><td>"+listZx1.get(i).getDevice()+"</td><td>"+listZx1.get(i).getUnit()+"</td><td></td><td></td><td></td></tr>";	
		}
		descStr = descStr +"</table>";
		//非计停
		//主线
		DwFileDetail07Example fjtExample = new DwFileDetail07Example();
		fjtExample.createCriteria().andTimeBetween(beginTime, endTime).andTypeEqualTo("非计停").andTriptypeLike("主线%");
		List<DwFileDetail07> listFjtZx = db.selectByExample(DwFileDetail07Mapper.class, fjtExample);
		//支线
		DwFileDetail07Example fjtExample1 = new DwFileDetail07Example();
		fjtExample1.createCriteria().andTimeBetween(beginTime, endTime).andTypeEqualTo("非计停").andTriptypeLike("支线%");
		List<DwFileDetail07> listFjtZx1 = db.selectByExample(DwFileDetail07Mapper.class, fjtExample1);
		descStr = descStr +"<p>当日配网10kV主线非计停"+listFjtZx.size()+"项，支线非计停"+listFjtZx1.size()+"项，因线路非计停造成停电高压用户 户，停电低压用户 户。</p>";
		descStr = descStr +"<table border='1'>";
		if(listFjtZx.size()>0 || listFjtZx1.size()>0){
			descStr = descStr +"<tr><th>设备名称</th><th>管理单位</th><th>停电高压用户数</th><th>停电居民用户数</th><th>备注</th></tr>";
		}
		for(int i=0;i<listFjtZx.size();i++){
			descStr = descStr+"<tr><td>"+listFjtZx.get(i).getDevice()+"</td><td>"+listFjtZx.get(i).getUnit()+"</td><td></td><td></td><td></td></tr>";	
		}
		for(int i=0;i<listFjtZx1.size();i++){
			descStr = descStr+"<tr><td>"+listFjtZx1.get(i).getDevice()+"</td><td>"+listFjtZx1.get(i).getUnit()+"</td><td></td><td></td><td></td></tr>";	
		}
		descStr = descStr +"</table>";
		//跳闸
		//主线
		DwFileDetail07Example tzExample = new DwFileDetail07Example();
		tzExample.createCriteria().andTimeBetween(beginTime, endTime).andTypeEqualTo("跳闸").andTriptypeLike("主线%");
		List<DwFileDetail07> listTzZx = db.selectByExample(DwFileDetail07Mapper.class, tzExample);
		//支线
		DwFileDetail07Example tzExample1 = new DwFileDetail07Example();
		tzExample1.createCriteria().andTimeBetween(beginTime, endTime).andTypeEqualTo("跳闸").andTriptypeLike("支线%");
		List<DwFileDetail07> listTzZx1 = db.selectByExample(DwFileDetail07Mapper.class, tzExample1);
		descStr = descStr +"<p>当日配网发生10kV主线跳闸"+listTzZx.size()+"条次，支线跳闸"+listTzZx1.size()+"条次。因线路跳闸无重合闸造成停电高压用户 户，停电低压用户 户。</p>";
		descStr = descStr +"<table border=\"1\">";
		if(listTzZx.size()>0 || listTzZx1.size()>0){
			descStr = descStr +"<tr><th>设备名称</th><th>管理单位</th><th>故障原因</th><th>重合情况</th><th>停电高压用户数</th><th>停电居民用户数</th></tr>";
		}
		for(int i=0;i<listTzZx.size();i++){
			descStr = descStr+"<tr><td>"+listTzZx.get(i).getDevice()+"</td><td>"+listTzZx.get(i).getUnit()+"</td><td>"+listTzZx.get(i).getCause()+"</td><td>"+listTzZx.get(i).getChzdzqk()+"</td><td></td><td></td></tr>";	
		}
		for(int i=0;i<listTzZx1.size();i++){
			descStr = descStr+"<tr><td>"+listTzZx1.get(i).getDevice()+"</td><td>"+listTzZx1.get(i).getUnit()+"</td><td>"+listTzZx1.get(i).getCause()+"</td><td>"+listTzZx1.get(i).getChzdzqk()+"</td><td></td><td></td></tr>";	
		}
		descStr = descStr +"</table>";
		Map<String, Object> resMap = new HashMap<String, Object>();
//		resMap.put("dataMap", dataMap);
		resMap.put("descStr", descStr);
		return resMap; 
	}
	
	public List<List<String>> reportTypeZDDTYBBII(String firstFileId, MINHttpServletRequestContext request) throws MINBusinessException, InvalidFormatException, IOException{
		IMINDataBaseService db = Service.lookup(IMINDataBaseService.class);
		List<List<String>> resList = new ArrayList<List<String>>();
		
		List<String> titleList = new ArrayList<String>();
		titleList.add("ID");
		titleList.add("TNAME");
		titleList.add("SRC");
		resList.add(titleList);
		
		// 选择文件
		DwReportData reportData = db.selectByPrimaryKey(DwReportDataMapper.class, firstFileId);
		String jsonArrayStr = reportData.getData();
		JSONArray array = JSONArray.fromObject(jsonArrayStr);
		// 对比文件
		// 获取文件
		FileItem fileItem = request.getFile("file");
		String fileName = fileItem.getName();
		if (!fileName.endsWith(".xlsx") && !fileName.endsWith(".xls")) {
			throw new MINBusinessException("文件格式错误!");
		}
		String[] titleKey = new String[]{"gdbh","gdlx","gdfqsj","hjmc", "bdzmc","xlmc","gddw","zrdw","zrbz","ywmc","zdsbscmc","jhtysj","xttysj"};
		List<Map<String, String>> secondList = FilesUtil.readExecleasy(fileItem, titleKey, 1);
		
		for (Object first : array) {
			List<String> child = (List<String>)first;
			String tname = child.get(0);
			String id = child.get(1);
			boolean flag = false;
			for (Map<String, String> second : secondList) {
				String zdsbscmc = second.get("zdsbscmc");
				if (tname.equals(zdsbscmc)) {
					flag = true;
					break;
				}
			}
			if (!flag) {
				List<String> resChildList = new ArrayList<String>();
				resChildList.add(id);
				resChildList.add(tname);
				resChildList.add("投运");
				resList.add(resChildList);
			}
		}
		return resList;
	}
}