| | |
|---|
| | | @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("select * from lihu.dev_rent where state=#{state} and dev_id=#{devId} and to_days(#{stateDate})=to_days(update_time) limit 1") |
|---|
| | | DevRentDO selectByDevIdAndState(@Param("devId") String devId, @Param("state") Integer state, @Param("stateDate") LocalDate stateDate); |
|---|
| | | |
|---|
| | | @Select("<script>" + |
|---|
| | | "SELECT paid FROM lihu.dev_rent " + |
|---|
| | | "where id in (" + |
|---|
