Changeset 577 for trunk/app/models

Timestamp:

05/31/08 16:41:09 (6 months ago)

Author:

aarkerio

Message:

Update record

Files:

• trunk/app/models/vclassroom.php (modified) (3 diffs)

trunk/app/models/vclassroom.php

@@ -131 +131 @@
      
      // Consult Test Model
-     //$this->TestsVclassroom->bindModel(array('hasMany'=>array('Tests')));
+     $this->TestsVclassroom->bindModel(array('belongsTo'=>array('Test')));
      
      $conditions        = array('TestsVclassroom.vclassroom_id'=>$vclassroom_id);
-     $fields            = array('Result.question_id', 'Result.answer_id', 'Result.correct', 'Test.title', 'Test.id', 'Question.id', 'Question.worth'); 
-     $record['tests']   = $this->TestsVclassroom->findAll($conditions, null, null, null, null, 2);
+     $fields            = array('TestsVclassroom.test_id', 'TestsVclassroom.id', 'Test.title'); 
+     $record['tests']   = $this->TestsVclassroom->findAll($conditions, $fields);
+     //die(debug($record['tests']));
+   
      foreach($record['tests'] as $k => $t):
+       $record['tests'][$k]['TestsVclassroom']['title'] = $t['Test']['title'];
        $this->Test->Result->unbindAll();
        $this->Test->Result->bindModel(array('belongsTo'=>array('Question','Test')));
@@ -143 +146 @@
        $fields     = array('Result.correct', 'Result.answer_id','Test.title', 'Question.question', 'Question.worth');
        $results    = $this->Test->Result->findAll($conditions, $fields);
-       $points     = (int) 0;
+
+       if ( count($results) > 0 ):
+            $points     = (int) 0;
+       else:
+            $points     = null;   //student has no answered this test yet
+       endif;
+       
        foreach($results as $r):
          if ($r['Result']['correct'] == 1):
@@ -149 +158 @@
      endif;
      //die(debug($results));
-       $record['tests'][$k]['TestsVclassroom']['title'] = $r['Test']['title'];
+       
        endforeach;
     
         $record['tests'][$k]['TestsVclassroom']['points'] = $points;
+     
      endforeach;
      //die(debug($record['tests']));