Changeset 756 for trunk/app/models
- Timestamp:
- 09/04/08 19:34:27 (3 months ago)
- Files:
-
- 1 modified
-
trunk/app/models/vclassroom.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/app/models/vclassroom.php
r753 r756 256 256 $users = array(); 257 257 $records = array(); 258 259 258 $data = $this->UsersVclassroom->findAll(array('UsersVclassroom.vclassroom_id'=>$vclassroom_id), array('user_id')); 260 261 259 //die(debug($data)); 262 260 foreach ($data as $u): 263 264 261 $this->User->removeBinds(); // remove innecesaries user binds 265 262 266 $user_id = $u['UsersVclassroom']['user_id'];263 $user_id = (int) $u['UsersVclassroom']['user_id']; 267 264 268 265 $conditions = array('User.id'=>$user_id); 269 266 $fields = array('User.name', 'User.email'); //null; 270 267 $records[$user_id] = $this->User->find($conditions, $fields); 271 272 // Test result 273 $conditions = array('Result.vclassroom_id'=>$vclassroom_id, 'Result.user_id'=>$user_id); 274 $fields = array('Result.correct', 'Test.title'); //null; 275 $records[$user_id]['tests'] = $this->Test->Result->findAll($conditions, $fields); 276 //die(debug($records)); 277 268 // Consult Test Model associated to this Vclassroom 269 $this->TestsVclassroom->bindModel(array('belongsTo'=>array('Test'))); 270 $conditions = array('TestsVclassroom.vclassroom_id'=>$vclassroom_id); 271 $fields = array('TestsVclassroom.test_id', 'TestsVclassroom.id', 'Test.title'); 272 $tests = $this->TestsVclassroom->findAll($conditions, $fields); 273 274 // foreach test check in Result model 275 foreach($tests as $k => $t): 276 $records[$user_id]['tests'][$k]['Test']['points'] = $this->Test->getPoints($t['TestsVclassroom']['test_id'], $user_id, $vclassroom_id); 277 $records[$user_id]['tests'][$k]['Test']['title'] = $t['Test']['title']; 278 endforeach; 279 278 280 $conditions = array('ResultTreasure.vclassroom_id'=>$vclassroom_id, 'ResultTreasure.user_id'=>$user_id); 279 281 $fields = array('ResultTreasure.points', 'Treasure.title'); //null;
