Changeset 91 for Dev/trunk/classes

Timestamp:

08/30/11 17:49:19 (14 years ago)

Author:

basvannuland

Message:

start with dashboard database

Location:

Dev/trunk/classes

Files:

• ApplicationDatabaseInterface.php (modified) (1 diff)
• DashboardCreationDatabaseInterface.php (added)
• DashboardRDFReader.php (added)
• DashboardRDFWriter.php (added)
• QuestionRDFReader.php (modified) (1 diff)
• SurveyAnswerDatabaseInterface.php (modified) (1 diff)
• SurveyCreationDatabaseInterface.php (modified) (2 diffs)
• SurveyCreationTool.php (modified) (1 diff)
• SurveyRDFReader.php (modified) (1 diff)

Dev/trunk/classes/ApplicationDatabaseInterface.php

@@ -63 +63 @@
 
         $resultApplication = $this->applicationRDFReader->readAllApplications();
-        
-        for($aNumber = 0;$aNumber<sizeof($resultApplication[0]);$aNumber++)
+        if($resultApplication[0] != false)
         {
-            $aID = $resultApplication[0][$aNumber]['?uid']->label;
-            $aTitle = $resultApplication[1][$aNumber]['?title']->label;
-            $applicationInfo[$aID] = $aTitle;
-        }               
+            for($aNumber = 0;$aNumber<sizeof($resultApplication[0]);$aNumber++)
+            {
+                $aID = $resultApplication[0][$aNumber]['?uid']->label;
+                $aTitle = $resultApplication[1][$aNumber]['?title']->label;
+                $applicationInfo[$aID] = $aTitle;
+            }
+        }
 
         return $applicationInfo;

Dev/trunk/classes/QuestionRDFReader.php

@@ -69 +69 @@
         return $result; 
     }
+    
+    public function readQuestionCodes()
+    {
+        $result = null;
+        
+        if(file_exists($this->filePath.'questions.rdf'))
+        {
+            // Create empty MemModel
+            $factory = new ModelFactory();
+            $tempmodel= $factory->getDefaultModel();
+            $tempmodel->load($this->filePath.'questions.rdf');
+
+            $querystring = '
+            PREFIX      predicates: <' . SURVEYTOOL_PREDICATES_NAMESPACE . '>
+            PREFIX      resources: <' . SURVEYTOOL_RESOURCES_NAMESPACE . '>
+            SELECT      ?questionCode
+            WHERE 
+            {   
+                    _question   predicates:resource_type        resources:question ;
+                                predicates:question_code        ?questionCode                           
+            }';
+            
+            $result = $tempmodel->sparqlQuery($querystring);
+        }
+        return $result; 
+    }
 
     public function readQuestionTitle($questionID)

Dev/trunk/classes/SurveyAnswerDatabaseInterface.php

@@ -5 +5 @@
 // Include RAP Library to write RDF files
 include(RDFAPI_INCLUDE_DIR . "RDFAPI.php");
-
-
 
 class SurveyAnswerDatabaseInterface extends SurveyCreationDatabaseInterface

Dev/trunk/classes/SurveyCreationDatabaseInterface.php

@@ -94 +94 @@
         }
         
-        if(!$this->checkQuestionIDExists($qID))
-        {
+        if($this->checkQuestionCodeExists($qCode))
+        {
+            return 'Question code (' . $qCode . ') already in use. Please try a new code.';
+        }
+        else if($this->checkQuestionIDExists($qID))
+        {
+            return 'Question already exists';
+        }
+        else {
             $this->questionRDFWriter->createQuestion($qTitle,$qDescription,$qType,$qID,"null","null",$qAnswers);
+            return 'Question saved';
         }
     }
@@ -201 +209 @@
         return $result;
     }
+    
+    public function checkQuestionCodeExists($qCode)
+    {
+        $result = false;
+
+        $questionCodes = $this->questionRDFReader->readQuestionCodes();
+        
+        if ($questionCodes != null)
+        {
+            foreach($questionCodes as $questionCode)
+            {
+                $code = $questionCode['?questionCode']->label;
+                if(!strcmp($code ,$qCode))
+                {
+                    $result = true;
+                    break;
+                }
+            }
+        }
+
+        return $result;
+    }
 }
 ?>

Dev/trunk/classes/SurveyCreationTool.php

@@ -15 +15 @@
         $this->survey = $survey;
         $this->timeStamp = $timeStamp;
-        var_dump($_POST);
-        var_dump($survey);
         if (isset($this->survey->id))
             SurveyCreationTool::javascript($this->survey->id);

Dev/trunk/classes/SurveyRDFReader.php

@@ -20 +20 @@
     public function loadSurvey()
     {
-        $this->model->load($this->filePath);
+        if(file_exists($this->filePath))
+        {
+            $this->model->load($this->filePath);
+            return true;
+        }
+        else
+        {
+            return false;
+        }
     }