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

/**
 * 毛利润分析表
 */
Ext.define('saas.view.money.report.ProfitDetail', {
    extend: 'saas.view.core.report.ReportPanel',
    xtype: 'monry-report-profitdetail',

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

    viewName: 'money-report-profitdetail',

    groupField: null,
    listUrl: '/api/money/report/profitdetails',
    defaultCondition: null,
    reportTitle: '毛利润分析表',
    QueryWidth: 0.2,
    searchItems: [{
        xtype: 'customerDbfindTrigger',
        name: 'pi_custname',
        emptyText: '客户',
        columnWidth: 0.15,
        dbfinds:[
            {
                from:'cu_name',to:'pi_custname'
            }]
    }, {
        xtype : "remotecombo", 
        storeUrl:'/api/document/customerkind/getCombo',
        name : "cu_type", 
        emptyText : "客户类型", 
        columnWidth: 0.15,
        hiddenBtn:true
    }, {
        xtype: 'condatefield',
        name: 'pi_date',
        fieldLabel: '日期',
        columnWidth: 0.5
    }],

    reportColumns: [{
        text: '客户',
        dataIndex: 'pi_custname',
        width: 200,
    },{
        text: '客户类型',
        dataIndex: 'cu_type',
        width: 200,
    }, {
        text: '业务员',
        dataIndex: 'cu_sellername',
        width: 200,
    }, {
        text: '销售总额',
        dataIndex: 'saamount',
        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: 'netamount',
        exportFormat: 'Amount',
        xtype: 'numbercolumn',
        width: 150,
        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: 'costamount',
        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: 'profit',
        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: 'profitpresent',
        width: 130,
        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 * 100, format);
        },
    },{
        flex: 1
    }]
});