saas-platform/frontend/saas-web/app/view/stock/report/Prodiodetail.js

Ext.define('saas.view.stock.report.Prodiodetail', {
    extend: 'saas.view.core.report.ReportPanel',
    xtype: 'stock-report-prodiodetail',

    controller: 'stock-report-prodiodetail',
    viewModel: 'stock-report-prodiodetail',

    viewName: 'stock-report-prodiodetail',
  //  按物料分组
    groupField: 'pd_prodcode',
    groupHeaderTpl: '物料: {[values.rows[0].data.pr_detail]}({[values.rows[0].data.pd_prodcode]})',
    listUrl: '/api/storage/report/prodioDetail',
    defaultCondition: null,
    reportTitle: '物料出入库明细表',
    QueryWidth:0.2,
    showMySummary: false,

    //筛选：单据类型、物料、日期
    searchItems: [ {		
        xtype: 'textfield',
        name: 'pd_prodcode',
        fieldLabel: '',
        emptyText:'输入单号，订单号或物料编号',
        columnWidth: 0.2,
        getCondition:function(v){
            return "(upper(pd_prodcode) like '%" + v.toUpperCase() + "%' or upper(pi_inoutno) like '%" + v.toUpperCase() + "%' or upper(pd_ordercode) like '%" + v.toUpperCase() + "%')";
        }
    },{
        xtype: 'multicombo',
        name: 'pi_class',
        fieldLabel: '单据类型',
        allowBlank: true,
        columnWidth: 0.2,
        datas: [
            ["采购验收单", "采购验收单"],
            ["采购验退单", "采购验退单"],
            ["出货单", "出货单"],
            ["销售退货单", "销售退货单"],
            ["完工入库单", "完工入库单"],
            ["生产领料单", "生产领料单"],
            ["拆件领料单", "拆件领料单"],
            ["其它入库单", "其它入库单"],
            ["其它出库单", "其它出库单"],
            ["调拨单", "调拨单"],
            ["拨入单", "拨入单"],
            ["库存初始化","库存初始化"]
        ]
    }, {
        xtype: 'condatefield',
        name: 'pi_date',
        fieldLabel: '单据日期',
        columnWidth: 0.4
    }],
    reportColumns: [{
        text: 'id',
        dataIndex: 'id',
        hidden: true
    }, {
        text: '单号',
        dataIndex: 'pi_inoutno',
        width: 150
    }, {
        text: '单据类型',
        dataIndex: 'pi_class',
        width: 110
    }, {
        text: '日期',
        dataIndex: 'pi_date',
        xtype: 'datecolumn'
    }, {
        text: '序号',
        dataIndex: 'pd_pdno',
        exportFormat: 'Integer',
        xtype: 'numbercolumn',
        width: 80
    }, {
        text: '物料类型',
        dataIndex: 'pr_kind'
    }, {
        text: '物料编号',
        dataIndex: 'pd_prodcode',
        width: 150
    }, {
        text: '物料名称',
        dataIndex: 'pr_detail',
        width: 200
    }, {
        text: '物料规格',
        dataIndex: 'pr_spec',
        width: 150
    }, {
        text: '仓库',
        dataIndex: 'pd_whname',
        width: 150
    }, {
        text: '入库数量',
        xtype: 'numbercolumn',
        exportFormat: 'Quantity',
        dataIndex: 'inqty',
        summaryType: 'sum',
        summaryRenderer: 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: '出库数量',
        xtype: 'numbercolumn',
        exportFormat: 'Quantity',
        dataIndex: 'outqty',
        summaryType: 'sum',
        summaryRenderer: 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: '成本单价(元)',
        xtype: 'numbercolumn',
        exportFormat: 'Price',
        dataIndex: 'pd_price',
        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_ordercode',
        width: 150
    },{
        text: '备注',
        dataIndex: 'pd_remark',
        width: 250
    }, {
        text: '客户/供应商编号',
        dataIndex: 'bizcode',
        width: 150
    }, {
        text: '客户/供应商名称',
        dataIndex: 'bizname',
        width: 250
    }]

});