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

Ext.define('saas.view.money.report.AccountBalance', {
    extend: 'saas.view.core.report.ReportPanel',
    xtype: 'monry-report-accountbalance',

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

    viewName: 'money-report-accountbalance',

    groupField: 'bankname',
    groupHeaderTpl: '账户名称: {[values.rows[0].data.bankname]}',
    listUrl: '/api/money/report/accountBalance',
    defaultCondition: null,
    reportTitle: '账户收支明细表',
    QueryWidth: 0.25,
    //筛选：账户、日期（必填）
    searchItems: [{
        xtype: 'bandinfoDbfindTrigger',
        name: 'bankname',
        fieldLabel: '账户名称',
        columnWidth: 0.25
    }, {
        xtype: 'condatefield',
        name: 'date',
        fieldLabel: '日期',
        columnWidth: 0.5
    }],

    reportColumns: [{
        text: '账户编号',
        dataIndex: 'bankcode',
        width: 150
    }, {
        text: '账户名称',
        dataIndex: 'bankname',
        width: 200
    }, {
        text: '日期',
        dataIndex: 'date',
        xtype: 'datecolumn',
        width: 110
    }, {
        text: '业务类型',
        dataIndex: 'kind',
        width: 110
    }, {
        text: '收入',
        dataIndex: 'inamount',
        exportFormat: 'Amount',
        xtype: 'numbercolumn',
        width: 110,
        renderer: function (v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join('');
            return Ext.util.Format.number(v, format);
        },
        summaryType: 'sum',
        summaryRenderer: function (v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join('');
            return Ext.util.Format.number(v, format);
        }
    }, {
        text: '支出',
        dataIndex: 'outamount',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        width: 110,
        renderer: function (v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join('');
            return Ext.util.Format.number(v, format);
        },
        summaryType: 'sum',
        summaryRenderer: function (v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join('');
            return Ext.util.Format.number(v, format);
        }
    },
    //     {
    //     text: '账户余额',
    //     dataIndex: 'thisamount',
    //     xtype: 'numbercolumn',
    //     width: 110,
    //     renderer: function (v) {
    //         var arr = (v + '.').split('.');
    //         var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
    //         var format = '0,000.' + xr.join('');
    //         return Ext.util.Format.number(v, format);
    //     }
    // },
        {
        text: '往来单位',
        dataIndex: 'bname',
        width: 150
    }, {
        text: '收付款人',
        dataIndex: 'bmanname',
        width: 110
    }, {
        text: '备注',
        dataIndex: 'remark',
        width: 250,
    }]
});