1<?php
2/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */
3
4
5/**
6 * @author        Björn Heyser <bheyser@databay.de>
7 * @version        $Id$
8 *
9 * @package     Modules/Test
10 */
11class ilTestEvaluation
12{
13    /**
14     * @var ilDB
15     */
16    protected $db;
17
18    /**
19     * @var integer
20     */
21    protected $testId;
22
23    /**
24     * ilTestEvaluation constructor.
25     * @param ilDBInterface $db
26     * @param $testId
27     */
28    public function __construct(ilDBInterface $db, $testId)
29    {
30        $this->db = $db;
31        $this->testId = $testId;
32    }
33
34    /**
35     * @param $testId
36     * @return array
37     */
38    public function getAllActivesPasses()
39    {
40        $query = "
41			SELECT active_fi, pass
42			FROM tst_active actives
43			INNER JOIN tst_pass_result passes
44			ON active_fi = active_id
45			WHERE test_fi = %s
46		";
47
48        $res = $this->db->queryF($query, array('integer'), array($this->testId));
49
50        $passes = array();
51
52        while ($row = $this->db->fetchAssoc($res)) {
53            if (!isset($passes[$row['active_fi']])) {
54                $passes[$row['active_fi']] = array();
55            }
56
57            $passes[$row['active_fi']][] = $row['pass'];
58        }
59
60        return $passes;
61    }
62}
63