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/report/saleDetail',
    defaultCondition: null,
    reportTitle: '销售明细报表',
    QueryWidth:0.2,
    allowCust: true,

    searchItems: [
    {
        xtype: 'customerDbfindTrigger',
        name: 'sa_custname',
        emptyText:'请输入客户名称',
        columnWidth: 0.2
    }, {
        xtype: 'multicombo',
        name: 'sa_sendstatuscode',
        fieldLabel: '业务状态',
        allowBlank: true,
        columnWidth: 0.2,
        datas: [
            ["TURNOUT", "已出库"],
            ["UNTURNOUT", "未出库"],
            ["PARTOUT", "部分出库"],
            ["CLOSE", "已关闭"]
        ]
    }, {
        xtype: 'condatefield',
        name: 'sa_date',
        fieldLabel: '日期',
        columnWidth: 0.4
    }],
    reportModel: 'saas.model.report.Sale',
    reportColumns: [
    {
        text: 'id',
        dataIndex: 'sa_id',
        hidden: true
    }, {
        text: '销售单号',
        dataIndex: 'sa_code',
        width: 150
    }, {
        text: '客户名称',
        dataIndex: 'sa_custname',
        width: 200
    }, {
        text: '业务状态',
        align: 'center',
        dataIndex: 'sa_sendstatus',
        width: 80
    }, {
        text: '业务员',
        dataIndex: 'sa_seller',
        width: 80
    }, {
        text: '单据日期',
        xtype: 'datecolumn',
        dataIndex: 'sa_date',
        width: 110
    }, {
        text: '序号',
        xtype: 'numbercolumn',
        dataIndex: 'sd_detno',
        align: 'center',
        exportFormat: 'Integer',
        width: 65,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 0, true);
        }
    }, {
        text: '物料编号',
        width: 150,
        dataIndex: 'sd_prodcode'
    }, {
        text: '品牌',
        dataIndex: 'pr_brand',
        width: 100
    }, {
        text: '物料名称',
        dataIndex: 'pr_detail',
        width: 150
    }, {
        text: '型号',
        dataIndex: 'pr_orispeccode',
        width: 200
    }, {
        text: '规格',
        dataIndex: 'pr_spec',
        width: 200
    },{
        text: '出货数量',
        dataIndex: 'sd_pdsendqty',
        exportFormat: 'Quantity',
        xtype: 'numbercolumn',
        width: 110,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 3, false);
        }
    }, {
        text: '销售数量',
        dataIndex: 'sd_qty',
        exportFormat: 'Quantity',
        xtype: 'numbercolumn',
        width: 110,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 3, false);
        }
    }, {
        text: '单位',
        dataIndex: 'pr_unit',
        width: 65
    }, {
        text: '单价(元)',
        dataIndex: 'sd_netprice',
        exportFormat: 'Price',
        xtype: 'numbercolumn',
        width: 120,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 4, true);
        }
    }, {
        text: '含税单价(元)',
        dataIndex: 'sd_price',
        exportFormat: 'Price',
        xtype: 'numbercolumn',
        width: 120,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 4, true);
        }
    }, {
        text: '金额(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        width: 120,
        hidden:true,
        dataIndex: 'sd_nettotal',
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    }, {
        text: '金额(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        width: 120,
        dataIndex: 'sd_nettotal*sa_rate',
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryType: 'sum',
        summaryLabel: '金额(本位币)',
        summaryRenderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    }, {
        text: '税率(%)',
        dataIndex: 'sd_taxrate',
        exportFormat: 'Integer',
        width: 80,
        xtype: 'numbercolumn',
        renderer: function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, false);
        },
    }, {
        text: '税额(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'sd_total - sd_nettotal',
        width: 120,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryType: 'sum',
        summaryLabel: '税额',
        summaryRenderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    }, {
        text: '价税合计(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'sd_total',
        width: 120,
        hidden:true,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    }, {
        text: '价税合计(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Amount',
        dataIndex: 'sd_total*sa_rate',
        width: 120,
        renderer : function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        },
        summaryType: 'sum',
        summaryLabel: '价税合计(本位币)',
        summaryRenderer: function(v) {
            return saas.util.BaseUtil.numberFormat(v, 2, true);
        }
    }, {
        text: '币别',
        dataIndex: 'sa_currency',
        align:'center',
        width: 65
    }, {
        text: '汇率',
        xtype: 'numbercolumn',
        dataIndex: 'sa_rate',
        width: 80,
        renderer: function(v, m, r) {
            return saas.util.BaseUtil.numberFormat(v, 6, true);
        }
    },  {
        text : "备注", 
        dataIndex : "sd_remark",
        width : 250 
    }]

});