Collaboration diagram for ilCalendarCategoryAssignments:

Public Member Functions
	__construct (int $a_cal_entry_id)

	getFirstAssignment ()
	get first assignment More...

	getAssignments ()

	addAssignment (int $a_cal_cat_id)

	deleteAssignment (int $a_cat_id)

	deleteAssignments ()

Static Public Member Functions
static	_lookupCategories (int $a_cal_id)

static	_lookupCategory (int $a_cal_id)

static	_getAppointmentCalendars (array $a_cal_ids)

static	_getAssignedAppointments (array $a_cat_id)
	Get assigned apointments. More...

static	lookupNumberOfAssignedAppointments (array $a_cat_ids)

static	_getAutoGeneratedAppointmentsByObjId (int $a_obj_id)
	get automatic generated appointments of category More...

static	_deleteByAppointmentId (int $a_app_id)
	Delete appointment assignment. More...

static	_deleteByCategoryId (int $a_cat_id)
	Delete assignments by category id public. More...

Protected Attributes
ilDBInterface	$db

int	$cal_entry_id = 0

array	$assignments = []

Private Member Functions
	read ()

Detailed Description

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

Definition at line 30 of file class.ilCalendarCategoryAssignments.php.

Constructor & Destructor Documentation

◆ __construct()

ilCalendarCategoryAssignments::__construct ( int $a_cal_entry_id )

Definition at line 37 of file class.ilCalendarCategoryAssignments.php.

References $DIC, and read().

     {
         global $DIC;
 
         $this->db = $DIC->database();
         $this->cal_entry_id = $a_cal_entry_id;
         $this->read();
     }

Here is the call graph for this function:

Member Function Documentation

◆ _deleteByAppointmentId()

static ilCalendarCategoryAssignments::_deleteByAppointmentId ( int $a_app_id )

static

Delete appointment assignment.

Definition at line 152 of file class.ilCalendarCategoryAssignments.php.

References $DIC, $ilDB, and $res.

Referenced by ilConsultationHourUtils\cancelBooking(), ilCalendarEntry\delete(), ilCalendarAppointmentGUI\delete(), ilCalendarAppEventListener\deleteAppointments(), ilCalendarCategoryGUI\deleteAppointments(), and ilConsultationHoursGUI\deleteAppointments().

                                                                 : void
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $query = "DELETE FROM cal_cat_assignments " .
             "WHERE cal_id = " . $ilDB->quote($a_app_id, 'integer') . " ";
         $res = $ilDB->manipulate($query);
     }

Here is the caller graph for this function:

◆ _deleteByCategoryId()

static ilCalendarCategoryAssignments::_deleteByCategoryId ( int $a_cat_id )

static

Delete assignments by category id public.

Parameters

int	category_id

Returns

Definition at line 169 of file class.ilCalendarCategoryAssignments.php.

References $DIC, $ilDB, and $res.

Referenced by ilCalendarCategory\delete(), and ilCalendarRemoteReader\importIcal().

                                                              : void
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $query = "DELETE FROM cal_cat_assignments " .
             "WHERE cat_id = " . $ilDB->quote($a_cat_id, 'integer') . " ";
         $res = $ilDB->manipulate($query);
     }

Here is the caller graph for this function:

◆ _getAppointmentCalendars()

static ilCalendarCategoryAssignments::_getAppointmentCalendars ( array $a_cal_ids )

static

Parameters

int[] $a_cal_ids

Returns: array<int, int>

Definition at line 73 of file class.ilCalendarCategoryAssignments.php.

References $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Referenced by ilCalendarSchedule\calculate().

                                                                      : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $query = "SELECT * FROM cal_cat_assignments " .
             "WHERE " . $ilDB->in('cal_id', $a_cal_ids, false, 'integer');
         $res = $ilDB->query($query);
         $map = [];
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $map[(int) $row->cal_id] = (int) $row->cat_id;
         }
         return $map;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getAssignedAppointments()

