saas-platform/frontend/saas-web/app/view/stock/appropriationInOut/QueryPanel.js

Ext.define('saas.view.stock.appropriationInOut.QueryPanel', {
    extend: 'saas.view.core.query.QueryPanel',
    xtype: 'stock-appropriationinout-querypanel',

    controller: 'stock-appropriationinout-querypanel',
    viewModel: 'stock-appropriationinout-querypanel',

    viewName: 'stock-appropriationinout-querypanel',

    queryFormItems: [{
        xtype: 'hidden',
        name: 'id',
        fieldLabel: 'ID',
        allowBlank: true,
        columnWidth: 0
    },{
        xtype: 'textfield',
        name: 'pi_inoutno',
        emptyText:'请输入单号或物料',
        showDetail: true,
        getCondition: function(value) {
            if(value != '') {
                return  ' (pi_inoutno like\'%' + value + '%\' or pd_prodcode like \'%'+value+'%\' ) ';
            }else {
                return '1=1';
            }
        }
    }, {
        xtype: 'condatefield',
        name: 'pi_date',
        fieldLabel: '日期',
        allowBlank: true,
        columnWidth: 0.5
    }, {
        xtype: 'combobox',
        name: 'pi_statuscode',
        fieldLabel: '状态',
        allowBlank: true,
        editable:false,
        columnWidth: 0.25,
        showDetail: true,
        queryMode: 'local',
        emptyText :'全部',
        editable:false,
        displayField: 'pi_status',
        valueField: 'pi_statuscode',
        store: Ext.create('Ext.data.ArrayStore', {
            fields: ['pi_statuscode', 'pi_status'],
            data: [
                ["ALL", "全部"],
                ["AUDITED", "已审核"],
                ["UNAUDITED", "未审核"]
            ]
        }),
        getCondition: function(value) {
            if(value == 'ALL') {
                return '1=1';
            }else {
                return 'pi_statuscode=\'' + value + '\'';
            }
        }
    },{
        xtype: 'warehouseDbfindTrigger',
        name: 'pd_whcode',
        fieldLabel: '仓库',
        emptyText :'请输入仓库名或仓库编号',
        showDetail: true,
        getCondition: function(value) {
            if(value != '') {
                return  ' (pd_whcode like\'%' + value + '%\' or pd_whname like \'%'+value+'%\' or pd_inwhcode like\'%' + value + '%\' or pd_inwhname like \'%'+value+'%\') ';
            }else {
                return '1=1';
            }
        }
    }],
    moreQueryFormItems: [],
    queryGridConfig: {
        idField:'id',
        codeField:'pi_inoutno',
        addTitle:'调拨单',
        addXtype:'stock-appropriationinout-formpanel',
        defaultCondition:' pi_class = \'调拨单\'',
        baseVastUrl:'/api/storage/prodinout/',
        baseColumn: [{
            text: 'id',
            dataIndex: 'id',
            hidden:true,
            xtype: 'numbercolumn'
        }, {
            text: '调拨单号',
            dataIndex: 'pi_inoutno',
            width: 150
        },{
            text: '单据类型',
            dataIndex: 'pi_class',
            width: 0
        },{
            text: '单据日期',
            dataIndex: 'pi_date',
            xtype:'datecolumn',
            width: 110
        },{
            text: '状态',
            dataIndex: 'pi_status',
            width: 90
        },{
            text: '录入人',
            dataIndex: 'creatorName',
            width: 110
        },{
            text: '审核人',
            dataIndex: 'pi_auditman',
            width: 110
        },{
            text: '备注',
            dataIndex: 'pi_remark',
            width: 250
        }],
        relativeColumn: [
            {
                text: 'id',
                dataIndex: 'pi_id',
                xtype: 'numbercolumn',
                hidden:true
            },{
                text: '调拨单号',
                dataIndex: 'pi_inoutno',
                width: 150
            },{
                text: '单据类型',
                dataIndex: 'pi_class',
                width: 0
            },{
                text: '单据日期',
                dataIndex: 'pi_date',
                xtype:'datecolumn',
                width: 110
            },{
                text: '状态',
                dataIndex: 'pi_status',
                width: 90
            },{
                text: '序号',
                dataIndex: 'pd_pdno',
                width: 80
            },{
                text: '相关单号',
                dataIndex: 'pd_ordercode',
                width: 150
            },{
                text: '物料编号',
                dataIndex: 'pd_prodcode',
                width: 150
            },{
                text: '物料名称',
                dataIndex: 'pr_detail',
                width: 200
            },{
                text: '物料规格',
                dataIndex: 'pr_spec',
                width: 150
            },{
                text: '单位',
                dataIndex: 'pr_unit',
                width: 80
            },{
                text: '数量',
                dataIndex: 'pd_inqty',
                xtype:'numbercolumn',
                width: 110
            },{
                text: '仓库',
                dataIndex: 'pd_whname',
                width: 150
            },{
                text: '单价',
                dataIndex: 'pd_orderprice',
                xtype:'numbercolumn',
                width: 110,
                renderer : 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: 'pd_taxrate',
                xtype:'numbercolumn',
                width: 80,            
                renderer : function(v) {
                    return Ext.util.Format.number(v, '0');
                },
            },{
                text: '金额',
                dataIndex: 'pd_total',
                xtype:'numbercolumn',            
                width: 110,
                renderer : 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: 'pd_remark',
                width:250
            }]
    }
});