package com.panzhihua.service_community.dao;

import java.util.List;

import com.panzhihua.common.model.vos.community.StatisticsCommVO;
import com.panzhihua.common.model.vos.community.bigscreen.BigScreenVolunteerStatisticsInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

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.vos.community.ComMngVolunteerMngVO;
import com.panzhihua.common.model.vos.community.TodoEventsVO;
import com.panzhihua.service_community.model.dos.ComMngVolunteerMngDO;

/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 志愿者
 * @author: huang.hongfa weixin hhf9596 qq 959656820
 * @create: 2020-12-15 09:50
 **/
@Mapper
public interface ComMngVolunteerMngDAO extends BaseMapper<ComMngVolunteerMngDO> {

    /**
     * 分页查询志愿者列表
     * @param page  分页参数
     * @param comMngVolunteerMngVO  请求参数
     * @return  志愿者列表
     */
    IPage<ComMngVolunteerMngVO> pageVolunteer(Page page,
        @Param("comMngVolunteerMngVO") ComMngVolunteerMngVO comMngVolunteerMngVO);

    IPage<ComMngVolunteerMngVO> pageVolunteerExamine(Page page,
        @Param("comMngVolunteerMngVO") ComMngVolunteerMngVO comMngVolunteerMngVO);

    @Select("SELECT\n" + "'4' type\n" + "FROM\n" + "com_mng_volunteer_mng v \n" + "WHERE\n" + "v.state = 1 \n"
        + "AND v.`community_id` = #{communityId} \n")
    List<TodoEventsVO> selectNeedToDo(Long communityId);

    @Select("select user_id from sys_user where type=1 and phone=#{phone}")
    Long selectUserIdByPhone(String phone);

    @Select("select id_card from sys_user where type=1 and phone=#{idCard}")
    Long selectUserIdByIdCard(String idCard);

    /**
     * 志愿者-组织直方图数据
     * @param communityId
     * @return
     */
    List<StatisticsCommVO> retrieveVolunteerOrgHistogram(@Param("communityId") Long communityId);

    /**
     * 获取杨家坪定制页面-志愿服务基础数据
     * @param communityId
     * @return
     */
    BigScreenVolunteerStatisticsInfo getVolunteerBaseData(@Param("communityId") Long communityId);

    /**
     * 获取志愿者数据
     * @param communityId
     * @return
     */
    List<ComMngVolunteerMngVO> retrieveVolunteerServiceTypeCircleData(@Param("communityId") Long communityId);

    /**
     * 志愿者年龄段占比圆形图数据
     * @param communityId
     * @return
     */
    List<StatisticsCommVO> retrieveVolunteerAgeCircleData(@Param("communityId") Long communityId);

    /**
     * 志愿者技能占比圆形图
     * @param communityId
     * @return
     */
    List<ComMngVolunteerMngVO> retrieveVolunteerSkillCircleData(@Param("communityId") Long communityId);

    /**
     * 根据社区id查询志愿者
     * @param communityId
     * @return
     */
    List<ComMngVolunteerMngVO> selectVolunteerByCommunityId(@Param("communityId") Long communityId);

    /**
     * 志愿者审核详情
     * @param id
     * @return
     */
    ComMngVolunteerMngVO detailVolunteerExamine(@Param("id") Long id);
}