// JavaScript Document
var xmlHttp

function GetXmlHttpObject()
{
var xmlHttp=null;
try
 {
 // Firefox, Opera 8.0+, Safari
 xmlHttp=new XMLHttpRequest();
 }
catch (e)
 {
 //Internet Explorer
 try
  {
  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
  }
 catch (e)
  {
  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
 }
return xmlHttp;
}

function checkrequired(which) {
var pass=true;

for (i=0;i<which.length;i++) 
	{
	if (which.elements[i].value=="" || which.elements[i].value < 0)
		{
		alert("Please make sure the  field "+which.elements[i].name+" was properly completed.");
		pass=false;
		break;
		}
	}
if (!pass)
	{
	return false;
	}
else
	{
	return true;
	}//End of Else
}
var tableNameGl;
var columnCountGl;
var divAddGl;
var divViewGl;
var controlValuesGl = new Array();
var columnNamesGl = new Array();
var editRecordNameGl;
var editRecordNoGl;
var loadFunChkGl = 1;

var divViewGl;

function nextData(tableName,columnNames,arrcap,orderBy,count,divAdd,divView)
{
	
	try
	{
		document.getElementById(divView).innerHTML = "<div align='center'><img src='images/rotating_arrow.gif' /></div>";
	}
	catch(err){}

	var arrColumnNames = new Array();
	var arrColumnCaptions = new Array();
	
	for(var i=0;i<arrcap.length;i++)
	{
		arrcap = arrcap.replace("%"," ");
	}
	for(var i=0;i<count;i++)
	{
		arrColumnNames[i] = columnNames.substring(0,columnNames.indexOf("|"));
		columnNames = columnNames.substr(columnNames.indexOf("|")+1);
		
		arrColumnCaptions[i] = arrcap.substring(0,arrcap.indexOf("|"));
		arrcap = arrcap.substr(arrcap.indexOf("|")+1);
		
	}
	setLimit += 30;
	chkLimit = 1;
	viewData(tableName,arrColumnNames,arrColumnCaptions,orderBy,count,divAdd,divView);
}
function prevData(tableName,columnNames,arrcap,orderBy,count,divAdd,divView)
{
	try
	{
		document.getElementById(divView).innerHTML = "<div align='center'><img src='images/rotating_arrow.gif' /></div>";
	}
	catch(err){}
	var arrColumnNames = new Array();
	var arrColumnCaptions = new Array();
	
	for(var i=0;i<arrcap.length;i++)
	{
		arrcap = arrcap.replace("%"," ");
	}
	for(var i=0;i<count;i++)
	{
		arrColumnNames[i] = columnNames.substring(0,columnNames.indexOf("|"));
		columnNames = columnNames.substr(columnNames.indexOf("|")+1);
		
		arrColumnCaptions[i] = arrcap.substring(0,arrcap.indexOf("|"));
		arrcap = arrcap.substr(arrcap.indexOf("|")+1);
		
	}

	setLimit -= 30;
	chkLimit = 1;
	if(setLimit < 0) 
		{
		alert("No Record Beyond this Record");
		setLimit = 0;
		}
	viewData(tableName,arrColumnNames,arrColumnCaptions,orderBy,count,divAdd,divView);
}

function viewData(tableName,columnNames,arrcap,orderBy,count,divAdd,divView)
{
	if(chkLimit == 0)
	{
		setLimit = 0;
	}
	
	divViewGl = divView;
	document.getElementById(divViewGl).innerHTML = "<div align='center'><img src='images/rotating_arrow.gif' /></div>";
	
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";
	url=url+"?task=view";
	url=url+"&order="+orderBy;
	url=url+"&tColumn="+count;
	url=url+"&table="+tableName;
	url=url+"&divAddData="+divAdd;
	url=url+"&divViewData="+divView;
	url=url+"&setLimit="+setLimit;

	for(var i=0;i<count;i++)
		{
		url=url+"&column"+i+"="+columnNames[i];
		url=url+"&cap"+i+"="+arrcap[i];
		}
	//alert(url);
	xmlHttp.onreadystatechange=viewDataState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
	
}
function viewDataState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 //alert(xmlHttp.responseText);
 document.getElementById(divViewGl).innerHTML=xmlHttp.responseText; 
 
 } 
}



