Changeset 451

Timestamp:

05/04/08 00:08:10 (8 months ago)

Author:

aarkerio

Message:

Best podcast

Location:

trunk/app

Files:

• config/sql/postgresql/participations.sql (modified) (1 diff)
• models/participation.php (modified) (1 diff)
• models/vclassroom.php (modified) (4 diffs)
• views/vclassrooms/participation.ctp (modified) (1 diff)

trunk/app/config/sql/postgresql/participations.sql

@@ -1 +1 @@
 CREATE TABLE participations (  -- tests student results
    id serial NOT NULL PRIMARY KEY,
+   title varchar(80) NOT NULL,
    user_id int NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    points smallint NOT NULL DEFAULT 0,

trunk/app/models/participation.php

@@ -11 +11 @@
     
   public $belongsTo  = array(
-             "User" => array(
-                             "className"    => "User",
-                             "foreignKey"   => "user_id"
-                               ), 
-             "Forum" => array(
-                             "className"    => "Forum",  
-                             "foreignKey"   => "forum_id"
-                              )
+                             "User" => array(
+                                            "className"    => "User",
+                                            "foreignKey"   => "user_id"
+                                            )
              );
     

trunk/app/models/vclassroom.php

@@ -4 +4 @@
 *  Manuel Montoya 2002-2008 
 *  Chipotle Software TM
-*  GPLv3 manuel<at>mononeurona<punto>org
+*  GPLv3 manuel<arroba>mononeurona<punto>org
 */ 
 class Vclassroom extends AppModel
@@ -25 +25 @@
                  'offset'        => '',
                              'counterQuery'  => ''
+                 ),
+                      'Participation' =>
+               array('className'     => 'Participation',
+                 'conditions'    => null,
+                 'order'         => null,
+                 'limit'         => null,
+                 'foreignKey'    => 'vclassroom_id'
                  )
                );
@@ -110 +117 @@
      $topics      = $this->Forum->Topic->findAll($conditions, $fields);
      
-     $participations = (int) 0;
+     $num_topics = (int) 0;
      
      foreach ($topics as $p) 
      {
        $record .= 'Forum: '. $p['Forum']['title'] . '<br />';
-       $participations++;
+       $num_topics++;
      }
      
-     $record .= 'Participations on Forums: ' . $participations . '<br />';
+     $record .= 'Participations on Forums: ' . $num_topics . '<br />';
+
+     $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));
      return $record;
@@ -128 +149 @@
   
    $conditions = array('"UsersVclassroom"."vclassroom_id"'=>$vclassroom_id, '"UsersVclassroom"."user_id"'=>$user_id);
-  
+    
    $data = $this->UsersVclassroom->field('user_id', $conditions);
    

trunk/app/views/vclassrooms/participation.ctp

@@ -5 +5 @@
 echo $form->hidden('Participation.vclassroom_id', array('value'=>$vclassroom_id)); 
 echo $form->hidden('Participation.blogger_id', array('value'=>$blogger_id));
+echo $form->input('Participation.title', array('size'=>'40', 'maxlength'=>'80', 'between'=>': ')).'<br />';
 echo $form->label('Participation.participation', 'Text:').'<br />';
 echo $form->textarea('Participation.participation', array('cols'=>50, 'rows'=>15));