From 7d2ee3cef2e0d68ba6400bc5957640d2771bbf4c Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期三, 16 九月 2026 18:05:40 +0800
Subject: [PATCH] refactor: 单据审核改为审批配置状态机(新增:audit接口/审核人字段/DB变更脚本)

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/techconfirm/ProductTechConfirmMapper.java |   46 ++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 46 insertions(+), 0 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/techconfirm/ProductTechConfirmMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/techconfirm/ProductTechConfirmMapper.java
index befbb93..d4529cd 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/techconfirm/ProductTechConfirmMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/techconfirm/ProductTechConfirmMapper.java
@@ -5,7 +5,10 @@
 import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
 import cn.iocoder.yudao.module.mes.controller.admin.pd.techconfirm.vo.ProductTechConfirmPageReqVO;
 import cn.iocoder.yudao.module.mes.dal.dataobject.pd.techconfirm.ProductTechConfirmDO;
+import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
 import org.apache.ibatis.annotations.Mapper;
+
+import java.time.LocalDateTime;
 
 @Mapper
 public interface ProductTechConfirmMapper extends BaseMapperX<ProductTechConfirmDO> {
@@ -20,4 +23,47 @@
                 .orderByDesc(ProductTechConfirmDO::getId));
     }
 
+    /**
+     * 鎻愪氦瀹℃牳锛氱疆涓哄緟瀹℃牳锛屽苟娓呯┖涓婁竴杞鏍哥粨鏋�
+     *
+     * 涔嬫墍浠ョ敤 UpdateWrapper 鑰岄潪 updateById锛歁yBatis-Plus 榛樿鐨勫瓧娈垫洿鏂扮瓥鐣ヤ細蹇界暐 null锛�
+     * 鐩存帴 updateById 鏃犳硶鎶婂鏍镐笉閫氳繃鍚庢畫鐣欑殑瀹℃牳浜恒�佸鏍告椂闂淬�佸鏍告剰瑙佺湡姝f竻绌恒��
+     *
+     * @param id     缂栧彿
+     * @param status 鐩爣鐘舵�侊紙寰呭鏍革級
+     * @return 褰卞搷琛屾暟
+     */
+    default int submitAndResetAuditInfo(Long id, Integer status) {
+        return update(null, new LambdaUpdateWrapper<ProductTechConfirmDO>()
+                .eq(ProductTechConfirmDO::getId, id)
+                .set(ProductTechConfirmDO::getStatus, status)
+                .set(ProductTechConfirmDO::getReviewerId, null)
+                .set(ProductTechConfirmDO::getReviewerName, null)
+                .set(ProductTechConfirmDO::getReviewTime, null)
+                .set(ProductTechConfirmDO::getReviewRemark, null));
+    }
+
+    /**
+     * 瀹℃牳锛氬啓鍏ュ鏍哥粨鏋溿�佸鏍镐汉涓庡鏍告剰瑙�
+     *
+     * reviewRemark 鍏佽涓� null锛堝鏍搁�氳繃鏃舵剰瑙佸彲閫夛級锛屾晠鍚屾牱浣跨敤 UpdateWrapper 鐩村啓銆�
+     *
+     * @param id           缂栧彿
+     * @param status       鐩爣鐘舵�侊紙宸插鏍� / 瀹℃牳涓嶉�氳繃锛�
+     * @param reviewerId   瀹℃牳浜虹紪鍙�
+     * @param reviewerName 瀹℃牳浜哄鍚�
+     * @param reviewRemark 瀹℃牳鎰忚
+     * @return 褰卞搷琛屾暟
+     */
+    default int auditTechConfirm(Long id, Integer status, Long reviewerId,
+                                 String reviewerName, String reviewRemark) {
+        return update(null, new LambdaUpdateWrapper<ProductTechConfirmDO>()
+                .eq(ProductTechConfirmDO::getId, id)
+                .set(ProductTechConfirmDO::getStatus, status)
+                .set(ProductTechConfirmDO::getReviewerId, reviewerId)
+                .set(ProductTechConfirmDO::getReviewerName, reviewerName)
+                .set(ProductTechConfirmDO::getReviewTime, LocalDateTime.now())
+                .set(ProductTechConfirmDO::getReviewRemark, reviewRemark));
+    }
+
 }

--
Gitblit v1.9.3