<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[select 
  t.post_id,
  t.item_id,
  t.new_flag,
  (t.item_length||t.item_type||t.org_code||t.bus_type||t.bus_detail||
  t.bus_number||t.ocu_place||t.start_date||t.end_date||t.currency||
  t.credit_amount||t.share_credit||t.debt_amount||t.guta_method||
  t.pay_type||t.pay_months||t.left_months||t.due_date||t.last_due_date||
  t.due_amount||t.rec_amount||t.left_amount||t.overdue_times||t.overdue_amount||
  t.over31_60||t.over61_90||t.over91_180||t.over181||t.over_times_t||t.top_over_times||
  t.five_status||t.item_status||t.repay24||t.overdraft||t.new_flag||t.tenant_name||t.card_type||
  t.id_card_no||t.ref_v01) base_str,
  (select l.item_type||l.sex_type||l.birtth_date||l.marital_status||l.academic_background||
  l.academic_degree||l.phone||l.cell_phone||l.work_phone||l.mail||
  l.address||l.zip_code||l.card_address||l.name_sp||l.card_type_sp||
  l.id_card_no_sp||l.address_sp||l.cell_phone_sp||l.job_item_type||l.job_code||
  l.unit_name||l.industry||l.unit_address||l.unit_zipcode||l.unit_year||l.job_level||
  l.job_name||l.income||l.paycard_num||l.paycard_bank||l.live_item_type||l.live_address||
  l.live_zipcode||l.live_condition 
from hls_zx_post_identity l
where l.item_id = t.item_id) identify_str
from hls_zx_post_base t
where t.post_id = ${@post_id}
and t.send_flag='Y']]></bm:query-sql>
            <bm:parameters>
                <bm:parameter name="post_id"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="post_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="POST_ID"/>
        <bm:field name="item_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ITEM_ID"/>
        <bm:field name="base_str" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BASE_STR"/>
        <bm:field name="new_flag"/>
        <bm:field name="identify_str"/>
    </bm:fields>
</bm:model>
