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

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

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

    viewName: 'sale-report-saleprofit',

    groupField: null,
    listUrl: '/api/sale/report/saleProfit',
    defaultCondition: null,
    reportTitle: '销售毛利润表',
//筛选：客户、物料、时间	
    QueryWidth:0.2, 	
    searchItems: [{
        xtype: 'customerDbfindTrigger',
        name: 'sa_custname',
        fieldLabel: '客户',
        columnWidth: 0.2
    }, {
        xtype: 'productDbfindTrigger',
        name: 'pr_detail',
        fieldLabel: '物料',
        columnWidth: 0.2
    }, {
        xtype: 'condatefield',
        name: 'pi_date',
        fieldLabel: '时间',
        columnWidth: 0.4
    }],

    reportColumns: [
    {
        text: 'id',
        dataIndex: 'sa_id',
        hidden: true
    }, {
        text: '客户编号',
        dataIndex: 'sa_custcode',
        width: 150
    }, {
        text: '客户名称',
        dataIndex: 'sa_custname',
        width: 200
    }, {
        text: '业务员',
        dataIndex: 'sa_seller',
        width: 110
    }, {
        text: '单据日期',
        xtype: 'datecolumn',
        dataIndex: 'pi_date',
        width: 110
    }, {
        text: '单据编号',
        dataIndex: 'pd_inoutno',
        width: 150
    }, {
        text: '单据类型',
        dataIndex: 'pd_piclass',
        width: 110
    }, {
        text: '物料类别',
        dataIndex: 'pr_kind',
        width: 110
    }, {
        text: '物料编号',
        width: 150,
        dataIndex: 'pr_code'
    }, {
        text: '品牌',
        dataIndex: 'pr_brand',
        width: 200
    }, {
        text: '名称',
        dataIndex: 'pr_detail',
        width: 200
    }, {
        text: '型号',
        dataIndex: 'pr_orispeccode',
        width: 200
    }, {
        text: '规格',
        dataIndex: 'pr_spec',
        width: 150
    }, {
        text: '数量',
        dataIndex: 'pd_outqty',
        exportFormat: 'Quantity',
        xtype: 'numbercolumn',
        width: 110,
        renderer : function(v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 3 ? 3 : arr[1].length)).fill('0');
            var format = '0.' + xr.join('');
            return Ext.util.Format.number(v, format);
        }
    }, {
        text: '单位',
        dataIndex: 'pr_unit',
        width: 80
    }, {
        text: '含税单价(元)',
        dataIndex: 'pd_sendprice',
        exportFormat: 'Price',
        xtype: 'numbercolumn',
        width: 150,
        renderer: function(v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 4 ? 4 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join('');
            return Ext.util.Format.number(v, format);
        }
    }, {
        text: '税率%',
        dataIndex: 'pd_taxrate',
        exportFormat: 'Integer',
        xtype: 'numbercolumn',
        width: 90,
        renderer: function(v) {
            return Ext.util.Format.number(v, '0');
        }
    }, {
        text: '含税金额(元)',
        dataIndex: 'pd_ordertotal',
        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: '不含税单价(元)',
        exportFormat: 'Price',
        dataIndex: 'pd_netprice',
        xtype: 'numbercolumn',
        width:150,
        renderer : function(v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 4 ? 4 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join('');
            return Ext.util.Format.number(v, format);
        }
    }, {
        text: '成本单价(元)',
        dataIndex: 'pw_costprice',
        exportFormat: 'Price',
        xtype: 'numbercolumn',
        width:140,
        renderer : function(v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length > 4 ? 4 : arr[1].length)).fill('0');
            var format = '0,000.' + xr.join('');
            return Ext.util.Format.number(v, format);
        }
    }, {
        text: '成本金额(元)',
        dataIndex: 'pd_total',
        exportFormat: 'Amount',
        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: 'pd_profit',
        exportFormat: 'Amount',
        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: 'pd_profitpresent',
        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, format);
        }
    }, {
        text : "备注", 
        dataIndex : "pd_remark",
        width : 250 
    }]

});