mes/WebContent/app/controller/common/Import.js

Ext.QuickTips.init();
Ext.define('erp.controller.common.Import', {
    extend: 'Ext.app.Controller',
    requires: ['erp.util.BaseUtil','erp.util.GridUtil'],
    views: ['common.init.Template', 'core.button.UpExcel', 'core.trigger.DbfindTrigger', 'core.trigger.MultiDbfindTrigger',
            'core.toolbar.Toolbar'],
    init: function(){ 
    	var me = this;
    	me.BaseUtil = Ext.create('erp.util.BaseUtil');
    	me.GridUtil = Ext.create('erp.util.GridUtil');
    	this.control({ 
    		'form[id=upexcel]': {
    			afterrender: function(btn){
    				btn.upexcel = function(field){
    					if(btn.grid){
    						btn.getForm().submit({
        		        		url: basePath + 'system/initImport.action?caller=' + btn.grid.caller,
        		        		waitMsg: "正在解析Excel",
        		        		success: function(fp, o){
        		        			field.reset();
        		        			btn.grid.ilid = o.result.ilid;
        		        			btn.grid.down('pagingtoolbar').dataCount = o.result.count;
        		        			btn.grid.down('pagingtoolbar').onLoad();
        		        			btn.grid.getGridData(1);
        		        			Ext.getCmp('check').show();
        		        		},
        		        		failure: function(fp, o){
        		        			if(o.result.size){
        		        				showError(o.result.error + " " + Ext.util.Format.fileSize(o.result.size));
        		        				field.reset();
        		        			} else {
        		        				showError(o.result.error);
        		        				field.reset();
        		        			}
        		        		}
        		        	});
    						
    					}
    				};
    			}
    		},
    		'button[id=export]': {
    			click: function(btn){
    				var grid = btn.ownerCt.ownerCt.down('gridpanel');
    				if(grid){
    					window.location = basePath + 'system/initTemplate.xls?caller=' + grid.caller + 
    						'&title=' + (grid.ownerCt.title.replace(/»/g, '/'));
    				}
    			}
    		},
    		'button[id=rule]': {
    			click: function(btn){
    				me.showRule(btn.ownerCt.ownerCt.down('gridpanel'));
    			}
    		},
    		'button[id=check]': {
    			click: function(btn){
    				var grid = btn.ownerCt.ownerCt.down('gridpanel');
    				if(grid && grid.down('pagingtoolbar').dataCount<=0) showMessage('提示', '无数据');
    				else if(grid) me.checkdata(grid);
    			}
    		},
    		'button[id=history]': {
    			click: function(btn){
    				var grid = btn.ownerCt.ownerCt.down('gridpanel');
    				if(grid){
    					me.showHistory(grid.caller);
    				}
    			}
    		},
    		'checkbox[id=onlyerror]': {
    			change: function(f){
    				var grid = f.ownerCt.ownerCt.down('gridpanel');
    				if(grid) {/*
    					if(f.checked) {
        					grid.store.filterBy(function(item) {
					    		return !Ext.isEmpty(item.get('log')); 
					    	});
        				} else {
        					grid.store.filterBy(function(item) {
					    		return true; 
					    	});
        				}
    				*/
    					grid.getGridData(1);	
    				}
    			}
    		},
    		'button[id=toformal]': {
    			click: function(btn){
    				var grid = btn.ownerCt.ownerCt.down('gridpanel');
    				if(grid && grid.ilid > 0) {
    					if(grid.errorNodes && grid.errorNodes.length > 0) {
    						showMessage('提示', '测试未通过,无法转入正式');
    					} else {
    						me.toformal(grid);
    					}
    				}
    			}
    		},
    		/*'button[id=errdelete]': {
    			click: function(btn){
    				var grid = btn.ownerCt.ownerCt.down('gridpanel');
    				if(grid && grid.ilid > 0) {
    					me.deleteErrors(grid);
    				}
    			}
    		},
    		'button[id=saveupdates]': {
    			click: function(btn){
    				var grid = btn.ownerCt.ownerCt.down('gridpanel');
    				if(grid && grid.ilid > 0) {
    					me.saveUpdates(grid);
    				}
    			}
    		},*/
    		'button[id=errdownload]': {
    			click: function(btn){
    				var grid = btn.ownerCt.ownerCt.down('gridpanel');
    				if(grid && grid.ilid > 0) {
    					grid.store.filterBy(function(item) {
				    		return !Ext.isEmpty(item.get('log')); 
				    	});
    					me.BaseUtil.exportGrid(grid, btn.ownerCt.ownerCt.title);
    				}
    			}
    		},
    		'#template': {
    			afterrender: function(p) {
    				this.getDetails(p, caller, false);
    			}
    		}
    	});
    },
    getDetails: function(p, caller, isReload){
    	if(caller != p.caller || isReload){
    		p.caller = caller;
    		var me = this;
        	Ext.Ajax.request({
        		url: basePath + 'system/initDetails.action',
        		params: {
        			caller: caller
        		},
        		method: 'post',
        		callback: function(options, success, response){
        			var res = new Ext.decode(response.responseText);
            		if(res.exceptionInfo != null){
            			Ext.getCmp('upexcel').hide();
            			showError(res.exceptionInfo);return;
            		} else {
            			p.removeAll();
            			var store = me.emptyData(res.data);
            			p.add({
            				xtype: 'grid',
            				id: 'template-data',
            				anchor: "100% 100%",
            				cls: 'custom',
            				caller: caller,
            				ilid: -1,
            				cfg: res.data,//当前导入项的配置信息
            				columnLines: true,
            				columns: me.parseInitDetails(res.data),
            				store: store,
            				dockedItems: [me.getDockedItems(store)],
            				getGridData: function(page){
            					var f = Ext.getCmp('onlyerror');
                    			if(f.checked) {                    				
                    				me.loadErrData(this, page); 
                    			}else {                    				
                    				me.loadInitData(this, page);
                    			}
             			    },
             			    loadData: function(ilid, count, page){
             			    	this.ilid = ilid;
             			    	this.down('pagingtoolbar').dataCount = count;
    		        			this.down('pagingtoolbar').onLoad();
             			    	this.getGridData(page);
             			    	Ext.getCmp('errdownload').show();
             	    	    	Ext.getCmp('onlyerror').show();
             	    	    	Ext.getCmp('toformal').show();
             	    	    	/*Ext.getCmp('errdelete').show();
             	    	    	Ext.getCmp('saveupdates').show();*/
             	    	    	Ext.getCmp('check').show();            	    	                	    	    	
             			    },
             			    deleteData: function(ilid){
             			    	me.ondelete(ilid);
             			    },
             			    reset: function(){
             			    	this.ilid = -1;
             			    	this.down('pagingtoolbar').dataCount = 25;
    		        			this.down('pagingtoolbar').onLoad();
    		        			this.store.removeAll(true);
    		        			this.store.loadData([{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]);
             			    },
             			    showErrors: function(){
             			    	var grid = this,items = grid.store.data.items,
             			    		columns = grid.columns,d,nodes = grid.errorNodes,log = '';            			    		
             			    	if(nodes && nodes.length > 0) {
             			    		grid.errorArray = me.getMixedGroups(nodes);
             	   	    			Ext.each(items, function(item, index){
                 	    				d = item.data;
                 	    				log = '';
                 	    				Ext.each(columns, function(c, idx){
                 	    					var e = d.id_id+':'+c.dataIndex;
                 	    					e = e.toLowerCase();
                 	    					var errorGrid = grid.errorArray[e];
                 	    					if(errorGrid){
                 	    						if(log == '') {
                 	        	    					log = '<table class="custom-log">';
                 	        	    					log += '<tr class="custom-tr"><td>字段</td><td>值</td>' + 
                 	        	    						'<td>规则</td><td>数据类型</td>' +
                 	        	    						'<td>是否必填</td>' +
                 	        	    						'<td>逻辑</td>' +
                 	        	    						'</tr>';
                 	        	    			}
                 	        	    			/*if(idx > 0 && errorGrid.groups){
                 	        	    				log += '<tr><td>' + c.text + '</td><td><font color=red>'
			             	        	    					+ d[c.dataIndex] + '</td><td><font color=blue>'
			             	        	    					+ (c.rule || '') + '</font></td><td><font color=blue>' 
			             	        	    					+ c.dataType + '</font></td><td><font color=blue>'
			             	        	    					+ c.isNeed + '</font></td><td><font color=red>' ;		
			             	        	    	    var dat='';
	                 	        	    			Ext.each(errorGrid.groups, function(da) {  
	                 	        	    			 	if(da!=null && da!=''){
	                 	        	    			 		dat += da+"<br>";
	                 	        	    			 	}else{
	                 	        	    			 		dat+= c.logicdesc+"<br>";
	                 	        	    			 	}
	                 	        	    			});
                 	        	    			    log +=dat +'</font></td></tr>';
                 	        	    			}*/

                 	        	    			 Ext.each(errorGrid.groups, function(da) {  
                 	        	    			 	 if(idx > 0){
		             	        	    				if(da!=null && da!=''){
			             	        	    				log += '<tr><td>' + c.text + '</td><td><font color=red>'
			             	        	    					+ d[c.dataIndex] + '</td><td><font color=blue>'
			             	        	    					+ '' + '</font></td><td><font color=blue>' 
			             	        	    					+ c.dataType + '</font></td><td><font color=blue>'
			             	        	    					+ '' + '</font></td><td><font color=red>' 
			             	        	    					+ da +'</font></td></tr>';
		             	        	    				}else{
			             	        	    				log += '<tr><td>' + c.text + '</td><td><font color=red>'
			             	        	    					+ d[c.dataIndex] + '</td><td><font color=blue>'
			             	        	    					+ (c.rule || '') + '</font></td><td><font color=blue>' 
			             	        	    					+ c.dataType + '</font></td><td><font color=blue>'
			             	        	    					+ c.isNeed + '</font></td><td><font color=red>' 
			             	        	    					+ c.logicdesc +'</font></td></tr>';
		             	        	    				}
                 	        	    			 	 }
                 	        	    			 });
                 	    					}                	    					
                 	        	    	});
                 	    				if(log != '') {
                 	    					log += '</table>';
                 	    				}
                 	    				item.set('log', log);
                 	    	    	});
             			    	}
             			    },
             			    plugins: [{
             		            ptype: 'rowexpander',
             		            rowBodyTpl : [
             		                '<p><b>校验状态:</b> {log}</p><br>'
             		            ],
             		           toggleRow: function(rowIdx) {
              		              var rowNode = this.view.getNode(rowIdx),
              		                  row = Ext.get(rowNode),
              		                  nextBd = Ext.get(row).down(this.rowBodyTrSelector),
              		                  record = this.view.getRecord(rowNode),
              		                  grid = this.getCmp();

              		              if (row.hasCls(this.rowCollapsedCls)) {
              		                  row.removeCls(this.rowCollapsedCls);
              		                  nextBd.removeCls(this.rowBodyHiddenCls);
              		                  this.recordsExpanded[record.internalId] = true;
              		                  this.view.fireEvent('expandbody', rowNode, record, nextBd.dom);
              		              } else {
              		                  row.addCls(this.rowCollapsedCls);
              		                  nextBd.addCls(this.rowBodyHiddenCls);
              		                  this.recordsExpanded[record.internalId] = false;
              		                  this.view.fireEvent('collapsebody', rowNode, record, nextBd.dom);
              		              }
              		              this.view.up('gridpanel').invalidateScroller();
              		              this.view.up('gridpanel').doComponentLayout();
              		          }
             		        }, Ext.create('Ext.grid.plugin.CellEditing', {
             		        	clicksToEdit: 1
             		        })]
            			});
            			
            			var btn = Ext.getCmp('upexcel');
            			if(btn) {
            				btn.show();
                			btn.grid = p.down('gridpanel');
            			}
            		}
        		}
        	});
    	}
    },
    parseInitDetails: function(arr){
    	var me = this, d = new Array(),o;
    	d.push({xtype: 'rownumberer', width: 35});
    	d.push({
    		text: '导入日志',
    		dataIndex: 'log',
    		hidden: true,
    		renderer: function(val, meta){
    			meta.style = 'height:0px;';
    		}
    	});
    	d.push({
    		text: 'ID',
    		dataIndex: 'id_id',
    		hidden: true
    	});
    	Ext.each(arr, function(a){
    		o = new Object();
    		o.text = a.id_caption;
    		o.dataIndex = a.id_field;
    		o.hidden = a.id_visible == 0;
    		o.width = a.id_width;
    		o.rule = a.id_rule;
    		o.dataType = a.id_type;
    		o.isNeed = a.id_need == 1 ? '是' : '否';
    		o.logic = a.id_logic;
    		o.logicdesc = me.parseLogic(o.logic);
    		o.editor = {
    				xtype: 'textfield'
    		};
			if(/combo(.)/.test(o.logic)){
				var s = o.logic.substring(6, o.logic.lastIndexOf(')')).split(','),
					da = new Array();
				Ext.each(s, function(t){
					da.push({
						display: t,
						value: t
					});
				});
				o.editor = {
	    				xtype: 'combobox',
	    				displayField: 'display',
	    				valueField: 'value',
	    				queryMode: 'local',
	    				editable: false,
	    				store:  Ext.create('Ext.data.Store', {
	    		            fields: ['display', 'value'],
	    		            data : da
	    		        })
	    		};
			}
    		o.renderer = function(val, meta, record, x, y, store, view){
    			if(view) {
    				var grid = view.ownerCt,errorArray = grid.errorArray,cm = grid.columns[y];
        			if(errorArray && y > 0 && !!record.get('log') && errorArray[record.data['id_id'] + ':' + (cm.dataIndex).toLowerCase()]){
            			meta.tdCls = 'x-td-warn';
            			meta.tdAttr = 'data-qtip="' + (cm.rule || cm.dataType) + '"';
        			}else
        				meta.tdCls = '';
    			}
    			return val;
    		};
    		d.push(o);
    	});
    	return d;
    },
    emptyData: function(arr){
    	var fields = new Array();
    	Ext.each(arr, function(a){
    		fields.push(a.id_field);
    	});
    	return new Ext.data.Store({
    		fields: fields,
    		data: [{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]
    	});
    },
    getDockedItems: function(store){
    	return {
    		xtype: 'pagingtoolbar',
    		store: store,
    		pageSize: 100,
    		dataCount: store.data.items.length,
    		page: 1,
    		dock: 'bottom',
    		displayInfo: true,
    		updateInfo : function(){
    			var page = this.child('#inputItem').getValue() || 1;
    			var me = this,
    				pageSize = me.pageSize || 100,
    				dataCount = me.dataCount || 20;
	 	    	var displayItem = me.child('#displayItem'),
	 	    	 	pageData = me.getPageData();
                pageData.fromRecord = (page-1)*pageSize+1;
                pageData.toRecord = page*pageSize > dataCount ? dataCount : page*pageSize;
	    		pageData.total = dataCount;
	    		var msg;
	                if (displayItem) {
	                    if (me.dataCount === 0) {
	                        msg = me.emptyMsg;
	                    } else {
	                        msg = Ext.String.format(
	                            me.displayMsg,
	                            pageData.fromRecord,
	                            pageData.toRecord,
	                            pageData.total
	                        );
	                    }
	                    displayItem.setText(msg);
	                    me.doComponentLayout();
	                }
	            },
	            getPageData : function(){
	            	var me = this,
	            		totalCount = me.dataCount;
		        	return {
		        		total : totalCount,
		        		currentPage : me.page,
		        		pageCount: Math.ceil(me.dataCount / me.pageSize),
		        		fromRecord: ((me.page - 1) * me.pageSize) + 1,
		        		toRecord: Math.min(me.page * me.pageSize, totalCount)
		        	};
		        },
		        doRefresh:function(){
			    	this.moveFirst();
			    },
		        onPagingKeyDown : function(field, e){
		            var me = this,
		                k = e.getKey(),
		                pageData = me.getPageData(),
		                increment = e.shiftKey ? 10 : 1,
		                pageNum = 0;

		            if (k == e.RETURN) {
		                e.stopEvent();
		                pageNum = me.readPageFromInput(pageData);
		                if (pageNum !== false) {
		                    pageNum = Math.min(Math.max(1, pageNum), pageData.pageCount);
		                    me.child('#inputItem').setValue(pageNum);
		                    if(me.fireEvent('beforechange', me, pageNum) !== false){
		                    	me.page = pageNum;
		                    	me.ownerCt.getGridData(me.page);
		                    }
		                    
		                }
		            } else if (k == e.HOME || k == e.END) {
		                e.stopEvent();
		                pageNum = k == e.HOME ? 1 : pageData.pageCount;
		                field.setValue(pageNum);
		            } else if (k == e.UP || k == e.PAGEUP || k == e.DOWN || k == e.PAGEDOWN) {
		                e.stopEvent();
		                pageNum = me.readPageFromInput(pageData);
		                if (pageNum) {
		                    if (k == e.DOWN || k == e.PAGEDOWN) {
		                        increment *= -1;
		                    }
		                    pageNum += increment;
		                    if (pageNum >= 1 && pageNum <= pageData.pages) {
		                        field.setValue(pageNum);
		                    }
		                }
		            }
		            me.updateInfo();
		            me.resetTool(value);
		        }, 
		        moveFirst : function(){
	            	var me = this;
	                me.child('#inputItem').setValue(1);
	                value = 1;
	            	me.page = value;
	            	me.ownerCt.getGridData(value);
	                me.updateInfo();
	                me.resetTool(value);
	            },
	            movePrevious : function(){
	                var me = this;
	                me.child('#inputItem').setValue(me.child('#inputItem').getValue() - 1);
	                value = me.child('#inputItem').getValue();
	                me.page = value;
	            	me.ownerCt.getGridData(value);
	                me.updateInfo();
	                me.resetTool(value);
	            },
	            moveNext : function(){
	                var me = this,
	                last = me.getPageData().pageCount;
	                total = last;
	                me.child('#inputItem').setValue(me.child('#inputItem').getValue() + 1);
	                value = me.child('#inputItem').getValue();
	                me.page = value;
	            	me.ownerCt.getGridData(value);
	                me.updateInfo();
	                me.resetTool(value);
	            },
	            moveLast : function(){
	                var me = this,
	                last = me.getPageData().pageCount;
	                total = last;
	                me.child('#inputItem').setValue(last);
	                value = me.child('#inputItem').getValue();
	            	me.page = value;
	            	me.ownerCt.getGridData(value);
	                me.updateInfo();
	                me.resetTool(value);
	            },
	            onLoad : function() {
					var e = this, d, b, c, a;
					if (!e.rendered) {
						return
					}
					d = e.getPageData();
					b = d.currentPage;
					c = Math.ceil(e.dataCount / e.pageSize);
					a = Ext.String.format(e.afterPageText, isNaN(c) ? 1 : c);
					e.child("#afterTextItem").setText(a);
					e.child("#inputItem").setValue(b);
					e.child("#first").setDisabled(b === 1);
					e.child("#prev").setDisabled(b === 1);
					e.child("#next").setDisabled(b === c || c===1);//
					e.child("#last").setDisabled(b === c || c===1);
					e.child("#refresh").enable();
					e.updateInfo();
					e.fireEvent("change", e, d);
				},
				resetTool: function(value){
					var pageCount = this.getPageData().pageCount;
					this.child('#last').setDisabled(value == pageCount || pageCount == 1);
				    this.child('#next').setDisabled(value == pageCount || pageCount == 1);
				    this.child('#first').setDisabled(value <= 1);
				    this.child('#prev').setDisabled(value <= 1);
				}
    	};
    },
    getPathString: function(tree, record){//path:/root/5/12
    	var str = tree.ownerCt.title;
    	return record.getPath('text', '&raquo;').replace('root', str);
    },
    showHistory: function(caller){
    	var w = Ext.create('Ext.Window', {
    		width: '60%',
    		height: '80%',
    		id: 'history-win',
    		title: '导入数据历史记录',
    		autoShow: true,
    		layout: 'anchor',
    		items: [{
    			xtype: 'gridpanel',
    			anchor: '100% 100%',
    			columnLines: true,
    			columns: [{dataIndex: 'il_id', hidden: true},{dataIndex: 'il_caller', hidden: true},{dataIndex: 'il_date', text: '日期', flex: 2},
    			          {dataIndex: 'il_sequence', text: '次数', flex: 1},{dataIndex: 'il_count', text: '数据量(条)', flex: 1},
    			          {dataIndex: 'il_checked', text: '是否已校验', flex: 1, renderer: function(val, m){
    			        	  if(val == '否') {
    			        		  m.style = 'float:right';
    			        	  }
    			        	  return val;
    			          }},{dataIndex: 'il_success',text:'是否校验通过', flex: 1, renderer: function(val, m){
    			        	  if(val == '否') {
    			        		  m.style = 'float:right';
    			        	  }
    			        	  return val;
    			          }},
    			          {dataIndex: 'il_toformal', text: '是否转正式', flex: 1, renderer: function(val, m){
    			        	  if(val == '否') {
    			        		  m.style = 'float:right';
    			        	  }
    			        	  return val;
    			          }}, {text: '', flex: 1, renderer: function(val, m, r){
    			        	  return '<a href="javascript:Ext.getCmp(\'template-data\').loadData(' + r.get('il_id') + ',' 
    			        	  		+ r.get('il_count') + ',1);Ext.getCmp(\'history-win\').close();Ext.getDom(\'check\').click();">载入</a>&nbsp;&nbsp;<a href="javascript:Ext.getCmp(\'template-data\').deleteData(' + 
    			        	  		r.get('il_id') + ');Ext.getCmp(\'history-win\').close();">删除</a>';
    			          }}],
    			store: Ext.create('Ext.data.Store', {
    				fields: ['il_id', 'il_caller', 'il_date', 'il_sequence', 'il_count', 'il_checked', 'il_success', 'il_toformal'],
    				data: [{},{},{},{},{},{},{},{},{},{}]
    			})
    		}]
    	});
    	this.getInitLog(w.down('gridpanel'), caller);
    },
    getInitLog: function(g, c){
    	Ext.Ajax.request({
    		url: basePath + 'system/initHistory.action',
    		params: {
    			caller: c
    		},
    		method: 'post',
    		callback: function(opt, s, r){
    			var res = new Ext.decode(r.responseText);
    			var dd = res.data;
    			Ext.each(dd, function(d){
    				d.il_date = Ext.Date.format(new Date(d.il_date), 'Y-m-d H:i:s');
    				d.il_checked = d.il_checked == 1 ? '是' : '否';
    				d.il_success = d.il_success == 1 ? '是' : '否';
    				d.il_toformal = d.il_toformal == 1 ? '是' : '否';
    			});
    			g.store.loadData(dd);
    		}
    	});
    },
    loadInitData: function(grid, page){
    	var f = (page-1) * 100 + 1,
    		t = page*100;
    	grid.setLoading(true);
    	Ext.Ajax.request({
    		url: basePath + 'system/getInitData.action',
    		params: {
    			condition: "id_ilid=" + grid.ilid + 
    				" AND id_detno between " + f + " AND " + t
    		},
    		method: 'post',
    		callback: function(options, success, response){
    			var res = new Ext.decode(response.responseText);
    			grid.setLoading(false);
        		if(res.exceptionInfo != null){
        			showError(res.exceptionInfo);return;
        		} else {
        			var datas = new Array(), o;
        			Ext.each(res.data, function(d){
        				o = Ext.decode(d.id_data);
        				o.id_id = d.id_id;
        				datas.push(o);
        			});
        			grid.store.loadData(datas);
        			grid.showErrors();
        			/*var f = Ext.getCmp('onlyerror');
        			if(f.checked) {
    					grid.store.filterBy(function(item) {
				    		return !Ext.isEmpty(item.get('log')); 
				    	});
    				}*/
        		}
    		}
    	});
    },
    loadErrData: function(grid, page){
    	var f = (page-1) * 100 + 1,
    		t = page*100;
    	grid.setLoading(true);
    	Ext.Ajax.request({
    		url: basePath + 'system/getErrData.action',
    		timeout: 10000,
    		params: {
    			id:grid.ilid,
    			condition:" RN between " + f + " AND " + t
    		},
    		method: 'post',
    		callback: function(options, success, response){
    			grid.setLoading(false);
    			var res = new Ext.decode(response.responseText);
    			if(!success) {
    				if(res.exceptionInfo != null){
    					alert(res.exceptionInfo);return;
    				}
    				alert('系统繁忙，请稍后再试!');
    				return;
    			}
        		if(res.exceptionInfo != null){
        			showError(res.exceptionInfo);return;
        		} else {
        			var datas = new Array(), o;
        			Ext.each(res.data, function(d){
        				o = Ext.decode(d.id_data);
        				o.id_id = d.id_id;
        				datas.push(o);
        			});
        			grid.store.loadData(datas);
        			grid.showErrors();
        		}
    		}
    	});
    },
    ondelete: function(id){
    	var grid = Ext.getCmp('template-data');
    	grid.setLoading(true);
    	Ext.Ajax.request({
    		url: basePath + 'system/deleteInitData.action',
    		params: {
    			id: id
    		},
    		method: 'post',
    		callback: function(options, success, response){
    			var res = new Ext.decode(response.responseText);
    			grid.setLoading(false);
        		if(res.exceptionInfo != null){
        			showError(res.exceptionInfo);return;
        		} else {
        			if(id == grid.ilid) {//如果删除的是当前显示的数据，要清除当前grid的数据
        				grid.reset();
        			}
        		}
    		}
    	});
    },
    showRule: function(grid){
    	if(grid){
    		var me = this,data = me.getRules(grid);
    		Ext.create('Ext.window.Window', {
    			width: '100%',
    			height: '100%',
    			autoShow: 'true',
    			closeAction: 'destroy',
    			title: '导入配置',
    			layout: 'anchor',
    			tbar: ['->',{
    				text: '保存',
    				width: 80,
    				cls: 'x-btn-bar-s',
    				handler: function(b){
    					me.saveInitDetails(b.ownerCt.ownerCt.down('gridpanel'), grid.caller);
    				}
    			},{
    				text: '取消',
    				width: 80,
    				cls: 'x-btn-bar-s',
    				handler: function(b) {
    					b.ownerCt.ownerCt.close();
    				}
    			},'->'],
    			items: [{
    				xtype: 'gridpanel',
    				id: 'initdetails',
    				anchor: '100% 100%',
    				plugins: Ext.create('Ext.grid.plugin.CellEditing', {
    			        clicksToEdit: 1
    			    }),
    				columnLines: true,
    				keyField: 'id_id',
    				detno: 'id_detno',
    				bbar: {xtype: 'erpToolbar'},
    				dbfinds: [{
    					field: 'id_table',
    					dbGridField: 'dd_tablename;ddd_tablename'
    				},{
    					field: 'id_field',
    					dbGridField: 'ddd_fieldname'
    				},{
    					field: 'id_caption',
    					dbGridField: 'ddd_description'
    				},{
    					field: 'id_type',
    					dbGridField: 'ddd_fieldtype'
    				}],
    				columns: [{
    					dataIndex: 'id_id',
    					hidden: true
    				},{
    					dataIndex: 'id_caller',
    					hidden: true,
    					renderer: function(v, m, r, x, y, s, w){
    						var grid = w.ownerCt;
    						if(Ext.isEmpty(v) && !Ext.isEmpty(grid.caller)) {
    							v = grid.caller;
    							r.set('id_caller', v);
    						}
    						return v;
    					}
    				},{
    					dataIndex: 'id_detno',
    					text: '序号',
    					width: 40,
    					renderer: function(val, meta) {
    				        meta.tdCls = Ext.baseCSSPrefix + 'grid-cell-special';
    				        return val;
    				    }
    				},{
    					text: '导入表',
    					dataIndex: 'id_table',
    					width: 90,
    					editor: {
    						xtype: 'dbfindtrigger'
    					},
    					dbfind: 'DataDictionary|dd_tablename'
    				},{
    					text: '导入项',
    					dataIndex: 'id_field',
    					width: 100,
    					editor: {
    						xtype: 'multidbfindtrigger'
    					},
    					dbfind: 'DataDictionaryDetail|ddd_fieldname'
    				},{
    					text: '描述',
    					dataIndex: 'id_caption',
    					width: 105,
    					renderer: function(v){
    						if(Ext.isEmpty(v)) {
    							return '<font color=gray>无</font>';
    						}
    						return v;
    					},
    					editor: {
    						xtype: 'textfield'
    					}
    				},{
    					text: '逻辑表达式',
    					dataIndex: 'id_logic',
    					width: 250,
    					renderer: function(v){
    						if(Ext.isEmpty(v)) {
    							return '<font color=gray>无</font>';
    						}
    						return v;
    					},
    					editor: {
    						xtype: 'trigger',
    						editable: false,
    						triggerCls: 'x-form-search-trigger',
    						onTriggerClick: function(){
    							me.logicTypes(this, Ext.getCmp('initdetails').selModel.lastSelected);
    						}
    					}
    				},{
    					text: '逻辑描述',
    					dataIndex: 'id_rule',
    					width: 500,
    					renderer: function(v){
    						if(Ext.isEmpty(v)) {
    							return '<font color=gray>无</font>';
    						}
    						return v;
    					},
    					editor: {
    						xtype: 'textfield'
    					}
    				},{
    					text: '类型',
    					dataIndex: 'id_type',
    					width: 105,
    					renderer: function(v, meta, record){
    						if(Ext.isEmpty(v)) {
    							return '<font color=gray>无</font>';
    						} else {
    							v = v.toLowerCase();
    							if(contains(v, 'varchar2')) {
    								v = v.replace(/byte/g, '').trim();
    							}
    							if(record.data['id_type'] != v) {
									record.set('id_type', v);
								}
    						}
    						return v;
    					},
    					editor: {
    						xtype: 'trigger',
    						editable: false,
    						triggerCls: 'x-form-search-trigger',
    						onTriggerClick: function(){
    							me.dataTypes(this, Ext.getCmp('initdetails').selModel.lastSelected);
    						}
    					}
    				},{
    					text: '默认值',
    					dataIndex: 'id_default',
    					wdith: 80,
    					renderer: function(v){
    						if(Ext.isEmpty(v)) {
    							return '<font color=gray>无</font>';
    						}
    						return v;
    					},
    					editor: {
    						xtype: 'trigger',
    						editable: false,
    						triggerCls: 'x-form-search-trigger',
    						onTriggerClick: function(){
    							me.fieldTypes(this, Ext.getCmp('initdetails').selModel.lastSelected);
    						}
    					}
    				},{
    					text: '是否显示',
    					dataIndex: 'id_visible',
    					xtype: 'checkcolumn',
    					width: 75,
    					editor: {
    						xtype: 'checkbox'
    					}
    				},{
    					text: '是否必填',
    					dataIndex: 'id_need',
    					xtype: 'checkcolumn',
    					width: 75,
    					editor: {
    						xtype: 'checkbox'
    					}
    				},{
    					text: '列宽度',
    					dataIndex: 'id_width',
    					xtype: 'numbercolumn',
    					format: '0',
    					width: 75,
    					editor: {
    						xtype: 'numberfield',
    						hideTrigger: true,
    						format: '0'
    					}
    				}],
    				store: Ext.create('Ext.data.Store', {
    					fields: ['id_id', 'id_caller', 'id_detno', 'id_table', 'id_field', 'id_caption', 'id_logic', 'id_rule',
    					         'id_type', {name: 'id_visible', type: 'bool'},  {name: 'id_need', type: 'bool'}, 'id_default',
    					         'id_width'],
    					data: data
    				}),
    				listeners: {
    					itemclick: function(selModel, record){
    						me.GridUtil.onGridItemClick(selModel, record);
    					}
    				}
    			}]
    		});
    		me.control('field[name=id_field]', {
    			focus: function(t){
					var record = Ext.getCmp('initdetails').selModel.lastSelected;
    				var dd = record.data['id_table'];
    				if(!Ext.isEmpty(dd)) {
    					t.dbBaseCondition = 'ddd_tablename=\'' + dd + '\'';
    				} else {
    					t.dbBaseCondition = '';
    				}
				}
    		});
    	}
    },
    saveInitDetails: function(grid, caller){
    	var me = this,datas = [],items = grid.store.data.items,d;
    	Ext.each(items, function(i){
    		if(i.dirty) {
    			d = i.data;
    			if(!Ext.isEmpty(d.id_field) && !Ext.isEmpty(d.id_table)) {
    				d.id_need = d.id_need ? 1 : 0;
        			d.id_visible = d.id_visible ? 1 : 0;
        			d.id_caller = caller;
        			d.id_width = Ext.isEmpty(d.id_width) ? 0 : d.id_width;
        			datas.push(d);
    			}
    		}
    	});
    	Ext.Ajax.request({
    		url: basePath + 'system/saveInitDetail.action',
    		method: 'post',
    		params: {
    			data: unescape(Ext.encode(datas).replace(/\\/g,"%"))
    		},
    		callback: function(opt, s, r) {
    			if(r.exceptionInfo) {
    				showError(r.exceptionInfo);
    			} else {
    				alert('保存成功!');
    				grid.ownerCt.destroy();
    				me.getDetails(Ext.getCmp('template'), caller, true);
    			}
    		}
    	});
    },
    fieldTypes: function(f, record){
    	var g = Ext.getCmp('initdetails'), dd = g.store.data.items,ff = [];
    	Ext.each(dd, function(i){
    		if(i.data.id_field != record.data.id_field) {
    			ff.push({
        			display: i.data.id_caption,
        			value: i.data.id_field
        		});
    		}
    	});
    	var ww = Ext.create('Ext.Window', {
			autoShow: true,
			modal: true,
			title: '默认值',
			width: '55%',
			height: '50%',
			layout: 'column',
			items: [{
				xtype: 'fieldcontainer',
				name: 'keyField',
				columnWidth: 1,
				items: [{
					xtype: 'radio',
					columnWidth: 1,
					boxLabel: '自动取ID',
					name: 'default'
				}],
				getValue: function(){
					return 'keyField';
				},
				setValue: function(){
					this.down('radio').setValue(true);
				}
			},{
				xtype: 'fieldcontainer',
				name: 'codeField',
				columnWidth: 1,
				items: [{
					xtype: 'radio',
					columnWidth: 1,
					boxLabel: '自动取编号',
					name: 'default'
				}],
				getValue: function(){
					return 'codeField';
				},
				setValue: function(){
					this.down('radio').setValue(true);
				}
			},{
				xtype: 'fieldcontainer',
				name: 'date',
				columnWidth: 1,
				layout: 'hbox',
				items: [{
					xtype: 'radio',
					boxLabel: '当前时间',
					name: 'default'
				},{
					xtype: 'checkbox',
					inputValue: 'yy-MM-dd',
					separator: ' ',
					boxLabel: '年月日'
				},{
					xtype: 'checkbox',
					inputValue: 'HH:mm:ss',
					separator: '',
					boxLabel: '时分秒'
				}],
				getValue: function(){
					var rr = this.query('checkbox[checked=true]'), vv = '', len = rr.length;
					Ext.each(rr, function(r, idx){
						if(r.xtype == 'checkbox' && r.inputValue) {
							vv += r.inputValue;
							if(idx < len - 1) {
								vv += r.separator;
							}
						}
					});
					if(vv == '') {
						return '';
					}
					return 'date(' + vv + ')';
				},
				setValue: function(v){
					this.down('radio').setValue(true);
					v = v.substring(v.indexOf('(') + 1, v.indexOf(')'));
					var y = v.split(' '),arr,me = this;
					Ext.each(y, function(i){
						if(i.indexOf('-') != -1) {
							arr = i.split('-');
						} else {
							arr = i.split(':');
						}
						var ch;
						Ext.each(arr, function(j){
							ch = me.down('checkbox[inputValue=' + j + ']');
							if(ch)
								ch.setValue(true);
						});
					});
				}
			},{
				xtype: 'fieldcontainer',
				name: 'replace',
				columnWidth: 1,
				layout: 'hbox',
				items: [{
					xtype: 'radio',
					name: 'default',
					boxLabel: '替代值'
				},{
					xtype: 'fieldcontainer',
					items: [{
						xtype: 'textfield',
						emptyText: '显示值'
					},{
						xtype: 'textfield',
						emptyText: '实际值'
					}],
					getValue: function(){
						var val = this.items.items[0],dis = this.items.items[1];
						if(!Ext.isEmpty(val.value) && !Ext.isEmpty(dis.value)) {
							return val.value + ':' + dis.value;
						}
						return '';
					},
					setValue: function(v) {
						if(!Ext.isEmpty(v)) {
							this.items.items[0].setValue(v.split(':')[0]);
							this.items.items[1].setValue(v.split(':')[1] || '');
						}
					}
				},{
					xtype: 'button',
					iconCls: 'x-button-icon-add',
					cls: 'x-btn-tb',
					handler: function(b){
						b.ownerCt.insert(b.ownerCt.items.items.length - 1, {
							xtype: 'fieldcontainer',
							items: [{
								xtype: 'textfield',
								emptyText: '显示值'
							},{
								xtype: 'textfield',
								emptyText: '实际值'
							}],
							getValue: function(){
								var val = this.items.items[0],dis = this.items.items[1];
								if(!Ext.isEmpty(val.value) && !Ext.isEmpty(dis.value)) {
									return val.value + ':' + dis.value;
								}
								return '';
							},
							setValue: function(v) {
								if(!Ext.isEmpty(v)) {
									this.items.items[0].setValue(v.split(':')[0]);
									this.items.items[1].setValue(v.split(':')[1] || '');
								}
							}
						});
					}
				}],
				getValue: function(){
					var tx = this.query('fieldcontainer'),val = '';
					Ext.each(tx, function(t){
						if(!Ext.isEmpty(t.getValue())) {
							if(val == '') {
								val = t.getValue();
							} else {
								val += ',' + t.getValue();
							}
						}
					});
					if(val == '') {
						return null;
					}
					return 'replace(' +val + ')';
				},
				setValue: function(v){
					var m = this;
					this.down('radio').setValue(true);
					var t = v.substring(v.indexOf('(') + 1, v.lastIndexOf(')')).split(',');
					Ext.each(t, function(r, i){
						if(i == 0) {
							m.down('fieldcontainer').setValue(r);
						} else {
							var f = Ext.create('Ext.form.FieldContainer', {
								items: [{
									xtype: 'textfield',
									emptyText: '显示值'
								},{
									xtype: 'textfield',
									emptyText: '实际值'
								}],
								getValue: function(){
									var val = this.items.items[0],dis = this.items.items[1];
									if(!Ext.isEmpty(val.value) && !Ext.isEmpty(dis.value)) {
										return val.value + ':' + dis.value;
									}
									return '';
								},
								setValue: function(v) {
									if(!Ext.isEmpty(v)) {
										this.items.items[0].setValue(v.split(':')[0]);
										this.items.items[1].setValue(v.split(':')[1] || '');
									}
								}
							});
							m.insert(m.items.items.length - 1, f);
							f.setValue(r);
						}
					});
				}
			},{
				xtype: 'fieldcontainer',
				name: 'copy',
				columnWidth: 1,
				layout: 'hbox',
				items: [{
					xtype: 'radio',
					boxLabel: '等于字段',
					name: 'default'
				},{
					xtype: 'combo',
					displayField: 'display',
					valueField: 'value',
					queryMode: 'local',
					editable: false,
					store: Ext.create('Ext.data.Store', {
						fields: ['display','value'],
						data: ff
					})
				},{
					xtype: 'radio',
					name: 'condition',
					inputValue: 'if',
					boxLabel: '只在值为空时'
				},{
					xtype: 'radio',
					name: 'condition',
					inputValue: 'of',
					boxLabel: '任何情况下',
					checked: true
				}],
				getValue: function(){
					var rr = this.query('radio[name=condition]'), vv = '';
					Ext.each(rr, function(){
						if(this.checked) {
							vv = this.inputValue;
						}
					});
					return 'copy' + vv + '(' + this.down('combo').value + ')';
				},
				setValue: function(v) {
					this.down('radio').setValue(true);
					this.down('combo').setValue(v.substring(v.indexOf('(') + 1, v.lastIndexOf(')')));
					var ff = v.substring(4, v.indexOf('('));
					this.down('radio[inputValue=' + ff + ']').setValue(true);
				}
			},{
				xtype: 'fieldcontainer',
				name: 'others',
				columnWidth: 1,
				layout: 'hbox',
				items: [{
					xtype: 'radio',
					boxLabel: '其它',
					name: 'default'
				},{
					xtype: 'textfield'
				}],
				getValue: function() {
					return this.down('textfield').value;
				},
				setValue: function(v) {
					this.down('radio').setValue(true);
					this.down('textfield').setValue(v);
				}
			}],
			buttonAlign: 'center',
			buttons: [{
				text: '确定',
				handler: function(b){
					var w = b.ownerCt.ownerCt;
					var val = '',ch = w.query('radio[name="default"]'),cc = null;
					Ext.each(ch, function(){
						if(this.checked) {
							cc = this;
						}
					});
					if(cc) {
						v = cc.ownerCt.getValue();
						if(v != null) {
							val = v;
						}
					}
					f.setValue(val);
					record.set('id_default', val);
					w.close();
				}
			},{
				text: '取消',
				handler: function(b){
					b.ownerCt.ownerCt.close();
				}
			}]
    	});
    	var fc = ww.query('fieldcontainer');
    	if(!Ext.isEmpty(f.value)) {
    		var vv = f.value,bool = false;
    		Ext.each(fc, function(r){
	    		if(contains(vv, r.name, true)) {
	    			bool = true;
	    			r.setValue(vv);
	    		}
	    	});
    		if(!bool) {
    			ww.down('fieldcontainer[name=others]').setValue(vv);
    		}
    	}
    },
    logicTypes: function(f, record){
    	var g = Ext.getCmp('initdetails'), dd = g.store.data.items,ff = [];
    	Ext.each(dd, function(i){
    		if(i.data.id_field != record.data.id_field) {
    			ff.push({
        			display: i.data.id_caption,
        			value: i.data.id_field
        		});
    		}
    	});
    	var ww = Ext.create('Ext.Window', {
			autoShow: true,
			modal: true,
			title: '逻辑表达式',
			width: '60%',
			height: '60%',
			layout: 'column',
			padding: 15,
			items: [{
				xtype: 'fieldcontainer',
				name: 'unique',
				columnWidth: 1,
				items: [{
					xtype: 'checkbox',
					boxLabel: '唯一性'
				}],
				getValue: function(){
					return 'unique(' + record.data.id_table + '|' + record.data.id_field + ')';
				},
				setValue: function(v){
					this.down('checkbox').setValue(true);
				}
			},{
				xtype: 'fieldcontainer',
				name: 'trim',
				columnWidth: 1,
				layout: 'column',
				items: [{
					xtype: 'checkbox',
					columnWidth: 0.1,
					boxLabel: '禁用字符'
				},{
					xtype: 'textfield',
					columnWidth: 0.1
				},{
					xtype: 'button',
					iconCls: 'x-button-icon-add',
					cls: 'x-btn-tb',
					handler: function(b){
						b.ownerCt.insert(b.ownerCt.items.items.length - 1, {
							xtype: 'textfield',
							columnWidth: 0.1
						});
					}
				}],
				getValue: function(){
					var tx = this.query('textfield'),val = '';
					Ext.each(tx, function(t){
						if(!Ext.isEmpty(t.value)) {
							if(val == '') {
								val = t.value;
							} else {
								val += ',' + t.value;
							}
						}
					});
					if(val == '') {
						return null;
					}
					return 'trim(' +val + ')';
				},
				setValue: function(v){
					var m = this;
					m.down('checkbox').setValue(true);
					var t = v.substring(v.indexOf('(') + 1, v.lastIndexOf(')')).split(',');
					Ext.each(t, function(r, i){
						if(i == 0) {
							m.down('textfield').setValue(r);
						} else {
							m.insert(m.items.items.length - 1, {
								xtype: 'textfield',
								columnWidth: 0.1,
								value: r
							});
						}
					});
				}
			},{
				xtype: 'fieldcontainer',
				name: 'combo',
				columnWidth: 1,
				layout: 'column',
				items: [{
					xtype: 'checkbox',
					columnWidth: 0.1,
					boxLabel: '可选范围'
				},{
					xtype: 'textfield',
					columnWidth: 0.1
				},{
					xtype: 'button',
					iconCls: 'x-button-icon-add',
					cls: 'x-btn-tb',
					handler: function(b){
						b.ownerCt.insert(b.ownerCt.items.items.length - 1, {
							xtype: 'textfield',
							columnWidth: 0.1
						});
					}
				}],
				getValue: function(){
					var tx = this.query('textfield'),val = '';
					Ext.each(tx, function(t){
						if(!Ext.isEmpty(t.value)) {
							if(val == '') {
								val = t.value;
							} else {
								val += ',' + t.value;
							}
						}
					});
					if(val == '') {
						return null;
					}
					return 'combo(' +val + ')';
				},
				setValue: function(v){
					var m = this;
					m.down('checkbox').setValue(true);
					var t = v.substring(v.indexOf('(') + 1, v.lastIndexOf(')')).split(',');
					Ext.each(t, function(r, i){
						if(i == 0) {
							m.down('textfield').setValue(r);
						} else {
							m.insert(m.items.items.length - 1, {
								xtype: 'textfield',
								columnWidth: 0.1,
								value: r
							});
						}
					});
				}
			},{
				xtype: 'fieldcontainer',
				name: 'accord',
				columnWidth: 1,
				layout: 'column',
				items: [{
					xtype: 'checkbox',
					columnWidth: 0.1,
					boxLabel: '关联'
				},{
					columnWidth: 0.3,
					emptyText: '表',
					id: 'accord_table',
					name: 'accord_table',
					xtype: 'dbfindtrigger'
				},{
					columnWidth: 0.3,
					emptyText: '字段',
					id: 'accord_field',
					name: 'accord_field',
					dbKey: 'accord_table',
					mappingKey: 'ddd_tablename',
					dbMessage: '请选择表名',
					xtype: 'dbfindtrigger'
				}],
				getValue: function(){
					var at = this.down('dbfindtrigger[name=accord_table]'),
						af = this.down('dbfindtrigger[name=accord_field]');
					if(!Ext.isEmpty(at.value) && !Ext.isEmpty(af.value)) {
						return 'accord(' + at.value + '|' + af.value + ')';
					}
					return null;
				},
				setValue: function(v){
					this.down('checkbox').setValue(true);
					var t = v.substring(v.indexOf('(') + 1, v.lastIndexOf(')')).split('|');
					this.down('dbfindtrigger[name=accord_table]').setValue(t[0]);
					this.down('dbfindtrigger[name=accord_field]').setValue(t[1]);
				}
			},{
				xtype: 'fieldcontainer',
				name: 'diffence',
				columnWidth: 1,
				layout: 'column',
				items: [{
					xtype: 'checkbox',
					columnWidth: 0.1,
					boxLabel: '不同于'
				},{
					columnWidth: 0.3,
					xtype: 'combo',
					displayField: 'display',
					valueField: 'value',
					queryMode: 'local',
					editable: false,
					store: Ext.create('Ext.data.Store', {
						fields: ['display','value'],
						data: ff
					})
				}],
				getValue: function(){
					var c = this.down('combo');
					if(!Ext.isEmpty(c.value)) {
						return 'diffence(' + c.value + ')';
					}
					return null;
				},
				setValue: function(v){
					this.down('checkbox').setValue(true);
					this.down('combo').setValue(v.substring(v.indexOf('(') + 1, v.lastIndexOf(')')));
				}
			},{
				xtype: 'fieldcontainer',
				name: 'minValue',
				columnWidth: 1,
				layout: 'column',
				items: [{
					xtype: 'checkbox',
					columnWidth: 0.1,
					boxLabel: '最小值'
				},{
					columnWidth: 0.3,
					xtype: 'numberfield'
				}],
				getValue: function(){
					var c = this.down('numberfield');
					if(!Ext.isEmpty(c.value)) {
						return 'minValue(' + c.value + ')';
					}
					return null;
				},
				setValue: function(v){
					this.down('checkbox').setValue(true);
					this.down('minValue').setValue(v.substring(v.indexOf('(') + 1, v.lastIndexOf(')')));
				}
			}],
			buttonAlign: 'center',
			buttons: [{
				text: '确定',
				handler: function(b){
					var w = b.ownerCt.ownerCt;
					var val = '',ch = w.query('checkbox[checked=true]'),v;
					Ext.each(ch, function(c){
						v = c.ownerCt.getValue();
						if(v != null) {
							if(val != '') {
								val += ';';
							}
							val += v;
						}
					});
					f.setValue(val);
					record.set('id_logic', val);
					w.close();
				}
			},{
				text: '取消',
				handler: function(b){
					b.ownerCt.ownerCt.close();
				}
			}]
    	});
    	var fc = ww.query('fieldcontainer');
    	if(!Ext.isEmpty(f.value)) {
    		var vv = f.value.split(';');
    		Ext.each(vv, function(s){
    			Ext.each(fc, function(r){
    	    		if(contains(s, r.name, true)) {
    	    			r.setValue(s);
    	    		}
    	    	});
    		});
    	}
    },
    dataTypes: function(f, record){
    	var v = f.value,a = v.substring(v.indexOf('(') + 1, v.indexOf(')')),x = 30,y = 0;
    	if(a) {
    		x = a.split(',')[0];
    		y = a.split(',')[1];
    	}
    	var isDate = contains(f.value, 'date', true), isStr = contains(f.value, 'varchar2', true);
    	Ext.create('Ext.Window', {
			autoShow: true,
			modal: true,
			title: '数据类型',
			width: '40%',
			height: '40%',
			items: [{
				xtype: 'container',
				padding: '10 5 5 10',
				items: [{
					xtype: 'radio',
					boxLabel: '日期',
					name: 'type',
					checked: isDate,
					inputValue: 'date()',
					listeners: {
						change : function(){
							if(this.checked) {
								this.ownerCt.down('numberfield[name=length_y]').hide();
								this.ownerCt.down('numberfield[name=length_x]').hide();
							} else {
								this.ownerCt.down('numberfield[name=length_x]').show();
							}
						}
					}
				},{
					xtype: 'radio',
					boxLabel: '字符串',
					name: 'type',
					checked: isStr,
					inputValue: 'varchar2'
				},{
					xtype: 'radio',
					boxLabel: '数字',
					name: 'type',
					checked: !isDate && !isStr,
					inputValue: 'number',
					listeners: {
						change : function(){
							if(this.checked) {
								this.ownerCt.down('numberfield[name=length_y]').show();
								this.ownerCt.down('numberfield[name=length_x]').setMaxValue(38);
								this.ownerCt.down('numberfield[name=length_x]').validate();
							} else {
								this.ownerCt.down('numberfield[name=length_y]').hide();
								this.ownerCt.down('numberfield[name=length_x]').setMaxValue(2000);
							}
						}
					}
				},{
					xtype: 'numberfield',
					fieldLabel: '长度',
					name: 'length_x',
					format: '0',
					value: x,
					hidden: isDate,
					maxText: '超过最大长度',
					listeners: {
						change: function(f){
							var a = f.ownerCt.down('radio[checked=true]').inputValue;
							if(a == 'number') {
								f.setMaxValue(38);
							} else {
								f.setMaxValue(2000);
							}
						}
					}
				},{
					xtype: 'numberfield',
					fieldLabel: '小数位数',
					name: 'length_y',
					hidden: isDate || isStr,
					format: '0',
					maxValue: 57,
					maxText: '超过最大数57',
					value: y
				}]
			}],
			buttonAlign: 'center',
			buttons: [{
				text: '确定',
				handler: function(b){
					var w = b.ownerCt.ownerCt;
					v = w.down('radio[checked=true]').inputValue;
					x = w.down('numberfield[name=length_x]').value || 0;
					y = w.down('numberfield[name=length_y]').value || 0;
					if(v == 'varchar2') {
						v += '(' + x + ')';
					} else if (v == 'number') {
						v += '(' + x + ',' + y + ')';
					}
					f.setValue(v);
					record.set(f.name, v);
					w.close();
				}
			},{
				text: '取消',
				handler: function(b){
					b.ownerCt.ownerCt.close();
				}
			}]
		});
    },
    getRules: function(grid){
    	var datas = new Array();
    	if(grid.cfg && grid.cfg.length > 0) {
    		datas = grid.cfg;
    		var keys;
    		Ext.each(datas, function(d){
    			keys = Ext.Object.getKeys(d);
    			Ext.each(keys, function(k){
    				d[k] = d[k] == null ? '' : d[k];
    			});
    			d.id_visible = d.id_visible == 1;
    			d.id_need = d.id_need == 1;
    		});
    	} else {
    		datas = [{id_detno:1,id_width:100},{id_detno:2,id_width:100},{id_detno:3,id_width:100},
    		         {id_detno:4,id_width:100},{id_detno:5,id_width:100},{id_detno:6,id_width:100},
    		         {id_detno:7,id_width:100},{id_detno:8,id_width:100},{id_detno:9,id_width:100},
    		         {id_detno:10,id_width:100}];
    	}
    	return datas;
    },
    /**
     * 数据校验
     */
    checkdata: function(grid){
    	var me = this, count = grid.down('pagingtoolbar').dataCount, pageSize = 5000, page = 0, a, b,
    		len = Math.ceil(count/pageSize), index = 0;
    	var p = Ext.create('Ext.ProgressBar', {
			width: '60%',
			text: '准备校验中...',
			floating: true,
			renderTo: Ext.getBody()
		}).show();
    	grid.setLoading(true);
    	//先删除上次校验记录
    	Ext.Ajax.request({
    		url: basePath + 'system/beforeCheckLog.action',
    		params: {
    			id: grid.ilid
    		},
    		method: 'post',
    		callback: function(opt, s, r){
    			var res = Ext.decode(r.responseText);
    			if(res.success) {
    		    	while (page*pageSize < count) {
    		    		a = page * pageSize + 1;
    		    		b = (page + 1) * pageSize;
    		    		Ext.Ajax.request({
    		        		url: basePath + 'system/checkInitData.action',
    		        		timeout: 30000,
    		        		async: false,
    		        		method: 'post',
    		        		params: {
    		        			id: grid.ilid,
    		        			start: a,
    		        			end: b
    		        		},
    		        		callback: function(opt, s, r){
    		        			var rs = Ext.decode(r.responseText);
    		        			if(rs.exceptionInfo) {
    		        				grid.setLoading(false);
    		        				p.destroy();
    		        				Ext.Msg.alert('发现错误', rs.exceptionInfo);return;
    		        			}
    		        			index++;
    		        			p.updateProgress(index/len, '完成' + index/len*100 + '%', true);
    		        			if(index == len) {
    		        				p.updateProgress(0.4, '准备完毕，正在校验...', true);
    		        				Ext.Ajax.request({
    		        		    		url: basePath + 'system/afterCheckLog.action',
    		        		    		timeout: 30000,
    		        		    		params: {
    		        		    			id: grid.ilid
    		        		    		},
    		        		    		method: 'post',
    		        		    		callback: function(opt, s, r){
    		        		    			var res = Ext.decode(r.responseText);
    		        		    			if(res.success) {
    		        		    				p.updateProgress(0.8, '校验完成，正在获取校验结果...', true);
    		        		    				grid.setLoading(false);
    		        		    				//刷新grid.renderer
    		    		        				me.getCheckResult(grid, p);
    		        		    			}
    		        		    		}
    		        				});
    		        			}
    		        		}
    		        	});
    		    		page++;
    		    	}
    			} else {
    				if(res.exceptionInfo) {
        				if(res.exceptionInfo = '数据超过5000条,请分批导入'){
        					alert('数据超过5000条,请分批导入!');
        					grid.setLoading(false);
            				p.destroy();
            				return;
        				}
        			}
    				alert('系统错误，准备校验失败!');
    				grid.setLoading(false);
    				p.destroy();
    			}
    		}
    	});
    },
    /**
     * 从数据库取校验结果
     */
    getCheckResult: function(grid, p){
    	grid.setLoading(true);
    	Ext.Ajax.request({
    		url: basePath + 'system/getCheckResult.action',
    		timeout: 15000,
    		params: {
    			id: grid.ilid
    		},
    		method: 'post',
    		callback: function(opt, s, r){
    			p.destroy();
    			grid.setLoading(false);
    			var rs = r.responseText;
    			if(rs != null && rs != '') {
    				grid.errorNodes = rs.replace(/\s/g, '').split(';|,').filter(function(a){
    					return a != '' && a != ' ';
    				});
    			} else {
    				grid.errorNodes = [];
    				alert('系统错误，未找到校验结果.');
    			}
    			grid.showErrors();
    	    	Ext.getCmp('errdownload').show();
    	    	Ext.getCmp('onlyerror').show();
    	    	Ext.getCmp('toformal').show();
    	    	/*Ext.getCmp('errdelete').show();
    	    	Ext.getCmp('saveupdates').show();*/
    		}
    	});
    },
    toformal: function(grid){
    	var count = grid.down('pagingtoolbar').dataCount, pageSize = 2000, page = 0, a, b,
			len = Math.ceil(count/pageSize), index = 0;
		if ('Purchase' == grid.caller || 'Sale' == grid.caller || 
				'PurchasePrice' == grid.caller || 'SalePrice' == grid.caller ||
				'ProdInOut' == grid.caller || 'Estimate' == grid.caller ||
				'Make' == grid.caller || 'SaleForecast' == grid.caller
				|| 'GoodsSend' == grid.caller||'ARBill'==grid.caller||'APBill'==grid.caller||
    			'ProdInOut!ExchangeIn'==grid.caller||'ProdInOut!SaleBorrow'==grid.caller||
    			'ProdInOut!OtherPurcIn'==grid.caller||"Make!Mac"==grid.caller||"Make!IMEI"==grid.caller||"Make!MakeSN"==grid.caller || "Make!SaleSN"==grid.caller ) {
			pageSize = count;
			len = 1;
		}
		var p = Ext.create('Ext.ProgressBar', {
			width: '60%',
			text: '准备中...',
			floating: true,
			renderTo: Ext.getBody()
		}).show();
		grid.setLoading(true);
		Ext.Ajax.request({
			url: basePath + 'system/beforeToFormal.action',
			params: {
				id: grid.ilid
			},
			callback: function(opt, s, r){
				if (!s) {
					grid.setLoading(false);
					p.destroy();
					var rs = Ext.decode(r.responseText);
					if(rs.exceptionInfo) {
						showError(rs.exceptionInfo);return;
					}
				}
				var res = Ext.decode(r.responseText);
				if(res.success) {
					while (page*pageSize < count) {
						a = page * pageSize + 1;
						b = (page + 1) * pageSize;
						p.updateProgress(index/len, '开始导入' + index/len*100 + '%', true);
						Ext.Ajax.request({
				    		url: basePath + 'system/toFormalData.action',
				    		timeout: 30000,
				    		method: 'post',
				    		async: false,
				    		params: {
				    			id: grid.ilid,
				    			start: a,
				    			end: b
				    		},
				    		callback: function(_opt, _s, _r){
				    			var rs = Ext.decode(_r.responseText);
				    			if(rs.exceptionInfo) {
				    				grid.setLoading(false);
				    				p.destroy();
				    				showError(rs.exceptionInfo);return;
				    			} else if(_s){
				    				index++;
	    			    			p.updateProgress(index/len, '完成' + index/len*100 + '%', true);
	    			    			if(index == len) {
	    			    				grid.setLoading(false);
	    			    				p.destroy();
	    			    				alert('转入成功!');
	    			    				Ext.Ajax.request({
	    			    		    		url: basePath + 'system/afterToFormal.action',
	    			    		    		params: {
	    			    		    			id: grid.ilid
	    			    		    		},
	    			    		    		callback: function(){
	    			    		    			
	    			    		    		}
	    			    				});
	    			    			}
				    			} else
				    				return;
				    		}
				    	});
						page++;
					}
				} else {
					grid.setLoading(false);
					p.destroy();
					showError(res.exceptionInfo);
				}
			}
		});
    },
    /**
     * 保存已修改的数据
     */
    saveUpdates: function(grid){
    	var items = grid.store.data.items,arr = new Array(), d;
    	Ext.each(items, function(item){
    		if(item.dirty) {
    			d = item.data;
    			delete d.log;
    			arr.push(d);
    		}
    	});
    	Ext.Ajax.request({
    		url: basePath + 'system/updateInitData.action',
    		method: 'post',
    		params: {
    			data: Ext.encode(arr)
    		},
    		callback: function(opt, s, r) {
    			var res = Ext.decode(r.responseText);
    			if(res.success) {
    				alert('保存成功!');
    				grid.getGridData(1);
    			}
    		}
    	});
    },
    /**
     * 删除校验错误数据
     */
    deleteErrors: function(grid) {
    	Ext.Msg.alert('提示', '确定删除?', function(btn){
    		if(btn == 'ok') {
    			Ext.Ajax.request({
    				url: basePath + 'system/init/errdelete.action',
    				params: {
    					id: grid.ilid
    				},
    				callback: function(opt, s, r) {
    					var rs = Ext.decode(r.responseText);
    					if(rs.success) {
    						alert('删除成功!');
    						grid.getGridData(1);
    					}
    				}
    			});
    		}
    	});
    },
    parseLogic: function(logic) {
    	if(logic != null) {
    		var gc = logic.split(';'), str = '';
    		for(var i in gc) {
    			var s = gc[i];
    			if(s != null) {
    				if(s.indexOf('unique') > -1) {
    					str += '唯一性;';
    				} else if(s.indexOf('trim') > -1) {
    					str += '不能包含' + s.replace('trim', '') + ';';
    				} else if(s.indexOf('combo') > -1) {
    					str += '只能是' + s.replace('combo', '') + '之一;';
    				} else if(s.indexOf('accord') > -1) {
    					str += '必须存在于' + s.replace('accord', '') + '中;';
    				} else if(s.indexOf('diffence') > -1) {
    					str += '必须与' + s.replace('diffence', '') + '不同;';
    				}
    			}
    		}
    		return str;
    	}
    	return null;
    },
    
    getMixedGroups: function(items) {
        var data = new Object(), k;
        var name= new Array();
        Ext.each(items, function(d) {
            k = '',j='',n,name=[];           
            if(d!=null && d!=''){
            	name = d.split("-");
            	k=name[0]; 
            	if (k.length > 0) {
	                if (!data[k]) {
	                    data[k] = {
	                        keys: d,
	                        groups: [name[1]||'']
	                    };
	                } else {
	                    data[k].groups.push(name[1]||'');
	                }
               }          
            }              
        });
        return data;
    }
    
});