mes/WebContent/app/view/ma/DataDictionary.js

Ext.define('erp.view.ma.DataDictionary',{ 
	extend: 'Ext.Viewport', 
	layout: 'border', 
	hideBorders: true, 
	initComponent : function(){ 
		var me = this; 
		Ext.apply(me, { 				
			items: [{
				xtype:'form',
				frame:true,
				region:'north',
				layout:'column',
				defaults:{
					cls: "form-field-allowBlank",
					xtype:'textfield',
					focusCls: 'x-form-field-cir-focus',
					fieldStyle: "background:#FFFAFA;color:#515151;",
					columnWidth:0.5
				},
				items:[{
					fieldLabel:'表名',
					allowBlank:false,
					name:'object_name'				
				},{				
					fieldLabel:'注释',			
					allowBlank:false,
					name:'comments',
					xtype:'textareatrigger'
				},{
					fieldLabel:'ID',
					name:'object_id',
					hidden:true
				}],
				bbar:['->',{ 
					xtype: 'button', 
					cls: 'x-btn-blue',
					text: '新增',
					itemId:'add',
					width: 80,
					margin: '0 0 0 5'
				},{ 
					xtype: 'button', 
					cls: 'x-btn-blue',
					text: '保存',
					itemId:'save',
					formBind: true,
					width: 80,
					margin: '0 0 0 5'
				},{
					xtype: 'button', 
					cls: 'x-btn-blue',
					text: '关闭',
					width: 80,
					itemId:'close',
					margin: '0 0 0 5'  
				},'->']		
			},{
				xtype:'tabpanel',
				region:'center',
				id:'dictab',
				items:[{
					title:'列信息',					
					xtype: 'dictionarygrid'
				},{
					title:'索引',
					layout:'border',
					items:[{
						region:'west',
						width:300,
						xtype:'panel',
						layout:'fit',
						frame:true,
						dockedItems:{
							dock : 'top',
							/*ui: 'footer',*/
							xtype:'toolbar',
							items:[{
								xtype:'label',
								html:'<h1>索引名称</h1>'
							},{
								xtype:'button',
								iconCls:'x-button-icon-add',
								text:'添加',
								itemId:'add_index'
							},{
								xtype:'button',
								iconCls:'x-button-icon-delete2',
								text:'删除',
								itemId:'delete_index'
							}]
						},
						items:[{
							xtype:'boundlist',
							deferInitialRefresh: false,
							multiSelect: true,
							store: me.store,
							name:'tab_indexs',
							itemSelector:'li',
							displayField:'index_name',
							border: false,
							disabled: false,
							store:Ext.create('Ext.data.Store', {
								fields: [ {name: 'index_name'},
								          {name:'uniqueness'},
								          {name:'ind_columns'}],
								          proxy: {
								        	  type: 'ajax',
								        	  url: basePath+'/common/getColumnIndex.action',
								        	  extraParams :{
								        		  tablename:tablename
								        	  },
								        	  reader: {
								        		  idProperty:'index_name',
								        		  type: 'json',
								        		  root: 'list'
								        	  }
								          },
								          autoLoad:true   
							})
						}]
					},{
						region:'center',
						layout: 'anchor',
						style:'margin-top:10px',
						xtype:'container',
						items:[{
							xtype:'textfield',
							fieldLabel:'索引名称',
							name:'index_name',
							id:'index_name',
							anchor:'100%',
							maxWidth:400,
							frame:true
						},{
							xtype: 'radiogroup',
							fieldLabel: '唯一性',
							layout: 'column',
							name:'uniqueness',
							id:'uniqueness',
							defaults: {
								columnWidth:1,
								labelStyle: 'padding:4px;'
							},
							items: [{boxLabel: '唯一', name: 'uniqueness', inputValue: 'UNIQUE'},
							        {boxLabel: '不唯一', name: 'uniqueness', inputValue: 'NONUNIQUE', checked: true}]
						},{
							xtype:'gridpanel',
							id:'index_column_grid',
							columnLines:true,
							plugins:[Ext.create('Ext.grid.plugin.CellEditing', {
								clicksToEdit: 1,
							})],
							tbar:[{
								xtype:'label',
								html:'<h1>表达式</h1>'
							},{
								xtype:'button',
								iconCls:'x-button-icon-add',
								text:'添加',
								itemId:'add_ind_column'
							},{
								xtype:'button',
								iconCls:'x-button-icon-delete2',
								text:'删除',
								itemId:'delete_ind_column'
							}],
							columns:[{
								text:'索引字段',
								dataIndex:'COLUMN_NAME',
								cls: "x-grid-header-1",
								width:200,
								editor:{
									xtype:'combo',
									queryMode: 'local',
									displayField: 'column_name',
									valueField: 'column_name',
									store:Ext.create('Ext.data.Store',{
										fields:['column_name'],
										data:[]
									}),
									onTriggerClick:function(trigger){
										var me=this,store=this.getStore();
										if(store.totalCount<1){		
											store.loadRecords(Ext.getCmp('grid').getStore().data.items);
										}
										if (!me.readOnly && !me.disabled) {
											if (me.isExpanded) {
												me.collapse();
											} else {
												me.expand();
											}
											me.inputEl.focus();
										}    
									}
								}
							},{
								text:'排序',
								dataIndex:'DESCEND',
								cls: "x-grid-header-1",
								width:100,
								editor:{
									xtype:'combo',
									queryMode: 'local',
									displayField: 'display',
									valueField: 'value',
									store:Ext.create('Ext.data.Store',{
										fields:['display','value'],
										data:[{
											display:'ASC',
											value:'ASC'
										},{
											display:'DESC',
											value:'DESC'
										}]
									})
								}
							}],
							store:Ext.create('Ext.data.Store',{
								fields:['COLUMN_NAME','DESCEND'],
								data:[]
							})
						}]

					}]
				},{
					title:'修改日志',
					listeners:{
						activate:function(tab){
							if(!tab.loaded && tablename){
								Ext.Ajax.request({
									method: 'post',
									url : basePath + '/common/getFieldsDatas.action',
									params :{
										caller:'DB$LOG',
										fields:'alter_type,alter_remark,alter_date,alter_man',
										condition:"table_name='"+tablename+"'"
									},
									callback : function(options, success, response){					  				
										var res = new Ext.decode(response.responseText);
										tab.loaded=true;
										tab.getStore().loadData(new Ext.decode(res.data));
									}
								});	
							}
						}
					},
					xtype:'gridpanel',
					id:'log-grid',
					loaded:false,
					columnLines:true,
					plugins: [Ext.create('erp.view.core.grid.HeaderFilter')],
					columns:[{
						text:'操作描述',
						dataIndex:'ALTER_REMARK',
						flex:1,
						filter: {xtype:"textfield", filterName:"ALTER_REMARK"}
					},{
						text:'操作类型',
						dataIndex:'ALTER_TYPE',
						width:80,
						filter: {xtype:"textfield", filterName:"ALTER_TYPE"}
					},{
						text:'操作人',
						width:150,
						filter: {xtype:"textfield", filterName:"ALTER_MAN"},
						dataIndex:'ALTER_MAN'
					},{
						text:'操作时间',
						xtype:'datecolumn',
						format:'Y-m-d H:i:s',
						width:150,
						filter: {xtype:"textfield", filterName:"ALTER_DATE"},
						dataIndex:'ALTER_DATE'
					}],
					store:Ext.create('Ext.data.Store', {
						fields: [ {name: 'alter_remark'},
						          {name:'alter_type'},
						          {name:'alter_man'},{
						        	  name:'alter_date'	  
						          }],
						          sorters: [{
						        	  property : 'alter_date',
						        	  direction: 'ASC'
						          }],
						          data:[]				  
					})
				}]
			}] 
		}); 
		me.callParent(arguments); 
	}
});