class.ilTestEvaluation.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilTestEvaluation
{
    protected $db;

    protected $testId;

    public function __construct(ilDBInterface $db, $testId)
    {
        $this->db = $db;
        $this->testId = $testId;
    }

    public function getAllActivesPasses(): array
    {
        $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;
    }
}