package cn.lihu.jh.module.ecg.dal.mysql.devrent;

import java.util.*;

import cn.lihu.jh.framework.common.pojo.PageResult;
import cn.lihu.jh.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.lihu.jh.framework.mybatis.core.mapper.BaseMapperX;
import cn.lihu.jh.module.ecg.dal.dataobject.devrent.DevRentDO;
import org.apache.ibatis.annotations.Mapper;
import cn.lihu.jh.module.ecg.controller.admin.devrent.vo.*;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 装机拆机 Mapper
 *
 * @author 芋道源码
 */
@Mapper
public interface DevRentMapper extends BaseMapperX<DevRentDO> {

    default PageResult<DevRentDO> selectPage(DevRentPageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<DevRentDO>()
                .eqIfPresent(DevRentDO::getDevId, reqVO.getDevId())
                .eqIfPresent(DevRentDO::getPatId, reqVO.getPatId())
                .likeIfPresent(DevRentDO::getPatName, reqVO.getPatName())
                .betweenIfPresent(DevRentDO::getRentTime, reqVO.getRentTime())
                .betweenIfPresent(DevRentDO::getReturnTime, reqVO.getReturnTime())
                .eqIfPresent(DevRentDO::getInterference, reqVO.getInterference())
                .eqIfPresent(DevRentDO::getBaseline, reqVO.getBaseline())
                .eqIfPresent(DevRentDO::getDetachment, reqVO.getDetachment())
                .eqIfPresent(DevRentDO::getRemark, reqVO.getRemark())
                .betweenIfPresent(DevRentDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(DevRentDO::getId));
    }

    @Select("select * from lihu.dev_rent where dev_id=#{devId} order by rent_time desc limit 1")
    DevRentDO getLatestRent( @Param("devId") String devId );

}