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

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

/**
 * 当天序号 Mapper
 *
 * @author 金华医院
 */
@Mapper
public interface QueueSequenceMapper extends BaseMapperX<QueueSequenceDO> {

    default PageResult<QueueSequenceDO> selectPage(QueueSequencePageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<QueueSequenceDO>()
                .eqIfPresent(QueueSequenceDO::getCheckType, reqVO.getCheckType())
                .eqIfPresent(QueueSequenceDO::getTimeSlot, reqVO.getTimeSlot())
                .eqIfPresent(QueueSequenceDO::getQueueNo, reqVO.getQueueNo())
                .eqIfPresent(QueueSequenceDO::getQueueVipNo, reqVO.getQueueVipNo())
                .eqIfPresent(QueueSequenceDO::getQueueFull, reqVO.getQueueFull())
                .eqIfPresent(QueueSequenceDO::getQueueVipFull, reqVO.getQueueVipFull())
                .betweenIfPresent(QueueSequenceDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(QueueSequenceDO::getId));
    }

    @Update("truncate table lihu.queue_sequence")
    void clearQueueSequenceTable();

}