From 3e9a6da99aae968123ee7bca352fc08becd7f1f2 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期四, 29 八月 2024 17:29:21 +0800
Subject: [PATCH] 工单过程图接口更换

---
 ycl-server/src/main/java/com/ycl/platform/service/impl/ReportServiceImpl.java |  167 +++++++++++++++++++++++++++++++++++++------------------
 1 files changed, 113 insertions(+), 54 deletions(-)

diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/ReportServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/ReportServiceImpl.java
index 46aee9b..2ccf8e2 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/impl/ReportServiceImpl.java
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/ReportServiceImpl.java
@@ -1,13 +1,12 @@
 package com.ycl.platform.service.impl;
 
-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.service.impl.ServiceImpl;
+import com.ycl.platform.domain.dto.ReportImportDTO;
 import com.ycl.platform.domain.entity.Report;
 import com.ycl.platform.domain.entity.YwPeople;
-import com.ycl.platform.domain.entity.YwPoint;
-import com.ycl.platform.domain.entity.YwUnit;
+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;
@@ -18,15 +17,22 @@
 import com.ycl.platform.service.ReportService;
 import com.ycl.system.Result;
 import com.ycl.system.page.PageUtil;
+import com.ycl.utils.DateUtils;
 import com.ycl.utils.SecurityUtils;
+import com.ycl.utils.html.EscapeUtil;
+import com.ycl.utils.poi.ExcelUtil;
+import com.ycl.utils.uuid.IdUtils;
+import enumeration.general.ErrorTypeEnum;
+import jakarta.servlet.http.HttpServletResponse;
 import lombok.RequiredArgsConstructor;
-import org.apache.commons.lang3.StringUtils;
+import lombok.SneakyThrows;
 import org.springframework.beans.BeanUtils;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.Assert;
-import org.springframework.util.CollectionUtils;
 
 import java.util.ArrayList;
+import java.util.Date;
 import java.util.List;
 import java.util.Objects;
 import java.util.stream.Collectors;
