function addRowToTable()
{
  var tbl = document.getElementById('tblSample');
  var lastRow = tbl.rows.length;
  // if there's no header row in the table, then iteration = lastRow + 1
  var iteration = lastRow;
  var row = tbl.insertRow(lastRow);
  
  row.className="tableitem_"+lastRow%2
  
  // cell 0
  var cell_0 = row.insertCell(0);
  cell_0.width = 20;
  var textNode = document.createTextNode(iteration+1);
  cell_0.appendChild(textNode);
  
  // cell 1
  var cell_1 = row.insertCell(1);
  cell_1.width = 150;
  var el = document.createElement('input');
  el.type = 'text';
  el.name = 'tarih_' + iteration;
  el.id = 'tarih_' + iteration;
  //el.disabled = "true"
  el.size = 8;
  el.className="textbox";
  cell_1.appendChild(el);
  var el = document.createElement('img');
  el.id = 'btntarih_' + iteration;
  el.src = "http://www.mazars.com.tr/upload/www/raporlar/images/takvim.jpg";
  
  cell_1.appendChild(el);
  
  Calendar.setup({
			inputField     :    'tarih_' + iteration,      // id of the input field
			ifFormat       :    "%d.%m.%Y",//"%m/%d/%Y %I:%M %p",       // format of the input field
			showsTime      :    false,            // will display a time selector
			button         :    'btntarih_' + iteration,   // trigger for the calendar (button ID)
			singleClick    :    false,           // double-click mode
			step           :    1,                // show all years in drop-down boxes (instead of every other year as default)
			electric	   :    false
		});
  
  // cell 2
  var cell_2 = row.insertCell(2);
  cell_2.width = 150;
  var el = document.createElement('input');
  el.type = 'text';
  el.name = 'bakiye_' + iteration;
  el.id = 'bakiye_' + iteration;
  el.onblur = calculateadat
  el.onkeyup = formatCurrency2
  el.setAttribute('maxLength',13);
  el.className="currency";
  
  el.size = 10;
  cell_2.appendChild(el);
  var textNode = document.createTextNode(",");
  cell_2.appendChild(textNode);
  var el = document.createElement('input');
  el.type = 'text';
  el.name = 'bakiyekrs_' + iteration;
  el.id = 'bakiyekrs_' + iteration;
  el.onblur = calculateadat
  el.setAttribute('maxLength',2);
  el.size = 1;
  el.className="textbox";
  cell_2.appendChild(el);
  
  // cell 3
  var cell_3 = row.insertCell(3);
  cell_3.width = 150;
  var el = document.createElement('input');
  el.type = 'text';
  el.name = 'kasa_' + iteration;
  el.id = 'kasa_' + iteration;
  el.disabled = "true"
  el.size = 8;
  el.className="currency";
  cell_3.appendChild(el);
  
   // cell 4
  var cell_4 = row.insertCell(4);
  cell_4.width = 150;
  var el = document.createElement('input');
  el.type = 'text';
  el.name = 'faiz_' + iteration;
  el.id = 'faiz_' + iteration;
  el.disabled = "true"
  el.size = 8;
  el.className="currency";
  cell_4.appendChild(el);
}

function startcalculation()
{
	document.getElementById("tblhesaplayici").style.display="block";
	
	var tbl = document.getElementById("tblSample");
	rowcount = 	tbl.rows.length

	for(i=0;i<10-rowcount;i++)
	{
		addRowToTable();
	}
	var tbl = document.getElementById("tblSample");
  	
	mytablebody = tbl.getElementsByTagName("tbody")[0];
	myrow = mytablebody.getElementsByTagName("tr")[0];
	mycel_tarih = myrow.getElementsByTagName("td")[1];
	mycel_bakiye = myrow.getElementsByTagName("td")[2];
	mycel_kasa = myrow.getElementsByTagName("td")[3];
	mycel_faiz = myrow.getElementsByTagName("td")[4];
	
	if(mycel_tarih.childNodes[0].value == "")
	{
	
		mycel_tarih.childNodes[0].value = document.getElementById("txtTARIH").value
		mycel_tarih.childNodes[1].style.display = "none";
		mycel_bakiye.childNodes[0].value = ""
		mycel_bakiye.childNodes[0].disabled = "true"
		mycel_kasa.childNodes[0].value = ""
		mycel_faiz.childNodes[0].value = ""
		
	}
	else
	{
		for(i=0;i<rowcount;i++)
		{
			mytablebody = tbl.getElementsByTagName("tbody")[0];
			myrow = mytablebody.getElementsByTagName("tr")[i];
			mycel_tarih = myrow.getElementsByTagName("td")[1];
			mycel_bakiye = myrow.getElementsByTagName("td")[2];
			mycel_kasa = myrow.getElementsByTagName("td")[3];
			mycel_faiz = myrow.getElementsByTagName("td")[4];
			if(mycel_tarih.childNodes[1].style.display == "none")
			{
				mycel_tarih.childNodes[0].value = document.getElementById("txtTARIH").value
				mycel_tarih.childNodes[1].style.display = "none";
				mycel_bakiye.childNodes[0].value = ""
				mycel_bakiye.childNodes[0].disabled = "true"
				mycel_kasa.childNodes[0].value = ""
				mycel_faiz.childNodes[0].value = ""
			}
		}
		calculateadat();
	}
	
}


