| | |
|---|
| | | @Mapper |
|---|
| | | public interface MesWmTransactionMapper extends BaseMapperX<MesWmTransactionDO> { |
|---|
| | | |
|---|
| | | @org.apache.ibatis.annotations.Select("SELECT COALESCE(-SUM(quantity), 0) FROM mes_wm_transaction WHERE biz_type = 119 AND type = 2 AND biz_line_id = #{lineId} AND deleted = 0") |
|---|
| | | java.math.BigDecimal sumSalesOutboundByLineId(Long lineId); |
|---|
| | | |
|---|
| | | default PageResult<MesWmTransactionDO> selectPage(MesWmTransactionPageReqVO reqVO) { |
|---|
| | | return selectPage(reqVO, new LambdaQueryWrapperX<MesWmTransactionDO>() |
|---|
| | | .eqIfPresent(MesWmTransactionDO::getItemId, reqVO.getItemId()) |
|---|
| | | .likeIfPresent(MesWmTransactionDO::getBatchCode, reqVO.getBatchCode()) |
|---|
| | | .eqIfPresent(MesWmTransactionDO::getBatchCode, reqVO.getBatchCodeExact()) |
|---|
| | | .likeIfPresent(MesWmTransactionDO::getBagCode, reqVO.getBagCode()) |
|---|
| | | .eqIfPresent(MesWmTransactionDO::getShipmentId, reqVO.getShipmentId()) |
|---|
| | | .eqIfPresent(MesWmTransactionDO::getWarehouseId, reqVO.getWarehouseId()) |
|---|
| | | .eqIfPresent(MesWmTransactionDO::getLocationId, reqVO.getLocationId()) |
|---|
| | | .eqIfPresent(MesWmTransactionDO::getAreaId, reqVO.getAreaId()) |
|---|
| | | .eqIfPresent(MesWmTransactionDO::getType, reqVO.getType()) |
|---|
| | | .eqIfPresent(MesWmTransactionDO::getBizType, reqVO.getBizType()) |
|---|
| | | .likeIfPresent(MesWmTransactionDO::getBizCode, reqVO.getBizCode()) |
|---|
| | | .eqIfPresent(MesWmTransactionDO::getBizCode, reqVO.getBizCodeExact()) |
|---|
| | | .eqIfPresent(MesWmTransactionDO::getMaterialStockId, reqVO.getMaterialStockId()) |
|---|
| | | .geIfPresent(MesWmTransactionDO::getTransactionTime, reqVO.getStartTime()) |
|---|
| | | .leIfPresent(MesWmTransactionDO::getTransactionTime, reqVO.getEndTime()) |
|---|
