var args = getArgs();
var slist = 0;
if (args.sort) slist=args.sort;
else slist="6"; //Default sort is Villa Name
//QuickBaseURL = "https://www.quickbase.com/db/6r5ramf4?a=API_GenResultsTable&query={'84'.EX.'yes'}&clist=6.7.89.93.90.94.96.84&slist=" + slist + "&options='sortorder-A'&jsa=1&username=sunvillas&password=viewonly"
var QuickBaseURL = new String('');
if((slist == '36') || (slist == '38')){
	QuickBaseURL = "https://www.quickbase.com/db/bdv4euyky?a=API_GenResultsTable&query={'71'.EX.'yes'}&clist=6.43.36.67.38.68.72.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.36.67.38.68.72.71&slist=" + slist + "&options='sortorder-A'&jsa=1&username=guest@sunvillas.com&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='christmas_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==6) document.write(" SELECTED ");
		document.write(" Value=6>Villa Name</OPTION>");
	document.write("<OPTION ");
		if (slist==43) document.write(" SELECTED ");
		document.write(" Value=43>Number of Bedrooms</OPTION>");
	document.write("<OPTION ");
		if (slist==36) document.write(" SELECTED ");
		document.write(" Value=36>Christmas Availability</OPTION>");
	document.write("<OPTION ");
		if (slist==38) document.write(" SELECTED ");
		document.write(" Value=38>New Year Availability</OPTION>");
		document.write("</SELECT></FORM>");
}

function WriteTable() {


	/*table header*/
	//document.write("<TABLE width=445 border=1><TR><TD CLASS=TableHeader width=175>Villa</TD><TD CLASS=TableHeader width=80>Bdrms</TD><TD CLASS=TableHeader width=160>Christmas<br>Week</TD><TD CLASS=TableHeader width=160>Christmas<br>Rate</TD><TD CLASS=TableHeader width=160>New Years<br>Week</TD><TD CLASS=TableHeader width=160>New Years<br>Rate</TD></tr>")
	
	
	document.write("<TABLE width=440 border=1>")
	/*write table rows*/
	var rowcount=0;
	while(rowcount < qdb_numrows) {
		document.write("<TR>")
		document.write("<TD CLASS=TableRow width=92><A HREF=" + qdb_data[rowcount][6] + ">" + qdb_data[rowcount][0] + "</A></TD>")
		document.write("<TD CLASS=TableRow width=18>" + qdb_data[rowcount][1] + "</TD>")
		document.write("<TD CLASS=TableRow width=89>" + qdb_data[rowcount][2] + "</TD>")
		document.write("<TD CLASS=TableRow width=63>" + qdb_data[rowcount][3] + "</TD>")
		document.write("<TD CLASS=TableRow width=86>" + qdb_data[rowcount][4] + "</TD>")
		document.write("<TD CLASS=TableRow width=62>" + qdb_data[rowcount][5] + "</TD>")

		document.write("</TR>")
		rowcount++;
		}
		
	/*close table*/	
	document.write("</TABLE>")
}

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