diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessOutsourceCertificateMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessOutsourceCertificateMapper.xml index 61b17f4..c0a59ae 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessOutsourceCertificateMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessOutsourceCertificateMapper.xml @@ -23,7 +23,7 @@ - SELECT boc.certificate_code, boc.certificate_name, boc.original_record_file, boc.certificate_file, boc.print_status, + SELECT boc.id, boc.certificate_code, boc.certificate_name, boc.original_record_file, boc.certificate_file, boc.print_status, boc.create_time, csi.sample_no, csi.sample_name, csi.sample_model, csi.manufacturing_no, boi.outsourcer_name FROM business_outsource_certificate boc LEFT JOIN customer_sample_info csi ON boc.sample_id = csi.id diff --git a/casic-metering-model/src/main/java/com/casic/missiles/dto/business/outsource/OutsourceCertificateListResponse.java b/casic-metering-model/src/main/java/com/casic/missiles/dto/business/outsource/OutsourceCertificateListResponse.java index 9f266d4..826ee3a 100644 --- a/casic-metering-model/src/main/java/com/casic/missiles/dto/business/outsource/OutsourceCertificateListResponse.java +++ b/casic-metering-model/src/main/java/com/casic/missiles/dto/business/outsource/OutsourceCertificateListResponse.java @@ -24,6 +24,9 @@ @ApiModel @Data public class OutsourceCertificateListResponse { + @ApiModelProperty(value = "证书id", dataType = "Long") + private Long id; + @ExcelProperty("证书编号") @ApiModelProperty(value = "证书编号", dataType = "String") private String certificateCode;