From 3d191e81842cf3bcd6f841fbe2fc3d451c45ef99 Mon Sep 17 00:00:00 2001
From: hongjli <3117313295@qq.com>
Date: 星期三, 14 五月 2025 13:54:40 +0800
Subject: [PATCH] 钣金计划大表增加“异常状态”字段
---
aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateProcessStat.java | 3 +++
aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateProcessStatMapper.xml | 4 +++-
2 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateProcessStat.java b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateProcessStat.java
index 7190995..9f72691 100644
--- a/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateProcessStat.java
+++ b/aps-modules/aps-core/src/main/java/com/aps/core/domain/ApsPlateProcessStat.java
@@ -71,6 +71,9 @@
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date computePlanEndDay;
+ @Excel(name = "寮傚父鐘舵��", width = 50)
+ private String exceptionStatus;
+
/** 璁捐宸ユ椂 */
private Long designTimes;
diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateProcessStatMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateProcessStatMapper.xml
index 9f9a7ca..cb97682 100644
--- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateProcessStatMapper.xml
+++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlateProcessStatMapper.xml
@@ -23,12 +23,14 @@
<result property="createBy" column="create_by" />
<result property="delFlag" column="del_flag" />
<result property="warning" column="warning" />
+ <result property="exceptionStatus" column="exception_status" />
</resultMap>
<sql id="selectApsPlateProcessStatVo">
select id, work_order_no, process_name, num, route_process_number, current_process_number, production_quantity,
standard_time, process_total_time, process_plan_end_day,process_plan_start_day, order_plan_end_day, design_times,
- batch_number, create_by, del_flag, warning
+ batch_number, create_by, del_flag, warning,
+ CASE WHEN <![CDATA[ process_plan_start_day <= NOW() OR process_plan_end_day <= NOW() ]]> THEN '鏄�' ELSE '鍚�' END as exception_status
from aps_plate_process_stat
</sql>
--
Gitblit v1.9.3