contract_receipt_detail_print.lsc 9.19 KB
Newer Older
1 2 3 4
<?xml version="1.0" encoding="UTF-8"?>
<a:service xmlns:a="http://www.leaf-framework.org/application" xmlns:s="leaf.plugin.script" xmlns:dr="leaf.plugin.excelreport"  trace="true">
    <a:init-procedure>
        <a:model-query defaultWhereClause="contract_id=${/parameter/@contract_id}" fetchAll="true" model="cont.CON1300.get_contract_print_info" rootPath="/model/head_info"/>
stone's avatar
stone committed
5
        <a:model-query  fetchAll="true" model="cont.CON1300.get_contract_print_grid_info" rootPath="/model/grid_data"/>
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
        <s:server-script><![CDATA[
            function getdate() {
            var now = new Date()
            y = now.getFullYear()
            m = now.getMonth() + 1
            d = now.getDate()
            m = m < 10 ? "0" + m : m
            d = d < 10 ? "0" + d : d
            return y + "" + m + "" + d
            }

            $ctx.parameter.file_name   = $ctx.parameter.file_name+getdate()+'.xlsx';
            ]]></s:server-script>
        <dr:excel-report enableTask="false" fileName="${/parameter/@file_name}">
            <styles>
                <dr:cell-style name="title" align="ALIGN_CENTER">
stone's avatar
stone committed
22
                    <dr:font fontName="黑体" height="12" italic="false"/>
23 24
                </dr:cell-style>
                <dr:cell-style name="left" align="ALIGN_LEFT">
stone's avatar
stone committed
25
                    <dr:font fontName="黑体" height="10" italic="false"/>
26
                </dr:cell-style>
stone's avatar
stone committed
27 28
                <dr:cell-style name="right" align="ALIGN_RIGHT">
                    <dr:font fontName="黑体" height="10" italic="false"/>
29
                </dr:cell-style>
stone's avatar
stone committed
30 31 32 33 34 35
                <dr:cell-style name="grid_title"  align="ALIGN_CENTER" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderTop="BORDER_THIN" borderRight="BORDER_THIN">
                    <dr:font fontName="黑体" height="9" italic="false"/>

                </dr:cell-style>
                <dr:cell-style name="grid_cell" align="ALIGN_CENTER" borderbottom="BORDER_THIN" borderleft="BORDER_THIN" borderTop="BORDER_THIN" borderRight="BORDER_THIN">
                    <dr:font fontName="黑体" height="9" italic="false"/>
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56

                </dr:cell-style>
                <dr:cell-style name="header" align="ALIGN_CENTER">
                    <dr:font bold="false" fontName="宋体" height="12"/>
                </dr:cell-style>
                <dr:cell-style name="foot">
                    <dr:font bold="false" fontName="宋体" height="12"/>
                </dr:cell-style>
                <dr:cell-style name="footNumber" dataFormat="#,##0.000">
                    <dr:font bold="false" fontName="宋体" height="12"/>
                </dr:cell-style>
                <dr:cell-style name="dateFormat" dataFormat="YYYY-MM-DD">
                    <dr:font bold="false" fontName="宋体" height="12"/>
                </dr:cell-style>
                <dr:cell-style name="group">
                    <dr:font bold="false" fontName="宋体" height="12"/>
                </dr:cell-style>
            </styles>
            <sheets>
                <dr:sheet name="第一页" autoSizeColumns="0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20" displayGridlines="true">
                    <dr:static-content>
stone's avatar
stone committed
57 58
                        <dr:cell-data cell="A"    row="1" stylename="title" type="content" value="合同应收明细表"/>
                        <dr:cell-data cell="A"    row="3" stylename="right" type="content" value="代理店:"/>
59
                        <dr:cell-data cell="B"   row="3" stylename="left" type="content" value="${/model/head_info/record/@bp_name}"/>
