saas-platform/frontend/saas-web/app/view/test/query/QueryPanel.js

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

    controller: 'test-query-querypanel',
    viewModel: 'test-query-querypanel',
    
    viewName: 'test-query-formpanel',
    _baseVastUrl:basePath+'purchase/',
    _idField:'pu_id',
    _codeField:'pu_code',
    queryFormItems: [{
        xtype: 'hidden',
        name: 'pu_id',
        bind: '{pu_id}',
        fieldLabel: 'ID',
        allowBlank: true,
        columnWidth: 0
    }, {
        xtype: 'dbfindtrigger',
        name: 'pu_code',
        bind: '{pu_code}',
        fieldLabel: '单据编号',
        allowBlank: true,
        columnWidth: 0.25,
        dataUrl:basePath+'ducument/vendor/list',
        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.Store', {
            fields: ['pr_statuscode', 'pr_status'],
            data: [
                ["$ALL", "全部"],
                ["AUDITED", "已审核"],
                ["AUDITED", "未审核"]
            ]
        })
    }, {
        xtype: 'multicombo',
        name: 'pu_acceptstatuscode',
        bind: '{pu_acceptstatuscode}',
        fieldLabel: '入库状态',
        allowBlank: true,
        columnWidth: 0.25,
        datas: [
            ["$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:basePath+'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
        }],
        _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
        }]
    }
});