diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java index c7c721f..77afe8c 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java @@ -16,4 +16,6 @@ public interface BizResourceStaffVerifierDetailMapper extends BaseMapper { List getListByVerifierList(Long verifierId); + + boolean batchRemoveByVerifierId(Long verifierId); } diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java index c7c721f..77afe8c 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java @@ -16,4 +16,6 @@ public interface BizResourceStaffVerifierDetailMapper extends BaseMapper { List getListByVerifierList(Long verifierId); + + boolean batchRemoveByVerifierId(Long verifierId); } diff --git a/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml b/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml index 8f5c348..a0e9d72 100644 --- a/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml @@ -24,5 +24,10 @@ WHERE verifier_id = #{verifierId} ORDER BY certification_date DESC + + + DELETE FROM biz_resource_staff_verifier_detail + WHERE verifier_id = #{verifierId} + diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java index c7c721f..77afe8c 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java @@ -16,4 +16,6 @@ public interface BizResourceStaffVerifierDetailMapper extends BaseMapper { List getListByVerifierList(Long verifierId); + + boolean batchRemoveByVerifierId(Long verifierId); } diff --git a/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml b/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml index 8f5c348..a0e9d72 100644 --- a/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml @@ -24,5 +24,10 @@ WHERE verifier_id = #{verifierId} ORDER BY certification_date DESC + + + DELETE FROM biz_resource_staff_verifier_detail + WHERE verifier_id = #{verifierId} + diff --git a/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java b/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java index 0adee98..98bb335 100644 --- a/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java +++ b/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java @@ -606,6 +606,18 @@ public ReturnDTO verifierUpdate(BizResourceStaffVerifier staffVerifier) { int updateFlag = staffVerifierMapper.updateById(staffVerifier); if (updateFlag > 0) { + // 删除关联子表的记录再重新建 + verifierDetailService.batchRemoveByVerifierId(staffVerifier.getId()); + + // 重建关联关系 + List verifierDetailList = staffVerifier.getVerifierDetailList(); + if (null != verifierDetailList && !verifierDetailList.isEmpty()) { + verifierDetailList.forEach(verifierDetail -> { + verifierDetail.setVerifierId(staffVerifier.getId()); + }); + verifierDetailService.saveBatch(verifierDetailList); + } + return ReturnUtil.success(); } throw new BusinessException(BusinessExceptionEnum.HANDLE_FAILED); diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java index c7c721f..77afe8c 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java @@ -16,4 +16,6 @@ public interface BizResourceStaffVerifierDetailMapper extends BaseMapper { List getListByVerifierList(Long verifierId); + + boolean batchRemoveByVerifierId(Long verifierId); } diff --git a/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml b/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml index 8f5c348..a0e9d72 100644 --- a/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml @@ -24,5 +24,10 @@ WHERE verifier_id = #{verifierId} ORDER BY certification_date DESC + + + DELETE FROM biz_resource_staff_verifier_detail + WHERE verifier_id = #{verifierId} + diff --git a/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java b/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java index 0adee98..98bb335 100644 --- a/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java +++ b/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java @@ -606,6 +606,18 @@ public ReturnDTO verifierUpdate(BizResourceStaffVerifier staffVerifier) { int updateFlag = staffVerifierMapper.updateById(staffVerifier); if (updateFlag > 0) { + // 删除关联子表的记录再重新建 + verifierDetailService.batchRemoveByVerifierId(staffVerifier.getId()); + + // 重建关联关系 + List verifierDetailList = staffVerifier.getVerifierDetailList(); + if (null != verifierDetailList && !verifierDetailList.isEmpty()) { + verifierDetailList.forEach(verifierDetail -> { + verifierDetail.setVerifierId(staffVerifier.getId()); + }); + verifierDetailService.saveBatch(verifierDetailList); + } + return ReturnUtil.success(); } throw new BusinessException(BusinessExceptionEnum.HANDLE_FAILED); diff --git a/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffVerifierDetailServiceImpl.java b/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffVerifierDetailServiceImpl.java index 4b644e2..392bfb2 100644 --- a/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffVerifierDetailServiceImpl.java +++ b/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffVerifierDetailServiceImpl.java @@ -23,4 +23,9 @@ public List getListByVerifierList(Long verifierId) { return baseMapper.getListByVerifierList(verifierId); } + + @Override + public boolean batchRemoveByVerifierId(Long verifierId) { + return baseMapper.batchRemoveByVerifierId(verifierId); + } } diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java index c7c721f..77afe8c 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/resource/BizResourceStaffVerifierDetailMapper.java @@ -16,4 +16,6 @@ public interface BizResourceStaffVerifierDetailMapper extends BaseMapper { List getListByVerifierList(Long verifierId); + + boolean batchRemoveByVerifierId(Long verifierId); } diff --git a/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml b/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml index 8f5c348..a0e9d72 100644 --- a/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierDetailMapper.xml @@ -24,5 +24,10 @@ WHERE verifier_id = #{verifierId} ORDER BY certification_date DESC + + + DELETE FROM biz_resource_staff_verifier_detail + WHERE verifier_id = #{verifierId} + diff --git a/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java b/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java index 0adee98..98bb335 100644 --- a/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java +++ b/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffInfoServiceImpl.java @@ -606,6 +606,18 @@ public ReturnDTO verifierUpdate(BizResourceStaffVerifier staffVerifier) { int updateFlag = staffVerifierMapper.updateById(staffVerifier); if (updateFlag > 0) { + // 删除关联子表的记录再重新建 + verifierDetailService.batchRemoveByVerifierId(staffVerifier.getId()); + + // 重建关联关系 + List verifierDetailList = staffVerifier.getVerifierDetailList(); + if (null != verifierDetailList && !verifierDetailList.isEmpty()) { + verifierDetailList.forEach(verifierDetail -> { + verifierDetail.setVerifierId(staffVerifier.getId()); + }); + verifierDetailService.saveBatch(verifierDetailList); + } + return ReturnUtil.success(); } throw new BusinessException(BusinessExceptionEnum.HANDLE_FAILED); diff --git a/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffVerifierDetailServiceImpl.java b/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffVerifierDetailServiceImpl.java index 4b644e2..392bfb2 100644 --- a/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffVerifierDetailServiceImpl.java +++ b/casic-metering-service/src/main/java/com/casic/missiles/service/Impl/resource/BizResourceStaffVerifierDetailServiceImpl.java @@ -23,4 +23,9 @@ public List getListByVerifierList(Long verifierId) { return baseMapper.getListByVerifierList(verifierId); } + + @Override + public boolean batchRemoveByVerifierId(Long verifierId) { + return baseMapper.batchRemoveByVerifierId(verifierId); + } } diff --git a/casic-metering-service/src/main/java/com/casic/missiles/service/resource/IBizResourceStaffVerifierDetailService.java b/casic-metering-service/src/main/java/com/casic/missiles/service/resource/IBizResourceStaffVerifierDetailService.java index e5153e7..6f44cc1 100644 --- a/casic-metering-service/src/main/java/com/casic/missiles/service/resource/IBizResourceStaffVerifierDetailService.java +++ b/casic-metering-service/src/main/java/com/casic/missiles/service/resource/IBizResourceStaffVerifierDetailService.java @@ -16,4 +16,6 @@ public interface IBizResourceStaffVerifierDetailService extends IService { List getListByVerifierList(Long verifierId); + + boolean batchRemoveByVerifierId(Long verifierId); }