saas-platform/frontend/saas-web/app/view/purchase/purchaseIn/QueryPanel.js

Ext.define('saas.view.purchase.purchasein.QueryPanel', {
    extend: 'saas.view.core.query.QueryPanel',
    xtype: 'purchase-purchasein-querypanel',

    controller: 'purchase-purchasein-queryformcontroller',
    viewModel: 'purchase-purchasein-queryformmodel',
    _baseVastUrl:'http://192.168.253.58:8800/purchase/',
    _idField:'id',
    _codeField:'pi_inoutno',
    queryFormItems: [{
        xtype: 'hidden',
        name: 'id',
        bind: '{id}',
        fieldLabel: 'ID',
        allowBlank: true,
        columnWidth: 0
    }, {
        xtype: 'textfield',
        name: 'pi_inoutno',
        bind: '{pi_inoutno}',
        fieldLabel: '单据编号',
        allowBlank: true,
        columnWidth: 0.25
    }, {
        xtype: 'condatefield',
        name: 'pi_date',
        bind: '{pi_date}',
        fieldLabel: '单据日期',
        allowBlank: true,
        columnWidth: 0.5
    }, {
        xtype: 'textfield',
        name: 'pi_vendcode',
        bind: '{pi_vendcode}',
        fieldLabel: '供应商编号',
        allowBlank: true,
        hidden:true,
        columnWidth: 0.25
    }, {
        xtype: 'textfield',
        name: 'pi_vendname',
        bind: '{pi_vendname}',
        fieldLabel: '供应商名称',
        allowBlank: true,
        columnWidth: 0.25
    }, {
        xtype: 'dbfindtrigger',
        name: 'pd_prodcode',
        bind: '{pd_prodcode}',
        fieldLabel: '物料编号',
        fieldMode: 'DETAIL',
        queryType:'VAG',
        hidden:true,
        allowBlank: true,
        columnWidth: 0.25
    }, {
        xtype: 'dbfindtrigger',
        name: 'pr_detail#pd_prodcode',
        bind: '{pr_detail}',
        fieldLabel: '物料名称',
        allowBlank: true,
        columnWidth: 0.25
    }, {
        xtype: 'combobox',
        name: 'pi_statuscode',
        bind: '{pi_statuscode}',
        fieldLabel: '审核状态',
        allowBlank: true,
        columnWidth: 0.25,
        queryMode: 'local',
        displayField: 'pi_status',
        valueField: 'pi_statuscode',
        store: Ext.create('Ext.data.ArrayStore', {
            fields: ['pi_statuscode', 'pi_status'],
            data: [
                ["$ALL", "全部"],
                ["AUDITED", "已审核"],
                ["UNAUDITED", "未审核"]
            ]
        })
    }],
    moreQueryFormItems: [{
        xtype: 'textfield',
        name: 'pu_buyername',
        bind: '{pu_buyername}',
        fieldLabel: '采购员',
        allowBlank: true
    }, {
        xtype: 'textfield',
        name: 'pu_total',
        bind: '{pu_total}',
        fieldLabel: '金额',
        allowBlank: true
    }, {
        xtype: 'condatefield',
        name: 'pu_delivery',
        bind: '{pu_delivery}',
        fieldLabel: '交货日期',
        allowBlank: true,
        columnWidth: 1
    }],
    queryGridConfig: {
        _idField:'id',
        _codeField:'pi_inoutno',
        _title:'采购验收单',
        _defaultCondition:' pi_class = \'采购验收单\'',
        _addXtype:'purchase-purchasein-formpanel',
        _baseVastUrl:'http://192.168.253.228:8800/prodinout/',
        _baseColumn: [{
            text: '序号',
            width: 80,
            xtype: 'rownumberer'
        }, {
            text: 'id',
            dataIndex: 'id',
            width: 100,
            xtype: 'numbercolumn'
        }, {
            text: '单据编号',
            dataIndex: 'pi_inoutno',
            width: 120
        }, {
            text: '单据状态',
            dataIndex: 'pi_status',
            width: 120
        }, {
            text: '单据类型',
            dataIndex: 'pi_class',
            width: 120
        }, {
            text: '下单日期',
            dataIndex: 'pi_date',
            xtype:'datecolumn',
            width: 200
        },{
            text: '采购单号',
            dataIndex: 'pi_pucode',
            width: 200
        },{
            text: '供应商名称',
            dataIndex: 'pi_vendname',
            width: 120
        },{
            text: '含税金额',
            dataIndex: 'pi_total',
            xtype:'numbercolumn',
            width: 120
        },{
            text: '不含税金额',
            dataIndex: 'pi_nettotal',
            xtype:'numbercolumn',
            width: 120,
            flex: 1
        }],
        _relativeColumn: [{
            text : "序号", 
            dataIndex : "pd_pdno", 
            width : 100, 
            xtype : "numbercolumn",
            align : 'center'
        }, {
            text: 'id',
            dataIndex: 'pu_id',
            width: 0,
            xtype: 'numbercolumn'
        }, {
            text: '单据编号',
            dataIndex: 'pd_inoutno',
            width: 120
        }, {
            text: '单据状态',
            dataIndex: 'pi_status',
            width: 120
        }, {
            text: '下单日期',
            dataIndex: 'pi_date',
            xtype:'datecolumn',
            width: 200
        },{
            text: '供应商名称',
            dataIndex: 'pi_vendname',
            width: 120
        },{
            text: '采购单号',
            dataIndex: 'pd_ordercode',
            width: 120
        },{
            text: '采购序号',
            dataIndex: 'pd_orderdetno',
            xtype:'numbercolumn',
            width: 120
        },{
            text: '物料编号',
            dataIndex: 'pd_prodcode',
            width: 120
        },{
            text: '验收数量',
            dataIndex: 'pd_inqty',
            xtype:'numbercolumn',
            width: 120
        },{
            text: '采购单价',
            dataIndex: 'pd_orderprice',
            xtype:'numbercolumn',
            width: 120
        },{
            text: '金额',
            dataIndex: 'pd_total',
            xtype:'numbercolumn',
            width: 120
        },{
            text: '税率',
            dataIndex: 'pd_taxrate',
            xtype:'numbercolumn',
            width: 120
        },{
            text: '成本单价',
            dataIndex: 'pd_price',
            xtype:'numbercolumn',
            width: 120,
            flex: 1
        }]
    }
});