20221130

xiaoyong931011

2022-12-05 22819e7b84e661b65b43b8a3c8467080b1b23fa4

 src/main/java/cc/mrbird/febs/dapp/mapper/DappFundFlowDao.java

@@ -6,8 +6,10 @@
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;
import java.util.Map;

public interface DappFundFlowDao extends BaseMapper<DappFundFlowEntity> {

@@ -15,7 +17,21 @@

    List<DappFundFlowEntity> selectListForMemberAndDay(@Param("memberId") Long memberId, @Param("type") int type);

    DappFundFlowEntity selectMineFundFlowByMemberIdAndTime(@Param("time") Long memberId, @Param("time") Date time);

    DappFundFlowEntity selectByFromHash(@Param("txHash") String txHash, @Param("status") Integer status);

    List<DappFundFlowEntity> selectFundFlowListByAddress(@Param("address") String address, @Param("status") Integer status);

    Map<String, BigDecimal> selectAmountTotalByType(@Param("memberId") Long memberId);

    BigDecimal selectProfitAmountByMemberId(@Param("memberId") Long memberId);

    DappFundFlowEntity selectNewestFundFlow(@Param("memberId") Long memberId, @Param("type") Integer type);

    BigDecimal selectSumAmountByMemberIdAndTypeAndStatus(@Param("memberId") Long memberId,@Param("type")int type, @Param("status")int status);

    DappFundFlowEntity selectInfoById(@Param("id")Long id);

    int updateStatusById(@Param("status")int status, @Param("id")Long id);

    DappFundFlowEntity selectByStateAndVersionAndFromHashLimitOne(@Param("status")int withdrawStatusAgree, @Param("version")int withdrawStatusAgree1);
}