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 | 171 ++++++++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 156 insertions(+), 15 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 1e0d780..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,28 +1,32 @@
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.CauseDao;
-import com.example.jz.dao.GroupDao;
-import com.example.jz.dao.ReportDao;
-import com.example.jz.dao.UserDao;
+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.entity.Cause;
-import com.example.jz.modle.entity.Group;
-import com.example.jz.modle.entity.Report;
-import com.example.jz.modle.entity.User;
+import com.example.jz.modle.dto.CauseLoadDto;
+import com.example.jz.modle.entity.*;
+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.ArrayList;
-import java.util.Date;
-import java.util.List;
+import java.util.*;
import java.util.stream.Collectors;
/**
@@ -44,10 +48,16 @@
CauseService causeService;
@Resource
GroupDao groupDao;
+ @Resource
+ GroupUserDao groupUserDao;
+
+ @Resource
+ AnnouncementDao announcementDao;
@Override
+ @Transactional(rollbackFor = Exception.class)
public Integer addCause(CauseDto causeDto) {
- //鍒涘缓妗堜欢
+ //锟斤拷锟斤拷锟斤拷锟斤拷
Cause cause = new Cause();
BeanUtils.copyProperties(causeDto, cause);
cause.setCtime(new Date());
@@ -87,6 +97,7 @@
BeanUtils.copyProperties(a, causeVo);
causeVo.setUserName(userDao.selectOne(new QueryWrapper<User>().eq("id", a.getUserId())).getRealName());
causeVo.setReportNumber(reportDao.selectCount(new QueryWrapper<Report>().eq("cause_id", a.getId())));
+ causeVo.setGroupId(groupDao.selectOne(new QueryWrapper<Group>().eq("cause_id", a.getId())).getId());
return causeVo;
}).collect(Collectors.toList());
PageParam<CauseVo> causeVoPageParam = new PageParam<>();
@@ -106,11 +117,141 @@
}
@Override
- public Integer updateCause(CauseDto causeDto,Integer id) {
+ public Integer updateCause(CauseDto causeDto, Integer id) {
Cause cause = new Cause();
- BeanUtils.copyProperties(causeDto,cause);
+ BeanUtils.copyProperties(causeDto, cause);
cause.setId(id);
return causeDao.updateById(cause);
}
-}
+ @Override
+ 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();
+ User user = userDao.selectOne(new QueryWrapper<User>().eq("id", a.getUserId()));
+ BeanUtils.copyProperties(a, causeReportVo);
+ causeReportVo.setUserIdcard(user.getUserIdcard());
+ causeReportVo.setUserMobile(user.getUserMobile());
+ causeReportVo.setUserIdcard(causeReportVo.getUserIdcard().replaceAll("(?<=[\\d]{3})\\d(?=[\\d]{4})", "*"));
+ causeReportVo.setUserName(user.getRealName());
+ return causeReportVo;
+ }
+ ).collect(Collectors.toList());
+ PageParam<CauseReportVo> causeReportVoPageParam = new PageParam<>();
+ BeanUtils.copyProperties(reportPageParam, causeReportVoPageParam);
+ return causeReportVoPageParam;
+ }
+
+ @Override
+ 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
+ @Transactional
+ public Boolean addReportPeople(AddReportDto addReportDto) {
+ User user = userDao.selectOne(new LambdaQueryWrapper<User>(User.class).eq(User::getUserIdcard, addReportDto.getIdcard()));
+ if (user == null) {
+ // 濡傛灉鐢ㄦ埛涓嶅瓨鍦� 鍒欐坊鍔犵敤鎴�
+ user = new User().setUserIdcard(addReportDto.getIdcard()).setUserMobile(addReportDto.getMobile()).setRealName(addReportDto.getReporterName())
+ .setModifyTime(new Date()).setUserRegtime(new Date()).setPic(addReportDto.getPic());
+ userDao.insert(user);
+ }
+ // 娣诲姞浜哄憳杩涚兢缁�
+ groupUserDao.insert(new GroupUser().setGroupId(addReportDto.getGroupId()).setUserId(user.getId()).setCtime(new Date()).setBanSpeech(0));
+ // 娣诲姞鎶ユ淇℃伅
+ Report report = new Report();
+ BeanUtils.copyProperties(addReportDto, report);
+ report
+ .setUserId(user.getId())
+ .setCtime(new Date())
+ .setStatus(0)
+ .setReportMethod("鐜板満褰曞叆")
+ .setIsCommission("0").setReportTime(new Date())
+ .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