Changeset 444

Timestamp:

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

Author:

aarkerio

Message:

Add new tables for students result

Location:

trunk/app

Files:

• config/sql/postgresql/participations.sql (added)
• config/sql/postgresql/result_treasures.sql (added)
• config/sql/postgresql/result_webquests.sql (added)
• config/sql/postgresql/topics.sql (modified) (1 diff)
• controllers/vclassrooms_controller.php (modified) (1 diff)
• models/forum.php (modified) (1 diff)
• models/participation.php (added)
• models/vclassroom.php (modified) (3 diffs)
• views/vclassrooms/admin_record.ctp (modified) (1 diff)

trunk/app/config/sql/postgresql/topics.sql

@@ -4 +4 @@
  message text NOT NULL,
  created timestamp(0) with time zone DEFAULT now() NOT NULL,
- forum_id integer NOT NULL REFERENCES forums(id) ON DELETE CASCADE,
+ forum_id int NOT NULL REFERENCES forums(id) ON DELETE CASCADE,
+ vclassroom_id int NOT NULL REFERENCES vclassrooms(id) ON DELETE CASCADE, -- just one facility to create student's reports
  user_id integer NOT NULL REFERENCES users(id) ON DELETE CASCADE,
- status int NOT NULL DEFAULT 1,
- views int NOT NULL DEFAULT 0  -- number of times the topic has been seen
+ status smallint NOT NULL DEFAULT 1,
+ views smallint NOT NULL DEFAULT 0  -- number of times the topic has been seen
 );
 

trunk/app/controllers/vclassrooms_controller.php

@@ -264 +264 @@
  public function admin_record($student_id, $vclassroom_id) 
  {
+    $this->layout    = 'admin';
+    $this->pageTitle = 'Student Record';
+    
     $record = $this->Vclassroom->getRecord($student_id, $vclassroom_id);
-
+    
     $this->set('data', $record);
  }

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;

trunk/app/views/vclassrooms/admin_record.ctp

@@ -1 +1 @@
 <?php
-die(debug($data));
+//die(debug($data));
 
-
+echo $html->div(null, $data);
 
 ?>