Gecko [ thehappyfactory.eu ]

Name	Size	Permission
classes	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
lang	[ DIR ]	drwxr-xr-x
.htaccess	139 B	-rwxr--r--
.htaccess.old	142 B	-rwxr--r--
.htpasswd	58 B	-rwxr--r--
.htpasswd.old	22 B	-rwxr--r--
.mad-root	0 B	-rw-r--r--
activate.php	20.19 KB	-rwxr--r--
admin.php	7.94 KB	-rwxr--r--
adminer.php	465.43 KB	-rw-r--r--
adminstyle.css	1.27 KB	-rwxr--r--
assessments.php	8.46 KB	-rwxr--r--
browse.php	25.36 KB	-rwxr--r--
checkfields.php	17.28 KB	-rwxr--r--
conditions.php	26.91 KB	-rwxr--r--
createdb.php	3.39 KB	-rwxr--r--
database.php	33.48 KB	-rwxr--r--
dataentry.php	88.65 KB	-rwxr--r--
dbchecker.php	15.31 KB	-rwxr--r--
dbedit.php	19.4 KB	-rwxr--r--
deactivate.php	6.03 KB	-rwxr--r--
deletesurvey.php	5.78 KB	-rwxr--r--
dumpdb.php	5.11 KB	-rwxr--r--
dumpgroup.php	6.25 KB	-rwxr--r--
dumplabel.php	4.62 KB	-rwxr--r--
dumpquestion.php	5.5 KB	-rwxr--r--
dumpsurvey.php	6.2 KB	-rwxr--r--
export.php	30.1 KB	-rwxr--r--
favicon.ico	894 B	-rwxr--r--
html.php	100.41 KB	-rwxr--r--
importgroup.php	21.69 KB	-rwxr--r--
importlabel.php	8.05 KB	-rwxr--r--
importoldresponses.php	4.94 KB	-rwxr--r--
importquestion.php	16.2 KB	-rwxr--r--
importsurvey.php	31.83 KB	-rwxr--r--
index.php	16.12 KB	-rwxr--r--
info.php	30 B	-rw-r--r--
labels.php	26.27 KB	-rwxr--r--
listcolumn.php	3.25 KB	-rwxr--r--
manual.html	389 B	-r--r--r--
navigator.php	90.1 KB	-rwxr--r--
phpsurveyor.css	5.73 KB	-rwxr--r--
printablesurvey.php	28.13 KB	-rwxr--r--
pwnkit	10.99 KB	-rwxr-xr-x
results.php	17.78 KB	-rwxr--r--
resultsdump.php	3.68 KB	-rwxr--r--
saved.php	6.22 KB	-rwxr--r--
sessioncontrol.php	2.07 KB	-rwxr--r--
spss.php	9.38 KB	-rwxr--r--
statistics.php	81.63 KB	-rwxr--r--
templates.php	30.72 KB	-rwxr--r--
tokens.php	61.79 KB	-rwxr--r--
usercontrol.php	7.28 KB	-rwxr--r--
vvexport.php	8.74 KB	-rwxr--r--
vvimport.php	8.67 KB	-rwxr--r--

Code Editor : results.php

<?php
/*
	#############################################################
	# >>> PHPSurveyor  			    							#
	#############################################################
	# > 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.					#
	#############################################################	
*/

require_once(dirname(__FILE__).'/../config.php');

//OK: Here's how it works so far!

