UserTicketOrderMapper.java 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586
  1. package com.qs.mp.user.mapper;
  2. import com.qs.mp.admin.domain.vo.IndexVO;
  3. import com.qs.mp.admin.domain.vo.TicketCntVO;
  4. import com.qs.mp.user.domain.UserDeliverOrder;
  5. import com.qs.mp.user.domain.UserTicketOrder;
  6. import java.util.List;
  7. import org.apache.ibatis.annotations.Param;
  8. import com.baomidou.mybatisplus.core.conditions.Wrapper;
  9. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  10. import com.baomidou.mybatisplus.core.toolkit.Constants;
  11. /**
  12. * @auther quanshu
  13. * @create 2022-03-07 20:45:43
  14. * @describe 用户盲票订单mapper类
  15. */
  16. public interface UserTicketOrderMapper extends BaseMapper<UserTicketOrder> {
  17. /**
  18. * 统计交易金额
  19. * @param wrapper
  20. * @return
  21. */
  22. List<IndexVO> selectIndexPayAmtList(@Param(Constants.WRAPPER) Wrapper<UserTicketOrder> wrapper);
  23. /**
  24. * 统计交易用户数
  25. * @param wrapper
  26. * @return
  27. */
  28. List<IndexVO> selectIndexPayUserCntList(@Param(Constants.WRAPPER) Wrapper<UserTicketOrder> wrapper);
  29. /**
  30. * 统计实时交易数据
  31. * @param wrapper
  32. * @return
  33. */
  34. List<IndexVO> selectIndexDailyInfoList(@Param(Constants.WRAPPER) Wrapper<UserTicketOrder> wrapper);
  35. /**
  36. * 统计票组销售TOP10
  37. * @param wrapper
  38. * @return
  39. */
  40. List<IndexVO> selectIndexTicketBoxTop(@Param(Constants.WRAPPER) Wrapper<UserTicketOrder> wrapper);
  41. /**
  42. * 统计经销商交易额TOP10
  43. * @param wrapper
  44. * @return
  45. */
  46. List<IndexVO> selectIndexTicketSiteTop(@Param(Constants.WRAPPER) Wrapper<UserTicketOrder> wrapper);
  47. /**
  48. * 查询子渠道全部的盲票销售张数
  49. * @param channelNo
  50. * @return
  51. */
  52. int getChannelTotalTicketNumCnt(@Param("channelNo") String channelNo);
  53. /**
  54. * 查询经销商的盲票销售张数
  55. * @param channelNo
  56. * @return
  57. */
  58. int getSaleSiteTotalTicketNumCnt(@Param("channelId") Long channelId);
  59. /**
  60. * 统计经销商盲票销量,线下和线上
  61. * @param channelId
  62. * @return
  63. */
  64. TicketCntVO getTicketSaleCnt(@Param("channelId") Long channelId);
  65. /**
  66. * 查询统计经销商盲票销量数据,线下和线上
  67. * @param queryWrapper
  68. * @return
  69. */
  70. List<TicketCntVO> listTicketSaleCnt(@Param(Constants.WRAPPER) Wrapper<UserTicketOrder> queryWrapper);
  71. }