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