question.php

<?php
/*
	#############################################################
	# >>> PHP Surveyor  										#
	#############################################################
	# > Author:  Jason Cleeland									#
	# > E-mail:  jason@cleeland.org								#
	# > Mail:    Box 99, Trades Hall, 54 Victoria St,			#
	# >          CARLTON SOUTH 3053, AUSTRALIA					#
	# > Date: 	 20 February 2003								#
	#															#
	# This set of scripts allows you to develop, publish and	#
	# perform data-entry on surveys.							#
	#############################################################
	#															#
	#	Copyright (C) 2003  Jason Cleeland						#
	#															#
	# This program is free software; you can redistribute 		#
	# it and/or modify it under the terms of the GNU General 	#
	# Public License as published by the Free Software 			#
	# Foundation; either version 2 of the License, or (at your 	#
	# option) any later version.								#
	#															#
	# This program is distributed in the hope that it will be 	#
	# useful, but WITHOUT ANY WARRANTY; without even the 		#
	# implied warranty of MERCHANTABILITY or FITNESS FOR A 		#
	# PARTICULAR PURPOSE.  See the GNU General Public License 	#
	# for more details.											#
	#															#
	# You should have received a copy of the GNU General 		#
	# Public License along with this program; if not, write to 	#
	# the Free Software Foundation, Inc., 59 Temple Place - 	#
	# Suite 330, Boston, MA  02111-1307, USA.					#
	#############################################################
*/
	
//Move current step
if ($_POST['move'] == " << prev " && !$_POST['newgroupondisplay']) {$_SESSION['step'] = $_POST['thisstep']-1;}
elseif ($_POST['move'] == " << prev " && $_POST['newgroupondisplay'] == "Y") {$_SESSION['step'] = $_POST['thisstep'];}
if ($_POST['move'] == " next >> ") {$_SESSION['step'] = $_POST['thisstep']+1;}
if ($_POST['move'] == " last ") {$_SESSION['step'] = $_POST['thisstep']+1;}

//CONVERT POSTED ANSWERS TO SESSION VARIABLES 
if ($_POST['fieldnames'])
	{
	$postedfieldnames=explode("|", $_POST['fieldnames']);
	foreach ($postedfieldnames as $pf)
		{
		$_SESSION[$pf] = $_POST[$pf];
		//echo "<!-- SAVING $pf: $_SESSION[$pf] -->\n";
		}
	}

//CHECK IF ALL MANDATORY QUESTIONS HAVE BEEN ANSWERED
if ($_POST['mandatory'])
	{
	$chkmands=explode("|", $_POST['mandatory']);
	$mfns=explode("|", $_POST['mandatoryfn']);
	$mi=0;
	foreach ($chkmands as $cm)
		{
		$multiname="MULTI$mfns[$mi]";
		//echo "Checking Mandatory: $cm<br />";
		//echo "Mandatory $cm is ".$_SESSION[$cm]."<br />\n";
		if ($_SESSION[$cm] == "0" || $_SESSION[$cm])
			{
			}
		elseif (!$_POST[$multiname])
			{
			//One of the mandatory questions hasn't been asnwered
			if ($_POST['move'] == " << prev ") {$_SESSION['step'] = $_POST['thisstep'];}
			if ($_POST['move'] == " next >> ") {$_SESSION['step'] = $_POST['thisstep'];}
			if ($_POST['move'] == " last ") {$_SESSION['step'] = $_POST['thisstep']; $_POST['move'] == " next >> ";}
			$notanswered[]=$mfns[$mi];
			}
		else
			{
			$notanswered[]=$mfns[$mi];
			}
		if ($_POST[$multiname])
			{
		    if (count($notanswered) == count($chkmands)) //
				{
				//The number of questions not answered is equal to the number of questions
				if ($_POST['move'] == " << prev ") {$_SESSION['step'] = $_POST['thisstep'];}
				if ($_POST['move'] == " next >> ") {$_SESSION['step'] = $_POST['thisstep'];}
				if ($_POST['move'] == " last ") {$_SESSION['step'] = $_POST['thisstep']; $_POST['move'] == " next >> ";}
			    }
			}
		$mi++;
		}
	}
if ($_POST['conmandatory'])
	{
	$chkcmands=explode("|", $_POST['conmandatory']);
	$cmfns=explode("|", $_POST['conmandatoryfn']);
	$mi=0;
	foreach ($chkcmands as $ccm)
		{
		$multiname="MULTI$cmfns[$mi]";
		if (!$_POST[$multiname])
			{
		    $dccm="display$ccm";
			}
		else
			{
			$dccm="display".$cmfns[0];
			}
		if ($_POST[$dccm] == "on" && (!$_SESSION[$ccm] && $_SESSION[$ccm] != "0") && !$_POST[$multiname])
			{
			//One of the conditional mandatory questions was on, but hasn't been answered
			if ($_POST['move'] == " << prev ") {$_SESSION['step'] = $_POST['thisstep'];}
			if ($_POST['move'] == " next >> ") {$_SESSION['step'] = $_POST['thisstep'];}
			if ($_POST['move'] == " last ") {$_SESSION['step'] = $_POST['thisstep']; $_POST['move'] == " next >> ";}
			$notanswered[]=$cmfns[$mi];
			}
		elseif ($_POST[$dccm] == "on" && !$_SESSION[$ccm] && $_POST[$multiname])
			{
			$notanswered[]=$cmfns[$mi];
			}
		}
	if ($_POST[$multiname])
		{
	    if (count($notanswered) == count($chkcmands)) //
			{
			//The number of questions not answered is equal to the number of questions
			if ($_POST['move'] == " << prev ") {$_SESSION['step'] = $_POST['thisstep'];}
			if ($_POST['move'] == " next >> ") {$_SESSION['step'] = $_POST['thisstep'];}
			if ($_POST['move'] == " last ") {$_SESSION['step'] = $_POST['thisstep']; $_POST['move'] == " next >> ";}
		    }
		}
	}
