package com.ruoyi.project.mapper;


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

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

import com.ruoyi.project.domain.ServiceDonateorgan;
import com.ruoyi.project.domain.vo.DonateOrganVO;
import com.ruoyi.project.domain.vo.TimeVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * 捐献器官管理Mapper接口
 *
 * @author ruoyi
 * @date 2021-11-10
 */
@Mapper
public interface ServiceDonateorganMapper extends BaseMapper<ServiceDonateorgan> {
    /**
     * 查询捐献器官管理列表
     *
     * @param serviceDonateorgan 捐献器官管理
     * @return 捐献器官管理集合
     */
    public List<ServiceDonateorgan> selectServiceDonateorganList(ServiceDonateorgan serviceDonateorgan);

    List<ServiceDonateorgan> getAllDonateOrgans();

    Integer getAllProcessOrgans(TimeVO timeVO);

    Integer getAllFinishedOrgans(TimeVO timeVO);


    int getAllFinishedOrgansThisYear(TimeVO timeVO);

    int getOrganNumberThisYear(TimeVO timeVO);

    int getbiopsyBeforeNumberThisYear(TimeVO timeVO);

    int getbiopsyAfterNumberThisYear(TimeVO timeVO);

    int getmarginalOrgansNumberThisYear(TimeVO timeVO);

    int getPathogenPositiveNumberThisYear(TimeVO timeVO);

    int getPNFNumberThisYear(TimeVO timeVO);

    int getDGFNumberThisYear(TimeVO timeVO);

    List<ServiceDonateorgan> selectPNFOrganThisYear(TimeVO timeVO);

    List<ServiceDonateorgan> selectDGFOrganThisYear(TimeVO timeVO);

    List<DonateOrganVO> selectVOList(DonateOrganVO donateOrganVO);

    int getOrganNo(@Param("organno") String organno, @Param("starttime") Date starttime, @Param("endtime") Date endtime, @Param("city") String city, @Param("reporterno") String reporterno);

    Integer countNumber(TimeVO timeVO);

    Integer countPeople(TimeVO timeVO);

    List<ServiceDonateorgan> getAllDonateOrgansByTime(TimeVO timeVO);

    List<ServiceDonateorgan> selectServiceDonateorganListNotAbandon(ServiceDonateorgan serviceDonateorgan);

    int getOrgansCount(@Param("starttime") Date starttime, @Param("endtime") Date endtime, @Param("organizationid") String organizationid);

    int getDistinctOrgansCount(@Param("organno") String organno, @Param("starttime") Date starttime, @Param("endtime") Date endtime, @Param("city") String city, @Param("reporterno") String reporterno);

    String getOrganNameByNo(String organno);

    List<ServiceDonateorgan> selectAll(TimeVO timeVO);

    List<ServiceDonateorgan> countList(ServiceDonateorgan serviceDonateorgan);
}