saas-platform/frontend/saas-web/app/view/sale/report/SaleRec.js

Ext.define('saas.view.sale.report.SaleRec', {
    extend: 'saas.view.core.report.ReportPanel',
    xtype: 'sale-report-salerec',

    controller: 'sale-report-salerec',
    viewModel: 'sale-report-salerec',

    viewName: 'sale-report-salerec',

    groupField: 'rb_custname',
    listUrl: '/api/sale/report/saleRec',
    defaultCondition: null,
    reportTitle: '销售收款报表',
    QueryWidth:0.25,
    searchItems: [{//筛选：客户、日期	
        xtype: 'customerDbfindTrigger',
        name: 'rb_custname',
        fieldLabel: '客户',
        columnWidth: 0.25
    }, {
        xtype: 'condatefield',
        name: 'rb_date',
        fieldLabel: '日期',
        columnWidth: 0.5
    }],

    reportColumns: [{
        text: 'id',
        dataIndex: 'id',
        hidden: true
    }, {
        text: '收款单号',
        dataIndex: 'rb_code',
        summaryType: 'count',
        width: 150
    }, {
        text: '客户编号',
        dataIndex: 'rb_custcode',
        width: 150
    }, {
        text: '客户名称',
        dataIndex: 'rb_custname',
        width: 200
    }, {
        text: '业务员',
        dataIndex: 'rb_manname'
    }, {
        text: '日期',
        dataIndex: 'rb_date',
        xtype: 'datecolumn'
    }, {
        text: '来源单号',
        dataIndex: 'rbd_slcode',
        width: 150
    }, {
        text: '类型',
        dataIndex: 'rbd_slkind'
    }, {
        text: '销售金额',
        xtype: 'numbercolumn',
        dataIndex: 'rbd_amount',
        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: '本次收款',
        xtype: 'numbercolumn',
        dataIndex: 'rbd_nowbalance',
        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: '应收余额',
        xtype: 'numbercolumn',
        dataIndex: 'rb_rbdamount',
        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: 'rb_backrate',
        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.' + xr.join();
            return Ext.util.Format.number(v*100, format);
        }
    }, {
        text: '备注',
        dataIndex: 'rb_remark',
        width: 250
    }]

});