//DEBUG - FOLLOWING SECTION CAN GO ONCE SCRIPT IS OK
//What answers have been made so far?
//echo "<hr>\n";
//echo "<!-- DEBUG: ANSWERFIELDS AND ANSWERS SO FAR\n";
//foreach (array_keys($_SESSION) as $SESak)
//	{
//	echo "$SESak: " . $_SESSION[$SESak] . "\n";
//	}
//echo "-->\n";
//
//echo "<!-- DEBUG: POSTED VARIABLES\n";
//foreach (array_keys($_POST) as $POSak)
//	{
//	echo "$POSak: ". $_POST[$POSak] . "\n";
//	}
//echo "-->\n";
//
//echo "<!-- DEBUG: GROUPLIST\n";
//foreach (array_keys($_SESSION['grouplist']) as $GLak)
//	{
//	echo "** $GLak: \n";
//	foreach (array_keys($_SESSION['grouplist'][$GLak]) as $GL2ak)
//		{
//		echo "\t$GL2ak: ".$_SESSION['grouplist'][$GLak][$GL2ak]."\n";
//		}
//	}
//echo "-->\n";
//
//echo "<!-- DEBUG: POST ARRAY\n";
//foreach (array_keys($_POST) as $Pak)
//	{
//	echo "** $Pak: {$_POST[$Pak]}<br />\n";
//	}
//echo "-->\n";
//echo "<!-- DEBUG: FIELDARRAY\n";
//foreach (array_keys($_SESSION['fieldarray']) as $FAak)
//	{
//	echo "** $FAak:\n";
//	foreach (array_keys($_SESSION['fieldarray'][$FAak]) as $FA2ak)
//		{
//		echo "\t$FA2ak: ".$_SESSION['fieldarray'][$FAak][$FA2ak]."\n";
//		}
//	}
//echo "-->\n";
//END DEBUG

