青羊经侦大队-数据平台
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
baizonghao
2023-03-21 d20d3b8e9add900543a6bb3b18cea2311263ee1f 
 src/main/java/com/example/jz/service/impl/ReportServiceImpl.java


@@ -1,6 +1,8 @@


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.alibaba.excel.metadata.data.ImageData;


import com.alibaba.excel.metadata.data.WriteCellData;


import com.alibaba.excel.util.IoUtils;


@@ -12,19 +14,23 @@


import com.example.jz.dao.*;


import com.example.jz.modle.PageParam;


import com.example.jz.modle.dto.AddReportDto;


import com.example.jz.modle.dto.AddReportLoadDto;


import com.example.jz.modle.dto.ReportParamDto;


import com.example.jz.modle.entity.*;


import com.example.jz.modle.vo.ExportExcelReportVo;


import com.example.jz.modle.vo.ReportListVo;


import com.example.jz.modle.vo.ReportVXVO;


import com.example.jz.service.MinIOService;


import com.example.jz.service.ReportService;


import com.example.jz.service.UserService;


import lombok.SneakyThrows;


import org.springframework.beans.BeanUtils;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.context.annotation.Bean;


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


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


import org.springframework.web.multipart.MultipartFile;




import javax.annotation.Resource;


import javax.servlet.http.HttpServletResponse;


@@ -34,9 +40,10 @@


import java.time.LocalDateTime;


import java.time.format.DateTimeFormatter;


import java.util.ArrayList;


import java.util.Comparator;


import java.util.Date;


import java.util.List;


import java.util.function.Consumer;


import java.util.stream.Collectors;




/**


 * 报案表(Report)表服务实现类


@@ -74,16 +81,19 @@


     * @return


     */


    @Override


    @Transactional


    @Transactional(rollbackFor = Exception.class)


    public Boolean audit(Report report) {


        // 1. 更新报案表


        report.setStatus(1);


        report.setIsInGroup(1);


        reportDao.updateById(report);


        // 2. 更新群用户表


        Group group = groupDao.selectOne(new LambdaQueryWrapper<>(Group.class)


                .eq(Group::getCauseId, report.getCauseId()));


        GroupUser groupUser = new GroupUser().setGroupId(group.getId()).setUserId(report.getId()).setCtime(new Date()).setBanSpeech(0);


        groupUserDao.insert(groupUser);


        if (!groupUserDao.selectUserList(group.getId()).contains(report.getUserId())) {


            GroupUser groupUser = new GroupUser().setGroupId(group.getId()).setUserId(report.getId()).setCtime(new Date()).setBanSpeech(0);


            return groupUserDao.insert(groupUser) == 1 ? true : false;


        }


        return true;


    }




