| | |
|---|
| | | .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）， |
|---|
