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

Timestamp:

05/05/08 19:14:49 (8 months ago)

Author:

aarkerio

Message:

PDF support

Files:

• trunk/app/models/vclassroom.php (modified) (1 diff)

trunk/app/models/vclassroom.php

@@ -132 +132 @@
      return $record;
  }
+ /**
+ *  Get class (group) record
+ *
+ * @param  integer $vclassroom_id  description
+ * @return array   $record description
+ * @access public
+ * @author author Manuel Montoya 
+ **/
+ public function recordClass($vclassroom_id)
+ {   
+  $users      = array();
+  $records    = array();
+    
+  $data  = $this->UsersVclassroom->findAll(array('UsersVclassroom.vclassroom_id'=>$vclassroom_id), array('user_id'));
+
+  // die(debug($users));   
+  foreach ($data as $u):
+     
+     $user_id = $u['UsersVclassroom']['user_id'];
+     
+     $conditions        = array('Result.vclassroom_id'=>$vclassroom_id, 'Result.user_id'=>$user_id);
+     $fields            = array('Result.percentage', 'Test.title');  //null;
+     $records[$user_id]['tests']   = $this->Test->Result->findAll($conditions, $fields);
+     //die(debug($record['tests']));
+    
+     $conditions = array('ResultTreasure.vclassroom_id'=>$vclassroom_id, 'ResultTreasure.user_id'=>$user_id);
+     $fields     = array('ResultTreasure.points', 'Treasure.title'); //null;
+     $records[$user_id]['treasures']  =  $this->Treasure->ResultTreasure->findAll($conditions, $fields);  
+         
+     $conditions       = array('Topic.vclassroom_id'=>$vclassroom_id, 'Topic.user_id'=>$user_id);
+     $fields           = array('Forum.title', 'Topic.subject'); //null;
+     $records[$user_id]['topics'] = $this->Forum->Topic->findAll($conditions, $fields);
+     
+     $conditions     = array('Participation.vclassroom_id'=>$vclassroom_id, 'Participation.user_id'=>$user_id);
+     $fields         = array('Participation.title', 'Participation.points'); //null;
+     
+     $records[$user_id]['participations'] = $this->Participation->findAll($conditions, $fields);
+
+     $conditions     = array('ResultWebquest.vclassroom_id'=>$vclassroom_id, 'ResultWebquest.user_id'=>$user_id);
+     $fields         = array('Webquest.title', 'ResultWebquest.points'); //null;
+
+     $records[$user_id]['webquests']      = $this->Webquest->ResultWebquest->findAll($conditions, $fields);
+     
+  endforeach;
+  // die(debug($records));
+  return $records;
+ }
+
 /**
  *  Get student evaluation, return integer