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 $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 $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 $ilDB;
                
                //@todo
        }
        
        public static function lookupTitle($a_group_id)
        {
                global $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 $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 $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;
        }
}
?>