update

eight

2024-08-15 8c2f79b721a05fbf73c50a78b267ea3868c632d2

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queue/queueMapper.java

@@ -1,13 +1,17 @@
package cn.lihu.jh.module.ecg.dal.mysql.queue;

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.queue.queueDO;
import cn.lihu.jh.module.ecg.dal.dataobject.queue.QueueDO;
import cn.lihu.jh.module.ecg.dal.dataobject.queue.QueueStatisticDO;
import cn.lihu.jh.module.ecg.dal.dataobject.room.RoomStatisticsDO;
import org.apache.ibatis.annotations.Mapper;
import cn.lihu.jh.module.ecg.controller.admin.queue.vo.*;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 排队 Mapper
@@ -15,23 +19,34 @@
 * @author 芋道源码
 */
@Mapper
public interface queueMapper extends BaseMapperX<queueDO> {
public interface queueMapper extends BaseMapperX<QueueDO> {

    default PageResult<queueDO> selectPage(queuePageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<queueDO>()
                .eqIfPresent(queueDO::getPatId, reqVO.getPatId())
                .likeIfPresent(queueDO::getPatName, reqVO.getPatName())
                .eqIfPresent(queueDO::getPatGender, reqVO.getPatGender())
                .eqIfPresent(queueDO::getBookTimeslot, reqVO.getBookTimeslot())
                .eqIfPresent(queueDO::getBookCheckType, reqVO.getBookCheckType())
                .eqIfPresent(queueDO::getSeqNum, reqVO.getSeqNum())
                .eqIfPresent(queueDO::getStatus, reqVO.getStatus())
                .eqIfPresent(queueDO::getPassed, reqVO.getPassed())
                .eqIfPresent(queueDO::getExpired, reqVO.getExpired())
                .eqIfPresent(queueDO::getRoomNum, reqVO.getRoomNum())
                .eqIfPresent(queueDO::getBedNum, reqVO.getBedNum())
                .betweenIfPresent(queueDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(queueDO::getId));
    default PageResult<QueueDO> selectPage(QueuePageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<QueueDO>()
                .eqIfPresent(QueueDO::getPatId, reqVO.getPatId())
                .likeIfPresent(QueueDO::getPatName, reqVO.getPatName())
                .eqIfPresent(QueueDO::getPatGender, reqVO.getPatGender())
                .eqIfPresent(QueueDO::getBookTimeslot, reqVO.getBookTimeslot())
                .eqIfPresent(QueueDO::getBookCheckType, reqVO.getBookCheckType())
                .eqIfPresent(QueueDO::getSeqNum, reqVO.getSeqNum())
                .eqIfPresent(QueueDO::getStatus, reqVO.getStatus())
                .eqIfPresent(QueueDO::getPassed, reqVO.getPassed())
                .eqIfPresent(QueueDO::getExpired, reqVO.getExpired())
                .eqIfPresent(QueueDO::getRoomNum, reqVO.getRoomNum())
                .eqIfPresent(QueueDO::getBedNum, reqVO.getBedNum())
                .betweenIfPresent(QueueDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(QueueDO::getId));
    }

    @Select("<script>" +
            "SELECT status, count(1) as total_in_status FROM lihu.queue where status in (" +
            " <foreach collection='statusList' separator=',' item='status'>" +
            " #{status} " +
            " </foreach> )" +
            " group by status; "
            +"</script>")
    List<QueueStatisticDO> queueStatistic(@Param("statusList")List<Byte> statusList);

    @Select("SELECT max(seq_num) FROM lihu.queue")
    int getMaxSeqNum();
}