blame | history | patch | commit | commitdiff | ignore whitespace
xiaoyong931011
2023-08-18 15a6f5b0a38f0cd19c777c75c3fc4ff498fbc8dc 
 src/main/java/cc/mrbird/febs/mall/mapper/MallMoneyFlowMapper.java


@@ -1,18 +1,51 @@


package cc.mrbird.febs.mall.mapper;




import cc.mrbird.febs.mall.dto.MoneyChargeListDto;


import cc.mrbird.febs.mall.dto.MoneyFlowDto;


import cc.mrbird.febs.mall.dto.MoneyFlowListDto;


import cc.mrbird.febs.mall.entity.MallMember;


import cc.mrbird.febs.mall.entity.MallMoneyFlow;


import cc.mrbird.febs.mall.vo.AdminMallMoneyFlowVo;


import cc.mrbird.febs.mall.vo.AdminMoneyChargeListVo;


import cc.mrbird.febs.mall.vo.AdminMoneyFlowListVo;


import cc.mrbird.febs.mall.vo.MoneyFlowVo;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;


import com.baomidou.mybatisplus.core.metadata.IPage;


import com.baomidou.mybatisplus.extension.plugins.pagination.Page;


import org.apache.ibatis.annotations.Param;




import java.math.BigDecimal;


import java.util.Date;


import java.util.List;




public interface MallMoneyFlowMapper extends BaseMapper<MallMoneyFlow> {




    IPage<AdminMallMoneyFlowVo> selectMoneyFlowInPage(Page<AdminMallMoneyFlowVo> page, @Param("record")MallMember mallMember);




    IPage<MoneyFlowVo> selectApiMoneyFlowInPage(IPage<MoneyFlowVo> page, @Param("record") MoneyFlowDto moneyFlowDto);




    IPage<AdminMoneyFlowListVo> getMoneyFlowListInPage(Page<AdminMoneyFlowListVo> page,  @Param("record")MoneyFlowListDto moneyFlowListDto);




    IPage<AdminMoneyChargeListVo> getMoneyChargeListInPage(Page<AdminMoneyChargeListVo> page, @Param("record")MoneyChargeListDto moneyChargeListDto);




    List<MallMoneyFlow> selectMoneyFlowProfitByDate(@Param("date") Date date);




    int updateIsReturnByMemberId(@Param("isReturn") Integer isReturn, @Param("memberId") Long memberId);




    BigDecimal selectProfitByDateAndMemberId(Long memberId);




    BigDecimal selectCommissionIncome(@Param("type") Integer type, @Param("date") Date date, @Param("memberId") Long memebrid);




    BigDecimal selectThankfulCommission(@Param("date") Date date, @Param("memberId") Long memberId);




    MallMoneyFlow selectOneByOrderNoAndMemberId(@Param("rechargeNo")String rechargeNo, @Param("memberId")Long memberId);


    MallMoneyFlow selectOneByOrderNoAndMemberIdAndRtMemberId(@Param("rechargeNo")String rechargeNo,


                                                             @Param("memberId")Long memberId,


                                                             @Param("rtMemberId")Long rtMemberId);




    BigDecimal selectAmountByFlowtypeAndType(@Param("memberId")Long memberId,@Param("flowType")Integer flowType,


                                             @Param("type")Integer type, @Param("status")Integer status,


                                             @Param("dateDay") Date DateTime,@Param("dateMonth") Date dateMonth);




    List<MoneyFlowVo> selectMoneyFlowByOrderNo(@Param("orderNo")String orderNo, @Param("memberId")Long memberId);


}