Collaboration diagram for ilCalendarCategoryAssignments:

Public Member Functions
	__construct ($a_cal_entry_id)
	Constructor. More...

	getFirstAssignment ()
	get first assignment More...

	getAssignments ()
	get assignments More...

	addAssignment ($a_cal_cat_id)
	add assignment More...

	deleteAssignment ($a_cat_id)
	delete assignment More...

	deleteAssignments ()
	delete assignments More...

Static Public Member Functions
static	_lookupCategories ($a_cal_id)
	lookup categories More...

static	_lookupCategory ($a_cal_id)
	Lookup category id. More...

static	_getAppointmentCalendars ($a_cal_ids)
	lookup calendars for appointment ids More...

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

static	lookupNumberOfAssignedAppointments ($a_cat_ids)
	Get number of assigned appoitments. More...

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

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

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

Protected Attributes
	$db

	$cal_entry_id = 0

	$assignments = array()

Private Member Functions
	read ()
	read assignments More...

Detailed Description

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

Version: $Id$

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

Constructor & Destructor Documentation

◆ __construct()

ilCalendarCategoryAssignments::__construct ( $a_cal_entry_id )

Constructor.

@access public

Parameters

int	calendar entry id

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

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

References $ilDB, and read().

Here is the call graph for this function:

Member Function Documentation

◆ _deleteByAppointmentId()

static ilCalendarCategoryAssignments::_deleteByAppointmentId ( $a_app_id )

static

Delete appointment assignment.

@access public

Parameters

int	appointment id

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

    {
        global $ilDB;
        
        $query = "DELETE FROM cal_cat_assignments " .
            "WHERE cal_id = " . $ilDB->quote($a_app_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);
        
        return true;
    }

References $ilDB, $query, and $res.

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

Here is the caller graph for this function:

◆ _deleteByCategoryId()

static ilCalendarCategoryAssignments::_deleteByCategoryId ( $a_cat_id )

static

Delete assignments by category id.

@access public

Parameters

int	category_id

Returns

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

    {
        global $ilDB;
        
        $query = "DELETE FROM cal_cat_assignments " .
            "WHERE cat_id = " . $ilDB->quote($a_cat_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);
        return true;
    }

References $ilDB, $query, and $res.

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

Here is the caller graph for this function:

◆ _getAppointmentCalendars()

static ilCalendarCategoryAssignments::_getAppointmentCalendars ( $a_cal_ids )

static

lookup calendars for appointment ids

@access public

Parameters

array $a_cal_ids

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

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

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

Referenced by ilCalendarSchedule\calculate().

Here is the caller graph for this function:

◆ _getAssignedAppointments()

static ilCalendarCategoryAssignments::_getAssignedAppointments ( $a_cat_id )

static

Get assigned apointments.

@access public

Parameters

array $a_cat_id

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

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

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

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

Here is the caller graph for this function:

◆ _getAutoGeneratedAppointmentsByObjId()

static ilCalendarCategoryAssignments::_getAutoGeneratedAppointmentsByObjId ( $a_obj_id )

static

get automatic generated appointments of category

@access public

Parameters

int obj_id

Returns

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

    {
        global $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);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $apps[] = $row->cal_id;
        }
        return $apps ? $apps : array();
    }

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

Referenced by ilCalendarAppEventListener\deleteAppointments().

Here is the caller graph for this function:

◆ _lookupCategories()

static ilCalendarCategoryAssignments::_lookupCategories ( $a_cal_id )

static

lookup categories

@access public

Parameters

int cal_id

Returns: array of categories

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

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

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

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

Here is the caller graph for this function:

◆ _lookupCategory()

static ilCalendarCategoryAssignments::_lookupCategory ( $a_cal_id )

static

Lookup category id.

@access public

Parameters

return

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

    {
        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(), ilDownloadFilesBackgroundTask\getEventFileNameFromId(), ilCalendarAppointmentPanelGUI\getHTML(), ilCalendarAgendaListGUI\getHTML(), ilAppointmentFileHandlerFactory\getInstance(), ilAppointmentPresentationFactory\getInstance(), ilCalendarScheduleFilterBookingPool\modifyEvent(), ilCalendarScheduleFilterExercise\modifyEvent(), and ilCalendarAppointmentGUI\showInfoScreen().

Here is the caller graph for this function:

◆ addAssignment()

ilCalendarCategoryAssignments::addAssignment ( $a_cal_cat_id )

add assignment

@access public

Parameters

int	calendar category id

Returns

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

    {
        global $ilDB;
        
        $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 = $ilDB->manipulate($query);
        $this->assignments[] = (int) $a_cal_cat_id;
        
        return true;
    }

References $ilDB, $query, and $res.

◆ deleteAssignment()

ilCalendarCategoryAssignments::deleteAssignment ( $a_cat_id )

delete assignment

@access public

Parameters

int	calendar category id

Returns

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

    {
        global $ilDB;
        
        $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 = $ilDB->manipulate($query);
        
        if (($key = array_search($a_cat_id, $this->assignments)) !== false) {
            unset($this->assignments[$key]);
        }
        return true;
    }

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

◆ deleteAssignments()

ilCalendarCategoryAssignments::deleteAssignments ( )

delete assignments

@access public

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

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

References $ilDB, $query, and $res.

◆ getAssignments()

ilCalendarCategoryAssignments::getAssignments ( )

get assignments

@access public

Returns

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

    {
        return $this->assignments ? $this->assignments : array();
    }

◆ getFirstAssignment()

ilCalendarCategoryAssignments::getFirstAssignment ( )

get first assignment

@access public

Returns

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

    {
        return isset($this->assignments[0]) ? $this->assignments[0] : false;
    }

◆ lookupNumberOfAssignedAppointments()

static ilCalendarCategoryAssignments::lookupNumberOfAssignedAppointments ( $a_cat_ids )

static

Get number of assigned appoitments.

Parameters

type $a_cat_id

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

    {
        global $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 $row->num;
        }
        return 0;
    }

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

Referenced by ilCalendarCategoryGUI\doImportFile().

Here is the caller graph for this function:

◆ read()

ilCalendarCategoryAssignments::read ( )

private

read assignments

@access private

Returns

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

    {
        global $ilDB;
 
        $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[] = $row->cat_id;
        }
    }

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

Referenced by __construct().

Here is the caller graph for this function:

Field Documentation

◆ $assignments

ilCalendarCategoryAssignments::$assignments = array()

protected

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

◆ $cal_entry_id

ilCalendarCategoryAssignments::$cal_entry_id = 0

protected

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

◆ $db

ilCalendarCategoryAssignments::$db

protected

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

The documentation for this class was generated from the following file:

Services/Calendar/classes/class.ilCalendarCategoryAssignments.php

Public Member Functions

Static Public Member Functions

Protected Attributes

Private Member Functions

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ _deleteByAppointmentId()

◆ _deleteByCategoryId()

◆ _getAppointmentCalendars()

◆ _getAssignedAppointments()

◆ _getAutoGeneratedAppointmentsByObjId()

◆ _lookupCategories()

◆ _lookupCategory()

◆ addAssignment()

◆ deleteAssignment()

◆ deleteAssignments()

◆ getAssignments()

◆ getFirstAssignment()

◆ lookupNumberOfAssignedAppointments()

◆ read()

Field Documentation

◆ $assignments

◆ $cal_entry_id

◆ $db