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

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

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

    viewName: 'stock-report-prodinoutCount',
    //按物料分组
    groupField: null,
    listUrl: '/api/storage/report/prodinoutCount',
    defaultCondition: null,
    reportTitle: '物料收发汇总表',
    QueryWidth:0.1,
    //筛选：仓库、物料、物料类型、时间			
    searchItems: [{		
        xtype: 'dbfindtrigger',
        name: 'wh_description',
        fieldLabel: '仓库',
        columnWidth: 0.2
    }, {		
        xtype: 'dbfindtrigger',
        name: 'pd_prodcode',
        fieldLabel: '物料编号',
        columnWidth: 0.2
    }, {		
        xtype: 'remotecombo',
        editable:false,
        name: 'pd_prodcode',
        fieldLabel: '物料类型',
        columnWidth: 0.2,
        storeUrl:'/api/document/producttype/getCombo',
        addHandler:function(b){
            var document = Ext.create('saas.view.document.kind.Kind',{});
            var form = this.ownerCmp.ownerCt;
            this.dialog = form.getController().getView().add({
                xtype: 'document-kind-childwin',
                bind: {
                    title: '新增物料类型'
                },
                dataKind:'productkind',
                belong:document.etc['productkind'],
                _parent:form,
                _combo:this.ownerCmp,
                record:null,
                session: true
            });
            this.dialog.show();
        }
    }, {
        xtype: 'condatefield',
        name: 'pi_date',
        fieldLabel: '单据日期',
        columnWidth: 0.5
    }],
    reportColumns: [{
        text: '物料类型',
        dataIndex: 'pr_kind'
    }, {
        text: '物料编号',
        dataIndex: 'pr_code',
        width: 200
    }, {
        text: '物料名称',
        dataIndex: 'pr_detail',
        width: 200
    }, {
        text: '物料规格',
        dataIndex: 'pr_spec'
    }, {
        text: '单位',
        dataIndex: 'pr_unit'
    }, {
        text: '仓库',
        dataIndex:'pd_whcode'
    }, {
        text: '期初',
        columns: [{
            text: '数量',
            dataIndex:'pwm_beginqty',
            xtype: 'numbercolumn'
        },{
            text: '成本',
            dataIndex:'pwm_beginamount',
            xtype: 'numbercolumn'
        }]
    }, {
        text: '入库合计',
        columns: [{
            text: '数量',
            dataIndex:'pwm_nowinqty',
            xtype: 'numbercolumn'
        },{
            text: '成本',
            dataIndex:'pwm_nowinamount',
            xtype: 'numbercolumn'
        }]
    }, {
        text: '出库合计',
        columns: [{
            text: '数量',
            dataIndex:'pwm_nowoutqty',
            xtype: 'numbercolumn'
        },{
            text: '成本',
            dataIndex:'pwm_nowoutamount',
            xtype: 'numbercolumn'
        }]
    }, {
        text: '结存',
        columns: [{
            text: '数量',
            dataIndex:'pwm_endqty',
            xtype: 'numbercolumn'
        },{
            text: '成本',
            dataIndex:'pwm_endamount',
            xtype: 'numbercolumn'
        }]
    }]
});