package cc.mrbird.febs.dapp.mapper;

import cc.mrbird.febs.dapp.entity.IgtOnHookPlanOrderItem;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

public interface IgtOnHookPlanOrderItemDao extends BaseMapper<IgtOnHookPlanOrderItem> {

    IgtOnHookPlanOrderItem selectByOrderIdAndMemberIdAndState(@Param("orderId") Long orderId, @Param("memberId")Long memberId, @Param("state")int i);

    BigDecimal selectTotalProfitByByOrderIdAndMemberIdAndState(@Param("orderId") Long orderId, @Param("memberId")Long memberId
            , @Param("state")int i, @Param("isGoal")int isGoal);

    BigDecimal selectTotalAmountByByOrderIdAndMemberIdAndState(@Param("orderId") Long orderId, @Param("memberId")Long memberId
            , @Param("state")int i, @Param("isGoal")int isGoal);

    IgtOnHookPlanOrderItem selectByMemberIdAndBelongNum( @Param("memberId")Long memberId,  @Param("recordNum")String recordNum);

    BigDecimal selectTotalProfitByMemberIdAndStateAndIsgoal(@Param("memberId")Long memberId
            , @Param("state")int i, @Param("isGoal")int isGoal);

    List<IgtOnHookPlanOrderItem> selectByIgtIdAndMemberId(@Param("orderId") Long orderId, @Param("memberId")Long memberId);

    BigDecimal selectTotalAmountByCreateTimeAndOrderId(@Param("startTime")Date startTime, @Param("endTime")Date endTime, @Param("orderId")Long id);

    Long selectByIsgoalAndOrderId(@Param("isGoal")int i, @Param("orderId")Long orderId);
}