Collaboration diagram for ilECSParticipantSettingsRepository:

Public Member Functions
	__construct ()

	getExportableParticipants ($a_type)
	Get participants which are enabled and export is allowed. More...

	getServersContaingExports ()
	Get server ids which allow an export. More...

Private Attributes
ilDBInterface	$db

Detailed Description

Author: Per Pascal Seeland pasca.nosp@m.l.se.nosp@m.eland.nosp@m.@tik.nosp@m..uni-.nosp@m.stut.nosp@m.tgart.nosp@m..de

Definition at line 23 of file class.ilECSParticipantSettingsRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilECSParticipantSettingsRepository::__construct ( )

Definition at line 27 of file class.ilECSParticipantSettingsRepository.php.

    {
        global $DIC;
 
        $this->db = $DIC->database();
    }

References $DIC.

Member Function Documentation

◆ getExportableParticipants()

ilECSParticipantSettingsRepository::getExportableParticipants ( $a_type )

Get participants which are enabled and export is allowed.

Definition at line 37 of file class.ilECSParticipantSettingsRepository.php.

                                                      : array
    {
        $query = 'SELECT sid,mid,export_types FROM ecs_part_settings ep ' .
            'JOIN ecs_server es ON ep.sid = es.server_id ' .
            'WHERE export = ' . $this->db->quote(1, 'integer') . ' ' .
            'AND active = ' . $this->db->quote(1, 'integer') . ' ' .
            'ORDER BY cname,es.title';
 
        $res = $this->db->query($query);
        $mids = array();
        $counter = 0;
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            if (in_array($a_type, (array) unserialize($row->export_types, ['allowed_classes' => true]), true)) {
                $mids[$counter]['sid'] = (int) $row->sid;
                $mids[$counter]['mid'] = (int) $row->mid;
                $counter++;
            }
        }
        return $mids;
    }

References $query, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getServersContaingExports()

ilECSParticipantSettingsRepository::getServersContaingExports ( )

Get server ids which allow an export.

Definition at line 61 of file class.ilECSParticipantSettingsRepository.php.

                                               : array
    {
        $query = 'SELECT DISTINCT(sid) FROM ecs_part_settings  ep ' .
            'JOIN ecs_server es ON ep.sid = es.server_id ' .
            'WHERE export = ' . $this->db->quote(1, 'integer') . ' ' .
            'AND active = ' . $this->db->quote(1, 'integer') . ' ';
        $res = $this->db->query($query);
        $sids = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $sids[] = (int) $row->sid;
        }
        return $sids;
    }