From a73ef74a7b215299d2e6be291266d7cc1c3da85c Mon Sep 17 00:00:00 2001
From: eight <641137800@qq.com>
Date: 星期二, 26 十一月 2024 22:29:53 +0800
Subject: [PATCH] queue表 增加 episode_id 字段

---
 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/devrent/DevRentMapper.java |   18 +++++++++++-------
 1 files changed, 11 insertions(+), 7 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 cbe70ec..8fd5047 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
@@ -1,17 +1,13 @@
 package cn.lihu.jh.module.ecg.dal.mysql.devrent;
 
-import java.time.LocalDate;
 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.devrent.DevRentDO;
-import cn.lihu.jh.module.ecg.dal.dataobject.queue.QueueDO;
-import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.*;
 import cn.lihu.jh.module.ecg.controller.admin.devrent.vo.*;
-import org.apache.ibatis.annotations.Param;
-import org.apache.ibatis.annotations.Select;
 
 /**
  * 瑁呮満鎷嗘満 Mapper
@@ -51,14 +47,20 @@
             "  <if test=\"patId != null and patId != ''\"> " +
             "    and pat_id = #{patId} " +
             "  </if> " +
+            "  <if test=\"checkType != null and checkType != ''\"> " +
+            "    and check_type = #{checkType} " +
+            "  </if> " +
             "</where> " +
             "order by create_time desc " +
             "limit 1 " +
             "</script>")
+    @Results({
+            @Result(property = "patDetails", column = "pat_details", typeHandler=com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler.class)
+    })
     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())")
-    List<DevRentDO> selectByPatIdAndState(@Param("patId") String patId, @Param("state") Integer state);
+    @Select("select * from lihu.dev_rent where state=#{state} and pat_id=#{patId} and check_type=#{checkType} and to_days(create_time)=to_days(now())")
+    List<DevRentDO> selectByPatAndChecktypeAndState(@Param("patId") String patId, @Param("checkType") Integer checkType, @Param("state") Integer state);
 
     @Select("<script>" +
             "SELECT paid FROM lihu.dev_rent " +
@@ -69,4 +71,6 @@
             "</script>")
     List<Integer> getPaidInfo(@Param("rentIdList")List<Long> rentIdList);
 
+    @Update("update lihu.dev_rent set paid = #{paid} where id = #{rentId};")
+    Integer setPaid(@Param("rentId") Long rentId, @Param("paid") Integer paid);
 }

--
Gitblit v1.9.3