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.community.sanshuo.ComSanshuoExpertDTO;
|
import com.panzhihua.common.model.dtos.community.sanshuo.IndexDateDTO;
|
import com.panzhihua.common.model.vos.sanshuo.ComSanshuoExpertVO;
|
import com.panzhihua.common.model.vos.sanshuo.ExpertShowVO;
|
import com.panzhihua.service_community.entity.ComSanshuoExpert;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
/**
|
* @author Frozen
|
* @description 针对表【com_sanshuo_expert(三说会堂专家表)】的数据库操作Mapper
|
* @createDate 2022-09-06 14:17:37
|
* @Entity generator.entity.ComSanshuoExpert
|
*/
|
@Mapper
|
public interface ComSanshuoExpertDao extends BaseMapper<ComSanshuoExpert> {
|
|
/**
|
* 后台获取专家列表
|
* @param page
|
* @param keyWord
|
* @param range 数据范围：1街道下属/2社区下属/3业务中心下属/null三说会堂下属
|
* @param id 社区或街道或业务中心id
|
* @return 处理结果
|
* */
|
IPage<ComSanshuoExpertVO> expertPage(Page page, @Param("keyWord")String keyWord, @Param("range") Integer range, @Param("id")Long id,@Param("level")Integer level,@Param("appId")String appId);
|
|
/**
|
* 专家风采列表
|
* */
|
List<ExpertShowVO> expertShow(String appId);
|
|
/**
|
* 行业分中心分组专家
|
* */
|
List<ExpertShowVO> selectExpertIndustry();
|
|
|
/**
|
* 街道分组专家
|
* */
|
List<ExpertShowVO> selectExpertStreet();
|
|
/**
|
* 社区分组专家
|
* */
|
List<ExpertShowVO> selectExpertCommunity(String appId);
|
|
|
/**
|
* 小程序获取专家列表
|
* */
|
List<ComSanshuoExpert> selectExpertList();
|
|
/**
|
* 是否重名，重复手机号，重复账号
|
* */
|
List<ComSanshuoExpert> selectExpertByNameOrPhoneOrAccount(@Param("dto") ComSanshuoExpertDTO comSanshuoExpertDTO);
|
|
/**
|
* 获取当前级别的专家数量
|
* */
|
Integer selectExpertCount(@Param("dto") IndexDateDTO indexDataDTO);
|
|
Integer selectExpertVoList();
|
|
IPage<ComSanshuoExpertVO> expertList(Page page, @Param("level") Integer level, @Param("id") Long id,@Param("appId")String appId,@Param("keyWord")String keyWord);
|
}
|
