Changeset 444 for trunk/app/models

Timestamp:

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

Author:

aarkerio

Message:

Add new tables for students result

Location:

trunk/app/models

Files:

• forum.php (modified) (1 diff)
• participation.php (added)
• vclassroom.php (modified) (3 diffs)

trunk/app/models/forum.php

@@ -16 +16 @@
                                            'order'      => 'id ASC',
                                            'fields'     => null
-                                           ));
+                                           ),
+            'Participation' => 
+                                     array('className'  => 'Participation', 
+                                           'foreignkey' => 'forum_id',
+                                           'conditions' =>  null,
+                                           'order'      => 'id ASC',
+                                           'fields'     => null
+                                           )
+                     );
+
 public $belongsTo = array('Catforum' => 
                                      array('className' => 'Catforum', 

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;