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);
|
}
|
