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;
    }
}