<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[select 
				  lower(eh.table_name) table_name,
				  eh.sheet_seq,
				  eh.multi_flag,
				  eh.multi_line_from,
				  eh.multi_line_to,
				  lower(el.field_name) field_name,
				  el.field_query,
				  el.sheet_row,
				  el.sheet_column,
				  el.field_query,
				  el.ln_id
				from hls_excel_templete et,hls_excel_templete_hd eh,hls_excel_templete_ln el
				where et.templete_id = eh.templete_id
				and eh.hd_id = el.hd_id
				and et.templete_code = ${@templete_code}
				order by eh.sheet_seq,eh.hd_id]]></bm:query-sql>
            <bm:parameters>
                <bm:parameter name="templete_code"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
