From b70ac86f95acd31985d6c335b5ecb3b9578876d5 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Sun, 20 Nov 2022 00:31:56 +0800
Subject: [PATCH] 20221117
---
src/main/resources/mapper/dapp/DappOnHookAwardDao.xml | 10 ++++++++++
src/main/java/cc/mrbird/febs/dapp/service/impl/ApiIgtOnHookPlanServiceImpl.java | 3 ++-
src/main/java/cc/mrbird/febs/dapp/mapper/DappOnHookAwardDao.java | 2 ++
3 files changed, 14 insertions(+), 1 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/dapp/mapper/DappOnHookAwardDao.java b/src/main/java/cc/mrbird/febs/dapp/mapper/DappOnHookAwardDao.java
index bed80ee..0390f8b 100644
--- a/src/main/java/cc/mrbird/febs/dapp/mapper/DappOnHookAwardDao.java
+++ b/src/main/java/cc/mrbird/febs/dapp/mapper/DappOnHookAwardDao.java
@@ -13,4 +13,6 @@
DappOnHookAward selectByByAwardTime(@Param("awardTime")String yyyyMMddHHMM);
List<DappOnHookAward> selectInfoByByAwardTime(@Param("awardTime")String yyyyMMddHHMM);
+
+ List<DappOnHookAward> selectByIdLimitTT(@Param("id")Long id);
}
diff --git a/src/main/java/cc/mrbird/febs/dapp/service/impl/ApiIgtOnHookPlanServiceImpl.java b/src/main/java/cc/mrbird/febs/dapp/service/impl/ApiIgtOnHookPlanServiceImpl.java
index 3b9c368..d66c2e3 100644
--- a/src/main/java/cc/mrbird/febs/dapp/service/impl/ApiIgtOnHookPlanServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/dapp/service/impl/ApiIgtOnHookPlanServiceImpl.java
@@ -282,7 +282,8 @@
Date date = dappOnHookAwardNow.getAwardTime();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
String yyyyMMddHHMM = sdf.format(date);
- List<DappOnHookAward> dappOnHookAwards = dappOnHookAwardDao.selectInfoByByAwardTime(yyyyMMddHHMM);
+// List<DappOnHookAward> dappOnHookAwards = dappOnHookAwardDao.selectInfoByByAwardTime(yyyyMMddHHMM);
+ List<DappOnHookAward> dappOnHookAwards = dappOnHookAwardDao.selectByIdLimitTT(Long.parseLong(onHookAwardRedisId));
if(CollUtil.isNotEmpty(dappOnHookAwards)){
for(DappOnHookAward dappOnHookAward : dappOnHookAwards){
ApiAwardInfoVo apiAwardInfoVo = new ApiAwardInfoVo();
diff --git a/src/main/resources/mapper/dapp/DappOnHookAwardDao.xml b/src/main/resources/mapper/dapp/DappOnHookAwardDao.xml
index 3c3f798..ab68d27 100644
--- a/src/main/resources/mapper/dapp/DappOnHookAwardDao.xml
+++ b/src/main/resources/mapper/dapp/DappOnHookAwardDao.xml
@@ -31,5 +31,15 @@
limit 20
</select>
+ <select id="selectByIdLimitTT" resultType="cc.mrbird.febs.dapp.entity.DappOnHookAward">
+ select
+ a.*
+ from dapp_on_hook_award a
+ where
+ a.id <= #{id}
+ order by a.id desc
+ limit 20
+ </select>
+
</mapper>
\ No newline at end of file
--
Gitblit v1.9.1