/**
 * @author philip.ward
 * 
 * November 2008: Script being re-written to use jQuery and jQuery UI.
 */
 
//	Global variables (values cached in memory)

var currentPopup = 0;	//	need to keep global...

//function getFeedback (event_id, event_name, event_date, event_location) // Calls feedback screen

function largeFont() {	// Increase the font size in the results table

	var f = $("#resultsTable").css('font-size');
	f = f.substr(0,2);
	f++;
	$("#resultsTable").css('font-size', f + 'px');
	
}

function littleFont() {	//	Decrease the font size in the results table
	
	var f = $("#resultsTable").css('font-size');
	f = f.substr(0,2);
	f--;
	$("#resultsTable").css('font-size', f + 'px');
	
}

function showVideo (eventID, eventTitle, eventDate, eventPlace) {	//	Show a YouTube video, or an MP4 on the site, in one of the popups

	var h = "<DIV class=drag-video><TABLE id='headertable' width='100%'><TR><TD align=left><B>" + eventTitle + "</B></TD><TD align=right><input class='press' type='button' value='Close' onclick='closeVideo()'></TD></TR></TABLE></DIV>";
	
	if (eventID.length > 9) {		//	Video is on YouTube
		h += "<object id='video' width='425' height='344'>";
		h += "<param name='movie' value='http://www.youtube.com/v/" + eventID + "&hl=en&fs=1'></param>";
		h += "<param name='allowFullScreen' value='true'></param>";
		h += "<param name='allowscriptaccess' value='always'></param>";
		h += "<embed src='http://www.youtube.com/v/" + eventID + "&hl=en&fs=1' type='application/x-shockwave-flash' allowscriptaccess='always' allowfullscreen='true' width='425' height='344'></embed>";
		h += "</object>";		
	} else {	//	Video is on our server - we use JW FLV Player		
		h += "<span id='preview'>The player will show in this paragraph</span>";
		h += "<script type='text/javascript' src='video/swfobject.js'></script>";
		h += "<script type='text/javascript'>";
		h += "var s1 = new SWFObject('video/player.swf','player','480','360','9');"; 
		h += "s1.addParam('allowfullscreen','true');";
		h += "s1.addParam('allowscriptaccess','always');";
		h += "s1.addParam('flashvars','file=" + eventID + ".mp4');";
		h += "s1.write('preview');";
		h += "</script>";
	}

	h += "<br>" + eventDate + ", " + eventPlace;
	
	//	Add an opaque background to the screen:
	
	log("Opaquing display");
	
	$("#opback").fadeTo(1,0.7).show();
	
	log("Showing video DIV");	
	
	$("#popup10").html(h).fadeIn("slow").addClass("video").draggable({
		handle: "div"
	});	//	since popup 10 is unlikely to be open...
	
	//	Set DIV width to match movie container width:
	
	var w = $("#video").width();
	$("#headertable").width(w-8);
	
	//	Center the video:
	
	var ww = $(window).width() - $("#popup10").width();
	$("#popup10").css({"left":ww/2 + "px"});
	
	log("Video should be ready to play");
}

function closeVideo() { // Close the video opened with showVideo

	log("Hiding opaque");
	$("#opback").fadeTo(1,0).hide();

	log("Closing video...");
	$("#popup10").fadeOut("slow").html("").draggable({
		handle: "div",
		cursor: "default"
	});
	
	$(".div").css('cursor','auto');	// Sometimes this doesn't happen automatically.

	log("Done");
	
}

