// jq_askdb.js

var _dbYear = "2010";
/*
$(_div).askdb({keywords:[
	"lastname",
	"firstname",
	"district",
	"rating",
	"numraters",
	"year"
	
	player,
	
]});
*/
var askdbQs = [
{
	eng: "Breakdown by District",
	sql: "SELECT district, COUNT(*) as players,"+
		"ROUND(avg(rating),2) as avr_rtg, "+
		"ROUND(min(rating),2) as best,"+
		"ROUND(max(rating),2) as worst,"+
		"ROUND(avg(numraters),1) as avr_rtrs,"+
		"min(numraters) as least,"+
		"max(numraters) as most,"+
		"year"+
		" FROM `shuf_ratings` "+
		" where year="+_dbYear+
		" GROUP BY district",
	rtncols:["district","players","avr_rtg","best","worst",
				"avr_rtrs","least","most"],
	sort: 0
},{
	eng: "this is question 2"
},{
	eng: "this is question 3"
}


];
//---------------------------------
$.fn.askdb = function(o)
	{
	var askdb = $(this).addClass("askdb");
/*	
	var panel = $(_div).addClass("panel").appendTo(askdb);
	$(_div).addClass("textLink").html("Add a Question")
	.bind("click", function(){
		$(this).modal({
			height: 300, width: 500,draw: drawAskDBDlog
		});
	})
	.appendTo(panel);
*/
	askdb_drawQs(askdb);

	return askdb;
	}

//--------------------------------------------------
function drawAskDBDlog(div)
	{
	$(_div).addClass("askdb_title").html("SQL").appendTo(div);
	$(_textarea).addClass("askdb_sql").appendTo(div)
	.focus().select();

	$(_div).addClass("askdb_title").html("Question").appendTo(div);
	$(_textarea).addClass("askdb_sql").appendTo(div);
	
	//ShutModal();

	}

	
//--------------------------------------------------
function askdb_drawQs(div)
{
	for (var i = 0; i < askdbQs.length; ++i) {
		var q = askdbQs[i];
		$(_div).html(q.eng)
		.attr("i",i)
		.addClass("askdb_question").hover(function()
		{
			$(this).css({
				color: "yellow"
			});
		}, function()
		{
			$(this).css({
				color: "#bbbbbb"
			});
		})
		.bind("click",function(){
			var ques = $(this);
			if (ques.attr("open"))
				{
				ques.next().remove();
				ques.removeAttr("open");	
				}
			else
				{
				ques.attr("open",true);
				var rec = askdbQs[ques.attr("i")];
				$(_div)
				.insertAfter(ques)
				.table({php:"shuf_ratings.php",sqlinfo: rec});
				}
		})
		.appendTo(div);
	}
}