From 0b6cb0ac976ca1ddcb1e6f17dfa04bb526585a1e Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Sun, 29 Jan 2023 09:54:38 +0800 Subject: [PATCH] 1 --- src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java | 12 ++++++++++++ 1 files changed, 12 insertions(+), 0 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java index f511408..2fcd3e9 100644 --- a/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java +++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java @@ -61,4 +61,16 @@ List<MallOrderInfo> selectOrderInfoWithNormalGoods(@Param("date") Date date); BigDecimal selectSumAmountByPayMethodAndStatue(@Param("payMethod")String name, @Param("statue")int value); + + BigDecimal selectTotalAmountByPayDoneAndDataString(@Param("payResult")int i, @Param("date") Date date); + + BigDecimal selectSumAmountByPayMethodAndSomeStatue(@Param("payMethod")String name, @Param("statues") List<Long> values); + + Integer selectCountByCreateTimeAndMemberId(@Param("createdTime")String yyyyMMdd,@Param("memberId")Long memberId); + + BigDecimal selectTodayAmountByCreateTimeAndMemberId(@Param("createdTime")String yyyyMMdd,@Param("memberId")Long memberId); + + Integer selectOrderInfoByStatusAndMemberId(@Param("status")int value, @Param("memberId")Long id); + + Integer selectCountByCreateTime(@Param("createdTime")String yyyyMMdd); } -- Gitblit v1.9.1