function xmlHttpPost(strURL, strDetails) { // Make Ajax request, process response
	
	//	Pretty standard Ajax stuff; actually, not strictly Ajax as no XML involved.

			var xmlHttpReq = false;
			var self = this;
			
			// Decide which browser we are using:
			
			// Mozilla / Safari
			if (window.XMLHttpRequest) {
				self.xmlHttpReq = new XMLHttpRequest();

			//	Make sure content is returned as iso-8859-1 to avoid problems with accented characters:
			
				if (self.xmlHttpReq.overrideMimeType) {
            		self.xmlHttpReq.overrideMimeType('text/xml; charset=iso-8859-1');					
				}
				log("Detected Gecko browser");
			}
			// IE
			else if (window.ActiveXObject) {
				self.xmlHttpReq = new ActiveXObject("Microsoft.XMLHTTP");
				log("Detected IE");
			}
			
			log("Submitting " + strDetails);
			report();
			self.xmlHttpReq.open('POST', strURL, true);
			self.xmlHttpReq.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
		 
			self.xmlHttpReq.onreadystatechange = function() {
				log("Ajax ready state " + self.xmlHttpReq.readyState);
				if (self.xmlHttpReq.readyState == 4) {
					var resp1 = self.xmlHttpReq.responseText;
					var resp2 = resp1.substr(0,7);
					log ("Received " + resp1);
					switch (resp2) {
						case "Display":
							updateRow(resp1.substr(7), "");
							break;
						case "Failed ":
							alert("Database operation failed: " + resp1);
							break;
						case "No Priv":
							alert("No privilege for requested operation.");
							break;
						case "Duplica":
							alert("Duplicate entry attempted.");
							break;
						case "No such":
							alert("No entry found with this ID.");
							break;
						case "Timeout":
							alert("Session timed out. Please log on again.");
							break;
						case "Illegal":
							alert(resp1);
							break;
						case "INSERT:":
							var objId = resp1.substr(7);
							$("#object_" + currentPopup).val(objId);
							log("Inserted " & objId & " from popup ID");
						case "Success":
							log("Current popup: " + currentPopup);
							updatePopup(currentPopup);
							break;
						case "Results":
							resp1 = resp1.substr(7);
							updateResults(resp1, 'results');
							break;
						case "Excel  ":
							resp1 = resp1.substr(7);
							$("body").html(resp1);
							break;
						case "UPDATE:": 
							break;
						case "Fedback": ackFeedback();	//	Acknowledge feedback
							break;
						case "Donkey:": eatGrass(resp1);	//	Vulgar obfuscation
							break;
						default: alert(resp1);						
					}
					report();
				}
			}
			log("Sending request...");
			self.xmlHttpReq.send(strDetails); 
		}

function updateResults(someHtml, someObject) { // Updates content of a HTML object
	
	log("updateResults: " + someHtml.length);
	log("Object: " + someObject);
	
	//	This is necessary as the jQuery procedure apparently doesn't work with old IE versions.
		
//	if (window.ActiveXObject) { // We have some problems with old IE...
		var q = document.getElementById(someObject);
		q.innerHTML = someHtml;
/*	} else {
		$(someObject).html(resp1);
	}
*/	
	if (someHtml.indexOf("</TABLE>")>0) {
		$("#provFeedback").show();
	}
	
	log("Loaded HTML");
	
	report();
	
	return;
	
}

function resizeWindow(newWidth,newHeight) { // Resize window
	window.resizeTo(newWidth,newHeight);
	return;	
}

function closeConfirm(popupId, parentId) { // Close a popup, focus parent popup (if any)

	//	Hide and empty the current popup, make draggable:
	
	$("#popup" + popupId).hide("normal").html("").draggable({handle: "div"});
	
	//	If the parent of this popup was another popup, fade it back in:
	
	if (parentId > 0) {
		$("#popup" + parentId).fadeTo("normal", 1);
	}
	
	$("WzTtDiV").hide();	//	In case any ToolTips still open.
	
	$(selectedRow).removeClass("selectedRow");
	
	if (currentPopup == popupId) {
		currentPopup = 0;
	}
	
	report();

	return;
}

function makeDivs() { // Creates 10 invisible DIVs which can then be used for popup windows, sets different background colors and cascades them.

	//	Make all popups draggable using the drag handle, and hide them:
	
	$(".popup").hide().draggable({
		handle: ".drag-handle",
		dragPrevention: "a,input,textarea,table,.multiSelectOptions",
		cursor: "move"
	});
	
	//	Add an opaque background DIV for the lightbox simulation, hide it for now:
	
	$("#opback").addClass("opaqueBackground").hide();
}

