package com.ruoyi.project.mapper;


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

import java.util.List;

import com.ruoyi.project.domain.FunddetailReqVo;
import com.ruoyi.project.domain.ServiceFunddetail;
import com.ruoyi.project.domain.SpStatBonus;
import com.ruoyi.project.domain.vo.SpFinancialExpensesFundOut;
import com.ruoyi.project.domain.vo.TaxMoneyByItemEO;
import com.ruoyi.project.domain.vo.TaxMoneySumEO;
import com.ruoyi.project.domain.vo.TaxMoneyVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * 费用申请明细Mapper接口
 *
 * @author ruoyi
 * @date 2022-01-25
 */
@Mapper
public interface ServiceFunddetailMapper extends BaseMapper<ServiceFunddetail> {
    /**
     * 查询费用申请明细列表
     *
     * @param serviceFunddetail 费用申请明细
     * @return 费用申请明细集合
     */
    public List<ServiceFunddetail> selectServiceFunddetailList(ServiceFunddetail serviceFunddetail);

    List<ServiceFunddetail> selectFundDetailListById(Long id);

    List<ServiceFunddetail> getAllDetailsByFDIDLW(Long id);

    List<ServiceFunddetail> getAllDetailsByFDIDSH(Long id);

    List<ServiceFunddetail> getAllDetailsByFDIDSS(Long id);

    List<ServiceFunddetail> getAllDetailsByFDIDYX(Long id);

    List<ServiceFunddetail> getAllDetailsByFDIDHZ(Long id);

    List<ServiceFunddetail> getAllDetailsByFDIDLWF(Long id);

    int countItem(@Param("fundid") Long fundid, @Param("itemid") Long itemid);

    public List<ServiceFunddetail> getDataBybeneficiaryNo(FunddetailReqVo funddetailReqVo);

    List<ServiceFunddetail> getTaxBeforeByBeneFiciaryNo(TaxMoneyVO taxMoneyV);

    boolean updateTaxTime(ServiceFunddetail serviceFunddetail);

    TaxMoneySumEO getTaxSum(TaxMoneyByItemEO taxMoneyByItemEO);

    List<ServiceFunddetail> totlaTax(List<Long> fundids);

    List<SpStatBonus> getListBySpStatBonus(@Param("PABEGTIME ") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") Integer PAUSERNO, @Param("PABONUSTYPE") String PABONUSTYPE);

}