class.ilAwarenessUserProviderMemberships.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2014 ILIAS open source, Extended GPL, see docs/LICENSE */
 
include_once("./Services/Awareness/classes/class.ilAwarenessUserProvider.php");
 
class ilAwarenessUserProviderMemberships extends ilAwarenessUserProvider
{
 
    public function __construct()
    {
        global $DIC;
 
        parent::__construct();
        
        $this->db = $DIC->database();
    }
 
    public function getProviderId()
    {
        return "mmbr_user_grpcrs";
    }
 
    public function getTitle()
    {
        $this->lng->loadLanguageModule("mmbr");
        return $this->lng->txt("mmbr_awrn_my_groups_courses");
    }
 
    public function getInfo()
    {
        $this->lng->loadLanguageModule("crs");
        return $this->lng->txt("mmbr_awrn_my_groups_courses_info");
    }
 
    public function getInitialUserSet()
    {
        $ilDB = $this->db;
 
        $groups_and_courses_of_user = ilParticipants::_getMembershipByType($this->getUserId(), array("grp", "crs"));
 
        $set = $ilDB->query(
            "SELECT DISTINCT usr_id FROM obj_members " .
            " WHERE " . $ilDB->in("obj_id", $groups_and_courses_of_user, false, "integer") . ' ' .
            'AND (admin > ' . $ilDB->quote(0, 'integer') . ' ' .
            'OR tutor > ' . $ilDB->quote(0, 'integer') . ' ' .
            'OR member > ' . $ilDB->quote(0, 'integer') . ")"
        );
        $ub = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $ub[] = $rec["usr_id"];
        }
 
        return $ub;
    }
}