//SUBMIT
if ($_POST['move'] == " submit ")
	{
	foreach(file("$thistpl/startpage.pstpl") as $op)
		{
		echo templatereplace($op);
		}
	echo "\n<br />\n";
	//DEVELOP SQL TO INSERT RESPONSES
	$subquery = "INSERT INTO $surveytable ";
	if (is_array($_SESSION['insertarray']))
		{
		foreach ($_SESSION['insertarray'] as $value)
			{
			$col_name .= ", " . $value; 
			if (get_magic_quotes_gpc() == "0")
				{
				if (phpversion() >= "4.3.0")
					{
					$values .= ", '" . mysql_real_escape_string($_SESSION[$value], "'") . "'";	
					}
				else
					{
					$values .= ", '" . mysql_escape_string($_SESSION[$value]) . "'";
					}
				}
			else
				{
				$values .= ", '" . $_SESSION[$value] . "'";
				}
			}
		$col_name = substr($col_name, 2); //Strip off first comma & space
		$values = substr($values, 2); //Strip off first comma & space
		$subquery .= "\n($col_name) \nVALUES \n($values)";
		}
	else
		{
		echo "<br /><center><font face='verdana' size='2'><font color='red'><b>Error:</b></font><br /><br />\n";
		echo "Cannot submit results - there are none to submit.<br /><br />\n";
		echo "<font size='1'>This error can occur if you have already submitted your responses<br />\n";
		echo "and pressed 'refresh' on your browser. In this case, your responses have<br />\n";
		echo "been saved and you should move on with your life.";
		echo "</font></center><br /><br />";
		exit;
		}	
	//COMMIT CHANGES TO DATABASE
	if ($surveyactive != "Y")
		{
		$completed = "<br /><b><font size='2' color='red'>Did Not Save!</b></font><br /><br />\n\n";
		$completed .= "Your survey responses have not been recorded. This survey is not yet active.<br /><br />\n";
		$completed .= "<a href='$PHP_SELF?sid=$sid&move=clearall'>Clear responses</a><br /><br />\n";
		$completed .= "<font size='1'>$subquery</font>\n";
		}
	else
		{
		if (mysql_query($subquery))
			{
			$completed = "<br /><b><font size='2'><font color='green'>Thank you.</b></font><br /><br />\n\n";
			$completed .= "Your survey responses have been recorded.<br />\n";
			$completed .= "<a href='javascript:window.close()'>Close this window</a></font><br /><br />\n";
			if ($_POST['token'])
				{
				$utquery = "UPDATE tokens_$sid SET completed='Y' WHERE token='{$_POST['token']}'";
				$utresult = mysql_query($utquery) or die ("Couldn't update tokens table!<br />\n$utquery<br />\n".mysql_error());
				$cnfquery = "SELECT * FROM tokens_$sid WHERE token='{$_POST['token']}' AND completed='Y'";
				$cnfresult = mysql_query($cnfquery);
				while ($cnfrow = mysql_fetch_array($cnfresult))
					{
					$headers = "From: $surveyadminemail\r\n";
					$headers .= "X-Mailer: $sitename Email Inviter";
					$to = $cnfrow['email'];
					$subject = "Confirmation: $surveyname Survey Completed";
					$message="";
					foreach (file("$thistpl/confirmationemail.pstpl") as $ce)
						{
						$add=$ce;
						$add = str_replace("{FIRSTNAME}", $cnfrow['firstname'], $add);
						$add = str_replace("{LASTNAME}", $cnfrow['lastname'], $add);
						$add = str_replace("{ADMINNAME}", $surveyadminname, $add);
						$add = str_replace("{ADMINEMAIL}", $surveyadminemail, $add);
						$add = str_replace("{SURVEYNAME}", $surveyname, $add);
						$message .= $add;
						}
					if ($cnfrow['email']) {mail($to, $subject, $message, $headers);} //Only send confirmation email if there is an email address
					
					//DEBUG INFO: CAN BE REMOVED
					echo "<!-- DEBUG: MAIL INFORMATION\n";
					echo "TO: $to\n";
					echo "SUBJECT: $subject\n";
					echo "MESSAGE: $message\n";
					echo "HEADERS: $headers\n";
					echo "-->\n";
					//END DEBUG
					}					
				}
			session_unset();
			session_destroy();
			}
		else
			{
			$completed = "<br /><b><font size='2' color='red'>Did Not Save!</b></font><br /><br />\n\n";
			$completed .= "An unexpected error has occurred and your responses cannot be saved.<br /><br />\n";
			if ($adminemail)
				{	
				$completed .= "Your responses have not been lost and have been emailed to the survey administrator ";
				$completed .= "and will be entered into our database at a later point.<br /><br />\n";
				$email="An error occurred saving a response to survey id $sid\n\n";
				$email .= "DATA TO BE ENTERED:\n";
				foreach ($_SESSION['insertarray'] as $value)
					{
					$email .= "$value: {$_SESSION[$value]}\n";
					}
					$email .= "\nSQL CODE THAT FAILED:\n";
				$email .= "$subquery\n\n";
				$email .= "ERROR MESSAGE:\n";
				$email .= mysql_error()."\n\n";
				mail($surveyadminemail, "ERROR SAVING", $email);
				}
			else
				{
				$completed .= "<a href='javascript:location.reload()'>Try to submit again</a><br /><br />\n";
				}
			}
		}
	//$GLOBALS["completed"]=$completed;
	foreach(file("$thistpl/completed.pstpl") as $op)
		{
		echo templatereplace($op);
		}
	
	echo "\n<br />\n";
	foreach(file("$thistpl/endpage.pstpl") as $op)
		{
		echo templatereplace($op);
		}
	exit;
	}

//LAST PHASE
if ($_POST['move'] == " last " && !$notanswered)
	{
	last();
	exit;
	}

//SEE IF $sid EXISTS
if ($surveyexists <1)
	{
	//SURVEY DOES NOT EXIST. POLITELY EXIT.
	foreach(file("$thistpl/startpage.pstpl") as $op)
		{
		echo templatereplace($op);
		}
	echo "\t<center><br />\n";
	echo "\tSorry. There is no matching survey.<br />&nbsp;\n";	
	foreach(file("$thistpl/endpage.pstpl") as $op)
		{
		echo templatereplace($op);
		}
	exit;
	}

//SEE IF THERE ARE TOKENS FOR THIS SURVEY
$i = 0; $tokensexist = 0;
$tresult = @mysql_list_tables($databasename) or die ("Error getting tokens<br />".mysql_error());
while($tbl = @mysql_tablename($tresult, $i++))
	{
	if ($tbl == "tokens_$sid") {$tokensexist = 1;}
	}

