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.civil.ComActSocialExportVO;
import com.panzhihua.common.model.dtos.civil.ComActSocialWorkerExcelVO;
import com.panzhihua.common.model.dtos.civil.PageComActSocialWorkerDTO;
import com.panzhihua.common.model.vos.civil.ComActSocialWorkerVO;
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenHmkProjectTypeInfo;
import org.apache.ibatis.annotations.Mapper;
import com.panzhihua.service_community.entity.ComActSocialWorker;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 社工(ComActSocialWorker)表数据库访问层
 *
 * @author makejava
 * @since 2021-10-25 10:56:47
 */
@Mapper
public interface ComActSocialWorkerDao extends BaseMapper<ComActSocialWorker> {
    /**
     * 分页查询
     * @param pageComActSocialWorkerDTO
     * @return
     */
    IPage<ComActSocialWorkerVO> findByPage(Page page, @Param("pageComActSocialWorkerDTO") PageComActSocialWorkerDTO pageComActSocialWorkerDTO);

    /**
     * 导出
     * @param comActSocialWorkerDO
     * @return
     */
    List<ComActSocialWorkerExcelVO> queryAll(ComActSocialExportVO comActSocialWorkerDO);

    /**
     * 查询社工人数
     * @param type
     * @return
     */
    Integer selectType(@Param("type") Integer type,@Param("communityId")Long communityId);

    /**
     * 社工技能分布查询
     * @return
     */
    List<BigScreenHmkProjectTypeInfo> selectSkillType(Long communityId);

    /**
     * 活动社工查询
     * @param page
     * @param id
     * @return
     */
    IPage<ComActSocialWorkerVO> selectActivity(Page page,@Param("id") Long id);

    /**
     * 查询社工详情
     * @param id
     * @return
     */
    ComActSocialWorkerVO selectOneById(Long id);

    /**
     * 根据技能id查询社工列表
     * @param id
     * @return
     */
    List<ComActSocialWorker> selectIncludeSkillWorkerList(@Param("id") Long id);
}