diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java index 55b2895..81d229a 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java @@ -36,6 +36,8 @@ String customTemplateByCategory(@Param("templateType") String templateType, @Param("itemCategoryId") Long itemCategoryId); + String getMeasureAddress(@Param("addressId")String addressId); + @Select("SELECT count(id) from biz_business_device_measure_approval where approval_status = 4 and sample_id = #{sampleId} and order_id=#{orderId}") Long selectSampleCertifications(@Param("sampleId") Long sampleId, @Param("orderId") Long orderId); diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java index 55b2895..81d229a 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java @@ -36,6 +36,8 @@ String customTemplateByCategory(@Param("templateType") String templateType, @Param("itemCategoryId") Long itemCategoryId); + String getMeasureAddress(@Param("addressId")String addressId); + @Select("SELECT count(id) from biz_business_device_measure_approval where approval_status = 4 and sample_id = #{sampleId} and order_id=#{orderId}") Long selectSampleCertifications(@Param("sampleId") Long sampleId, @Param("orderId") Long orderId); diff --git a/casic-metering-dao/src/main/resources/mapper/business/BizBusinessDeviceMeasureApprovalMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BizBusinessDeviceMeasureApprovalMapper.xml index 7af9cb9..390f354 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BizBusinessDeviceMeasureApprovalMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BizBusinessDeviceMeasureApprovalMapper.xml @@ -102,6 +102,12 @@ AND template_type= #{templateType} + + + + + + + +