function toggleDrag(popup) { // Removes draggable attribute from a popup, allowing text selection
	
	$("#popup" + popup).draggable("destroy");
	
}

function submitForm() { // Submits a form
	document.form.submit();
}

function openPopup(toEdit, objId, userId, sessionId, parentId){ // Opens a popup for data editing 

	// Find a popup we can use:
	
	var i = 0;
	var j = 0;
	
	for (i = 1; i < 11; i++) {
		if ($("#popup" + i).html() == "") {
			j = i;
			i = 11;
		}
	}
	
	if (j == 0) {
		alert("Too many popup windows open. Please close at least one.");
		return;
	}
	else {
		var p = "#popup" + j;
	}
	
	//	Make the popup visible:
	
	$(p).show().html("<H1>Loading data...</H1>");
	
	//	Fade the parent popup, if there is one:
	
	if (parentId > 0) {
		$("WzTtDiV").hide(); //	In case any ToolTips still open.
		$("#popup" + parentId).fadeTo("normal", 0.6);
	}
	
	//	Populate the popup:
	
	loadPopup(toEdit, objId, userId, sessionId, parentId, j);
	currentPopup = j;
	return j;
}

function loadPopup(toEdit, objId, userId, sessionId, parentId, popupId) { // Loads content of a popup window
	
	//	Determine the Ajax query:
	
	log("Running loadPopup for parent " +  parentId + ", child " + popupId + ", objId " + objId + ", type " + toEdit + ", user:" + userId + ", session: " + sessionId);
	
	var l = toEdit.length;
	
	if (toEdit.substr(l-3) == "_id") {
		toEdit = toEdit.substr(0, l-3) + "s";
	}
	
	if (toEdit == "citys") {	// Special case of plural
		toEdit = "cities";
	};
	
	//	Parameters to send to the server: type of object to edit, object ID, user ID, session ID, popup ID, parent ID.
	var qry = "?w=" + toEdit + "~~~" + objId + "~~~" + userId + "~~~" + sessionId + "~~~" + popupId + "~~~" + parentId;
	var url = "http://talks.sahajayogaonline.com/cgi-bin/easyEditNew.pl" + qry;
	
	//	Ajax query to database, returned content is loaded into popup window:
	
	$("#popup" + popupId).load(url);
	
	//	"reactivate" the buttons:
	
	$("dataentry input").attr("color", "#000000");


}

function removeLink(table, user, col1, val1, col2, val2, popupId) {	//	Removes an entry in a many-to-many link table by creating a Ajax request and passing it to a M2M script on the server.
	
	/* Arguments: CGI script to run
	 * 			
	 * 
	 * Typical arguments to Perl CGI script:
	 * 
	 * w=tracks+add+Phil+event_id+213+tape_id+1234
			
	 */
	
	var url = "http://talks.sahajayogaonline.com/cgi-bin/mtm.pl";
	var par = "w=" + table + "+remove+" + user + "+" + col1 + "+" + val1 + "+" + col2 + "+" + val2;

	if (confirm("Do you really want to de-link?")) {
	
		xmlHttpPost(url, par);
		
	}
	
	updatePopup(popupId);
	
	return;
	
}

function updatePopup (popupId) { // Updates the content of a popup

	//	First identify which of the several forms on screen is being used:
	
//	alert("Updating popup " + popupId);

	$("#popup" + popupId).fadeTo("fast", 1);
	
	for (var k=0;k<20;k++) {
//		alert(k + " " + document.forms[k].id);
		if (document.forms[k].id == "easyForm_" + popupId) {
			var myForm = document.forms[k];
			k = 22;
		}
	}
	
	if (k < 22) {
		alert("Could not find form for easyForm_" + popupId);
		return;
	}
	
	var toEdit = myForm.type.value;
	var objId = myForm.object.value;
	var userId = myForm.user.value;
	var sessionId = myForm.session.value;
	var parentId = myForm.parent.value;
	
//	alert("Calling loadPopup for ID " + objId);
	
	loadPopup(toEdit, objId, userId, sessionId, parentId, popupId);
	
	return;		
	
}

