<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.yami.shop.dao.ShopBankCardMapper">

  <resultMap id="shopWalletMap" type="com.yami.shop.bean.model.ShopWallet">
    <id column="shop_wallet_id" property="shopWalletId" />
    <result column="shop_id" property="shopId"/>
    <result column="unsettled_amount" property="unsettledAmount"/>
    <result column="settled_amount" property="settledAmount"/>
    <result column="freeze_amount" property="freezeAmount"/>
    <result column="total_settled_amount" property="totalSettledAmount"/>
    <result column="version" property="version"/>
    <result column="update_time" property="updateTime"/>
    <result column="shop_name" property="shopName"/>
    <result column="shop_logo" property="shopLogo"/>
  </resultMap>
    <select id="pageShopWallet" resultMap="shopWalletMap">
      select tw.*,tsd.shop_name,tsd.shop_logo from  tz_shop_wallet tw
        join tz_shop_detail tsd on tsd.shop_id = tw.shop_id
        <where>
          <if test="shopWallet.shopName != null and shopWallet.shopName != ''">
            tsd.shop_name like concat('%',#{shopWallet.shopName} ,'%')
          </if>
        </where>
      order by tw.shop_wallet_id desc
    </select>
</mapper>
