class.ilTestEvaluation.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */
 
 
class ilTestEvaluation
{
        protected $db;
 
        protected $testId;
 
        public function __construct(ilDBInterface $db, $testId)
        {
                $this->db = $db;
                $this->testId = $testId;
        }
 
        public function getAllActivesPasses()
        {
                $query = "
                        SELECT active_fi, pass
                        FROM tst_active actives
                        INNER JOIN tst_pass_result passes
                        ON active_fi = active_id
                        WHERE test_fi = %s
                ";
                
                $res = $this->db->queryF($query, array('integer'), array($this->testId));
                
                $passes = array();
                
                while($row = $this->db->fetchAssoc($res))
                {
                        if( !isset($passes[$row['active_fi']]) )
                        {
                                $passes[$row['active_fi']] = array();
                        }
 
                        $passes[$row['active_fi']][] = $row['pass'];
                }
                
                return $passes;
        }
}