//RUN THIS IF THIS IS THE FIRST TIME
//if ((!$_SESSION['step'] && $_SESSION['step'] != "0") || $_SESSION['step'] < 0 )
if (!$_SESSION['step'])
	{
	//*****************************************************************************************************
	//PREPARE SURVEY
	//*****************************************************************************************************

	if ($tokensexist == 1 && !$_GET['token'])
		{
		//NO TOKEN PRESENTED. EXPLAIN PROBLEM AND PRESENT FORM
		foreach(file("$thistpl/startpage.pstpl") as $op)
			{
			echo templatereplace($op);
			}
		foreach(file("$thistpl/survey.pstpl") as $op)
			{
			echo templatereplace($op);
			}
		echo "\t<center><br />\n";
		echo "\tThis survey titled <b>$surveyname</b> is a controlled survey. You need a valid\n";
		echo "\ttoken to participate.<br /><br />\n";
		echo "\tIf you have been issued with a token, please enter it in the box below and click\n";
		echo "\tcontinue.<br />&nbsp;\n";
		echo "\t<table align='center'>";
		echo "\t<form method='get' action='{$_SERVER['PHP_SELF']}'>\n";
		echo "\t<input type='hidden' name='sid' value='$sid'>\n";
		echo "\t\t<tr>\n";
		echo "\t\t\t<td align='center' valign='middle'>\n";
		echo "\t\t\tToken: <input class='text' type='text' name='token'>\n";
		echo "\t\t\t<input class='submit' type='submit' value='Continue'>\n";
		echo "\t\t\t</td>\n";
		echo "\t\t</tr>\n";
		echo "\t</form>\n";
		echo "\t</table>\n";
		echo "\t<br />&nbsp;</center>\n";
		foreach(file("$thistpl/endpage.pstpl") as $op)
			{
			echo templatereplace($op);
			}
		exit;
		}
	if ($tokensexist == 1 && $_GET['token'])
		{
		//check if token actually does exist
		$tkquery = "SELECT * FROM tokens_$sid WHERE token='{$_GET['token']}' AND completed != 'Y'";
		$tkresult = mysql_query($tkquery);
		$tkexist = mysql_num_rows($tkresult);

		if (!$tkexist)
			{
			//TOKEN DOESN'T EXIST OR HAS ALREADY BEEN USED. EXPLAIN PROBLEM AND EXIT
			foreach(file("$thistpl/startpage.pstpl") as $op)
				{
				echo templatereplace($op);
				}
			foreach(file("$thistpl/survey.pstpl") as $op)
				{
				echo "\t".templatereplace($op);
				}
			echo "\t<center><br />\n";
			echo "\tThis survey, titled <b>$surveyname</b>, is a controlled survey. You need a valid\n";
			echo "\ttoken to participate.<br /><br />\n";
			echo "\tThe token you have provided is either not valid, or has already been used. Please\n";
			echo "\tcontact $surveyadminname at <a href='mailto:$surveyadminemail'>$surveyadminemail</a>\n";
			echo "\tfor more information.<br /><br />\n";
			echo "\t<a href='javascript:window.close()'>Close this window</a><br />&nbsp;\n";
			foreach(file("$thistpl/endpage.pstpl") as $op)
				{
				echo templatereplace($op);
				}
			exit;
			}
		}
	//RESET ALL THE SESSION VARIABLES AND START AGAIN
	unset($_SESSION['grouplist']);
	unset($_SESSION['fieldarray']);
	unset($_SESSION['insertarray']);

	//LETS COUNT THE NUMBER OF GROUPS (That's how many steps there will be)
	$query = "SELECT * FROM groups WHERE groups.sid=$sid ORDER BY group_name";
	$result = mysql_query($query) or die ("Couldn't get group list<br />$query<br />".mysql_error());
	//$_SESSION['totalsteps'] = mysql_num_rows($result);
	while ($row = mysql_fetch_array($result)){$_SESSION['grouplist'][]=array($row['gid'], $row['group_name'], $row['description']);}
	//NOW LETS BUILD THE SESSION VARIABLES
	$query = "SELECT * FROM questions, groups WHERE questions.gid=groups.gid AND questions.sid=$sid ORDER BY group_name";
	$result = mysql_query($query);
	$totalquestions = mysql_num_rows($result);
	$_SESSION['totalsteps'] = $totalquestions;
	if ($totalquestions == "0")	//break out and crash if there are no questions!
		{
		foreach(file("$thistpl/startpage.pstpl") as $op)
			{
			echo templatereplace($op);
			}
		foreach(file("$thistpl/survey.pstpl") as $op)
			{
			echo "\t".templatereplace($op);
			}
		echo "\t<center><br />\n";
		echo "\tThis survey, titled <b>$surveyname</b>, does not yet have any questions and cannot\n";
		echo "\tbe tested or completed.<br /><br />\n";
		echo "\tContact $surveyadminname at <a href='mailto:$surveyadminemail'>$surveyadminemail</a>\n";
		echo "\tfor more information.<br /><br />\n";
		echo "\t<a href='javascript:window.close()'>Close this window</a><br />&nbsp;\n";
		foreach(file("$thistpl/endpage.pstpl") as $op)
			{
			echo templatereplace($op);
			}
		exit;
		}

	$arows = array(); //Create an empty array in case mysql_fetch_array does not return any rows
	while ($row = mysql_fetch_assoc($result)) {$arows[] = $row;} // Get table output into array
	usort($arows, 'CompareGroupThenTitle'); // Perform a case insensitive natural sort on group name then question title of a multidimensional array
		if (!$_SESSION['insertarray'])
		{
		if ($surveyprivate == "N")
			{
			$_SESSION['token'] = $token;
			$_SESSION['insertarray'][]= "token";
			}
	
		foreach ($arows as $arow)
			{
			//WE ARE CREATING A SESSION VARIABLE FOR EVERY FIELD IN THE SURVEY
			$fieldname = "{$arow['sid']}X{$arow['gid']}X{$arow['qid']}";
			if ($arow['type'] == "M" || $arow['type'] == "A" || $arow['type'] == "B" || $arow['type'] == "C" || $arow['type'] == "P") {
				$abquery = "SELECT answers.*, questions.other FROM answers, questions WHERE answers.qid=questions.qid AND sid=$sid AND questions.qid={$arow['qid']} ORDER BY answers.code";
				$abresult = mysql_query($abquery);
				while ($abrow = mysql_fetch_array($abresult))
					{
					$_SESSION['insertarray'][] = "$fieldname".$abrow['code'];
					$alsoother = "";
					if ($abrow['other'] == "Y") {$alsoother = "Y";}
					if ($arow['type'] == "P")
						{
						$_SESSION['insertarray'][] = "$fieldname".$abrow['code']."comment";	
						}
					}
				if ($alsoother)
					{
					$_SESSION['insertarray'][] = "$fieldname"."other";
					if ($arow['type'] == "P")
						{
						$_SESSION['insertarray'][] = "$fieldname"."othercomment";	
						}
					}
				} elseif ($arow['type'] == "R") {
				$abquery = "SELECT answers.*, questions.other FROM answers, questions WHERE answers.qid=questions.qid AND sid=$sid AND questions.qid={$arow['qid']} ORDER BY answers.code";
				$abresult = mysql_query($abquery);
				$abcount = mysql_num_rows($abresult);
				for ($i=1; $i<=$abcount; $i++)
					{
					$_SESSION['insertarray'][] = "$fieldname".$i;
					}			
				} elseif ($arow['type'] == "O")	{
				$_SESSION['insertarray'][] = "$fieldname";
				$fn2 = "$fieldname"."comment";
				$_SESSION['insertarray'][] = "$fn2";
				} else	{
				$_SESSION['insertarray'][] = "$fieldname";
				}

			//Check to see if there are any conditions set for this question
			if (conditionscount($arow['qid']) > 0)
				{
				$conditions = "Y";
				} else {
				$conditions = "N";
				}
			//echo "F$fieldname, {$arow['title']}, {$arow['question']}, {$arow['type']}<br />\n"; //MORE DEBUGGING STUFF
			//NOW WE'RE CREATING AN ARRAY CONTAINING EACH FIELD AND RELEVANT INFO
			//ARRAY CONTENTS - [0]=questions.qid, [1]=fieldname, [2]=questions.title, [3]=questions.question
			//                 [4]=questions.type, [5]=questions.gid, [6]=questions.mandatory, [7]=conditionsexist?
			$_SESSION['fieldarray'][] = array("{$arow['qid']}", "$fieldname", "{$arow['title']}", "{$arow['question']}", "{$arow['type']}", "{$arow['gid']}", "{$arow['mandatory']}", $conditions);
			}
		}

	
	
	foreach(file("$thistpl/startpage.pstpl") as $op)
		{
		echo templatereplace($op);
		}
	echo "\n<form method='post' action='{$_SERVER['PHP_SELF']}' id='phpsurveyor' name='phpsurveyor'>\n";
	
	echo "\n\n<!-- START THE SURVEY -->\n";

	foreach(file("$thistpl/welcome.pstpl") as $op)
		{
		echo "\t\t\t".templatereplace($op);
		}
	echo "\n";
	//DEBUG FIELDARRAY
	//echo "<ul>\n";
	//foreach ($_SESSION['fieldarray'] as $fa)
	//	{
	//	echo "<li>QID: $fa[0], FIELDNAME: $fa[1], TITLE: $fa[2], QUESTION: $fa[3], TYPE: $fa[4], GID: $fa[5], MANDATORY: $fa[6], CONDITIONSEXIST?: $fa[7]</li>\n";
	//	}
	//echo "</ul>\n";
	//END DEBUG
	$navigator = surveymover();
	foreach(file("$thistpl/navigator.pstpl") as $op)
		{
		echo templatereplace($op);
		}
	if ($surveyactive != "Y") {echo "\t\t<center><font color='red' size='2'>This survey is not currently active. You will not be able to save your responses.</font></center>\n";}
	foreach(file("$thistpl/endpage.pstpl") as $op)
		{
		echo templatereplace($op);
		}
	echo "\n<input type='hidden' name='sid' value='$sid'>\n";
	echo "\n<input type='hidden' name='token' value='$token'>\n";
	echo "\n</form>\n</html>";
	exit;
	}

	
