blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zxl
2025-11-10 cb415813de667096290d6bd0f924f5b523104117 
 ycl-server/src/main/java/com/ycl/platform/service/impl/ReportServiceImpl.java


@@ -1,34 +1,48 @@


package com.ycl.platform.service.impl;




import com.ycl.platform.domain.entity.Region;


import com.ycl.platform.domain.entity.Report;


import com.ycl.platform.domain.entity.YwPeople;


import com.ycl.platform.domain.entity.YwUnit;


import com.ycl.platform.mapper.RegionMapper;


import com.alibaba.fastjson2.JSON;


import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;


import com.baomidou.mybatisplus.core.metadata.IPage;


import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;


import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper;


import com.baomidou.mybatisplus.extension.plugins.pagination.Page;


import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;


import com.ycl.platform.domain.dto.ReportImportDTO;


import com.ycl.platform.domain.entity.*;


import com.ycl.platform.domain.form.ReportAuditingForm;


import com.ycl.platform.domain.form.ReportForm;


import com.ycl.platform.domain.query.ReportQuery;


import com.ycl.platform.domain.vo.ReportVO;


import com.ycl.platform.domain.vo.YwPointVO;


import com.ycl.platform.mapper.ReportMapper;


import com.ycl.platform.mapper.YwPeopleMapper;


import com.ycl.platform.mapper.YwPointMapper;


import com.ycl.platform.mapper.YwUnitMapper;


import com.ycl.platform.service.ReportAuditingRecordService;


import com.ycl.platform.service.ReportErrorTypeService;


import com.ycl.platform.service.ReportService;


import com.ycl.system.Result;


import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;


import com.ycl.platform.domain.form.ReportForm;


import com.ycl.platform.domain.vo.ReportVO;


import com.ycl.platform.domain.query.ReportQuery;


import java.util.List;


import org.apache.commons.lang3.StringUtils;


import com.baomidou.mybatisplus.core.metadata.IPage;


import com.ycl.system.entity.SysDictData;


import com.ycl.system.page.PageUtil;


import org.springframework.stereotype.Service;


import org.springframework.security.core.context.SecurityContextHolder;


import com.ycl.system.service.ISysDictTypeService;


import com.ycl.utils.DateUtils;


import com.ycl.utils.SecurityUtils;


import com.ycl.utils.StringUtils;


import com.ycl.utils.html.EscapeUtil;


import com.ycl.utils.poi.ExcelUtil;


import com.ycl.utils.uuid.IdUtils;


import jakarta.servlet.http.HttpServletResponse;


import lombok.RequiredArgsConstructor;


import lombok.SneakyThrows;


import lombok.extern.slf4j.Slf4j;


import org.springframework.beans.BeanUtils;


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


import org.springframework.util.Assert;


import java.util.ArrayList;


import java.util.Objects;


import org.springframework.util.CollectionUtils;




import java.util.*;


import java.util.stream.Collectors;


import com.baomidou.mybatisplus.extension.plugins.pagination.Page;


import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;


import lombok.RequiredArgsConstructor;




/**


 * 报备 服务实现类


@@ -38,12 +52,15 @@


 */


@Service


@RequiredArgsConstructor


@Slf4j


public class ReportServiceImpl extends ServiceImpl<ReportMapper, Report> implements ReportService {




    private final ReportMapper reportMapper;


    private final YwUnitMapper unitMapper;


    private final YwPointMapper ywpointMapper;


    private final YwPeopleMapper peopleMapper;


    private final RegionMapper regionMapper;


    private final ReportErrorTypeService reportErrorTypeService;


    private final ISysDictTypeService dictTypeService;


    private final ReportAuditingRecordService reportAuditingRecordService;




    /**


     * 添加


@@ -51,14 +68,116 @@


     * @return


     */


    @Override


    @Transactional(rollbackFor = Exception.class)


