From 59ced2bc629aa8bc66b34bdae543a2408b3e3614 Mon Sep 17 00:00:00 2001 From: KKSU <15274802129@163.com> Date: Tue, 27 Feb 2024 10:21:15 +0800 Subject: [PATCH] 抽奖 --- src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java | 24 ++++++++++++++++++++++++ 1 files changed, 24 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 cb64ee0..fd29fea 100644 --- a/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java +++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java @@ -1,7 +1,10 @@ package cc.mrbird.febs.mall.mapper; +import cc.mrbird.febs.common.enumerates.OrderPayMethodEnum; +import cc.mrbird.febs.mall.dto.ChoujiangInfoDto; import cc.mrbird.febs.mall.dto.MallOrderInfoDto; import cc.mrbird.febs.mall.dto.OrderListDto; +import cc.mrbird.febs.mall.entity.CjInfo; import cc.mrbird.febs.mall.entity.MallOrderInfo; import cc.mrbird.febs.mall.entity.MallOrderItem; import cc.mrbird.febs.mall.vo.AdminMallOrderInfoVo; @@ -13,6 +16,7 @@ import org.apache.ibatis.annotations.Param; import java.math.BigDecimal; +import java.util.Date; import java.util.List; import java.util.Map; @@ -21,6 +25,8 @@ * @date 2021-09-18 **/ public interface MallOrderInfoMapper extends BaseMapper<MallOrderInfo> { + + IPage<MallOrderInfo> selectInPage(@Param("record") MallOrderInfo mallOrderInfo, IPage<MallOrderInfo> page); MallOrderInfo selectOrderByMemberIdAndId(@Param("memberId") Long memberId, @Param("id") Long id); @@ -45,4 +51,22 @@ Integer selectCntDirect(@Param("inviteId") String inviteId); BigDecimal selectTotalAmount(@Param("memberId") Long memberId); + + BigDecimal selectTotalAmountForDate(@Param("date") Date date, @Param("member") Long memberId); + + BigDecimal selectTotalAmountUnCostForDate(@Param("date") Date date, @Param("member") Long memberId, @Param("dateType") String dateType, @Param("isNormal") Integer isNormal); + + MallOrderInfo selectByOrderNo(@Param("orderNo") String orderNo); + + int updateOrderConfirmStatus(@Param("date") Date date); + + 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); + + IPage<CjInfo> getChouJiangListInPage(Page<CjInfo> page, @Param("record")ChoujiangInfoDto choujiangInfoDto); } -- Gitblit v1.9.1