stone's avatar
stone committed
60 61 62
                        <dr:cell-data cell="J"   row="3" stylename="right" type="content" value="业务伙伴号:"/>
                        <dr:cell-data cell="k"   row="3" stylename="left" type="content" value="${/model/head_info/record/@client_bp_code}"/>
                        <dr:cell-data cell="A"   row="4" stylename="right" type="content" value="合同编号:"/>
63
                        <dr:cell-data cell="B"   row="4" stylename="left" type="content" value="${/model/head_info/record/@contract_number}"/>
stone's avatar
stone committed
64 65
                        <dr:cell-data cell="J"   row="4" stylename="right" type="content" value="客户名称:"/>
                        <dr:cell-data cell="k"   row="4" stylename="left" type="content" value="${/model/head_info/record/@client_bp_name}"/>
66

stone's avatar
stone committed
67
                        <dr:cell-data cell="A"   row="5" stylename="right" type="content" value="机型:"/>
68
                        <dr:cell-data cell="B"   row="5" stylename="left" type="content" value="${/model/head_info/record/@pattern}"/>
stone's avatar
stone committed
69 70
                        <dr:cell-data cell="J"   row="5" stylename="right" type="content" value="机号:"/>
                        <dr:cell-data cell="k"   row="5" stylename="left" type="content" value="${/model/head_info/record/@machine_number}"/>
71

stone's avatar
stone committed
72
                        <dr:cell-data cell="A"   row="6" stylename="right" type="content" value="合同签订日:"/>
73
                        <dr:cell-data cell="B"   row="6" stylename="left" type="content" value="${/model/head_info/record/@inception_of_lease}"/>
stone's avatar
stone committed
74 75
                        <dr:cell-data cell="J"   row="6" stylename="right" type="content" value="租赁开始日:"/>
                        <dr:cell-data cell="k"   row="6" stylename="left" type="content" value="${/model/head_info/record/@lease_start_date}"/>
76

stone's avatar
stone committed
77 78 79 80
                        <dr:cell-data cell="A"   row="7" stylename="right" type="content" value="利率:"/>
                        <dr:cell-data cell="B"   row="7" stylename="left" type="content" value="${/model/head_info/record/@int_rate_display}"/>
                        <dr:cell-data cell="J"   row="7" stylename="right" type="content" value="租赁期间:"/>
                        <dr:cell-data cell="k"   row="7" stylename="left" type="content" value="${/model/head_info/record/@lease_times}"/>
81 82 83
                    </dr:static-content>
                    <dr:dynamic-content cell="A" datamodel="/model/grid_data" row="8">
                        <dr:columns>
stone's avatar
stone committed
84 85 86
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="439" field="times" title="期数"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="440" field="due_date" title="预定收款日"  type="content" groupDesc="计数" />
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="441" field="due_amount" title="预定收款金额"  type="content"/>
stone's avatar
stone committed
87 88 89
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="441" field="vat_due_amount" title="租金增值税"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="441" field="principal" title="本金"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="441" field="vat_principal" title="本金增值税"  type="content"/>
stone's avatar
stone committed
90 91 92 93 94 95 96 97 98 99 100 101
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="448" field="total_interest" title="利息合计"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="442" field="up_interest" title="利息上段"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="443" field="down_interest" title="利息下段"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="444" field="total_net_interest" title="利息(不含税)合计"  type="content" />
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="445" field="up_net_interest" title="利息(不含税)上段"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="446" field="down_net_interest" title="利息(不含税)下段"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="447" field="total_vat_interest" title="利息(增值税)合计"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="447" field="up_vat_interest" title="利息(增值税)上段"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="447" field="down_vat_interest" title="利息(增值税)下段"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="447" field="total_weight_factor" title="本期天数合计"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="447" field="up_weight_factor" title="本期天数上段"  type="content"/>
                            <dr:table-column cellStyle="grid_cell" titleStyle="grid_title" column_id="447" field="down_weight_factor" title="本期天数下段"  type="content"/>
102 103 104 105 106 107 108
                        </dr:columns>
                    </dr:dynamic-content>
                </dr:sheet>
            </sheets>
        </dr:excel-report>
    </a:init-procedure>
</a:service>