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

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

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

    viewName: 'money-othspendings-querypanel',
    
    queryFormItems: [{
        xtype: 'hidden',
        name: 'os_id',
        fieldLabel: 'ID',
        allowBlank: true,
        columnWidth: 0,
        getCondition: function(value) {
            return 'os_id=' + value;
        }
    },{
        xtype: 'textfield',
        name: 'os_code',
        emptyText:'请输入单号或客户或账号',
        getCondition: function(value) {
            if(value == 'ALL') {
                return '1=1';
            }else {
                return  ' (os_code like\'%' + value + '%\'' 
                +' or os_vendcode like \'%'+value+'%\''
                +' or os_vendname like \'%'+value+'%\''
                +' or os_bankcode like \'%'+value+'%\''
                +' or os_bankname like \'%'+value+'%\''
                +') ';
            }
        }
    },{
        xtype: 'condatefield',
        name: 'os_date',
        columnWidth: 0.5,
        fieldLabel: '日期'
    },{
        name: 'osd_type',
        fieldLabel: '支出类别',
        xtype : "remotecombo",
        emptyText :'全部',
        showDetail: true,
        storeUrl:'/api/document/fundinouttype/getCombo?condition=支出',
        hiddenBtn:true,//true 则会关闭新增按钮功能
        getCondition: function(value) {
            if(!value) {
                return '1=1';
            }else {
                return 'osd_type like \'%' + value + '%\'';
            }
        }
    },{
        xtype: 'combobox',
        name: 'os_statuscode',
        fieldLabel: '状态',
        queryMode: 'local',
        displayField: 'os_status',
        valueField: 'os_statuscode',
        emptyText :'全部',
        editable:false,
        store: Ext.create('Ext.data.ArrayStore', {
        fields: ['os_statuscode', 'os_status'],
        data: [
            ["ALL", "全部"],
            ["AUDITED", "已审核"],
            ["UNAUDITED", "未审核"]
        ]
        }),
        getCondition: function(value) {
            if(value == 'ALL') {
                return '1=1';
            }else {
                return 'os_statuscode=\'' + value + '\'';
            }
        }
    }],
    moreQueryFormItems: [],
    queryGridConfig: {
        idField: 'id',
        codeField: 'os_code',
        addTitle: '其它支出单',
        addXtype: 'money-othspendings-formpanel',
        defaultCondition:'',
        baseVastUrl: '/api/money/othspendings/',
        baseColumn: [{
            text: 'id',
            dataIndex: 'id',
            hidden:true,
            xtype: 'numbercolumn'
        }, {
            text: '单据编号',
            dataIndex: 'os_code',
            width: 150
        }, {
            text: '日期',
            dataIndex: 'os_date',
            xtype: 'datecolumn',
            width: 110
        }, {
            text: '供应商名称',
            dataIndex: 'os_vendname',
            width:250
        },{
            text: '结算账户',
            dataIndex: 'os_bankname',
            width: 150
        },{
            text: '付款金额',
            dataIndex: 'os_amount',
            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);
            }
        }, {
            text: '单据状态',
            dataIndex: 'os_status',
            width: 90
        },{
            text: '录入人',
            dataIndex: 'creatorName',
            width: 110
        }, {
            text: '审核人',
            dataIndex: 'os_auditman',
            width: 110
        }, {
            text: '备注',
            dataIndex: 'os_remark',
            width: 250
        }],
        relativeColumn: [{
            text: 'id',
            dataIndex: 'id',
            hidden:true,
            xtype: 'numbercolumn'
        }, {
            text: '单据编号',
            dataIndex: 'os_code',
            width: 150
        }, {
            text: '日期',
            dataIndex: 'os_date',
            xtype: 'datecolumn',
            width: 110
        }, {
            text: '供应商名称',
            dataIndex: 'os_vendname',
            width:250
        },{
            text: '结算账户',
            dataIndex: 'os_bankname',
            width: 150
        },{
            text: '付款金额',
            dataIndex: 'os_amount',
            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);
            }
        }, {
            text: '单据状态',
            dataIndex: 'os_status',
            width: 90
        },{
            text: '录入人',
            dataIndex: 'creatorName',
            width: 110
        }, {
            text: '审核人',
            dataIndex: 'os_auditman',
            width: 110
        }, {
            text: '支出类别',
            dataIndex: 'osd_type',
            width: 110
        }, {
            text: '明细金额',
            dataIndex: 'osd_nowbalance',
            width: 110
        },{
            text: '备注',
            dataIndex: 'osd_remark',
            width: 250
        }]
    }
});