1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<?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 * from(
SELECT hls_notice_definition_id,notice_msg,notice_name,user_show_flag,dealer_show_flag,sequence_num,to_char(start_date,'yyyy-mm-dd') start_date,to_char(end_date,'yyyy-mm-dd') end_date from(
SELECT t.hls_notice_definition_id,t.notice_name,t.notice_msg,t.user_show_flag,t.dealer_show_flag,t.sequence_num,
t.start_date,t.end_date
FROM hls_notice_definition t
) t1
where t1.start_date <= trunc(sysdate)
and
nvl(t1.end_date,sysdate) >= trunc(sysdate)
and (hls_common_pkg.show_notice(t1.hls_notice_definition_id,${/session/@user_id})) = 'Y'
) t2
#WHERE_CLAUSE#
ORDER BY t2.sequence_num desc
]]></bm:query-sql>
</bm:operation>
</bm:operations>
<bm:fields>
<bm:field name="hls_notice_definition_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="HLS_NOTICE_DEFINITION_ID" required="true"/>
<bm:field name="notice_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTICE_NAME" required="true"/>
<bm:field name="notice_msg" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTICE_MSG"/>
<bm:field name="user_show_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USER_SHOW_FLAG"/>
<bm:field name="dealer_show_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEALER_SHOW_FLAG"/>
<bm:field name="sequence_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SEQUENCE_NUM"/>
<bm:field name="start_date" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="START_DATE"/>
<bm:field name="end_date" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="END_DATE"/>
</bm:fields>
<bm:query-fields>
<bm:query-field field="hls_notice_definition_id" queryExpression="hls_notice_definition_id = ${/parameter/@hls_notice_definition_id}"/>
<bm:query-field field="notice_name" queryOperator="like"/>
<bm:query-field field="notice_msg" queryOperator="like"/>
<bm:query-field field="start_date" queryExpression="t2.start_date >= ${@start_date}"/>
<bm:query-field field="end_date" queryExpression="t2.end_date <= ${@end_date}"/>
</bm:query-fields>
</bm:model>