Changeset 576 for trunk/app/models

Timestamp:

05/30/08 22:31:24 (6 months ago)

Author:

aarkerio

Message:

Update record

Location:

trunk/app/models

Files:

• test.php (modified) (3 diffs)
• vclassroom.php (modified) (1 diff)

trunk/app/models/test.php

@@ -90 +90 @@
     $result = $this->find($conditions);
     
-    foreach ($result['Vclassroom'] as $val)
-    {
-      $vclassrooms[$val['name']] = $val['id'];
-    }
-
+    foreach ($result['Vclassroom'] as $val):
+       $vclassrooms[$val['name']] = $val['id'];
+    endforeach;
+    
     return $vclassrooms;
  }
@@ -109 +108 @@
     $conditions =  array("Result.user_id"=>$user_id, "Result.test_id"=>$test_id, "Result.vclassroom_id"=>$vclassroom_id);
     $data       =  $this->Result->field('Result.id', $conditions);
-   
+    
     if ($data == false ):
           return false;   
@@ -115 +114 @@
           return true;
     endif;
+ }
+
+ public function getTest($test_id, $user_id, $vclassroom_id)
+ {
+  $tests = $this->Test->Question->findAll(array('Question.test_id'=>$this->data['Test']['test_id']), $fields);
+
+    //die(debug($this->data['Test']));
+ 
+    $points  = 0; 
+
+    foreach($this->data['Test'] as $k => $t):
+      if ( is_numeric($k) ):
+    $res = $this->Test->Question->Answer->find(array('Answer.id'=>$t)); 
+     if ( $res['Answer']['correct'] == 1):
+             $points += (int) $res['Question']['worth'];        
+     endif;
+      endif;
+    endforeach;
+    
+   return $data;
  }
 

trunk/app/models/vclassroom.php

@@ -130 +130 @@
      $record   = $this->User->find(array('User.id'=>$user_id), array('id', 'username', 'name', 'email'));
      
-     // Consult Test Model 
-     $conditions        = array('Result.vclassroom_id'=>$vclassroom_id, 'Result.user_id'=>$user_id);
-     $fields            = array('Result.percentage', 'Test.title', 'Test.id');  //null;
-     $record['tests']   = $this->Test->Result->findAll($conditions, $fields);
-    
+     // Consult Test Model
+     //$this->TestsVclassroom->bindModel(array('hasMany'=>array('Tests')));
+     
+     $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);
+     foreach($record['tests'] as $k => $t):
+       $this->Test->Result->unbindAll();
+       $this->Test->Result->bindModel(array('belongsTo'=>array('Question','Test')));
+       
+       $conditions = array('Result.vclassroom_id'=>$vclassroom_id,'Result.user_id'=>$user_id,'Result.test_id'=>$t['TestsVclassroom']['test_id']);
+       $fields     = array('Result.correct', 'Result.answer_id','Test.title', 'Question.question', 'Question.worth');
+       $results    = $this->Test->Result->findAll($conditions, $fields);
+       $points     = (int) 0;
+       foreach($results as $r):
+         if ($r['Result']['correct'] == 1):
+               $points     += $r['Question']['worth'];     
+     endif;
+     //die(debug($results));
+       $record['tests'][$k]['TestsVclassroom']['title'] = $r['Test']['title'];
+       endforeach;
+    
+        $record['tests'][$k]['TestsVclassroom']['points'] = $points;
+     endforeach;
+     //die(debug($record['tests']));
      // Consult Treasure Model
      $conditions = array('ResultTreasure.vclassroom_id'=>$vclassroom_id, 'ResultTreasure.user_id'=>$user_id);