From f4d7ac0f1c7799893e47ea950aa82117a0e721fa Mon Sep 17 00:00:00 2001
From: yuan <123@>
Date: 星期三, 01 四月 2026 22:17:44 +0800
Subject: [PATCH] 质检查询优化：简化selectOneData字段
---
src/main/resources/static/out-report-template.docx | 0
src/main/resources/mapper/quality/QualityInspectMapper.xml | 36 ++----------------------------------
2 files changed, 2 insertions(+), 34 deletions(-)
diff --git a/src/main/resources/mapper/quality/QualityInspectMapper.xml b/src/main/resources/mapper/quality/QualityInspectMapper.xml
index c2bcab9..e8494eb 100644
--- a/src/main/resources/mapper/quality/QualityInspectMapper.xml
+++ b/src/main/resources/mapper/quality/QualityInspectMapper.xml
@@ -444,34 +444,7 @@
</select>
<select id="selectOneData" resultType="com.ruoyi.quality.pojo.QualityInspect">
- select id,
- inspect_type,
- check_time,
- production_date,
- supplier,
- customer,
- process,
- check_name,
- product_id,
- product_name,
- model,
- unit,
- quantity,
- check_company,
- check_result,
- create_time,
- create_user,
- update_time,
- update_user,
- tenant_id,
- inspect_state,
- purchase_ledger_id,
- product_main_id,
- defective_phenomena,
- product_model_id,
- test_standard_id,
- inspected_quantity,
-
+ select *,
case
when inspect_material_condition = '妫�楠岀敤娑插墏鎯呭喌' then
'鈽�'
@@ -483,12 +456,7 @@
'鈽�'
else
'鈽�'
- end as inspect_material_condition_b,
-
- validity_date,
- manufacturing_team,
- batch_no
-
+ end as inspect_material_condition_b
from quality_inspect
where id = #{id};
</select>
diff --git a/src/main/resources/static/out-report-template.docx b/src/main/resources/static/out-report-template.docx
index d01b54d..24023ef 100644
--- a/src/main/resources/static/out-report-template.docx
+++ b/src/main/resources/static/out-report-template.docx
Binary files differ
--
Gitblit v1.9.3