Changeset 443 for trunk/app/models

Timestamp:

04/30/08 14:40:36 (7 months ago)

Author:

aarkerio

Message:

New SQL table

Location:

trunk/app/models

Files:

• result_webquest.php (added)
• vclassroom.php (modified) (1 diff)

trunk/app/models/vclassroom.php

@@ -80 +80 @@
 
  // get student record
- public function getRecord($vclassroom_id, $user_id)
+ public function getRecord($user_id, $vclassroom_id)
  {
-     $record = (string) '';
-
-     $conditions = array('"'=>$vclassroom_id, '"UsersVclassroom"."user_id"'=>$user_id);
-  
-     $tests      = $this->Vclassroom->Test->findAll($conditions, $fields);
-
+     $record     = (string) '';
+
+     $conditions = array('Result.vclassroom_id'=>$vclassroom_id, 'Result.user_id'=>$user_id);
+     $fields     = array('Result.percentage', 'Test.title'); //null;
+     $tests      = $this->Test->Result->findAll($conditions, $fields);
+     //die(debug($tests));
      foreach ($tests as $t) 
      {
-       
-     }   
-
-     $webquests  = $this->Vclassroom->Webquest->findAll($conditions, $fields);
-    
-     $treasures  = $this->Vclassroom->Treasures->findAll($conditions, $fields);
-
+       $record .= $t['Test']['title'];
+       $record .= 'Percentage: ' . $t['Result']['percentage'];  
+     }
+     
+     
+     // $webquests  = $this->Webquest->ResultWebquest->findAll($conditions, $fields);
+     
+     $conditions = array('ResultTreasure.vclassroom_id'=>$vclassroom_id, 'ResultTreasure.user_id'=>$user_id);
+     $fields     = array('ResultTreasure.points', 'Treasure.title'); //null;
+     $treasures  = $this->Treasure->ResultTreasure->findAll($conditions, $fields);
+     
+     foreach ($tests as $t) 
+     {
+       $record .= $t['Test']['title'];
+       $record .= 'Percentage: ' . $t['Result']['percentage'];  
+     }
+     // die(debug($treasures));
      return $record;
  }