package com.ydtech.modules.admin.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ydtech.modules.admin.model.dto.*;
import com.ydtech.modules.admin.model.po.SysUserAccountHistory;
import com.ydtech.modules.admin.model.report.financeData.RevenueAndExpenditureDataDto;
import com.ydtech.modules.admin.model.report.financeData.RevenueAndExpenditureQueryDto;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.HashMap;
import java.util.List;

/**
* @author Administrator
* @description 针对表【sys_user_account_history(用户账户表)】的数据库操作Mapper
* @createDate 2024-03-05 11:47:38
* @Entity generator.domain.SysUserAccountHistory
*/
public interface SysUserAccountHistoryMapper extends BaseMapper<SysUserAccountHistory> {

    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/5 18:38
     *  @Description: 查询年分
     */
    List<RevenueReportDto> revenueReportYear(HashMap<String,Object> map);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/5 18:39
     *  @Description: 月分
     */
    List<RevenueReportDto> revenueReportMonth(HashMap<String,Object> map);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/5 18:39
     *  @Description: 日
     */
    List<RevenueReportDto> revenueReportDay(HashMap<String,Object> map);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/19 15:55
     *  @Description: 通过用户id查询费用类型记录表
     */
    Page<MyCollectInAdvanceDto> findMyIncomeAndExpensesAmountByUserId(@Param("page") Page<MyCollectInAdvanceDto> page, @Param("myIncomeAndExpensesQueryDto") MyIncomeAndExpensesQueryDto myIncomeAndExpensesQueryDto);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/19 15:56
     *  @Description: 通过用户id查询费用类型记录总条数
     */
    Long findMyIncomeAndExpensesAmountByUserIdCount(@Param("myIncomeAndExpensesQueryDto") MyIncomeAndExpensesQueryDto myIncomeAndExpensesQueryDto);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/19 17:12
     *  @Description: 查询用户总金额
     */
    BigDecimal findSumAmount(@Param("myIncomeAndExpensesQueryDto") MyIncomeAndExpensesQueryDto myIncomeAndExpensesQueryDto);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/19 20:13
     *  @Description: 查询用户总金额
     */
    BigDecimal findSumAmountByUserId(@Param("userId") String userId,@Param("types")  String types);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/30 18:38
     *  @Description: 查询分页
     */
    Page<ExportExpenditureTypeDetalsSZDto> findMyIncomeAndExpensesAmountNewByUserId(@Param("page") Page<ExportExpenditureTypeDetalsSZDto> page, @Param("vo") MyCollectInAdvanceQueryNewDto myCollectInAdvanceQueryNewDto);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/30 18:38
     *  @Description: 导出
     */
    List<ExportExpenditureTypeDetalsSZDto> exportMyIncomeAndExpensesAmountNewByUserId(@Param("vo") MyCollectInAdvanceQueryNewDto myCollectInAdvanceQueryNewDto);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/7/4 14:41
     *  @Description: 查询代理人、渠道的收支明细
     */
    Page<RevenueAndExpenditureDataDto> queryRevenueAndExpenditureDataPage(@Param("vo") RevenueAndExpenditureQueryDto revenueAndExpenditureQueryDto, @Param("page") Page<RevenueAndExpenditureDataDto> page);
}