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);
|
|
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);
|
}
|