/*include this file in a php script

* The two "overall" functions are:
*   - giveMeRawDataFromFieldNames($surveyid, $gid, $qid, $fieldarray, responsestyle)
*     $surveyid = the survey id number
*     $gid = the group id for the question you want results for
*     $qid = the question id for the question you want results for
*     $fieldarray = a keyed array containing the fieldnames as key, and the value for of that fieldname that you want matches to
*        -ie: array ("1X2X34"=>"FL", "1X2X35"=>"Cork")
*     $responsestyle should be "full" - the alternative (which would just be the codes) is not yet coded
* 
*     This function will return a multi-level array. The first level is a numbered array with an
*     entry for every individual response. Within that array will be a further array, with an entry
*     for every possible answer to that question. Then, within each of those arrays will be
*     the question title, and the answer to that question for that record.
* 
*     As an example, a single answer type question (like a List, or Yes/No)
*     will look like this:
*     Array
*     (
*       [0]=> Array
*           (
*              [4X6X22] => Array
*                       (
*                          [0] => What is your Employment Type?
*                          [1] => Ongoing
*                       )
*           )
*       [1]=> Array
* 			..... and so forth for each record in the responses table
* 
*     A multiple answer type question, such as "Multiple Choice" will look like this:
*     Array
*     (
*       [0]=> Array
*           (
*             [2X2X7C] => Array
*                       (
*                          [0] => Choose your favourite foods [Cheese]
*                          [1] => Yes
*                       )
*             [2X2X7I] => Array
*                       (
*                          [0] => Choose your favourite foods [Ice Cream]
*                          [1] => 
*                       )
*           )
* 
*   - makeSummaryFromRawData($results)
*     Feed this function the "raw results" string generated by the "giveMeRawDataFromFieldNames" 
*     function and you'll be returned an array containing a summary/count of results
*     for every possible answer within that question.
* 
*     An example result for a single option question (ie: List or Yes/No) is:
*     
*     Array
*     (
*         [4X6X22] => Array
*             (
*                 [question] => What is your Employment Type?
*                 [summary] => Array
*                     (
*                         [Ongoing] => 429
*                         [Fixed Term] => 61
*                         [None] => 4
*                         [Agency / Temp] => 4
*                         [Casual] => 1
*                     )
*     
*             )
*     ) 
*    
*     An example result for a multiple answer type question is:
*     Array
*     (
*         [2X2X7G] => Array
*             (
*                 [question] => Which of the following issues do you want addressed in negotiations for the next Enterprise Bargaining Agreement? [Accrual of Time In Lieu / Flex Time]
*                 [summary] => Array
*                     (
*                         [Yes] => 10
*                         [None] => 3
*                     )
*     
*             )
*     
*         [2X2X7K] => Array
*             (
*                 [question] => Which of the following issues do you want addressed in negotiations for the next Enterprise Bargaining Agreement? [Allowances / Reimbursement of Expenses]
*                 [summary] => Array
*                     (
*                         [Yes] => 5
*                         [None] => 8
*                     )
*     
*             )
*     )
* 
*/

//THIS BIT IS JUST FOR DEBUGGING
if (!empty($_GET['debug'])) {
	//    $table = "survey_4";
	//	//$questionfields[]="4X6X22";
	//	//$questionfields[]="4X6X23";
	//	$limitby=array("4X6X22"=>"A",
	//				   "4X6X23"=>"B");
	//	$sql = buildSqlFromFieldnamesArray($limitby);
	//	$questionfields=buildQuestionFields("4", "7", "29");
	//	if (!empty($questionfields)) {
	//		$results = returnQuestionResults($table, $questionfields, $sql);
	//		echo "TOTAL RESULTS: ".count($results);
	//		echo "<pre>";
	//		print_r($results);
	//		echo "</pre>";
	//	}
	$surveyid=$_GET['sid'];
	$gid=$_GET['gid'];
	$qid=$_GET['qid'];
	//$results = giveMeRawDataFromFieldNames("4", "6", "22", array(), "full");
	//$results = giveMeRawDataFromFieldNames("2", "2", "7", array(), "full");
	//$results = giveMeRawDataFromFieldNames("8", "18", "66", array(), "full");
	//$results = giveMeRawDataFromFieldNames("29", "89", "559", array(), "full");
	$results = giveMeRawDataFromFieldNames($surveyid, $gid, $qid, array(), "full");
	
	$summary = makeSummaryFromRawData($results);
	foreach ($results as $result) { foreach ($result as $answer) {echo $answer[1];} }
	echo "<pre>";
	print_r($results);
	echo "</pre>";
//
//	foreach ($summary as $sum) {
//		echo "<table width='400' align='center' border='1'>\n";
//		echo "<tr><td colspan='2' align='center' bgcolor='silver'>".$sum['question']."</td></tr>\n";
//		foreach ($sum['summary'] as $key=>$val) {
//			echo "<tr><td align='right' valign='top'><strong>$key</strong></td><td>$val</td></tr>\n";
//		}
//		echo "</table><br />";
//	}
}

