6.9新增登录失败冻结逻辑

liujie

2025-06-09 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActSocialProjectDao.java

@@ -3,11 +3,22 @@
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.PageBaseDTO;
import com.panzhihua.common.model.dtos.community.social.PageProjectDTO;
import com.panzhihua.common.model.dtos.community.social.PageProjectSignListDTO;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.community.ComActSocialOrgVO;
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenActivityLine;
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenFiveAssociationsStatisticsInfo;
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenHmkBaseInfo;
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenHmkProjectInfo;
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenHmkProjectTypeInfo;
import com.panzhihua.common.model.vos.community.social.SocialProjectVO;
import org.apache.ibatis.annotations.Mapper;
import com.panzhihua.service_community.entity.ComActSocialProject;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 三社联动项目表(ComActSocialProject)表数据库访问层
@@ -33,4 +44,77 @@
     */
    SocialProjectVO getByApplet(Long id);

    /**
     * 河门口大屏项目基础数据
     * @return
     */
    BigScreenHmkProjectInfo selectBaseInfo(Long communityId);

    /**
     * 河门口大屏项目分类
     * @param orgName
     * @param communityId
     * @return
     */
    List<BigScreenHmkProjectTypeInfo> selectType(@Param("orgName")String orgName,@Param("communityId")Long communityId);

    /**
     * 根据活动类型查询数量
     * @param type
     * @return
     */
    Integer selectActivity(@Param("type") Integer type,@Param("communityId")Long communityId);

    /**
     * 首页基础数据
     * @return
     */
    BigScreenHmkBaseInfo selectIndexBaseInfo();

    /**
     * 河门口大屏活动折线
     * @param date
     * @param year
     * @return
     */
    BigScreenActivityLine selectActivityCountMonth(@Param("date") String date,@Param("year") String year);

    /**
     * id查询
     * @param id
     * @return
     */
    SocialProjectVO selectByLevel(Long id);

    /**
     * 分页查询项目报名列表
     * @param page
     * @param pageProjectSignListDTO
     * @return
     */
    IPage<ComActSocialOrgVO> pageProjectSignList(@Param("page") Page page, @Param("pageProjectSignListDTO") PageProjectSignListDTO pageProjectSignListDTO);

    /**
     * 分页查询用户报名的项目
     * @param page
     * @param pageProjectDTO
     * @return
     */
    IPage<SocialProjectVO> pageProjectWhichIsSignedByUser(@Param("page") Page page, @Param("pageProjectDTO") PageProjectDTO pageProjectDTO);

    /**
     * 五社联动项目展示列表
     * @param pageBaseDTO
     * @param streetId
     * @return
     */
    IPage<SocialProjectVO> pageSocialProjectList(@Param("page") Page page, @Param("pageBaseDTO") PageBaseDTO pageBaseDTO, @Param("streetId") Long streetId);

    /**
     * 五社联动基础数据
     * @param communityId
     * @param streetId
     * @return
     */
    BigScreenFiveAssociationsStatisticsInfo getFiveAssociationsBaseData(@Param("communityId") Long communityId, @Param("streetId") Long streetId);
}