Changeset 429

Timestamp:

04/24/08 21:33:43 (9 months ago)

Author:

aarkerio

Message:

Tests and answers

Location:

trunk/app

Files:

• config/sql/karamelo_postgres.sql (modified) (1 diff)
• controllers/tests_controller.php (modified) (5 diffs)
• views/tests/result.ctp (modified) (1 diff)
• views/tests/view.ctp (modified) (4 diffs)

trunk/app/config/sql/karamelo_postgres.sql

@@ -589 +589 @@
    results smallint NOT NULL,
    test_id int NOT NULL REFERENCES tests(id) ON DELETE CASCADE,
-   PRIMARY KEY (user_id, test_id)
+   vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE,
+   PRIMARY KEY (user_id, test_id, vclassroom_id)
 );
 -- Test model tables ends
 
-
--- Share it!
+-- Share stuff (docs an5Dd multimedia) with your students
 CREATE TABLE shares (
 id serial PRIMARY KEY,

trunk/app/controllers/tests_controller.php

@@ -68 +68 @@
      // the student alredy answered this test?
      $already = $this->Test->Result->field('Result.id', array("Result.user_id"=>$this->Auth->user('id'), "Result.test_id"=>$test_id));
-
+     
      if ($already != null)
      {
@@ -75 +75 @@
          exit();
      }
-
+    
     if ( $this->Auth->user() && $this->Auth->user('group_id') == 3)
     {
@@ -95 +95 @@
 
     $this->set('data', $this->Test->find($conditions, $fields, $order, 2));
-  }
+ }
 
  public function result()
  { 
  try {
-    // die(debug($this->data['Test']));
-
+   //die(debug($this->data['Test']));
+    if ( $this->Auth->user() && $this->Auth->user('group_id') == 3)
+    {
+       $student_id = (int) $this->Auth->user('id');
+           $this->Edublog->setSession($student_id); //check if user belongs to class
+    }
+    
     $this->pageTitle = 'Test Results';
     
@@ -130 +135 @@
          if ( $res['Answer']['correct'] == 1)       
      {
-            echo 'worth: ' . $res['Question']['worth'].'<br />';
             $points += (int) $res['Question']['worth'];        
          }
@@ -137 +141 @@
     // die('Points:  '. $points);
          
-    $this->data['Result']['test_id'] =  $this->data['Question']['test_id'];
-
-    $this->data['Result']['user_id']    = $this->Auth->user('id');
-    $this->data['Result']['user_id']    = $points;  
+    $this->data['Result']['user_id']        = $this->Auth->user('id');
+    $this->data['Result']['results']        = $points;
+    $this->data['Result']['test_id']        = $this->data['Test']['test_id']; 
+    $this->data['Result']['vclassroom_id']  = $this->data['Test']['vclassroom_id'];
+
     $this->Test->Result->create();
       
     if ($this->Test->Result->save($this->data['Result']) )
     {
-         $this->set('data',     $this->Test->find($conditions, null, null, 2));
-         $this->set('results', $this->data['Result']);
-    }
-    } 
-    catch (Exception $e) 
-    {
+         $this->data['Test']['results']          = $points;
+         $maxpoints = (int) $this->data['Test']['maxpoints'];
+         $this->data['Test']['percentage']        = number_format( ( ($points / $maxpoints)*100), 2, '.', '');
+         $this->set('data', $this->data['Test']);
+    }
+  }
+  catch (Exception $e) 
+  {
       echo "Caught my exception\n" . $e;
-    }   
+  }   
  }
 

trunk/app/views/tests/result.ctp

@@ -1 +1 @@
 <?php
-// exit(var_dump($data));
-?>
+//exit(debug($data));
+$auth = true;
 
-<div style="font-size:18pt;padding:5px;boder:1px solid #c0c0c0"> <?php echo $blog["User"]["username"]; ?>'s Exam</div>
+/* if ( $session->check('vclassrooms') ):
+   foreach($data['Vclassroom'] as $v):
+       if ( in_array($v['id'], $session->read('vclassrooms'))):
+              $auth = true; 
+          break;
+       endif;
+   endforeach;
+endif; */
+ 
+if ( $auth === true ):
 
-<?php
-if ( $othAuth->sessionValid() && $othAuth->user('group_id') == 3)
-{
- echo '<h2>' . $othAuth->user('username') .'\'s results </h2>';
+ echo '<h2>' . $cU['User']['username'] .'\'s results </h2>';
 
- echo '<p>You result was: <b>'.$results['results'].'</b> points. Result has been saved, Thanks!<p>';
+ echo $html->div('result', $data['percentage'].'%');
 
- echo '<h1>'. $data['Test']['title'] . '</h1>';
+ echo $html->para(null, 'You result was: <b>'.$data['results'].'</b> from ' .$data['maxpoints'] .' possible score. Result has been saved, Thanks!');
 
- echo '<p>'.  $data['Test']['description'] . '</p>';
 
- foreach ($data['Question'] as $val)
- {
-   //exit(var_dump($val));
-   echo '<div>';
-   echo '<div style="font-size:14pt;margin:5px 0 6px 0">' . $val['question'] .' '. $val['worth']  .'</div>'; 
-    
-   $total = 0;
-
-   foreach ($val["Answer"] as $v)
-   {
-       // $v['id'] = $v['answer'];
- 
-       echo 'Your answer was:';
-   }
-
-  
-    echo '<br /><b>Hint was</b>: <i>' .  $val['hint']  . '</i><br /><br />';
-    echo '</div>';
- }
-
-}
-else
-{
-  echo '<p>You must be logged to see this exam</p>';
-}
+else:
+  echo '<p>You must be logged adn belongs to this class to see this exam</p>';
+endif;
 
 

trunk/app/views/tests/view.ctp

@@ -1 +1 @@
 <?php
-// die(debug($data));
+//die(debug($data));
 
 $auth = false;
@@ -8 +8 @@
        if ( in_array($v['id'], $session->read('vclassrooms'))):
               $auth = true;
+              $vclassroom_id = $v['id']; 
           break;
        endif;
@@ -24 +25 @@
   echo $form->hidden('test_id', array('value'=>$data['Test']['id']));
   echo $form->hidden('blogger_id', array('value'=>$blog['User']['id']));
+  echo $form->hidden('vclassroom_id', array('value'=>$vclassroom_id ));
 
-$points = 0;  
+  $maxpoints = 0;  
   foreach ($data['Question'] as $val):
     //exit(debug($val));
-    $points += (int) $val['worth'];
-       echo '<div>';
+    $maxpoints += (int) $val['worth'];
+    echo $html->para(null, 'Maxim calification: ' . $maxpoints);
+    echo $form->hidden('maxpoints', array('value'=>$maxpoints));
+    echo '<div>';
        
           $options = array(); // to build options radio buttons
@@ -45 +49 @@
   endforeach;
  
-  echo $html->para(null, 'Maxim calification: '.$points);
   echo $form->end('Send');