var divViewGl2;
var setLimit;
var chkLimit = 0;
function nextSearch(querry,columnNames,arrcap,count,divView,isClient,isSale)
{
	try
	{
		document.getElementById(divView).innerHTML = "<div align='center'><img src='images/rotating_arrow.gif' /></div>";
	}
	catch(err){}

	var arrColumnNames = new Array();
	var arrColumnCaptions = new Array();
	
	for(var i=0;i<arrcap.length;i++)
	{
		arrcap = arrcap.replace("%"," ");
	}
	for(var i=0;i<count;i++)
	{
		arrColumnNames[i] = columnNames.substring(0,columnNames.indexOf("|"));
		columnNames = columnNames.substr(columnNames.indexOf("|")+1);
		
		arrColumnCaptions[i] = arrcap.substring(0,arrcap.indexOf("|"));
		arrcap = arrcap.substr(arrcap.indexOf("|")+1);
		
	}
	setLimit += 30;
	chkLimit = 1;
	viewDataSearch(querry,arrColumnNames,arrColumnCaptions,count,divView,isClient,isSale);
}
function prevSearch(querry,columnNames,arrcap,count,divView,isClient,isSale)
{
	try
	{
		document.getElementById(divView).innerHTML = "<div align='center'><img src='images/rotating_arrow.gif' /></div>";
	}
	catch(err){}
	var arrColumnNames = new Array();
	var arrColumnCaptions = new Array();
	
	for(var i=0;i<arrcap.length;i++)
	{
		arrcap = arrcap.replace("%"," ");
	}
	for(var i=0;i<count;i++)
	{
		arrColumnNames[i] = columnNames.substring(0,columnNames.indexOf("|"));
		columnNames = columnNames.substr(columnNames.indexOf("|")+1);
		
		arrColumnCaptions[i] = arrcap.substring(0,arrcap.indexOf("|"));
		arrcap = arrcap.substr(arrcap.indexOf("|")+1);
		
	}

	setLimit -= 30;
	chkLimit = 1;
	if(setLimit < 0) 
		{
		alert("No Record Beyond this Record");
		setLimit = 0;
		}
	viewDataSearch(querry,arrColumnNames,arrColumnCaptions,count,divView,isClient,isSale);
}

function viewDataSearch(querry,columnNames,arrcap,count,divView,isClient,isSale)
{
	if(chkLimit == 0)
	{
		setLimit = 0;
	}
	divViewGl2 = divView;
	
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";
	url=url+"?task=viewSearch";
	url=url+"&querry="+querry;
	url=url+"&tColumn="+count;
	url=url+"&divViewData="+divView;
	url=url+"&isClient="+isClient;
	url=url+"&isSale="+isSale;
	url=url+"&setLimit="+setLimit;

	for(var i=0;i<count;i++)
		{
		url=url+"&column"+i+"="+columnNames[i];
		url=url+"&cap"+i+"="+arrcap[i];
		}
	//alert(url);
	xmlHttp.onreadystatechange=viewDataSearchState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
	
}

function viewDataSearchState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 //alert(xmlHttp.responseText);
 document.getElementById(divViewGl2).innerHTML=xmlHttp.responseText; 
 
 } 
}


