From 42239f79490e7130a63d51a67efd1f2c8d23be37 Mon Sep 17 00:00:00 2001
From: xyh <18782104331@139.com>
Date: 星期五, 18 六月 2021 09:50:44 +0800
Subject: [PATCH] 平均耗时格式
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComEldersAuthElderlyServiceImpl.java | 91 ++++++++++++++++++++++++++++++++++++---------
1 files changed, 73 insertions(+), 18 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComEldersAuthElderlyServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComEldersAuthElderlyServiceImpl.java
index 28c8549..4ff8fed 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComEldersAuthElderlyServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComEldersAuthElderlyServiceImpl.java
@@ -1,27 +1,40 @@
package com.panzhihua.service_community.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.panzhihua.common.exceptions.ServiceException;
import com.panzhihua.common.model.dtos.community.EldersAuthElderlyDTO;
import com.panzhihua.common.model.dtos.community.PageComEldersAuthElderlyDTO;
import com.panzhihua.common.model.dtos.community.PageEldersAuthElderlyDTO;
+import com.panzhihua.common.model.helper.AESUtil;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.ComEldersAuthElderlyVO;
import com.panzhihua.common.model.vos.community.EldersAuthElderlyExcelVO;
+import com.panzhihua.common.utlis.AgeUtils;
+import com.panzhihua.common.utlis.IdCard;
import com.panzhihua.service_community.dao.ComEldersAuthElderlyMapper;
import com.panzhihua.service_community.model.dos.ComEldersAuthElderlyDO;
import com.panzhihua.service_community.service.ComEldersAuthElderlyService;
import com.panzhihua.service_community.service.EldersAuthService;
import lombok.extern.slf4j.Slf4j;
+import org.apache.commons.lang.StringUtils;
import org.springframework.beans.BeanUtils;
+import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.ObjectUtils;
import javax.annotation.Resource;
-import java.util.ArrayList;
-import java.util.List;
-import java.util.Objects;
+import javax.crypto.BadPaddingException;
+import javax.crypto.IllegalBlockSizeException;
+import javax.crypto.NoSuchPaddingException;
+import java.io.UnsupportedEncodingException;
+import java.security.InvalidKeyException;
+import java.security.NoSuchAlgorithmException;
+import java.text.SimpleDateFormat;
+import java.util.*;
/**
* 高龄老人库 serviceImpl
@@ -38,12 +51,14 @@
@Resource
private ComEldersAuthElderlyMapper comEldersAuthElderlyMapper;
+ @Value("${domain.aesKey:}")
+ private String aesKey;
+
@Resource
private EldersAuthService eldersAuthService;
@Override
public R pageQueryEldersAuthElderly(PageEldersAuthElderlyDTO pageEldersAuthElderlyDTO) {
-
PageComEldersAuthElderlyDTO pageComEldersAuthElderlyDTO = new PageComEldersAuthElderlyDTO();
BeanUtils.copyProperties(pageEldersAuthElderlyDTO,pageComEldersAuthElderlyDTO);
IPage<ComEldersAuthElderlyVO> page = comEldersAuthElderlyMapper.findByPage(new Page(pageEldersAuthElderlyDTO.getPageNum(),pageEldersAuthElderlyDTO.getPageSize()),pageComEldersAuthElderlyDTO);
@@ -51,24 +66,64 @@
}
@Override
+ @Transactional(rollbackFor = Exception.class)
public R batchSave(List<EldersAuthElderlyExcelVO> list,Long communityId,Long createBy) {
- List<ComEldersAuthElderlyDO> listDO = new ArrayList<>();
+ List<ComEldersAuthElderlyDO> listNewDO = new ArrayList<>();
+ List<ComEldersAuthElderlyDO> listUpdateDO = new ArrayList<>();
list.forEach(e->{
- ComEldersAuthElderlyDO comEldersAuthElderlyDO = new ComEldersAuthElderlyDO();
- comEldersAuthElderlyDO.setName(e.getName());
- comEldersAuthElderlyDO.setIdCard(e.getIdCard());
- comEldersAuthElderlyDO.setCommunityId(communityId);
- comEldersAuthElderlyDO.setCreateBy(createBy);
- comEldersAuthElderlyDO.setDomicile(eldersAuthService.queryDomicile(e.getIdCard()));
- comEldersAuthElderlyDO.setIsExist(Objects.equals("是",e.getIsExist())?1:2);
- comEldersAuthElderlyDO.setIsBigAge(Objects.equals("是",e.getIsExist())?1:2);
- /**
- * 去重
- */
+ String idCardEncrypted = e.getIdCard();
+ try {
+ idCardEncrypted = AESUtil.encrypt128(idCardEncrypted, aesKey);
+ } catch (Exception exp) {
+ exp.printStackTrace();
+ }
+ List<ComEldersAuthElderlyDO> comEldersAuthElderlyDOList =
+ comEldersAuthElderlyMapper.selectList(new LambdaQueryWrapper<ComEldersAuthElderlyDO>().eq(ComEldersAuthElderlyDO::getIdCard, idCardEncrypted)
+ .orderByDesc(ComEldersAuthElderlyDO::getCreateAt));
- listDO.add(comEldersAuthElderlyDO);
+ if(comEldersAuthElderlyDOList!=null && comEldersAuthElderlyDOList.size()>0){
+ ComEldersAuthElderlyDO lastestOne = comEldersAuthElderlyDOList.get(0);
+ lastestOne.setName(e.getName());
+ lastestOne.setCommunityId(communityId);
+ lastestOne.setUpdateBy(createBy);
+ lastestOne.setIdCard(null);
+ lastestOne.setDomicile(eldersAuthService.queryDomicile(e.getIdCard()));
+ lastestOne.setIsExist(Objects.equals("是",e.getIsExist())?1:2);
+ lastestOne.setIsBigAge(Objects.equals("是",e.getIsExist())?1:2);
+ lastestOne.setUpdateAt(new Date());
+ listUpdateDO.add(lastestOne);
+ }else{
+ ComEldersAuthElderlyDO comEldersAuthElderlyDO = new ComEldersAuthElderlyDO();
+ comEldersAuthElderlyDO.setName(e.getName());
+ comEldersAuthElderlyDO.setIdCard(e.getIdCard());
+ comEldersAuthElderlyDO.setCommunityId(communityId);
+ comEldersAuthElderlyDO.setCreateBy(createBy);
+ comEldersAuthElderlyDO.setDomicile(eldersAuthService.queryDomicile(e.getIdCard()));
+ comEldersAuthElderlyDO.setIsExist(Objects.equals("是",e.getIsExist())?1:2);
+ comEldersAuthElderlyDO.setIsBigAge(Objects.equals("是",e.getIsExist())?1:2);
+ comEldersAuthElderlyDO.setBirthday(e.getBirthday());
+ comEldersAuthElderlyDO.setLevel(e.getLevel());
+ listNewDO.add(comEldersAuthElderlyDO);
+ }
+
});
- this.saveBatch(listDO);
+ boolean noImport = (listNewDO==null || listNewDO.size()==0) && (listUpdateDO==null || listUpdateDO.size()==0);
+ if(noImport){
+ throw new ServiceException("未发现高龄老人数据");
+ }
+ if(listNewDO!=null && listNewDO.size()>0) {
+ boolean batchAdd = this.saveBatch(listNewDO);
+ if (!batchAdd) {
+ throw new ServiceException("批量插入失败");
+ }
+ }
+ if(listUpdateDO!=null && listUpdateDO.size()>0) {
+ boolean batchUpdate = this.updateBatchById(listUpdateDO);
+ if (!batchUpdate) {
+ throw new ServiceException("批量更新失败");
+ }
+ }
+
return R.ok("共计导入高龄老人数量：" + list.size());
}
--
Gitblit v1.7.1