saas-platform/frontend/saas-web/app/view/money/report/TotalRecDetail.js

/**
 * 应收总账
 */
Ext.define('saas.view.money.report.TotalRecDetail', {
    extend: 'saas.view.core.report.ReportPanel',
    xtype: 'monry-report-totalrecdetail',

    controller: 'money-report-totalrecdetail',
    viewModel: 'money-report-totalrecdetail',

    viewName: 'money-report-totalrecdetail',

    groupField: null,
    listUrl: '/api/money/report/custormonthdetails',
    defaultCondition: null,
    reportTitle: '应收总账',
    QueryWidth: 0.35,
    allowPaging: false,

    searchItems: [{
        xtype: 'customerDbfindTrigger',
        name: 'cm_custname',
        emptyText: '请输入客户名称',
        columnWidth: 0.25
    }, {
        xtype: 'conmonthfield',
        fieldLabel: '期间',
        name: 'cm_yearmonth',
        columnWidth: 0.4
    }],

    reportModel: 'saas.model.report.TotalRecDetail',

    reportColumns: [{
        text: '期间',
        dataIndex: 'cm_yearmonth',
        width: 80,
    }, {
        text: '客户名称',
        dataIndex: 'cm_custname',
        width: 200,
    }, {
        text: '币别',
        dataIndex: 'cm_currency',
        align:'center',
        width: 65,
    }, {
        text: '汇率',
        dataIndex: 'cm_rate',
        align:'center',
        width: 65,
    }, {
        text: '期初',
        columns: [{
            text: '预收(元)',
            xtype: 'numbercolumn',
            exportFormat: 'Amount',
            dataIndex: 'cm_beginpreamount',
            width: 120,
            renderer: function(v, m, r) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }, {
            text: '应收(元)',
            xtype: 'numbercolumn',
            exportFormat: 'Amount',
            dataIndex: 'cm_beginamount',
            width: 120,
            renderer: function(v, m, r) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }]
    }, {
        text: '本期',
        columns: [{
            text: '预收(元)',
            xtype: 'numbercolumn',
            exportFormat: 'Amount',
            dataIndex: 'cm_nowpreamount',
            width: 120,
            renderer: function(v, m, r) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }, {
            text: '应收(元)',
            xtype: 'numbercolumn',
            exportFormat: 'Amount',
            dataIndex: 'cm_nowamount',
            width: 120,
            renderer: function(v, m, r) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }, {
            text: '核销(元)',
            xtype: 'numbercolumn',
            exportFormat: 'Amount',
            dataIndex: 'cm_nowpayamount',
            width: 120,
            renderer: function(v, m, r) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            } 
        }]
    }, {
        text: '期末',
        columns: [{
            text: '预收(元)',
            dataIndex: 'cm_endpreamount',
            exportFormat: 'Amount',
            xtype: 'numbercolumn',
            width: 120,
            renderer: function(v, m, r) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            },
            summaryType: 'sum',
            summaryRenderer: function(v, d, f, m) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }, {
            text: '应收(元)',
            dataIndex: 'cm_endamount',
            exportFormat: 'Amount',
            xtype: 'numbercolumn',
            width: 120,
            renderer: function(v, m, r) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            },
            summaryType: 'sum',
            summaryRenderer: function(v, d, f, m) {
                return saas.util.BaseUtil.numberFormat(v, 2, true);
            }
        }]
    }, {
        text: '应收余额(元)',
        dataIndex: 'cm_endamount-cm_endpreamount',
        exportFormat: 'Amount',
        xtype: 'numbercolumn',
        width: 120,
        renderer: function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    }, {
        hidden:true,
        text: '应收余额(本位币)(元)',
        dataIndex: 'cm_amount_cr',
        exportFormat: 'Amount',
        xtype: 'numbercolumn',
        width: 160,
        renderer: function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryType: 'sum',
        summaryLabel: '应收余额(本位币)',
        summaryRenderer: function(v, d, f, m) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    }, {
        dataIndex: '',
        flex: 1
    }]
});