From 4ca4444ad33a2a1a51f5c06e78ee9365dfb1eed6 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期四, 08 十月 2026 17:11:11 +0800
Subject: [PATCH] feat(mes): 种子二维码标签国标四要素合规改造
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/materialstockbag/MesWmMaterialStockBagMapper.java | 82 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 82 insertions(+), 0 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/materialstockbag/MesWmMaterialStockBagMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/materialstockbag/MesWmMaterialStockBagMapper.java
new file mode 100644
index 0000000..d1727b5
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/wm/materialstockbag/MesWmMaterialStockBagMapper.java
@@ -0,0 +1,82 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.wm.materialstockbag;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockBagPageReqVO;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.dal.dataobject.wm.materialstockbag.MesWmMaterialStockBagDO;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.util.Collection;
+import java.util.List;
+
+@Mapper
+public interface MesWmMaterialStockBagMapper extends BaseMapperX<MesWmMaterialStockBagDO> {
+
+ default PageResult<MesWmMaterialStockBagDO> selectPage(MesWmMaterialStockBagPageReqVO reqVO) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
+ .eq(MesWmMaterialStockBagDO::getMaterialStockId, reqVO.getMaterialStockId())
+ .likeIfPresent(MesWmMaterialStockBagDO::getBagCode, reqVO.getBagCode())
+ .eq(MesWmMaterialStockBagDO::getStatus, 1)
+ .orderByAsc(MesWmMaterialStockBagDO::getInboundTime));
+ }
+
+ default MesWmMaterialStockBagDO selectByBagCode(String bagCode) {
+ return selectOne(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
+ .eq(MesWmMaterialStockBagDO::getBagCode, bagCode)
+ .orderByDesc(MesWmMaterialStockBagDO::getId)
+ .last("LIMIT 1"));
+ }
+
+ default MesWmMaterialStockBagDO selectByBagCodeId(Long bagCodeId) {
+ return selectOne(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
+ .eq(MesWmMaterialStockBagDO::getBagCodeId, bagCodeId)
+ .orderByDesc(MesWmMaterialStockBagDO::getId)
+ .last("LIMIT 1"));
+ }
+
+ default MesWmMaterialStockBagDO selectOneActiveByMaterialStockId(Long materialStockId) {
+ return selectOne(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
+ .eq(MesWmMaterialStockBagDO::getMaterialStockId, materialStockId)
+ .eq(MesWmMaterialStockBagDO::getStatus, 1)
+ .last("LIMIT 1"));
+ }
+
+ default MesWmMaterialStockBagDO selectActiveByBagCode(String bagCode) {
+ return selectOne(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
+ .eq(MesWmMaterialStockBagDO::getBagCode, bagCode)
+ .eq(MesWmMaterialStockBagDO::getStatus, 1)
+ .last("LIMIT 1"));
+ }
+
+ default MesWmMaterialStockBagDO selectActiveByBagCodeId(Long bagCodeId) {
+ return selectOne(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
+ .eq(MesWmMaterialStockBagDO::getBagCodeId, bagCodeId)
+ .eq(MesWmMaterialStockBagDO::getStatus, 1)
+ .last("LIMIT 1"));
+ }
+
+ default List<MesWmMaterialStockBagDO> selectActiveListByItemAndBatch(Long itemId, Long batchId, Integer stockState) {
+ return selectList(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
+ .eq(MesWmMaterialStockBagDO::getItemId, itemId)
+ .eqIfPresent(MesWmMaterialStockBagDO::getBatchId, batchId)
+ .eqIfPresent(MesWmMaterialStockBagDO::getStockState, stockState)
+ .eq(MesWmMaterialStockBagDO::getStatus, 1)
+ .eq(MesWmMaterialStockBagDO::getFrozen, false)
+ .orderByAsc(MesWmMaterialStockBagDO::getInboundTime));
+ }
+
+ default List<MesWmMaterialStockBagDO> selectListByMaterialStockIds(Collection<Long> materialStockIds) {
+ return selectList(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
+ .in(MesWmMaterialStockBagDO::getMaterialStockId, materialStockIds)
+ .eq(MesWmMaterialStockBagDO::getStatus, 1)
+ .orderByAsc(MesWmMaterialStockBagDO::getInboundTime));
+ }
+
+ default List<MesWmMaterialStockBagDO> selectListByMaterialStockId(Long materialStockId) {
+ return selectList(new LambdaQueryWrapperX<MesWmMaterialStockBagDO>()
+ .eq(MesWmMaterialStockBagDO::getMaterialStockId, materialStockId)
+ .eq(MesWmMaterialStockBagDO::getStatus, 1)
+ .orderByAsc(MesWmMaterialStockBagDO::getInboundTime));
+ }
+}
--
Gitblit v1.9.3