From b852254d90e7d1955db31db154193ec8ee84d8b3 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期三, 09 九月 2026 10:57:59 +0800
Subject: [PATCH] feat(hrm): 新增员工用工性质、班组归属字段及考勤异常处理优化
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/transaction/MesWmTransactionMapper.java | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/transaction/MesWmTransactionMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/transaction/MesWmTransactionMapper.java
index 878347e..192ca52 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/transaction/MesWmTransactionMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/transaction/MesWmTransactionMapper.java
@@ -24,12 +24,27 @@
.eqIfPresent(MesWmTransactionDO::getBizType, reqVO.getBizType())
.likeIfPresent(MesWmTransactionDO::getBizCode, reqVO.getBizCode())
.eqIfPresent(MesWmTransactionDO::getMaterialStockId, reqVO.getMaterialStockId())
+ .eqIfPresent(MesWmTransactionDO::getSnCode, reqVO.getSnCode())
.geIfPresent(MesWmTransactionDO::getTransactionTime, reqVO.getStartTime())
.leIfPresent(MesWmTransactionDO::getTransactionTime, reqVO.getEndTime())
.orderByDesc(MesWmTransactionDO::getTransactionTime));
}
/**
+ * 鎸� SN 鐮佹煡璇㈡渶杩戜竴绗斿簱瀛樹簨鍔�
+ *
+ * @param snCode SN 鐮�
+ * @return 鏈�杩戜竴绗斾簨鍔★紝涓嶅瓨鍦ㄨ繑鍥� null
+ */
+ default MesWmTransactionDO selectLatestBySnCode(String snCode) {
+ return selectOne(new LambdaQueryWrapperX<MesWmTransactionDO>()
+ .eq(MesWmTransactionDO::getSnCode, snCode)
+ .orderByDesc(MesWmTransactionDO::getTransactionTime)
+ .orderByDesc(MesWmTransactionDO::getId)
+ .last("LIMIT 1"));
+ }
+
+ /**
* 鏌ユ壘铏氭嫙绾胯竟搴撳簱瀛樿褰曞搴旂殑鍘熷鍑哄簱浠撳簱淇℃伅
* <p>
* 閫氳繃铏氭嫙绾胯竟搴撶殑 materialStockId锛屾壘鍒伴娆″叆搴撲簨鍔★紙IN锛夛紝
--
Gitblit v1.9.3