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',
    // listUrl: 'http://192.168.253.139:8560/api/money/report/custormonthdetails',
    defaultCondition: null,
    reportTitle: '应收总账',
    QueryWidth: 0.35,
    allowPaging: false,

    searchItems: [{
        xtype: 'textfield',
        name: 'cm_custcode',
        emptyText: '客户编号/名称',
        columnWidth: 0.25,
        getCondition: function (v) {
            return "(upper(cm_custcode) like '%" + v.toUpperCase() + "%' or upper(cm_custname) like '%" + v.toUpperCase() + "%')";
        },
    }, {
        xtype: 'conmonthfield',
        fieldLabel: '期间',
        name: 'cm_yearmonth',
        columnWidth: 0.4
    }],

    reportColumns: [
    {
        text: '期间',
        dataIndex: 'cm_yearmonth',
        width: 110
    },{
        text: '客户编号',
        dataIndex: 'cm_custcode',
        width: 190
    }, {
        text: '客户名称',
        dataIndex: 'cm_custname',
        width: 210,
    },{
        text: '期初预收',
        dataIndex: 'cm_beginpreamount',
        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);
        }
    },{
        text: '期初应收',
        dataIndex: 'cm_beginamount',
        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);
        }
    }, {
        text: '本期应收',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'cm_nowamount',
        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: '本期核销',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'cm_nowpayamount',
        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: '预收余额',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'cm_endpreamount',
        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: 'cm_endamount',
        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);
        }
    }, {
        flex: 1
    }]
});