| | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.HashMap; |
| | | import java.util.Map; |
| | | |
| | | import com.ruoyi.common.utils.StringUtils; |
| | |
| | | donationWitnessVO.setReporterno(user.getUserName()); |
| | | } |
| | | List<DonationWitnessVO> donationWitnessVOS = serviceDonationwitnessMapper.selectVOList(donationWitnessVO); |
| | | |
| | | // 一次性取出各捐献基础对应的死亡时间,避免在循环里按 InfoID 逐条查见证表(N+1) |
| | | List<Long> infoIds = new ArrayList<>(); |
| | | for (DonationWitnessVO item : donationWitnessVOS) { |
| | | if (item.getInfoid() != null) { |
| | | infoIds.add(item.getInfoid()); |
| | | } |
| | | } |
| | | Map<Long, Date> deathTimeMap = new HashMap<>(); |
| | | if (!infoIds.isEmpty()) { |
| | | for (ServiceDonationwitness witness : serviceDonationwitnessMapper.selectDeathTimeByInfoIds(infoIds)) { |
| | | if (witness.getInfoid() != null && !deathTimeMap.containsKey(witness.getInfoid())) { |
| | | deathTimeMap.put(witness.getInfoid(), witness.getDeathtime()); |
| | | } |
| | | } |
| | | } |
| | | |
| | | for (DonationWitnessVO donationWitnessVO1 : donationWitnessVOS) { |
| | | //先给个年龄默认值(因为age是数字类型,不能放横杠,所以就所横扛放到单位上) |
| | | donationWitnessVO1.setAgeunit("-"); |
| | | |
| | | //获取死亡时间,如果获取见证里有死亡时间,则进行计算他的年龄 |
| | | ServiceDonationwitness sdw = new ServiceDonationwitness(); |
| | | sdw.setInfoid(donationWitnessVO1.getInfoid()); |
| | | List<ServiceDonationwitness> serviceDonationwitnessList = serviceDonationwitnessMapper.selectServiceDonationwitnessList(sdw); |
| | | if (!CollectionUtils.isEmpty(serviceDonationwitnessList) && donationWitnessVO1.getBirthday() != null) { |
| | | Date deathtime = serviceDonationwitnessList.get(0).getDeathtime(); |
| | | if (ObjectUtils.isNotEmpty(deathtime)) { |
| | | Date deathtime = deathTimeMap.get(donationWitnessVO1.getInfoid()); |
| | | if (ObjectUtils.isNotEmpty(deathtime) && donationWitnessVO1.getBirthday() != null) { |
| | | Map<String, String> map = CalculateDateUtils.calculateAge(donationWitnessVO1.getBirthday().toInstant().atZone(ZoneId.systemDefault()).toLocalDate(), deathtime.toInstant().atZone(ZoneId.systemDefault()).toLocalDate()); |
| | | if (ObjectUtils.isEmpty(map)) { |
| | | log.error("DonationWitnessVO出生日期:{},DonationWitnessVO死亡日期:{}", donationWitnessVO1.getBirthday(), deathtime); |
| | |
| | | donationWitnessVO1.setAgeunit(map.get("ageUnit")); |
| | | donationWitnessVO1.setAge2(org.apache.commons.lang3.ObjectUtils.isNotEmpty(map.get("age2")) ? Long.valueOf(map.get("age2")) : null); |
| | | donationWitnessVO1.setAgeunit2(map.get("ageUnit2")); |
| | | } |
| | | } |
| | | } |
| | | return donationWitnessVOS; |