saas-one/frontend/saas-web/app-make/app/view/osmake/reconciliation/QueryPanel3.js

Ext.define('make.view.osmake.reconciliation.QueryPanel_3', {
    extend: 'saas.view.core.query.QueryPanel',
    xtype: 'osmake-reconciliation-querypanel-3',
    controller: 'osmake-reconciliation-querypanel',
    viewModel: {
        extend: 'saas.view.core.query.QueryPanelModel',
        data: {
            form: {}, // 查询字段记录
            addEnable: false, // 显示新增按钮
            auditEnable: false, // 显示审核按钮
            printEnable: false, // 显示打印按钮
            importEnable: false, // 显示导入按钮
            exportEnable: true, // 显示导出按钮
            closeEnable: false, // 显示关闭按钮
            deleteEnable: false, // 显示删除按钮
            deleteDisable:false, //删除按钮是否可使用
            
            openAudit:false,//单独显示审核按钮
            openUnAudit:false,//单独显示反审核按钮
            openEnable:false, //显示开启  针对已取消列表
            configurable: true, // 允许列设置
        }
    },      
    viewName: 'osmake-reconciliation-querypanel',
    caller: 'APCHECKOS',
    initComponent: function () {
        var me=this;
        Ext.apply(this, {
            queryFormItems: [ {
                xtype: 'condatefield',
                name: 'pi_date',
                fieldLabel: '日期',
                columnWidth: 0.5,
                value:1, 
                operation: 'between',  
                showCurrentMonth:true
            },{
                xtype: 'multiqueryField',
                columnWidth: 0.4,
                name: 'multi_query',
                querys: {          
                    "Vend":{"field": "pi_vendname", "dbfinds": [{//供应商
                        from: 've_name',
                        to: 'pi_vendname'
                     }]},
                     "Currency":{"field": "pi_currency", "dbfinds": [{
                        from: 'cr_name',
                        to: 'pi_currency'
                     }]}
                }
            }],
            moreQueryFormItems:[{
                xtype: 'condatefield',
                name: 'pi_date',
                fieldLabel: '单据日期',
                columnWidth: 1
            },{
                xtype: 'vendorDbfindTrigger',
                name: 'pi_vendname',
                fieldLabel: '供应商名称'
            },{
                xtype: 'combobox',
                name: 'pi_currency',
                fieldLabel: '币别',
                queryMode: 'local',
                displayField: 'pi_currency',
                valueField: 'pi_currency',
                emptyText :'',
                editable:false,
                store: Ext.create('Ext.data.ArrayStore', {
                fields: ['pi_currency', 'pi_currency'],
                data: [
                    ["RMB", "RMB"],
                    ["USD", "USD"],
                    ["HKD", "HKD"]
                ]
                }),
                getCondition: function(value) {
                    if(!value) {
                        return '1=1';
                    }else {
                        return 'pi_currency=\'' + value + '\'';
                    }
                }
            }],
            queryGridConfig:{
                idField: 'id',
                codeField: '',
                mainIdField:'_id',
                detailIdField:'ad_id',
                addTitle: '外协对账单',
                addXtype: 'osmake-reconciliation-formpanel',
                defaultCondition: me.defaultCondition,
                baseVastUrl: '/api/money/apcheck/',
                caller: 'APCHECKOS', 
                selModel: {
                    type: 'cellmodel'
                },

                baseColumn: [{
                    text : 'id', 
                    hidden:true,
                    dataIndex : 'id', 
                    xtype : 'numbercolumn',   
                },{
                    text : '对账单号', 
                    dataIndex : 'ac_code',
                    width:150
                },{
                    text : 'ac_b2bid', 
                    hidden:true,
                    dataIndex : 'ac_b2bid', 
                    xtype : 'numbercolumn',   
                },{
                    text : 'accountId', 
                    hidden:true,
                    dataIndex : 'accountId', 
                    xtype : 'numbercolumn',     
                },{
                    text : 'ac_sendstatus', 
                    hidden:true,
                    dataIndex : 'ac_sendstatus'
                },{
                    text : '供应商编号', 
                    dataIndex : 'ac_vendcode', 
                    hidden:true
                },{
                    text : '供应商名称', 
                    dataIndex : 'ac_vendname', 
                    width:150
                },{
                    text: '对账期间',
                    dataIndex: 'period',
                    width: 200
                }, {
                    text: '对账时间',
                    xtype: 'datecolumn',
                    format: 'Y-m-d',
                    dataIndex: 'ac_date',
                    width: 110
                },{
                    text : '币种',
                    width : 90.0, 
                    dataIndex : 'ac_currency', 
                },{
                    text : '对账总额', 
                    dataIndex : 'ac_checkamount',
                    xtype:'numbercolumn', 
                    width : 110.0,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFixFormat(v, 2, true);
                    }
                }, {
                    text : '单据状态',
                    textAlign: 'center',
                    dataIndex : 'ac_status', 
                }],
                relativeColumn: [{
                    text : '供应商名称', 
                    dataIndex : 'ac_vendname', 
                    width:300
                },{
                    text : '币种',
                    width : 90.0, 
                    dataIndex : 'ac_currency', 
                },{
                    text : '本期入库金额(元)', 
                    dataIndex : 'ac_thissend',
                    xtype:'numbercolumn', 
                    width : 170.0,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFixFormat(v, 2, true);
                    }
                },{
                    text : '本期未对账(元)', 
                    dataIndex : 'ac_thisuncheck',
                    xtype:'numbercolumn', 
                    width : 170.0,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFixFormat(v, 2, true);
                    }
                },{
                    text : '本期已对账(元)', 
                    dataIndex : 'ac_thischeck',
                    xtype:'numbercolumn', 
                    width : 170.0,
                    renderer: function(v, m, r) {
                        return saas.util.BaseUtil.numberFixFormat(v, 2, true);
                    }
                }, {
                    text: '操作',
                    xtype:'buttoncolumn',
                    align: 'center',
                    vertical: true,
                    dataIndex:'ac_confirmstatuscode',
                    ignoreExport: true,
                    width: 120,
                    buttons: [{
                        text: '明细',
                        handler: 'showDetail'
                    }]
                }]
            }
        });
        this.callParent(arguments);
    },
    getQueryMode: function () {
        return 'PRODIO';
    }
});