From a156ddbb26693b8040f9dbbd7582a12c1fc8d61b Mon Sep 17 00:00:00 2001 From: eight <641137800@qq.com> Date: 星期四, 07 十一月 2024 17:04:47 +0800 Subject: [PATCH] 预约序号 --- jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/devrent/DevRentMapper.java | 19 +++++++++++++++++++ 1 files changed, 19 insertions(+), 0 deletions(-) diff --git a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/devrent/DevRentMapper.java b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/devrent/DevRentMapper.java index 854f2c3..cbe70ec 100644 --- a/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/devrent/DevRentMapper.java +++ b/jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/devrent/DevRentMapper.java @@ -36,6 +36,25 @@ .orderByDesc(DevRentDO::getId)); } + @Select("<script> " + + "SELECT * FROM lihu.dev_rent " + + "<where> " + + " <if test='stateList != null'> " + + " and state in ( " + + " <foreach collection='stateList' separator=',' item='state'> " + + " #{state} " + + " </foreach> ) " + + " </if> " + + " <if test=\"devId != null and devId != ''\"> " + + " and dev_id = #{devId} " + + " </if> " + + " <if test=\"patId != null and patId != ''\"> " + + " and pat_id = #{patId} " + + " </if> " + + "</where> " + + "order by create_time desc " + + "limit 1 " + + "</script>") DevRentDO getRentByState(DevRentSearchReqVO reqVO ); @Select("select * from lihu.dev_rent where state=#{state} and pat_id=#{patId} and to_days(create_time)=to_days(now())") -- Gitblit v1.9.3