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:'pi_id',
    _codeField:'pi_inoutno',
    queryFormItems: [{
        xtype: 'hidden',
        name: 'pi_id',
        bind: '{pi_id}',
        fieldLabel: 'ID',
        allowBlank: true,
        columnWidth: 0
    }, {
        xtype: 'dbfindtrigger',
        name: 'pi_inoutno',
        bind: '{pi_inoutno}',
        fieldLabel: '单据编号',
        allowBlank: true,
        columnWidth: 0.25,
        dataUrl:'http://192.168.253.41:9480/api/document/vendor/getVendorsByCondition',
        dbfinds:[{
            from:'ve_code',to:'pu_code'
        }],
        dbColumns:[{
            conditionCode:'ve_id',
            "text": "供应商ID",
            "flex": 0,
            "dataIndex": "ve_id",
            "width": 0,
            "xtype": "",
            "items": null
        },{
            conditionCode:'ve_code',
            "text": "供应商编号",
            "flex": 1,
            "dataIndex": "ve_code",
            "width": 100,
            "xtype": "",
            "items": null
        }, {
            conditionCode:'ve_name',
            "text": "供应商名称",
            "flex": 1,
            "dataIndex": "ve_name",
            "xtype": "",
            "items": null
        }, {
            conditionCode:'ve_type',
            "text": "供应商类型",
            "flex": 0,
            "dataIndex": "ve_type",
            "width": 200,
            "xtype": "",
            "items": null
        }]
    }, {
        xtype: 'condatefield',
        name: 'pu_date',
        bind: '{pu_date}',
        fieldLabel: '采购日期',
        allowBlank: true,
        columnWidth: 0.5
    }, {
        xtype: 'dbfindtrigger',
        name: 'pu_vendcode',
        bind: '{pu_vendcode}',
        fieldLabel: '供应商编号',
        allowBlank: true,
        columnWidth: 0.25,
        configUrl: 'resources/json/purchase/vendorColumnsDbfind.json',
        dataUrl: 'resources/json/purchase/vendorDataDbfind.json'
    }, {
        xtype: 'textfield',
        name: 'pu_vendname',
        bind: '{pu_vendname}',
        fieldLabel: '供应商名称',
        allowBlank: true,
        columnWidth: 0.25
    }, {
        xtype: 'dbfindtrigger',
        name: 'pd_prodcode#pd_prodcode',
        bind: '{pd_prodcode}',
        fieldLabel: '物料编号',
        fieldMode: 'DETAIL',
        queryType:'VAG',
        allowBlank: true,
        columnWidth: 0.25,
        configUrl: 'resources/json/purchase/vendorColumnsDbfind.json',
        dataUrl: 'resources/json/purchase/vendorDataDbfind.json'
    }, {
        xtype: 'textfield',
        name: 'pr_detail',
        bind: '{pr_detail}',
        fieldLabel: '物料名称',
        allowBlank: true,
        columnWidth: 0.25
    }, {
        xtype: 'combobox',
        name: 'pr_statuscode',
       // bind: '{pr_statuscode}',
        fieldLabel: '审核状态',
        allowBlank: true,
        columnWidth: 0.25,
        queryMode: 'local',
            displayField: 'pr_status',
            valueField: 'pr_statuscode',
        store: Ext.create('Ext.data.ArrayStore', {
            fields: ['pr_statuscode', 'pr_status'],
            data: [
                ["$ALL", "全部"],
                ["AUDITED", "已审核"],
                ["UNAUDITED", "未审核"]
            ]
        })
    }, {
        xtype: 'combobox',
        name: 'pu_acceptstatuscode',
        bind: '{pu_acceptstatuscode}',
        fieldLabel: '入库状态',
        allowBlank: true,
        columnWidth: 0.25,
        queryMode: 'local',
        displayField: 'pu_acceptstatus',
        valueField: 'pu_acceptstatuscode',
        store: Ext.create('Ext.data.ArrayStore', {
            fields: ['pu_acceptstatuscode', 'pu_acceptstatus'],
            data: [
                ["$ALL", "全部"],
                ["TURNOUT", "已入库"],
                ["NOOUT", "未入库"],
                ["PARTOUT", "部分入库"]
            ]
        })
    }],
    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:'pu_id',
        _codeField:'pu_code',
        _title:'采购单',
        _addXtype:'test-order-formpanel',
        _baseVastUrl:'http://192.168.253.58:8800/purchase/',
        _baseColumn: [{
            text: '序号',
            width: 80,
            xtype: 'rownumberer'
        }, {
            text: 'id',
            dataIndex: 'pu_id',
            width: 100,
            xtype: 'numbercolumn'
        }, {
            text: '单据编号',
            dataIndex: 'pu_code',
            width: 120
        }, {
            text: '单据状态',
            dataIndex: 'pu_status',
            width: 120
        }, {
            text: '下单日期',
            dataIndex: 'pu_indate',
            xtype:'datecolumn',
            width: 200
        },{
            text: '供应商名称',
            dataIndex: 'pu_vendname',
            width: 120
        },{
            text: '含税金额',
            dataIndex: 'pu_taxtotal',
            xtype:'numbercolumn',
            width: 120
        },{
            text: '金额',
            dataIndex: 'pu_total',
            xtype:'numbercolumn',
            width: 120,
            flex: 1
        }],
        _relativeColumn: [{
            text: '序号',
            width: 80,
            xtype: 'rownumberer'
        }, {
            text: 'id',
            dataIndex: 'pu_id',
            width: 100,
            xtype: 'numbercolumn'
        }, {
            text: '单据编号',
            dataIndex: 'pu_code',
            width: 120
        }, {
            text: '单据状态',
            dataIndex: 'pu_status',
            width: 120
        }, {
            text: '下单日期',
            dataIndex: 'pu_indate',
            xtype:'datecolumn',
            width: 200
        },{
            text: '供应商名称',
            dataIndex: 'pu_vendname',
            width: 120
        },{
            text: '采购序号',
            dataIndex: 'pd_detno',
            xtype:'numbercolumn',
            width: 120
        },{
            text: '物料编号',
            dataIndex: 'pd_prodcode',
            width: 120
        },{
            text: '数量',
            dataIndex: 'pd_qty',
            xtype:'numbercolumn',
            width: 120
        },{
            text: '单价',
            dataIndex: 'pd_price',
            xtype:'numbercolumn',
            width: 120
        },{
            text: '已转数',
            dataIndex: 'pd_ytqy',
            xtype:'numbercolumn',
            width: 120,
            flex: 1
        }]
    }
});