package com.ruoyi.project.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.sql.Time;
import java.util.Collection;
import java.util.List;

import com.ruoyi.project.domain.ServiceDonateorgan;
import com.ruoyi.project.domain.ServiceDonationwitness;
import com.ruoyi.project.domain.vo.DonationWitnessVO;
import com.ruoyi.project.domain.vo.TimeVO;
import org.apache.ibatis.annotations.Mapper;

/**
 * 捐献见证Mapper接口
 * 
 * @author ruoyi
 * @date 2021-11-17
 */
@Mapper
public interface ServiceDonationwitnessMapper extends BaseMapper<ServiceDonationwitness>
{
    /**
     * 查询捐献见证列表
     *
     * @param serviceDonationwitness 捐献见证
     * @return 捐献见证集合
     */
    public List<ServiceDonationwitness> selectServiceDonationwitnessList(ServiceDonationwitness serviceDonationwitness);

    List<ServiceDonationwitness> getWitnessList();

    List<DonationWitnessVO> selectVOList(DonationWitnessVO donationWitnessVO);

    int getDBDDonaterNumberThisYear(TimeVO timeVO);

    int getDCDDonaterNumberThisYear(TimeVO timeVO);

    int getDBCDDonaterNumberThisYear(TimeVO timeVO);

    String getDonationCategoryByInfoId(Long infoId);

    Integer countNumber(TimeVO timeVO);

    ServiceDonationwitness selectByInfoId(Long infoid);

    List<ServiceDonationwitness> getAllDonatePeople();


    int countThisYearByTime(TimeVO timeVO);

    List<ServiceDonationwitness> getAllDonatePeopleByTime(TimeVO timeVO);

    List<ServiceDonationwitness> selectByTime(TimeVO timeVO);
}