function calculateadat()
{
	faiz = document.getElementById("txtFAIZORANI").value
	
	adatmatris = getdata('tblSample')
	generalsum = 0.0;
	adatmatris.sort()
	clearmatrixfaiz(adatmatris);
	i=0;
	for(i=0;i<adatmatris.length-1;i++)
	{
		bakiye = (escapedots(adatmatris[i][2])*1)+adatmatris[i][5]/100;		//yanına kuruşları ekliyoruz
		datediff = Math.ceil((adatmatris[i+1][0] - adatmatris[i][0])*1/(3600 * 24 * 1000));
		if (datediff == 0)   //aynı güne girilirse farkı 0 hesaba katmasın 1 günlük faiz hesaplansın
		{
			datediff++;
		} 
		//alert((bakiye-adatmatris[i][3])*1*faiz*datediff/36000)
		//alert(formatCurrency((bakiye-adatmatris[i][3])*1*faiz*datediff/36000))
		adatmatris[i][4] = (bakiye-adatmatris[i][3])*1*faiz*datediff/36000;
		
		if (!isNaN(adatmatris[i][4]))
		{
			generalsum += adatmatris[i][4];
		}
		adatmatris[i][4] = formatCurrency(adatmatris[i][4],true)
	}
	cleartable('tblSample');
	databind('tblSample',adatmatris,generalsum);
	
}