function addLink(table, user, col1, val1, col2) { // adds a many-to-many link between data objects from a popup
	
	//	The opposite of removeLink...
		
	var url = "http://talks.sahajayogaonline.com/cgi-bin/mtm.pl";
	var tableName = col2.substr(0, col2.indexOf("_id"));
	var val2 = prompt("Please enter the ID of the " + tableName + " that you want to link to.");
	
	if (val2 != "") {
		var par = "w=" + table + "+add+" + user + "+" + col1 + "+" + val1 + "+" + col2 + "+" + val2;
		xmlHttpPost(url, par);		
	} else {
		alert("No " + tableName + " ID specified.")
	}
	
	var toEdit = myForm.type.value;
	var objId = myForm.object.value;
	var userId = myForm.user.value;
	var sessionId = myForm.session.value;
	var parentId = myForm.parent.value;
	
	updatePopup(popupId);

	return;
}

function easyChanges(sqlQry) { // Pass a query to a host script for execution.
	 
	var url = "http://talks.sahajayogaonline.com/cgi-bin/easyUpdate.pl";
	
	var qry = escape(sqlQry);
	xmlHttpPost(url, qry);
	
	return;
	
}

function makeChanges(someId, tableName, session, popupId) {	// From popup, updates the database for the object of given ID and type (table name).
	
	//	First identify which of the several forms on screen is being used:
	
	log("parameters: " + someId + " " + tableName + " " + session + " " + popupId);
	
	var myForm = $("#easyForm_" + popupId);
	var currentUser = $("#user_" + popupId).attr('value');	
	
	//	Go through the form and identify changeable fields:
	
	var qry;
	var values = "";
	var commaWritten = 0;
	var i;	
	var histText;
	var url = "http://talks.sahajayogaonline.com/cgi-bin/udb.pl";
	var curVal = "";
	var oldVal = "";
	var fieldName = "";
	
	//	Identify the parent:
	
	var parent = $("#parent_" + popupId).val();
	
	//	The object ID is contained within the form as a hidden value, so it's not
	//	necessary to get it from the function arguments.
	
	var objectId = $("#object_" + popupId).val();
	
	if (objectId == "0") {	//	New object creation
		qry = "INSERT|" + tableName + "|";
		histText = "Created by " + currentUser + " " + document.lastModified;
	} else {
		qry = "UPDATE|" + tableName + "|" + objectId + "|";
		histText = "Updated by " + currentUser + " " + document.lastModified;
	}
	
	var allInputs = $("#easyForm_" + popupId + " > :input");
	
	//	Run through the fields, one by one:
	
	var commaWritten = 0;
	
	$(allInputs).each(function() {
		
		curVal = $(this).val();
		fieldName = $(this).attr('name');
		
		if ($(this).attr("type") == "select-one") {
			oldVal = $(this).attr('default');
		} else {
			oldVal = $(this).attr("defaultValue");
		}
		
		if (curVal != oldVal) {

			if (commaWritten == 0) {
				commaWritten = 1;
			}
			
			histText = histText + "<BR><B>" + fieldName + ":</B> " + oldVal + " -QamphashQ62QsemicolonQ " + curVal;							

			curVal = hformat(curVal);
			oldVal = hformat(oldVal);
						
			//	Special treatment for duration fields:
			if ($(this).hasClass("duration") == true) {
				var z = curVal.indexOf("( ");
					
				if (z>0) {
					curVal = curVal.substr(z+2);
					z = curVal.indexOf(" sec");
					curVal = curVal.substr(0, z-1);					
				}				
			}			
			qry = qry + fieldName + "=" + curVal + "|";
		}		
	})
	
	//	Repeat the process for any multiSelect inputs:
	
	$(".popup .multiSelect > span").each(function() {
		curVal = $(this).html();
		log("curVal: " + curVal);
		fieldName = $(this).parent().attr('id');
		log("fieldName: " + fieldName);
		
		//	Default values from hidden input:
		
		oldVal = $("#default" + fieldName).val();
		log("oldVal: " + oldVal);
		
		if (curVal != oldVal) {
			fieldName = $("#default" + fieldName).attr('name');
			log(">> fieldName: " + fieldName);

			if (commaWritten == 0) {
				commaWritten = 1;
			}
			
			histText = histText + "<BR><B>" + fieldName + ":</B> " + oldVal + " -QamphashQ62QsemicolonQ " + curVal;							

			curVal = hformat(curVal);
			oldVal = hformat(oldVal);
						
			qry = qry + fieldName + "=" + curVal + "|";
			
		}
	})
		
	if (commaWritten==0) {
		alert("No changes made.");
		return;
	}
	
	qry = "w=" + session + "|" + qry + "history=" + histText;
	
	report();

	var currentPopup = popupId;

	//	Update the parent popup or window:
	
	//	Make the form look as though it has been disabled:
	
	$("#popup" + popupId).fadeTo("fast", 0.8);

	url = url + "?" + qry;

	var objId = $("#object_" + popupId).val();

	var x = $.get(url, function(data) {
		
		if (data.substr(0,6) == "INSERT") {
			objId = parseInt(data.substr(7));
			$("#object_" + popupId).val(objId);
		}
		
		//	Update the current popup
		updatePopup(currentPopup);
		
		if (parent == 0) {
			url = location.href;
			
			var sf = url.indexOf("SimpleForm.pl");
			if (sf != 0) {
				url = url.substring(0, sf) + "SimpleFormLoad.pl";
			}
			
			log("URL: " + url);
			//	Update the results listing:
			qry = "objId=" + objectId + "&user=" + currentUser + "&session=" + session;
			xmlHttpPost(url, qry);
		} else {
			url="http://talks.sahajayogaonline.com/cgi-bin/easyEditNew.pl";
			//	Update the calling dropdown list in the parent popup:
			qry = "x=" + $("#type_" + popupId).val() + "&objId=" + objId + "&user=" + currentUser + "&session=" + session;
			url += "?" + qry;
			
			$.get(url, function(data) {
				var category = singular(tableName) + "_id_" + parent;
				$("#" + category).html(data);
			});
		}
	});
	
	return false;
}

