Ext.define('uas.view.trigger.DbfindTriggerPanel', { extend: 'Ext.grid.Panel', xtype: 'dbfindtriggerpanel', dataUrl: '', dbSearchFields: [], condition:'', plugins: { gridHeaderFilter: true }, dockedItems: [{ name:'operateToolbar', cls:'x-grid-operateToolbar', xtype: 'toolbar', dock: 'top', height:32, items:[{ cls:'x-btn-blue', xtype:'button', text:'筛选', handler:function(me){ const grid = me.up('dbfindtriggerpanel'); if(!grid.searchPlanWindow){ grid.searchPlanWindow = Ext.create('widget.searchPlanWindow',{ modal: false, height:grid.getHeight()*0.95, width:grid.getWidth()*0.95, renderTo:grid.ownerCt.getEl(), grid:grid }).show(); }else{ grid.searchPlanWindow.show(); } } },{ margin:'0 0 0 6', xtype:'button', text:'批处理' },{ margin:'0 0 0 6', xtype:'button', text:'上一页' },{ margin:'0 0 0 6', xtype:'button', text:'下一页' },{ margin:'0 0 0 6', xtype:'button', text:'导出' },{ margin:'0 0 0 6', xtype:'button', text:'个性设置' },{ margin:'0 0 0 12', xtype:'button', text:'关闭' }] },{ xtype: 'toolbar', dock: 'top', name:'searchPlan', cls:'x-grid-searchPlan', height:32, items:[{ xtype:'displayfield', value:'查询方案:' }] },{ xtype: 'toolbar', dock: 'top', name:'filterToolbar', cls:'x-grid-filterToolbar', height:32, items:[{ xtype:'displayfield', value:'筛选条件:' },'->'] },{ xtype: 'dataListPaging' }], initComponent: function() { var me = this; me.initColumns(); if(me.columns){ var fields = me.columns.map(column => column.dataIndex); me.store = Ext.create('Ext.data.Store',{ fields:fields, autoLoad: true, pageSize: 10, grid:me, data: [], proxy: { type: 'ajax', timeout:8000, url: me.dataUrl, actionMethods: { read: 'GET' }, reader: { type: 'json', rootProperty: 'data.list', totalProperty: 'data.total', }, listeners: { exception: function(proxy, response, operation, eOpts) { if(operation.success) { if(response.timedout) { saas.util.BaseUtil.showErrorToast('请求超时'); } }else { console.error('exception: ', response); saas.util.BaseUtil.showErrorToast('查询失败:' + (response.responseJson?response.responseJson.message:'请求超时')); } } } }, listeners: { beforeload: function (store, op) { var condition = me.condition; if (Ext.isEmpty(condition)) { condition = []; } //添加默认条件 if(me.up('window').trigger.defaultCondition) { condition.push({ type: 'condition', value: me.ownerCt.trigger.defaultCondition }); } Ext.apply(store.proxy.extraParams, { number: op._page, size: store.pageSize, condition: JSON.stringify(condition) }); }, load: function(store, records, successful, operation, eOpts) { const grid = store.grid; const paging = grid.down('[xtype=dataListPaging]'); const pageCountItem = paging.down('#pageCountItem'); const dataCount = paging.down('#dataCountItem'); if(store.totalCount!==Number.MAX_SAFE_INTEGER){ //展示*号 if(store.currentPage===Number.MAX_SAFE_INTEGER){ let page = store.totalCount/store.pageSize; page = page>parseInt(page)?page+1:page; store.currentPage = page; paging.down('#inputItem').setValue(page); } pageCountItem.update(Ext.String.format(paging.afterPageText,store.currentPage)); dataCount.setValue("行/共"+store.totalCount+"行"); } } } }); } me.callParent(arguments); me.getSearchPlan(); }, listeners:{ itemClick: function(view,record) { var me = this; var dbfinds = me.dbfinds; var ownerTrigger = me.ownerCt.trigger; ownerTrigger.dbValues = record.data; if(dbfinds&&dbfinds.length>0){ if(me.belong=='grid'){ for (let index = 0; index < dbfinds.length; index++) { var item = dbfinds[index]; var mainGrid = me.dbfindtrigger.column.ownerCt.ownerCt; var rec = mainGrid.selModel.getLastSelected(); if(rec){ var nowRec = me.dbfindtrigger.column.ownerCt.ownerCt.store.getData().getByKey(rec.id); nowRec.set(item.to,record.get(item.from)); //me.column.getEditor().setValue(record.get(item.from)); //mainGrid.up('detailGridField').fireEvent('edit'); } } }else if(me.belong=='form'){ for (let index = 0; index < dbfinds.length; index++) { var item = dbfinds[index]; var field = me.ownerCt.belong.down('[name='+item.to+']'); if(field){ var val = record.get(item.from); if(field.xtype=='dbfindtrigger'){ field.setValue(val); field.lastTriggerValue=val; }else{ field.setValue(val); } } } }else { var dbfind = Ext.Array.findBy(dbfinds, function(d) { return d.to = ownerTrigger.name; }); if(dbfind) { ownerTrigger.setValue(record.get(dbfind.from)); } } ownerTrigger.aftertrigger(ownerTrigger,record); } me.ownerCt.close(); } }, initColumns: function() { var me = this, columns = me.columns || []; Ext.Array.each(columns, function(c) { Ext.applyIf(c, { width: 200 }); }); }, getSearchFields: function() { var me = this, searchFields = me.dbSearchFields; Ext.Array.each(searchFields, function(f) { f.enableKeyEvents = true; f.listeners = { keydown: function(th, e, eOpts) { if(e.keyCode == 13) { me.condition = '', items = []; Ext.Array.each(searchFields,function(f) { var field = th.ownerCt.down('[name='+f.name+']') items.push(field); }); me.condition = me.getCondition(items); me.store.loadPage(1); } } } }); return searchFields; }, /** * 获得过滤条件 */ getCondition: function(items) { var me = this, conditions = []; for(var i = 0; i < items.length; i++) { var item = items[i]; var field = item.name, func = item.getCondition, value = item.value, condition; if(value&&value!=''){ if(typeof func == 'function') { condition = { type: 'condition', value: func(value) } }else { var xtype = item.xtype || 'textfield', type = item.fieldType || me.getDefaultFieldType(xtype), operation = item.operation || me.getDefaultFieldOperation(xtype), conditionValue = me.getConditionValue(xtype, value); if(!conditionValue) { continue; } condition = { type: type, field: field, operation: operation, value: conditionValue } } conditions.push(condition); } }; return conditions; }, getDefaultFieldType: function(xtype) { var type; if(Ext.Array.contains(['numberfield'], xtype)) { type = 'number'; }else if(Ext.Array.contains(['datefield', 'condatefield'], xtype)) { type = 'date'; }else if(Ext.Array.contains(['combobox', 'multicombo', 'combo', 'radiofield', 'radio'], xtype)) { type = 'enum'; }else { type = 'string'; } return type; }, getDefaultFieldOperation: function(xtype) { var operation; if(Ext.Array.contains(['numberfield'], xtype)) { operation = '='; }else if(Ext.Array.contains(['datefield'], xtype)) { operation = '='; }else if(Ext.Array.contains(['condatefield'], xtype)) { operation = 'between'; }else if(Ext.Array.contains(['combobox', 'multicombo', 'combo'], xtype)) { operation = 'in'; }else { operation = 'like'; } return operation; }, /** * 处理部分字段值 */ getConditionValue: function(xtype, value) { var conditionValue; if(xtype == 'datefield') { conditionValue = Ext.Date.format(new Date(from), 'Y-m-d H:i:s'); }else if(xtype == 'condatefield') { var from = value.from, to = value.to; conditionValue = Ext.Date.format(new Date(from), 'Y-m-d 00:00:00') + ',' + Ext.Date.format(new Date(to), 'Y-m-d 23:59:59'); }else if(xtype == 'combobox' || xtype == 'combo') { conditionValue = '\'' + value + '\''; }else if(xtype == 'multicombo') { conditionValue = value.map(function(v) { return '\'' + v.value + '\''; }).join(','); }else { conditionValue = value; } return conditionValue; }, onAddClick: function(){ var grid = this; var trigger = grid.ownerCt.trigger; saas.util.BaseUtil.openTab(trigger.addXtype, '新增'+trigger.addTitle,trigger.addXtype + '_add'); }, getSearchPlan:function(){ const me = this; Ext.Ajax.request({ url: me.searchUrl, params: '', method: 'GET', async:false, success: function(response, opts) { var _data = Ext.decode(response.responseText); if(_data&&_data.data){ const searchPlan = me.down('[name=searchPlan]'); let items = []; Ext.Array.each(_data.data,function(p){ if(p.children&&p.children.length>0){ Ext.Array.each(p.children,function(item){ items.push({ text:item.text, xtype:'button' }) }) } }); searchPlan.add(items); } }, failure: function(response, opts) {} }); } });