package com.dingzhuo.energy.project.reportForm.controller;

import com.dingzhuo.energy.common.utils.poi.ExcelUtil;
import com.dingzhuo.energy.data.model.domain.EnergyIndex;
import com.dingzhuo.energy.data.model.domain.ModelNode;
import com.dingzhuo.energy.data.model.service.IModelNodeService;
import com.dingzhuo.energy.dataservice.domain.DataItem;
import com.dingzhuo.energy.framework.aspectj.lang.annotation.Log;
import com.dingzhuo.energy.framework.aspectj.lang.enums.BusinessType;
import com.dingzhuo.energy.framework.web.controller.BaseController;
import com.dingzhuo.energy.framework.web.domain.AjaxResult;
import com.dingzhuo.energy.project.reportForm.domain.dailyReport;
import com.dingzhuo.energy.project.reportForm.service.IdailyReportService;
import org.apache.commons.collections4.CollectionUtils;
import org.apache.commons.lang3.ObjectUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.lang.reflect.Field;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.stream.Collectors;

/**
 * 报表
 * @author sys
 * @date 2020-03-25
 */
@RestController
@RequestMapping("/report/dailyReport")
class dailyReportController extends BaseController {
    @Autowired
    private IdailyReportService dailyReportService;
    @Autowired
    private IModelNodeService modelNodeService;
    /**
     * 报表查询
     */
    @GetMapping("/list")
    public AjaxResult list(DataItem dataItem) throws ParseException {
        List<ModelNode> nodeId = modelNodeService.getModelNodeByModelCode(dataItem.getIndexCode());
        List<EnergyIndex> energyList = modelNodeService.getSettingIndex(nodeId.get(0).getNodeId());
        List<String> indexIds = energyList.stream().map(EnergyIndex::getIndexId).collect(Collectors.toList());
        dailyReport reportList =new  dailyReport();
        List<dailyReport> dataList=new ArrayList<>();
        /*List<Map> table=new ArrayList<>();
        Map tableColumn =new HashMap<>();//表数据*/
        DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
        SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String aa= df.format(dataItem.getDataTime());
        String bb="";
        int i = 0;
        dataItem.setBeginTime(dataItem.getDataTime());
        String endTime=aa+" 24:00:00";
        dataItem.setEndTime(sf.parse(endTime));
        while (i < 24) {
            if(i>9){
                bb=aa+" "+i+":00:00";
            }else{
                bb=aa+" 0"+i+":00:00";
            }
            dailyReport report=new dailyReport();
            report.setDataTime(sf.parse(bb));
            report.setValue("value"+i);
            dataList.add(report);
            i++;
        }
       List<dailyReport> list = dailyReportService.getDailyReportList(indexIds, dataList,dataItem.getBeginTime(),dataItem.getEndTime(), dataItem.getTimeType(),dataItem.getIndexStorageId());
        reportList.setTabledata(list);
        /*table.add(tableColumn);
        reportList.setTablehead(table);*/
        return AjaxResult.success(list);
        /*//表格数据
        List<DataItem> list = reportFormService.getDailyReportList(indexCode, dataItem.getBeginTime(),dataItem.getEndTime(), dataItem.getTimeType());
        Map<Date, List<DataItem>> groupBy = list.stream().collect(Collectors.groupingBy(DataItem::getDataTime));
        List<Map<String,Object>> tableRows= new ArrayList<>();
        AtomicInteger colcount= new AtomicInteger(0);//日期列的分组记录数
        groupBy.forEach((time,indexDatas)->{
            //time 是每一列的 日期
            //indexdatas是每一列的行数据
            //遍历每一列的行集合
            for(int rowCounts=0;rowCounts<indexDatas.size();rowCounts++)
            {
                DataItem indexData = indexDatas.get(rowCounts);//取列的行单元格
                if(rowCounts==0 && tableRows.size()==0)
                {
                    Map<String,Object> indexDataRow = new HashMap<>();
                    indexDataRow.put("indexname",indexData.getIndexName());
                    indexDataRow.put(time.getHours()+"",indexData.getValue());
                    tableRows.add(indexDataRow);
                }else
                {
                    if((tableRows.size()-1)==rowCounts)
                    {
                        Map<String,Object> t = tableRows.get(rowCounts);
                        t.put("indexname",indexData.getIndexName());
                        t.put(time.getHours()+"",indexData.getValue());
                        tableRows.add(t);
                    }else if((tableRows.size()-1)<rowCounts){
                        Map<String,Object> indexDataRow = new HashMap<>();
                        indexDataRow.put("indexname",indexData.getIndexName());
                        indexDataRow.put(time.getHours()+"",indexData.getValue());
                        tableRows.add(indexDataRow);
                    }
                }
            }
            colcount.getAndIncrement();
        });
        System.out.print("tableRows="+tableRows.size());
        System.out.print("=========================");*/
    }
    /**
     * 导出工序单耗统计指标设置功能列表
     */
    @Log(title = "综合报表", businessType = BusinessType.EXPORT)
    @GetMapping("/export")
    public AjaxResult export(DataItem dataItem) throws ParseException {
        ModelNode modelNode = modelNodeService.getModelNodeByModelCodeByIndexCode(dataItem.getIndexCode());
        if (ObjectUtils.isEmpty(modelNode)) {
            return AjaxResult.success("暂无数据");
        }
        List<dailyReport> dataList=new ArrayList<>();
        DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
        SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String aa= df.format(dataItem.getDataTime());
        String bb;
        int i = 0;
        dataItem.setBeginTime(dataItem.getDataTime());
        String endTime=aa+" 24:00:00";
        dataItem.setEndTime(sf.parse(endTime));
        while (i < 24) {
            if(i>9){
                bb=aa+" "+i+":00:00";
            }else{
                bb=aa+" 0"+i+":00:00";
            }
            dailyReport report=new dailyReport();
            report.setDataTime(sf.parse(bb));
            report.setValue("value"+i);
            dataList.add(report);
            i++;
        }
        List<dailyReport> list = dailyReportService.listDailyReportList(modelNode.getNodeId(), dataList,dataItem.getBeginTime(),
                dataItem.getEndTime(), dataItem.getTimeType(),dataItem.getIndexStorageId());
        if(CollectionUtils.isNotEmpty(list)){
            list.forEach(this::valueRep);
        }
        ExcelUtil<dailyReport> util = new ExcelUtil<>(dailyReport.class);
        return util.exportExcel(list, "综合指标分析日");
    }

