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 @access 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.

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

References $DIC, and 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.

                                                                : 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);
    }

References $DIC, $ilDB, $query, and $res.

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

Here is the caller graph for this function:

◆ _deleteByCategoryId()

static ilCalendarCategoryAssignments::_deleteByCategoryId ( int $a_cat_id )

static

Delete assignments by category id @access public.

Parameters

int	category_id

Returns

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

                                                             : 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);
    }

References $DIC, $ilDB, $query, and $res.

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

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.

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

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

Referenced by ilCalendarSchedule\calculate().

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.

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

References $DIC, $ilDB, $query, $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().

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.

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

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

Referenced by ilCalendarAppEventListener\deleteAppointments().

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.

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

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

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

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.

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

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

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.

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

References $query, and $res.

◆ deleteAssignment()

ilCalendarCategoryAssignments::deleteAssignment ( int $a_cat_id )

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

                                                   : 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]);
        }
    }

References ILIAS\LTI\ToolProvider\$key, $query, and $res.

◆ deleteAssignments()

ilCalendarCategoryAssignments::deleteAssignments ( )

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

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

References $query, and $res.

◆ getAssignments()

ilCalendarCategoryAssignments::getAssignments ( )

Returns: int[]

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

                                    : array
    {
        return $this->assignments;
    }

References $assignments.

◆ getFirstAssignment()

ilCalendarCategoryAssignments::getFirstAssignment ( )

get first assignment

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

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

◆ 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.

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

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

Referenced by ilCalendarCategoryGUI\doImportFile().

Here is the caller graph for this function:

◆ read()

ilCalendarCategoryAssignments::read ( )

private

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

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