function txtValues(value,loc)
{
	//alert(value);
	controlValuesGl[loc] = value;
}
function editData(tableName,columnCount,columnValues,columnValues2,columnCap,recordName,recordNo,divAdd,divView)
{
	//alert(columnValues2);
	editRecordNameGl = recordName;
	editRecordNoGl = recordNo;
	var columnNames = new Array(columnCount);
	var varColumnCap;
	var tempVal='';
	var htmlStr = "<br><div align='center'><fieldset style='width:60%'><table border='0' width='70%'>";
	var columnCount2 = columnCount - 1;
	//columnValues = columnValues.replace(".*", "<");
	//columnValues = columnValues.replace("*.", ">");
	var TempColumnValues2 = columnValues2;
	while(1)
		{
		columnValues2 = columnValues2.replace(".*", "<");
		columnValues2 = columnValues2.replace("*.", ">");
		if(TempColumnValues2 == columnValues2)
			{
			break;
			}
		else
			{
			TempColumnValues2 = columnValues2;
			}
		}
	//alert(columnValues);
	//alert(columnValues2);
	for(var i=0;i<columnCount2;i++)
	{
		columnNames[i] = columnValues.substring(0,columnValues.indexOf("|"));
		columnValues = columnValues.substr(columnValues.indexOf("|")+1);
		
		tempVal = columnValues2.substring(0,columnValues2.indexOf("|"));
		tempVal = tempVal.replace(/%/gi, " ");

		varColumnCap = columnCap.substring(0,columnCap.indexOf("|"));
		columnCap = columnCap.substr(columnCap.indexOf("|")+1);
		
		txtValues(tempVal,i);
		htmlStr += "<tr><td class='arstext1' valign='top'>"+varColumnCap+"</td><td align='left'>";
		if(varColumnCap=="Text")
		{
			htmlStr += "<textarea class='ars1Textarea' onchange='txtValues(this.value,"+i+");'> "+tempVal+"</textarea>";
		}
		else		
		{
			htmlStr += "<input class='ars1' type='text' value='"+tempVal+"' onchange='txtValues(this.value,"+i+");'>";
		}
		htmlStr += "</td></tr>";
		columnValues2 = columnValues2.substr(columnValues2.indexOf("|")+1);
	}
	
	htmlStr += "<tr><td colspan='"+columnCount2+"' align='right'><input class='arsBtn1' type='button' value='Edit' onclick='editedData()' />&nbsp;<input class='arsBtn1' type='button' value='Cancel' onclick=funCancel('"+divAdd+"') /></td></tr></table></fieldset></div>";
	tableNameGl = tableName;
	columnCountGl = columnCount2;
	divAddGl = divAdd;
	divViewGl = divView;
	columnNamesGl = columnNames;
	document.getElementById(divAdd).innerHTML=htmlStr;
}

function editedData()
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";
	url=url+"?task=edit";
	url=url+"&tColumn="+columnCountGl;
	url=url+"&table="+tableNameGl;
	url=url+"&recordName="+editRecordNameGl;
	url=url+"&recordNo="+editRecordNoGl;
	for(var i=0;i<columnCountGl;i++)
		{
		if(glClientChk == 1 && i == 0)
			{
				//glClientChk = 0;
			url=url+"&value"+i+"="+document.getElementById("slctBranch").value;
			url=url+"&column"+i+"=branchId";
			}
		else
			{
			url=url+"&value"+i+"="+controlValuesGl[i];
			url=url+"&column"+i+"="+columnNamesGl[i];
			}
		}
	//alert(url);
	xmlHttp.onreadystatechange=editedDataState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function editedDataState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 if(xmlHttp.responseText == "ok")
 	{
	alert("Data Edited");
	document.getElementById(divAddGl).innerHTML="";
	if(glClientChk == 1)
		{
		glClientChk = 0;
		goClientSearch();
		}
	else
		{
		loadFunctions(GLtblName,GLvarColNames,GLvarColCap,GLcnt,GLvarCaption);
		}
	}
else
	{
	alert(xmlHttp.responseText);
	}	
 } 
}