@@ -96,67 +106,67 @@


        groupUserDao.delete(new QueryWrapper<GroupUser>().eq("user_id", id).eq("group_id", groupId));


    }




    @Override


    @SneakyThrows


    public void exportReporter(Integer id, HttpServletResponse response) {


        //查询报案人相关信息通过案件


        List<Report> reports = reportDao.selectList(new QueryWrapper<Report>().eq("cause_id", id).orderByDesc());


        ArrayList<ExportExcelReportVo> exportExcelReportVos = new ArrayList<>();


        reports.forEach(


                a -> {


                    ExportExcelReportVo exportExcelReportVo = new ExportExcelReportVo();


                    User user = userDao.selectOne(new QueryWrapper<User>().eq("id", a.getUserId()));


                    BeanUtils.copyProperties(a, exportExcelReportVo);


                    exportExcelReportVo.setUserIdcard(user.getUserIdcard());


                    exportExcelReportVo.setUserMobile(user.getUserMobile());


                    exportExcelReportVo.setRealName(user.getRealName());


                    WriteCellData<List<ImageData>> objectWriteCellData = new WriteCellData<>();


                    ArrayList<ImageData> imageDataList = new ArrayList<>();


                    if (StringUtils.isNotBlank(a.getReportMaterials())) {


                        String[] urls = a.getReportMaterials().split(",");


                        if (urls.length == 1) {


                            int width = 600;


                            try {


                                ImageData imageData = new ImageData();


                                imageData.setImage(IoUtils.toByteArray(new URL(minIOService.getPreviewFileUrl(urls[0])).openConnection().getInputStream()));


                                imageData.setRight(width / 2);


                                imageDataList.add(imageData);


                            } catch (Exception e) {


                                throw new RuntimeException(e);


                            }


                        } else {


                            for (int i = 0; i < urls.length; i++) {


                                int width = 600;


                                try {


                                    ImageData imageData = new ImageData();


                                    imageData.setImage(IoUtils.toByteArray(new URL(minIOService.getPreviewFileUrl(urls[i])).openConnection().getInputStream()));


                                    imageData.setLeft(width / urls.length * i);


                                    imageData.setRight(width - width / urls.length * (i + 1));


                                    imageDataList.add(imageData);


                                } catch (Exception e) {


                                    throw new RuntimeException(e);


                                }


                            }


                        }


                    }


                    objectWriteCellData.setImageDataList(imageDataList);


                    exportExcelReportVo.setWriteCellData(objectWriteCellData);


                    exportExcelReportVos.add(exportExcelReportVo);


                }


        );


        String name = causeDao.selectOne(new QueryWrapper<Cause>().eq("id", id)).getName();


        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");


        response.setCharacterEncoding("utf-8");


        response.setHeader("Content-disposition", "attachment;filename=" + LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) + URLEncoder.encode(name + ".xlsx", "utf-8"));


        EasyExcel.write(response.getOutputStream(), ExportExcelReportVo.class).sheet("材料导出").doWrite(exportExcelReportVos);


    }


//    @Override


//    @SneakyThrows


//    public void exportReporter(Integer id, HttpServletResponse response) {


//        //查询报案人相关信息通过案件


//        List<Report> reports = reportDao.selectList(new QueryWrapper<Report>().eq("cause_id", id).orderByDesc());


//        ArrayList<ExportExcelReportVo> exportExcelReportVos = new ArrayList<>();


//        reports.forEach(


//                new Consumer<Report>() {


//                    @Override


//                    public void accept(Report a) {


//                        ExportExcelReportVo exportExcelReportVo = new ExportExcelReportVo();


//                        User user = userDao.selectOne(new QueryWrapper<User>().eq("id", a.getUserId()));


//                        BeanUtils.copyProperties(a, exportExcelReportVo);


//                        exportExcelReportVo.setUserIdcard(user.getUserIdcard());


//                        exportExcelReportVo.setUserMobile(user.getUserMobile());


//                        exportExcelReportVo.setRealName(user.getRealName());


//                        WriteCellData<List<ImageData>> objectWriteCellData = new WriteCellData<>();


//                        ArrayList<ImageData> imageDataList = new ArrayList<>();


//                        if (StringUtils.isNotBlank(a.getReportMaterials())) {


//                            String[] urls = a.getReportMaterials().split(",");


//                            if (urls.length == 1) {


//                                int width = 600;


//                                try {


//                                    ImageData imageData = new ImageData();


//                                    imageData.setImage(IoUtils.toByteArray(new URL(minIOService.getPreviewFileUrl(urls[0])).openConnection().getInputStream()));


//                                    imageData.setRight(width / 2);


//                                    imageDataList.add(imageData);


//                                } catch (Exception e) {


//                                    throw new RuntimeException(e);


//                                }


//                            } else {


//                                for (int i = 0; i < urls.length; i++) {


//                                    int width = 600;


//                                    try {


//                                        ImageData imageData = new ImageData();


//                                        imageData.setImage(IoUtils.toByteArray(new URL(minIOService.getPreviewFileUrl(urls[i])).openConnection().getInputStream()));


//                                        imageData.setLeft(width / urls.length * i);


//                                        imageData.setRight(width - width / urls.length * (i + 1));