//******************************************************************************************************
//PRESENT SURVEY
//******************************************************************************************************

//GET GROUP DETAILS

//$grouparrayno=$_SESSION['step']-1;
//echo "--- GROUP: ".$_SESSION['fieldarray'][$_SESSION['step']-1][5]." ---<br />\n";
//echo "--- FACOUNT: ".count($_SESSION['fieldarray'])." ---<br />";
//echo "--- STEP: ".$_SESSION['step']." ---<br />";
//echo "--- TOTALSTEPS: ".$_SESSION['totalsteps']." ---<br />";
//GET GROUP DETAILS

if ($_SESSION['step'] == "0") {$currentquestion=$_SESSION['step'];}
else {$currentquestion=$_SESSION['step']-1;}
$ia=$_SESSION['fieldarray'][$currentquestion];

foreach ($_SESSION['grouplist'] as $gl)
	{
	if ($gl[0] == $ia[5])
		{
		$gid=$gl[0];
		$groupname=$gl[1];
		$groupdescription=$gl[2];
		if ($_POST['lastgroupname'] != $groupname && $groupdescription) {$newgroup = "Y";} else {$newgroup = "N";}
		}
	}

if ($newgroup == "Y" && $_POST['move'] == " << prev " && $_POST['grpdesc']=="Y") //a small trick to manage moving backwards from a group description
	{
	$currentquestion++; 
	$ia=$_SESSION['fieldarray'][$currentquestion]; 
	$_SESSION['step']++;
	}

