值班表导入bug修改

tangxiaobao

2021-08-04 aa76c2b0bb73e9fe463387fb5656ea80094eceec

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComSwDangerReportServiceImpl.java

@@ -73,10 +73,48 @@
        IPage<ComSwDangerReportVO> iPage = comSwDangerReportDAO.pageDangerReport(page, comSwPatrolRecordPageDTO);
        if (!iPage.getRecords().isEmpty()) {
            iPage.getRecords().forEach(comSwDangerReportVO -> {
                if (StringUtils.isNotEmpty(comSwDangerReportVO.getAssignPerson())) {
                    comSwDangerReportVO.setIsAssign(ComSwDangerReportVO.isOk.no);
                }else {
                if (StringUtils.isNotEmpty(comSwDangerReportVO.getStatus()) && "2".equals(comSwDangerReportVO.getStatus())) {
                    comSwDangerReportVO.setIsAssign(ComSwDangerReportVO.isOk.yes);
                }else {
                    comSwDangerReportVO.setIsAssign(ComSwDangerReportVO.isOk.no);
                }
                StringBuilder patrolNameString = new StringBuilder();
                StringBuilder patrolPhoneString = new StringBuilder();
                //巡查人员id查询巡查人员的名字和电话
                if(StringUtils.isNotEmpty(comSwDangerReportVO.getPatrolPerson())){
                    String[] patrolIds = comSwDangerReportVO.getPatrolPerson().split(",");
                    for (int i = 0; i < patrolIds.length ; i++) {
                        Map<String,String> leader = comSwPatrolRecordDAO.getPbServiceTeamById(patrolIds[i]);
                        if(leader != null){
                            if(i != 0){
                                patrolNameString.append(",");
                                patrolPhoneString.append(",");
                            }
                            patrolNameString.append(leader.get("name"));
                            patrolPhoneString.append(leader.get("phone"));
                        }
                    }
                    comSwDangerReportVO.setPPersonName(patrolNameString.toString());
                    comSwDangerReportVO.setPPersonPhone(patrolPhoneString.toString());
                }
                //整改人员id查询整改人员的名字和电话
                StringBuilder dangerNameString = new StringBuilder();
                StringBuilder dangerPhoneString = new StringBuilder();
                if(StringUtils.isNotEmpty(comSwDangerReportVO.getRectifyPerson())){
                    String[] dangerIds = comSwDangerReportVO.getRectifyPerson().split(",");
                    for (int i = 0; i < dangerIds.length ; i++) {
                        Map<String,String> person = comSwPatrolRecordDAO.getPbServiceTeamById(dangerIds[i]);
                        if(person != null){
                            if(i != 0){
                                dangerNameString.append(",");
                                dangerPhoneString.append(",");
                            }
                            dangerNameString.append(person.get("name"));
                            dangerPhoneString.append(person.get("phone"));
                        }
                    }
                    comSwDangerReportVO.setDPersonName(dangerNameString.toString());
                    comSwDangerReportVO.setDPersonPhone(dangerPhoneString.toString());
                }
            });
        }
@@ -116,7 +154,7 @@
            comSwDangerReportVO.setPatrolType(sb.toString());
        }

        //查询人员信息
        //查询整改人员信息
        if(StringUtils.isNotEmpty(comSwDangerReportVO.getRectifyPerson())){
            StringBuilder sb = new StringBuilder();
            String personIds[] = comSwDangerReportVO.getRectifyPerson().split(",");
@@ -153,10 +191,43 @@
            comSwDangerReportVO.setAssignPersonName(sb.toString());
        }

        //查询巡查人员
        Map<String,String> map = comSwPatrolRecordDAO.getPatrolPersonName(comSwDangerReportVO.getId());
        if(map != null){
            comSwDangerReportVO.setPatrolName(map.get("person_name"));
        StringBuilder patrolNameString = new StringBuilder();
        StringBuilder patrolPhoneString = new StringBuilder();
        //巡查人员id查询巡查人员的名字和电话
        if(StringUtils.isNotEmpty(comSwDangerReportVO.getPatrolPerson())){
            String[] patrolIds = comSwDangerReportVO.getPatrolPerson().split(",");
            for (int i = 0; i < patrolIds.length ; i++) {
                Map<String,String> leader = comSwPatrolRecordDAO.getPbServiceTeamById(patrolIds[i]);
                if(leader != null){
                    if(i != 0){
                        patrolNameString.append(",");
                        patrolPhoneString.append(",");
                    }
                    patrolNameString.append(leader.get("name"));
                    patrolPhoneString.append(leader.get("phone"));
                }
            }
            comSwDangerReportVO.setPPersonName(patrolNameString.toString());
            comSwDangerReportVO.setPPersonPhone(patrolPhoneString.toString());
        }
        //整改人员id查询整改人员的名字和电话
        StringBuilder dangerNameString = new StringBuilder();
        StringBuilder dangerPhoneString = new StringBuilder();
        if(StringUtils.isNotEmpty(comSwDangerReportVO.getRectifyPerson())){
            String[] dangerIds = comSwDangerReportVO.getRectifyPerson().split(",");
            for (int i = 0; i < dangerIds.length ; i++) {
                Map<String,String> person = comSwPatrolRecordDAO.getPbServiceTeamById(dangerIds[i]);
                if(person != null){
                    if(i != 0){
                        dangerNameString.append(",");
                        dangerPhoneString.append(",");
                    }
                    dangerNameString.append(person.get("name"));
                    dangerPhoneString.append(person.get("phone"));
                }
            }
            comSwDangerReportVO.setDPersonName(dangerNameString.toString());
            comSwDangerReportVO.setDPersonPhone(dangerPhoneString.toString());
        }

        return R.ok(comSwDangerReportVO);
@@ -178,6 +249,44 @@
            BeanUtils.copyProperties(comSwDangerReportDO, comSwDangerReportVO);
        }
        BeanUtils.copyProperties(comSwPatrolRecordDO, comSwDangerReportVO);
        StringBuilder patrolNameString = new StringBuilder();
        StringBuilder patrolPhoneString = new StringBuilder();
        //巡查人员id查询巡查人员的名字和电话
        if(StringUtils.isNotEmpty(comSwDangerReportVO.getPatrolPerson())){
            String[] patrolIds = comSwDangerReportVO.getPatrolPerson().split(",");
            for (int i = 0; i < patrolIds.length ; i++) {
                Map<String,String> leader = comSwPatrolRecordDAO.getPbServiceTeamById(patrolIds[i]);
                if(leader != null){
                    if(i != 0){
                        patrolNameString.append(",");
                        patrolPhoneString.append(",");
                    }
                    patrolNameString.append(leader.get("name"));
                    patrolPhoneString.append(leader.get("phone"));
                }
            }
            comSwDangerReportVO.setPPersonName(patrolNameString.toString());
            comSwDangerReportVO.setPPersonPhone(patrolPhoneString.toString());
        }
        //整改人员id查询整改人员的名字和电话
        StringBuilder dangerNameString = new StringBuilder();
        StringBuilder dangerPhoneString = new StringBuilder();
        if(StringUtils.isNotEmpty(comSwDangerReportVO.getRectifyPerson())){
            String[] dangerIds = comSwDangerReportVO.getRectifyPerson().split(",");
            for (int i = 0; i < dangerIds.length ; i++) {
                Map<String,String> person = comSwPatrolRecordDAO.getPbServiceTeamById(dangerIds[i]);
                if(person != null){
                    if(i != 0){
                        dangerNameString.append(",");
                        dangerPhoneString.append(",");
                    }
                    dangerNameString.append(person.get("name"));
                    dangerPhoneString.append(person.get("phone"));
                }
            }
            comSwDangerReportVO.setDPersonName(dangerNameString.toString());
            comSwDangerReportVO.setDPersonPhone(dangerPhoneString.toString());
        }
        return R.ok(comSwDangerReportVO);
    }

