google.load("jquery", "1.3.2")
var isPageChange = false;

function setDocumentTitle(title){
	document.title = "laureldenise - " + title;
}

function showById(id){
	document.getElementById('results_per_page').value = (id == "show_all") ? 0 : 10;
	loadPageChange();
}

function sendAndReloadData(){
	var index = document.getElementById("table_selection").selectedIndex;
	
	if(index != 6){
		//alert($("form").serialize());
		$.post("ajax_example.php", $("form").serialize(),
		function(data){
			var arrData = data.split("||");
			document.getElementById("table_data").innerHTML = arrData[2];
			$(".single").colorbox();
		}, "html");
	}
	else{
		var form = document.forms[0];
		form.action = "ajax_example.php";
		form.method = "post";
		form.encoding = "multipart/form-data";
		document.getElementById("index").value = 5;
		form.submit();
	}
	
	$.post("php/dropdown_values.php", {ddl:""},
	function(data){
		ProdiJay.ddValues = JSON.parse(data);
	}, "html");
}

function loadPageChange(){
	isPageChange = true;
	loadDataFromSchema();
	isPageChange = false;
}

function loadDataFromSchema(){
	if(!isPageChange){
		document.getElementById("select_page").innerHTML = "";
		document.getElementById("current_sort").value = "";
	}
	
	var index = document.getElementById("table_selection").selectedIndex;
	var objPage = document.getElementById("page_selection");
	
	ProdiJay.index = index - 1;
	ProdiJay.rowcount = 0;
	document.getElementById("index").value = ProdiJay.index;
	var results_per_page = document.getElementById("results_per_page").value;
	var current_sort = document.getElementById("current_sort").value;
	var is_schema_change = document.getElementById("is_schema_change").value;
	var current_page_num = (objPage != null) ? objPage.selectedIndex + 1 : document.getElementById("current_page_num").value;
	current_page_num = (!isPageChange) ? 1 : current_page_num;
	document.getElementById("current_page_num").value = current_page_num;

	$.post("ajax_example.php", {selectchange : ProdiJay.index, results_per_page : results_per_page, current_page_num : current_page_num, 
			current_sort : current_sort },
	function(data){
	//alert(data);
		var arrData = data.split("||");
		var selectPage = document.getElementById("select_page");
		var count = arrData[0];
		var currentPage = arrData[1];
		
		var objSelect = document.createElement("SELECT");
		objSelect.id = "page_selection";
		objSelect.name = "page_selection";
		objSelect.onchange = loadPageChange;
		
		for (i = 1; i <= count; ++i) {
			objOption = document.createElement("OPTION");
			objOption.value = i;
			if(i == currentPage){ objOption.selected = true; }
			objOption.appendChild(document.createTextNode(i));
			objSelect.appendChild(objOption);
		}
		
		selectPage.innerHTML = "";
		document.getElementById("is_schema_change").value = 0;
		selectPage.appendChild(objSelect);
		
		document.getElementById("table_data").innerHTML = arrData[2];
		$(".single").colorbox();
	}, "html");
}

function changeSort(obj){
	isPageChange = true;
	var oldSort = document.getElementById("current_sort").value;
	var newSort = obj.parentNode.id;
	
	if(oldSort.indexOf(newSort) > -1){
		if(oldSort.indexOf("DESC") < 0){ newSort += " DESC "; }
	}

	document.getElementById("current_sort").value = newSort;
	loadDataFromSchema();
	isPageChange = false;
}

function next(){
	var obj = document.getElementById("page_selection");
	var max = obj.options.length;
	var curr = obj.selectedIndex;
	var page = curr + 1;
	
	if(page < max){ 
		obj.options[page].selected =  true; 
		loadPageChange();
	}
	else{ alert("There is no next page") };
}

function previous(){
	var obj = document.getElementById("page_selection");
	var curr = obj.selectedIndex;
	var page = curr - 1;
	
	if(curr > 0){ 
		obj.options[page].selected = true; 
		loadPageChange();
	}
	else{ alert("There is no previous page") };
}