From 2b278a1aa078b39d891f3eb00aac729ed2c1c5b3 Mon Sep 17 00:00:00 2001
From: wl <173@qq.com>
Date: 星期一, 25 七月 2022 17:28:58 +0800
Subject: [PATCH] 报案人查询分页处理,处理案件早发时间 修改问题

---
 src/main/java/com/example/jz/service/impl/CauseServiceImpl.java |  110 +++++++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 94 insertions(+), 16 deletions(-)

diff --git a/src/main/java/com/example/jz/service/impl/CauseServiceImpl.java b/src/main/java/com/example/jz/service/impl/CauseServiceImpl.java
index bcc2ce5..c2a73b9 100644
--- a/src/main/java/com/example/jz/service/impl/CauseServiceImpl.java
+++ b/src/main/java/com/example/jz/service/impl/CauseServiceImpl.java
@@ -1,30 +1,36 @@
 package com.example.jz.service.impl;
 
+import com.alibaba.excel.EasyExcel;
+import com.alibaba.excel.context.AnalysisContext;
+import com.alibaba.excel.event.AnalysisEventListener;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.toolkit.StringUtils;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.example.jz.dao.*;
+import com.example.jz.enums.CauseEnums;
+import com.example.jz.exception.BusinessException;
 import com.example.jz.modle.PageParam;
 import com.example.jz.modle.dto.AddReportDto;
 import com.example.jz.modle.dto.CauseDto;
+import com.example.jz.modle.dto.CauseLoadDto;
 import com.example.jz.modle.entity.*;
-import com.example.jz.modle.vo.AnnouncementVo;
 import com.example.jz.modle.vo.CauseReportVo;
 import com.example.jz.modle.vo.CauseVo;
 import com.example.jz.modle.vo.UserVo;
 import com.example.jz.service.CauseService;
+import lombok.SneakyThrows;
 import org.springframework.beans.BeanUtils;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.multipart.MultipartFile;
 
 import javax.annotation.Resource;