static ilCalendarCategoryAssignments::_getAssignedAppointments ( array $a_cat_id )

static

Get assigned apointments.

Parameters

int[]

Returns: int[]

Definition at line 93 of file class.ilCalendarCategoryAssignments.php.

References $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Referenced by ilCalendarExport\addCategories(), ilCalendarScheduleFilterExercise\addCustomEvents(), ilCalendarCategory\delete(), ilCalendarScheduleFilterTimings\findCalendarEntriesForItem(), ilCalendarDataSet\getDependencies(), ilCalendarSharedStatus\getOpenInvitations(), ilCalendarRemoteReader\importIcal(), and ilCalendarCategoryGUI\showAssignedAppointments().

                                                                     : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $query = "SELECT * FROM cal_cat_assignments " .
             "WHERE " . $ilDB->in('cat_id', $a_cat_id, false, 'integer');
 
         $res = $ilDB->query($query);
         $cal_ids = [];
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $cal_ids[] = (int) $row->cal_id;
         }
         return $cal_ids;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _getAutoGeneratedAppointmentsByObjId()

static ilCalendarCategoryAssignments::_getAutoGeneratedAppointmentsByObjId ( int $a_obj_id )

static

get automatic generated appointments of category

Returns: int[]

Definition at line 131 of file class.ilCalendarCategoryAssignments.php.

References $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Referenced by ilCalendarAppEventListener\deleteAppointments().

                                                                               : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $query = "SELECT ce.cal_id FROM cal_categories cc " .
             "JOIN cal_cat_assignments cca ON cc.cat_id = cca.cat_id " .
             "JOIN cal_entries ce ON cca.cal_id = ce.cal_id " .
             "WHERE auto_generated = 1 " .
             "AND obj_id = " . $ilDB->quote($a_obj_id, 'integer') . " ";
         $res = $ilDB->query($query);
         $apps = [];
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $apps[] = (int) $row->cal_id;
         }
         return $apps;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _lookupCategories()

static ilCalendarCategoryAssignments::_lookupCategories ( int $a_cal_id )

static

Definition at line 46 of file class.ilCalendarCategoryAssignments.php.

References $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Referenced by ilCalendarExport\buildAppointmentUrl(), ilConsultationHourUtils\getConsultationHourLinksForRepositoryObject(), ilCalendarVisibility\isAppointmentVisible(), and ilCalendarScheduleFilterConsultationHourInRepository\modifyEvent().

                                                            : array
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $query = "SELECT cat_id FROM cal_cat_assignments " .
             "WHERE cal_id = " . $ilDB->quote($a_cal_id, 'integer') . " ";
         $res = $ilDB->query($query);
         $cat_ids = [];
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $cat_ids[] = (int) $row->cat_id;
         }
         return $cat_ids;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _lookupCategory()

static ilCalendarCategoryAssignments::_lookupCategory ( int $a_cal_id )

static

Definition at line 61 of file class.ilCalendarCategoryAssignments.php.

Referenced by ilCalendarAppointmentGUI\edit(), ilCalendarAppointmentGUI\editResponsibleUsers(), ilAppointmentBaseFileHandler\getCatId(), ilAppointmentPresentationGUI\getCatId(), ilCalendarAppointmentBaseFactory\getClassBaseName(), ilCalendarAppointmentPanelGUI\getHTML(), ilCalendarAgendaListGUI\getHTML(), ilAppointmentFileHandlerFactory\getInstance(), ilCalendarScheduleFilterBookingPool\modifyEvent(), ilCalendarScheduleFilterExercise\modifyEvent(), ilCalendarScheduleFilterTimings\modifyEvent(), and ilCalendarAppointmentGUI\showInfoScreen().

                                                          : int
     {
         if (count($cats = self::_lookupCategories($a_cal_id))) {
             return $cats[0];
         }
         return 0;
     }

Here is the caller graph for this function:

◆ addAssignment()

ilCalendarCategoryAssignments::addAssignment ( int $a_cal_cat_id )

