csh_advances_received_detail.lview

<?xml version="1.0" encoding="UTF-8"?>

<a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true">
    <a:init-procedure>
        <a:model-query fetchAll="true" model="basic.hls_lease_channel_for_lov" rootPath="lease_channel_path"/>
        <a:model-query defaultWhereClause="t1.business_type in (&apos;LEASE&apos;,&apos;LEASEBACK&apos;)" fetchAll="true" model="basic.hls_business_type_for_lov" rootPath="business_type_path"/>
    </a:init-procedure>
    <a:view>
        <script type="text/javascript"><![CDATA[
        function csh_advances_query() {
            $('csh_advances_grid_ds').query();
        }

        function csh_advances_reset(){
            $('csh_advances_form_ds').reset();
        }

        function csh_advances_export() {
            $('source_to_grid')._export(null,'客户预收款明细');
        }


        ]]></script>
        <a:dataSets>
            <a:dataSet id="lease_channel_ds">
                <a:datas dataSource="/model/lease_channel_path"/>
            </a:dataSet>
            <a:dataSet id="business_type_ds">
                <a:datas dataSource="/model/business_type_path"/>
            </a:dataSet>
            <a:dataSet id="contract_status_ds" lookupCode="CON500_CONTRACT_STATUS"/>
            <a:dataSet id="division_name_ds" loadData="true" model="cont.CON1260.hls_division"/>
            <a:dataSet id="csh_advances_form_ds">
                <a:fields>
                    <a:field name="contract_status_n" displayField="code_value_name" options="contract_status_ds" returnField="contract_status" valueField="code_value"/>
                    <a:field name="lease_channel_n" displayField="description" options="lease_channel_ds"
                             returnField="lease_channel" valueField="lease_channel"/>
                    <a:field name="lease_channel" />
                    <a:field name="business_type_n" displayField="description" options="business_type_ds" returnField="business_type" valueField="business_type"/>
                    <a:field name="business_type" />
                    <a:field name="division_n" displayField="description" options="division_name_ds"
                             returnField="division" valueField="division"/>
                    <a:field name="bp_id_agent_level1_n" lovService="basic.hls_bp_master_v_for_lov?bp_category=AGENT"
                             lovHeight="500" lovLabelWidth="100" lovWidth="800" prompt="代理商" title="代理商">
                        <a:mapping>
                            <a:map from="bp_id" to="bp_id_agent_level1"/>
                            <a:map from="bp_name" to="bp_id_agent_level1_n"/>
                        </a:mapping>
                    </a:field>
                </a:fields>
            </a:dataSet>
            <a:dataSet id="csh_advances_grid_ds"
                       model="csh.CSH1030.csh_advances_received_detail"
                       queryDataSet="csh_advances_form_ds" autoQuery="false" selectable="true" selectionModel="single">
            </a:dataSet>
        </a:dataSets>

        <a:screenBody>
            <a:screenTopToolbar>
                <a:screenTitle/>
                <a:gridButton click="csh_advances_query" text="查询"/>
                <a:gridButton click="csh_advances_reset" text="重置"/>
                <a:gridButton click="csh_advances_export" text="导出"/>
            </a:screenTopToolbar>
            <a:form column="4" marginWidth="100" title="查询条件">
                <a:textField name="contract_number" bindTarget="csh_advances_form_ds" prompt="合同编号"/>
                <a:textField name="bp_code" bindTarget="csh_advances_form_ds" prompt="客户编号" />
                <a:textField name="bp_name" bindTarget="csh_advances_form_ds" prompt="客户名称" />
                <a:comboBox name="contract_status_n" bindTarget="csh_advances_form_ds" prompt="合同状态"/>
                <a:lov name="bp_id_agent_level1_n" bindTarget="csh_advances_form_ds" prompt="代理商"/>
                <a:datePicker name="journal_date_from" bindTarget="csh_advances_form_ds" prompt="记账日期从"/>
                <a:datePicker name="journal_date_to" bindTarget="csh_advances_form_ds" prompt="记账日期到"/>
                <a:textField name="transaction_num" bindTarget="csh_advances_form_ds" prompt="预收款现金事务编号" />
               <a:numberField name="transaction_amount_from" bindTarget="csh_advances_form_ds" prompt="预收款金额从"/>
                <a:numberField name="transaction_amount_to" bindTarget="csh_advances_form_ds" prompt="预收款金额到"/>
                <a:textField name="bp_bank_account_name" bindTarget="csh_advances_form_ds" prompt="汇款人" />
                <a:textField name="transaction_num_y" bindTarget="csh_advances_form_ds" prompt="汇款现金事务编号" />
                <!--<a:comboBox name="division_n" bindTarget="csh_advances_form_ds" prompt="产品线"/>-->
                <!--<a:comboBox name="business_type_n" bindTarget="csh_advances_form_ds" prompt="商业模式"/>-->
                <!--<a:comboBox name="lease_channel_n" bindTarget="csh_advances_form_ds" prompt="业务类型" />-->
            </a:form>
            <a:grid id="source_to_grid" bindTarget="csh_advances_grid_ds" navBar="true" height="400" marginWidth="100">
                <a:columns>
                    <a:column name="contract_number" align="center" prompt="合同编号" width="130"/>
                    <a:column name="bp_code" align="center" prompt="客户编号" width="100"/>
                    <a:column name="bp_name" align="center" prompt="客户名称" width="100"/>
                    <a:column name="bp_agent_code" align="center" prompt="代理商编号" width="100"/>
                    <a:column name="bp_agent_name" align="center" prompt="代理商名称" width="100"/>
                    <a:column name="pattern" align="center" prompt="机型" width="100"/>
                    <a:column name="machine_number" align="center" prompt="机号" width="100"/>
                    <a:column name="transaction_amount" align="center" prompt="预收款金额" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="unwrite_off_amount" align="center" prompt="未核销金额" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="contract_status_n" align="center" prompt="合同状态" width="100"/>
                    <a:column name="et_date" align="center" prompt="结清日期" width="100" renderer="Leaf.formatDate"/>
                    <a:column name="journal_date" align="center" prompt="记账日期" width="100" renderer="Leaf.formatDate"/>
                    <a:column name="transaction_num" align="center" prompt="预收款现金事务编号" width="150"/>
                    <a:column name="transaction_num_y" align="center" prompt="汇款现金事务编号" width="150"/>
                    <a:column name="transaction_amount_y" align="center" prompt="汇款金额" width="100" renderer="Leaf.formatMoney"/>
                    <a:column name="transaction_date" align="center" prompt="汇款日期" width="100" renderer="Leaf.formatDate"/>
                    <a:column name="bp_bank_account_name" align="center" prompt="汇款人" width="100"/>
                    <a:column name="description" align="center" prompt="汇款摘要" width="100"/>
                    <a:column name="ref_v05" align="center" prompt="备注" width="100"/>
                    <a:column name="zuonr" align="center" prompt="凭证上的ASSIGNMENT" width="150"/>
                    <a:column name="re_kunnr" align="center" prompt="客户sap编码" width="100"/>
                    <a:column name="division_n" align="center" prompt="产品线" width="100"/>
                    <a:column name="business_type_n" align="center" prompt="商业模式" width="150"/>
                    <a:column name="lease_channel_n" align="center" prompt="业务类型" width="100"/>
                </a:columns>
            </a:grid>
        </a:screenBody>
    </a:view>
</a:screen>