    public Result add(ReportForm form) {


        form.setPeopleId(1);


        form.setUnitId(2);


        Report entity = ReportForm.getEntityByForm(form, null);


        if(baseMapper.insert(entity) > 0) {


            return Result.ok("添加成功");


        if (Objects.isNull(form.getPointId())) {


            throw new RuntimeException("点位不能为空");


        }


        return Result.error("添加失败");


        Integer unitId = SecurityUtils.getUnitId();


        if (Objects.isNull(unitId)) {


            throw new RuntimeException("非运维单位暂时无法报备");


        }


        form.setUnitId(unitId);


        Long userId = SecurityUtils.getLoginUser().getUserId();


        form.setPeopleId(Integer.parseInt(userId+""));


        if ("事前报备".equals(form.getReportType())) {


            // 如果是事前报备需要检验是否已经生成下发工单


            YwPointVO point = ywpointMapper.countNotFinishedWorkOrderByGb(form.getPointId());


            if (Objects.nonNull(point)) {


                throw new RuntimeException(String.format("点位【%s】已经存在下发工单，无法事前报备", point.getPointName()));


            }


        }


        YwPoint point = new LambdaQueryChainWrapper<>(ywpointMapper)


                .eq(YwPoint::getSerialNumber, form.getPointId())


                .one();


        if (Objects.isNull(point)) {


            throw new RuntimeException("点位不存在");


        }


        Report entity = ReportForm.getEntityByForm(form, null);


        entity.setSerialNumber(point.getSerialNumber());


        entity.setStatus(0);


        Date now = new Date();


        entity.setCreateTime(now);


        entity.setUpdateTime(now);


        entity.setIdentify(IdUtils.randomNO(now));


        baseMapper.insert(entity);


        List<ReportErrorType> errorTypeList = form.getErrorTypeList().stream().map(item -> {


            ReportErrorType reportErrorType = new ReportErrorType();


            reportErrorType.setErrorType(item);


            reportErrorType.setDeleted(0);


            reportErrorType.setCreateTime(now);


            reportErrorType.setReportId(entity.getId());


            return reportErrorType;


        }).collect(Collectors.toList());


        reportErrorTypeService.saveBatch(errorTypeList);


        return Result.ok("报备成功");


    }




    @Override


    @SneakyThrows


    public void importTemplate(HttpServletResponse response) {


        ExcelUtil<ReportImportDTO> excelUtil = new ExcelUtil<>(ReportImportDTO.class);


        excelUtil.exportExcel(response, null, "报备导入模板");


    }




    @Override


    @SneakyThrows


    @Transactional


    public Result importData(ReportForm form) {


        Integer unitId = SecurityUtils.getUnitId();


        if (Objects.isNull(unitId)) {


            throw new RuntimeException("非运维单位暂时无法报备");


        }


        form.setUnitId(unitId);


        form.setBeginCreateTime(DateUtils.parseDate(form.getBeginCreateTimeStr()));


        form.setEndCreateTime(DateUtils.parseDate(form.getEndCreateTimeStr()));


        // 读取excel数据


        ExcelUtil<ReportImportDTO> excelUtil = new ExcelUtil<>(ReportImportDTO.class);


        List<ReportImportDTO> list = excelUtil.importExcel(form.getImportPointId().getInputStream());


        Date now = DateUtils.getNowDate();


        // 批量插入


        String pid = IdUtils.randomNO(now);


        Integer success = 0;


        for (ReportImportDTO item : list) {


            if ("事前报备".equals(form.getReportType())) {


                // 如果是事前报备需要检验是否已经生成下发工单


                YwPointVO point = ywpointMapper.countNotFinishedWorkOrderByGb(item.getSerialNumber());


                if (Objects.nonNull(point)) {


                    throw new RuntimeException(String.format("点位【%s】已经存在下发工单，无法事前报备", point.getPointName()));


                }


            }


            YwPoint point = new LambdaQueryChainWrapper<>(ywpointMapper)


                    .eq(YwPoint::getSerialNumber, item.getSerialNumber())


                    .one();


            if (Objects.isNull(point)) {


                continue;


            }


            Report entity = ReportForm.getEntityByForm(form, null);


            entity.setImportBatchNumber(pid);


            entity.setSerialNumber(item.getSerialNumber());


            entity.setStatus(0);


            entity.setIdentify(IdUtils.randomNO(now));


            entity.setCreateTime(now);


            entity.setUpdateTime(now);


            baseMapper.insert(entity);


            List<ReportErrorType> errorTypeList = form.getErrorTypeList().stream().map(err -> {


                ReportErrorType reportErrorType = new ReportErrorType();


                reportErrorType.setErrorType(err);


                reportErrorType.setDeleted(0);


                reportErrorType.setCreateTime(now);


                reportErrorType.setReportId(entity.getId());


                return reportErrorType;


            }).collect(Collectors.toList());


            reportErrorTypeService.saveBatch(errorTypeList);


            success++;


        }


        return Result.ok("报备点位数：" + list.size() + "，导入成功数：" + success);


    }




    @Override


    public Result getTogether(String pid) {


        List<Report> list = baseMapper.getTogether(pid);


        return Result.ok().data(list);


    }




    /**


@@ -67,17 +186,45 @@


     * @return


     */


    @Override


    @Transactional(rollbackFor = Exception.class)


    public Result update(ReportForm form) {




        Report entity = baseMapper.selectById(form.getId());




        // 为空抛IllegalArgumentException，做全局异常处理


        Assert.notNull(entity, "记录不存在");


        BeanUtils.copyProperties(form, entity);


        if (baseMapper.updateById(entity) > 0) {


            return Result.ok("修改成功");


        Date now = new Date();


        entity.setUpdateTime(now);


        if ("事前报备".equals(form.getReportType())) {


            // 如果是事前报备需要检验是否已经生成下发工单


            YwPointVO point = ywpointMapper.countNotFinishedWorkOrderByGb(form.getPointId());


            if (Objects.nonNull(point)) {


                throw new RuntimeException(String.format("点位【%s】已经存在下发工单，无法事前报备", point.getPointName()));


            }


        }


        return Result.error("修改失败");


        YwPoint point = new LambdaQueryChainWrapper<>(ywpointMapper)


                .eq(YwPoint::getSerialNumber, form.getPointId())


                .one();


        if (Objects.isNull(point)) {


            throw new RuntimeException("点位不存在");


        }


        BeanUtils.copyProperties(form, entity);


        entity.setSerialNumber(form.getPointId());


        // 重置为待审核


        entity.setStatus(0);


        baseMapper.updateById(entity);


        new LambdaUpdateChainWrapper<>(reportErrorTypeService.getBaseMapper())


                .eq(ReportErrorType::getReportId, form.getId())


                .remove();


        List<ReportErrorType> errorTypeList = form.getErrorTypeList().stream().map(err -> {


            ReportErrorType reportErrorType = new ReportErrorType();


            reportErrorType.setErrorType(err);


            reportErrorType.setDeleted(0);


            reportErrorType.setCreateTime(now);


            reportErrorType.setReportId(entity.getId());


            return reportErrorType;


        }).collect(Collectors.toList());


        reportErrorTypeService.saveBatch(errorTypeList);


        return Result.ok("修改成功");


    }




    /**


@@ -113,29 +260,40 @@


     */


    @Override


    public Result page(ReportQuery query) {


        IPage<ReportVO> page = PageUtil.getPage(query, ReportVO.class);


        query.setUnitId(SecurityUtils.getUnitId());


        if (query.getReportTimeEnd() != null) {


            query.setReportTimeEnd(DateUtils.getDayEnd(query.getReportTimeEnd()));


        }




        IPage<Report> page = new LambdaQueryChainWrapper<>(baseMapper)


                .eq(StringUtils.isNotBlank(query.getReportType()), Report::getReportType, query.getReportType())


                .le(Objects.nonNull(query.getBeginCreateTime()), Report::getBeginCreateTime, query.getBeginCreateTime())


                .ge(Objects.nonNull(query.getEndCreateTime()), Report::getEndCreateTime, query.getEndCreateTime())


                .orderByDesc(Report::getCreateTime)


                .page(PageUtil.getPage(query, Report.class));


        if (query.getEffectTimeEnd() != null) {


            query.setEffectTimeEnd(DateUtils.getDayEnd(query.getEffectTimeEnd()));


        }


        long dbStartTime = System.currentTimeMillis();


        baseMapper.page(page, query);


        long dbCostTime = System.currentTimeMillis() - dbStartTime;


        // 5. 打印耗时日志（含请求参数，方便后续排查慢查询）


        log.info("报表数据库查询耗时：{}ms，查询参数：{}", dbCostTime, JSON.toJSONString(query));




        List<ReportVO> vos = page.getRecords().stream()


                .map(


                        entity -> {


                            ReportVO vo = ReportVO.getVoByEntity(entity, null);


                            YwUnit unit = unitMapper.selectById(vo.getUnitId());


                            vo.setUnitName(unit.getUnitName());


                            YwPeople ywPeople = peopleMapper.selectById(vo.getPeopleId());


                            vo.setPeopleName(ywPeople.getYwPersonName());


                            Region region = regionMapper.selectById(vo.getPointId());


                            vo.setPointName(region.getFullName());


                            return vo;


                        }


                )


                .collect(Collectors.toList());


        return Result.ok().data(vos).total(page.getTotal());


        long dictStartTime = System.currentTimeMillis();


        List<SysDictData> errorTypeList = dictTypeService.selectDictDataByType("report_error_type");


        long dictEndTime = System.currentTimeMillis() - dictStartTime;


        Map<String, String> dictMap = errorTypeList.stream().collect(Collectors.toMap(SysDictData::getDictValue, SysDictData::getDictLabel));


        page.getRecords().stream().forEach(item -> {


            if (StringUtils.hasText(item.getErrorType())) {


                item.setErrorTypeList(List.of(item.getErrorType().split(",")));


                StringBuilder sb = new StringBuilder();


                item.getErrorTypeList().stream().forEach(err -> {


                    String s = dictMap.get(err);


                    if (org.springframework.util.StringUtils.hasText(s)) {


                        sb.append(s).append("、");


                    }


                });


                item.setErrorType(sb.substring(0, sb.length() - 1));


            }


        });


        log.info("组装信息耗时：{}ms", dictEndTime);


        return Result.ok().data(page).total(page.getTotal());


    }




    /**


@@ -145,10 +303,16 @@


     */


    @Override


    public Result detail(String id) {




        Report entity = baseMapper.selectById(id);


        Assert.notNull(entity, "记录不存在");


        ReportVO vo = ReportVO.getVoByEntity(entity, null);


        vo.setPointId(vo.getSerialNumber());


        List<ReportErrorType> errList = new LambdaQueryChainWrapper<>(reportErrorTypeService.getBaseMapper())


                .select(ReportErrorType::getErrorType)


                .eq(ReportErrorType::getReportId, id)


                .list();


        List<String> list = errList.stream().map(ReportErrorType::getErrorType).collect(Collectors.toList());


        vo.setErrorTypeList(list);


        return Result.ok().data(vo);


    }




@@ -166,4 +330,133 @@


                .collect(Collectors.toList());


        return Result.ok().data(vos);


    }




    @Override


    public List<ReportVO> export(ReportQuery query) {


        // 1. 分页查询主数据（不变）


        IPage<ReportVO> page = PageUtil.getPage(query, ReportVO.class);


        page.setSize(-1);


        query.setUnitId(SecurityUtils.getUnitId());


        baseMapper.page(page, query);


        List<ReportVO> records = page.getRecords();


        if (CollectionUtils.isEmpty(records)) {


            return Collections.emptyList();


        }




        // 2. 批量查询字典数据（不变，建议加缓存）


        List<SysDictData> errorTypeList = dictTypeService.selectDictDataByType("report_error_type");


        Map<String, String> errorDictMap = errorTypeList.stream()


                .collect(Collectors.toMap(SysDictData::getDictValue, SysDictData::getDictLabel, (k1, k2) -> k2));




        // 3. 批量查询审核记录（核心修改：用子查询替代窗口函数，兼容低版本MySQL）


        List<Integer> reportIds = records.stream().map(ReportVO::getId).collect(Collectors.toList());


        // 子查询：获取每个reportId的最新创建时间


        LambdaQueryWrapper<ReportAuditingRecord> maxTimeQuery = new LambdaQueryWrapper<ReportAuditingRecord>()


                .in(ReportAuditingRecord::getReportId, reportIds)


                .groupBy(ReportAuditingRecord::getReportId)


                .select(ReportAuditingRecord::getReportId, ReportAuditingRecord::getCreateTime); // 分组查reportId和最大时间




        // 主查询：关联子查询，拿到每个reportId最新的审核记录


        List<ReportAuditingRecord> allAuditRecords = reportAuditingRecordService.getBaseMapper().selectList(


                new LambdaQueryWrapper<ReportAuditingRecord>()


                        .in(ReportAuditingRecord::getReportId, reportIds)


                        // 关联子查询，匹配reportId和最新创建时间


                        .inSql(ReportAuditingRecord::getCreateTime,


                                "SELECT MAX(create_time) FROM t_report_auditing_record WHERE report_id IN (" +


                                        reportIds.stream().map(String::valueOf).collect(Collectors.joining(",")) +


                                        ") GROUP BY report_id")


        );




        // 构建reportId -> 最新审核记录的Map（不变）


        Map<Integer, ReportAuditingRecord> auditRecordMap = allAuditRecords.stream()


                .collect(Collectors.toMap(ReportAuditingRecord::getReportId, record -> record, (k1, k2) -> {


                    // 极端情况：同一reportId有相同创建时间的记录，取任意一个（按创建时间倒序取第一个）


                    return k1.getCreateTime().after(k2.getCreateTime()) ? k1 : k2;


                }));




        // 4. 循环处理数据（不变，保留之前的字符串优化和空值处理）


        records.forEach(item -> {


            // 处理故障类型（不变）


            String errorType = item.getErrorType();


            if (StringUtils.hasText(errorType)) {


                String[] errorTypeArr = StringUtils.split(errorType, ",");


                StringJoiner sj = new StringJoiner("、");


                for (String err : errorTypeArr) {


                    String dictLabel = errorDictMap.get(err);


                    if (StringUtils.hasText(dictLabel)) {


                        sj.add(dictLabel);


                    }


                }


                item.setErrorTypeList(Arrays.asList(errorTypeArr));


                item.setErrorType(sj.toString());


            }




            // 处理审核结果（不变，从Map获取）


            ReportAuditingRecord auditRecord = auditRecordMap.get(item.getId());


            if (auditRecord != null) {


                item.setResultStr(auditRecord.getResult() ? "通过" : "未通过");


                item.setResultRemark(auditRecord.getResultRemark());


                item.setAuditingTime(auditRecord.getCreateTime());


            } else {


                item.setResultStr("审核中");


            }




            item.setReportContent(EscapeUtil.clean(StringUtils.defaultString(item.getReportContent())));


        });




        return records;


    }




    @Override


    public Result auditingRecord(Integer id) {


        List<ReportVO> reportList = baseMapper.examineRecord(id);


        return Result.ok().data(reportList);


    }




    @Override


    @Transactional(rollbackFor = Exception.class)


    public Result auditing(ReportAuditingForm form) {


        if (CollectionUtils.isEmpty(form.getTogetherList())) {


            form.setTogetherList(new ArrayList<>(2));


        }


        form.getTogetherList().add(form.getId());


        for (Integer id : form.getTogetherList()) {


            Report report = baseMapper.selectById(id);


            if (Objects.isNull(report)) {


                continue;


            }


            if (form.getAuditingResult()) {


                report.setStatus(1);


            } else {


                report.setStatus(2);


            }


            Date now = new Date();


            report.setUpdateTime(now);


            baseMapper.updateById(report);




            // 添加一条审核记录


            ReportAuditingRecord reportAuditingRecord = new ReportAuditingRecord();


            reportAuditingRecord.setReportId(id);


            reportAuditingRecord.setDeleted(0);


            reportAuditingRecord.setCreateTime(now);


            reportAuditingRecord.setResultRemark(form.getAuditOpinion());


            reportAuditingRecord.setResult(form.getAuditingResult());


            reportAuditingRecordService.save(reportAuditingRecord);


        }


        return Result.ok("操作成功");


    }




    @Override


    public Result getListByGb(String gb) {


        List<ReportVO> list = baseMapper.getListByGb(gb);


        for (ReportVO report : list) {


            List<ReportErrorType> errors = new LambdaQueryChainWrapper<>(reportErrorTypeService.getBaseMapper())


                    .eq(ReportErrorType::getReportId, report.getId())


                    .orderByDesc(ReportErrorType::getCreateTime)


                    .list();


            String err = errors.stream().map(ReportErrorType::getErrorType).collect(Collectors.joining(","));


            report.setErrorType(err);


        }


        return Result.ok().data(list);


    }


}