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