Changeset 563 for trunk/app/models

Timestamp:

05/26/08 22:47:53 (6 months ago)

Author:

aarkerio

Message:

Reports

Location:

trunk/app/models

Files:

• reply.php (modified) (1 diff)
• vclassroom.php (modified) (4 diffs)

trunk/app/models/reply.php

@@ -12 +12 @@
                                      array('className' => 'User', 
                                            'foreignkey' => 'user_id',
-                                           'fields'=>array('username','id', 'avatar'))
+                        'fields'=>array('username','id', 'avatar'))
                          );
 

trunk/app/models/vclassroom.php

@@ -114 +114 @@
                        ); */ 
  /**
- *  Get student record, return array
+ *  Get student record in Vclassroom , return array
  *
  * @param  integer $user_id  description
@@ -124 +124 @@
  public function studentRecord($user_id, $vclassroom_id)
  {   
-     $record            = array();
-     
-     $record['user']    = $this->User->find(array('User.id'=>$user_id), array('id', 'username', 'name', 'email'));
-     
+     $record                  = array();
+   
+     $this->User->unbindAll();
+
+     $record   = $this->User->find(array('User.id'=>$user_id), array('id', 'username', 'name', 'email'));
+     
+     // Consult Test Model 
      $conditions        = array('Result.vclassroom_id'=>$vclassroom_id, 'Result.user_id'=>$user_id);
      $fields            = array('Result.percentage', 'Test.title');  //null;
      $record['tests']   = $this->Test->Result->findAll($conditions, $fields);
-     //die(debug($tests));
     
+     // Consult Treasure Model
      $conditions = array('ResultTreasure.vclassroom_id'=>$vclassroom_id, 'ResultTreasure.user_id'=>$user_id);
      $fields     = array('ResultTreasure.points', 'Treasure.title'); //null;
-     $record['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;
-     $record['topics'] = $this->Forum->Topic->findAll($conditions, $fields);
-
-     // forums
-     //$conditions     = array('Forum.vclassroom_id'=>$vclassroom_id, 'Forum.user_id'=>$user_id);
-     //$fields         = array('Participation.title', 'Participation.id', 'Participation.points'); //null;
-     
-     //$record['participations'] = $this->Participation->findAll($conditions, $fields);
-     
+     $record['treasures']  =  $this->Treasure->ResultTreasure->findAll($conditions, $fields);
+  
+     // Consult Reply Model    
+     $conditions        = array('Reply.vclassroom_id'=>$vclassroom_id, 'Reply.user_id'=>$user_id);
+     $fields            = array('Reply.topic_id', 'Reply.vclassroom_id', 'Reply.id', 'Reply.points'); //null;
+     $record['replies'] = $this->Forum->Topic->Reply->findAll($conditions, $fields);
+
      // Participations
      $conditions     = array('Participation.vclassroom_id'=>$vclassroom_id, 'Participation.user_id'=>$user_id);
-     $fields         = array('Participation.title', 'Participation.id', 'Participation.points'); //null;
-     
+     $fields         = array('Participation.title', 'Participation.id', 'Participation.points'); //null; 
      $record['participations'] = $this->Participation->findAll($conditions, $fields);
 
@@ -156 +153 @@
      $conditions     = array('ResultWebquest.vclassroom_id'=>$vclassroom_id, 'ResultWebquest.user_id'=>$user_id);
      $fields         = array('Webquest.title', 'Webquest.id', 'ResultWebquest.points'); //null;
-
-     $record['webquests']      = $this->Webquest->ResultWebquest->findAll($conditions, $fields);
-     
+     $record['webquests']        = $this->Webquest->ResultWebquest->findAll($conditions, $fields);
+     $record['Vclassroom']['id'] = $vclassroom_id; // dirty but works     
      //die(debug($record));
      return $record;
  }
-/*
+
+/* 
+*  getList method
 *  build a list containing vclassrooms to wich the stundent belongs to, used in portal component to display select  
 *  int  user_id
@@ -274 +272 @@
    $data = $this->UsersVclassroom->field('user_id', $conditions);
    
-   if ($data == null)
-   {
-     return false;    
-   }
-   else
-   {
-     return true; 
-   } 
+   if ($data == null):
+         return false;    
+   else:
+         return true; 
+   endif; 
+ }
+ public function studentPoints($user_id, $vclassroom_id)
+ {   
+     $points  = (int) 0;
+   
+     // Consult Test Model 
+     /*$conditions     = array('Result.vclassroom_id'=>$vclassroom_id, 'Result.user_id'=>$user_id);
+     $fields         = array('Result.percentage');  //null;
+     $tests          = $this->Test->Result->findAll($conditions, $fields);
+     foreach ($tests as $t):
+            $points = $t['Test'][''];
+     endforeach; */
+     // Consult Treasure Model
+     $conditions = array('ResultTreasure.vclassroom_id'=>$vclassroom_id, 'ResultTreasure.user_id'=>$user_id);
+     $fields     = array('ResultTreasure.points'); //null;
+     $treasures  =  $this->Treasure->ResultTreasure->findAll($conditions, $fields);
+     foreach ($treasures as $t):
+            $points += $t['ResultTreasure']['points'];
+     endforeach;
+  
+     // Consult Reply Model    
+     $conditions    = array('Reply.vclassroom_id'=>$vclassroom_id, 'Reply.user_id'=>$user_id);
+     $fields        = array('Reply.points'); //null;
+     $replies       = $this->Forum->Topic->Reply->findAll($conditions, $fields);
+     foreach ($replies as $r):
+            $points += $r['Reply']['points'];
+     endforeach;
+  
+     // Participations
+     $conditions     = array('Participation.vclassroom_id'=>$vclassroom_id, 'Participation.user_id'=>$user_id);
+     $fields         = array('Participation.points'); //null; 
+     $participations = $this->Participation->findAll($conditions, $fields);
+     foreach ($participations as $pa):
+            $points += $pa['Participation']['points'];
+     endforeach;
+  
+     // Webquest
+     $conditions     = array('ResultWebquest.vclassroom_id'=>$vclassroom_id, 'ResultWebquest.user_id'=>$user_id);
+     $fields         = array('Webquest.title', 'Webquest.id', 'ResultWebquest.points'); //null;
+     $webquests      = $this->Webquest->ResultWebquest->findAll($conditions, $fields);
+     foreach ($webquests as $w):
+            $points += $w['ResultWebquest']['points'];
+     endforeach;
+         
+     //die(debug($record));
+     return $points;
  }