|  |  | 
 |  |  | package com.xcong.excoin.modules.member.dao;
 | 
 |  |  | 
 | 
 |  |  | import java.util.List;
 | 
 |  |  | 
 | 
 |  |  | import org.apache.ibatis.annotations.Param;
 | 
 |  |  | 
 | 
 |  |  | import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 | 
 |  |  | 
 |  |  |     MemberCoinAddressEntity selectBlockAddressWithTag(@Param("memberId")Long memberId, @Param("symbol")String symbol, @Param("tag")String tag);
 | 
 |  |  |     MemberCoinAddressEntity selectBlockAddress(@Param("memberId")Long memberId, @Param("symbol")String symbol);
 | 
 |  |  | 
 | 
 |  |  |     List<MemberCoinAddressEntity> selectCoinAddressListByMap(String symbol, Long memberId);
 | 
 |  |  | 
 | 
 |  |  | 
 | 
 |  |  | 
 | 
 |  |  | }
 | 
 
 |  |  | 
 |  |  |         Map<String, Object> columnMap = new HashMap<>(); | 
 |  |  |         columnMap.put("member_id", memberId); | 
 |  |  |         columnMap.put("symbol", symbol); | 
 |  |  |         List<MemberCoinAddressEntity> selectByMap = memberCoinAddressDao.selectByMap(columnMap); | 
 |  |  |         columnMap.put("symbolscoin_id", "2"); | 
 |  |  |         List<MemberCoinAddressEntity> selectByMap = memberCoinAddressDao.selectCoinAddressListByMap(symbol,memberId); | 
 |  |  |         MemberCoinAddressListVo memberCoinAddressListVo = new MemberCoinAddressListVo(); | 
 |  |  |         List<MemberCoinAddressVo> arrayList = new ArrayList<>(); | 
 |  |  |         if (CollUtil.isNotEmpty(selectByMap)) { | 
 
 |  |  | 
 |  |  |              </if>
 | 
 |  |  |          </where>
 | 
 |  |  |     </select>
 | 
 |  |  | 	 | 
 |  |  |     <select id="selectCoinAddressListByMap" resultType="com.xcong.excoin.modules.member.entity.MemberCoinAddressEntity">
 | 
 |  |  |         select *  from member_coin_address  | 
 |  |  |          <where>
 | 
 |  |  |          is_biyict = 1
 | 
 |  |  |           and symbolscoin_id IS NOT NULL
 | 
 |  |  |              <if test="memberId != null  and  memberId  != ''">
 | 
 |  |  |                   and member_id = #{memberId}
 | 
 |  |  |              </if>
 | 
 |  |  |              <if test="symbol != null  and  symbol  != ''">
 | 
 |  |  |                  and symbol = #{symbol}
 | 
 |  |  |              </if>
 | 
 |  |  |          </where>
 | 
 |  |  |     </select>
 | 
 |  |  |     
 | 
 |  |  | </mapper> |