package cn.iocoder.yudao.module.hrm.dal.mysql.supply; import cn.iocoder.yudao.framework.common.enums.CommonStatusEnum; 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.hrm.controller.admin.supply.vo.HrmSupplyPageReqVO; import cn.iocoder.yudao.module.hrm.dal.dataobject.supply.HrmSupplyDO; import org.apache.ibatis.annotations.Mapper; import java.util.List; /** * 办公用品档案 Mapper * * @author 超级管理员 */ @Mapper public interface HrmSupplyMapper extends BaseMapperX { default PageResult selectPage(HrmSupplyPageReqVO reqVO) { return selectPage(reqVO, new LambdaQueryWrapperX() .likeIfPresent(HrmSupplyDO::getCode, reqVO.getCode()) .likeIfPresent(HrmSupplyDO::getName, reqVO.getName()) .eqIfPresent(HrmSupplyDO::getCategory, reqVO.getCategory()) .eqIfPresent(HrmSupplyDO::getStatus, reqVO.getStatus()) .orderByDesc(HrmSupplyDO::getId)); } default HrmSupplyDO selectByCode(String code) { return selectOne(HrmSupplyDO::getCode, code); } default List selectEnabledList() { return selectList(new LambdaQueryWrapperX() .eq(HrmSupplyDO::getStatus, CommonStatusEnum.ENABLE.getStatus()) .orderByAsc(HrmSupplyDO::getCode) .orderByAsc(HrmSupplyDO::getId)); } }