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',
    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: 200
        }, {
            text: '账户名称',
            dataIndex: 'bankname',
            width: 200
        }, {
            text: '日期',
            dataIndex: 'date',
            xtype:'datecolumn',
            width: 200
        }, {
            text: '业务类型',
            dataIndex: 'kind'
        },{
            text:'收入',
            dataIndex:'inamount',
            xtype: 'numbercolumn',
            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',
            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',
            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: 'bcode'
        }, {
            text: '收付款人',
            dataIndex: 'bmanname'
        }, {
            text: '备注',
            dataIndex: 'remark'
        }]
});