var args = getArgs();
var slist = 0;
if (args.sort) slist=args.sort;
else slist="6"; //Default sort is Villa Name
var QuickBaseURL = new String('');
if(slist == '56'){
	QuickBaseURL = "https://www.quickbase.com/db/bdv4euyky?a=API_GenResultsTable&query={'71'.EX.'yes'}&clist=6.43.72.70.37.71&slist=" + slist + ".6&options=sortorder-DA&jsa=1&username=guest@sunvillas.com&password=viewonly"
}
else{
	QuickBaseURL = "https://www.quickbase.com/db/bdv4euyky?a=API_GenResultsTable&query={'71'.EX.'yes'}&clist=6.43.72.70.37.71&slist=" + slist + "&options='sortorder-A'&jsa=1&username=guest@sunvillas.com&password&password=viewonly"
}


document.write("<SCR" + "IPT Language='JavaScript' SRC=" + QuickBaseURL + ">");
document.write("</SCR" + "IPT>");

function getArgs() {
	var args = new Object();
	var query = location.search.substring(1);
	var pairs = query.split(",");
	for (var i = 0; i < pairs.length; i++) {
		var pos = pairs[i].indexOf('=');
		if (pos == -1) continue;
		var argname = pairs[i].substring(0,pos);
		var value = pairs[i].substring(pos+1);
		args[argname] = unescape(value);
	}
	return args;
}

function WriteSort(){
	document.write("<P><FORM NAME='SortOption' METHOD=GET ACTION='thanksgiving_rates.htm'>");
	document.write("<BR><font face='Verdana' size=2>Sort By: ");
    document.write("<SELECT ID='sort' NAME='sort' onChange='SortTable();'>");
	document.write("<OPTION ");
		if (slist==13) document.write(" SELECTED ");
		document.write(" Value=6>Villa Name</OPTION>");
	document.write("<OPTION ");
		if (slist==6) document.write(" SELECTED ");
		document.write(" Value=43>Number of Bedrooms</OPTION>");
	document.write("<OPTION ");
		if (slist==27) document.write(" SELECTED ");
		document.write(" Value=70>Thanksgiving Rate</OPTION>");
	document.write("<OPTION ");
		if (slist==56) document.write(" SELECTED ");
		document.write(" Value=37>Status</OPTION>");
	document.write("</SELECT></FORM>");
	
}
function WriteTable() {
	

	/*table header*/
	//document.write("<TABLE Border=0 cellspacing=0 cellpadding=0><TR><TD CLASS=TableHeader width=175>Villa</TD><TD CLASS=TableHeader width=80>Bdrms</TD><TD CLASS=TableHeader width=170>Thanksgiving<BR>Rate US$/Week</TD><TD CLASS=TableHeader width=150>Status</TD></TR>")
	document.write("<TABLE Border=1 width=440>")

	/*write table rows*/
	var rowcount=0;
	while(rowcount < qdb_numrows) {
		document.write("<TR>")
		document.write("<TD CLASS=TableRow width=135><A HREF=" + qdb_data[rowcount][2] + ">" + qdb_data[rowcount][0] + "</A></TD>")
		document.write("<TD CLASS=TableRow width=16>" + qdb_data[rowcount][1] + "</TD>")
		document.write("<TD CLASS=TableRow width=100>" + qdb_data[rowcount][3] + "</TD>")
		document.write("<TD CLASS=TableRow width=161>" + qdb_data[rowcount][4] + "</TD>")
		document.write("</TR>")
		rowcount++;
		}
		
	/*close table*/	
	document.write("</TABLE>")
}

function SortTable() {
	document.SortOption.submit();
}