saas-platform/frontend/saas-web/app/view/sale/sale/QueryPanel.js

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

    controller: 'sale-sale-querypanel',
    viewModel: 'sale-sale-querypanel',
    viewName: 'sale-sale-formpanel',
    _idField: 'sa_id',
    _codeField: 'sa_code',
    queryFormItems: [{
        xtype: 'hidden',
        name: 'sa_id',
        bind: '{sa_id}',
        fieldLabel: 'ID',
        allowBlank: true,
        columnWidth: 0
    }, {
        xtype: 'textfield',
        name: 'sa_code',
        bind: '{sa_code}',
        fieldLabel: '单据编号',
        allowBlank: true,
        columnWidth: 0.25
    }, {
        xtype: 'condatefield',
        name: 'sa_recorddate',
        bind: '{sa_recorddate}',
        fieldLabel: '单据日期',
        allowBlank: true,
        columnWidth: 0.5
    }, {
        xtype: 'dbfindtrigger',
        name: 'sa_custcode',
        bind: '{sa_custcode}',
        fieldLabel: '客户编号',
        allowBlank: true,
        columnWidth: 0.25
    }, {
        xtype: 'textfield',
        name: 'sa_custname',
        bind: '{sa_custname}',
        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
    }, {
        xtype: 'textfield',
        name: 'pr_detail',
        bind: '{pr_detail}',
        fieldLabel: '物料名称',
        allowBlank: true,
        columnWidth: 0.25
    }, {
        xtype: 'combobox',
        name: 'sa_statuscode',
        bind: '{sa_statuscode}',
        fieldLabel: '审核状态',
        allowBlank: true,
        columnWidth: 0.25,
        queryMode: 'local',
        displayField: 'sa_status',
        valueField: 'sa_statuscode',
        editable:false,
        store: Ext.create('Ext.data.ArrayStore', {
        fields: ['sa_statuscode', 'sa_status'],
        data: [
            ["$ALL", "全部"],
            ["AUDITED", "已审核"],
            ["UNAUDITED", "未审核"]
        ]
        })
    }, {
        xtype: 'multicombo',
        name: 'sa_sendstatuscode',
        bind: '{sa_sendstatuscode}',
        fieldLabel: '出库状态',
        allowBlank: true,
        columnWidth: 0.25,
        datas: [
            ["TURNOUT", "已出库"],
            ["UNTURNOUT", "未出库"],
            ["PARTOUT", "部分出库"]
        ]
    }],
    moreQueryFormItems: [{
        xtype: 'textfield',
        name: 'pu_buyername',
        bind: '{pu_buyername}',
        fieldLabel: '采购员',
        allowBlank: true
    }],
    queryGridConfig: {
        _idField: 'sa_id',
        _codeField: 'sa_code',
        _title: '销售订单',
        _defaultCondition:'',
        _addXtype: 'sale-sale-formpanel',
        _baseVastUrl: 'http://192.168.0.181:8560/api/sale/sale/',
        _baseColumn: [{
            text: '序号',
            width: 80,
            xtype: 'rownumberer'
        }, {
            text: 'id',
            dataIndex: 'sa_id',
            width: 100,
            xtype: 'numbercolumn'
        }, {
            text: '单据编号',
            dataIndex: 'sa_code',
            width: 120
        }, {
            text: '单据状态',
            dataIndex: 'sa_status',
            width: 120
        }, {
            text: '单据日期',
            dataIndex: 'sa_recorddate',
            xtype: 'datecolumn',
            width: 200
        }, {
            text: '客户名称',
            dataIndex: 'sa_cuname',
            width: 120
        }, {
            text: '金额',
            dataIndex: 'sa_total',
            xtype: 'numbercolumn',
            width: 120
        }],
        _relativeColumn: [{
            text: '序号',
            width: 80,
            xtype: 'rownumberer'
        }, {
            text: 'id',
            dataIndex: 'sa_id',
            width: 100,
            xtype: 'numbercolumn'
        }, {
            text: '单据编号',
            dataIndex: 'sa_code',
            width: 120
        }, {
            text: '单据状态',
            dataIndex: 'sa_status',
            width: 120
        }, {
            text: '下单日期',
            dataIndex: 'sa_recorddate',
            xtype: 'datecolumn',
            width: 200
        }, {
            text: '客户名称',
            dataIndex: 'sa_cuname',
            width: 120
        }, {
            text: '明细序号',
            dataIndex: 'sd_detno',
            xtype: 'numbercolumn',
            width: 120
        }, {
            text: '物料编号',
            dataIndex: 'sd_prodcode',
            width: 120
        }, {
            text: '数量',
            dataIndex: 'sd_qty',
            xtype: 'numbercolumn',
            width: 120
        }, {
            text: '单价',
            dataIndex: 'sd_price',
            xtype: 'numbercolumn',
            width: 120
        }, {
            text: '已转数',
            dataIndex: 'sd_ytqy',
            xtype: 'numbercolumn',
            width: 120
        }, {
            text: '已出货数',
            dataIndex: 'sd_sendqty',
            xtype: 'numbercolumn',
            width: 120
        }, {
            text: '已审核采购单数',
            dataIndex: 'sd_pdqty',
            xtype: 'numbercolumn',
            width: 120
        }, {
            text: '备注',
            dataIndex: 'sd_remark',
            width: 250,
            flex: 1
        }]
    }
});