From 647095a34d62db02533cf9c121436900b51c757c Mon Sep 17 00:00:00 2001 From: eight <641137800@qq.com> Date: 星期二, 15 十月 2024 15:07:13 +0800 Subject: [PATCH] update --- jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/devrent/DevRentMapper.java | 17 ++++++++++++++--- 1 files changed, 14 insertions(+), 3 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 c90ef5a..360b2d3 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 @@ -6,11 +6,11 @@ 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.devrent.DevRentDO; +import cn.lihu.jh.module.ecg.dal.dataobject.queue.QueueDO; import org.apache.ibatis.annotations.Mapper; import cn.lihu.jh.module.ecg.controller.admin.devrent.vo.*; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; -import org.apache.ibatis.annotations.Update; /** * 瑁呮満鎷嗘満 Mapper @@ -35,8 +35,19 @@ .orderByDesc(DevRentDO::getId)); } - DevRentDO getDismantleRentByState(DevRentSearchReqVO reqVO ); + DevRentDO getRentByState(DevRentSearchReqVO reqVO ); - @Select("select * from lihu.dev_rent where state=#{state} and pat_id=#{patId}") + @Select("select * from lihu.dev_rent where state=#{state} and pat_id=#{patId} and to_days(create_time)=to_days(now())") List<DevRentDO> selectByPatIdAndState(@Param("patId") String patId, @Param("state") Integer state); + + + @Select("<script>" + + "SELECT paid FROM lihu.dev_rent " + + "where id in (" + + " <foreach collection='rentIdList' separator=',' item='rentId'>" + + " #{rentId} " + + " </foreach> )" + + "</script>") + List<Integer> getPaidInfo(@Param("rentIdList")List<Long> rentIdList); + } -- Gitblit v1.9.3