ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
Static Public Member Functions
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 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 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 type $ilDB.

Parameters
type$a_user_id
Returns
int

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

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

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

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  }
DB_FETCHMODE_OBJECT
const DB_FETCHMODE_OBJECT
Definition: class.ilDB.php:11
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
+ 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.

References $lng, and $options.

Referenced by ilConsultationHoursGUI\initFormSequence().

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  }
$options
if(!is_array($argv)) $options
Definition: tcpdf_addfont.php:137
$lng
global $lng
Definition: privfeed.php:40
+ 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.

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

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

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  }
DB_FETCHMODE_OBJECT
const DB_FETCHMODE_OBJECT
Definition: class.ilDB.php:11
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
+ 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.

References $ilDB.

57  {
58  global $ilDB;
59 
60  //@todo
61  }
$ilDB
global $ilDB
Definition: storeScorm2004.php:16

◆ lookupMaxBookings()

static ilConsultationHourGroups::lookupMaxBookings (   $a_group_id)
static

Lookup max number of bookings for group type $ilDB.

Parameters
type$a_group_id
Returns
int

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

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

Referenced by ilBookingEntry\isAppointmentBookableForUser().

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  }
DB_FETCHMODE_OBJECT
const DB_FETCHMODE_OBJECT
Definition: class.ilDB.php:11
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
+ 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.

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

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

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  }
DB_FETCHMODE_OBJECT
const DB_FETCHMODE_OBJECT
Definition: class.ilDB.php:11
$ilDB
global $ilDB
Definition: storeScorm2004.php:16
+ Here is the caller graph for this function:
The documentation for this class was generated from the following file: