20220902

xiaoyong931011

2022-09-02 b6a76de40ec625b440b28d8ec7977d355eec01c8

 src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java

@@ -1,5 +1,6 @@
package cc.mrbird.febs.mall.mapper;

import cc.mrbird.febs.common.enumerates.OrderPayMethodEnum;
import cc.mrbird.febs.mall.dto.MallOrderInfoDto;
import cc.mrbird.febs.mall.dto.OrderListDto;
import cc.mrbird.febs.mall.entity.MallOrderInfo;
@@ -13,6 +14,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 +23,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 +49,20 @@
    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);
}