function get_price(){
	//Variable Declaration
	var region = '';
	var price = '';
	var varietal = '';
	
	//Get Price
	if(document.getElementById('cost').value){
		var ob = document.getElementById('cost');
		for (var i = 0; i < ob.options.length; i++){
			if (ob.options[ i ].selected){
				if(price == '') price = ob.options[i].value;
				else price = price +"_" +ob.options[i].value;
			}
		}
		price = '&price='+price;
	}
	//Get Varietal
	if(document.getElementById('varietal').value){
		var ob = document.getElementById('varietal');
		for (var i = 0; i < ob.options.length; i++){
			if (ob.options[ i ].selected){
				if(varietal == '') varietal = ob.options[i].value;
				else varietal = varietal +"_" +ob.options[i].value;
			}
		}
		varietal = '&varietal='+varietal;
	}
	
	//Get Region
	if(document.getElementById('region').value){
		var ob = document.getElementById('region');
		for (var i = 0; i < ob.options.length; i++){
			if (ob.options[ i ].selected){
				if(region == '') region = ob.options[i].value;
				else region = region +"_" +ob.options[i].value;
			}
		}
		region = '&region='+region;
	}
		
	edit_prompt(price+varietal+region);
}

function edit_prompt(query){
	ajaxRequest('wine_widget/widget.functions.php', 'submit_query', query, getResponse);
}

function getResponse(transport){	
	returned_value = json_decode(transport.responseText);
	
	//Dealing With Prices
	var tbl = document.getElementById("cost");
	while (tbl.firstChild) {
		tbl.removeChild(tbl.firstChild);
	}
	
	price_array = returned_value['price'];
	var tbl = document.getElementById("cost");
	var new_element = null;
	//Price is a fixed array will always have cheap, medium, expensive, super_expensive  no need for loop
	
	
	new_element = document.createElement('option');
	new_element.value = 20;
	if(get_select_prices(20, returned_value['price_select'])) new_element.selected = 1;
	new_element.innerHTML = '$20 and Below ('+price_array['cheap']+')';
	tbl.appendChild(new_element);
		
	new_element = document.createElement('option');
	new_element.value = 40;
	if(get_select_prices(40, returned_value['price_select'])) new_element.selected = 1;
	new_element.innerHTML = '$20 - $40 ('+price_array['medium']+')';
	tbl.appendChild(new_element);
	
	new_element = document.createElement('option');
	new_element.value = 80;
	if(get_select_prices(80, returned_value['price_select'])) new_element.selected = 1;
	new_element.innerHTML = '$40 - $80 ('+price_array['expensive']+')';
	tbl.appendChild(new_element);
		
	new_element = document.createElement('option');
	new_element.value = 'above';
	if(get_select_prices('above', returned_value['price_select'])) new_element.selected = 1;
	new_element.innerHTML = '$80 and Above ('+price_array['super_expensive']+')';
	tbl.appendChild(new_element);
	// Prices Are now set correctly
	
	
	//Dealing with varietal
	var tbl = document.getElementById("varietal");
	while (tbl.firstChild) {
			tbl.removeChild(tbl.firstChild);
	}
	
	var tbl = document.getElementById("varietal");
	for(index = 0; index < returned_value['varietal'].length; index++){
		new_element = document.createElement('option');
		new_element.value = returned_value['varietal'][index]['department'];
		if(get_select_prices(returned_value['varietal'][index]['department'], returned_value['varietal_select'])) new_element.selected = 1;
		new_element.innerHTML = returned_value['varietal'][index]['department'] + ' ('+returned_value['varietal'][index]['number']+')';
		tbl.appendChild(new_element);
	}
	
	//Dealing with Region
	var tbl = document.getElementById("region");
	while (tbl.firstChild) {
			tbl.removeChild(tbl.firstChild);
	}
	
	var tbl = document.getElementById("region");
	for(index = 0; index < returned_value['region'].length; index++){
		new_element = document.createElement('option');
		new_element.value = returned_value['region'][index]['region'];
		if(get_select_prices(returned_value['region'][index]['region'], returned_value['region_select'])) new_element.selected = 1;
		new_element.innerHTML = returned_value['region'][index]['region'] + ' ('+returned_value['region'][index]['number']+')';
		if(returned_value['region'][index]['number'] > 0)
			tbl.appendChild(new_element);
	}
	
	//Dealing with Region
	var tbl = document.getElementById("top");
	while (tbl.firstChild) {
			tbl.removeChild(tbl.firstChild);
	}
	
	new_element = document.createElement('p');
	new_element.className = "crumbs";
	new_element.innerHTML = '<a href="index2.html">Home</a> &gt; Wine'
	tbl.appendChild(new_element);
	
	//<img src="" alt="" border="0" height="28" width="374">
	new_element = document.createElement('img');	
	new_element.src = 'assets/txt/Inventory.png';
	new_element.alt = "Inventory Results";
	new_element.className = "header_image";
	new_element.onclick = function(){
		window.print();
	}
	tbl.appendChild(new_element);
	
	//Setting new background
	document.getElementById('wrapper').style.backgroundImage = 'url(assets/main_bg4.jpg)';
	
	var tbl = document.getElementById("top");
	var top_element = document.createElement('ul');
	top_element.style.listStyleType = 'none';
	
	for(index = 0; index < returned_value['wines'].length; index++){
		new_element = document.createElement('li');
		new_element.style.listStyleImage = 'none';
		var year = returned_value['wines'][index]['vintage'] == 0 ? '' : returned_value['wines'][index]['vintage'];
		new_element.innerHTML = returned_value['wines'][index]['description'] + ' ' + year + ' ($'+returned_value['wines'][index]['price']+') QTY ' +returned_value['wines'][index]['qty'];
		top_element.appendChild(new_element);
	}
	
	tbl.appendChild(top_element);
	
	if(returned_value['region'].length || returned_value['varietal'].length || returned_value['price_select'].length){
		document.getElementById('user_selection').style.display = 'block';
		
		var tbl = document.getElementById("user_selection");
		while (tbl.firstChild) {tbl.removeChild(tbl.firstChild);}
		document.getElementById("user_heading").style.display = 'block';
		
		for(x = 0; x < returned_value['region_select'].length; x++){
			new_element = document.createElement('li');
			img = '<img src="wine_widget/includes/delete.png"  width="12px" border="0" onClick="unselect(\''+returned_value['region_select'][x]+'\')" style="cursor:pointer;">';
			new_element.innerHTML = img+' <span class="text">'+returned_value['region_select'][x]+"</span>";
			tbl.appendChild(new_element);
		}
		
		for(x = 0; x < returned_value['varietal_select'].length; x++){
			new_element = document.createElement('li');
			img = '<img src="wine_widget/includes/delete.png"  width="12px" border="0" onClick="unselect(\''+returned_value['varietal_select'][x]+'\')" style="cursor:pointer;">';
			new_element.innerHTML = img+' <span class="text">'+returned_value['varietal_select'][x]+"</span>";
			tbl.appendChild(new_element);
		}
		
		for(x = 0; x < returned_value['price_select'].length; x++){
			new_element = document.createElement('li');
			img = '<img src="wine_widget/includes/delete.png" width="12px" border="0" onClick="unselect(\''+returned_value['price_select'][x]+'\')" style="cursor:pointer;">';
			new_element.innerHTML = img+' <span class="text">'+convert_price(returned_value['price_select'][x])+"</span>";
			tbl.appendChild(new_element);
		}
		
	}
}