function databind(table,array,generalsum)
{
	var tbl = document.getElementById(table);
  	
	tblindex=0;
	for(i=0;i<array.length;i++)
	{
		if(array[i][0]!=undefined)
		{
			mytablebody = tbl.getElementsByTagName("tbody")[0];
			myrow       = mytablebody.getElementsByTagName("tr")[tblindex];
			mycel_tarih = myrow.getElementsByTagName("td")[1];
			mycel_bakiye = myrow.getElementsByTagName("td")[2];
			mycel_kasa = myrow.getElementsByTagName("td")[3];
			mycel_faiz = myrow.getElementsByTagName("td")[4];
	
			mycel_tarih.childNodes[0].value = array[i][1]
			if(array[i][0]-1 == countmilisecond(document.getElementById("txtTARIH").value))   //aynı tarihler girilirse adat hesaplanacak tarih aşağıya insin diye 1 milisaniye değer değişikliği var o yüzden 1 milisaniye fark kontrolü
			{
				mycel_tarih.childNodes[1].style.display = "none";
				mycel_bakiye.childNodes[0].disabled = "true"
			}
			else
			{
				mycel_tarih.childNodes[1].style.display = "";
				mycel_bakiye.childNodes[0].disabled = ""
			}
			mycel_bakiye.childNodes[0].value = array[i][2]
			mycel_bakiye.childNodes[2].value = array[i][5]
			mycel_kasa.childNodes[0].value = array[i][3]
			mycel_faiz.childNodes[0].value = array[i][4]
			tblindex++;
		}
	}
	document.getElementById("spn_generalsum").innerHTML = formatCurrency(generalsum,true);
}
function getdata(table)
{
	var kasa = document.getElementById("txtKASABAKIYESI").value
	if(isNaN(kasa) || kasa == "") kasa=0;
	var tbl = document.getElementById(table);
	adatmatris = new Array (tbl.rows.length);
	for (i = 0; i < adatmatris.length; ++ i)
	adatmatris[i] = new Array (3);
  	
	arrayindex=0;
	for(i=0;i<tbl.rows.length;i++)
	{
		mytablebody = tbl.getElementsByTagName("tbody")[0];
		myrow       = mytablebody.getElementsByTagName("tr")[i];
		mycel_tarih = myrow.getElementsByTagName("td")[1];
		mycel_bakiye = myrow.getElementsByTagName("td")[2];
		mycel_kasa = myrow.getElementsByTagName("td")[3];
		mycel_faiz = myrow.getElementsByTagName("td")[4];
		
		if(mycel_tarih.childNodes[0].value != "")
		{
			adatmatris[arrayindex][0] = countmilisecond(mycel_tarih.childNodes[0].value)	//tarih milisecond
			adatmatris[arrayindex][1] = mycel_tarih.childNodes[0].value						//tarih
			if(mycel_tarih.childNodes[1].style.display=="none")		//aynı tarihler girilirse adat hesaplanacak tarih aşağıya insin diye 1 milisaniye değer değişikliği
			{
				adatmatris[arrayindex][0] ++ ;
			}
			adatmatris[arrayindex][2] = mycel_bakiye.childNodes[0].value					//bakiye
			adatmatris[arrayindex][3] = kasa												//kasa
			adatmatris[arrayindex][4] = mycel_faiz.childNodes[0].value						//faiz	
			adatmatris[arrayindex][5] = mycel_bakiye.childNodes[2].value					//bakiyenin kuruşu
			arrayindex++;
		}

	}
	
	/*adatmatris[0][0] = countmilisecond("01.02.2006")
	adatmatris[0][1] = "01.02.2006"	
	adatmatris[0][2] = "4000"
	adatmatris[0][3] = "1000"	
	adatmatris[0][4] = ""								
			
	adatmatris[1][0] = countmilisecond("10.01.2006")
	adatmatris[1][1] = "10.01.2006"			
	adatmatris[1][2] = "8000"
	adatmatris[1][3] = "1000"
	adatmatris[1][4] = ""
	
	adatmatris[2][0] = countmilisecond("14.01.2006")
	adatmatris[2][1] = "14.01.2006"
	adatmatris[2][2] = "1000"
	adatmatris[2][3] = "1000"
	adatmatris[2][4] = ""
	
	adatmatris[3][0] = countmilisecond("12.01.2006")
	adatmatris[3][1] = "12.01.2006"
	adatmatris[3][2] = "1000"
	adatmatris[3][3] = "1000"
	adatmatris[3][4] = ""
	
	adatmatris[4][0] = countmilisecond("12.05.2006")
	adatmatris[4][1] = "12.05.2006"
	adatmatris[4][2] = ""
	adatmatris[4][3] = ""
	adatmatris[4][4] = ""
	for(i=0;i<adatmatris.length;i++)
	{
		alert(adatmatris[i][0]+' '+adatmatris[i][1]+' '+adatmatris[i][2]+' '+adatmatris[i][3]+' '+adatmatris[i][4]);
	}*/
	
	return adatmatris;

}
function cleartable(table)
{
	var tbl = document.getElementById(table);
	tblindex=0;
	for(i=0;i<tbl.rows.length;i++)
	{
		
		mytablebody = tbl.getElementsByTagName("tbody")[0];
		myrow       = mytablebody.getElementsByTagName("tr")[i];
		mycel_tarih = myrow.getElementsByTagName("td")[1];
		mycel_bakiye = myrow.getElementsByTagName("td")[2];
		mycel_kasa = myrow.getElementsByTagName("td")[3];
		mycel_faiz = myrow.getElementsByTagName("td")[4];

		mycel_tarih.childNodes[0].value = ""
		mycel_bakiye.childNodes[0].value = ""
		mycel_kasa.childNodes[0].value = ""
		mycel_faiz.childNodes[0].value = ""
			
	}
	document.getElementById("spn_generalsum").innerHTML = formatCurrency(generalsum,true);
}
function clearmatrixfaiz(adatmatris)
{
	for(i=0;i<adatmatris.length;i++)
	{
		
		adatmatris[i][4] = ""		
			
	}
}