package com.panzhihua.service_community.dao;

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)表数据库访问层
 *
 * @author makejava
 * @since 2021-12-22 14:02:46
 */
@Mapper
public interface ComActSocialProjectDao extends BaseMapper<ComActSocialProject> {

    /**
     * 分页查询
     * @param page
     * @param commonPage
     * @return
     */
    IPage<SocialProjectVO> pageList(Page page, @Param("commonPage")CommonPage commonPage);

    /**
     * 小程序查询项目详情
     * @param id
     * @return
     */
    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);
}