// ---------------------------------------------------------------------
// JAVASCRIPT	: Kamper GUI TABLE DATABASE
// REVISION		: 13mrt07	v1.1
// ---------------------------------------------------------------------

var kgdb_DBTable;		// <table> object where all data resides
var kgdb_DBRows;		// Array of all <tr> in <table>
var kgdb_nrDBRows;
var kgdb_DBCells;		// Array of all <td> in <tr> from <table>
var kgdb_nrDBCells;
var kgdb_DBColumnID = new Array();	// <table><tr><th> contains <title>-tags to identify COLUMN names

// -- FUNCTIONS --------------------------------------

function kgui_getTableData(vQuery) {	// V1
	var record = new Array ();
	var myQuery = vQuery.split("=");
	var columnID = kgdb_DBColumnID.zoek(myQuery[0]);

	for( var i=1; i<kgdb_nrDBRows; i++) {	// Repeat for every <TR> in <TABLE>
		kgdb_DBCells = kgdb_DBRows[i].getElementsByTagName("td");
		// alert ( "["+i+"] "+kgui_stripspaces(DBCells[columnID].innerHTML)+" = "+myQuery[1]);
		if ( kgui_stripspaces(kgdb_DBCells[columnID].innerHTML) == myQuery[1]) { // Record found
			for ( j=0; j<kgdb_nrDBCells; j++ ) {
				record.push(kgdb_DBColumnID[j]);	// <th><title> identifier
				record.push(kgdb_DBCells[j].innerHTML);	// <td> cell content
			}}}
	return record ; // record.join("][");
}

function kgui_resetTabelData(vTabelID) {	// V1
	kgdb_DBTable = MM_findObj(vTabelID);
	kgdb_DBRows = kgdb_DBTable.getElementsByTagName("tr");
	kgdb_nrDBRows = kgdb_DBRows.length;
	kgdb_DBCells = kgdb_DBRows[0].getElementsByTagName("th");
	kgdb_nrDBCells = kgdb_DBCells.length;
	// Scan FIRST TABLE ROW : <tr><th><title> for each column
	// Identify each colmn with an QUERY ID
	for( var j=0; j<kgdb_nrDBCells; j++) kgdb_DBColumnID.push(kgdb_DBCells[j].title);
}

function kgui_copyDBTable(vTblVanID, vTblNaarID) {	// V1
	var v_rows = vTblVanID.getElementsByTagName("tr");
	var v_cols = v_rows[0].getElementsByTagName("td");
	var v_rowLength = v_rows.length, v_colLength=0;
	var n_rows = vTblNaarID.getElementsByTagName("tr");
	var n_cols = n_rows[0].getElementsByTagName("td");

	for ( var row=0; row<v_rowLength; row++ ) {
		n_cols = n_rows[row].getElementsByTagName("td");
		v_cols = v_rows[row].getElementsByTagName("td");
		v_colLength = v_cols.length;
		// alert(row+" - "+colLength);
		for ( var col=0; col<v_colLength; col++) {
			n_cols[col].innerHTML = v_cols[col].innerHTML ;
		}
	}
}