From 309761da6a8484269c10f559c0cff41782652b6a Mon Sep 17 00:00:00 2001
From: sfd <sun.sunshine@163.com>
Date: 星期四, 08 五月 2025 17:14:36 +0800
Subject: [PATCH] 修改钣金计划管理字段映射
---
aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanOrderManagerMapper.xml | 16 ++++++++--------
1 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanOrderManagerMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanOrderManagerMapper.xml
index c4ae944..ab86a94 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanOrderManagerMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlatePlanOrderManagerMapper.xml
@@ -7,19 +7,19 @@
<resultMap type="ApsPlateOrderPlanManager" id="ApsPlateOrderPlanManagerResult">
<result property="require_id" column="requireId" />
<result property="requireTrackId" column="require_track_id" />
- <result property="docNo" column="doc_no" />
+ <result property="workOrderNo" column="doc_no" />
<result property="deductionAmount" column="deduction_amount" />
- <result property="workOrderType" column="work_order_type" />
+ <result property="workOrderType" column="professional_affiliation" />
<result property="mainPartNumber" column="main_part_number" />
<result property="mainPartDrawingNumber" column="main_part_drawing_number" />
<result property="customer" column="customer" />
<result property="productionQuantity" column="production_quantity" />
- <result property="applicableFactories" column="applicable_factories" />
+ <result property="applicableFactories" column="plant" />
<result property="productionBase" column="production_base" />
<result property="planStartDay" column="plan_start_day" />
<result property="planEndDay" column="plan_end_day" />
<result property="unmatchedQuantity" column="unmatched_quantity" />
- <result property="hasDelayRisk" column="has_delay_risk" />
+ <result property="hasDelayRisk" column="has_risk" />
</resultMap>
<select id="selectApsPlanOrderManager" parameterType="ApsPlateOrderPlanManager" resultMap="ApsPlateOrderPlanManagerResult">
@@ -28,17 +28,17 @@
detail.require_track_id,
detail.doc_no,
detail.deduction_amount,
- plan.professional_affiliation as workOrderType,
- plan.main_part_number as item_number,
+ plan.professional_affiliation,
+ plan.main_part_number,
plan.main_part_drawing_number,
plan.customer,
plan.production_quantity,
- plan.plant as applicable_factories,
+ plan.plant,
plan.production_base,
plan.plan_start_day,
plan.plan_end_day,
plan.unmatched_quantity,
- plan.has_risk as has_delay_risk
+ plan.has_risk
from aps_plate_standard_require_bom_order_detail detail
left join aps_plate_plan plan on detail.doc_no = plan.document_number
<where>
--
Gitblit v1.9.3