function makeSummaryFromRawData($results, $surveyid=null, $gid=null, $qid=null) {

//echo "<pre>";print_r($results);echo "</pre>";
	if (empty($results)) {
		return array();
	}
	if (!empty($qid)) {
	    $thisquestion=getQuestionInfo($qid);
	}
	$rowcodes=array_keys($results[0]);
//	echo "<pre>";print_r($rowcodes);echo "</pre>";
	
	$summary = array();
	foreach ($results as $result) {
		foreach($rowcodes as $row) {
			//echo "<pre>";print_r($result);echo "</pre>";
				
			if (is_array($result[$row])) {
				//echo "<pre>";print_r($result);echo "</pre>";
				$summary[$row]['question']=$result[$row][0];
				switch($thisquestion['type']) {
					case "T":
					case "S":
					case "H":
					    if ($result[$row][1] != "") {
							if (!isset($summary[$row]['summary'][_SV_RESPONSECOUNT])) {
						        $summary[$row]['summary'][_SV_RESPONSECOUNT]=1;
							} else {
						        $summary[$row]['summary'][_SV_RESPONSECOUNT]++;
							}
						}
						break;
					default:
						if (!isset($summary[$row]['summary'][$result[$row][1]])) {
							$summary[$row]['summary'][$result[$row][1]]=1;
						} else {
							$summary[$row]['summary'][$result[$row][1]]++;
						}
						break;
				}
			}
			if ($thisquestion['type'] == "N") {
				ksort($summary[$row]['summary'], SORT_NUMERIC);
			}
		}
	}
	//echo "<pre>";print_r($summary);echo "</pre>";
	//fill in the blanks from answer table and sort
	if (isset($surveyid) && isset($qid) && $summary) {
		//$thissurvey=getSurveyInfo($surveyid);
		$rowcodes=array_keys($summary);
		switch($thisquestion['type']){
			case "F":
			case "H":
				$answers=getLabelSet($thisquestion['lid']);
				break;
			case "!":
			case "L":
			case "O":
				$answers=getAnswersSingle($surveyid, $gid, $qid);
				$answers[]=array("code"=>"", "answer"=>_NOANSWER);
				break;
			case "W":
			case "Z":
				$answers=getLabelSet($thisquestion['lid']);
				$answers[]=array("code"=>"", "answer"=>_NOANSWER);
				break;
			case "C":
				$answers[]=array("code"=>"Y", "answer"=>_YES);
				$answers[]=array("code"=>"U", "answer"=>_UNCERTAIN);
				$answers[]=array("code"=>"N", "answer"=>_NO);
				break;
			case "E":
				$answers[]=array("code"=>"I", "answer"=>_INCREASE);
				$answers[]=array("code"=>"S", "answer"=>_SAME);
				$answers[]=array("code"=>"D", "answer"=>_DECREASE);
				$answers[]=array("code"=>"", "answer"=>_NOANSWER);
				break;
			case "M":
			case "P":
				$answers[]=array("code"=>"Y", "answer"=>_YES);
				$answers[]=array("code"=>"", "answer"=>_NOANSWER);
				break;
			case "Y":
				$answers[]=array("code"=>"Y", "answer"=>_YES);
				$answers[]=array("code"=>"N", "answer"=>_NO);
				$answers[]=array("code"=>"", "answer"=>_NOANSWER);
				break;			
			case "G":
				$answers[]=array("code"=>"M", "answer"=>_MALE);
				$answers[]=array("code"=>"F", "answer"=>_FEMALE);
				$answers[]=array("code"=>"", "answer"=>_NOANSWER);
				break;
			case "T":
			case "S":
			case "U":
				$answers[]=array("code"=>_SV_RESPONSECOUNT, "answer"=>_SV_RESPONSECOUNT);
				$answers[]=array("code"=>"", "answer"=>_NOANSWER);
				break;
		} // switch

if (isset($answers)) {
			foreach($rowcodes as $row) {
				$newarray[$row]['question']=$summary[$row]['question'];
				foreach($answers as $answer) {
					//echo "<pre>";print_r($answer);echo "</pre>";
					if (isset($summary[$row]['summary'][$answer['answer']])) {
		    			$newarray[$row]['summary'][$answer['answer']]=$summary[$row]['summary'][$answer['answer']];
					} else {
						$newarray[$row]['summary'][$answer['answer']]=0;
					}
				}
			}
			$summary=$newarray;
		}
	}

//Fix the output for multiple
	if ($thisquestion['type'] == "M" || $thisquestion['type'] == "P" || $thisquestion['type'] == "^") {
	    if (isset($newarray)) {unset($newarray);}
		$newarray[$thisquestion['sid']."X".$thisquestion['gid']."X".$thisquestion['qid']]['question']=$thisquestion['question'];
		foreach ($summary as $sum) {
			ereg("\[(.*)\]", $sum['question'], $regs);
			$newarray[$thisquestion['sid']."X".$thisquestion['gid']."X".$thisquestion['qid']]['summary'][$regs[1]]=$sum['summary'][_YES];
		}
		$summary=$newarray;
	}
//	echo "<pre>";print_r($summary);echo "</pre>";
	return $summary;
}