var glClientChk = 0;
function editDataClient(tableName,columnCount,columnValues,columnValues2,columnCap,recordName,recordNo,divAdd,slctData)
{
	
	glClientChk = 1;
	//alert(columnValues2);
	editRecordNameGl = recordName;
	editRecordNoGl = recordNo;
	var columnNames = new Array(columnCount);
	var varColumnCap;
	var tempVal='';
	var htmlStr = "<br><div align='center'><fieldset style='width:60%'><table border='0' width='70%'>";
	var columnCount2 = columnCount - 1;
	//columnValues = columnValues.replace(".*", "<");
	//columnValues = columnValues.replace("*.", ">");
	var TempColumnValues2 = columnValues2;
	while(1)
		{
		columnValues2 = columnValues2.replace(".*", "<");
		columnValues2 = columnValues2.replace("*.", ">");
		if(TempColumnValues2 == columnValues2)
			{
			break;
			}
		else
			{
			TempColumnValues2 = columnValues2;
			}
		}
	//alert(columnValues);
	//alert(columnValues2);
	for(var i=0;i<columnCount2;i++)
	{
		columnNames[i] = columnValues.substring(0,columnValues.indexOf("|"));
		columnValues = columnValues.substr(columnValues.indexOf("|")+1);
		
		tempVal = columnValues2.substring(0,columnValues2.indexOf("|"));
		tempVal = tempVal.replace(/%/gi, " ");

		varColumnCap = columnCap.substring(0,columnCap.indexOf("|"));
		columnCap = columnCap.substr(columnCap.indexOf("|")+1);
		
		txtValues(tempVal,i);
		htmlStr += "<tr><td class='arstext1' valign='top'>"+varColumnCap+"</td><td align='left'>";
		
		if(varColumnCap=="Text")
		{
			htmlStr += "<textarea class='ars1Textarea' onchange='txtValues(this.value,"+i+");'> "+tempVal+"</textarea>";
		}
		if(i == 0)
		{
			//alert(slctData);
			for(var j =0;j<slctData.length;j++)
			{
				slctData = slctData.replace("%", " ");
				slctData = slctData.replace("*!", "<");
				slctData = slctData.replace("!*", ">");
				slctData = slctData.replace("!!*", "(");
				slctData = slctData.replace("*!!", ")");
				slctData = slctData.replace("`", "'");
			}
			//alert(slctData);
			htmlStr += slctData;
		}
		else 		
		{
			htmlStr += "<input class='ars1' type='text' value='"+tempVal+"' onchange='txtValues(this.value,"+i+");'>";
		}
		htmlStr += "</td></tr>";
		columnValues2 = columnValues2.substr(columnValues2.indexOf("|")+1);
	}
	
	htmlStr += "<tr><td colspan='"+columnCount2+"' align='right'><input class='arsBtn1' type='button' value='Edit' onclick='editedData()' />&nbsp;<input class='arsBtn1' type='button' value='Cancel' onclick=funCancel('"+divAdd+"') /></td></tr></table></fieldset></div>";
	tableNameGl = tableName;
	columnCountGl = columnCount2;
	divAddGl = divAdd;
	//divViewGl = divView;
	columnNamesGl = columnNames;
	document.getElementById(divAdd).innerHTML=htmlStr;
}


function addData(tableName,columnCount,columnValues,columnCap,divAdd,divView)
{
	//alert(columnValues);
	var columnNames = new Array(columnCount);
	var varColumnCap;
	
	var htmlStr = "<br><div align='center'><fieldset style='width:60%'><table border='0' width='70%'>";
	var columnCount2 = columnCount - 1;
	for(var i=0;i<columnCount2;i++)
	{
		columnNames[i] = columnValues.substring(0,columnValues.indexOf("|"));
		columnValues = columnValues.substr(columnValues.indexOf("|")+1);
		
		varColumnCap = columnCap.substring(0,columnCap.indexOf("|"));
		columnCap = columnCap.substr(columnCap.indexOf("|")+1);
			
		htmlStr += "<tr><td class='arstext1' valign='top'>"+varColumnCap+"</td><td align='left'>";
		if(tableName=="mainpage" && i==1)
		{
			htmlStr += "<textarea class='ars1Textarea' onchange='txtValues(this.value,"+i+");'></textarea>";
		}
		else		
		{
			var txtStatus = "";
			var txtStatusChkFun = "";
			if(varColumnCap == "Status(1 for Active Client)")
				{
				txtStatus = " name='txtStatus' id='txtStatus' ";
				txtStatusChkFun = 'if(document.getElementById("txtStatus").value == "")alert("Please Type Status"); else ';
				}
			htmlStr += "<input" + txtStatus + " class='ars1' type='text' onchange='txtValues(this.value,"+i+");'>";
		}
		htmlStr += "</td></tr>";
		
	}
	
	htmlStr += "<tr><td colspan='"+columnCount2+"' align='right'><input type='button' value='Add' onclick='"+txtStatusChkFun+"addedData(1)'  class='arsBtn1' />&nbsp;<input type='button' class='arsBtn1' value='Cancel' onclick=funCancel('"+divAdd+"') /></td></tr></table></fieldset></div>";
	tableNameGl = tableName;
	columnCountGl = columnCount2;
	divAddGl = divAdd;
	divViewGl = divView;
	columnNamesGl = columnNames;
	document.getElementById(divAdd).innerHTML=htmlStr;
}
var addAlert = 1;
function addedData(varAlert)
{
	addAlert = varAlert;
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";
	url=url+"?task=insert";
	url=url+"&tColumn="+columnCountGl;
	url=url+"&table="+tableNameGl;
	for(var i=0;i<columnCountGl;i++)
		{
		url=url+"&value"+i+"="+controlValuesGl[i];
		url=url+"&column"+i+"="+columnNamesGl[i];
		}
	xmlHttp.onreadystatechange=addedDataState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function addedDataState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 if(xmlHttp.responseText == "ok")
 	{
	if(addAlert == 1)alert("Data Added");
	if(loadFunChkGl == 1)
		{
		document.getElementById(divAddGl).innerHTML="";
		loadFunctions(GLtblName,GLvarColNames,GLvarColCap,GLcnt,GLvarCaption);
		}
	loadFunChkGl = 1;
	}
else
	{
	alert(xmlHttp.responseText);
	}	
 } 
}

