root/trunk/app/models/test.php

<?php
/**
*  Karamelo eLearning Platform
*  Chipotle Software 2002-2008 
*  GPLv3 manuel<arroba>mononeurona<punto>org
*  @version 0.3
**/ 

class Test extends AppModel {
   
   public $belongsTo = array('User' =>
             array('className'  => 'User',
                   'conditions' => '',
                   'order'      => '',
                               'foreignKey' => 'user_id',
                               'fields'     => 'id, username'
                   )
             );
   
   public $hasMany = array(
                     'Question' =>
                   array('className'     => 'Question',
                 'conditions'    => null,
                 'order'         => 'Question.id ASC',
                 'limit'         => null,
                 'foreignKey'    => 'test_id',
                 'dependent'     => true,
                 'exclusive'     => false,
                             'finderQuery'   => null

                 ),
                   'Result' =>
             array('className'     => 'Result',
               'conditions'    => null,
               'order'         => null,
               'limit'         => null,
               'foreignKey'    => 'test_id',
               'dependent'     => true,
               'exclusive'     => false,
                           'finderQuery'   => null

               )
               );

    public $hasAndBelongsToMany = array('Vclassroom' =>
                       array('className'             => 'Vclassroom',
                         'joinTable'             => 'tests_vclassrooms',
                         'foreignKey'            => 'test_id',
                         'associationForeignKey' => 'vclassroom_id',
                         'conditions'            => null,
                         'order'                 => null,
                         'limit'                 => '',
                         'unique'                => true,
                         'finderQuery'           => '',
                         'deleteQuery'           => ''
                         )
                            );   
public $validate = array(
              'title' => array(
                          'rule'    => array('minLength', 4),
                                      'message' => 'Minimum 4 characters long'
                       ),
              'description' => array(
                             'rule'    => array('minLength', 4),
                                         'message' => 'Minimum 4 characters long'
                     ),
                      'user_id' => array(
                                 'rule'       => 'numeric',
                                         'allowEmpty' => false,
                                         'on'         => 'create', // but not on update
                                         'required'   => true 
                                )       
                );
/*
 *  getPoints  returns points from already answered test by student
 *  
 */
 public function getPoints($test_id, $user_id, $vclassroom_id)
 {
  $points = (int) 0;
  $conditions = array('Result.test_id'=>$test_id, 'Result.user_id'=>$user_id, 'Result.vclassroom_id'=>$vclassroom_id);
  $this->Result->unbindAll();  // removeds unnecesary stuff
  $answers    = $this->Result->findAll($conditions);  // get the answers gived by student

  if ( count($answers) < 1):    // test not answer yet
    return null;
  endif;

  foreach($answers as $a):
    $question = $this->Question->find(array('Question.id'=>$a['Result']['question_id']), array('worth')); //how much points question have?
    foreach($question['Answer'] as $qa):
        if ($qa['id'] == $a['Result']['answer_id'] && $qa['question_id'] == $a['Result']['question_id'] && $qa['correct'] == 1):
            $points += (int) $question['Question']['worth'];  
    endif;
     endforeach;
  endforeach;
  
  return $points;
 }
 public function linkClassroom($test_id, $user_id)
 {
    $conditions = array('Test.status'=>1, 'Test.user_id'=>$user_id, 'Test.id'=>$test_id);
    
    $vclassrooms = array();
    
    $result = $this->find($conditions);
    
    foreach ($result['Vclassroom'] as $val):
       $vclassrooms[$val['name']] = $val['id'];
    endforeach;
    
    return $vclassrooms;
 }

/*
 *  check if studen already found treasure
 *  int treasure_id 
 *  int user_id      
 *  int vclassroom_id
 *  return boolean
 */
 public function chk($test_id, $user_id, $vclassroom_id)
 {
    $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;   
    else:
          return true;
    endif;
 }

 public function getTest($user_id, $test_id, $vclassroom_id)
 {
  $conditions = array('Result.user_id'=>$user_id, 'Result.test_id'=>$test_id, 'Result.vclassroom_id'=>$vclassroom_id);
  $this->Result->bindModel(array('belongsTo'=>array('Question', 'Answer')));
  $fields     = array('Result.id', 'Result.created','Result.question_id','Test.title', 'Question.question', 'Question.worth', 'Answer.answer', 'Answer.correct');
  $data       = $this->Result->findAll($conditions, $fields);
    
  return $data;
 }

 public function chkAnswers($answers, $test_id)
 {
    $this->Test->unbindModel(array('belongsTo'=>array('User'))); //just few data
    
    $result = 0;
    
    foreach($questions as $q_id => $a_id):  // question id and answer id
         $correct_answer = $this->Test->Question->Answer->field('Answer.correct', array('Answer.id'=>$a_id));   // answer was correct?
         
           if ($correct_answer == 1):
              $worth   = $this->Test->Question->field('Question.worth', array('Question.id'=>$q_id));         // how many points
              $result += $worth;
           endif;
     endforeach;
    //exit('Result was:' . $result)e
    return $result; 
  }
}
?>