diff --git a/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java b/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java index 435f9c8..4094bf1 100644 --- a/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java +++ b/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java @@ -78,7 +78,7 @@ */ @ApiOperation("设备终止") @PostMapping("/terminate") - public ReturnDTO forcedTerminate(@Valid DeviceStatusChangeDTO deviceReceiveDTO) { + public ReturnDTO forcedTerminate(@RequestBody @Valid DeviceStatusChangeDTO deviceReceiveDTO) { Assert.isFalse(Objects.isNull(deviceReceiveDTO.getOrderId()) || Objects.isNull(deviceReceiveDTO.getSampleId()), () -> { throw new BusinessException(BusinessExceptionEnum.ID_NULL); }); diff --git a/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java b/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java index 435f9c8..4094bf1 100644 --- a/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java +++ b/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java @@ -78,7 +78,7 @@ */ @ApiOperation("设备终止") @PostMapping("/terminate") - public ReturnDTO forcedTerminate(@Valid DeviceStatusChangeDTO deviceReceiveDTO) { + public ReturnDTO forcedTerminate(@RequestBody @Valid DeviceStatusChangeDTO deviceReceiveDTO) { Assert.isFalse(Objects.isNull(deviceReceiveDTO.getOrderId()) || Objects.isNull(deviceReceiveDTO.getSampleId()), () -> { throw new BusinessException(BusinessExceptionEnum.ID_NULL); }); diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java index fc9330e..499ba5c 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java @@ -19,7 +19,7 @@ */ public interface BusinessCertificateReportMapper extends BaseMapper { - List selectBatchForApprovalList(Page page, @Param("request") CertificateListRequest request, @Param("businessKey") List businessKey); + List selectBatchForApprovalList(Page page, @Param("request") CertificateListRequest request, @Param("businessKey") List businessKey); diff --git a/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java b/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java index 435f9c8..4094bf1 100644 --- a/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java +++ b/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java @@ -78,7 +78,7 @@ */ @ApiOperation("设备终止") @PostMapping("/terminate") - public ReturnDTO forcedTerminate(@Valid DeviceStatusChangeDTO deviceReceiveDTO) { + public ReturnDTO forcedTerminate(@RequestBody @Valid DeviceStatusChangeDTO deviceReceiveDTO) { Assert.isFalse(Objects.isNull(deviceReceiveDTO.getOrderId()) || Objects.isNull(deviceReceiveDTO.getSampleId()), () -> { throw new BusinessException(BusinessExceptionEnum.ID_NULL); }); diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java index fc9330e..499ba5c 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java @@ -19,7 +19,7 @@ */ public interface BusinessCertificateReportMapper extends BaseMapper { - List selectBatchForApprovalList(Page page, @Param("request") CertificateListRequest request, @Param("businessKey") List businessKey); + List selectBatchForApprovalList(Page page, @Param("request") CertificateListRequest request, @Param("businessKey") List businessKey); diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessCertificateReportMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessCertificateReportMapper.xml index 13456e6..1086ec8 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessCertificateReportMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessCertificateReportMapper.xml @@ -32,8 +32,11 @@ id, certificate_report_code, certificate_report_name, certificate_report_category, calibration_major, issuance_date, expiration_date, template_id, sign_id, approval_sign_id, certificate_report_file, original_record_id, print_status, print_num, remark, is_del, create_user, create_time, update_time - + SELECT bcr.id,certificate_no AS "certificateNo",bcr.certificate_name AS "certificateName",csi.sample_no AS "sampleNo",,csi.sample_name + AS "sampleName",csi.sample_model AS "sampleModel",csi.manufacturing_no AS "manufacturingNo",bo.order_code AS "orderNo",bo.measure_type + AS "measureType",bcr.certificate_type AS "certificateType",bcr.print_status AS "printStatus",bcr.print_num AS "printNum",bcr.approval_status AS "approvalStatus" + bcr.create_time AS "createTime",measurePersonId FROM ( SELECT * FROM business_certificate_report @@ -42,12 +45,17 @@ and certificate_no like concat('%',#{request.certificateNo},'%') - and CERTIFICATE_CLASS like concat('%',#{request.certificateClass},'%') + and certificate_class like concat('%',#{request.certificateClass},'%') - and bcr.id in - - #{id} - + + and print_status like concat('%',#{request.printStatus},'%') + + + and bcr.id in + + #{id} + + ) bcr JOIN ( SELECT id @@ -62,7 +70,7 @@ ) bo ON bo.id=bcr.orderId JOIN ( SELECT id - FROM business_order + FROM customer_sample_info WHERE is_del=0 and SAMPLE_NO like concat('%',#{request.sampleNo},'%') @@ -70,7 +78,7 @@ and SAMPLE_NAME like concat('%',#{request.sampleName},'%') - ) bo ON bo.id=bcr.sampleId + ) csi ON csi.id=bcr.sampleId diff --git a/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java b/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java index 435f9c8..4094bf1 100644 --- a/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java +++ b/casic-metering-api/src/main/java/com/casic/missiles/controller/business/BusinessDispatchController.java @@ -78,7 +78,7 @@ */ @ApiOperation("设备终止") @PostMapping("/terminate") - public ReturnDTO forcedTerminate(@Valid DeviceStatusChangeDTO deviceReceiveDTO) { + public ReturnDTO forcedTerminate(@RequestBody @Valid DeviceStatusChangeDTO deviceReceiveDTO) { Assert.isFalse(Objects.isNull(deviceReceiveDTO.getOrderId()) || Objects.isNull(deviceReceiveDTO.getSampleId()), () -> { throw new BusinessException(BusinessExceptionEnum.ID_NULL); }); diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java index fc9330e..499ba5c 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BusinessCertificateReportMapper.java @@ -19,7 +19,7 @@ */ public interface BusinessCertificateReportMapper extends BaseMapper { - List selectBatchForApprovalList(Page page, @Param("request") CertificateListRequest request, @Param("businessKey") List businessKey); + List selectBatchForApprovalList(Page page, @Param("request") CertificateListRequest request, @Param("businessKey") List businessKey); diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessCertificateReportMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessCertificateReportMapper.xml index 13456e6..1086ec8 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessCertificateReportMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessCertificateReportMapper.xml @@ -32,8 +32,11 @@ id, certificate_report_code, certificate_report_name, certificate_report_category, calibration_major, issuance_date, expiration_date, template_id, sign_id, approval_sign_id, certificate_report_file, original_record_id, print_status, print_num, remark, is_del, create_user, create_time, update_time - + SELECT bcr.id,certificate_no AS "certificateNo",bcr.certificate_name AS "certificateName",csi.sample_no AS "sampleNo",,csi.sample_name + AS "sampleName",csi.sample_model AS "sampleModel",csi.manufacturing_no AS "manufacturingNo",bo.order_code AS "orderNo",bo.measure_type + AS "measureType",bcr.certificate_type AS "certificateType",bcr.print_status AS "printStatus",bcr.print_num AS "printNum",bcr.approval_status AS "approvalStatus" + bcr.create_time AS "createTime",measurePersonId FROM ( SELECT * FROM business_certificate_report @@ -42,12 +45,17 @@ and certificate_no like concat('%',#{request.certificateNo},'%') - and CERTIFICATE_CLASS like concat('%',#{request.certificateClass},'%') + and certificate_class like concat('%',#{request.certificateClass},'%') - and bcr.id in - - #{id} - + + and print_status like concat('%',#{request.printStatus},'%') + + + and bcr.id in + + #{id} + + ) bcr JOIN ( SELECT id @@ -62,7 +70,7 @@ ) bo ON bo.id=bcr.orderId JOIN ( SELECT id - FROM business_order + FROM customer_sample_info WHERE is_del=0 and SAMPLE_NO like concat('%',#{request.sampleNo},'%') @@ -70,7 +78,7 @@ and SAMPLE_NAME like concat('%',#{request.sampleName},'%') - ) bo ON bo.id=bcr.sampleId + ) csi ON csi.id=bcr.sampleId diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml index 2730c9c..83802df 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml @@ -36,23 +36,23 @@ - SELECT * + diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml index 2730c9c..83802df 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml @@ -36,23 +36,23 @@ - SELECT * + diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml index 2730c9c..83802df 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml @@ -36,23 +36,23 @@ - SELECT * + diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml index 2730c9c..83802df 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml @@ -36,23 +36,23 @@ - SELECT * + diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml index 2730c9c..83802df 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml @@ -36,23 +36,23 @@ - SELECT * + diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml index 2730c9c..83802df 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml @@ -36,23 +36,23 @@ - SELECT * + diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml index 2730c9c..83802df 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml @@ -36,23 +36,23 @@ - SELECT * + diff --git a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml index 2730c9c..83802df 100644 --- a/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessInterchangeMapper.xml @@ -36,23 +36,23 @@