class.ilECSParticipantSettingsRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilECSParticipantSettingsRepository
{
    private ilDBInterface $db;
 
    public function __construct()
    {
        global $DIC;
 
        $this->db = $DIC->database();
    }
 
    public function getExportableParticipants($a_type): 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;
    }
 
    public function getServersContaingExports(): 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;
    }
 
    // Code below is unused according to eclipse. keep around if not true, otherwise remove
    //     /**
    //      * Delete by server
    //      * @global  $ilDB
    //      * @param int $a_server_id
    //      */
    //     public static function deleteByServer($a_server_id)
    //     {
    //         global $DIC;
 
    //         $ilDB = $DIC['ilDB'];
 
    //         $query = 'DELETE from ecs_part_settings ' .
    //             'WHERE sid = ' . $this->db->quote($a_server_id, 'integer');
    //         $this->db->manipulate($query);
    //     }
}