Changeset 471 for trunk/app/models

Timestamp:

05/09/08 23:13:21 (7 months ago)

Author:

aarkerio

Message:

Forums and topics improveds

Location:

trunk/app/models

Files:

• message.php (modified) (1 diff)
• user.php (modified) (2 diffs)
• vclassroom.php (modified) (1 diff)

trunk/app/models/message.php

@@ -18 +18 @@
       'sender_id' => VALID_NOT_EMPTY
       );
+  /* return 
+   *
+   */
+ public function getUsers($vclassroom_id)
+ {
+    $users = array();
 
+    $conditions    = array('UsersVclassroom.vclassroom_id'=>$vclassroom_id);
+
+    $fields        = array('UsersVclassroom.user_id');
+
+    $this->User->bindModel(
+                                    array('hasAndBelongsToMany'=>
+                         array('Vclassroom' =>
+                              array('className'    => 'Vclassroom',
+                                    'joinTable'    => 'users_vclassrooms',
+                                     'foreignKey'   => 'user_id',
+                                     'associationForeignKey'=> 'vclassroom_id'
+                                 )
+                          )
+                      )
+    );
+
+    $Usersids   = $this->User->UsersVclassroom->findAll($conditions, $fields);
+    //die(debug($Usersids));
+    foreach($Usersids as $u)
+    {
+      $conditions = array('User.id'=>$u['UsersVclassroom']['user_id']);
+      
+      $fields = array('User.email', 'User.id');     
+
+      $this->User->removeBinds();
+
+      $tmp = $this->User->find($conditions, $fields);
+      //die(debug($tmp));
+      array_push($users, $tmp['User']);        
+    }
+    
+    return $users; 
+ }
 }
 ?>

trunk/app/models/user.php

@@ -51 +51 @@
   );
   
- public $notNow = array('hasMany'=>array('Entry', 'Category', 'Acquaintance', 'Faq', 'Glossary', 'Vclassroom', 'Lesson', 'Confirm'));
+ public $notNow = array('hasMany'=>array('Entry', 'Category', 'Acquaintance', 'Faq', 'Glossary', 'Vclassroom', 'Lesson', 'Confirm', 'Vclassroom'));
 
  public $validate = array(
@@ -59 +59 @@
       'name' => VALID_NOT_EMPTY,
       'email'    => VALID_EMAIL
-   ); 
+   );
+ 
+ /*
+  * excepts : model you need
+  *
+  */
+  public function removeBinds($excepts = array())
+  {
+    foreach ($excepts as $e)
+    {
+        if ( in_array($e, $this->notNow) )
+    {
+           unset($this->notNow[$e]); // not unbind this model
+        }
+    }
+
+    $this->unbindModel($this->notNow);
+
+    return true;
+  }
 }
 ?>

trunk/app/models/vclassroom.php

@@ -155 +155 @@
   $data  = $this->UsersVclassroom->findAll(array('UsersVclassroom.vclassroom_id'=>$vclassroom_id), array('user_id'));
 
-  // die(debug($users));   
+  //die(debug($data));   
   foreach ($data as $u):
      
      $user_id = $u['UsersVclassroom']['user_id'];
-     
+
+     $conditions       = array('User.id'=>$user_id);
+     $fields           = array('User.name', 'User.email'); //null;
+     $records[$user_id] = $this->User->find($conditions, $fields);
+  
+     // Test result     
      $conditions        = array('Result.vclassroom_id'=>$vclassroom_id, 'Result.user_id'=>$user_id);
      $fields            = array('Result.percentage', 'Test.title');  //null;