diff --git a/casic-metering-common/src/main/java/com/casic/missiles/enums/ApplyFromIdEnum.java b/casic-metering-common/src/main/java/com/casic/missiles/enums/ApplyFromIdEnum.java
index 0975556..57a5e76 100644
--- a/casic-metering-common/src/main/java/com/casic/missiles/enums/ApplyFromIdEnum.java
+++ b/casic-metering-common/src/main/java/com/casic/missiles/enums/ApplyFromIdEnum.java
@@ -18,5 +18,5 @@
     String DEVICE_BORROW_APPROVAL = "clsbjysp"; // 设备借用申请
     String DEVICE_FIX_APPROVAL = "sbglsbjxsq"; // 设备检修申请
     String DEVICE_FIX_ACCEPTANCE = "sbglsbjxbyysd"; // 设备检修保养验收单
-    String CERTIFICATE_PRINT_APPROVAL = "sbglbzzzcxsqssd"; // 证书打印通过，暂定************
+    String CERTIFICATE_PRINT_APPROVAL = "ywglzsdy"; // 证书打印通过
 }

diff --git a/casic-metering-common/src/main/java/com/casic/missiles/enums/ApplyFromIdEnum.java b/casic-metering-common/src/main/java/com/casic/missiles/enums/ApplyFromIdEnum.java
index 0975556..57a5e76 100644
--- a/casic-metering-common/src/main/java/com/casic/missiles/enums/ApplyFromIdEnum.java
+++ b/casic-metering-common/src/main/java/com/casic/missiles/enums/ApplyFromIdEnum.java
@@ -18,5 +18,5 @@
     String DEVICE_BORROW_APPROVAL = "clsbjysp"; // 设备借用申请
     String DEVICE_FIX_APPROVAL = "sbglsbjxsq"; // 设备检修申请
     String DEVICE_FIX_ACCEPTANCE = "sbglsbjxbyysd"; // 设备检修保养验收单
-    String CERTIFICATE_PRINT_APPROVAL = "sbglbzzzcxsqssd"; // 证书打印通过，暂定************
+    String CERTIFICATE_PRINT_APPROVAL = "ywglzsdy"; // 证书打印通过
 }
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 1458b94..92d1d35 100644
--- a/casic-metering-dao/src/main/resources/mapper/business/BusinessCertificateReportMapper.xml
+++ b/casic-metering-dao/src/main/resources/mapper/business/BusinessCertificateReportMapper.xml
@@ -33,9 +33,9 @@
     </sql>
 
     <select id="selectBatchForApprovalList" resultType="com.casic.missiles.dto.business.print.CertificateListResponse">
-        SELECT bcr.id,certificate_no AS "certificateNo",bcr.certificate_name AS "certificateName",csi.sample_no AS "sampleNo",
+        SELECT bcr.id,bcr.certificate_report_code AS "certificateNo",bcr.certificate_report_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",
+        csi.measure_type AS "measureType",bcr.certificate_report_type AS "certificateType",bcr.print_status AS "printStatus",bcr.print_num AS "printNum",
         bcr.approval_status AS "approvalStatus",bcr.create_time AS "createTime",bcr.measure_person_id AS "measurePersonId"
         FROM (
             SELECT *
@@ -50,7 +50,7 @@
             <if test="request.printStatus != null and request.printStatus !=''">
                 and print_status like concat('%',#{request.printStatus},'%')
             </if>
-            <if test="request.businessKey != null">
+            <if test="businessKey != null">
                 and bcr.id in
                 <foreach collection="businessKey" item="id" index="index" open="(" close=")" separator=",">
                     #{id}
@@ -58,33 +58,33 @@
             </if>
             <if test="request.ids != null">
                 and bcr.id in
-                <foreach collection="ids" item="id" index="index" open="(" close=")" separator=",">
+                <foreach collection="request.ids " item="id" index="index" open="(" close=")" separator=",">
                     #{id}
                 </foreach>
             </if>
         ) bcr
         JOIN (
-        SELECT id
-        FROM business_order
-        WHERE is_del=0
-        <if test="request.orderNo != null and request.orderNo !=''">
-            and ORDER_CODE like concat('%',#{request.orderNo},'%')
-        </if>
-        <if test="request.cutomerName != null and request.cutomerName !=''">
-            and CUTOMER_NAME like concat('%',#{request.cutomerName},'%')
-        </if>
-        ) bo ON bo.id=bcr.orderId
+            SELECT *
+            FROM business_order
+            WHERE is_del=0
+            <if test="request.orderNo != null and request.orderNo !=''">
+                and ORDER_CODE like concat('%',#{request.orderNo},'%')
+            </if>
+            <if test="request.customerName != null and request.customerName !=''">
+                and CUSTOMER_NAME like concat('%',#{request.customerName},'%')
+            </if>
+        ) bo ON bo.id=bcr.order_id
         JOIN (
-        SELECT id
-        FROM customer_sample_info
-        WHERE is_del=0
-        <if test="request.sampleNo != null and request.sampleNo !=''">
-            and SAMPLE_NO like concat('%',#{request.sampleNo},'%')
-        </if>
-        <if test="request.sampleName != null and request.sampleName !=''">
-            and SAMPLE_NAME like concat('%',#{request.sampleName},'%')
-        </if>
-        ) csi ON csi.id=bcr.sampleId
+            SELECT id,sample_no,sample_name,sample_model,manufacturing_no,measure_type
+            FROM customer_sample_info
+            WHERE is_del=0
+            <if test="request.sampleNo != null and request.sampleNo !=''">
+                and SAMPLE_NO like concat('%',#{request.sampleNo},'%')
+            </if>
+            <if test="request.sampleName != null and request.sampleName !=''">
+                and SAMPLE_NAME like concat('%',#{request.sampleName},'%')
+            </if>
+        ) csi ON csi.id=bcr.sample_id
     </select>