//                                        imageDataList.add(imageData);


//                                    } catch (Exception e) {


//                                        throw new RuntimeException(e);


//                                    }


//                                }


//                            }


//                        }


//                        objectWriteCellData.setImageDataList(imageDataList);


//                        exportExcelReportVo.setWriteCellData(objectWriteCellData);


//                        exportExcelReportVos.add(exportExcelReportVo);


//                    }


//                }


//        );


//        String name = causeDao.selectOne(new QueryWrapper<Cause>().eq("id", id)).getName();


//        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");


//        response.setCharacterEncoding("utf-8");


//        response.setHeader("Content-disposition", "attachment;filename=" + LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) + URLEncoder.encode(name + ".xlsx", "utf-8"));


//        EasyExcel.write(response.getOutputStream(), ExportExcelReportVo.class).sheet("材料导出").doWrite(exportExcelReportVos);


//    }




    @Override


    public Page<ReportListVo> getPage(Page<ReportListVo> page, ReportParamDto reportParamDto) {


        Page<ReportListVo> aaa = reportDao.getPage(page, reportParamDto);


        aaa.getRecords().stream()


                .forEach(x -> x.setIdcard(x.getIdcard().replaceAll("(?<=[\\d]{3})\\d(?=[\\d]{4})", "*")));


        return aaa;


        return reportDao.getPage(page, reportParamDto);


    }




    @Override


@@ -206,9 +216,65 @@


                .setCtime(new Date())


                .setStatus(0)


                .setIsInGroup(0)


                .setReportMethod("现场录入")


                .setIsCommission("0").setReportTime(new Date())


                .setReportMethod("现场报案")


                .setIsCommission("0")


                .setReportTime(new Date())


                .setCauseId(addReportDto.getCauseId());


        return reportService.save(report);


    }




    @Override


    public List<Report> listGroup(Integer id) {


        return reportDao.selectListGroup(id);


    }




    @Override


    @SneakyThrows


    public void loadFileReport(MultipartFile multipartFile, Integer causeId) {


        EasyExcel.read(multipartFile.getInputStream(), AddReportLoadDto.class, new AnalysisEventListener<AddReportLoadDto>() {


                    @Override


                    public void invoke(AddReportLoadDto data, AnalysisContext context) {


                        if (com.baomidou.mybatisplus.core.toolkit.StringUtils.isNotBlank(data.getReporterName()) && com.baomidou.mybatisplus.core.toolkit.StringUtils.isNotBlank(data.getIdcard())) {


                            AddReportDto addReportDto = new AddReportDto();


                            BeanUtils.copyProperties(data, addReportDto);


                            addReportDto.setCauseId(causeId);


                            addReport(addReportDto);


                        }




                    }




                    @Override


                    public void doAfterAllAnalysed(AnalysisContext context) {




                    }


                })


                .autoCloseStream(true)


                .doReadAll();


    }




    @Override


    @Transactional(rollbackFor = Exception.class)


    public Boolean reject(Integer id, String reason) {


        Report report = reportDao.selectReportByReportId(id);


        // 1. 更新报案表


        report.setStatus(2);


        report.setIsInGroup(2);


        report.setRemarks(reason);


        reportDao.updateById(report);


        return true;


    }




    @Override


    public ReportVXVO getRejectReportById(Integer id) {


        ReportVXVO reportVXVO = new ReportVXVO();


        Report report = reportDao.selectOne(new LambdaQueryWrapper<Report>().eq(Report::getId, id));


        User user = userDao.selectOne(new LambdaQueryWrapper<User>().eq(User::getId, report.getUserId()));


        BeanUtils.copyProperties(report, reportVXVO);


        reportVXVO.setLocation(user.getLocation());


        reportVXVO.setWorkingLocation(user.getWorkingLocation());


        reportVXVO.setSex(user.getSex());


        reportVXVO.setRealName(user.getRealName());


        reportVXVO.setUserIdCard(user.getUserIdcard());


        return reportVXVO;


    }


}