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

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

    controller: 'purchase-purchaseout-querypanel',
    viewModel: 'purchase-purchaseout-querypanel',

    viewName: 'purchase-purchaseout-querypanel',

    queryFormItems: [{
        xtype: 'textfield',
        name: 'pi_inoutno',
        emptyText:'请输入单号或供应商',
        getCondition: function(value) {
            return  ' (pi_inoutno like\'%' + value + '%\' or pi_vendcode like \'%'+value+'%\' or pi_vendname like \'%'+value+'%\') ';
        }
    }, {
        xtype: 'condatefield',
        name: 'pi_date',
        fieldLabel: '日期',
        columnWidth: 0.5,
        operation: 'between'
    }, {
        xtype: 'productDbfindTrigger',
        name: 'pr_detail',
        fieldLabel: '物料',
        emptyText:'输入物料编号或名称',
        showDetail: true,
        getCondition: function(value) {
            console.log('物料：'+value);
            if(!value) {
                return '1=1';
            }else {
                return ' upper(concat(IFNULL(product.pr_detail,\' \'),\'#\',IFNULL(product.pr_code,\' \')) like \'%' + value.toUpperCase() + '%\' ';
            }
        }
    }, {
        xtype: 'combobox',
        name: 'pi_statuscode',
        fieldLabel: '单据状态',
        allowBlank: true,
        emptyText :'全部',
        editable:false,
        queryMode: 'local',
        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: 'multicombo',
        name: 'pi_prstatuscode',
        fieldLabel: '付款状态',
        emptyText :'全部',
        datas: [
            ["PAYNONE", "未付款"],
            ["PAYPART", "部分付款"],
            ["PAYALL", "已付款"]
        ]
    }, {
        xtype: 'warehouseDbfindTrigger',
        name: 'pd_whname',
        fieldLabel: '仓库',
        emptyText:'请输入仓库编号或名称',
        showDetail: true,
        getCondition: function(value) {
            if(!value) {
                return '1=1';
            }else {
                return 'prodiodetail.pd_whname like\'%' + value + '%\'';
            }
        }
    }, {
        xtype: 'textfield',
        name: 'pi_iocode',
        fieldLabel: '关联验收单号',
        emptyText: '输入单号',
    }, {
        xtype: 'accountDbfindTrigger',
        name: 'creatorName',
        fieldLabel: '录入人',
        emptyText:'请输入人员编号或名称',
        getCondition: function(value) {
            if(!value) {
                return '1=1';
            }else {
                return 'prodinout.creatorName like\'%' + value + '%\'';
            }
        }
    }, {
        xtype: 'accountDbfindTrigger',
        name: 'pi_auditman',
        fieldLabel: '审核人',
        emptyText:'请输入人员编号或名称'
    }],
    queryGridConfig: {
        idField:'id',
        codeField:'pi_inoutno',
        addTitle:'采购验退单',
        addXtype:'purchase-purchaseout-formpanel',
        defaultCondition:' pi_class = \'采购验退单\'',
        baseVastUrl:'/api/purchase/prodinout/',
        caller:'PurchaseOut',
        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_vendname',
            width: 150
        },{
            text: '关联验收单号',
            dataIndex: 'pi_iocode',
            width: 150
        },{
            text: '总金额',
            dataIndex: 'pi_total',
            width: 110
        },{
            text: '单据状态',
            align: 'center',
            dataIndex: 'pi_status',
            width: 90
        },{
            text: '付款状态',
            align: 'center',
            dataIndex: 'pi_prstatus',
            width: 90
        },{
            text: '录入人',
            dataIndex: 'creatorName',
            width: 110
        },{
            text: '审核人',
            dataIndex: 'pi_auditman',
            width: 110
        },{
            text: '备注',
            dataIndex: 'pi_remark',
            width: 250
        }],
        relativeColumn: [
            {
                text: 'id',
                dataIndex: 'pu_id',
                xtype: 'numbercolumn',
                hidden:true
            }, {
                text: '单据编号',
                dataIndex: 'pi_inoutno',
                width: 150
            }, {
                text: '单据类型',
                dataIndex: 'pd_piclass',
                width: 0
            },{
                text: '单据日期',
                dataIndex: 'pi_date',
                xtype:'datecolumn',
                width: 110
            },{
                text: '供应商编号',
                dataIndex: 'pi_vendcode',
                width: 0
            },{
                text: '供应商名称',
                dataIndex: 'pi_vendname',
                width: 250
            },{
                text: '审核状态',
                align: 'center',
                dataIndex: 'pi_status',
                width: 90
            },{
                text: '序号',
                dataIndex: 'pd_pdno',
                width: 80, 
                renderer : function(v) {
                    return Ext.util.Format.number(v, '0');
                }
            },{
                text: '关联验收单号',
                dataIndex: 'pi_iocode',
                width: 150
            },{
                text: '关联验收序号号',
                dataIndex: 'iodetno',
                width: 150
            },{
                text: '物料编号',
                dataIndex: 'pd_prodcode',
                width: 150, 
                renderer : function(v) {
                    return Ext.util.Format.number(v, '0');
                }
            },{
                text: '物料名称',
                dataIndex: 'pr_detail',
                width: 200
            },{
                text: '物料规格',
                dataIndex: 'pr_spec',
                width: 150
            },{
                text: '单位',
                dataIndex: 'pr_unit',
                width: 80
            },{
                text: '数量',
                dataIndex: 'pd_outqty',
                xtype:'numbercolumn',
                width: 110,
                renderer : function(v) {
                    var arr = (v + '.').split('.');
                    var xr = (new Array(arr[1].length > 3 ? 3 : arr[1].length)).fill('0');
                    var format = '0,000.' + xr.join();
                    return Ext.util.Format.number(v, format);
                },
            },{
                text: '仓库',
                dataIndex: 'pd_whname',
                width: 150
            },{
                text: '单价',
                dataIndex: 'pd_orderprice',
                xtype:'numbercolumn',
                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);
                },            
                width: 110
            },{
                text: '税率',
                dataIndex: 'pd_taxrate',
                xtype:'numbercolumn',
                width: 80,
                renderer : function(v) {
                    return Ext.util.Format.number(v, '0');
                },
            },{
                text: '金额',
                dataIndex: 'pd_ordertotal',
                xtype:'numbercolumn',
                width: 110,
                renderer : function(v) {
                    var arr = (v + '.').split('.');
                    var xr = (new Array(arr[1].length > 2 ? 2 : arr[1].length)).fill('0');
                    var format = '0,000.' + xr.join();
                    return Ext.util.Format.number(v, format);
                },
            }]
    }
});