package cn.iocoder.yudao.module.vehicle.dal.mysql.application;

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.vehicle.controller.admin.application.vo.VehicleApplicationPageReqVO;
import cn.iocoder.yudao.module.vehicle.dal.dataobject.application.VehicleApplicationDO;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface VehicleApplicationMapper extends BaseMapperX<VehicleApplicationDO> {

    default VehicleApplicationDO selectByNo(String no) {
        return selectOne(VehicleApplicationDO::getNo, no);
    }

    default PageResult<VehicleApplicationDO> selectPage(VehicleApplicationPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<VehicleApplicationDO>()
                .likeIfPresent(VehicleApplicationDO::getNo, reqVO.getNo())
                .likeIfPresent(VehicleApplicationDO::getApplicantName, reqVO.getApplicantName())
                .likeIfPresent(VehicleApplicationDO::getDestination, reqVO.getDestination())
                .eqIfPresent(VehicleApplicationDO::getStatus, reqVO.getStatus())
                .betweenIfPresent(VehicleApplicationDO::getUseStartTime, reqVO.getUseTime())
                .orderByDesc(VehicleApplicationDO::getId));
    }

}