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

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

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

    viewName: 'sale-report-sale',

    groupField: null,
    listUrl: '/api/sale/sale/list',
    defaultCondition: null,
    reportTitle: '销售明细报表',
    QueryWidth:0.1,
    searchItems: [
    {
        xtype: 'dbfindtrigger',
        name: 'sa_custname',
        fieldLabel: '客户名称',
        columnWidth: 0.2
    }, {
        xtype: 'condatefield',
        name: 'sa_date',
        fieldLabel: '单据日期',
        columnWidth: 0.5
    }, {
        xtype: 'multicombo',
        name: 'sa_sendstatuscode',
        fieldLabel: '业务状态',
        allowBlank: true,
        columnWidth: 0.2,
        datas: [
            ["TURNOUT", "已出库"],
            ["UNTURNOUT", "未出库"],
            ["PARTOUT", "部分出库"],
            ["CLOSE", "已关闭"]
        ]
    }],

    reportColumns: [
    {
        text: 'id',
        dataIndex: 'sa_id',
        hidden: true
    }, {
        text: '销售单号',
        dataIndex: 'sa_code',
        width: 200
    }, {
        text: '客户编号',
        dataIndex: 'sa_custcode',
        width: 200
    }, {
        text: '客户名称',
        dataIndex: 'sa_custname',
        width: 200
    }, {
        text: '业务状态',
        dataIndex: 'sa_status'
    }, {
        text: '业务员编号',
        dataIndex: 'sa_sellercode',
        hidden:true
    }, {
        text: '业务员',
        dataIndex: 'sa_seller'
    }, {
        text: '单据日期',
        xtype: 'datecolumn',
        dataIndex: 'sa_date'
    }, {
        text: '序号',
        dataIndex: 'sd_detno',
        xtype: 'numbercolumn'
    }, {
        text: '物料编号',
        dataIndex: 'sd_prodcode',
        width: 200
    }, {
        text: '物料名称',
        dataIndex: 'pr_detail',
        width: 200, 
        renderer: function (v, m, r) {
            return r.data["productDTO"]?r.data["productDTO"][m.column.dataIndex]:v;
        }
    }, {
        text: '物料规格',
        dataIndex: 'pr_spec', 
        renderer: function (v, m, r) {
            return r.data["productDTO"]?r.data["productDTO"][m.column.dataIndex]:v;
        }
    }, {
        text: '品牌',
        dataIndex: 'pr_brand', 
        renderer: function (v, m, r) {
            return r.data["productDTO"]?r.data["productDTO"][m.column.dataIndex]:v;
        }
    }, {
        text: '单位',
        dataIndex: 'pr_unit', 
        renderer: function (v, m, r) {
            return r.data["productDTO"]?r.data["productDTO"][m.column.dataIndex]:v;
        }
    }, {//∑数量
        text: '数量',
        dataIndex: 'sd_qty',
        xtype: 'numbercolumn',
        renderer : function(v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length)).fill('0');
            var format = '0.' + 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)).fill('0');
            var format = '0.' + xr.join();
            return Ext.util.Format.number(v, format);
        }
    }, {
        text: '单价',
        xtype: 'numbercolumn',
        dataIndex: 'sd_price',
        xtype: 'numbercolumn'
    }, {
        text: '税率',
        dataIndex: 'sd_taxrate',
        xtype: 'numbercolumn'
    }, {//∑金额
        text: '金额',
        xtype: 'numbercolumn',
        dataIndex: 'sd_total',
        xtype: 'numbercolumn',
        summaryType: 'sum',
        summaryRenderer: function(v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length)).fill('0');
            var format = '0,000.' + xr.join();
            return Ext.util.Format.number(v, format);
        }
    }, {//∑不含税金额
        text: '不含税金额',
        xtype: 'numbercolumn',
        dataIndex: 'sd_nettotal',
        xtype: 'numbercolumn',
        summaryType: 'sum',
        summaryRenderer: function(v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length)).fill('0');
            var format = '0,000.' + xr.join();
            return Ext.util.Format.number(v, format);
        }
    }, {
        text: '出货数量',
        dataIndex: 'sd_sendqty',
        xtype: 'numbercolumn',
        renderer : function(v) {
            var arr = (v + '.').split('.');
            var xr = (new Array(arr[1].length)).fill('0');
            var format = '0.' + xr.join();
            return Ext.util.Format.number(v, format);
        }
    }, {
        text : "备注", 
        dataIndex : "sd_remark",
        width : 250 
    }]

});