saas-platform/frontend/saas-web/app/view/money/payBalance/QueryPanel.js

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

    controller: 'money-paybalance-querypanel',
    viewModel: 'money-paybalance-querypanel',

    viewName: 'money-paybalance-querypanel',
    
    queryFormItems: [{
        xtype: 'hidden',
        name: 'pb_id',
        fieldLabel: 'ID',
        allowBlank: true,
        getCondition: function(value) {
            return 'pb_id=' + value;
        }
    }, {
        xtype: 'textfield',
        name: 'pb_code',
        emptyText :'请输入单号或供应商',
        getCondition: function(value) {
            if(value == 'ALL') {
                return '1=1';
            }else {
                return  ' (pb_code like\'%' + value + '%\' '
                +' or pb_vendcode like \'%'+value+'%\' '
                +' or pb_vendname like \'%'+value+'%\') ';
            }
        }
    },{
        xtype: 'bandinfoDbfindTrigger',
        name: 'pd_bankname',
        fieldLabel: '资金账户',
        showDetail: true
    },{
        xtype: 'condatefield',
        name: 'pb_date',
        fieldLabel: '日期',
        columnWidth: 0.5,
        operation: 'between'
    },{
        xtype: 'combobox',
        name: 'pb_statuscode',
        fieldLabel: '状态',
        queryMode: 'local',
        displayField: 'name',
        valueField: 'value',
        emptyText :'全部',
        editable:false,
        store: Ext.create('Ext.data.ArrayStore', {
            fields: ['value', 'name'],
            data: [
                ["ALL", "全部"],
                ["AUDITED", "已审核"],
                ["UNAUDITED", "未审核"]
            ]
        }),
        getCondition: function(value) {
            if(value == 'ALL') {
                return '1=1';
            }else {
                return 'pb_statuscode=\'' + value + '\'';
            }
        }
    }],
    moreQueryFormItems: [],
    queryGridConfig: {
        idField: 'id',
        codeField: 'pb_code',
        addTitle: '付款单',
        addXtype: 'money-paybalance-formpanel',
        defaultCondition: '',
        baseVastUrl: '/api/money/paybalance/',
        baseColumn: [
            {
                text: 'id',
                dataIndex: 'id',
                width: 0,
                xtype: 'numbercolumn',
                hidden: true
            }, {
                text: '付款单号',
                dataIndex: 'pb_code',
                width: 150
            }, {
                text: '日期',
                dataIndex: 'pb_date',
                xtype: 'datecolumn',
                width: 110
            }, {
                text: '供应商名称',
                dataIndex: 'pb_vendname',
                width: 250,
            }, {
                text: '单据状态',
                dataIndex: 'pb_status',
                width: 90
            }, {
                text: '付款人',
                dataIndex: 'pb_manname',
                width: 110
            }, {
                text: '备注',
                dataIndex: 'pb_remark',
                width: 250
            }],
        relativeColumn: [{
            text: 'id',
            dataIndex: 'id',
            width: 0,
            xtype: 'numbercolumn',
            hidden: true
        }, {
            text: '付款单号',
            dataIndex: 'pb_code',
            width: 150
        }, {
            text: '日期',
            dataIndex: 'pb_date',
            xtype: 'datecolumn',
            width: 110
        }, {
            text: '供应商名称',
            dataIndex: 'pb_vendname',
            width: 250,
        }, {
            text: '单据状态',
            dataIndex: 'pb_status',
            width: 90
        }, {
            text: '付款人',
            dataIndex: 'pb_manname',
            width: 110
        },{
            text: '资金账户',
            dataIndex: 'pd_bankname',
            width: 110
        },{
            text: '付款金额',
            xtype: 'numbercolumn',
            dataIndex: 'pd_amount',
            width: 120,
            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);
            },
        } ,{
            text: '结算方式',
            dataIndex: 'pd_paymethod',
            width: 250
        },{
            text: '结算号',
            dataIndex: 'pd_paycode',
            width: 250
        },{
            text: '备注',
            dataIndex: 'pd_remark',
            width: 250
        }]
    }
});