function funCancel(divAdd)
{
		document.getElementById(divAdd).innerHTML='';
}


function deleteData(tblName,recName,recNo)
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	if (confirm("Are you sure you want to delete"))
	{
		var url="dbFunctions/dbFunctions.php";
		url=url+"?task=delete";
		url=url+"&table="+tblName;
		url=url+"&recordName="+recName;
		url=url+"&recordNo="+recNo;
		xmlHttp.onreadystatechange=deleteDataState;
		xmlHttp.open("GET",url,true);
		xmlHttp.send(null);
	}
}

function deleteDataState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 if(xmlHttp.responseText == "ok")
 	{
	alert("Data Deleted");
	if(loadFunChkGl == 1)loadFunctions(GLtblName,GLvarColNames,GLvarColCap,GLcnt,GLvarCaption);
	loadFunChkGl = 1;
	}
else
	{
	alert(xmlHttp.responseText);
	}	
 } 
}

function deleteDataClient(tblName,recName,recNo)
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	if (confirm("Are you sure you want to delete"))
	{
		var url="dbFunctions/dbFunctions.php";
		url=url+"?task=delete";
		url=url+"&table="+tblName;
		url=url+"&recordName="+recName;
		url=url+"&recordNo="+recNo;
		xmlHttp.onreadystatechange=deleteDataClientState;
		xmlHttp.open("GET",url,true);
		xmlHttp.send(null);
	}
}

function deleteDataClientState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 if(xmlHttp.responseText == "ok")
 	{
	alert("Data Deleted");	
	goClientSearch();
	}
else
	{
	alert(xmlHttp.responseText);
	}	
 } 
}

var parentIdGl=0;
var dvGl = 1;
var divNoGl;
var subCatChk='';
function addCat(varValue,divNo)
{
	divNoGl = divNo;
	if(varValue == 0)history.go(0);
	parentIdGl=varValue;
	
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";
	url=url+"?task=subCat";
	url=url+"&varValue="+varValue;
	url=url+"&divValue="+dvGl;

	subCatChk = subCatChk + "sub-";
	url=url+"&subCatChk="+subCatChk;
	
	xmlHttp.onreadystatechange=addCatState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}
function addCatState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 var tempDivNo = divNoGl+1;
 var dvId = "dv"+tempDivNo;
 document.getElementById(dvId).innerHTML = xmlHttp.responseText;
 dvGl = tempDivNo + 1;
 } 
}

var varValueGl;
function viewCat(varValue,divNo)
{
	varValueGl = varValue;
	divNoGl = divNo;
	if(varValue == 0)history.go(0);
	parentIdGl=varValue;
	
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";
	url=url+"?task=subCatview";
	url=url+"&varValue="+varValue;
	url=url+"&divValue="+dvGl;

	subCatChk = subCatChk + "sub-";
	url=url+"&subCatChk="+subCatChk;
	
	xmlHttp.onreadystatechange=viewCatState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}
