function submitSearchForm(sform)
{
	var searchObj = createSearchObject(sform);       
	saveSearchObject(searchObj);
	var activateSruvey = true;
	
	if(activateSruvey && (orgid==1001 || orgid==44777) && searchObj.keyword.toLowerCase().indexOf("sql tuning")!=-1){
		document.location.href = "db_pages.getpage?page_id=397";
	}else{	
		document.location.href = urlToNewSE();
	}
	
	return true;
}

function urlToNewSE(){
	var ssId = (new Date()).getTime(); // To generate an unique ID	
	return "db_pages.getpage?page_id=501&p_org_id="+orgid+"&lang="+lang+"&p_nl="+ssId;
}

function do_no_thanks() {
	document.location.href = urlToNewSE();
}

function returnSelectedRadioValue(radio){
	var selected='NS';
	for (var i=0; i < radio.length;i++){
		if(radio[i].checked){
			selected = i+1;
		}
	}
	return selected;
}

var showResults;
function do_submit_and_search_results() {
	if(validateAnswers()){
		showResults=false;
		saveSQLTuningResults();
	}
}

function do_submit_and_survey_results() {
	if(validateAnswers()){
		showResults=true;
		saveSQLTuningResults();
	}
}

function validateAnswers(){
	var answer1 = returnSelectedRadioValue(document.formSurvey.question1);
	var answer2 = returnSelectedRadioValue(document.formSurvey.question2);
	var answer3 = returnSelectedRadioValue(document.formSurvey.question3);
	var answer4 = returnSelectedRadioValue(document.formSurvey.question4);
	var answer5 = returnSelectedRadioValue(document.formSurvey.question5);
	if(answer1=="NS" || answer2=="NS" || answer3=="NS" || answer4=="NS" || answer5=="NS" ){
		alert("You need to answer all the questions");
		return false;
	}
	return true;
}

var pkgAjaxObject=new Array();
function seConnect(objIndex)
{
    if(pkgAjaxObject[objIndex] == undefined)
    {  
		if (window.XMLHttpRequest)	
			pkgAjaxObject[objIndex] = new XMLHttpRequest();	
		else 
		{     
		  if (window.ActiveXObject) 
		  {         
			try 
			{           
				pkgAjaxObject[objIndex] = new ActiveXObject("Microsoft.XMLHTTP");
			}
			catch (e) 
			{
				pkgAjaxObject[objIndex]=null;
				alert("Could not create wa.XMLHTTP Object");
			}
		  }
		}
    }   
    return pkgAjaxObject[objIndex];    
}

function saveSQLTuningResults(){
	var ajaxObject = seConnect(0);
    var url="/pls/web_prod-plq-dad/SurveyPackagesBO.saveSQLTuningSurveyResults";
    var params = "";
    if (ajaxObject){
		try{
			
		    var answer1 = returnSelectedRadioValue(document.formSurvey.question1);
			var answer2 = returnSelectedRadioValue(document.formSurvey.question2);
			var answer3 = returnSelectedRadioValue(document.formSurvey.question3);
			var answer4 = returnSelectedRadioValue(document.formSurvey.question4);
			var answer5 = returnSelectedRadioValue(document.formSurvey.question5);
			var answer6 = document.formSurvey.question6.value;
			params+="answer1="+answer1;
			params+="&answer2="+answer2;
			params+="&answer3="+answer3;
			params+="&answer4="+answer4;
			params+="&answer5="+answer5;
			params+="&answer6="+answer6;
			ajaxObject.open("POST", url, true);
			ajaxObject.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
			ajaxObject.setRequestHeader("Content-length", params.length);
			ajaxObject.setRequestHeader("Connection", "close");            
			ajaxObject.onreadystatechange = redirectToNextPage;
			ajaxObject.send(params);                 
        }catch(err){               
            alert("Problem saving the results");
        }
	}   
}

function redirectToNextPage(){
	var ajaxObject = seConnect(0);	
	try{
		if (ajaxObject.readyState==4){
		    if (ajaxObject.status == 200){
			  if (ajaxObject.responseText){
				var resXml = ajaxObject.responseXML.documentElement;				
				if(resXml.getElementsByTagName("ERROR").length == 0){
					if(showResults){
						location.href='/pls/web_prod-plq-dad/db_pages.getpage?page_id=398';
					}else{
						location.href=urlToNewSE();
					}
				}else{
					alert("Problem saving the survey");
					location.href=urlToNewSE();
				}
			  }
			}
		 }
	}catch(err){
		alert("Problem receiving the save response");
	}
}


