var pastdataXml;


$(document).ready(function(){


	function loadXml(){
/*
		new Ajax(filename, {
			method: 'get',
			onComplete: function(){onloadXml(this.response.xml)}
		}).request();
		
*/
		
		$.get(filename, function(data){
		  onloadXml(data);
		});
	}
	
	function onloadXml(XML){
		pastdataXml = XML;
		var workSheetNames = getWorkSheets(pastdataXml);
		
		for(var sheet=0; sheet<getWorkSheets(pastdataXml).length;sheet++){
			var sheetName = getWorkSheets(pastdataXml)[sheet];
		}
		
		//buildYearlyTimeline(searchFrom);
		buildPastdataTable(0,'data_shien');
		buildPastdataTable(1,'data_dai_kigyou');
		buildPastdataTable(2,'data_chusho_kigyou');
		buildPastdataTable(3,'data_kyotsu');
		buildPastdataTable(4,'data_zeisei');
	}
	
	loadXml();
	
	
	function buildPastdataTable(sheetnum,target){
		
		var targetId = target;
		var html = '';
		var line = 'odd';
		var className = '';
		var sheet = sheetnum;
		
		var sheetName = getWorkSheets(pastdataXml)[sheet];
		var wsObj = getWorkSheet(pastdataXml,sheetName);
		var w = getWorkSheetColCount(wsObj);
		var h = getWorkSheetRowCount(wsObj);

		
		html += '<table>';
		for(var j=0; j<h; j++){
		
			if(j%2==0){
					line = 'even';
					className = '';
				}
			else{
					line = 'odd';
					className = '';
			}
			
			html+='<tr>';
			if(j==0){
				for(var i=0; i<w;i++){
					value = getCellData(pastdataXml,sheetName,i,j);
					if(value != null){
						value = value.replace('&#13;','<br />');
					}
					else{
						value = '─';
					}
					if(i==0){
						html += '<th class="tbody_left">'+ value +'</th>';
					}
					else if(i==1){
						html += '<th class="tbody_center">'+ value +'</th>';
					}
					else if(i==2){
						html += '<th class="tbody_right">'+ value +'</th>';
					}
				}
			}
			else{
				for(var i=0; i<w;i++){
					value = getCellData(pastdataXml,sheetName,i,j);
					if(value != null){
						value = value.replace('&#13;','<br />');
					}
					else{
						value = '─';
					}
					if(i==0){
						html += '<th'+className+'>'+value+'</th>';
					}
					else{
						html += '<td'+className+'>'+value+'</td>';
					}
				}
				
			}
			html +='</tr>';
		}
		html +'</table>';
				
		//alert(html);
		//$(targetId).empty();
		$("#"+targetId).html(html);
	
	}
});