From 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期一, 09 六月 2025 11:54:00 +0800
Subject: [PATCH] 6.9新增登录失败冻结逻辑

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/McsGameDAO.java |   68 ++++++++++++++++++++++++++++++++++
 1 files changed, 68 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 d5da4a8..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
@@ -3,6 +3,10 @@
 import java.util.List;
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.panzhihua.common.model.dtos.community.microCommercialStreet.PageMcsGameDTO;
+import com.panzhihua.common.model.vos.community.microCommercialStreet.McsGameVO;
 import org.apache.ibatis.annotations.Param;
 import org.apache.ibatis.annotations.Mapper;
 import com.panzhihua.service_community.entity.McsGame;
@@ -36,4 +40,68 @@
      */
     int insertOrUpdateBatch(@Param("entities") List<McsGame> entities);
 
+    /**
+     * 分页查询戳戳游戏
+     * @param page
+     * @param pageMcsGameDTO
+     * @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