第三十九天：Aurora组件lov的用法

<?xml version="1.0" encoding="UTF-8"?>
<!-- 
	author:wht
	date:20170614
	-->
<a:screen xmlns:a="http://www.aurora-framework.org/application" trace="true">
    <a:init-procedure/>
    <a:view package="ui.template" template="empty">
        <!--数据操作层-->
        <a:dataSets>
            <!--数据源-->
            <a:dataSet id="find_company_result_ds" autoPageSize="true" canSubmit="true" model="gld.fnd_company"/>
            <!--数据链接层-->
            <a:dataSet id="functional_currency">
                <a:fields>
                    <a:field name="functional_currency_name" autoComplete="true" autoCompleteField="currency_code" autoCompleteSize="1" lovAutoQuery="true" lovGridHeight="200" lovHeight="380" lovLabelWidth="100" lovService="gld.gld_currency" lovWidth="400" required="true" requiredMessage="公司货币不能为空" title="货币类型">
                        <a:mapping>
                            <a:map from="currency_code" to="function_currency_code"/>
                            <a:map from="currency_name" to="function_currency_name"/>
                        </a:mapping> 
                    </a:field>
                </a:fields>
            </a:dataSet>
        </a:dataSets>
        <!--数据显示层-->
        <a:screen-Body>
            <a:form column="1" marginWidth="760" title="货币">
                <a:lov name="functional_currency_name" bindTarget="functional_currency" prompt="功能货币" width="208"/>
            </a:form>
        </a:screen-Body>
    </a:view>
</a:screen>

<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:e="aurora.service.exception" xmlns:o="aurora.database.local.oracle" xmlns:bm="http://www.aurora-framework.org/schema/bm" xmlns:f="aurora.database.features" alias="t" baseTable="FND_COMPANIES_6603">
    <bm:fields>
        <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID" prompt="FND_COMPANIES_6603.COMPANY_ID"/>
        <bm:field name="company_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_CODE" prompt="FND_COMPANIES_6603.COMPANY_CODE"/>
        <bm:field name="company_short_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_SHORT_NAME" prompt="FND_COMPANIES_6603.COMPANY_SHORT_NAME"/>
        <bm:field name="company_full_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_FULL_NAME" prompt="FND_COMPANIES_6603.COMPANY_FULL_NAME"/>
        <bm:field name="functional_currency_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FUNCTIONAL_CURRENCY_CODE" prompt="FND_COMPANIES_6603.FUNCTIONAL_CURRENCY_CODE"/>
        <bm:field name="start_date_active" databaseType="DATE" datatype="java.util.Date" physicalName="START_DATE_ACTIVE" prompt="FND_COMPANIES_6603.START_DATE_ACTIVE"/>
        <bm:field name="end_date_active" databaseType="DATE" datatype="java.util.Date" physicalName="END_DATE_ACTIVE" prompt="FND_COMPANIES_6603.END_DATE_ACTIVE"/>
        <bm:field name="exchange_rate_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXCHANGE_RATE_TYPE" prompt="FND_COMPANIES_6603.EXCHANGE_RATE_TYPE"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
        <o:sequence-pk/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="company_id"/>
    </bm:primary-key>
    <bm:order-by>
        <bm:order-field name="company_id"/>
    </bm:order-by>
    <bm:data-filters>
        <bm:data-filter enforceOperations="query" expression="t.start_date_active is not null"/>
        <!-- <bm:data-filter name="activeValide" expression="t.start_date_active < t.end_date_active"/> -->
    </bm:data-filters>
    <bm:relations>
        <bm:relation name="cc" joinType="LEFT OUTER" refModel="gld.gld_currency">
            <bm:reference foreignField="currency_code" localField="functional_currency_code"/>
        </bm:relation>
    </bm:relations>
    <bm:ref-fields>
        <bm:ref-field name="functional_currency_name" relationName="cc" sourceField="currency_name"/>
    </bm:ref-fields>
    <bm:query-fields>
        <bm:query-field field="company_code" queryOperator="like"/>
        <bm:query-field name="company_name" queryExpression="t.company_full_name like '%' || ${@company_name} || '%'"/>
        <!-- <bm:query-field field="company_short_name" queryExpression="t.company_short_name like ${@company_short_name} || ' % '"/>
        <bm:query-field field="company_full_name" queryExpression="t.company_full_name like ${@company_full_name} || ' % '"/>
        <bm:query-field name="start_date_active" queryExpression="t.start_date_active >= ${@start_date_active}"/>
        <bm:query-field name="end_date_active" queryExpression="t.end_date_active < ${@end_date_active}"/> -->
    </bm:query-fields>
    <e:exception-descriptor-config>
        <e:exception-descriptor exception="java.sql.SQLException" handleClass="aurora.database.SQLExceptionDescriptor">
            <e:error-message code="1" message="FND_COMPANIES.COMPANY_CODE_DISTINCT"/>
        </e:exception-descriptor>
    </e:exception-descriptor-config>
    <!-- <bm:operations>
    	<bm:operation name="insert">
    		<bm:update-sql><![CDATA[
    			begin
  					fnd_companies_pkg_6603.insert_fnd_companies(p_company_code => ${@company_code}, 
                                              					p_company_short_name => ${@company_short_name}, 
					                                            p_company_full_name => ${@company_full_name}, 
					                                            p_functional_currency_code => ${@functional_currency_code}, 
					                                            p_start_date_active => ${@start_date_active}, 
					                                            p_end_date_active => ${@end_date_active}, 
					                                            p_exchange_rate_type => ${@exchange_rate_type}, 
					                                            p_created_by => ${@create_by});
				end;
    		]]></bm:update-sql>
    	</bm:operation>
    	
    	<bm:operation name="update">
		    <bm:update-sql><![CDATA[
				begin
				  fnd_companies_pkg_6603.update_fnd_companies(p_company_code => ${@company_code}, 
				                                              p_company_short_name => ${@company_short_name}, 
				                                              p_company_full_name => ${@company_full_name}, 
				                                              p_functional_currency_code => ${@functional_currency_code}, 
				                                              p_start_date_active => ${@start_date_active}, 
				                                              p_end_date_active => ${@end_date_active}, 
				                                              p_exchange_rate_type => ${@exchange_rate_type}, 
				                                              p_last_updated_by => ${@last_updated_by});
				end;
		    ]]></bm:update-sql>
    	</bm:operation>
    	
    	<bm:operation name="delete">
    		<bm:update-sql><![CDATA[
    			begin
				  fnd_companies_pkg_6603.delete_fnd_companies(p_company_code => ${@company_code});
				end;
    		]]></bm:update-sql>
    	</bm:operation>
    </bm:operations> -->
</bm:model>