cus_reports.lview 9.33 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: nyl  
    $Date: 2015-3-13 上午10:30:25  
    $Revision: 1.0  
    $Purpose: 
-->
<a:screen xmlns:a="http://www.leaf-framework.org/application" customizationEnabled="true" trace="true">
    <a:init-procedure>
        <a:model-query fetchAll="true" model="cont.CON620.get_sysdate" rootPath="sysdate"/>
    </a:init-procedure>
    <a:view>
        <a:link id="con_contract_get_layout_code_link_id" model="cont.CON500.con_contract_get_layout_code" modelaction="update"/>
        <script type="text/javascript"><![CDATA[
            function cus319_con_contract_return() {
                history.go(-1);
            }
            
            function cus319_con_contract_query() {
                $('cus319_contract_result_ds').query();
            }
            
            function cus319_con_contract_reset() {
                $('cus319_contract_query_ds').reset();
                init();
            }
            
            function cus319_con_contract_export() {
                $('con501_con_contract_grid_ds')._export();
            }
            
            function init() {
            
                var record = $('cus319_contract_query_ds').getAt(0);
                record.getField('contract_number').setRequired(true);
                record.getField('period_name').setRequired(true);
            }
            
            function queryDs_onUpdate(ds, record, name, value, oldvalue) {
            
                if (name == 'contract_number' && record.get('contract_number')) {
                    record.getField('contract_number').setRequired(false);
                    record.getField('period_name').setRequired(false);
                }
                if (name == 'period_name' && record.get('period_name')) {
                    record.getField('contract_number').setRequired(false);
                    record.getField('period_name').setRequired(false);
                }
            }
        ]]></script>
        <a:screen-include screen="modules/cont/CON500/con_contract_get_layout_code.lview"/>
        <!--         <a:screen-include screen="modules/cont/CON500/con_contract_authority_list_validate.lview?document_category=CONTRACT&amp;function_code=cus319"/> -->
        <a:dataSets>
            <a:dataSet id="con301_division_name_ds" loadData="true" model="basic.hls_division_for_lov"/>
            <a:dataSet id="cus319_contract_query_ds" autoCreate="true">
                <a:fields>
                    <a:field name="bp_id_tenant_c" autoComplete="true" lovGridHeight="350" lovHeight="500" lovService="basic.hls_bp_master_v_for_lov?bp_category=TENANT" lovWidth="500" title="HLS.BP_TITLE">
                        <a:mapping>
                            <a:map from="bp_code" to="bp_id_tenant_c"/>
                            <a:map from="bp_name" to="bp_id_tenant_n"/>
                            <a:map from="bp_id" to="bp_id_tenant"/>
                        </a:mapping>
                    </a:field>
                    <a:field name="contract_number" autoComplete="true" autoCompleteField="contract_number" lovGridHeight="300" lovHeight="450" lovService="cus.CUS319.con_contract_number_lov" lovWidth="500" required="true" title="HLS.CONTRACT_NUMBER">
                        <a:mapping>
                            <a:map from="contract_number" to="contract_number"/>
                            <a:map from="contract_id" to="contract_id"/>
                            <a:map from="search_term_1" to="search_term_1"/>
                            <a:map from="contract_name" to="contract_name"/>
                        </a:mapping>
                    </a:field>
                    <a:field name="contract_id"/>
                    <a:field name="bp_id_tenant"/>
                    <a:field name="bp_id_tenant_n"/>
                    <a:field name="division_desc" displayField="description" options="con301_division_name_ds" returnField="division" valueField="division"/>
                    <a:field name="search_term_1"/>
                    <a:field name="division"/>
                    <a:field name="serial_number"/>
                    <a:field name="period_name" autoComplete="true" autoCompleteField="period_name" lovGridHeight="300" lovHeight="450" lovService="gld.gld_period_lov" lovWidth="500" required="true" title="会计期间">
                        <a:mapping>
                            <a:map from="period_name" to="period_name"/>
                        </a:mapping>
                    </a:field>
                </a:fields>
                <a:events>
                    <a:event name="update" handler="queryDs_onUpdate"/>
                </a:events>
            </a:dataSet>
            <a:dataSet id="cus319_contract_result_ds" model="cus.CUS319.cus_con_contact_vat_detail_lv" pageSize="100" queryDataSet="cus319_contract_query_ds" selectable="true"><![CDATA[
                ]]></a:dataSet>
        </a:dataSets>
        <a:screenBody>
            <a:screenTopToolbar>
                <a:screenTitle/>
                <a:gridButton click="cus319_con_contract_return" text="HLS.RETURN"/>
                <a:gridButton click="cus319_con_contract_query" text="HLS.QUERY"/>
                <a:gridButton click="cus319_con_contract_reset" text="HLS.RESET"/>
                <a:gridButton click="cus319_con_contract_export" text="导出"/>
            </a:screenTopToolbar>
            <a:form column="4" labelSeparator=" " labelWidth="100" marginWidth="30" title="CON301.CONTRACT_QUERY">
                <a:lov name="bp_id_tenant_c" bindTarget="cus319_contract_query_ds" prompt="客户编码"><![CDATA[
                 ]]></a:lov>
                <a:textField name="bp_id_tenant_n" bindTarget="cus319_contract_query_ds" prompt="客户名称"/>
                <a:comboBox name="division_desc" bindTarget="cus319_contract_query_ds" prompt="产品线"/>
                <a:textField name="serial_number" bindTarget="cus319_contract_query_ds" prompt="设备编号"/>
                <a:lov name="contract_number" bindTarget="cus319_contract_query_ds" prompt="合同序号"/>
                <a:textField name="contract_name" bindTarget="cus319_contract_query_ds" prompt="合同名称"/>
                <a:textField name="search_term_1" bindTarget="cus319_contract_query_ds" prompt="合同号"/>
                <a:lov name="period_name" bindTarget="cus319_contract_query_ds" prompt="会计期间"/>
            </a:form>
            <a:grid id="con501_con_contract_grid_ds" bindTarget="cus319_contract_result_ds" marginHeight="200" marginWidth="30" navBar="true">
                <a:columns>
                    <a:column name="search_term_1" align="left" prompt="合同号" width="100"/>
                    <a:column name="contract_number" align="left" prompt="合同序号" width="100"/>
                    <a:column name="contract_name" align="left" prompt="合同名称" width="120"/>
                    <a:column name="bp_id_tenant_n" align="left" prompt="承租人" width="150"/>
                    <a:column name="period_name" align="center" prompt="会计期间" width="80"/>
                    <a:column name="lease_item_amount_c" align="right" prompt="整机价格" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="lease_item_amount" align="right" prompt="整机价格" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="insurance_fee_c" align="right" prompt="保险费" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="down_payment_received_c" align="right" prompt=" DownPayment " renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="lease_item_certi" align="right" prompt=" 本期设备认证 " renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="insurance_fee_received_c" align="right" prompt="本期保险费扣减" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="down_payment_invoice_c" align="right" prompt="开票首付" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="mgt_fee_invoice_c" align="right" prompt="开票管理费" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="rental_invoice_c" align="right" prompt=" 开票租金 " renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="total_invoice_c" align="right" prompt="开票小计" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="amount_declare" align="right" prompt="设备本金扣除首付后一次性申报" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="principal_invoice_c" align="right" prompt="当期开票租金内含本金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="total_uninvoice_declare_c" align="right" prompt="未开票申报小计" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="toal_declare" align="right" prompt=" 申报收入合计 " renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="vat_uninvoice_last_month" align="right" prompt="上月未票VAT累计" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="vat_uninvoice_c" align="right" prompt="本月未票VAT累计" renderer="Leaf.formatMoney" width="100"/>
                </a:columns>
            </a:grid>
        </a:screenBody>
        <script type="text/javascript"><![CDATA[
        init();
    ]]></script>
    </a:view>
</a:screen>