<?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.cgd.pay.dao.SubAcctInfoMapper">
<resultMap id="BaseResultMap" type="com.cgd.pay.po.SubAcctInfo">
<id column="SUB_ACCT_NO" jdbcType="VARCHAR" property="subAcctNo" />
<result column="SUB_ACCT_NAME" jdbcType="VARCHAR" property="subAcctName" />
<result column="ORG_ID" jdbcType="BIGINT" property="orgId" />
<result column="MAIN_ACCT_NO" jdbcType="VARCHAR" property="mainAcctNo" />
<result column="OVERDRAFT" jdbcType="DECIMAL" property="overdraft" />
<result column="CCY" jdbcType="VARCHAR" property="ccy" />
<result column="BALANCE" jdbcType="DECIMAL" property="balance" />
<result column="STATUS" jdbcType="CHAR" property="status" />
<result column="SERVICE_TYPE" jdbcType="INTEGER" property="serviceType" />
<result column="USED_OVERDRAFT" jdbcType="DECIMAL" property="usedOverdraft" />
<result column="PROJECT_ID" jdbcType="BIGINT" property="projectId" />
<result column="LOGIN_ID" jdbcType="BIGINT" property="loginId" />
<result column="CREATE_DATE" jdbcType="DATE" property="createDate" />
<result column="CREATE_ORG_ID" jdbcType="BIGINT" property="createOrgId" />
<result column="UPDATE_ID" jdbcType="BIGINT" property="updateId" />
<result column="UPDATE_DATE" jdbcType="DATE" property="updateDate" />
<result column="UPDATE_ORG_ID" jdbcType="BIGINT" property="updateOrgId" />
</resultMap>
<resultMap id="ExtResultMap" type="com.cgd.pay.atom.bo.SubAcctInfoExt" extends="BaseResultMap">
<id column="SUB_ACCT_NO" jdbcType="VARCHAR" property="subAcctNo" />
<result column="MAIN_ACCT_NAME" jdbcType="VARCHAR" property="mainAcctName" />
<result column="SUPERIOR_ORG_ID" jdbcType="BIGINT" property="superiorOrgId" />
<result column="SOURCE" jdbcType="VARCHAR" property="source" />
<result column="OPEN_BANK" jdbcType="VARCHAR" property="openBank" />
</resultMap>
<!-- 子账号联动主账号查询 -->
<select id="selectWihtMainAcct" parameterType="Map" resultMap="ExtResultMap">select
*
from
(
select
s.*,
m.org_id as SUPERIOR_ORG_ID,m.MAIN_ACCT_NAME,m.source
from d_sub_acct_info s
inner join d_main_acct_info m
on s.main_acct_no=m.MAIN_ACCT_NO
where 1=1
<if test="subAcctNo != null">
AND SUB_ACCT_NO=#{subAcctNo,jdbcType=VARCHAR}
</if>
<if test="serviceType != null">
AND SERVICE_TYPE=#{serviceType,jdbcType=INTEGER}
</if>
<if test="orgId != null">
AND s.ORG_ID=#{orgId,jdbcType=BIGINT}
</if>
<if test="serviceType != null">
AND SERVICE_TYPE=#{serviceType,jdbcType=INTEGER}
</if>
<if test="projectId != null">
AND PROJECT_ID=#{projectId,jdbcType=BIGINT}
</if>
) as n
where 1=1
<if test="superiorOrgId != null">
AND SUPERIOR_ORG_ID=#{superiorOrgId,jdbcType=BIGINT}
</if>
<if test="source != null">
AND SOURCE=#{source,jdbcType=VARCHAR}
</if>
</select>
</mapper>