Changeset 170

Timestamp:

12/02/11 13:10:30 (13 years ago)

Author:

jkraaijeveld

Message:

• Session objects now have a 'toSPSS($location)' method, which creates a file at the specified location which can be imported into SPSS.

Location:

Dev/trunk/classes

Files:

• Session.php (modified) (1 diff)
• SessionConnector.php (modified) (1 diff)

Dev/trunk/classes/Session.php

@@ -36 +36 @@
                 $this->answersets = $answersets;
         }
+
+        /**
+         * function toSPSS
+         * @param type $location
+         * Writes an SPSS parseable file at the given location, named '$datetime_$title.txt'
+         */
+        public function toSPSS($location)
+        {
+                if(!is_dir($location))
+                {
+                        mkdir($location);
+                }
+                $fileName = $this->datetime->format("d-m-Y") . "_" . $this->title . ".txt";
+
+                //Make a list of all 'column headers', e.g. "respondent" and all the question codes.
+                $headers = array();
+                $headers[] = "respondent";
+                foreach ($this->pipeline as $element)
+                {
+                        if(get_class($element) == "Survey")
+                        {
+                                foreach($element->questions as $question)
+                                {
+                                        $headers[] = $element->title . '_' . $question->uid;
+                                }
+                        }
+                }
+                
+                $answers = $this->getAnswers($headers);
+
+                //Create the strings and write to file.
+                $headerString = "";
+                foreach($headers as $headerElement)
+                {
+                        $headerString = $headerString . $headerElement . "\t";
+                }
+                $fileHandler = fopen($location . '/' . $fileName, 'w') or die("File in use");
+                fwrite($fileHandler, $headerString . "\n");
+                foreach($answers as $entry)
+                {
+                        $entryString = "";
+                        foreach(array_keys($entry) as $i)
+                        {
+                                $entryString = $entryString . $entry[$i] . "\t";        
+                        }
+                        fwrite($fileHandler, $entryString . "\n");      
+                }
+        }
+
+        /*
+         * function getAnswers
+         * @param type $headers
+         * Based on the questions specified in the headers array, matches the answers of every
+         * respondent to the correct questions and returns an array containing a list of answers per 
+         * respondent
+         */
+        private function getAnswers($headers)
+        {
+                //Add the answers per survey per respondent. Requires some extra looping to assure proper ordering.
+                //Keeps a list of respondents which have already been used. If an answerset exists for a respondent which
+                //already exists within the answers-array, use the index of the respondent. Else: make a new row.
+                $respondentsUsed = array();
+                $answers = array();
+                foreach($this->answersets as $answerset)
+                {
+                        $entryIndex;
+                        if(in_array($answerset->respondent->uid, $respondentsUsed))
+                        {
+                                $entryIndex = array_search($answerset->respondent->uid, $respondentsUsed);
+                                $entry = $answers[$entryIndex];
+                        }
+                        else
+                        {
+                                $entry = array();
+                                $entry[0] = $answerset->respondent->uid;
+                                $entryIndex = count($respondentsUsed);
+                                $respondentsUsed[] = $answerset->respondent->uid;
+                        }
+                        foreach ($answerset->answers as $answer)
+                        {
+                                $index = array_search($answerset->survey->title . '_' . $answer->question->uid, $headers);
+                                //Index has to be a good number, else the answer doesn't belong in this session
+                                //Causes might be a missing question or having a wrong survey
+                                if($index != 0)
+                                {
+                                        $value = "";
+                                        foreach ($answer->values as $val)
+                                        {
+                                                $value = $value . $val . ",";
+                                        }
+                                        if (strlen($value) > 0) { $value = substr($value, 0, strlen($value)-1); }
+                                        $entry[$index] = $value;
+                                }
+                        }
+                        $answers[$entryIndex] = $entry;
+                }
+                return $answers;
+        }
+
 }       
 

Dev/trunk/classes/SessionConnector.php

@@ -115 +115 @@
                                 $datetime = new DateTime();
                                 $datetime->setTimestamp(intval($result['?datetime']->label));
-                                $sessions[] = new Session($result['?uid']->label, $result['?title']->label, $creator, $datetime, $pipeline, $answersets);
+                                $sessions[] = new Session($result['?uid']->label, $result['?title']->label, $creator[0], $datetime, $pipeline, $answersets);
                         }
                 }