execute_calendar_query.lview 7.6 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
<?xml version="1.0" encoding="UTF-8"?>

<a:screen xmlns:a="http://www.leaf-framework.org/application" trace="true">
    <a:view>
        <script type="text/javascript"><![CDATA[
        function csh_deposit_query() {
            $('execute_calendar_grid_ds').query();
        }

        function csh_deposit_reset(){
            $('execute_calendar_form_ds').reset();
        }

        function csh_deposit_export() {
            $('source_to_grid')._export();
        }

        function summaryRenderer(datas, name) {
            var sum = 0;
            var sum1 = 0;
            var sum2 = 0;
            var sum3 = 0;
            if (name == "calc_date") {
                return '<font color="red">合计:</font>';
            }
            if (name == "due_amount") {
                for (var i = 0; i < datas.length; i++) {
                    var record = datas[i];
                    var payment_amount_vl = record.get("due_amount");
                    var payment_amount = parseFloat(payment_amount_vl);
                    if (!isNaN(payment_amount)) {
                        sum += payment_amount;
                    }
                }
                return '<font color="red">' + Leaf.formatNumber(sum, 2) + '</font>';
            }
            if (name == "principal") {
                for (var i = 0; i < datas.length; i++) {
                    var record = datas[i];
                    var payment_amount_vl = record.get("principal");
                    var payment_amount = parseFloat(payment_amount_vl);
                    if (!isNaN(payment_amount)) {
                        sum += payment_amount;
                    }
                }
                return '<font color="red">' + Leaf.formatNumber(sum, 2) + '</font>';
            }
            if (name == "interest") {
                for (var j = 0; j < datas.length; j++) {
                    var record1 = datas[j];
                    var payment_amount_vl1 = record1.get("interest");
                    var payment_amount1 = parseFloat(payment_amount_vl1);
                    if (!isNaN(payment_amount1)) {
                        sum1 += payment_amount1;
                    }
                }
                return '<font color="red">' + Leaf.formatNumber(sum1, 2) + '</font>';
            }
        }



        function aut_authority_list_validate_query(ds, qpara) {
            qpara['authority_flag'] = 'Y';
            qpara['contract_ref_content_flag'] = 'Y';
            qpara['trx_category'] = 'CONTRACT';
            qpara['trx_id'] = 't1.contract_id';

        }

        ]]></script>

        <a:dataSets>
            <a:dataSet id="execute_calendar_form_ds"  >
                <a:fields>
                    <a:field name="contract_number" required="true" lovGridHeight="400" lovHeight="500" lovService="cont.CON1210.execute_calendar_form_query" lovWidth="500" title="合同编号" prompt="合同编号">
                        <a:mapping>
                            <a:map from="contract_number" to="contract_number"/>
                            <a:map from="bp_name" to="bp_name"/>
                            <a:map from="finance_amount" to="finance_amount"/>
                            <a:map from="lease_execution_date" to="lease_execution_date"/>
                            <a:map from="business_type" to="business_type"/>
                            <a:map from="deposit" to="deposit"/>
                            <a:map from="contract_id" to="contract_id"/>
                            <a:map from="amount_rent" to="amount_rent"/>
                            <a:map from="lease_channel_desc" to="lease_channel_desc"/>
                        </a:mapping>
                    </a:field>
                    <a:field name="bp_name"/>
                    <a:field name="finance_amount"/>
                    <a:field name="lease_execution_date"/>
                    <a:field name="business_type"/>
                    <a:field name="deposit"/>
                    <a:field name="contract_id"/>
                    <a:field name="amount_rent"/>
                    <a:field name="lease_channel_desc"/>
                </a:fields>
            </a:dataSet>

            <a:dataSet id="execute_calendar_grid_ds" fetchAll="true" autoQuery="false" model="cont.CON1210.execute_calendar_query" queryDataSet="execute_calendar_form_ds" selectionModel="single">
           <a:events>
               <a:event  name="query" handler="aut_authority_list_validate_query"/>
           </a:events>
            </a:dataSet>
        </a:dataSets>

        <a:screenBody>
            <a:screenTopToolbar>
                <a:screenTitle/>
                <a:gridButton click="csh_deposit_query" text="查询"/>
                <a:gridButton click="csh_deposit_reset" text="重置"/>
                <a:gridButton click="csh_deposit_export" text="导出"/>
            </a:screenTopToolbar>
            <a:form column="4" marginWidth="100" title="查询条件">
                <a:lov name="contract_number" bindTarget="execute_calendar_form_ds" prompt="合同编号" />
                <a:textField name="bp_name" bindTarget="execute_calendar_form_ds" prompt="主承租人" readOnly="true"/>
                <a:numberField name="finance_amount" bindTarget="execute_calendar_form_ds" prompt="融资额" readOnly="true" renderer="Leaf.formatMoney"/>
                <a:datePicker name="lease_execution_date" bindTarget="execute_calendar_form_ds" prompt="执行日期" readOnly="true"/>
                <a:textField name="business_type" bindTarget="execute_calendar_form_ds" prompt="业务类型" readOnly="true"/>
                <a:numberField name="deposit" bindTarget="execute_calendar_form_ds" prompt="保证金" readOnly="true" renderer="Leaf.formatMoney"/>
                <a:numberField name="amount_rent" bindTarget="execute_calendar_form_ds" prompt="租金总额" readOnly="true" renderer="Leaf.formatMoney"/>
                <a:textField name="lease_channel_desc" bindTarget="execute_calendar_form_ds" prompt="商业模式" readOnly="true"/>
            </a:form>
            <a:grid id="source_to_grid" bindTarget="execute_calendar_grid_ds" navBar="true" height="400" marginWidth="100">
                <a:columns>
                    <a:column name="times" align="center" prompt="期数" width="150" />
                    <a:column name="contract_number" prompt="合同编号" width="120"/>
                    <a:column name="bp_name"  prompt="主承租人" align="center" width="120"/>
                    <!--<a:column name="lease_channel" prompt="商业模式" group="true" />
                    <a:column name="total_rental" prompt="租金总额" group="true" renderer="Leaf.formatMoney"/>
                    <a:column name="cf_direction"  prompt="收/付" width="100" />-->
                    <a:column name="cf_item_n" align="center" prompt="现金流项目" width="180" />
                    <a:column name="calc_date" align="center" prompt="应收日" width="180" renderer="Leaf.formatDate" footerRenderer="summaryRenderer"/>
                    <a:column name="due_amount" align="center" prompt="应收/付金" width="180" renderer="Leaf.formatMoney" footerRenderer="summaryRenderer"/>
                    <a:column name="principal" align="center" prompt="应收本金" width="180" renderer="Leaf.formatMoney" footerRenderer="summaryRenderer"/>
                    <a:column name="interest" align="center" prompt="应收利息" width="180" renderer="Leaf.formatMoney" footerRenderer="summaryRenderer"/>
                    <a:column name="outstanding_prin_tax_incld" align="center" prompt="当期剩余本金" width="180" renderer="Leaf.formatMoney"/>
                </a:columns>
            </a:grid>
        </a:screenBody>
    </a:view>

</a:screen>