| | |
| | | import java.net.URL; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | |
| | |
| | | |
| | | import com.panzhihua.common.model.vos.community.bigscreen.BigScreenStaticsReserve; |
| | | import com.panzhihua.common.model.vos.community.bigscreen.BigScreenStaticsReserveMonth; |
| | | import com.panzhihua.common.model.vos.community.reserve.HomeQuarantineRegisterExportVO; |
| | | import com.panzhihua.common.model.vos.community.reserve.*; |
| | | import com.panzhihua.service_community.dao.ComActReserveMapper; |
| | | import com.panzhihua.service_community.dao.ComActReserveRecordMapper; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.stereotype.Service; |
| | |
| | | private ComActReserveSubMapper comActReserveSubMapper; |
| | | @Resource |
| | | private ComActReserveRecordMapper comActReserveRecordMapper; |
| | | @Resource |
| | | private ComActReserveMapper comActReserveMapper; |
| | | |
| | | /** |
| | | * 导出登记明细数据 |
| | |
| | | |
| | | //查询用户回答 |
| | | List<ComActQuestnaireAnswerContentVO> vos = this.baseMapper.export(pageReserveRegisterDetailedAdminDTO); |
| | | vos.forEach(vo->{ |
| | | if(vo.getType()==4){ |
| | | vo.setAnswerContent(vo.getAnswerContent().replaceAll("(?<=\\w{3})\\w(?=\\w{4})", "*")); |
| | | } |
| | | }); |
| | | result.setAnswers(vos); |
| | | |
| | | return R.ok(result); |
| | |
| | | List<ComActReserveRegisterDetailedAnswerVO> registerDetailedAnswerList = this.baseMapper.getRegisterDetailedAnswerList(registerDetailed.getId()); |
| | | if(!registerDetailedAnswerList.isEmpty()){ |
| | | for (ComActReserveRegisterDetailedAnswerVO detailed:registerDetailedAnswerList) { |
| | | if(detailed.getType()==4){ |
| | | detailed.setAnswerContent(detailed.getAnswerContent().replaceAll("(?<=\\w{3})\\w(?=\\w{4})", "*")); |
| | | } |
| | | if(!detailed.getType().equals(5)){ |
| | | if(detailed.getType().equals(1)){ |
| | | String key = detailed.getReserveSubId() + ""; |
| | |
| | | map.put(detailed.getReserveSubId() + "",detailed.getAnswerContent()); |
| | | } |
| | | } |
| | | |
| | | } |
| | | } |
| | | //渲染登记流水号 |
| | |
| | | } |
| | | resultPage.setRecords(resultMapList); |
| | | return R.ok(resultPage); |
| | | } |
| | | |
| | | @Override |
| | | public R registerDetailedListAdminExport(PageReserveRegisterDetailedAdminDTO detailedAdminDTO) { |
| | | String communityPhone=comActReserveMapper.selectCommunityPhoneByReserveId(detailedAdminDTO.getReserveId()); |
| | | List<ComActReserveRegisterDetailedVO> comActReserveRegisterDetailedVOS = this.baseMapper.pageRegisterDetailedListAdminExport(detailedAdminDTO); |
| | | if(!comActReserveRegisterDetailedVOS.isEmpty()){ |
| | | List<ReservePdfExportVO> reservePdfExportVOS=new ArrayList<>(); |
| | | comActReserveRegisterDetailedVOS.forEach(comActReserveRegisterDetailedVO -> { |
| | | List<ComActReserveRegisterDetailedAnswerVO> registerDetailedAnswerList = this.baseMapper.getRegisterDetailedAnswerList(comActReserveRegisterDetailedVO.getId()); |
| | | if(!registerDetailedAnswerList.isEmpty()){ |
| | | ReservePdfExportVO reservePdfExportVO=new ReservePdfExportVO(); |
| | | reservePdfExportVO.setAddress(registerDetailedAnswerList.get(0).getAnswerContent()); |
| | | reservePdfExportVO.setSign(registerDetailedAnswerList.get(1).getAnswerContent()); |
| | | if(detailedAdminDTO.getPdfType()==1){ |
| | | reservePdfExportVO.setTime(registerDetailedAnswerList.get(2).getAnswerContent()); |
| | | } |
| | | if(detailedAdminDTO.getPdfType()==2){ |
| | | reservePdfExportVO.setPhone(registerDetailedAnswerList.get(2).getAnswerContent()); |
| | | reservePdfExportVO.setTime(registerDetailedAnswerList.get(3).getAnswerContent()); |
| | | reservePdfExportVO.setCommunityPhone(communityPhone); |
| | | } |
| | | reservePdfExportVOS.add(reservePdfExportVO); |
| | | } |
| | | }); |
| | | return R.ok(reservePdfExportVOS); |
| | | } |
| | | return R.ok(); |
| | | } |
| | | |
| | | /** |
| | |
| | | @Override |
| | | public R bigScreenStaticsReserve(Long communityId) { |
| | | BigScreenStaticsReserve bigScreenStaticsReserve=comActReserveRecordMapper.biggestScreen(communityId); |
| | | bigScreenStaticsReserve.setReservePercent(BigDecimal.valueOf(bigScreenStaticsReserve.getReserveCount()*100d/ bigScreenStaticsReserve.getCount())); |
| | | bigScreenStaticsReserve.setFirePercent(BigDecimal.valueOf(bigScreenStaticsReserve.getFireCount()*100d/ bigScreenStaticsReserve.getCount())); |
| | | bigScreenStaticsReserve.setHomePercent(BigDecimal.valueOf(bigScreenStaticsReserve.getHomeCount()*100d/ bigScreenStaticsReserve.getCount())); |
| | | bigScreenStaticsReserve.setGasPercent(BigDecimal.valueOf(bigScreenStaticsReserve.getGasCount()*100d/ bigScreenStaticsReserve.getCount())); |
| | | bigScreenStaticsReserve.setReservePercent(BigDecimal.valueOf(bigScreenStaticsReserve.getReserveCount()*100d/ bigScreenStaticsReserve.getCount()).setScale(2,BigDecimal.ROUND_HALF_UP)); |
| | | bigScreenStaticsReserve.setFirePercent(BigDecimal.valueOf(bigScreenStaticsReserve.getFireCount()*100d/ bigScreenStaticsReserve.getCount()).setScale(2,BigDecimal.ROUND_HALF_UP)); |
| | | bigScreenStaticsReserve.setHomePercent(BigDecimal.valueOf(bigScreenStaticsReserve.getHomeCount()*100d/ bigScreenStaticsReserve.getCount()).setScale(2,BigDecimal.ROUND_HALF_UP)); |
| | | bigScreenStaticsReserve.setGasPercent(BigDecimal.valueOf(bigScreenStaticsReserve.getGasCount()*100d/ bigScreenStaticsReserve.getCount()).setScale(2,BigDecimal.ROUND_HALF_UP)); |
| | | List<BigScreenStaticsReserveMonth> bigScreenStaticsReserveMonthList=this.getPoints(); |
| | | bigScreenStaticsReserveMonthList.forEach(bigScreenStaticsReserveMonth -> { |
| | | BigScreenStaticsReserveMonth bigScreenStaticsReserveMonth1=comActReserveRecordMapper.biggestScreenMonth(communityId,bigScreenStaticsReserveMonth.getX()); |
| | | BigScreenStaticsReserveMonth bigScreenStaticsReserveMonth1=comActReserveRecordMapper.biggestScreenMonth(communityId,bigScreenStaticsReserveMonth.getX(), bigScreenStaticsReserveMonth.getYear()); |
| | | bigScreenStaticsReserveMonth.setCount(bigScreenStaticsReserveMonth1.getCount()); |
| | | bigScreenStaticsReserveMonth.setReserveCount(bigScreenStaticsReserveMonth1.getReserveCount()); |
| | | bigScreenStaticsReserveMonth.setFireCount(bigScreenStaticsReserveMonth1.getFireCount()); |
| | |
| | | |
| | | public List<BigScreenStaticsReserveMonth> getPoints(){ |
| | | List<BigScreenStaticsReserveMonth> bigScreenStaticsReserveMonths=new ArrayList<>(); |
| | | for(int i=1;i<=12;i++){ |
| | | String aDate=""; |
| | | if(i<10){ |
| | | aDate = "0"+i; |
| | | String nowMonth=DateUtils.getDateFormatString(new Date(),"MM"); |
| | | String nowYear=DateUtils.getDateFormatString(new Date(),"yyyy"); |
| | | String nowYearMonth=DateUtils.getDateFormatString(new Date(),"yyyyMM"); |
| | | if(Integer.parseInt(nowYearMonth)<202212){ |
| | | for(int i=9;i<=12;i++){ |
| | | String aDate=""; |
| | | if(i<10){ |
| | | aDate = "0"+i; |
| | | } |
| | | else { |
| | | aDate=i+""; |
| | | } |
| | | BigScreenStaticsReserveMonth bigScreenStaticsReserveMonth=new BigScreenStaticsReserveMonth(); |
| | | bigScreenStaticsReserveMonth.setYear("2021"); |
| | | bigScreenStaticsReserveMonth.setX(aDate); |
| | | bigScreenStaticsReserveMonths.add(bigScreenStaticsReserveMonth); |
| | | } |
| | | else { |
| | | aDate=i+""; |
| | | } |
| | | if(Integer.parseInt(nowYear)>2021){ |
| | | for(int i=1;i<=Integer.parseInt(nowMonth);i++){ |
| | | if(bigScreenStaticsReserveMonths.size()>=12){ |
| | | bigScreenStaticsReserveMonths.remove(0); |
| | | } |
| | | String aDate=""; |
| | | if(i<10){ |
| | | aDate = "0"+i; |
| | | } |
| | | else { |
| | | aDate=i+""; |
| | | } |
| | | BigScreenStaticsReserveMonth bigScreenStaticsReserveMonth=new BigScreenStaticsReserveMonth(); |
| | | bigScreenStaticsReserveMonth.setX(aDate); |
| | | bigScreenStaticsReserveMonth.setYear(nowYear); |
| | | bigScreenStaticsReserveMonths.add(bigScreenStaticsReserveMonth); |
| | | } |
| | | BigScreenStaticsReserveMonth bigScreenStaticsReserveMonth=new BigScreenStaticsReserveMonth(); |
| | | bigScreenStaticsReserveMonth.setX(aDate); |
| | | bigScreenStaticsReserveMonths.add(bigScreenStaticsReserveMonth); |
| | | } |
| | | return bigScreenStaticsReserveMonths; |
| | | } |