From 86df207c37502cce1b2043e1c7c0486459eef1d6 Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期四, 13 三月 2025 19:58:45 +0800
Subject: [PATCH] 党员、诉求评论基础代码
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsGameDAO.java | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 57 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsGameDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsGameDAO.java
index 7877dbe..18485d3 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsGameDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsGameDAO.java
@@ -47,4 +47,61 @@
* @return
*/
IPage<McsGameVO> pageMcsGame(@Param("page") Page page, @Param("pageMcsGameDTO") PageMcsGameDTO pageMcsGameDTO);
+
+ /**
+ * 查询商家已发布数
+ * @param merchantId
+ * @return
+ */
+ Integer selectPublishCount(@Param("merchantId") Long merchantId);
+
+ /**
+ * 查询商家下已被领取的卷总数
+ * @param merchantId
+ * @param type
+ * @return
+ */
+ Integer selectAppliedCount(@Param("merchantId") Long merchantId, @Param("type") Integer type);
+
+ /**
+ * 查询商家下已被核销的卷总数
+ * @param merchantId
+ * @param type
+ * @return
+ */
+ Integer selectVerifiedCount(@Param("merchantId") Long merchantId, @Param("type") Integer type);
+
+ /**
+ * 获取热门游戏
+ * @return
+ */
+ McsGameVO selectPopularGame();
+
+ /**
+ * h5分页游戏查询
+ * @param page
+ * @param pageMcsGameDTO
+ * @return
+ */
+ IPage<McsGameVO> pageH5McsGame(@Param("page") Page page, @Param("pageMcsGameDTO") PageMcsGameDTO pageMcsGameDTO);
+
+ /**
+ * 游戏详情
+ * @param gameId
+ * @return
+ */
+ McsGameVO selectDetailById(@Param("gameId") Long gameId);
+
+ /**
+ * 通过商家id批量下架戳戳游戏
+ * @param needDealIds
+ * @return
+ */
+ Integer setOffByMerchantIds(@Param("needDealIds") List<Long> needDealIds);
+
+ /**
+ * 获取需要处理的到期数据
+ * @return
+ */
+ List<McsGame> selectNeedDealExpire();
}
--
Gitblit v1.7.1