cus_reports.lview 7.78 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
<?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:model-query defaultWhereClause="t1.function_code = &apos;CUS310&apos;" model="cus.CUS100.cus_default_function_name" rootPath="default_function_name"/>
    </a:init-procedure>
    <a:view>
        <a:link id="con_contract_update_link_id" url="${/request/@context_path}/modules/cont/CON501N/con_contract_modify.lview"/>
        <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[
            var period_name;
            
            function cus310_con_contract_return() {
                history.go(-1);
            }
            
            function cus310_con_contract_query() {
                var record = $('cus310_contract_query_ds').getCurrentRecord();
                var year = record.get('period_date').getFullYear().toString();
                var month = record.get('period_date').getMonth().toString();
                if (month.length == 1) {
                    month = '0' + month;
                }
                period_name = year + '-' + month;
            
                $('cus310_contract_result_ds').query();
            }
            
            function cus310_con_contract_reset() {
                $('cus310_contract_query_ds').reset();
            }
            
            function cus310_con_contract_export() {
            
                //  $('con501_con_contract_grid_ds')._export('xls','${/model/default_function_name/record/@function_name}(${/model/default_value/record/@current_month})');
                $('con501_con_contract_grid_ds')._export('xls', '${/model/default_function_name/record/@function_name}(' + period_name + ')');
            
            }
        ]]></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=cus310"/> -->
        <a:dataSets>
            <a:dataSet id="cus310_contract_query_ds">
                <a:fields>
                    <a:field name="period_date" required="true"/>
                    <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:fields>
            </a:dataSet>
            <a:dataSet id="cus310_contract_result_ds" autoPageSize="true" model="cus.CUS310.cus_con_finance_income_lv" queryDataSet="cus310_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="cus310_con_contract_return" text="HLS.RETURN"/>
                <a:gridButton click="cus310_con_contract_query" text="HLS.QUERY"/>
                <a:gridButton click="cus310_con_contract_reset" text="HLS.RESET"/>
                <a:gridButton click="cus310_con_contract_export" text="导出"/>
            </a:screenTopToolbar>
            <a:form column="4" labelSeparator=" " labelWidth="100" marginWidth="30" title="CON301.CONTRACT_QUERY">
                <a:datePicker name="period_date" bindTarget="cus310_contract_query_ds" prompt="截止日期"/>
                <a:lov name="bp_id_tenant_c" bindTarget="cus310_contract_query_ds" prompt="客户编码">
                    <!--  <a:events>
                        <a:event name="focus" handler="function(object){on_std_focus(object,&apos;BP&apos;)}"/>
                    </a:events> --><![CDATA[
                    
                   
                ]]></a:lov>
                <a:textField name="bp_id_tenant_n" bindTarget="cus310_contract_query_ds" prompt="客户名称"/>
            </a:form>
            <a:grid id="con501_con_contract_grid_ds" bindTarget="cus310_contract_result_ds" marginHeight="200" marginWidth="30" navBar="true">
                <a:columns>
                    <a:column name="bp_id_tenant_c" prompt="客户编码" width="100"/>
                    <a:column name="bp_id_tenant_n" prompt="客户名称" width="150"/>
                    <a:column prompt="截止至上期金额累计">
                        <a:column name="total_rental" align="right" prompt="收入确认" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="penalty" align="right" prompt="滞纳金收入" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="residual_value" align="right" prompt="留购价款" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="lease_charge" 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="overdue_interest" align="right" prompt="逾期利息红冲" renderer="Leaf.formatMoney" width="100"/>
                    </a:column>
                    <a:column prompt="本月发生">
                        <a:column name="total_rental_c" align="right" prompt="收入确认" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="penalty_c" align="right" prompt="滞纳金收入" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="residual_value_c" align="right" prompt="留购价款" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="lease_charge_c" align="right" prompt="手续费" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="lease_mgt_fee_c" align="right" prompt="管理费" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="overdue_interest_c" align="right" prompt="逾期利息红冲" renderer="Leaf.formatMoney" width="100"/>
                    </a:column>
                    <a:column prompt="截止至本月累计">
                        <a:column name="total_rental_b" align="right" prompt="收入确认" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="penalty_b" align="right" prompt="滞纳金收入" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="residual_value_b" align="right" prompt="留购价款" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="lease_charge_b" align="right" prompt="手续费" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="lease_mgt_fee_b" align="right" prompt="管理费" renderer="Leaf.formatMoney" width="100"/>
                        <a:column name="overdue_interest_b" align="right" prompt="逾期利息红冲" renderer="Leaf.formatMoney" width="100"/>
                    </a:column>
                </a:columns>
            </a:grid>
        </a:screenBody>
    </a:view>
</a:screen>