// MANAGE CONDITIONAL QUESTIONS
$conditionforthisquestion=$ia[7];
while ($conditionforthisquestion == "Y") //IF CONDITIONAL, CHECK IF CONDITIONS ARE MET
			{
			$cquery="SELECT distinct cqid FROM conditions WHERE qid={$ia[0]}";
			$cresult=mysql_query($cquery) or die("Couldn't count cqids<br />$cquery<br />".mysql_error());
			$cqidcount=mysql_num_rows($cresult);
			$cqidmatches=0;
			while ($crows=mysql_fetch_array($cresult))//Go through each condition for this current question
				{
				//Check if the condition is multiple type
				$ccquery="SELECT type FROM questions WHERE qid={$crows['cqid']}";
				$ccresult=mysql_query($ccquery) or die ("Coudn't get type from questions<br />$ccquery<br />".mysql_error());
				while($ccrows=mysql_fetch_array($ccresult))
					{
					$thistype=$ccrows['type'];
					} 
				$cqquery = "SELECT cfieldname, value, cqid FROM conditions WHERE qid={$ia[0]} AND cqid={$crows['cqid']}";
				$cqresult = mysql_query($cqquery) or die("Couldn't get conditions for this question/cqid<br />$cquery<br />".mysql_error());
				$amatchhasbeenfound="N";
				while ($cqrows=mysql_fetch_array($cqresult))
					{
					$currentcqid=$cqrows['cqid'];
					$conditionfieldname=$cqrows['cfieldname'];
					if (!$cqrows['value']) {$conditionvalue="NULL";} else {$conditionvalue=$cqrows['value'];}
					if ($thistype == "M" || $thistype == "O")
						{
						$conditionfieldname .= $conditionvalue;
						$conditionvalue = "Y";
						}
					if (!$_SESSION[$conditionfieldname]) {$currentvalue="NULL";} else {$currentvalue=$_SESSION[$conditionfieldname];}
					if ($currentvalue == $conditionvalue) {$amatchhasbeenfound="Y";}
					echo "!- $conditionfieldname -- ". $currentvalue . "---". $conditionvalue."-- <br />";
					}
				if ($amatchhasbeenfound == "Y") {$cqidmatches++;}
				}
			if ($cqidmatches == $cqidcount)
				{
				//a match has been found in ALL distinct cqids. The question WILL be displayed
				$conditionforthisquestion="N";
				}
			else
				{
				//matches have not been found in ALL distinct cqids. The question WILL NOT be displayed
				echo "<!-- DEBUG - CONDITIONS ARE NOT MET IN THIS ROUND -->\n";
				if ($move == " next >> ")
					{
					$currentquestion++;
					$ia=$_SESSION['fieldarray'][$currentquestion];
					$_SESSION['step']++;
					foreach ($_SESSION['grouplist'] as $gl)
						{
						if ($gl[0] == $ia[5])
							{
							$gid=$gl[0];
							$groupname=$gl[1];
								$groupdescription=$gl[2];
							if ($_POST['lastgroupname'] != $groupname) {$newgroup = "Y";} else {$newgroup == "N";}
							}
						}

					if ($_SESSION['step'] > $_SESSION['totalsteps']) 
						{
						//echo "OhMyGod!";
						//The last question was conditional and has been skipped. Move into panic mode.
						$conditionforthisquestion="N";
						last();
						exit;
					//	submit($surveyheader, $_SESSION['step'], $_SESSION['totalsteps'], $sid, $setfont, $surveyprivate);
					//	exit;
						}
					}
				elseif ($move == " << prev ")
					{
					$currentquestion--;
					$ia=$_SESSION['fieldarray'][$currentquestion];
					$_SESSION['step']--;
					//$s = $_SESSION['step'];
					//$t--;
					//$v--;
					//$chart = (($s-1)/$u*100);
					}
				$conditionforthisquestion=$ia[7];
				}
			}

//echo "--- ".$ia[1]." ---<br />";
include("qanda.php");

$percentcomplete = makegraph($_SESSION['step'], $_SESSION['totalsteps']);

