Changeset 452

Timestamp:

05/04/08 23:49:32 (8 months ago)

Author:

aarkerio

Message:

Best podcast

Location:

trunk/app

Files:

• config/sql/postgresql/webquests.sql (modified) (1 diff)
• models/vclassroom.php (modified) (2 diffs)
• models/webquest.php (modified) (2 diffs)
• views/vclassrooms/admin_record.ctp (modified) (1 diff)

trunk/app/config/sql/postgresql/webquests.sql

@@ -14 +14 @@
   "user_id" int REFERENCES users(id) ON DELETE CASCADE,
   "status" smallint NOT NULL DEFAULT 0,
-  "value" smallint NOT NULL DEFAULT 10,
+  "points" smallint NOT NULL DEFAULT 10,
   "karanet" smallint NOT NULL DEFAULT 0  -- share karanet?
 );

trunk/app/models/vclassroom.php

@@ -85 +85 @@
                          )
                        );
+ public $validate = array(
+      'name'    => VALID_NOT_EMPTY,
+      'user_id' => VALID_NOT_EMPTY,
+      'status'  => VALID_NOT_EMPTY
+   );
  
- // get student record
+ /**
+ *  Get student record, return array
+ *
+ * @param  integer $user_id  description
+ * @param  integer $vclassroom_id  description
+ * @return array   $record description
+ * @access public
+ * @author author Manuel Montoya 
+ **/
  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;
-     $tests      = $this->Test->Result->findAll($conditions, $fields);
+     $record            = array();
+     
+     $record['user']   = $this->User->find(array('User.id'=>$user_id), array('id', 'username', 'name', 'email'));
+     
+     $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));
-     foreach ($tests as $t) 
-     {
-     $record .= 'Test: ' . $t['Test']['title'] . '<br />';
-         $record .= 'Percentage: ' . $t['Result']['percentage'] . '<br />';
-     }
-     
-     // $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 ($treasures as $tr) 
-     {
-       $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);
-     
-     $num_topics = (int) 0;
-     
-     foreach ($topics as $p) 
-     {
-       $record .= 'Forum: '. $p['Forum']['title'] . '<br />';
-       $num_topics++;
-     }
-     
-     $record .= 'Participations on Forums: ' . $num_topics . '<br />';
-
+     $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);
+     
      $conditions     = array('Participation.vclassroom_id'=>$vclassroom_id, 'Participation.user_id'=>$user_id);
-     $fields         = array('Participation.title', 'Participation.points'); //null;
-     
-     $participations = $this->Participation->findAll($conditions, $fields);
-     
-     $points = (int) 0;
-
-     foreach ($participations as $pr) 
-     {
-       $record .= 'Part title: '. $pr['Participation']['title'] . ' Points '. $pr['Participation']['points'] .'<br />';
-       $points += $pr['Participation']['points']; 
-     }
-     $record .= ' Total participation points: '. $points .'<br />';
-     // die(debug($treasures));
+     $fields         = array('Participation.title', 'Participation.id', 'Participation.points'); //null;
+     
+     $record['participations'] = $this->Participation->findAll($conditions, $fields);
+
+     $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);
+     
+     //die(debug($record));
      return $record;
  }
-
- //Check if the user already exist in the classroom
+/**
+ *  Get student evaluation, return integer
+ *
+ * @param  integer $user_id  description
+ * @param  integer $vclassroom_id  description
+ * @return array   $record description
+ * @access public
+ * @author author Manuel Montoya 
+ **/
+ public function getEval($user_id, $vclassroom_id)
+ {
+   return $record;
+ }
+/**
+ *  Check if the student already exist in the classroom
+ *
+ *  @param  integer $user_id  description
+ *  @param  integer $vclassroom_id  description
+ *  @return boolean   description
+ *  @access public
+ *  @author author Manuel Montoya 
+ **/
  public function chkMember($vclassroom_id, $user_id)
  { 
@@ -188 +197 @@
  }
 
- public $validate = array(
-      'name'    => VALID_NOT_EMPTY,
-      'user_id' => VALID_NOT_EMPTY,
-      'status'  => VALID_NOT_EMPTY
-   );
-
   /**
    * Adds a join record between two records of a hasAndBelongsToMany association

trunk/app/models/webquest.php

@@ -12 +12 @@
     public $belongsTo   = 'User';
     
+   public $hasMany = array(
+                     'ResultWebquest' =>
+                   array('className'     => 'ResultWebquest',
+                 'conditions'    => null,
+                 'order'         => null,
+                 'limit'         => null,
+                 'foreignKey'    => 'webquest_id',
+                 'dependent'     => true,
+                 'exclusive'     => false,
+                             'finderQuery'   => null
+                    ));
 
     public $hasAndBelongsToMany = array('Vclassroom' =>
@@ -29 +40 @@
       'title' => VALID_NOT_EMPTY,         //'/[a-z0-9\_\-]{3,}$/i',
       'user_id' => VALID_NOT_EMPTY,
-      'introduction' => VALID_NOT_EMPTY
+      'introduction' => VALID_NOT_EMPTY,
+      'points' => VALID_NOT_EMPTY
    );
 }

trunk/app/views/vclassrooms/admin_record.ctp

@@ -2 +2 @@
 //die(debug($data));
 
-echo $html->div(null, $data);
+ echo $html->div(null, $data['user']['User']['name'] .' '. $html->link($data['user']['User']['email'], $data['user']['User']['email']));
+  
+ echo $html->div(null, $html->link('Compose message', '/admin/message/compose/'.$data['user']['User']['id']));
 
+ $record = (string) '';
+
+ if ( count($data['tests']) > 0 )
+ {
+      foreach ($data['tests'] as $t) 
+      {
+      $record .= 'Test: ' . $t['Test']['title'] . ' Percentage: ' . $t['Result']['percentage'] . '<br />';
+      }
+ }
+ else
+ {
+   $record .= $html->para(null, 'No tests found');
+ }
+
+ // Webquests
+ if ( count($data['webquests']) > 0 )
+ {
+    foreach ($data['webquests'] as $w) 
+    {
+        $record .= 'Webquests: '. $p['Webquest']['title'] . '<br />';
+    }
+ }
+ else
+ {
+    $record .= $html->para(null, 'No webquests found');
+ }
+ 
+ // treasures  
+ if ( count($data['treasures']) > 0 )
+ {
+     foreach ($data['treasures'] as $tr) 
+     {
+         $record .= 'Treasure: '. $tr['Treasure']['title'] . ' Points: ' . $tr['ResultTreasure']['points'] . '<br />';
+     }
+ }
+ else
+ {
+   $record .= $html->para(null, 'No treasures found');
+ }
+   
+ // Topics on forums
+ if ( count($data['topics']) > 0 )
+ {
+    $num_topics = (int) 0;
+
+    foreach ($data['topics'] as $p) 
+    {
+        $record .= 'Forum: '. $p['Forum']['title'] . '<br />';
+        $num_topics++;
+    }
+ }
+ else
+ {
+    $record .= $html->para(null, 'No topic found');
+ }
+    
+  echo $html->div(null, $record);  
 ?>