manailin
2022-04-08 8d5fb4ee9d27fd6a61b210eaee74af265f76aa7c
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActSocialProjectDao.java
@@ -4,10 +4,16 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenActivityLine;
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 +39,45 @@
     */
    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);
}