@@ -214,15 +323,15 @@
    @Override
    public R exportDangerReport(List<Long> dangerReportIds) {
        List<ComSwDangerReportExcelVO> list = comSwDangerReportDAO.exportDangerReport(dangerReportIds);
        list.forEach(comSwDangerReportExcelVO -> {
            List<String> patrolUserIds = Arrays.asList(comSwDangerReportExcelVO.getPatrolPerson().split(","));
            List<String> patrolPhones = new ArrayList<>();
            for (String userId : patrolUserIds) {
                LoginUserInfoVO loginUserInfoVO = userService.getUserInfoByUserId(userId).getData();
                patrolPhones.add(loginUserInfoVO.getPhone());
            }
            comSwDangerReportExcelVO.setPatrolPersonPhone(StringUtils.join(patrolPhones,","));
        });
//        list.forEach(comSwDangerReportExcelVO -> {
//            List<String> patrolUserIds = Arrays.asList(comSwDangerReportExcelVO.getPatrolPerson().split(","));
//            List<String> patrolPhones = new ArrayList<>();
//            for (String userId : patrolUserIds) {
//                LoginUserInfoVO loginUserInfoVO = userService.getUserInfoByUserId(userId).getData();
//                patrolPhones.add(loginUserInfoVO.getPhone());
//            }
//            comSwDangerReportExcelVO.setPatrolPersonPhone(StringUtils.join(patrolPhones,","));
//        });
        return R.ok(list);
    }
}