Definition at line 195 of file class.ilCalendarCategoryAssignments.php.

References $res.

Referenced by ilConsultationHourUtils\bookAppointment(), ilCalendarAppEventListener\createAppointments(), ilConsultationHoursGUI\createAppointments(), ilCalendarAppointmentGUI\save(), and ilICalParser\writeEvent().

                                                     : void
     {
         $query = "INSERT INTO cal_cat_assignments (cal_id,cat_id) " .
             "VALUES ( " .
             $this->db->quote($this->cal_entry_id, 'integer') . ", " .
             $this->db->quote($a_cal_cat_id, 'integer') . " " .
             ")";
         $res = $this->db->manipulate($query);
         $this->assignments[] = $a_cal_cat_id;
     }

Here is the caller graph for this function:

◆ deleteAssignment()

ilCalendarCategoryAssignments::deleteAssignment ( int $a_cat_id )

Definition at line 206 of file class.ilCalendarCategoryAssignments.php.

References $res.

                                                    : void
     {
         $query = "DELETE FROM cal_cat_assignments " .
             "WHERE cal_id = " . $this->db->quote($this->cal_entry_id, 'integer') . ", " .
             "AND cat_id = " . $this->db->quote($a_cat_id, 'integer') . " ";
         $res = $this->db->manipulate($query);
 
         if (($key = array_search($a_cat_id, $this->assignments)) !== false) {
             unset($this->assignments[$key]);
         }
     }

◆ deleteAssignments()

ilCalendarCategoryAssignments::deleteAssignments ( )

Definition at line 218 of file class.ilCalendarCategoryAssignments.php.

References $res.

Referenced by ilCalendarAppointmentGUI\update().

                                        : void
     {
         $query = "DELETE FROM cal_cat_assignments " .
             "WHERE cal_id = " . $this->db->quote($this->cal_entry_id, 'integer') . " ";
         $res = $this->db->manipulate($query);
     }

Here is the caller graph for this function:

◆ getAssignments()

ilCalendarCategoryAssignments::getAssignments ( )

Returns: int[]

Definition at line 190 of file class.ilCalendarCategoryAssignments.php.

References $assignments.

                                     : array
     {
         return $this->assignments;
     }

◆ getFirstAssignment()

ilCalendarCategoryAssignments::getFirstAssignment ( )

get first assignment

Definition at line 182 of file class.ilCalendarCategoryAssignments.php.

Referenced by ilCalendarAppointmentGUI\calendarEntryToCategory(), and ilCalendarAppointmentGUI\initForm().

                                         : ?int
     {
         return $this->assignments[0] ?? null;
     }

Here is the caller graph for this function:

◆ lookupNumberOfAssignedAppointments()

static ilCalendarCategoryAssignments::lookupNumberOfAssignedAppointments ( array $a_cat_ids )

static

Parameters

int[] $a_cat_ids

Returns: int

Definition at line 113 of file class.ilCalendarCategoryAssignments.php.

References $DIC, $ilDB, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilCalendarCategoryGUI\doImportFile().

                                                                                : int
     {
         global $DIC;
 
         $ilDB = $DIC['ilDB'];
         $query = 'SELECT COUNT(*) num FROM cal_cat_assignments ' .
             'WHERE ' . $ilDB->in('cat_id', $a_cat_ids, false, 'integer');
         $res = $ilDB->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             return (int) $row->num;
         }
         return 0;
     }

Here is the caller graph for this function:

◆ read()

ilCalendarCategoryAssignments::read ( )

private

Definition at line 225 of file class.ilCalendarCategoryAssignments.php.

References $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Referenced by __construct().

     {
         $query = "SELECT * FROM cal_cat_assignments " .
             "WHERE cal_id = " . $this->db->quote($this->cal_entry_id, 'integer') . " ";
 
         $res = $this->db->query($query);
         while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
             $this->assignments[] = (int) $row->cat_id;
         }
     }