function viewCatState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 var tempDivNo = divNoGl+1;
 var dvId = "dv"+tempDivNo;
 document.getElementById(dvId).innerHTML = xmlHttp.responseText;
 dvGl = tempDivNo + 1;
 
 viewProduct();
 } 
}

function viewProduct()
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";
	url=url+"?task=viewProduct";
	url=url+"&varValue="+varValueGl;
	
	xmlHttp.onreadystatechange=viewProductState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}
function viewProductState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 document.getElementById("dvProduct").innerHTML = xmlHttp.responseText;
 } 
}

function addedCat()
{
	xmlHttp=GetXmlHttpObject()
	if (document.getElementById("title").value=='')
	 {
	 alert ("Please Fill the Required Value");
	 return;
	 }
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";
	url=url+"?task=insertcat";
	url=url+"&parentId="+parentIdGl;
	url=url+"&isProduct="+document.getElementById("slctIsProduct").value;
	url=url+"&itemNo="+document.getElementById("itemNo").value;
	url=url+"&styleNo="+document.getElementById("styleNo").value;
	url=url+"&title="+document.getElementById("title").value;
	url=url+"&price="+document.getElementById("price").value;
	url=url+"&discount="+document.getElementById("discount").value;	
	xmlHttp.onreadystatechange=addedCatState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function addedCatState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 if(xmlHttp.responseText.length < 2)
 	{
	alert("Data Added");
	//history.go(0);
	}
else
	{
	alert(xmlHttp.responseText);
	}	
 } 
}


function isProduct(valChk)
{
	if(valChk == 0)document.getElementById('dvProduct').style.display = "none"
	if(valChk == 1)document.getElementById('dvProduct').style.display = "block"
}

function setPage(pageId)
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="manager/dbFunctions/dbFunctions.php";
	url=url+"?task=setPage";
	url=url+"&pageId="+pageId;
	xmlHttp.onreadystatechange=setPageState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function setPageState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 window.location = "index.php";
 } 
}

function prevData1(type)
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";

	url=url+"?task=prevData";
	url=url+"&type="+type;
	
	xmlHttp.onreadystatechange=prevData1State;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function prevData1State() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 window.history.go(0);
 } 
}

function nextData1(type)
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";

	url=url+"?task=nextData";
	url=url+"&type="+type;
	
	xmlHttp.onreadystatechange=nextData1State;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function nextData1State() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 window.history.go(0);
 } 
}

function GotoPage(type,pageNo)
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";

	url=url+"?task=GotoPage";
	url=url+"&type="+type;
	url=url+"&pageNo="+pageNo;
	
	xmlHttp.onreadystatechange=GotoPageState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function GotoPageState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 window.history.go(0);
 } 
}

function getsrchSubType(type)
{
	//alert(type);
	document.getElementById('dvJewelSrch').style.display = "none";
	document.getElementById('dvStoneSrch').style.display = "none";
	if(type == "0")
		{
			document.getElementById('dvSrchBx').innerHTML = "";
			return;
		}
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";
	
	if(type == "jewellary")document.getElementById('dvJewelSrch').style.display = "block";
	if(type == "stone")document.getElementById('dvStoneSrch').style.display = "block";
	
	url=url+"?task=getsrchSubType";
	url=url+"&type="+type;
	xmlHttp.onreadystatechange=getsrchSubTypeState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function getsrchSubTypeState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 document.getElementById('dvSrchBx').innerHTML = xmlHttp.responseText;
 } 
}

function shapeSearch(shape)
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";

	url=url+"?task=goSearch";
	url=url+"&srchType=Stone"; 
	url=url+"&txtShapeStone="+shape; 

	xmlHttp.onreadystatechange=shapeSearchState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function shapeSearchState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 {
 var loc = "#";
 loc = "stones.php";
 window.location = loc;
 } 
}



