// JavaScript Document
	function drawVisualization(dropdown) {
	var fullURL = parent.document.URL;
	var xxx = fullURL.substring(fullURL.indexOf('?')+3, fullURL.length);
	
	var query = new google.visualization.Query('http://spreadsheets.google.com/tq?key=pbm0LWWoYKfvBevKA7GHJcQ&pub=1');
	var queryString = 'SELECT *';
	if ((dropdown.value == 0) || (dropdown.value == null)){
		queryString = 'SELECT *';
	}
	else {
		queryString = 'SELECT * WHERE ' + dropdown.value.toString() + ' = 1';
	}

	if (xxx == '1'){
		queryString = queryString + ' WHERE D = 1';
		document.dataf.category[1].selected = true;
	}
	query.setQuery(queryString);
	query.send(handleQueryResponse);
}
function reDrawVisualization(dropdown) {
	
	var query = new google.visualization.Query('http://spreadsheets.google.com/tq?key=pbm0LWWoYKfvBevKA7GHJcQ&pub=1');
	var queryString = 'SELECT *';
	if ((dropdown.value == 0) || (dropdown.value == null)){
		queryString = 'SELECT *';
	}
	else {
		queryString = 'SELECT * WHERE ' + dropdown.value.toString() + ' =1';
	}
	query.setQuery(queryString);
	query.send(handleQueryResponse);
}
function searchDrawVisualization(searchBox) {
	
	var query = new google.visualization.Query('http://spreadsheets.google.com/tq?key=pbm0LWWoYKfvBevKA7GHJcQ&pub=1'); 
	var queryString = 'SELECT *';
	/*queryString = queryString + ' WHERE P = 1';*/
/*	if (searchBox.value == 'a'){
		queryString = queryString + ' WHERE P = ' + '1';
	}*/	
	queryString = "select * where (upper(A) contains '" + searchBox.value.toUpperCase() + "') or (upper(C) contains '"+ searchBox.value.toUpperCase() + "')";
	query.setQuery(queryString);
	query.send(handleQueryResponse);
}



function handleQueryResponse(response) {
	if (response.isError()) {
		 alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
		return;
	}
	var data = response.getDataTable();
	visualization = new google.visualization.Table(document.getElementById('table'));

	var formatter = new google.visualization.TablePatternFormat('<a class="textLinkB" href="{1}" target="_blank">{0}</a>');
	formatter.format(data, [0, 1]);
	var formatter = new google.visualization.TablePatternFormat('<p>{0}</p>');
	formatter.format(data, [2]);
	
	var view = new google.visualization.DataView(data);
	view.setColumns([0, 2]);
	
	data.sort([{column: 17, desc: true}, {column: 18}]);
	var customCSS = {oddTableRow: 'googleOddTableRow'};
	visualization.draw(view, {allowHtml: true, sort: 'disable', width: 570, cssClassNames: customCSS});
}
      google.setOnLoadCallback(drawVisualization);