Ext.define('saas.view.money.othreceipts.QueryPanelController', { extend: 'saas.view.core.query.QueryPanelController', alias: 'controller.money-othreceipts-querypanel', init: function (form) { var me = this; this.control({ //放大镜赋值关系 以及 tpl模板 'dbfindtrigger[name=or_custname]':{ beforerender:function(f){ Ext.apply(f,{ dataUrl:'/api/document/customer/dbfind', addXtype: 'document-customer-formpanel', addTitle: '客户资料', dbfinds:[{ from:'id',to:'or_custid' },{ from:'cu_code',to:'or_custcode' },{ from:'cu_name',to:'or_custname' }], dbtpls:[{ field:'cu_code',width:100 },{ field:'cu_name',width:100 }], dbColumns:[ { conditionCode:'id', "text": "客户ID", "flex": 0, "dataIndex": "id", "width": 0, "xtype": "", "items": null },{ conditionCode:'cu_code', "text": "客户编号", "flex": 1, "dataIndex": "cu_code", "width": 100, "xtype": "", "items": null }, { conditionCode:'cu_name', "text": "客户名称", "flex": 1, "dataIndex": "cu_name", "xtype": "", "items": null }, { conditionCode:'cu_type', "text": "客户类型", "flex": 1, "dataIndex": "cu_type", "width": 200, "xtype": "", "items": null }, { "text": "业务员编号", "flex": 1, "dataIndex": "cu_sellercode", "width": 100 }, { "text": "业务员", "flex": 1, "dataIndex": "cu_sellername", "width": 100 }, { "text": "税率", "flex": 1, "dataIndex": "cu_taxrate", "width": 100, xtype: 'numbercolumn', }, { "text": "承付天数", "flex": 1, "dataIndex": "cu_promisedays", align: 'end', xtype: 'numbercolumn', "width": 100, renderer : function(v) { return Ext.util.Format.number(v, '0'); } }, { "text": "额度", "flex": 1, "dataIndex": "cu_credit", "width": 100, xtype: 'numbercolumn', renderer : function(v) { var arr = (v + '.').split('.'); var xr = (new Array(arr[1].length)).fill('0'); var format = '0,000.' + xr.join(); return Ext.util.Format.number(v, format); } }, { "text": "客户地址", "flex": 1, "dataIndex": "ca_address", "width": 250 }] }) ; } }, //放大镜赋值关系 以及 tpl模板 'dbfindtrigger[name=or_bankname]':{ beforerender:function(f){ Ext.apply(f,{ dataUrl:'/api/document/bankinformation/list', addXtype: 'other-bankinformation', addTitle: '资金账户', dbfinds:[{ from:'bk_bankcode',to:'or_bankcode' },{ from:'bk_bankname',to:'or_bankname' },{ from:'id',to:'or_bankid' }], dbtpls:[{ field:'bk_bankcode',width:100 },{ field:'bk_bankname',width:100 }], dbSearchFields: [{ emptyText: '查找资金账户', xtype: "textfield", name: "search", getCondition: function (v) { return "(upper(bk_bankcode) like '%"+v.toUpperCase()+"%' or upper(bk_bankname) like '%"+v.toUpperCase()+"%')"; }, allowBlank: true, columnWidth: 0.25 }], 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" }] }); } } }); } });