Changeset 444 for trunk/app/models/vclassroom.php

Timestamp:

05/01/08 23:19:28 (8 months ago)

Author:

aarkerio

Message:

Add new tables for students result

Files:

• trunk/app/models/vclassroom.php (modified) (3 diffs)

trunk/app/models/vclassroom.php

@@ -78 +78 @@
                          )
                        );
-
+ 
  // get student record
  public function getRecord($user_id, $vclassroom_id)
- {
+ {   
      $record     = (string) '';
-
+     
      $conditions = array('Result.vclassroom_id'=>$vclassroom_id, 'Result.user_id'=>$user_id);
      $fields     = array('Result.percentage', 'Test.title'); //null;
@@ -90 +90 @@
      foreach ($tests as $t) 
      {
-       $record .= $t['Test']['title'];
-       $record .= 'Percentage: ' . $t['Result']['percentage'];  
+     $record .= 'Test: ' . $t['Test']['title'] . '<br />';
+         $record .= 'Percentage: ' . $t['Result']['percentage'] . '<br />';
      }
-     
      
      // $webquests  = $this->Webquest->ResultWebquest->findAll($conditions, $fields);
@@ -101 +100 @@
      $treasures  = $this->Treasure->ResultTreasure->findAll($conditions, $fields);
      
-     foreach ($tests as $t) 
+     foreach ($treasures as $tr) 
      {
-       $record .= $t['Test']['title'];
-       $record .= 'Percentage: ' . $t['Result']['percentage'];  
+       $record .= 'Treasure: '. $tr['Treasure']['title'] . '<br />';
+       $record .= 'Points: ' . $tr['ResultTreasure']['points'] . '<br />';
      }
+     
+     $conditions  = array('Topic.vclassroom_id'=>$vclassroom_id, 'Topic.user_id'=>$user_id);
+     $fields      = array('Forum.title', 'Topic.subject'); //null;
+     $topics      = $this->Forum->Topic->findAll($conditions, $fields);
+     
+     $participations = (int) 0;
+     
+     foreach ($topics as $p) 
+     {
+       $record .= 'Forum: '. $p['Forum']['title'] . '<br />';
+       $participations++;
+     }
+     
+     $record .= 'Participations on Forums: ' . $participations . '<br />';
      // die(debug($treasures));
      return $record;