function hformat(someString) { // Substitute carriage returns and line feeds with <BR>:
	
	someString = escape(someString);

	var re = /%0D%0A/g;		//	Works for Internet Explorer
	someString = someString.replace(re, "<BR>");
	re = /%0A/g;			//	Works for Firefox
	someString = someString.replace(re, "<BR>");
	
	re = /%22/g;	//	Double quote marks
	someString = someString.replace(re, "&#34;");
	
//	alert(someString);
	
	//	Single quotes are not for some reason escaped by encodeURIComponent, so we do that here:
	
	re = /\'/g;
	someString = someString.replace(re, "&#39;");
	
	//	we also have some problems with plus signs:
	
	re = /\+/g;
	someString = someString.replace(re, "&#43;");
	
	//	Now replace percent signs by some string to fool http and perl that this is not an escaped string.
	
	re = /&#/g;
	someString = someString.replace(re, "QamphashQ");	
	
	//	Ditto with semicolons.
	
	re = /;/g;
	someString = someString.replace(re, "QsemicolonQ");	
	
	return someString;
		
}

function showSize () // Returns the size of the current window.

{
	var x = window.innerWidth;
	var y = window.innerHeight;
	var f;
	var q;
	
//	Number of forms in the page: //	
	var n = document.getElementById('feedcount');
	n = n.value;
	
	for (var i=0;i<n;i++) {
		f = 'feed' + i;
		q = document.getElementById(f);
//		alert (q.name + " " + i + " " + n); //
		q.cols = Math.round((x/8)-50);
		q.rows = Math.round(y/250);
	 }
	 
	 x = (x-200)/2;
	 
	 n = document.getElementById('who');
	 n.width = x;	
	 n = document.getElementById('email');
	 n.width = x;
	 
}
 
function showStats (someUser) {
	
		var url = "http://talks.sahajayogaonline.com/cgi-bin/Stats.pl";
		var typeOfStats = 'Feedback'; // may parametrize this later
		
		$("#statsDiv").load(url, { user: someUser, statsType: typeOfStats});
		
}

var selectedRow;