Ext.define('saas.view.money.verification.QueryPanelController', { extend: 'saas.view.core.query.QueryPanelController', alias: 'controller.money-verification-querypanel', init: function (form) { var me = this; this.control({ //放大镜赋值关系 以及 tpl模板 'dbfindtrigger[name=pu_vendname]':{ beforerender:function(f){ Ext.apply(f,{ dataUrl: '/api/document/vendor/list', addXtype: 'document-vendor-formpanel', addTitle: '供应商资料', dbfinds:[{ from:'ve_code',to:'pu_vendcode' },{ from:'ve_name',to:'pu_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": "供应商编号", "flex": 1, "dataIndex": "ve_code", "width": 100 }, { "text": "供应商名称", "flex": 1, "dataIndex": "ve_name", "width": 100 }, { "text": "供应商类型", "flex": 0, "dataIndex": "ve_type", "width": 200, "items": null }, { "text": "税率", "flex": 1, "dataIndex": "ve_taxrate", "width": 100 }, { "text": "承付天数", "flex": 1, "dataIndex": "ve_promisedays", "width": 100 }, { "text": "纳税人识别号", "flex": 1, "dataIndex": "ve_bankaccount", "width": 100 }, { "text": "开户银行", "flex": 1, "dataIndex": "ve_bankaccount", "width": 100 }, { "text": "银行账户", "flex": 1, "dataIndex": "ve_bankcode", "width": 100 }] }) ; } }, //放大镜赋值关系 以及 tpl模板 'dbfindtrigger[name=pd_prodcode]':{ beforerender:function(f){ Ext.apply(f,{ conditionCode:'pr_code', dataUrl: '/api/document/product/list', addXtype: 'document-product-formpanel', addTitle: '物料资料', dbfinds:[{ from:'pr_code',to:'pd_prodcode', }, { from:'pr_detail',to:'pr_detail' }], dbtpls:[{ field:'pr_code',width:100 },{ field:'pr_detail',width:100 }], defaultCondition: "pr_statuscode='OPEN'", dbSearchFields:[{ emptyText:'输入物料编号、名称或规格', xtype : "textfield", name : "search", width: 200, getCondition: function(v) { return "(upper(pr_spec) like '%" + v.toUpperCase()+"%' or upper(pr_code) like '%"+v.toUpperCase()+"%' or upper(pr_detail) like '%"+v.toUpperCase()+"%')"; }, allowBlank : true, columnWidth : 0.25 }], dbColumns:[{ "text": "物料ID", "hidden": true, "dataIndex": "id", }, { "text": "物料编号", "dataIndex": "pr_code", "width": 200, }, { "text": "物料名称", "width": 200, "dataIndex": "pr_detail", }, { "text": "规格", "dataIndex": "pr_spec", "width": 100, }, { "text": "单位", "dataIndex": "pr_spec", "width": 100, },{ "text": "仓库id", "dataIndex": "pr_whid", "hidden": true, },{ "text": "仓库编号", "dataIndex": "pr_whcode", "hidden": true, },{ "text": "仓库", "dataIndex": "pr_whname", "width": 200, },{ "text": "总库存数", "dataIndex": "po_onhand", "width": 100, },{ "text": "类型", "dataIndex": "pr_kind", "width": 100, },{ "text": "型号", "dataIndex": "pr_orispeccode", "width": 100, },{ "text": "品牌", "dataIndex": "pr_brand", "width": 100, },{ "text": "供应商", "dataIndex": "pr_vendname", "width": 100, },{ "text": "最小包装", "dataIndex": "pr_zxbzs", "width": 100, },{ "text": "L/T", "dataIndex": "pr_leadtime", "width": 100, }] }) ; } } }); } });