@@ -52,16 +58,65 @@
      */
     @Override
     public Result add(ReportForm form) {
+        if (Objects.isNull(form.getPointId())) {
+            throw new RuntimeException("鐐逛綅涓嶈兘涓虹┖");
+        }
         Long userId = SecurityUtils.getUserId();
         YwPeople people = new LambdaQueryChainWrapper<>(peopleMapper).eq(YwPeople::getUserId, userId).one();
         form.setPeopleId(people.getId());
         form.setUnitId(people.getBelongUnit());
         Report entity = ReportForm.getEntityByForm(form, null);
+        entity.setSerialNumber(form.getPointId());
+        entity.setErrorType(String.join(",", form.getErrorType()));
         entity.setStatus(0);
+        entity.setIdentify(IdUtils.randomNO());
+        Date now = new Date();
+        entity.setCreateTime(now);
+        entity.setUpdateTime(now);
         if(baseMapper.insert(entity) > 0) {
             return Result.ok("娣诲姞鎴愬姛");
         }
         return Result.error("娣诲姞澶辫触");
+    }
+
+    @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) {
+        if (Objects.isNull(form.getImportPointId())) {
+            throw new RuntimeException("鐐逛綅涓嶈兘涓虹┖");
+        }
+        Long userId = SecurityUtils.getUserId();
+        YwPeople people = new LambdaQueryChainWrapper<>(peopleMapper).eq(YwPeople::getUserId, userId).one();
+        form.setPeopleId(people.getId());
+        form.setUnitId(people.getBelongUnit());
+        // 璇诲彇excel鏁版嵁
+        ExcelUtil<ReportImportDTO> excelUtil = new ExcelUtil<>(ReportImportDTO.class);
+        List<ReportImportDTO> list = excelUtil.importExcel(form.getImportPointId().getInputStream());
+        // 鎵归噺鎻掑叆
+        ArrayList<Report> reports = new ArrayList<>();
+        long l = System.currentTimeMillis();
+        list.forEach( item -> {
+            Report entity = ReportForm.getEntityByForm(form, null);
+            entity.setImportBatchNumber(String.valueOf(l));
+            entity.setSerialNumber(item.getSerialNumber());
+            entity.setStatus(0);
+            entity.setIdentify(IdUtils.randomNO());
+            entity.setCreateTime(DateUtils.getNowDate());
+            entity.setUpdateTime(DateUtils.getNowDate());
+            reports.add(entity);
+        });
+        if (saveBatch(reports)) {
+            return Result.ok("鎴愬姛瀵煎叆" + list.size() + "鏉℃暟鎹�");
+        }
+        return Result.error("瀵煎叆澶辫触");
     }
 
     /**
@@ -73,14 +128,26 @@
     public Result update(ReportForm form) {
 
         Report entity = baseMapper.selectById(form.getId());
-
         // 涓虹┖鎶汭llegalArgumentException锛屽仛鍏ㄥ眬寮傚父澶勭悊
         Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
-        BeanUtils.copyProperties(form, entity);
-        if (baseMapper.updateById(entity) > 0) {
-            return Result.ok("淇敼鎴愬姛");
+        Date now = new Date();
+        entity.setUpdateTime(now);
+        if (0 == entity.getStatus()) {
+            // 寰呭鏍哥殑鐩存帴鏀�
+            BeanUtils.copyProperties(form, entity);
+            baseMapper.updateById(entity);
+        } else if (2 == entity.getStatus()) {
+            // 濡傛灉鏄湭瀹℃牳閫氳繃锛岃繘琛屼慨鏀癸紝閭d箞鐩存帴鏂板锛堜负浜嗕繚瀛樺鏍歌褰曪級
+            Report report = new Report();
+            BeanUtils.copyProperties(entity, report);
+            BeanUtils.copyProperties(form, report);
+            report.setId(null);
+            report.setStatus(0);
+            report.setAuditingTime(null);
+            report.setAuditOpinion(null);
+            baseMapper.insert(report);
         }
-        return Result.error("淇敼澶辫触");
+        return Result.ok("淇敼鎴愬姛");
     }
 
     /**
@@ -116,8 +183,10 @@
      */
     @Override
     public Result page(ReportQuery query) {
-        List<ReportVO> page = baseMapper.page(query);
-        return Result.ok().data(page).total(page.size());
+        IPage<ReportVO> page = PageUtil.getPage(query, ReportVO.class);
+        baseMapper.page(page, query);
+        page.getRecords().forEach(item -> item.setErrorType(ErrorTypeEnum.getEnumValue(item.getErrorType())));
+        return Result.ok().data(page).total(page.getTotal());
     }
 
     /**
@@ -149,49 +218,39 @@
         return Result.ok().data(vos);
     }
 
+    @Override
     public List<ReportVO> export(ReportQuery query) {
-
-        if (StringUtils.isNotBlank(query.getPointId())) {
-            LambdaQueryWrapper<YwPoint> queryWrapper = new LambdaQueryWrapper<>();
-            queryWrapper.like(YwPoint::getPointName, query.getPointId());
-            query.setPointIdList(ywpointMapper.selectList(queryWrapper).stream().map(YwPoint::getId).collect(Collectors.toList()));
-            if(CollectionUtils.isEmpty(query.getPointIdList())) {
-                return new ArrayList<>();
-            }
-        }
-        if (StringUtils.isNotBlank(query.getPeopleId())) {
-            LambdaQueryWrapper<YwPeople> queryWrapper = new LambdaQueryWrapper<>();
-            queryWrapper.like(YwPeople::getYwPersonName, query.getPeopleId());
-            query.setPeopleIdList(peopleMapper.selectList(queryWrapper).stream().map(YwPeople::getId).collect(Collectors.toList()));
-            if(CollectionUtils.isEmpty(query.getPeopleIdList())) {
-                return new ArrayList<>();
-            }
-        }
-
-        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())
-                .in(!CollectionUtils.isEmpty(query.getPointIdList()), Report::getPointId, query.getPointIdList())
-                .in(!CollectionUtils.isEmpty(query.getPeopleIdList()), Report::getPeopleId, query.getPeopleIdList())
-                .orderByDesc(Report::getCreateTime)
-                .page(PageUtil.getPage(query, Report.class));
-
-        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());
-                            YwPoint ywPoint = ywpointMapper.selectById(vo.getPointId());
-                            vo.setPointName(ywPoint.getPointName());
-                            return vo;
-                        }
-                )
-                .collect(Collectors.toList());
-        return vos;
+        IPage<ReportVO> page = PageUtil.getPage(query, ReportVO.class);
+        page.setSize(-1);
+        baseMapper.page(page, query);
+        page.getRecords().forEach(item -> {
+            item.setErrorType(ErrorTypeEnum.getEnumValue(item.getErrorType()));
+            item.setReportContent(EscapeUtil.clean(item.getReportContent()));
+        });
+        return page.getRecords();
     }
 
+
+    @Override
+    public Result auditingRecord(Integer id) {
+        List<ReportVO> reportList = baseMapper.examineRecord(id);
+        return Result.ok().data(reportList);
+    }
+
+    @Override
+    public Result auditing(ReportAuditingForm form) {
+        Report report = baseMapper.selectById(form.getId());
+        if (Objects.isNull(report)) {
+            throw new RuntimeException("瀹℃牳鐨勬姤澶囦笉瀛樺湪");
+        }
+        if (form.getAuditingResult()) {
+            report.setStatus(1);
+        } else {
+            report.setStatus(2);
+        }
+        report.setAuditOpinion(form.getAuditOpinion());
+        report.setAuditingTime(new Date());
+        baseMapper.updateById(report);
+        return Result.ok("鎿嶄綔鎴愬姛");
+    }
 }

--
Gitblit v1.8.0