//READ TEMPLATES, INSERT DATA AND PRESENT PAGE
foreach(file("$thistpl/startpage.pstpl") as $op)
	{
	echo templatereplace($op);
	}
echo "\n<form method='post' action='$PHP_SELF' id='phpsurveyor' name='phpsurveyor'>\n";
//PUT LIST OF FIELDS INTO HIDDEN FORM ELEMENT
//echo "\n\n<!-- INPUT NAMES -->\n";
//echo "\t<input type='hidden' name='fieldnames' value='";
//echo implode("|", $inputnames);
//echo "'>\n";

echo "\n\n<!-- START THE SURVEY -->\n";
foreach(file("$thistpl/survey.pstpl") as $op)
	{
	echo "\t".templatereplace($op);
	}

if ($newgroup == "Y" && $groupdescription && $_POST['move'] != " << prev ")
	{
	$presentinggroupdescription = "yes";
	echo "\n\n<!-- START THE GROUP DESCRIPTION -->\n";
	echo "\t\t\t<input type='hidden' name='grpdesc' value='Y'>\n";
	//echo "\t\t\t&nbsp;\n";
	foreach(file("$thistpl/startgroup.pstpl") as $op)
		{
		echo "\t".templatereplace($op);
		}
	echo "\n<br />\n";
	
	if ($groupdescription)
		{
		foreach(file("$thistpl/groupdescription.pstpl") as $op)
			{
			echo "\t\t".templatereplace($op);
			}
		}
	echo "\n";
	
	echo "\n\n<!-- JAVASCRIPT FOR CONDITIONAL QUESTIONS -->\n";
	echo "\t<script type='text/javascript'>\n";
	echo "\t<!--\n";
	echo "\t\tfunction checkconditions(value, name, type)\n";
	echo "\t\t\t{\n";
	echo "\t\t\t}\n";
	echo "\t//-->\n";
	echo "\t</script>\n\n";
//	echo "&nbsp;\n";
	echo "\n\n<!-- END THE GROUP -->\n";
	foreach(file("$thistpl/endgroup.pstpl") as $op)
		{
		echo "\t\t\t\t".templatereplace($op);
		}
	echo "\n";

//	echo "&nbsp;\n";
	$_SESSION['step']--;
	echo "\t\t\t<input type='hidden' name='newgroupondisplay' value='Y'>\n";
	}
else
	{
	echo "\n\n<!-- START THE GROUP -->\n";
//	echo "\t&nbsp;\n";
	foreach(file("$thistpl/startgroup.pstpl") as $op)
		{
		echo "\t".templatereplace($op);
		}
	echo "\n";
	
	//if ($groupdescription)
	//	{
	//	foreach(file("$thistpl/groupdescription.pstpl") as $op)
	//		{
	//		echo "\t\t".templatereplace($op);
	//		}
	//	}
	//echo "\n";
	
	echo "\n\n<!-- JAVASCRIPT FOR CONDITIONAL QUESTIONS -->\n";
	echo "\t<script type='text/javascript'>\n";
	echo "\t<!--\n";
	echo "\t\tfunction checkconditions(value, name, type)\n";
	echo "\t\t\t{\n";
	echo "\t\t\t}\n";
	echo "\t//-->\n";
	echo "\t</script>\n\n";
//	echo "&nbsp;\n";
	
	
	echo "\n\n<!-- PRESENT THE QUESTIONS -->\n";
	if (is_array($qanda))
		{
		foreach ($qanda as $qa)
			{
			echo "\n\t<!-- NEW QUESTION -->\n";
			echo "\t\t\t\t<div name='$qa[4]' id='$qa[4]'>";
			//if ($qa[3] != "Y") {echo ">\n";} else {echo " style='display: none'>\n";}
			$question=$qa[0];
			$answer=$qa[1];
			$help=$qa[2];
			$questioncode=$qa[5];
			foreach(file("$thistpl/question.pstpl") as $op)
				{
				echo "\t\t\t\t\t".templatereplace($op)."\n";
				}
			echo "\t\t\t\t</div>\n";
			}
		}
	echo "\n\n<!-- END THE GROUP -->\n";
	foreach(file("$thistpl/endgroup.pstpl") as $op)
		{
		echo "\t\t\t\t".templatereplace($op);
		}
	echo "\n";

//	echo "&nbsp;\n";
	}
$navigator = surveymover();
echo "\n\n<!-- PRESENT THE NAVIGATOR -->\n";
foreach(file("$thistpl/navigator.pstpl") as $op)
	{
	echo "\t\t".templatereplace($op);
	}
echo "\n";

if ($surveyactive != "Y") {echo "\t\t<center><font color='red' size='2'>This survey is not currently active. You will not be able to save your responses.</font></center>\n";}
foreach(file("$thistpl/endpage.pstpl") as $op)
	{
	echo templatereplace($op);
	}
echo "\n";
	
if (is_array($conditions)) //if conditions exist, create hidden inputs for previously answered questions
	{
	foreach (array_keys($_SESSION) as $SESak)
		{
		if (in_array($SESak, $_SESSION['insertarray']))
			{
			echo "<input type='hidden' name='java$SESak' id='java$SESak' value='" . $_SESSION[$SESak] . "'>\n";
			}
		}
	}

