con_maturity_query.lview 10.8 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
<?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 model="basic.get_sys_default_time" rootPath="sys_default_time"/>
    </a:init-procedure>
    <a:view>
        <script type="text/javascript"><![CDATA[
        function month_finance_query() {
            $('month_finance_grid_ds').query();
        }

        function month_finance_reset(){
            $('month_finance_form_ds').reset();
        }

        function month_finance_export() {
            $('source_to_grid')._export(null,'到期款明细');
        }

        ]]></script>

        <a:dataSets>
            <a:dataSet id="month_finance_form_ds">
                <a:fields>
                    <a:field name="select_year" defaultValue="${/model/sys_default_time/record/@now_year}"/>
                    <a:field name="__async__"  defaultValue="Y" prompt="异步导出"/>
                </a:fields>
            </a:dataSet>
            <a:dataSet id="month_finance_grid_ds" autoQuery="false"
                       model="cont.CON1280.con_maturity_query"
                       queryDataSet="month_finance_form_ds" selectable="true" selectionModel="single">
            </a:dataSet>
        </a:dataSets>

        <a:screenBody>
            <a:screenTopToolbar>
                <a:screenTitle/>
                <a:gridButton click="month_finance_query" text="查询"/>
                <a:gridButton click="month_finance_reset" text="重置"/>
                <a:gridButton click="month_finance_export" text="导出"/>
            </a:screenTopToolbar>
            <a:form column="4" marginWidth="100" title="查询条件">
                <a:textField name="contract_number" bindTarget="month_finance_form_ds" prompt="合同编号" />
                <a:textField name="bp_agent_name" bindTarget="month_finance_form_ds" prompt="代理商名称" />
                <a:datePicker name="lease_execution_date_from" bindTarget="month_finance_form_ds" prompt="执行日期从"  />
                <a:datePicker name="lease_execution_date_to" bindTarget="month_finance_form_ds" prompt="执行日期到"  />
                <a:numberField allowDecimals="false" name="select_year" bindTarget="month_finance_form_ds" prompt="查询年度"  />
            </a:form>
            <a:grid id="source_to_grid" bindTarget="month_finance_grid_ds" navBar="true" height="400" marginWidth="100">
                <a:columns>
                    <a:column name="contract_number" prompt="合同编号" width="120"/>
                    <a:column name="bp_code" prompt="客户编号" width="120"/>
                    <a:column name="bp_name" prompt="客户名称" width="120"/>
                    <a:column name="bp_agent_code"  prompt="代理商编号" width="100" />
                    <a:column name="bp_agent_name" prompt="代理商名称" />
                    <a:column name="division_n" prompt="产品线" />
                    <a:column name="lease_channel_n" prompt="商业模式" width="80" renderer="Leaf.formatDate"/>
                    <a:column name="business_type_n"  prompt="租赁类型" width="100" renderer="Leaf.formatDate"/>
                    <a:column name="pattern"  prompt="机型" width="100" />
                    <a:column name="machine_number"  prompt="机号" width="100" />
                    <a:column name="equipment_number"  prompt="装备号" width="100" />
                    <a:column prompt="01月">
                        <a:column name="january_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="january_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="january_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="02月">
                        <a:column name="february_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="february_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="february_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="03月">
                        <a:column name="march_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="march_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="march_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="04月">
                        <a:column name="april_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="april_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="april_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="05月">
                        <a:column name="may_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="may_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="may_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="06月">
                        <a:column name="june_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="june_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="june_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="07月">
                        <a:column name="july_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="july_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="july_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="08月">
                        <a:column name="august_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="august_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="august_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="09月">
                        <a:column name="september_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="september_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="september_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="10月">
                        <a:column name="october_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="october_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="october_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="11月">
                        <a:column name="november_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="november_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="november_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="12月">
                        <a:column name="december_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="december_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="december_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="查询年度第二年">
                        <a:column name="second_years_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="second_years_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="second_years_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="查询年度第三年">
                        <a:column name="third_years_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="third_years_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="third_years_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="查询年度第四年">
                        <a:column name="fourth_years_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="fourth_years_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="fourth_years_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="查询年度第五年">
                        <a:column name="fifth_years_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="fifth_years_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="fifth_years_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                    <a:column prompt="查询年度五年以后">
                        <a:column name="after_fifth_years_principal"  prompt="本金" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="after_fifth_years_interest"  prompt="利息" width="100" renderer="Leaf.formatMoney"/>
                        <a:column name="after_fifth_years_due_amount"  prompt="合计" width="100" renderer="Leaf.formatMoney"/>
                    </a:column>
                </a:columns>
            </a:grid>
        </a:screenBody>
    </a:view>
</a:screen>