package cn.iocoder.yudao.module.mes.dal.mysql.wm.warning;

import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.module.mes.controller.admin.wm.warning.vo.MesWmStockWarningPageReqVO;
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warning.MesWmStockWarningDO;
import org.apache.ibatis.annotations.Mapper;

/**
 * MES 库存预警 Mapper
 */
@Mapper
public interface MesWmStockWarningMapper extends BaseMapperX<MesWmStockWarningDO> {

    default PageResult<MesWmStockWarningDO> selectPage(MesWmStockWarningPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<MesWmStockWarningDO>()
                .likeIfPresent(MesWmStockWarningDO::getItemCode, reqVO.getItemCode())
                .likeIfPresent(MesWmStockWarningDO::getBatchCode, reqVO.getBatchCode())
                .eqIfPresent(MesWmStockWarningDO::getWarningType, reqVO.getWarningType())
                .eqIfPresent(MesWmStockWarningDO::getStatus, reqVO.getStatus())
                .orderByDesc(MesWmStockWarningDO::getCreateTime));
    }

}