ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
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 40 of file class.ilConsultationHourGroups.php.

41 {
42 global $ilDB;
43
44 $query = 'SELECT COUNT(grp_id) num FROM cal_ch_group '.
45 'WHERE usr_id = '.$ilDB->quote($a_user_id,'integer').' '.
46 'GROUP BY grp_id';
47
48 $res = $ilDB->query($query);
49 $row = $res->fetchRow(DB_FETCHMODE_OBJECT);
50 return (int) $row->num;
51 }
const DB_FETCHMODE_OBJECT
Definition: class.ilDB.php:11
global $ilDB

References $ilDB, $query, $res, $row, and DB_FETCHMODE_OBJECT.

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

+ 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 105 of file class.ilConsultationHourGroups.php.

106 {
107 global $lng;
108
109 $groups = self::getGroupsOfUser($a_user_id);
110 if(!count($groups))
111 {
112 return array();
113 }
114 $options = array();
115 foreach($groups as $group)
116 {
117 $options[(string) $group->getGroupId()] = $group->getTitle();
118 }
119 asort($options,SORT_STRING);
120 $sorted_options = array();
121 $sorted_options[0] = $lng->txt('cal_ch_grp_no_assignment');
122 foreach($options as $key => $opt)
123 {
124 $sorted_options[$key] = $opt;
125 }
126 return $sorted_options;
127 }
static getGroupsOfUser($a_user_id)
Get a all groups of an user.
global $lng
Definition: privfeed.php:40
if(!is_array($argv)) $options

References $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.

19 {
20 global $ilDB;
21
22 $query = 'SELECT grp_id FROM cal_ch_group '.
23 'WHERE usr_id = '.$ilDB->quote($a_user_id,'integer');
24 $res = $ilDB->query($query);
25 $groups = array();
26 while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
27 {
28 include_once './Services/Calendar/classes/ConsultationHours/class.ilConsultationHourGroup.php';
29 $groups[] = new ilConsultationHourGroup($row->grp_id);
30 }
31 return $groups;
32 }

References $ilDB, $query, $res, $row, and DB_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 56 of file class.ilConsultationHourGroups.php.

57 {
58 global $ilDB;
59
60 //@todo
61 }

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 86 of file class.ilConsultationHourGroups.php.

87 {
88 global $ilDB;
89
90 $query = 'SELECT multiple_assignments from cal_ch_group '.
91 'WHERE grp_id = '.$ilDB->quote($a_group_id,'integer');
92 $res = $ilDB->query($query);
93 while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
94 {
95 return $row->multiple_assignments;
96 }
97 return 0;
98 }

References $ilDB, $query, $res, $row, and DB_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 66 of file class.ilConsultationHourGroups.php.

67 {
68 global $ilDB;
69
70 $query = 'SELECT title from cal_ch_group '.
71 'WHERE grp_id = '.$ilDB->quote($a_group_id,'integer');
72 $res = $ilDB->query($query);
73 while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
74 {
75 return $row->title;
76 }
77 return '';
78 }

References $ilDB, $query, $res, $row, and DB_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: