Ext.define('saas.view.stock.report.ProdinoutCountController', { extend: 'saas.view.core.report.ReportPanelController', alias: 'controller.stock-report-prodinoutCount', init: function (form) { this.control({ //放大镜赋值关系 以及 tpl模板 'dbfindtrigger[name=pd_prodcode]':{ beforerender:function(f){ Ext.apply(f,{ dataUrl:'/api/document/product/list', addXtype: 'document-product-formpanel', addTitle: '物料资料', dbfinds:[ { from:'pr_code',to:'pd_prodcode' }, { from:'pr_detail',to:'pr_detail' }, { from:'pr_spec',to:'pr_spec' }], 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_unit", "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, align:'right' },{ "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, align:'right' },{ "text": "L/T", "dataIndex": "pr_leadtime", "width": 100, }] }) ; } }, 'dbfindtrigger[name=wh_description]':{ beforerender:function(f){ Ext.apply(f,{ conditionCode:'wh_code', dataUrl:'/api/document/warehouse/list', addXtype: 'other-storeinformation', addTitle: '仓库资料', dbfinds:[{ from:'id',to:'id',ignore:true }, { from:'wh_code',to:'wh_code' }, { from:'wh_description',to:'wh_description' }], dbtpls:[{ field:'wh_code',width:100 },{ field:'wh_description',width:100 }], defaultCondition: "wh_statuscode='OPEN'", dbSearchFields:[{ emptyText:'输入物料编号、名称或规格', xtype : "textfield", name : "search", width: 200, getCondition: function(v) { return "(upper(wh_code) like '%" + v.toUpperCase()+"%' or upper(wh_description) like '%"+v.toUpperCase()+"%')"; }, allowBlank : true, columnWidth : 0.25 }], dbColumns:[{ "text": "仓库ID", "flex": 0, "dataIndex": "id", "width": 0, "xtype": "", "items": null },{ "text": "仓库编号", "flex": 1, "dataIndex": "wh_code", "width": 100, "xtype": "", "items": null }, { "text": "仓库名称", "flex": 1, "dataIndex": "wh_description", "xtype": "", "items": null }, { "text": "仓库类型", "flex": 0, "dataIndex": "wh_type", "width": 200, "xtype": "", "items": null }, { "text": "仓库状态", "flex": 0, "dataIndex": "wh_status", "width": 200, "xtype": "", "items": null }] }) ; } } }); } });