class.ilConsultationHourGroups.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilConsultationHourGroups
{

    public static function getGroupsOfUser($a_user_id)
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $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)) {
            include_once './Services/Calendar/classes/ConsultationHours/class.ilConsultationHourGroup.php';
            $groups[] = new ilConsultationHourGroup($row->grp_id);
        }
        return $groups;
    }

    public static function getCountGroupsOfUser($a_user_id)
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $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);
        $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
        return (int) $row->num;
    }
    
    public static function lookupAssignedAppointments()
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        //@todo
    }
    
    public static function lookupTitle($a_group_id)
    {
        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 '';
    }

    public static function lookupMaxBookings($a_group_id)
    {
        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 $row->multiple_assignments;
        }
        return 0;
    }


    public static function getGroupSelectOptions($a_user_id)
    {
        global $DIC;

        $lng = $DIC['lng'];
        
        $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;
    }
}