class.ilTestParticipantData.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */
 
 
class ilTestParticipantData
{
    protected $db;
 
    protected $lng;
 
    private $activeIdsFilter;
 
    private $userIdsFilter;
 
    private $anonymousIdsFilter;
 
    private $byActiveId;
 
    private $byUserId;
 
    private $byAnonymousId;
    
    protected $participantAccessFilter;
    
    protected $scoredParticipantsFilterEnabled;
    
    public function __construct(ilDBInterface $db, ilLanguage $lng)
    {
        $this->db = $db;
        $this->lng = $lng;
 
        $this->activeIdsFilter = array();
        $this->userIdsFilter = array();
        $this->anonymousIdsFilter = array();
 
        $this->byActiveId = array();
        $this->byUserId = array();
        $this->byAnonymousId = array();
        
        $this->scoredParticipantsFilterEnabled = false;
    }
    
    public function getParticipantAccessFilter()
    {
        return $this->participantAccessFilter;
    }
    
    public function setParticipantAccessFilter($participantAccessFilter)
    {
        $this->participantAccessFilter = $participantAccessFilter;
    }
    
    public function isScoredParticipantsFilterEnabled()
    {
        return $this->scoredParticipantsFilterEnabled;
    }
    
    public function setScoredParticipantsFilterEnabled($scoredParticipantsFilterEnabled)
    {
        $this->scoredParticipantsFilterEnabled = $scoredParticipantsFilterEnabled;
    }
    
    public function load($testId)
    {
        $this->byActiveId = array();
        $this->byUserId = array();
 
        $query = "
                        SELECT          ta.active_id,
                                                ta.user_fi user_id,
                                                ta.anonymous_id,
                                                ud.firstname,
                                                ud.lastname,
                                                ud.login,
                                                ud.matriculation
                        FROM            tst_active ta
                        LEFT JOIN       usr_data ud
                        ON                      ud.usr_id = ta.user_fi
                        WHERE           test_fi = %s
                        AND                     {$this->getConditionalExpression()}
                        AND             {$this->getScoredParticipantsFilterExpression()}
                ";
        
        $res = $this->db->queryF($query, array('integer'), array($testId));
        
        $rows = array();
        $accessFilteredUsrIds = array();
        
        while ($row = $this->db->fetchAssoc($res)) {
            $accessFilteredUsrIds[] = $row['user_id'];
            $rows[] = $row;
        }
        
        if (is_callable($this->getParticipantAccessFilter(), true)) {
            $accessFilteredUsrIds = call_user_func_array($this->getParticipantAccessFilter(), [$accessFilteredUsrIds]);
        }
        
        foreach ($rows as $row) {
            if (!in_array($row['user_id'], $accessFilteredUsrIds)) {
                continue;
            }
            
            $this->byActiveId[ $row['active_id'] ] = $row;
            
            if ($row['user_id'] == ANONYMOUS_USER_ID) {
                $this->byAnonymousId[ $row['anonymous_id'] ] = $row;
            } else {
                $this->byUserId[ $row['user_id'] ] = $row;
            }
        }
    }
    
    public function getScoredParticipantsFilterExpression()
    {
        if ($this->isScoredParticipantsFilterEnabled()) {
            return "ta.last_finished_pass = ta.last_started_pass";
        }
        
        return '1 = 1';
    }
    
    public function getConditionalExpression()
    {
        $conditions = array();
        
        if (count($this->getActiveIdsFilter())) {
            $conditions[] = $this->db->in('active_id', $this->getActiveIdsFilter(), false, 'integer');
        }
 
        if (count($this->getUserIdsFilter())) {
            $conditions[] = $this->db->in('user_fi', $this->getUserIdsFilter(), false, 'integer');
        }
 
        if (count($this->getAnonymousIdsFilter())) {
            $conditions[] = $this->db->in('anonymous_id', $this->getAnonymousIdsFilter(), false, 'integer');
        }
 
        if (count($conditions)) {
            return '(' . implode(' OR ', $conditions) . ')';
        }
 
        return '1 = 1';
    }
 
    public function setActiveIdsFilter($activeIdsFilter)
    {
        $this->activeIdsFilter = $activeIdsFilter;
    }
    
    public function getActiveIdsFilter()
    {
        return $this->activeIdsFilter;
    }
    
    public function setUserIdsFilter($userIdsFilter)
    {
        $this->userIdsFilter = $userIdsFilter;
    }
    
    public function getUserIdsFilter()
    {
        return $this->userIdsFilter;
    }
    
    public function setAnonymousIdsFilter($anonymousIdsFilter)
    {
        $this->anonymousIdsFilter = $anonymousIdsFilter;
    }
    
    public function getAnonymousIdsFilter()
    {
        return $this->anonymousIdsFilter;
    }
 
    public function getActiveIds()
    {
        return array_keys($this->byActiveId);
    }
 
    public function getUserIds()
    {
        return array_keys($this->byUserId);
    }
 
    public function getAnonymousIds()
    {
        return array_keys($this->byAnonymousId);
    }
    
    public function getUserIdByActiveId($activeId)
    {
        return $this->byActiveId[$activeId]['user_id'];
    }
 
    public function getActiveIdByUserId($userId)
    {
        return $this->byUserId[$userId]['active_id'];
    }
    
    public function getConcatedFullnameByActiveId($activeId)
    {
        return "{$this->byActiveId[$activeId]['firstname']} {$this->byActiveId[$activeId]['lastname']}";
    }
 
    public function getFormatedFullnameByActiveId($activeId)
    {
        return $this->buildFormatedFullname($this->byActiveId[$activeId]);
    }
 
    public function getFileSystemCompliantFullnameByActiveId($activeId)
    {
        $fullname = str_replace(' ', '', $this->byActiveId[$activeId]['lastname']);
        $fullname .= '_' . str_replace(' ', '', $this->byActiveId[$activeId]['firstname']);
        $fullname .= '_' . $this->byActiveId[$activeId]['login'];
        
        return ilUtil::getASCIIFilename($fullname);
    }
    
    public function getOptionArray()
    {
        $options = array();
        
        foreach ($this->byActiveId as $activeId => $usrData) {
            $options[$activeId] = $this->buildFormatedFullname($usrData);
        }
        
        asort($options);
        
        return $options;
    }
    
    private function buildFormatedFullname($usrData)
    {
        return sprintf(
            $this->lng->txt('tst_participant_fullname_pattern'),
            $usrData['firstname'],
            $usrData['lastname']
        );
    }
    
    public function getAnonymousActiveIds()
    {
        $anonymousActiveIds = array();
        
        foreach ($this->byActiveId as $activeId => $active) {
            if ($active['user_id'] == ANONYMOUS_USER_ID) {
                $anonymousActiveIds[] = $activeId;
            }
        }
        
        return $anonymousActiveIds;
    }
    
    public function getUserDataByActiveId($activeId)
    {
        if (isset($this->byActiveId[$activeId])) {
            return $this->byActiveId[$activeId];
        }
        
        return null;
    }
}