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

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.checktype.CheckTypeDO;
import org.apache.ibatis.annotations.Mapper;
import cn.lihu.jh.module.ecg.controller.admin.checktype.vo.*;
import org.apache.ibatis.annotations.Select;

/**
 * 检查类型 Mapper
 *
 * @author majianbo
 */
@Mapper
public interface CheckTypeMapper extends BaseMapperX<CheckTypeDO> {

    default PageResult<CheckTypeDO> selectPage(CheckTypePageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<CheckTypeDO>()
                .likeIfPresent(CheckTypeDO::getName, reqVO.getName())
                .eqIfPresent(CheckTypeDO::getValue, reqVO.getValue())
                .eqIfPresent(CheckTypeDO::getReadyNum, reqVO.getReadyNum())
                .betweenIfPresent(CheckTypeDO::getCreateTime, reqVO.getCreateTime())
                .eqIfPresent(CheckTypeDO::getNeedDevReady, reqVO.getNeedDevReady())
                .eqIfPresent(CheckTypeDO::getCallingColumn, reqVO.getCallingColumn())
                .eqIfPresent(CheckTypeDO::getDisplayBarcode, reqVO.getDisplayBarcode())
                .eqIfPresent(CheckTypeDO::getExpenseRecognition, reqVO.getExpenseRecognition())
                .eqIfPresent(CheckTypeDO::getTimeslotBookNum, reqVO.getTimeslotBookNum())
                .eqIfPresent(CheckTypeDO::getTimeslotReservedNum, reqVO.getTimeslotReservedNum())
                .eqIfPresent(CheckTypeDO::getAffinityCheckTypes, reqVO.getAffinityCheckTypes())
                .orderByDesc(CheckTypeDO::getId));
    }

    @Select("<script> " +
              "SELECT * FROM lihu.check_type;" +
            "</script>")
    List<CheckTypeDO> simpleCheckTypeList();

}