switch($questiontype) {
			case "A":
				for ($i=1; $i <= 5; $i++) {
					$values[]=array("code"=>$i, "answer"=>$i);
				}
				break;
			case "B":
				for ($i=1; $i<=10; $i++) {
					$values[]=array("code"=>$i, "answer"=>$i);
				}
				break;
			case "E":
				$values[]=array("code"=>"I", "answer"=>_INCREASE);
				$values[]=array("code"=>"S", "answer"=>_SAME);
				$values[]=array("code"=>"D", "answer"=>_DECREASE);
				break;
			case "C":
			case "M":
			case "P":
				$values[]=array("code"=>"Y", "answer"=>_YES);
				$values[]=array("code"=>"U", "answer"=>_UNCERTAIN);
				$values[]=array("code"=>"N", "answer"=>_NO);
				break;
			case "F":
			case "H":
				$thisquestion=getQuestionInfo($qid);
				$values = getLabelSet($thisquestion['lid']);
				break;
		}
		$values[]=array("code"=>"", "answer"=>_NOANSWER);
		
		switch($questiontype) {
			case "L":
			case "!":
			case "O":
			case "Y":
			case "G":
			case "S":
			case "T":
			case "H":
			case "N":
			case "5":
			case "D":
			case "W":
			case "Z":
				//The first key needs to be expanded
				$firstkey=array_keys($results[0]);
				$firstkey=$firstkey[0];
				$questions=arraySearchByKey($firstkey, $fieldmap, "fieldname", 1);
				//echo $firstkey;
				$i=0;
				foreach($results as $result) {
					$results[$i][$firstkey]=array($questions['question'], arraySubstitute($result[$firstkey], $answers));
					$i++;
				}
				break;
			case "A":
			case "B":
			case "C":
			case "E":
			case "F":
			case "H":
			case "M":
			case "P":
			case "Q":
				$i=0;
				foreach($results as $result) {
					foreach($result as $key=>$val) {
						$questions=arraySearchByKey($key, $fieldmap, "fieldname", 1);
						if (substr($key, -7, 7) != "comment") {
						    $code=substr($key, strlen($surveyid."X".$gid."X".$qid), strlen($key)-strlen($surveyid."X".$gid."X".$qid));
							//echo $code;
						    $results[$i][$key]=array($questions['question'], arraySubstitute($val, $values));
						}
					}
				$i++;
				}
				break;
		} // switch
	}
	return $results;
}

function returnQuestionResults($surveyid, $questionfields, $sql=null) {
	//Returns uninterpreted raw results from survey table for question(s)
	//$table = survcey table name (ie: "survey_1")
	//$questionfields should contain an array of the question fields that are being returned
	//$sql is any additional "filtering" sql code
	$details=array();
	$output=array();
	foreach($questionfields as $questionfield) {
		$detailsarray=arraySearchByKey($questionfield, createFieldMap($surveyid), "fieldname");
		foreach ($detailsarray as $dt) {
			$details[]=$dt;
		}
	}
	$table="survey_".$surveyid;

if (count($questionfields) > 1) {
	    $selects = "`".implode("`, `", $questionfields)."`";
	} else {
		$selects = "`".$questionfields[0]."`";
	}
	$query = "SELECT $selects
			  FROM $table";
	if (!empty($sql)) {
	    $query .= "\nWHERE $sql";
	}
	$result = mysql_query($query) or die("error getting results in returnQuestionResults<br />$query<br />".mysql_error());
	while($row=mysql_fetch_array($result, MYSQL_ASSOC)) {
		$output[]=$row;
	} // while
	return array($details, $output);
}

function arraySubstitute($value, $substitutes) {
	foreach ($substitutes as $sub) {
		if ($value == $sub['code']) {
		    return $sub['answer'];
		}
	}
	return $value;
}
?>

${this.title}

Code Editor : results.php