From 030e1cca0b8103662a182a4dbe801c063b342630 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Thu, 10 Mar 2022 14:44:33 +0800 Subject: [PATCH] 20211201 fish --- src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java | 121 ++++++++++++++++++++++++++++++++++++++- 1 files changed, 116 insertions(+), 5 deletions(-) diff --git a/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java b/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java index e303696..7a4cb45 100644 --- a/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java +++ b/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java @@ -27,7 +27,7 @@ String selectTradeSetting(); - String selectMemberDataInfoCount(); +// String selectMemberDataInfoCount(); String selectTotalAmountUsdtBForBasicRealData(); @@ -45,7 +45,7 @@ String selectRewardratioForBasicRealData(); - String selectZCYHForBasicRealData(); +// String selectZCYHForBasicRealData(); String selectSFCCForBasicRealData(); @@ -65,7 +65,7 @@ String selectRewardratioForBasicRealDataBymid(Long memberId); - String selectTotalAmountUsdtBForBasicRealDataBymemberId(Long memberId); + String selectTotalAmountUsdtBForBasicRealDataBymemberId(@Param("memberId")Long memberId,@Param("symbol")String symbol); String selectTotalAmountUsdtSForBasicRealDataBymemberId(Long memberId); @@ -83,17 +83,24 @@ String selectprepriceForBasicRealDataBymemberId(Long memberId); - String selectBBZCForBasicRealDataBymemberId(Long memberId); + String selectBBZCForBasicRealDataBymemberId(@Param("memberId")Long memberId,@Param("symbol") String symbol); String selectHYZCForBasicRealDataBymemberId(Long memberId); String selectDLZCForBasicRealDataBymemberId(Long memberId); IPage<MemberEntity> findMemberAloneInPage(Page<MemberEntity> page, @Param("record") MemberEntity member); + + IPage<MemberEntity> findMemberAloneTestInPage(Page<MemberEntity> page, @Param("record") MemberEntity member); IPage<MemberDataInfoVo> selectMemberDataInfoDtoListInPageAlone(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity); + IPage<MemberDataInfoVo> findMemberDataInfoAllAloneTestListInPage(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity); + IPage<MemberDataInfoVo> selectMemberDataInfoDtoRealListInPageAlone(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity); + IPage<MemberDataInfoVo> findMemberDataInfoAloneTestDtoListInPage(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity); String selectTotalAmountUsdtBForBasicRealDataAlone(); + String selectTotalAmountUsdtBForBasicRealTestDataAlone(); + String selectTotalAmountUsdtBForBasicRealTestAllDataAlone(); String selectTotalAmountUsdtBForBasicData(); @@ -122,5 +129,109 @@ String selectHYZCForBasicData(); String selectDLZCForBasicData(); - + + String selectTotalAmountUsdtSForBasicRealDataAlone(); + String selectTotalAmountUsdtSForBasicRealTestDataAlone(); + String selectTotalAmountUsdtSForBasicRealTestAllDataAlone(); + + String selectTotalAmountUsdtCZForBasicRealDataAlone(); + String selectTotalAmountUsdtCZForBasicRealTestDataAlone(); + String selectTotalAmountUsdtCZForBasicRealTestAllDataAlone(); + + String selectTotalAmountUsdtTXForBasicRealDataAlone(); + String selectTotalAmountUsdtTXForBasicRealTestDataAlone(); + String selectTotalAmountUsdtTXForBasicRealTestAllDataAlone(); + + String selectReturnMoneyForBasicRealDataAlone(); + String selectReturnMoneyForBasicRealTestDataAlone(); + String selectReturnMoneyForBasicRealTestAllDataAlone(); + + String selectClosingpriceForBasicRealDataAlone(); + String selectClosingpriceForBasicRealTestDataAlone(); + String selectClosingpriceForBasicRealTestAllDataAlone(); + + String selectSellClosingpriceForBasicRealDataAlone(); + String selectSellClosingpriceForBasicRealTestDataAlone(); + String selectSellClosingpriceForBasicRealTestAllDataAlone(); + + String selectRewardratioForBasicRealDataAlone(); + String selectRewardratioForBasicRealTestDataAlone(); + String selectRewardratioForBasicRealTestAllDataAlone(); + + String selectSFCCForBasicRealDataAlone(); + String selectSFCCForBasicRealTestDataAlone(); + String selectSFCCForBasicRealTestAllDataAlone(); + + String selectBBZHForBasicRealDataAlone(); + String selectBBZHForBasicRealTestDataAlone(); + String selectBBZHForBasicRealTestAllDataAlone(); + + String selectHYZHForBasicRealDataAlone(); + String selectHYZHForBasicRealTestDataAlone(); + String selectHYZHForBasicRealTestAllDataAlone(); + + String selectprepriceForBasicRealDataAlone(); + String selectprepriceForBasicRealTestDataAlone(); + String selectprepriceForBasicRealTestAllDataAlone(); + + String selectBBZCForBasicRealDataAlone(); + String selectBBZCForBasicRealTestDataAlone(); + String selectBBZCForBasicRealTestAllDataAlone(); + + String selectHYZCForBasicRealDataAlone(); + String selectHYZCForBasicRealTestDataAlone(); + String selectHYZCForBasicRealTestAllDataAlone(); + + String selectDLZCForBasicRealDataAlone(); + String selectDLZCForBasicRealTestDataAlone(); + String selectDLZCForBasicRealTestAllDataAlone(); + + String selectTotalAmountUsdtBForBasicAllDataAlone(); + + String selectTotalAmountUsdtSForBasicAllDataAlone(); + + String selectTotalAmountUsdtCZForBasicAllDataAlone(); + + String selectTotalAmountUsdtTXForBasicAllDataAlone(); + + String selectReturnMoneyForBasicAllDataAlone(); + + String selectClosingpriceForBasicAllDataAlone(); + + String selectSellClosingpriceForBasicAllDataAlone(); + + String selectRewardratioForBasicAllDataAlone(); + + String selectSFCCForBasicAllDataAlone(); + + String selectBBZHForBasicAllDataAlone(); + + String selectHYZHForBasicAllDataAlone(); + + String selectprepriceForBasicAllDataAlone(); + + String selectBBZCForBasicAllDataAlone(); + + String selectHYZCForBasicAllDataAlone(); + + String selectDLZCForBasicAllDataAlone(); + + IPage<MemberAccountInfoVo> findMemberAccountInfoAloneListInPage(Page<MemberEntity> page, @Param("record")MemberEntity memberEntity); + + IPage<MemberEntity> findMemberListTestInPage(Page<MemberEntity> page, @Param("record")MemberEntity member); + + IPage<MemberAccountInfoVo> findmemberAccountInfoAloneTestListInPage(Page<MemberEntity> page, + @Param("record")MemberEntity memberEntity); + + String selectMemberInfoDetailByInviteId(@Param("inviteId")String inviteId); + + List<MemberEntity> selectMemberDataInfoListSearchs(@Param("inviteId")String inviteId); + + MemberEntity selectMemberByInviteId(@Param("inviteId")String string); + + IPage<MemberEntity> selectDataInfoListSearchs(Page<MemberEntity> page, @Param("record")MemberEntity member); + + MemberEntity selectMemberByAddress(@Param("address")String address); + + String selectMemberWalletContractByMemberId(@Param("memberId")long memberId); } -- Gitblit v1.9.1