质检查询优化：简化selectOneData字段

yuan

4 天以前 f4d7ac0f1c7799893e47ea950aa82117a0e721fa

质检查询优化：简化selectOneData字段

 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>

 src/main/resources/static/out-report-template.docx

Binary files differ