package cn.iocoder.yudao.module.mes.dal.mysql.dv.spare;
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.module.mes.dal.dataobject.dv.spare.MesDvSparePartDO;
import cn.iocoder.yudao.module.mes.controller.admin.dv.spare.vo.MesDvSparePageReqVO;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface MesDvSparePartMapper extends BaseMapperX<MesDvSparePartDO> {
    default MesDvSparePartDO lock(Long id) {
        return selectOne(new LambdaQueryWrapperX<MesDvSparePartDO>().eq(MesDvSparePartDO::getId,id).last("FOR UPDATE"));
    }
    default PageResult<MesDvSparePartDO> page(MesDvSparePageReqVO req) {
        return selectPage(req,new LambdaQueryWrapperX<MesDvSparePartDO>()
                .eqIfPresent(MesDvSparePartDO::getCode,req.getCode())
                .likeIfPresent(MesDvSparePartDO::getName,req.getName())
                .eqIfPresent(MesDvSparePartDO::getStatus,req.getStatus())
                .apply(Boolean.TRUE.equals(req.getShortageOnly()),"stock_quantity < safety_quantity")
                .orderByDesc(MesDvSparePartDO::getId));
    }
}