src/main/java/cc/mrbird/febs/dapp/mapper/DappFundFlowDao.java
@@ -31,4 +31,6 @@ BigDecimal selectAmountTotalByTypeAndMemberIdAndDate(@Param("memberId") Long memberId,@Param("type") int type, @Param("date") Date date); IPage<MoneyFlowVo> findMoneyFlowVos(Page<MoneyFlowVo> page, @Param("record")TeamListDto teamListDto); IPage<DappFundFlowEntity> selectInPages(Page<DappFundFlowEntity> page, @Param("record")DappFundFlowEntity dappFundFlowEntity); } src/main/java/cc/mrbird/febs/dapp/service/impl/DappWalletServiceImpl.java
@@ -166,7 +166,7 @@ dappFundFlowEntity.setStatus(recordInPageDto.getType()); } dappFundFlowEntity.setMemberId(member.getId()); IPage<DappFundFlowEntity> records = dappFundFlowDao.selectInPage(page, dappFundFlowEntity); IPage<DappFundFlowEntity> records = dappFundFlowDao.selectInPages(page, dappFundFlowEntity); return records.getRecords(); } src/main/resources/mapper/dapp/DappFundFlowDao.xml
@@ -114,4 +114,40 @@ and a.member_id=#{record.memberId} order by a.create_time desc </select> <select id="selectInPages" resultType="cc.mrbird.febs.dapp.entity.DappFundFlowEntity"> select a.amount, a.type, a.status, b.address address from dapp_fund_flow a left join dapp_member b on a.member_id = b.id <where> <if test="record.memberId != null"> and a.member_id = #{record.memberId} </if> <if test="record.type != null"> and a.type = #{record.type} </if> <if test="record.type != null"> and a.type = #{record.type} </if> <if test="record.status != null"> and a.status = #{record.status} </if> <if test="record.address != null and record.address != ''"> and b.address = #{record.address} </if> <if test="record.fromHash != null and record.fromHash != ''"> and a.from_hash = #{record.fromHash} </if> <if test="record.toHash != null and record.toHash != ''"> and a.to_hash = #{record.toHash} </if> </where> order by a.create_time desc </select> </mapper>