function convert_price(price){
	switch(price){
		case '20': 		return '$20 and Below';
		case '40': 		return '$20 to $40';
		case '80': 		return '$40 to $80';
		case 'above': 	return '$80 and Above';
		default: 		return 'Invalid input';
	}
}


function unselect(query){
	//Get Varietal
	var ob = document.getElementById('varietal');
	for (var i = 0; i < ob.options.length; i++){
		if (ob.options[ i ].selected && ob.options[i].value == query){
			ob.options[ i ].selected = 0;
			return get_price();
		}
	}
	
	ob = document.getElementById('region');
	for (var i = 0; i < ob.options.length; i++){
		if (ob.options[ i ].selected && ob.options[i].value == query){
			ob.options[ i ].selected = 0;
			return get_price();
		}
	}

	ob = document.getElementById('cost');	
	for (var i = 0; i < ob.options.length; i++){
		if (ob.options[ i ].selected && ob.options[i].value == query){
			ob.options[ i ].selected = 0;
			return get_price();
		}
	}	
}

function pop_up_window(){
	//Get Price
	id= '';
	if(document.getElementById('results').value){
		var ob = document.getElementById('results');
		for (var i = 0; i < ob.options.length; i++){
			if (ob.options[ i ].selected){
				if(id == '') id = ob.options[i].value;
				else id = id +"_" +ob.options[i].value;
			}
		}
		id = '&id='+id;
	}
	newwindow=window.open('wine_widget/wine_info.php?id='+id,'name','height=400,width=600', menubar=0, scrollbars=1);
	if (window.focus) {newwindow.focus()}
}


function get_select_prices(checking, array){
	for(x = 0; x < array.length; x++)
		if(array[x] == checking) return true;
	return false;
}

function ajaxRequest(url, php_function, data, response_func) {  
	var aj = new Ajax.Request(url, {method:'post', parameters: 'request='+php_function+(data?'&'+data:''), onSuccess: response_func});  
}