uas6.0/WebContent/app/view/ma/MyDataList.js

Ext.define('erp.view.ma.MyDataList',{ 
	extend: 'Ext.grid.Panel', 
	alias: 'widget.mydatalist',
	layout : 'fit',
	//id: 'datalist', 
	id: 'grid',
 	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, '=') : "";
	 	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'
			});
		}
	},
	detno: 'dld_detno',
	caller: 'DataList',
	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 != null){
				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(logic == 'necessaryField'){
					grid.necessaryField = column.dataIndex;
					if(!grid.necessaryFields){
						grid.necessaryFields = new Array();
					}
					grid.necessaryFields.push(column.dataIndex);
				} 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的数据转化成FormDetail数据
        				if(!Ext.Array.contains(sel, d.ddd_fieldname)){
        					o = new Object();
            				o.dld_table = d.ddd_tablename;
            				o.dld_field = d.ddd_fieldname;
            				o.dld_caption = d.ddd_description;
            				o.dld_caption_fan = d.ddd_description;
            				o.dld_caption_en = d.ddd_description;
            				o.dld_editable = false;
            				o.dld_width = 80;
            				o.deploy = false;
            				o.dld_caller = whoami;
            				if(contains(d.ddd_fieldtype, 'varchar2', true)){
            					o.dld_fieldtype = 'S';
            				} else if(contains(d.ddd_fieldtype, 'number', true)){
            					o.dld_fieldtype = 'N';
            				} else if(d.ddd_fieldtype == 'timestamp'){
            					o.dld_fieldtype = 'DT';
            				} else if(d.ddd_fieldtype == 'date'){
            					o.dld_fieldtype = 'D';
            				} else if(d.ddd_fieldtype == 'int'){
            					o.dld_fieldtype = 'N';
            				} else if(d.ddd_fieldtype == '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
		};
	}
});