<?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="cn.ey.biz.module.system.dal.mapper.codeblock.GdsRateCodeBlockMapper">
    <resultMap id="BaseResultMap" type="cn.ey.biz.module.system.dal.dataobject.codeblock.GdsRateCodeBlockDO">
        <result column="code_block_id" jdbcType="BIGINT" property="codeBlockId"/>
        <result column="code_block_code" jdbcType="VARCHAR" property="codeBlockCode"/>
        <result column="area_code" jdbcType="VARCHAR" property="areaCode"/>
        <result column="area_name" jdbcType="VARCHAR" property="areaName"/>
        <result column="country_region_code" jdbcType="VARCHAR" property="countryRegionCode"/>
        <result column="country_region_name" jdbcType="VARCHAR" property="countryRegionName"/>
        <result column="geo_region_code" jdbcType="VARCHAR" property="geoRegionCode"/>
        <result column="geo_region_name" jdbcType="VARCHAR" property="geoRegionName"/>
        <result column="legal_entity_code" jdbcType="VARCHAR" property="legalEntityCode"/>
        <result column="legal_entity_name" jdbcType="VARCHAR" property="legalEntityName"/>
        <result column="bu_code" jdbcType="VARCHAR" property="buCode"/>
        <result column="bu_name" jdbcType="VARCHAR" property="buName"/>
        <result column="ou_code" jdbcType="VARCHAR" property="ouCode"/>
        <result column="ou_name" jdbcType="VARCHAR" property="ouName"/>
        <result column="mu_code" jdbcType="VARCHAR" property="muCode"/>
        <result column="mu_name" jdbcType="VARCHAR" property="muName"/>
        <result column="smu_code" jdbcType="VARCHAR" property="smuCode"/>
        <result column="smu_name" jdbcType="VARCHAR" property="smuName"/>
        <result column="sl_code" jdbcType="VARCHAR" property="slCode"/>
        <result column="sl_name" jdbcType="VARCHAR" property="slName"/>
        <result column="ssl_code" jdbcType="VARCHAR" property="sslCode"/>
        <result column="ssl_name" jdbcType="VARCHAR" property="sslName"/>
        <result column="competency_code" jdbcType="VARCHAR" property="competencyCode"/>
        <result column="competency_name" jdbcType="VARCHAR" property="competencyName"/>
        <result column="market_segment_code" jdbcType="VARCHAR" property="marketSegmentCode"/>
        <result column="market_segment_name" jdbcType="VARCHAR" property="marketSegmentName"/>
        <result column="mr_code" jdbcType="VARCHAR" property="mrCode"/>
        <result column="mr_name" jdbcType="VARCHAR" property="mrName"/>
        <result column="city_code" jdbcType="VARCHAR" property="cityCode"/>
        <result column="city_name" jdbcType="VARCHAR" property="cityName"/>
        <result column="mercury_competency_code" jdbcType="VARCHAR" property="mercuryCompetencyCode"/>
        <result column="mercury_competency_name" jdbcType="VARCHAR" property="mercuryCompetencyCode"/>
        <result column="category_code" jdbcType="VARCHAR" property="categoryCode"/>
    </resultMap>
    <sql id="Base_Column_List">
        code_block_id,code_block_code,country_region_code,country_region_name,area_code,area_name,
        geo_region_code,geo_region_name, legal_entity_code, legal_entity_name,bu_code,bu_name,
        ou_code,ou_name,
        mu_code, mu_name,smu_code, smu_name,sl_code, sl_name,ssl_code,ssl_name, competency_code, competency_name,
        market_segment_code,market_segment_name, mr_code,mr_name, city_code,city_name,
        mercury_competency_code, mercury_competency_name,category_code
    </sql>

    <select id="financeFilterList" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List"/>
        from dict_gds_rate_code_block where  deleted =0 and source_type='gds' and status=0 and new_version=1
        order by code_block_id
    </select>


</mapper>