function getSQLTuningSurveyResults(){
	var ajaxObject = seConnect(1);
    var url="/pls/web_prod-plq-dad/SurveyPackagesBO.getSQLTuningSurveyResults";
    var params = "";
    if (ajaxObject){	
        try{
		   ajaxObject.open("POST", url, true);
           ajaxObject.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
           ajaxObject.setRequestHeader("Content-length", params.length);
           ajaxObject.setRequestHeader("Connection", "close");            
           ajaxObject.onreadystatechange = showSQLTuningSurveyResults;
           ajaxObject.send(params);                 
        }catch(err){               
            alert("Problem getting the survey results");
        }
	}
}

function showSQLTuningSurveyResults(){
	var ajaxObject = seConnect(1);	
	try{
		if (ajaxObject.readyState==4){
		    if (ajaxObject.status == 200){
			  if (ajaxObject.responseText){
				var resXml = ajaxObject.responseXML.documentElement;
				if(resXml.getElementsByTagName("ERROR").length == 0){
					for(var i = 0; i < resXml.getElementsByTagName("ANSWER").length;i++){
						var currNode = resXml.getElementsByTagName("ANSWER")[i];
						var answerId = currNode.getAttribute("answer_id");
						var value = currNode.firstChild.nodeValue;
						document.getElementById(answerId).firstChild.nodeValue = value + document.getElementById(answerId).firstChild.nodeValue;
					}
				}else{
					alert("Problem getting the survey results");
					location.href=urlToNewSE();
				}
			  }
			}
		 }
	}catch(err){
		alert("Problem getting the survey results");
	}
}

function removeRowsFromTable(table){
	var tbl = table.parentNode;
	var lastRow = tbl.rows.length; 
	for(var x = lastRow-1; x>0;x--){
		tbl.deleteRow(x);
	}
}

function showAnwers(){
	var ajaxObject = seConnect(2);
    var url="/pls/web_prod-plq-dad/SurveyPackagesBO.paginatedAnswers?";
    var params = "";
    if (ajaxObject){
		try{
			
		    var n_pageNumber = 1;
			var n_pageMaxRows = 1000000;
			
			params+="n_pageNumber="+n_pageNumber;
			params+="&n_pageMaxRows="+n_pageMaxRows;
			ajaxObject.open("POST", url, true);
			ajaxObject.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
			ajaxObject.setRequestHeader("Content-length", params.length);
			ajaxObject.setRequestHeader("Connection", "close");            
			ajaxObject.onreadystatechange = drawTable;
			ajaxObject.send(params);                 
        }catch(err){               
            alert("Problem saving the results");
        }
	}   
}

function drawTable(){
	var ajaxObject = seConnect(2);	
	try{
		if (ajaxObject.readyState==4){
		    if (ajaxObject.status == 200){
			  if (ajaxObject.responseText){
				var resXml = ajaxObject.responseXML.documentElement;				
				if(resXml.getElementsByTagName("ERROR").length == 0){
					var tableBody = document.getElementById("idAnswersTable");
					removeRowsFromTable(tableBody);
					for(var i = 0; i < resXml.getElementsByTagName("ANSWER").length;i++){
						var currAnswer = resXml.getElementsByTagName("ANSWER")[i];
						var currMessage = currAnswer.getElementsByTagName("MESSAGE")[0];
						var messageValue = currMessage.firstChild.nodeValue;
						var currDate = currAnswer.getElementsByTagName("DATE")[0];
						var dateValue = currDate.firstChild.nodeValue;

						var newRow = document.createElement("tr");
						var newCell1 = document.createElement("td");
						newCell1.setAttribute("align","right");
						newCell1.innerHTML=dateValue; 
						
						var newCell2 = document.createElement("td");
						newCell2.innerHTML=""; 
						
						var newCell3 = document.createElement("td");
						newCell3.setAttribute("align","left");
						newCell3.innerHTML=messageValue; 
						
						newRow.appendChild(newCell1);
						newRow.appendChild(newCell2);
						newRow.appendChild(newCell3);
						
						tableBody.appendChild(newRow);
					}
				}else{
					alert("Problem saving the survey");
					location.href=urlToNewSE();
				}
			  }
			}
		 }
	}catch(err){
		alert("Problem receiving the save response");
	}
}