<?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.cool.store.mapper.wallet.TempOpenWalletInfoMapper">
  <resultMap id="BaseResultMap" type="com.cool.store.entity.wallet.TempOpenWalletInfoDO">
    <!--
      WARNING - @mbg.generated
    -->
    <result column="store_code" jdbcType="VARCHAR" property="storeCode" />
    <result column="store_name" jdbcType="VARCHAR" property="storeName" />
    <result column="store_mode" jdbcType="VARCHAR" property="storeMode" />
    <result column="ledger_name" jdbcType="VARCHAR" property="ledgerName" />
    <result column="ledger_status" jdbcType="VARCHAR" property="ledgerStatus" />
    <result column="business_type" jdbcType="VARCHAR" property="businessType" />
    <result column="business_reg_name" jdbcType="VARCHAR" property="businessRegName" />
    <result column="business_license_no" jdbcType="VARCHAR" property="businessLicenseNo" />
    <result column="business_address" jdbcType="VARCHAR" property="businessAddress" />
    <result column="province" jdbcType="VARCHAR" property="province" />
    <result column="city" jdbcType="VARCHAR" property="city" />
    <result column="district" jdbcType="VARCHAR" property="district" />
    <result column="legal_person_name" jdbcType="VARCHAR" property="legalPersonName" />
    <result column="legal_person_id_no" jdbcType="VARCHAR" property="legalPersonIdNo" />
    <result column="legal_id_start_date" jdbcType="DATE" property="legalIdStartDate" />
    <result column="legal_id_expire_date" jdbcType="DATE" property="legalIdExpireDate" />
    <result column="settler_name" jdbcType="VARCHAR" property="settlerName" />
    <result column="settler_id_no" jdbcType="VARCHAR" property="settlerIdNo" />
    <result column="settler_id_start_date" jdbcType="DATE" property="settlerIdStartDate" />
    <result column="settler_id_expire_date" jdbcType="DATE" property="settlerIdExpireDate" />
    <result column="bank_branch_name" jdbcType="VARCHAR" property="bankBranchName" />
    <result column="bank_branch_no" jdbcType="VARCHAR" property="bankBranchNo" />
    <result column="settlement_card_no" jdbcType="VARCHAR" property="settlementCardNo" />
    <result column="bank_reserved_phone" jdbcType="VARCHAR" property="bankReservedPhone" />
    <result column="accounting_relation" jdbcType="VARCHAR" property="accountingRelation" />
  </resultMap>

  <select id="getTempOpenWalletInfoByStoreCode" resultMap="BaseResultMap">
    select * from zxjp_temp_open_wallet_info where store_code = #{storeCode}
  </select>


</mapper>