ilConsultationHourGroups Class Reference

Description of class. More...

Collaboration diagram for ilConsultationHourGroups:

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

Detailed Description

Description of class.

Author

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

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

Member Function Documentation

getCountGroupsOfUser()

static ilConsultationHourGroups::getCountGroupsOfUser (   $a_user_id )

static

Get number of consultation hour groups @global type $ilDB.

Parameters

type

$a_user_id

Returns

int

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

    {
        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;
    }

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

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

Here is the caller graph for this function:

getGroupSelectOptions()

static ilConsultationHourGroups::getGroupSelectOptions (   $a_user_id )

static

Get group selection options.

Parameters

type

$a_user_id

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

    {
        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;
    }

References $key, $lng, $options, 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 (   $a_user_id )

static

Get a all groups of an user.

Parameters

int

$a_user_id

Returns

array

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

    {
        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;
    }

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

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

Here is the caller graph for this function:

lookupAssignedAppointments()

static ilConsultationHourGroups::lookupAssignedAppointments ( )

static

Lookup number of assigned appointments.

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

    {
        global $ilDB;
        
        //@todo
    }

References $ilDB.

lookupMaxBookings()

static ilConsultationHourGroups::lookupMaxBookings (   $a_group_id )

static

Lookup max number of bookings for group @global type $ilDB.

Parameters

type

$a_group_id

Returns

int

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

    {
        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;
    }

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

Referenced by ilBookingEntry\isAppointmentBookableForUser().

Here is the caller graph for this function:

lookupTitle()

static ilConsultationHourGroups::lookupTitle (   $a_group_id )

static

Lookup group title.

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

    {
        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 '';
    }

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

Referenced by ilConsultationHoursTableGUI\parse(), and ilPortfolioPageGUI\renderConsultationHoursTeaser().

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