-import java.util.Date;
-import java.util.List;
+import java.util.*;
 import java.util.stream.Collectors;
 
 /**
- * 锟斤拷锟斤拷锟斤拷(Cause)锟斤拷锟斤拷锟绞碉拷锟斤拷锟�
+ * 妗堜欢琛�(Cause)琛ㄦ湇鍔″疄鐜扮被
  *
  * @author makejava
  * @since 2022-07-13 11:52:58
@@ -56,7 +62,7 @@
         BeanUtils.copyProperties(causeDto, cause);
         cause.setCtime(new Date());
         causeService.save(cause);
-        //锟斤拷锟斤拷群锟斤拷
+        //鍒涘缓缇ょ粍
         Group group = new Group();
         group.setCtime(new Date());
         group.setGroupName(causeDto.getName());
@@ -119,8 +125,10 @@
     }
 
     @Override
-    public List<CauseReportVo> getReporterList(Integer causeId) {
-        return reportDao.selectList(new QueryWrapper<Report>().eq("cause_id", causeId)).stream()
+    public PageParam<CauseReportVo> getReporterList(Integer causeId) {
+        PageParam<Report> PageParam = new PageParam<>();
+        PageParam<Report> reportPageParam = reportDao.selectPage(PageParam, new QueryWrapper<Report>().eq("cause_id", causeId));
+        reportPageParam.getRecords().stream()
                 .map(
                         a -> {
                             CauseReportVo causeReportVo = new CauseReportVo();
@@ -133,23 +141,81 @@
                             return causeReportVo;
                         }
                 ).collect(Collectors.toList());
+        PageParam<CauseReportVo> causeReportVoPageParam = new PageParam<>();
+        BeanUtils.copyProperties(reportPageParam, causeReportVoPageParam);
+        return causeReportVoPageParam;
     }
 
     @Override
-    public List<AnnouncementVo> getGroupAnnouncement(Integer groupId) {
-        return announcementDao.selectList(new QueryWrapper<Announcement>().eq("group_id", groupId)).stream()
-                .map(
-                        a -> {
-                            AnnouncementVo announcementVo = new AnnouncementVo();
-                            BeanUtils.copyProperties(a, announcementVo);
-                            return announcementVo;
-                        }
-                ).collect(Collectors.toList());
+    public List<Announcement> getGroupAnnouncement(Integer groupId) {
+        return announcementDao.selectList(new QueryWrapper<Announcement>().eq("group_id", groupId));
     }
 
     @Override
     public void deleteCause(Integer id) {
         causeDao.deleteById(id);
+        groupDao.delete(new QueryWrapper<Group>().eq("cause_id", id));
+    }
+
+    @Override
+    @SneakyThrows
+    @Transactional(rollbackFor = BusinessException.class)
+    public void loadFile(MultipartFile multipartFile) {
+        ArrayList<CauseLoadDto> causeLoadDtos = new ArrayList<>();
+        EasyExcel.read(multipartFile.getInputStream(), CauseLoadDto.class, new AnalysisEventListener<CauseLoadDto>() {
+                    @Override
+                    public void invoke(CauseLoadDto data, AnalysisContext context) {
+                        if (StringUtils.isNotBlank(data.getName()) && StringUtils.isNotBlank(data.getUserName())) {
+                            causeLoadDtos.add(data);
+                        }
+                    }
+
+                    @Override
+                    public void doAfterAllAnalysed(AnalysisContext analysisContext) {
+
+                    }
+                })
+                .autoCloseStream(true)
+                .doReadAll();
+        causeLoadDtos.forEach(
+                a -> {
+                    Cause cause = new Cause();
+                    BeanUtils.copyProperties(a, cause);
+                    if (StringUtils.isBlank(a.getStatus())) {
+                        throw new BusinessException("鐘舵�佷笉鑳戒负绌�");
+                    }
+                    if (a.getStatus().equals(CauseEnums.UNCHECKED.getMsg())) {
+                        cause.setStatus(CauseEnums.UNCHECKED.value());
+                    }
+                    if (a.getStatus().equals(CauseEnums.NOTTOPUTONRECORD.getMsg())) {
+                        cause.setStatus(CauseEnums.NOTTOPUTONRECORD.value());
+                    }
+                    if (a.getStatus().equals(CauseEnums.UNDERCONSIDERATION.getMsg())) {
+                        cause.setStatus(CauseEnums.UNDERCONSIDERATION.value());
+                    }
+                    if (a.getStatus().equals(CauseEnums.CASECLOSED.getMsg())) {
+                        cause.setStatus(CauseEnums.CASECLOSED.value());
+                    }
+                    if (a.getStatus().equals(CauseEnums.HASBEENDROPPED.getMsg())) {
+                        cause.setStatus(CauseEnums.HASBEENDROPPED.value());
+                    }
+                    cause.setCtime(new Date());
+                    if (StringUtils.isBlank(a.getUserName())) {
+                        throw new BusinessException("璐熻矗浜轰笉鍏佽涓虹┖");
+                    }
+                    if (userDao.selectOne(new QueryWrapper<User>().eq("real_name", a.getUserName())) == null) {
+                        throw new BusinessException("璐熻矗浜轰笉瀛樺湪");
+                    }
+                    Integer id = userDao.selectOne(new QueryWrapper<User>().eq("real_name", a.getUserName())).getId();
+                    cause.setUserId(id);
+                    causeService.save(cause);
+                    Group group = new Group();
+                    group.setCtime(new Date());
+                    group.setUserId(id);
+                    group.setGroupName(a.getName());
+                    group.setCauseId(cause.getId());
+                    groupDao.insert(group);
+                });
     }
 
     @Override
@@ -176,4 +242,16 @@
                 .setCauseId(groupDao.selectOne(new QueryWrapper<Group>().eq("id", addReportDto.getGroupId())).getCauseId());
         return reportDao.insert(report) > 0;
     }
+
+    @Override
+    public List<Map<String, String>> getCauseIdAndName() {
+        ArrayList<Map<String, String>> maps = new ArrayList<>();
+        causeDao.selectList(null).stream().forEach(a -> {
+            Map<String, String> map = new HashMap<>();
+            map.put("id", a.getId().toString());
+            map.put("name", a.getName());
+            maps.add(map);
+        });
+        return maps;
+    }
 }
\ No newline at end of file

--
Gitblit v1.8.0