<?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.OpenBankInfoMapper">
  <resultMap id="BaseResultMap" type="com.cool.store.entity.wallet.OpenBankInfoDO">
    <!--
      WARNING - @mbg.generated
    -->
    <result column="store_code" jdbcType="VARCHAR" property="storeCode" />
    <result column="store_id" jdbcType="VARCHAR" property="storeId" />
    <result column="signer_name" jdbcType="VARCHAR" property="signerName" />
    <result column="signer_id_card" jdbcType="VARCHAR" property="signerIdCard" />
    <result column="signer_phone" jdbcType="VARCHAR" property="signerPhone" />
    <result column="signer_id_card_front" jdbcType="VARCHAR" property="signerIdCardFront" />
    <result column="signer_id_card_back" jdbcType="VARCHAR" property="signerIdCardBack" />
    <result column="business_license_name" jdbcType="VARCHAR" property="businessLicenseName" />
    <result column="business_license_code" jdbcType="VARCHAR" property="businessLicenseCode" />
    <result column="business_license_photo" jdbcType="VARCHAR" property="businessLicensePhoto" />
    <result column="legal_is_signer" jdbcType="TINYINT" property="legalIsSigner" />
    <result column="legal_name" jdbcType="VARCHAR" property="legalName" />
    <result column="legal_id_card" jdbcType="VARCHAR" property="legalIdCard" />
    <result column="legal_id_card_expire_time" jdbcType="VARCHAR" property="legalIdCardExpireTime" />
    <result column="legal_phone" jdbcType="VARCHAR" property="legalPhone" />
    <result column="legal_id_card_front" jdbcType="VARCHAR" property="legalIdCardFront" />
    <result column="legal_id_card_back" jdbcType="VARCHAR" property="legalIdCardBack" />
    <result column="settlement_card" jdbcType="VARCHAR" property="settlementCard" />
    <result column="bank_branch_name" jdbcType="VARCHAR" property="bankBranchName" />
    <result column="bank_branch_code" jdbcType="VARCHAR" property="bankBranchCode" />
    <result column="bank_reserved_phone" jdbcType="VARCHAR" property="bankReservedPhone" />
    <result column="source" jdbcType="TINYINT" property="source" />
    <result column="legal_bank_card" jdbcType="VARCHAR" property="legalBankCard" />
    <result column="legal_bank_branch_name" jdbcType="VARCHAR" property="legalBankBranchName" />
    <result column="legal_bank_branch_code" jdbcType="VARCHAR" property="legalBankBranchCode" />
    <result column="legal_bank_reserved_phone" jdbcType="VARCHAR" property="legalBankReservedPhone" />
    <result column="legal_signer_relation" jdbcType="VARCHAR" property="legalSignerRelation" />
  </resultMap>

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

</mapper>