function goSearch()
{
	
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";

	url=url+"?task=goSearch";
	url=url+"&fromPrice="+document.getElementById('txtSrchPriceFrom').value;
	url=url+"&toPrice="+document.getElementById('txtSrchPriceTo').value;

 if(document.getElementById('slctSrchJewelType').value == "jewellary")
 	{
	url=url+"&srchType=Jewel"; 
	url=url+"&txtSrNoJewel="+document.getElementById('txtSrNoJewel').value; 
	url=url+"&txtItmNoJewel="+document.getElementById('txtItmNoJewel').value; 
	url=url+"&txtMWJewel="+document.getElementById('txtMWJewel').value; 
	}
 if(document.getElementById('slctSrchJewelType').value == "stone")
 	{
	url=url+"&srchType=Stone"; 
	url=url+"&txtSrNoStone="+document.getElementById('txtSrNoStone').value; 
	url=url+"&txtItmNoStone="+document.getElementById('txtItmNoStone').value; 
	url=url+"&txtShapeStone="+document.getElementById('txtShapeStone').value; 
	url=url+"&txtCaratStone="+document.getElementById('txtCaratStone').value; 
	url=url+"&txtColorStone="+document.getElementById('txtColorStone').value; 
	url=url+"&txtGradeStone="+document.getElementById('txtGradeStone').value; 
	url=url+"&txtClarityStone="+document.getElementById('txtClarityStone').value; 
	url=url+"&txtTreatmentStone="+document.getElementById('txtTreatmentStone').value; 
	url=url+"&txtMeasurementsStone="+document.getElementById('txtMeasurementsStone').value; 
	}

	xmlHttp.onreadystatechange=goSearchState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function goSearchState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 {
 var slctId = "slctSrchType";
 var loc = "#";
 if(document.getElementById('slctSrchJewelType').value == "jewellary")
 	{
	loc = "jewellery.php?id="+document.getElementById(slctId).value; 
	}
 if(document.getElementById('slctSrchJewelType').value == "stone")
 	{
	loc = "stones.php?id="+document.getElementById(slctId).value; 
	}
 if(document.getElementById('slctSrchJewelType').value == "specimen")
 	{
	loc = "specimen.php?id="+document.getElementById(slctId).value; 
	}
 window.location = loc;
 } 
}

function sortPrice(fromPrice,toPrice)
{
	
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";

	url=url+"?task=goSearch2";
	url=url+"&fromPrice="+fromPrice;
	url=url+"&toPrice="+toPrice;


	xmlHttp.onreadystatechange=sortPriceState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function sortPriceState() 
{ 

if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 {
 //var slctId = "slctSrchType";
 //var loc = "#";
 //window.location = loc;
 //alert(xmlHttp.responseText);
 window.history.go(0);
 } 
window.history.go(0);
}


function cancelSearch()
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";

	url=url+"?task=cancelSearch";
	
	xmlHttp.onreadystatechange=cancelSearchState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function cancelSearchState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
 window.history.go(0);
 } 
}

function sndEmail()
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	var url="dbFunctions/dbFunctions.php";
	url=url+"?task=sndmail";
	url=url+"&email="+document.getElementById('email').value;
	url=url+"&name="+document.getElementById('name').value;
	url=url+"&subject="+document.getElementById('subject').value;
	url=url+"&description="+document.getElementById('description').value;
	xmlHttp.onreadystatechange=sndEmailState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function sndEmailState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
	alert(xmlHttp.responseText);
 } 
}

function showNADProducts()
{
	xmlHttp=GetXmlHttpObject()
	if (xmlHttp==null)
	 {
	 alert ("Browser does not support HTTP Request");
	 return;
	 }
	document.getElementById("dvshowNADProducts").innerHTML= "<img src='processing.gif'>"; 
	var url="dbFunctions/dbFunctions.php";
	url=url+"?task=showNADProducts";
	
	xmlHttp.onreadystatechange=showNADProductsState;
	xmlHttp.open("GET",url,true);
	xmlHttp.send(null);
}

function showNADProductsState() 
{ 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 { 
	//alert(xmlHttp.responseText);
	 document.getElementById("dvshowNADProducts").innerHTML=xmlHttp.responseText; 
	 CollapsibleNAP.close();
	 CollapsibleNAP.open();
 } 
}