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