| | |
| | | import com.panzhihua.sangeshenbian.model.entity.*; |
| | | import com.panzhihua.sangeshenbian.model.excel.ComplaintExcel; |
| | | import com.panzhihua.sangeshenbian.model.query.AnalyticStatisticsQuery; |
| | | import com.panzhihua.sangeshenbian.model.query.AppStaticsQuery; |
| | | import com.panzhihua.sangeshenbian.model.query.BasePage; |
| | | import com.panzhihua.sangeshenbian.model.query.ComplaintQuery; |
| | | import com.panzhihua.sangeshenbian.model.vo.*; |
| | |
| | | // } |
| | | |
| | | |
| | | |
| | | |
| | | // //已办结,显示评价按钮 |
| | | // int count = complaintCommentService.count(new LambdaQueryWrapper<ComplaintComment>().eq(ComplaintComment::getComplaintId, detail.getId()).eq(ComplaintComment::getDelFlag, 0)); |
| | | // if(detail.getStatus() == 3 && 0 == count){ |
| | |
| | | complaintAuditRecord.setReporterLevel(reporterLevel); |
| | | complaintAuditRecord.setReporterId(reporterId); |
| | | complaintAuditRecord.setApplyName(reporter); |
| | | complaintAuditRecord.setApplyPhone(phone); |
| | | complaintAuditRecordService.save(complaintAuditRecord); |
| | | } |
| | | |
| | |
| | | record1.setDepartmentName(departmentName); |
| | | // 冗余申请人名称 |
| | | record1.setApplyName(reporter); |
| | | record1.setApplyPhone(loginUserInfoVO.getPhone()); |
| | | complaintAuditRecordService.save(record1); |
| | | } |
| | | |
| | |
| | | complaintVO.setComplaintComment(comment); |
| | | ArrayList<String> voiceFileList = new ArrayList<>(); |
| | | String voiceFile = complaint.getVoiceFile(); |
| | | if(StringUtils.isNotEmpty(voiceFile)){ |
| | | for (String file :voiceFile.split(",")) { |
| | | if (StringUtils.isNotEmpty(voiceFile)) { |
| | | for (String file : voiceFile.split(",")) { |
| | | voiceFileList.add(file); |
| | | } |
| | | } |
| | |
| | | public void updateProgress(ComplaintProcessUpdateDto dto) { |
| | | complaintProgressService.update(new LambdaUpdateWrapper<ComplaintProgress>().eq(ComplaintProgress::getId, dto.getId()) |
| | | .set(ComplaintProgress::getDescribe, dto.getDescribe()).set(ComplaintProgress::getImgUrl, dto.getImgUrl()) |
| | | .set(ComplaintProgress::getVideo, dto.getVideo()) ) ; |
| | | .set(ComplaintProgress::getVideo, dto.getVideo())); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public void delProgress(Long id) { |
| | | complaintProgressService.removeById(id); |
| | | complaintProgressService.removeById(id); |
| | | } |
| | | |
| | | @Override |
| | | public AnalyticStatisticsOneVo analyticStatisticsOne(AnalyticStatisticsQuery query,List<Complaint> complaints, SimpleDateFormat simpleDateFormat) { |
| | | public AnalyticStatisticsOneVo analyticStatisticsOne(AnalyticStatisticsQuery query, List<Complaint> complaints, SimpleDateFormat simpleDateFormat) { |
| | | String nowYearMonth; |
| | | String lastYearMonth; |
| | | int value = LocalDate.now().getMonth().getValue(); |
| | | if(value<10){ |
| | | if (value < 10) { |
| | | nowYearMonth = LocalDate.now().getYear() + "-0" + LocalDate.now().getMonth().getValue(); |
| | | }else { |
| | | } else { |
| | | nowYearMonth = LocalDate.now().getYear() + "-" + LocalDate.now().getMonth().getValue(); |
| | | } |
| | | int value1 = LocalDate.now().minusMonths(1).getMonth().getValue(); |
| | | if(value1<10){ |
| | | if (value1 < 10) { |
| | | lastYearMonth = LocalDate.now().minusMonths(1).getYear() + "-0" + LocalDate.now().minusMonths(1).getMonth().getValue(); |
| | | }else { |
| | | } else { |
| | | lastYearMonth = LocalDate.now().minusMonths(1).getYear() + "-" + LocalDate.now().minusMonths(1).getMonth().getValue(); |
| | | } |
| | | |
| | |
| | | vo.setAllTotal(complaints.size()); |
| | | |
| | | // 诉求单量本月 |
| | | int thisMonthTotal = (int)complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(nowYearMonth)).count(); |
| | | vo.setThisMonthTotal( thisMonthTotal); |
| | | int thisMonthTotal = (int) complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(nowYearMonth)).count(); |
| | | vo.setThisMonthTotal(thisMonthTotal); |
| | | |
| | | // 诉求单量同比上月 |
| | | int lastMonthTotal = (int)complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(lastYearMonth)).count(); |
| | | vo.setLastMonthCompareTotal(thisMonthTotal- lastMonthTotal); |
| | | int lastMonthTotal = (int) complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(lastYearMonth)).count(); |
| | | vo.setLastMonthCompareTotal(thisMonthTotal - lastMonthTotal); |
| | | |
| | | // 正在办理 |
| | | int nowTransactTotal = (int) complaints.stream().filter(e -> e.getStatus() == 0).count(); |
| | |
| | | |
| | | // 超时办理同比上月 |
| | | int lastMonthOvertimeTransactTotal = (int) overtimeComplaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(lastYearMonth)).count(); |
| | | vo.setLastMonthOvertimeTransactCompareTotal(thisMonthOvertimeTransactTotal-lastMonthOvertimeTransactTotal); |
| | | vo.setLastMonthOvertimeTransactCompareTotal(thisMonthOvertimeTransactTotal - lastMonthOvertimeTransactTotal); |
| | | |
| | | // 平均处理时长 |
| | | if(complaints.size()>0) { |
| | | if (complaints.size() > 0) { |
| | | double averageDay = complaints.stream().mapToDouble(v -> v.getHandlingDay() == null ? 0 : v.getHandlingDay()).average().getAsDouble(); |
| | | averageDay = BigDecimal.valueOf(averageDay).setScale(2, RoundingMode.HALF_UP).doubleValue(); |
| | | vo.setAverageTime(averageDay); |
| | | |
| | | List<Complaint> thisMonthAverageTimeComplaints = complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(nowYearMonth)).collect(Collectors.toList()); |
| | | if(thisMonthAverageTimeComplaints.size()>0){ |
| | | if (thisMonthAverageTimeComplaints.size() > 0) { |
| | | double thisMonthAverageTime = thisMonthAverageTimeComplaints.stream().mapToDouble(v -> v.getHandlingDay() == null ? 0 : v.getHandlingDay()).average().getAsDouble(); |
| | | thisMonthAverageTime = BigDecimal.valueOf(thisMonthAverageTime).setScale(2, RoundingMode.HALF_UP).doubleValue(); |
| | | vo.setThisMonthAverageTime(thisMonthAverageTime); |
| | | } |
| | | List<Complaint> lastMonthAverageTimeComplaints = complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(lastYearMonth)).collect(Collectors.toList()); |
| | | if(lastMonthAverageTimeComplaints.size()>0){ |
| | | if (lastMonthAverageTimeComplaints.size() > 0) { |
| | | double lastMonthAverageTime = lastMonthAverageTimeComplaints.stream().mapToDouble(v -> v.getHandlingDay() == null ? 0 : v.getHandlingDay()).average().getAsDouble(); |
| | | lastMonthAverageTime = BigDecimal.valueOf(lastMonthAverageTime).setScale(2, RoundingMode.HALF_UP).doubleValue(); |
| | | vo.setAverageTime(vo.getThisMonthAverageTime() - lastMonthAverageTime); |
| | | vo.setLastMonthCompareAverageTime(vo.getThisMonthAverageTime() - lastMonthAverageTime); |
| | | } |
| | | |
| | | } |
| | |
| | | List<Complaint> commentRateComplaints = complaints.stream().filter(e -> e.getCommentRate() != null).collect(Collectors.toList()); |
| | | long count = commentRateComplaints.stream().filter(e -> e.getCommentRate() > 1).count(); |
| | | int size = commentRateComplaints.size(); |
| | | if(size>0){ |
| | | if (size > 0) { |
| | | BigDecimal multiply = BigDecimal.valueOf(count).divide(new BigDecimal(size), 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal("100")); |
| | | vo.setSatisfactionRate(multiply.doubleValue()); |
| | | |
| | |
| | | long count1 = nowMonth.stream().filter(e -> e.getCommentRate() > 1).count(); |
| | | // 当月的评价数 |
| | | int nowMonthSize = nowMonth.size(); |
| | | if(nowMonthSize>0){ |
| | | if (nowMonthSize > 0) { |
| | | BigDecimal multiply1 = BigDecimal.valueOf(count1).divide(new BigDecimal(nowMonthSize), 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal("100")); |
| | | vo.setThisMonthSatisfactionRate(multiply1.doubleValue()); |
| | | } |
| | | |
| | | List<Complaint> lastMonth = commentRateComplaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(nowYearMonth)).collect(Collectors.toList()); |
| | | List<Complaint> lastMonth = commentRateComplaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(lastYearMonth)).collect(Collectors.toList()); |
| | | // 当月满意 |
| | | long count2 = lastMonth.stream().filter(e -> e.getCommentRate() > 1).count(); |
| | | // 当月的评价数 |
| | | int lastMonthSize = lastMonth.size(); |
| | | if(lastMonthSize>0){ |
| | | if (lastMonthSize > 0) { |
| | | BigDecimal multiply2 = BigDecimal.valueOf(count2).divide(new BigDecimal(lastMonthSize), 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal("100")); |
| | | vo.setLastMonthCompareSatisfactionRate(vo.getThisMonthSatisfactionRate()-multiply2.doubleValue()); |
| | | vo.setLastMonthCompareSatisfactionRate(vo.getThisMonthSatisfactionRate() - multiply2.doubleValue()); |
| | | } |
| | | } |
| | | return vo; |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | String time = "2022-02-02 - 2023-02-02"; |
| | | String[] split = time.split(" - "); |
| | | System.out.println(split[0]); |
| | | } |
| | | @Override |
| | | public List<AnalyticStatisticsTwoVo> analyticStatisticsTwo(AnalyticStatisticsQuery query, List<Complaint> complaints, SimpleDateFormat simpleDateFormat) { |
| | | public List<AnalyticStatisticsTwoVo> analyticStatisticsTwo(String time, List<Complaint> complaints, SimpleDateFormat simpleDateFormat) { |
| | | ArrayList<AnalyticStatisticsTwoVo> list = new ArrayList<>(); |
| | | try { |
| | | if (StringUtils.isNotEmpty(query.getTime())) { |
| | | String[] split = query.getTime().split(" - "); |
| | | if (StringUtils.isNotEmpty(time)) { |
| | | String[] split = time.split(" - "); |
| | | Date parse = simpleDateFormat.parse(split[0] + " 00:00:00"); |
| | | Date parse1 = simpleDateFormat.parse(split[1] + " 23:59:59"); |
| | | complaints = complaints.stream().filter(e -> e.getCreateTime().getTime() <= parse1.getTime() && e.getCreateTime().getTime() >= parse.getTime()).collect(Collectors.toList()); |
| | | int day = DateUtils.getDay(parse, parse1); |
| | | |
| | | if (day > 30) { |
| | | throw new ServiceException("时间范围不能超过30天"); |
| | | } |
| | | |
| | | for (int i = 0; i <= day; i++) { |
| | | AnalyticStatisticsTwoVo analyticStatisticsTwoVo = new AnalyticStatisticsTwoVo(); |
| | | if(i==0){ |
| | | if (i == 0) { |
| | | List<Complaint> collect = complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(split[0])).collect(Collectors.toList()); |
| | | analyticStatisticsTwoVo.setTime(split[0]); |
| | | analyticStatisticsTwoVo.setAllTotal(collect.size()); |
| | | int count = (int) collect.stream().filter(e -> e.getStatus() == 3).count(); |
| | | analyticStatisticsTwoVo.setCompleteTotal(count); |
| | | list.add(analyticStatisticsTwoVo); |
| | | }else { |
| | | } else { |
| | | String nextDay = DateUtils.getNextDay(parse, i); |
| | | List<Complaint> collect = complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(nextDay)).collect(Collectors.toList()); |
| | | analyticStatisticsTwoVo.setTime(nextDay); |
| | |
| | | } |
| | | |
| | | } else { |
| | | String time = DateUtils.getBeforeDay(6) + " 00:00:00"; |
| | | time = DateUtils.getBeforeDay(6) + " 00:00:00"; |
| | | Date parse = simpleDateFormat.parse(time); |
| | | // 近7天数据 |
| | | complaints = complaints.stream().filter(e -> e.getCreateTime().getTime() <= new Date().getTime() && e.getCreateTime().getTime() >= parse.getTime()).collect(Collectors.toList()); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<AnalyticStatisticsThreeVo> analyticStatisticsThree(AnalyticStatisticsQuery query, List<Complaint> complaints) { |
| | | public List<AnalyticStatisticsThreeVo> analyticStatisticsThree(Integer rank, List<Complaint> complaints) { |
| | | Map<String, List<Complaint>> groupedByProblemType = complaints.stream() |
| | | .collect(Collectors.groupingBy(Complaint::getProblemType)); |
| | | List<AnalyticStatisticsThreeVo> analyticStatisticsThreeVos = groupedByProblemType.entrySet().stream() |
| | |
| | | }) |
| | | .collect(Collectors.toList()); |
| | | analyticStatisticsThreeVos = analyticStatisticsThreeVos.stream().sorted(Comparator.comparing(AnalyticStatisticsThreeVo::getAllTotal).reversed()).collect(Collectors.toList()); |
| | | if(query.getRank()==null){ |
| | | if (rank == null) { |
| | | return analyticStatisticsThreeVos; |
| | | }else if(query.getRank()==5){ |
| | | return analyticStatisticsThreeVos.stream().limit(5).collect(Collectors.toList()); |
| | | }else if(query.getRank()==10){ |
| | | } else if (rank == 5) { |
| | | return analyticStatisticsThreeVos.stream().limit(5).collect(Collectors.toList()); |
| | | } else if (rank == 10) { |
| | | return analyticStatisticsThreeVos.stream().limit(10).collect(Collectors.toList()); |
| | | } |
| | | return Collections.emptyList(); |
| | | } |
| | | |
| | | @Override |
| | | public AnalyticStatisticsFourVo analyticStatisticsFour(List<Complaint> complaints) { |
| | | // 只计算评分了的 |
| | | complaints = complaints.stream().filter(e ->e.getCommentRate() != null).collect(Collectors.toList()); |
| | | AnalyticStatisticsFourVo vo = new AnalyticStatisticsFourVo(); |
| | | // 0:不满意 1:一般 2:满意 3:非常满意 |
| | | long count = complaints.stream().filter(e -> e.getCommentRate() != null && e.getCommentRate() == 0).count(); |
| | | long count1 = complaints.stream().filter(e -> e.getCommentRate() != null && e.getCommentRate() == 1).count(); |
| | | long count2 = complaints.stream().filter(e -> e.getCommentRate() != null && e.getCommentRate() == 2).count(); |
| | | long count3 = complaints.stream().filter(e -> e.getCommentRate() != null && e.getCommentRate() == 3).count(); |
| | | if (complaints.size() > 0) { |
| | | vo.setDissatisfactionRate(BigDecimal.valueOf(count).divide(BigDecimal.valueOf(complaints.size()), 2, RoundingMode.HALF_UP).multiply(new BigDecimal("100")).doubleValue()); |
| | | vo.setGeneralSatisfactionRate(BigDecimal.valueOf(count1).divide(BigDecimal.valueOf(complaints.size()), 2, RoundingMode.HALF_UP).multiply(new BigDecimal("100")).doubleValue()); |
| | | vo.setSatisfactionRate(BigDecimal.valueOf(count2).divide(BigDecimal.valueOf(complaints.size()), 2, RoundingMode.HALF_UP).multiply(new BigDecimal("100")).doubleValue()); |
| | | vo.setGreatSatisfactionRate(BigDecimal.valueOf(count3).divide(BigDecimal.valueOf(complaints.size()), 2, RoundingMode.HALF_UP).multiply(new BigDecimal("100")).doubleValue()); |
| | | } |
| | | return vo; |
| | | } |
| | | |
| | | @Override |
| | | public List<Complaint> queryCompliantList(AppStaticsQuery query, LoginUserInfoVO loginUserInfo) { |
| | | IdentityInformation identityInformation = identityInformationService.getIdentityInformation(loginUserInfo); |
| | | Integer identity = identityInformation.getIdentity(); |
| | | PartyMember partyMember = identityInformation.getPartyMember(); |
| | | SystemUserLevel systemUserLevel = identityInformation.getSystemUserLevel(); |
| | | Long targetId = null; |
| | | Integer accountLevel = 5; |
| | | //党员,查询该党员 |
| | | if (identity.equals(1)) { |
| | | targetId = partyMember.getId(); |
| | | } else if (identity.equals(2)) { |
| | | //上级 |
| | | if (Objects.nonNull(query.getTier()) && !query.getTier().equals(-1)) { |
| | | accountLevel = systemUserLevel.getLevel(); |
| | | switch (systemUserLevel.getLevel()) { |
| | | case 1: |
| | | //市级 |
| | | targetId = 510400L; |
| | | break; |
| | | case 2: |
| | | //区县级 |
| | | targetId = Long.valueOf(systemUserLevel.getDistrictsCode()); |
| | | break; |
| | | case 3: |
| | | //街道 |
| | | targetId = Long.valueOf(systemUserLevel.getStreetId()); |
| | | break; |
| | | case 4: |
| | | //社区 |
| | | targetId = systemUserLevel.getCommunityId(); |
| | | break; |
| | | } |
| | | }else { |
| | | targetId = Long.valueOf(query.getAreaId()); |
| | | accountLevel = query.getTier(); |
| | | } |
| | | } |
| | | return baseMapper.queryCompliantList(targetId, accountLevel, loginUserInfo); |
| | | } |
| | | } |
| | | |