From 9075785a9e14f6220783d052d231f915c6930b87 Mon Sep 17 00:00:00 2001
From: xiaoyi <908147524@qq.com>
Date: 星期三, 04 十一月 2026 10:21:45 +0800
Subject: [PATCH] revert(collect): 撤销 collect 数采模块（新高设备管理已有自己的采集方式）
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/materialstock/MesWmMaterialStockMapper.java | 39 +++++++++++++++++++++++++++++++++++++++
1 files changed, 39 insertions(+), 0 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/materialstock/MesWmMaterialStockMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/materialstock/MesWmMaterialStockMapper.java
index 38a7df2..8d2ad22 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/materialstock/MesWmMaterialStockMapper.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/materialstock/MesWmMaterialStockMapper.java
@@ -124,6 +124,45 @@
* 鍞竴閿細(itemId, warehouseId, locationId, areaId, batchId, vendorId)
* 鍚屼竴鐗╂枡鍚屼竴搴撲綅锛屼笉鍚屼緵搴斿晢/鎵规鐨勫簱瀛樺垎寮�绠＄悊
*/
+ /** 鏌ユ壘瀵煎叆鍩虹缁村害鐨勬墍鏈夊簱瀛橈紝鐢ㄤ簬妫�娴嬩緵搴斿晢姝т箟銆� */
+ default List<MesWmMaterialStockDO> selectImportBaseStocksForUpdate(Long itemId, Long warehouseId,
+ Long locationId, Long areaId, Long batchId) {
+ LambdaQueryWrapperX<MesWmMaterialStockDO> query = new LambdaQueryWrapperX<MesWmMaterialStockDO>()
+ .eq(MesWmMaterialStockDO::getItemId, itemId).eq(MesWmMaterialStockDO::getWarehouseId, warehouseId)
+ .eq(MesWmMaterialStockDO::getLocationId, locationId).eq(MesWmMaterialStockDO::getAreaId, areaId);
+ if (batchId == null) query.isNull(MesWmMaterialStockDO::getBatchId);
+ else query.eq(MesWmMaterialStockDO::getBatchId, batchId);
+ return selectList(query.last("FOR UPDATE"));
+ }
+ /** 搴撳瓨瀵煎叆浣跨敤褰撳墠璇伙紝渚涘簲鍟嗗拰鎵规涓虹┖鏃朵篃绮剧‘鍖归厤銆� */
+ default List<MesWmMaterialStockDO> selectAreaStocksForUpdate(Long areaId) {
+ return selectList(new LambdaQueryWrapperX<MesWmMaterialStockDO>()
+ .eq(MesWmMaterialStockDO::getAreaId, areaId).last("FOR UPDATE"));
+ }
+
+ /** 鍒涘缓搴撳瓨鏃剁殑褰撳墠璇伙紱渚涘簲鍟嗕负绌烘椂淇濈暀鐜版湁涓氬姟鐨勪换鎰忎緵搴斿晢鍖归厤瑙勫垯銆� */
+ default MesWmMaterialStockDO selectByCompositeKeyForUpdate(Long itemId, Long warehouseId, Long locationId,
+ Long areaId, Long batchId, Long vendorId) {
+ LambdaQueryWrapperX<MesWmMaterialStockDO> query = new LambdaQueryWrapperX<MesWmMaterialStockDO>()
+ .eq(MesWmMaterialStockDO::getItemId, itemId).eq(MesWmMaterialStockDO::getWarehouseId, warehouseId)
+ .eq(MesWmMaterialStockDO::getLocationId, locationId).eq(MesWmMaterialStockDO::getAreaId, areaId);
+ if (batchId == null) query.isNull(MesWmMaterialStockDO::getBatchId);
+ else query.eq(MesWmMaterialStockDO::getBatchId, batchId);
+ if (vendorId != null) query.eq(MesWmMaterialStockDO::getVendorId, vendorId);
+ return selectOne(query.last("ORDER BY quantity DESC LIMIT 1 FOR UPDATE"));
+ }
+ /** 搴撳瓨瀵煎叆绮剧‘鍖归厤鎵规鍜屼緵搴斿晢锛岀┖鍊兼寜绌哄�煎尮閰嶃�� */
+ default List<MesWmMaterialStockDO> selectImportStocksForUpdate(Long itemId, Long warehouseId, Long locationId,
+ Long areaId, Long batchId, Long vendorId) {
+ LambdaQueryWrapperX<MesWmMaterialStockDO> query = new LambdaQueryWrapperX<MesWmMaterialStockDO>()
+ .eq(MesWmMaterialStockDO::getItemId, itemId).eq(MesWmMaterialStockDO::getWarehouseId, warehouseId)
+ .eq(MesWmMaterialStockDO::getLocationId, locationId).eq(MesWmMaterialStockDO::getAreaId, areaId);
+ if (batchId == null) query.isNull(MesWmMaterialStockDO::getBatchId);
+ else query.eq(MesWmMaterialStockDO::getBatchId, batchId);
+ if (vendorId == null) query.isNull(MesWmMaterialStockDO::getVendorId);
+ else query.eq(MesWmMaterialStockDO::getVendorId, vendorId);
+ return selectList(query.last("FOR UPDATE"));
+ }
default MesWmMaterialStockDO selectByCompositeKey(Long itemId, Long warehouseId, Long locationId,
Long areaId, Long batchId, Long vendorId) {
LambdaQueryWrapperX<MesWmMaterialStockDO> wrapper = new LambdaQueryWrapperX<MesWmMaterialStockDO>()
--
Gitblit v1.9.3