    public void valueRep(dailyReport dr){
        Field[] fields = dr.getClass().getDeclaredFields();
        for(Field field:fields){
            field.setAccessible(true);
            Object obj = field.getType();
            if(field.getType().getName().equals("java.lang.Double")){
                String name = field.getName();
                try {
                    if(ObjectUtils.isEmpty(field.get(dr)))
                    {
                        field.set(dr,0.00);
                    }
                } catch (IllegalAccessException e) {
                    e.printStackTrace();
                }
            }
        }
    }


    public static String getLastDayOfMonth(String yearMonth) {
        int year = Integer.parseInt(yearMonth.split("-")[0]);  //年
        int month = Integer.parseInt(yearMonth.split("-")[1]); //月
        Calendar cal = Calendar.getInstance();
        // 设置年份
        cal.set(Calendar.YEAR, year);
        // 设置月份
        // cal.set(Calendar.MONTH, month - 1);
        cal.set(Calendar.MONTH, month); //设置当前月的上一个月
        // 获取某月最大天数
        //int lastDay = cal.getActualMaximum(Calendar.DATE);
        int lastDay = cal.getMinimum(Calendar.DATE); //获取月份中的最小值，即第一天
        // 设置日历中月份的最大天数
        //cal.set(Calendar.DAY_OF_MONTH, lastDay);
        cal.set(Calendar.DAY_OF_MONTH, lastDay - 1); //上月的第一天减去1就是当月的最后一天
        // 格式化日期
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        return sdf.format(cal.getTime());
    }
    private static Map<String, DataItem> change(List<DataItem> list) {
        Map<String, DataItem> resultMap = new HashMap<String, DataItem>();
        Set setTmp = new HashSet();
        for (DataItem tmp : list) {
            setTmp.add(tmp.getIndexId());
        }
        Iterator it = setTmp.iterator();
        while (it.hasNext()) {
            String oneSetTmpStr = (String) it.next();
            List<DataItem> oneSetTmpList = new ArrayList<DataItem>();
            for (DataItem tmp : list) {
                String oneMapValueStr = tmp.getIndexId();
                if (oneMapValueStr.equals(oneSetTmpStr)) {
                    oneSetTmpList.add(tmp);
                }
            }
            resultMap.put(oneSetTmpStr, oneSetTmpList.get(0));
        }
        return  resultMap;
    }
}