Ext.define('saas.view.money.othspendings.QueryPanelController', { extend: 'saas.view.core.query.QueryPanelController', alias: 'controller.money-othspendings-querypanel', init: function (form) { var me = this; this.control({ //放大镜赋值关系 以及 tpl模板 'dbfindtrigger[name=os_vendname]':{ beforerender: function (f) { Ext.apply(f, { dataUrl: '/api/document/vendor/list', addXtype: 'document-vendor-formpanel', addTitle: '供应商资料', dbfinds: [{ from: 'id', to: 'os_vendid' }, { from: 've_code', to: 'os_vendcode' }, { from: 've_name', to: 'os_vendname' }], dbtpls: [{ field: 've_code', width: 100 }, { field: 've_name', width: 100 }], defaultCondition: "ve_statuscode='OPEN'", dbSearchFields:[{ emptyText:'输入供应商编号或名称', xtype : "textfield", name : "search", getCondition: function(v) { return "(upper(ve_code) like '%"+v.toUpperCase()+"%' or upper(ve_name) like '%"+v.toUpperCase()+"%')"; }, allowBlank : true, columnWidth : 0.25 }], dbColumns:[{ "text": "供应商ID", "hidden": true, "dataIndex": "id", "width": 100, "xtype": "numbercolumn" },{ "text": "供应商编号", "dataIndex": "ve_code", "width": 200 }, { "text": "供应商名称", "dataIndex": "ve_name", "width": 200 }, { "text": "供应商类型", "dataIndex": "ve_type", "width": 180, "items": null }, { "text": "税率", "dataIndex": "ve_taxrate", "width": 100, xtype: 'numbercolumn', align: 'end' }, { "text": "承付天数", "dataIndex": "ve_promisedays", "width": 100, xtype: 'numbercolumn', align: 'end' }, { "text": "纳税人识别号", "dataIndex": "ve_bankaccount", "width": 150 }, { "text": "开户银行", "dataIndex": "ve_bankaccount", "width": 100 }, { "text": "银行账户", "dataIndex": "ve_bankcode", "width": 100 }] }); } }, //放大镜赋值关系 以及 tpl模板 'dbfindtrigger[name=os_bankname]':{ beforerender:function(f){ Ext.apply(f,{ conditionCode:'os_bankcode', dataUrl:'/api/document/bankinformation/list', dbfinds:[{ from:'bk_bankcode',to:'os_bankcode' },{ from:'bk_bankname',to:'os_bankname' },{ from:'id',to:'os_bankid' }], dbtpls:[{ field:'bk_bankcode',width:100 },{ field:'bk_bankname',width:100 }], dbColumns:[{ "text": "账户ID", "flex": 0, "dataIndex": "id", "width": 0, "xtype": "" },{ "text": "账户编号", "flex": 1, "dataIndex": "bk_bankcode", "width": 120, "xtype": "" }, { "text": "账户名称", "flex": 1, "dataIndex": "bk_bankname", "width": 150, "xtype": "" }, { "text": "账户类型", "flex": 1, "dataIndex": "bk_type", "width": 120, "xtype": "" }, { "text": "账户余额", "flex": 1, "dataIndex": "bk_thisamount", "width": 120, xtype: 'numbercolumn', }, { "text": "建帐日期", "flex": 1, "dataIndex": "bk_date", "width": 120, "xtype": "datecolumn" }] }) ; } } }); } });