//PUT LIST OF FIELDS INTO HIDDEN FORM ELEMENT (But only when a question is showing)
if ($newgroup == "Y" && $groupdescription && $_POST['move'] != " << prev ")
	{}
else
	{echo "<input type='hidden' name='fieldnames' value='";
	echo implode("|", $inputnames);
	echo "'>\n";
	}
//SOME STUFF FOR MANDATORY QUESTIONS
if (is_array($mandatorys) && $newgroup != "Y")
	{
	$mandatory=implode("|", $mandatorys);
	echo "<input type='hidden' name='mandatory' value='$mandatory'>\n";
	}
if (is_array($conmandatorys))
	{
	$conmandatory=implode("|", $conmandatorys);
	echo "<input type='hidden' name='conmandatory' value='$conmandatory'>\n";
	}
if (is_array($mandatoryfns))
	{
	$mandatoryfn=implode("|", $mandatoryfns);
	echo "<input type='hidden' name='mandatoryfn' value='$mandatoryfn'>\n";
	}
if (is_array($conmandatoryfns))
	{
	$conmandatoryfn=implode("|", $conmandatoryfns);
	echo "<input type='hidden' name='conmandatoryfn' value='$conmandatoryfn'>\n";
	}

echo "<input type='hidden' name='thisstep' value='{$_SESSION['step']}'>\n";
echo "<input type='hidden' name='sid' value='$sid'>\n";
echo "<input type='hidden' name='token' value='$token'>\n";
echo "<input type='hidden' name='lastgroupname' value='$groupname'>\n";
echo "</form>\n</html>";

function surveymover()
	{
	global $sid, $presentinggroupdescription;
	if ($_SESSION['step'])
		{$surveymover .= "<input class='submit' type='submit' value=' << prev ' name='move' />\n";}
	if ($_SESSION['step'] && (!$_SESSION['totalsteps'] || ($_SESSION['step'] < $_SESSION['totalsteps'])))
		{$surveymover .=  "\t\t\t\t\t<input class='submit' type='submit' value=' next >> ' name='move' />\n";}
	if (!$_SESSION['step'])
		{$surveymover .=  "\t\t\t\t\t<input class='submit' type='submit' value=' next >> ' name='move' />\n";}
	if ($_SESSION['step'] && ($_SESSION['step'] == $_SESSION['totalsteps']) && $presentinggroupdescription == "yes")
		{$surveymover .=  "\t\t\t\t\t<input class='submit' type='submit' value=' next >> ' name='move' />\n";}
	if ($_SESSION['step'] && ($_SESSION['step'] == $_SESSION['totalsteps']) && !$presentinggroupdescription)
		{$surveymover .= "\t\t\t\t\t<input class='submit' type='submit' value=' last ' name='move' />\n";}
	//$surveymover .= "\t\t\t\t\t<br />\n";
	return $surveymover;	
	}


function last()
	{
	global $thistpl, $sid, $token, $surveyprivate;
	if ($surveyprivate != "N")
		{
		foreach (file("$thistpl/privacy.pstpl") as $op)
			{
			$privacy .= $op;
			}
		}
	//READ TEMPLATES, INSERT DATA AND PRESENT PAGE
	foreach(file("$thistpl/startpage.pstpl") as $op)
		{
		echo templatereplace($op);
		}
	echo "\n\n<!-- JAVASCRIPT FOR CONDITIONAL QUESTIONS -->\n";
	echo "\t<script type='text/javascript'>\n";
	echo "\t<!--\n";
	echo "\t\tfunction checkconditions(value, name, type)\n";
	echo "\t\t\t{\n";
	echo "\t\t\t}\n";
	echo "\t//-->\n";
	echo "\t</script>\n\n";
	echo "\n<form method='post' action='$PHP_SELF' id='phpsurveyor' name='phpsurveyor'>\n";
	$GLOBALS["privacy"]=$privacy;
	echo "\n\n<!-- START THE SURVEY -->\n";
	foreach(file("$thistpl/survey.pstpl") as $op)
		{
		echo "\t\t".templatereplace($op);
		}
	//READ SUBMIT TEMPLATE
	foreach(file("$thistpl/submit.pstpl") as $op)
		{
		echo "\t\t\t".templatereplace($op);
		}
	
	$GLOBALS["navigator"]=surveymover();
	echo "\n\n<!-- PRESENT THE NAVIGATOR -->\n";
	foreach(file("$thistpl/navigator.pstpl") as $op)
		{
		echo "\t\t".templatereplace($op);
		}
	echo "\n";
	foreach(file("$thistpl/endpage.pstpl") as $op)
		{
		echo templatereplace($op);
		}
	echo "\n";
	echo "\n<input type='hidden' name='thisstep' value='{$_SESSION['step']}'>\n";
	echo "\n<input type='hidden' name='sid' value='$sid'>\n";
	echo "\n<input type='hidden' name='token' value='$token'>\n";
	echo "\n</form>\n</html>";
	}
?>