ilConsultationHourGroups Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilConsultationHourGroups:

Static Public Member Functions
static	getGroupsOfUser (int $a_user_id)
	Get a all groups of an user. More...
static	getCountGroupsOfUser (int $a_user_id)
	Get number of consultation hour groups. More...
static	lookupTitle (int $a_group_id)
	Lookup group title. More...
static	lookupMaxBookings (int $a_group_id)
	Lookup max number of bookings for group. More...
static	getGroupSelectOptions (int $a_user_id)
	Get group selection options. More...

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning

Author

Stefan Meyer smeye.nosp@m.r.il.nosp@m.ias@g.nosp@m.mx.d.nosp@m.e

Definition at line 25 of file class.ilConsultationHourGroups.php.

Member Function Documentation

getCountGroupsOfUser()

static ilConsultationHourGroups::getCountGroupsOfUser ( int  $a_user_id )

static

Get number of consultation hour groups.

Definition at line 49 of file class.ilConsultationHourGroups.php.

                                                               : int
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $query = 'SELECT COUNT(grp_id) num FROM cal_ch_group ' .
            'WHERE usr_id = ' . $ilDB->quote($a_user_id, 'integer') . ' ' .
            'GROUP BY grp_id';
 
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (int) $row->num;
        }
        return 0;
    }

References $DIC, $ilDB, $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilConsultationHoursTableGUI\__construct(), and ilConsultationHoursGUI\createNewBookingEntry().

Here is the caller graph for this function:

getGroupSelectOptions()

static ilConsultationHourGroups::getGroupSelectOptions ( int  $a_user_id )

static

Get group selection options.

Definition at line 102 of file class.ilConsultationHourGroups.php.

                                                                : array
    {
        global $DIC;
 
        $lng = $DIC->language();
        $groups = self::getGroupsOfUser($a_user_id);
        if (!count($groups)) {
            return array();
        }
        $options = array();
        foreach ($groups as $group) {
            $options[(string) $group->getGroupId()] = $group->getTitle();
        }
        asort($options, SORT_STRING);
        $sorted_options = array();
        $sorted_options[0] = $lng->txt('cal_ch_grp_no_assignment');
        foreach ($options as $key => $opt) {
            $sorted_options[$key] = $opt;
        }
        return $sorted_options;
    }

References $DIC, ILIAS\LTI\ToolProvider\$key, $lng, and getGroupsOfUser().

Referenced by ilConsultationHoursGUI\initFormSequence().

Here is the call graph for this function:

Here is the caller graph for this function:

getGroupsOfUser()

static ilConsultationHourGroups::getGroupsOfUser ( int  $a_user_id )

static

Get a all groups of an user.

Returns

ilConsultationHourGroup[]

Definition at line 31 of file class.ilConsultationHourGroups.php.

                                                          : array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $query = 'SELECT grp_id FROM cal_ch_group ' .
            'WHERE usr_id = ' . $ilDB->quote($a_user_id, 'integer');
        $res = $ilDB->query($query);
        $groups = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $groups[] = new ilConsultationHourGroup((int) $row->grp_id);
        }
        return $groups;
    }

References $DIC, $ilDB, $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by getGroupSelectOptions(), ilConsultationHoursGUI\groupList(), ilPCConsultationHoursGUI\initForm(), and ilConsultationHoursGUI\saveSequence().

Here is the caller graph for this function:

lookupMaxBookings()

static ilConsultationHourGroups::lookupMaxBookings ( int  $a_group_id )

static

Lookup max number of bookings for group.

Definition at line 85 of file class.ilConsultationHourGroups.php.

                                                             : int
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        $query = 'SELECT multiple_assignments from cal_ch_group ' .
            'WHERE grp_id = ' . $ilDB->quote($a_group_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (int) $row->multiple_assignments;
        }
        return 0;
    }

References $DIC, $ilDB, $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilBookingEntry\isAppointmentBookableForUser().

Here is the caller graph for this function:

lookupTitle()

static ilConsultationHourGroups::lookupTitle ( int  $a_group_id )

static

Lookup group title.

Definition at line 68 of file class.ilConsultationHourGroups.php.

                                                       : string
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        $query = 'SELECT title from cal_ch_group ' .
            'WHERE grp_id = ' . $ilDB->quote($a_group_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->title;
        }
        return '';
    }

References $DIC, $ilDB, $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilConsultationHoursTableGUI\parse().

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• Services/Calendar/classes/ConsultationHours/class.ilConsultationHourGroups.php