cus_reports.lview 12.2 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 142 143 144 145 146 147 148 149 150 151 152 153
<?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 model="cus.CUS100.cus_default_values" rootPath="default_value"/>
    </a:init-procedure>
    <a:init-procedure><![CDATA[

]]></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 cus312n_con_contract_return() {
                history.go(-1);
            }
            
            function cus312n_con_contract_query() {
                $('cus312n_contract_result_ds').query();
            }
            
            function cus312n_con_contract_reset(){
                $('cus312n_contract_query_ds').reset();
            }
            
            function cus312n_con_contract_export(){
                $('cus312n_con_contract_grid_ds')._export();
            }
 
            
        ]]></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=cus312n"/> -->
        <a:dataSets>
            <a:dataSet id="cus312n_contract_query_ds">
                <a:fields>
                    <a:field name="period_name" defaultValue="${/model/default_value/record/@current_month}"/>
                    <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="bp_id_tenant"/>
                    <a:field name="bp_id_tenant_n"/>
                    <a:field name="transaction_date_from"/>
                    <a:field name="transaction_date_to" defaultValue="${/model/default_value/record/@sys_date}" required="true"/>
                </a:fields>
            </a:dataSet>
            <a:dataSet id="cus312n_contract_result_ds" model="cus.CUS312N.cus_payment_current_report_lv" pageSize="100" queryDataSet="cus312n_contract_query_ds" selectable="true">
                <!--    <a:events> 
                    <a:event name="query" handler="aut_authority_list_validate_query"/>
                </a:events> --><![CDATA[
                
                
                
                
             
            ]]></a:dataSet>
        </a:dataSets>
        <a:screenBody>
            <a:screenTopToolbar>
                <a:screenTitle/>
                <a:gridButton click="cus312n_con_contract_return" text="HLS.RETURN"/>
                <a:gridButton click="cus312n_con_contract_query" text="HLS.QUERY"/>
                <a:gridButton click="cus312n_con_contract_reset" text="HLS.RESET"/>
                <a:gridButton click="cus312n_con_contract_export" text="导出"/>
            </a:screenTopToolbar>
            <a:form column="4" labelSeparator=" " labelWidth="100" marginWidth="30" title="CON301.CONTRACT_QUERY">
                <!-- <a:textField name="period_name" bindTarget="cus312n_contract_query_ds" prompt="计算月份"/> -->
                <a:textField name="contract_number" bindTarget="cus312n_contract_query_ds" prompt="合同序号"/>
                <a:textField name="search_term_1" bindTarget="cus312n_contract_query_ds" prompt="合同号"/>
                <a:lov name="bp_id_tenant_c" bindTarget="cus312n_contract_query_ds" prompt="客户编码"><![CDATA[
                   ]]></a:lov>
                <a:textField name="bp_id_tenant_n" bindTarget="cus312n_contract_query_ds" prompt="客户名称"/>
                <!-- <a:datePicker name="transaction_date_from" bindTarget="cus312n_contract_query_ds" prompt="收款日期从"/> -->
                <a:datePicker name="transaction_date_to" bindTarget="cus312n_contract_query_ds" prompt="计算截止日"/>
            </a:form>
            <a:grid id="cus312n_con_contract_grid_ds" bindTarget="cus312n_contract_result_ds" marginHeight="265" 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="bp_id_tenant_n" align="left" prompt="客户名称" width="100"/>
                    <a:column name="account_period" align="center" prompt="会计期间" width="100"/>
                    <a:column name="inception_of_lease" align="center" prompt="起租日" width="100"/>
                    <a:column name="signing_date" align="center" prompt="合同签订日" width="100"/>
                    <a:column name="transaction_date" align="center" prompt="收款日期" width="100"/>
                    <a:column name="division_n" align="left" prompt="产品线" width="100"/>
                    <a:column name="specification" align="left" prompt="设备型号" width="100"/>
                    <a:column name="serial_number" align="left" prompt="设备编号" width="100"/>
                    <a:column name="bp_id_vender_n" align="left" prompt="供应商" width="100"/>
                    <a:column name="province_id_tenant_n" align="left" prompt="承租人省份" width="100"/>
                    <a:column name="lease_item_amount" align="right" prompt="整机价格" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="insurance_fee" align="right" prompt="保险费" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="csa" align="right" prompt="CSA" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="ar" align="right" prompt="应付账款" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="lease_mgt_fee" align="right" prompt="管理费" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="residual_value" align="right" prompt="抵押金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="deposit" align="right" prompt="保证金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="down_payment_1" align="right" prompt="DOWNPAYMENT" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="down_payment" align="right" prompt="首付款" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="change_type" align="right" prompt="合同变更" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="change_date" align="right" prompt="变更时间" width="100"/>
                    <a:column name="ccr_fee" align="right" prompt="变更手续费" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="actual_finance_amount" align="right" prompt="净融资额" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="total_interest" align="right" prompt="利息总额" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="finance_income_sum" align="right" prompt="确认收入总额" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="due_amount" align="right" prompt="月租金总和" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="total_rental" align="right" prompt="租金总和" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="int_rate" align="right" prompt="名义利率" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="collected_times" align="right" prompt="已付租期" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="uncollected_times" align="right" prompt="未付租期" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="overdue_times" align="right" prompt="逾期(月)" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="times" align="right" prompt="总租期" width="100"/>
                    <a:column name="transaction_amount_rental" align="right" prompt="当月收到租金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="penalty" align="right" prompt="延迟履行金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="uncollected_ar" align="right" prompt="应收未收余额" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="net_invest_amount" align="right" prompt="净投资额" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="uncollected_interest" align="right" prompt="未实现利息余额" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="interest_current" align="right" prompt="本月确认利息" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="huichong" align="right" prompt="逾期3期以上收入回冲" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="principal_c_12_remain" align="right" prompt="当月开始往后12月本金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="overdue_amount_new" align="right" prompt="逾期租金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="principal_12" align="right" prompt="次12个月未到期本金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="interest_12" align="right" prompt="次12个月未到期利息" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="principal_12_remain" align="right" prompt="超过12个月到期本金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="interest_12_remain" align="right" prompt="超过12个月到期利息" renderer="Leaf.formatMoney" width="100"/>
                    <!-- <a:column name="principal_5" align="right" prompt="剩余5年内到期本金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="interest_5" align="right" prompt="剩余5年内到期利息" renderer="Leaf.formatMoney" width="100"/> -->
                    <a:column name="principal_5_over" align="right" prompt="超过5年到期本金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="interest_5_over" align="right" prompt="超过5年到期利息" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="interest_straight" align="right" prompt="直线法每期利息" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="uncollected_interest_straight" align="right" prompt="未到期直线法利息" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="interest_tax_adjust" align="right" prompt="税务调整利息" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="interest_declared" align="right" prompt="本月申报已收利息" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="interest_declared_last" align="right" prompt="截止上月累计已申报" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="interest_declared_current" align="right" prompt="截止本月累计已申报" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="collected_rental" align="right" prompt="累计已收租金" renderer="Leaf.formatMoney" width="100"/>
                    <a:column name="contract_status_n" align="left" prompt="合同状态" width="100"/>
                    <a:column name="all_file_confirm_status_n" align="left" prompt="付款状态" width="100"/>
                    <a:column name="company_id_n" align="left" prompt="公司名称" width="100"/>
                </a:columns>
            </a:grid>
        </a:screenBody>
    </a:view>
</a:screen>