sap ui define sap Table function Table return Table extend sap cc cont

sap.ui.define([
	"sap/m/Table"
], function(Table) {
	return Table.extend("sap.cc.control.CopyPasteTable", {
		onInit: function() {
			console.log("Init: sap.cc.control.CopyPasteTable");
		},
		
		onAfterRendering: function () {
			
			console.log("onAfterRendering: sap.cc.control.CopyPasteTable");			
			
			var that = this;
			sap.m.Table.prototype.onAfterRendering.apply(this, arguments);
			
			this.attachBrowserEvent('paste', function(e){ 
				
				console.log("entering method: attachBrowserEvent");
				
				e.preventDefault();
				var text = (e.originalEvent || e).clipboardData.getData('text/plain');				
				that.insertRows(text,this,undefined);
			});
			
			
			var items = this.getAggregation('items');
			
			if(items == undefined){
				console.log("items undefined!");
				return;
			}
			
			items.forEach(function(row) {
				
				console.log("entering method: getAggregation");
				
				row.getCells().forEach(function(cell) {
					
					console.log("entering method: forEach");
					
					cell.attachBrowserEvent('paste',function(e){
						
						console.log("entering method: attachBrowserEvent");
						
						
						var text = "";
						
						if (window.clipboardData) { // Internet Explorer
							text = window.clipboardData.getData('Text');
						} else {
				        	text = (e.originalEvent || e).clipboardData.getData('text/plain');
						}
						
						var flag = text.search(/\t/);
						if(flag === -1){
							console.log("no tab symbol, that means this simple string");
							e.stopPropagation();
						} else {
							console.log("has tab symbol, that means string from excel");
							e.stopPropagation();
							e.preventDefault();							
						}
						
						
						var domCell = jQuery.sap.domById(e.currentTarget.id)
						var insertCell = jQuery('#'+domCell.id).control()[0];
						var itemsPath = that.getBindingPath('items');
						var pathRow = insertCell.getBindingContext().sPath;
						var startRowIndex = pathRow.split(itemsPath+"/")[1];
						var startProperty = insertCell.getBindingPath('value');
						that.insertRows(text, that, undefined, startRowIndex, startProperty);
					});
				});
			});
			
		},
		
		insertRows:function(value,table,model,startRowIndex,startProperty){

			var that = this;
			var rows = value.split(/\n/);
			var cells = table.getBindingInfo('items').template.getCells();
			var templateItem = [];
			var itemsPath = table.getBindingPath('items');
			var itemsArray = table.getModel(model).getProperty(itemsPath);
			var startPropertyIndex = 0;
			var model = table.getModel(model);
			if(startRowIndex === undefined){
				startRowIndex = 0;
			}
			for (var int = 0; int < cells.length; int++) {
				var cell_element = cells[int];
				var path = cell_element.getBindingPath('value');
				if(path == undefined){
					path = cell_element.getBindingPath('selectedKey');
				}
				if(path == undefined){
					path = cell_element.getBindingPath('text');
				} 
				
				templateItem.push(path);
				if(path === startProperty){
					startPropertyIndex = int;
				}
				
			}
		
			for (var int = 0; int < rows.length-1; int++) {
				var rows_element = rows[int];
				var cells = rows_element.split(/\t/);

				
				var originalObject = model.getProperty(itemsPath+"/"+startRowIndex++);
				if(originalObject === undefined){
					originalObject = {};
					for(var k =0; k < templateItem.length; k++){
						originalObject[templateItem[k]] =undefined;
					}
					itemsArray.push(originalObject);
				}
				
				var lesserLength = Math.min(templateItem.length,(cells.length + startPropertyIndex));
				for(int2 = startPropertyIndex,intValue=0; int2 < lesserLength; int2++,intValue++){
					var name = templateItem[int2];
					originalObject[name] = cells[intValue];
					
				}
				
			}
			
			
			// row numbers
			var list = this.getModel().getProperty('/items');
			for (var int = 0; int < list.length; int++) {
				var elem = list[int];
				var a = int + 1;
				elem.id = "" + a;
			}
			
			model.refresh();
			
		},
		
		renderer: sap.m.Table.prototype.getRenderer()
	});
});