Ext.define('erp.view.ma.MyDataList',{ extend: 'Ext.grid.Panel', alias: 'widget.mydatalist', layout : 'fit', id: 'grid',//'datalist', emptyText : $I18N.common.grid.emptyText, columnLines : true, autoScroll : true, store: [], columns: [], plugins: Ext.create('Ext.grid.plugin.CellEditing', { clicksToEdit: 1 }), GridUtil: Ext.create('erp.util.GridUtil'), bbar: {xtype: 'erpToolbar'}, initComponent : function(){ condition = getUrlParam('gridCondition'); condition = condition != null ? condition.replace(/IS/g, '=') : null; whoami = (condition != null && condition !="")? condition.split('=')[1].replace(/'/g, ''):""; if(whoami == ''){ this.GridUtil.getGridColumnsAndStore(this, 'common/singleGridPanel.action', {caller: caller, condition: gridCondition, _m: 0}); } else { this.getGridColumnsAndStore(); } this.callParent(arguments); }, listeners: { afterrender: function() { this.down('erpToolbar').add({ id: 'erpSetComboButton', text: '重置下拉框', cls: 'x-btn-blue' },{ xtype:'erpComboButton', cls: 'x-btn-blue' }); } }, detno: 'dld_detno', caller: 'DataList', necessaryFields:['dld_field'], getGridColumnsAndStore: function(){ var grid = this; var main = parent.Ext.getCmp("content-panel"); if(!main) main = parent.parent.Ext.getCmp("content-panel"); if(main){ main.getActiveTab().setLoading(true);//loading... } Ext.Ajax.request({//拿到grid的columns url : basePath + 'common/singleGridPanel.action', async: false, params: { caller: grid.caller, condition: condition }, method : 'post', callback : function(options,success,response){ if(main){ main.getActiveTab().setLoading(false); } var res = new Ext.decode(response.responseText); if(res.exceptionInfo){ showError(res.exceptionInfo);return; } if(res.columns){ grid.columns = res.columns; grid.fields = res.fields; grid.columns.push({ xtype: 'checkcolumn', text: '配置', width: 60, dataIndex: 'deploy', cls: "x-grid-header-1", locked: true, editor: { xtype: 'checkbox', cls: "x-grid-checkheader-editor" } }); grid.fields.push({name: 'deploy', type: 'bool'}); //renderer grid.getRenderer(); var data = Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']')); Ext.each(data, function(d){ d.deploy = true; }); grid.data = data; if(res.dbfinds.length > 0){ grid.dbfinds = res.dbfinds; } //取数据字典配置 var tab = data[0].dld_table; if(tab) { grid.getDataDictionaryData(tab.split(' ')[0]); } grid.reconfigureGrid(); } } }); }, getRenderer: function(){ var grid = this; Ext.each(grid.columns, function(column, y){ //logictype var logic = column.logic; if(logic == 'detno'){ grid.detno = column.dataIndex; } else if(logic == 'keyField'){ grid.keyField = column.dataIndex; } else if(logic == 'mainField'){ grid.mainField = column.dataIndex; } else if(grid.necessaryFields.indexOf(column.dataIndex)>-1){ if(!column.haveRendered){ column.renderer = function(val, meta, item){ if(item.data['dld_id'] != null && item.data['dld_id'] != '' && item.data['dld_id'] != '0' && item.data['dld_id'] != 0) { return '' + '' + val + ''; } else { return '' + '' + val + ''; } }; } } else if(logic == 'groupField'){ grid.groupField = column.dataIndex; } }); }, reconfigureGrid: function(){ var grid = this; grid.store = Ext.create('Ext.data.Store', { storeId: 'gridStore', fields: grid.fields, data: grid.data, groupField: grid.groupField }); }, getDataDictionaryData: function(tablename){ var me = this,data = this.data; Ext.Ajax.request({ url : basePath + 'ma/getDataDictionary.action', async: false, params: { table: tablename }, method : 'post', callback : function(options,success,response){ var res = new Ext.decode(response.responseText); if(res.exceptionInfo){ showError(res.exceptionInfo);return; } else if(res.success) { //取Max(序号) var dets = Ext.Array.pluck(data, me.detno); Ext.Array.sort(dets, function(a, b){ return b - a; }); var det = dets[0]; //data里面包含的字段 var sel = Ext.Array.pluck(data, 'dld_field'); var o = null; Ext.each(res.datadictionary, function(d, index){ //将DataDictionary的数据转化成DataListDetail数据 if(!Ext.Array.contains(sel, d.column_name)){ o = new Object(); o.dld_table = d.table_name; o.dld_field = d.column_name; o.dld_caption = d.comments; o.dld_caption_fan = d.comments; o.dld_caption_en = d.comments; o.dld_editable = false; o.dld_width = 80; o.deploy = false; o.dld_caller = whoami; if(contains(d.data_type, 'VARCHAR2', true)){ o.dld_fieldtype = 'S'; } else if(contains(d.data_type, 'TIMESTAMP', true)){ o.dld_fieldtype = 'DT'; }else if(d.data_type == 'DATE'){ o.dld_fieldtype = 'D'; } else if(d.data_type == 'NUMBER'){ o.dld_fieldtype = 'N'; } else if(d.data_type == 'FLOAT'){ o.dld_fieldtype = 'N'; } else { o.dld_fieldtype = 'S'; } o.dld_detno = ++det; data.push(o); } }); } } }); }, getDeleted: function(){ var grid = this,items = grid.store.data.items,key = grid.keyField,deleted = new Array(),d = null; Ext.each(items, function(item){ d = item.data; if(item.dirty && !Ext.isEmpty(d[key]) && d['deploy'] == false) { deleted.push(grid.removeKey(d, 'deploy')); } }); return deleted; }, getAdded: function(){ var grid = this,items = grid.store.data.items,key = grid.keyField,added = new Array(),d = null; Ext.each(items, function(item){ d = item.data; if(item.dirty && d[key] == 0 && d['deploy'] == true) { added.push(grid.removeKey(d, 'deploy')); } }); return added; }, getUpdated: function(){ var grid = this,items = grid.store.data.items,key = grid.keyField,updated = new Array(),d = null; Ext.each(items, function(item){ d = item.data; if(item.dirty && !Ext.isEmpty(d[key]) && d[key] != 0 && d['deploy'] == true) { updated.push(grid.removeKey(d, 'deploy')); } }); return updated; }, removeKey: function(d, key){ var a = new Object(),keys = Ext.Object.getKeys(d); Ext.each(keys, function(k){ if(k != key) { a[k] = d[k]; } }); return a; }, getChange: function(){ var grid = this,items = grid.store.data.items,key = grid.keyField, added = new Array(),updated = new Array(),deleted = new Array(),d = null,e = null; Ext.each(items, function(item){ d = item.data; if (item.dirty) { e = grid.removeKey(d, 'deploy'); if(d[key] == 0 && d['deploy'] == true) { added.push(e); } if(!Ext.isEmpty(d[key]) && d[key] != 0 && d['deploy'] == true) { updated.push(e); } if(!Ext.isEmpty(d[key]) && d['deploy'] == false) { deleted.push(e); } } }); return { added: added, updated: updated, deleted: deleted }; } });