SysAmountAuditingMapper.java 2.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. package com.ydtech.modules.admin.dao;
  2. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  3. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  4. import com.ydtech.modules.admin.model.dto.MyCollectInAdvanceDto;
  5. import com.ydtech.modules.admin.model.dto.MyIncomeAndExpensesQueryDto;
  6. import com.ydtech.modules.admin.model.po.SysAmountAuditingEntity;
  7. import com.ydtech.modules.admin.model.vo.SysAmountAuditingVo;
  8. import org.apache.ibatis.annotations.Mapper;
  9. import org.apache.ibatis.annotations.Param;
  10. import java.math.BigDecimal;
  11. import java.util.HashMap;
  12. import java.util.List;
  13. @Mapper
  14. public interface SysAmountAuditingMapper extends BaseMapper<SysAmountAuditingEntity> {
  15. SysAmountAuditingEntity getByUserId( @Param("userId") String userId, @Param("amountStatus") String amountStatus);
  16. Page<SysAmountAuditingEntity> queryPageOrder(@Param("sysAmountAuditingVo") SysAmountAuditingVo sysAmountAuditingVo, Page<SysAmountAuditingEntity> page);
  17. List<SysAmountAuditingEntity> queryPageOrderNew(HashMap<String, Object> params);
  18. List<SysAmountAuditingEntity> getProgressIng(HashMap<String, Object> params);
  19. /**
  20. * @version
  21. * @author: hxl
  22. * @Date: 2024/6/19 16:19
  23. * @Description: 通过用户id查询提现中和已提现的数据
  24. */
  25. Page<MyCollectInAdvanceDto> queryAmountPage(@Param("myIncomeAndExpensesQueryDto") MyIncomeAndExpensesQueryDto myIncomeAndExpensesQueryDto, Page<MyCollectInAdvanceDto> page);
  26. /**
  27. * @version
  28. * @author: hxl
  29. * @Date: 2024/6/19 18:02
  30. * @Description:
  31. */
  32. BigDecimal findSumAmount(@Param("myIncomeAndExpensesQueryDto") MyIncomeAndExpensesQueryDto myIncomeAndExpensesQueryDto);
  33. /**
  34. * @version
  35. * @author: hxl
  36. * @Date: 2024/6/19 20:10
  37. * @Description: 通过用户id查询总金额
  38. */
  39. BigDecimal findSumAmountByUserId(@Param("userId") String userId);
  40. /**
  41. * @version
  42. * @author: hxl
  43. * @Date: 2024/6/27 16:32
  44. * @Description: 总金额
  45. */
  46. BigDecimal querySumAmount(@Param("vo") SysAmountAuditingVo sysAmountAuditingVo);
  47. }