eight
2024-11-29 04480e19c8b47c2cb469811d47679c923b82710d
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
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.*;
import cn.lihu.jh.module.ecg.controller.admin.queuesequence.vo.*;
 
/**
 * 当天序号 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));
    }
 
    @Select(" select * from lihu.queue_sequence where check_type=#{checkType}; ")
    List<QueueSequenceDO> selectTimeslotByCheckType(Integer checkType);
 
    @Select( "select count(1) from lihu.queue_sequence")
    Integer getQueueSequenceTableRowCount();
 
    @Delete("delete from lihu.queue_sequence where TO_DAYS(create_time) != TO_DAYS(NOW())")
    void clearQueueSequenceTableNotCurrent();
 
    @Update("truncate table lihu.queue_sequence")
    void clearQueueSequenceTable();
 
    @Select("select queue_no from lihu.queue_sequence where check_type=#{checkType} and time_slot=#{timeslot} and queue_no < queue_full for update; ")
    Integer selectQueueNoForUpdate(@Param("checkType") Integer checkType, @Param("timeslot") Integer timeslot);
 
    @Update("update lihu.queue_sequence set queue_no = queue_no + 1 where check_type=#{checkType} and time_slot=#{timeslot} and queue_no=#{curQueueNo} and queue_no < queue_full; ")
    Integer updateGivenCheckTypeTimeslotSeqNo(@Param("checkType") Integer checkType, @Param("timeslot") Integer timeslot, @Param("curQueueNo") Integer curQueueNo);
 
    @Select("select queue_vip_no from lihu.queue_sequence where check_type=#{checkType} and time_slot=#{timeslot} and queue_no < queue_full for update; ")
    Integer selectQueueVipNoForUpdate(@Param("checkType") Integer checkType, @Param("timeslot") Integer timeslot);
 
    @Update("update lihu.queue_sequence set queue_vip_no = queue_vip_no + 1 where check_type=#{checkType} and time_slot=#{timeslot} and queue_vip_no=#{curQueueVipNo} and queue_vip_no < queue_vip_full; ")
    Integer updateGivenCheckTypeTimeslotVipSeqNo(@Param("checkType") Integer checkType, @Param("timeslot") Integer timeslot, @Param("curQueueVipNo") Integer curQueueVipNo);
}