工位选择界面 诊室按照room id排序

eight

2024-12-12 2bc90e242eceb83d9aa80d48ea9f991c0f9b99c6

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queuesequence/QueueSequenceMapper.java

@@ -29,6 +29,15 @@
                .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();