package com.ycl.platform.service.impl;


import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ycl.platform.domain.entity.DailyMonitorDemeritRecord;

import com.ycl.platform.domain.entity.DemeritRecord;
import com.ycl.platform.domain.entity.MonitorConstruction;
import com.ycl.platform.domain.excel.DailyMonitorDemeritRecordExp;
import com.ycl.platform.service.IDailyMonitorDemeritRecordService;
import com.ycl.platform.service.IDemeritRecordService;
import com.ycl.platform.service.IMonitorConstructionService;
import com.ycl.system.mapper.DailyMonitorDemeritRecordMapper;
import com.ycl.utils.DateUtils;
import enumeration.ConstructionTypeEnum;
import enumeration.general.AreaDeptEnum;
import jakarta.servlet.http.HttpServletResponse;
import lombok.RequiredArgsConstructor;
import org.springframework.stereotype.Service;
import pojo.ExcelExp;
import utils.poi.ExcelUtilManySheet;

import java.io.IOException;
import java.time.LocalDateTime;
import java.time.ZoneId;
import java.time.format.DateTimeFormatter;
import java.util.*;

/**
 * zgyw
 *
 * @author : zxl
 * @date : 2025-11-04 17:47
 **/
@Service
@RequiredArgsConstructor
public class DailyMonitorDemeritRecordServiceImpl extends ServiceImpl<DailyMonitorDemeritRecordMapper,DailyMonitorDemeritRecord>
        implements IDailyMonitorDemeritRecordService {
    private final DailyMonitorDemeritRecordMapper dailyMonitorDemeritRecordMapper;
    private final IDemeritRecordService demeritRecordService;

    @Override
    public void getExportInfo(HttpServletResponse httpServletResponse, Integer id) throws IOException {
        DemeritRecord demeritRecord = demeritRecordService.getBaseMapper().selectById(id);

        if (demeritRecord != null) {

            //获得详情
            Date recordTime = demeritRecord.getRecordTime();
            LocalDateTime dateTime = LocalDateTime.ofInstant(recordTime.toInstant(), ZoneId.systemDefault());
            DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
            String formatted = dateTime.format(formatter);

            Integer deptId = demeritRecord.getDeptId();
            ConstructionTypeEnum constructionTypeEnum = ConstructionTypeEnum.getEnumByName(demeritRecord.getConstructionType());

            List<DailyMonitorDemeritRecord> list = new LambdaQueryChainWrapper<>(baseMapper)
                    .ge(DailyMonitorDemeritRecord::getRecordTime, DateUtils.getDayStart(recordTime))
                    .le(DailyMonitorDemeritRecord::getRecordTime, DateUtils.getDayEnd(recordTime))
                    .eq(DailyMonitorDemeritRecord::getDeptId, deptId)
                    .eq(DailyMonitorDemeritRecord::getConstructionType,constructionTypeEnum.getDesc())
                    .eq(DailyMonitorDemeritRecord::getDeleted, false)
                    .list();
            AreaDeptEnum areaDeptEnum = AreaDeptEnum.fromDept(deptId);
            List<DailyMonitorDemeritRecordExp> exps = new ArrayList<>();
            List<ExcelExp> mySheet = new ArrayList<>();
            for (DailyMonitorDemeritRecord dm : list) {
                DailyMonitorDemeritRecordExp dailyMonitorDemeritRecordExp = new DailyMonitorDemeritRecordExp();
                dailyMonitorDemeritRecordExp.setSerialNumber(dm.getSerialNumber());
                dailyMonitorDemeritRecordExp.setConstructionType(constructionTypeEnum.getDesc());

                if (areaDeptEnum != null) {
                    dailyMonitorDemeritRecordExp.setDept(areaDeptEnum.getName());
                }else{
                    dailyMonitorDemeritRecordExp.setDept("未知区域");
                }

                dailyMonitorDemeritRecordExp.setDemerit(dm.getDemerit());
                dailyMonitorDemeritRecordExp.setIsReport(dm.getIsReport() ? "已报备" :"未报备");
                dailyMonitorDemeritRecordExp.setRecordTime(formatted);
                dailyMonitorDemeritRecordExp.setDeviceName(dm.getDeviceName());
                exps.add(dailyMonitorDemeritRecordExp);
            }
            ExcelExp excelExp = new ExcelExp(areaDeptEnum == null ? "未知" : areaDeptEnum.getName(),exps,DailyMonitorDemeritRecordExp.class);
            mySheet.add(excelExp);
            ExcelUtilManySheet<List<ExcelExp>> util = new ExcelUtilManySheet<>(mySheet);
            util.exportExcelManySheet(httpServletResponse, mySheet);
        }



    }
}