ilCalendarCategories Class Reference

class for calendar categories More...

Collaboration diagram for ilCalendarCategories:

Public Member Functions
	setCHUserId ($a_user_id)
	Set ch user id. More...
	getCHUserId ()
	Get ch user id. More...
	getMode ()
	getTargetRefId ()
	initialize ($a_mode, $a_source_ref_id=0, $a_use_cache=false)
	initialize visible categories More...
	getCategoryInfo ($a_cat_id)
	@access public More...
	getCategoriesInfo ()
	get categories More...
	getCategories ($a_include_subitem_calendars=false)
	get categories More...
	getSubitemCategories ($a_cat_id)
	get subitem categories for a specific category More...
	prepareCategoriesOfUserForSelection ()
	prepare categories of users for selection More...
	getNotificationCalendars ()
	Get all calendars that allow send of notifications (Editable and course group calendars) More...
	isEditable ($a_cat_id)
	check if category is editable More...
	isVisible ($a_cat_id)
	check if category is visible More...
	readConsultationHoursCalendar ($a_target_ref_id=NULL)
	Read personal consultation hours calendar. More...
	readBookingCalendar ($user_id=NULL)
	Read booking manager calendar. More...

Static Public Member Functions
static	_getInstance ($a_usr_id=0)
	get singleton instance More...
static	_lookupCategoryIdByObjId ($a_obj_id)
	lookup category by obj_id More...
static	_isOwner ($a_usr_id, $a_cal_id)
	check if user is owner of a category More...
static	deletePDItemsCache ($a_usr_id)
	Delete cache (add remove desktop item) More...
static	deleteRepositoryCache ($a_usr_id)
	Delete cache. More...
static	lookupPrivateCategories ($a_user_id)
	Lookup private categories of user. More...

Data Fields
const	MODE_REPOSITORY = 2
const	MODE_REMOTE_ACCESS = 3
const	MODE_PERSONAL_DESKTOP_MEMBERSHIP = 4
const	MODE_PERSONAL_DESKTOP_ITEMS = 5
const	MODE_MANAGE = 6
const	MODE_CONSULTATION = 7
const	MODE_PORTFOLIO_CONSULTATION = 8
const	MODE_REMOTE_SELECTED = 9

Protected Member Functions
	__construct ($a_usr_id=0)
	Singleton instance. More...
	sleep ()
	Serialize categories. More...
	wakeup ($a_ser)
	Load from serialize string. More...
	setMode ($a_mode)
	setTargetRefId ($a_ref_id)
	readPDCalendars ()
	Read categories of user. More...
	readSelectedCalendar ($a_cal_id)
	Read info about selected calendar. More...
	readSelectedItemCalendars ()
	Read categories of selected items. More...
	readReposCalendars ()
	Read available repository calendars. More...
	readPublicCalendars ()
	Read public calendars. More...
	readPrivateCalendars ()
	Read private calendars. More...
	readSelectedCategories ($a_obj_ids)
	read selected categories More...
	addSubitemCalendars ()
	Add subitem calendars E.g. More...

Protected Attributes
	$db
	$user_id
	$mode = 0
	$categories = array()
	$categories_info = array()
	$subitem_categories = array()
	$root_ref_id = 0
	$root_obj_id = 0
	$ch_user_id = 0
	$target_ref_id = 0
	$logger = null
	ilLogger More...

Static Protected Attributes
static	$instance = null

Detailed Description

class for calendar categories

Author

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

Version

$Id$

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

Constructor & Destructor Documentation

__construct()

ilCalendarCategories::__construct (   $a_usr_id = 0 )

protected

Singleton instance.

@access protected

Parameters

int

$a_usr_id

user id

Returns

Definition at line 79 of file class.ilCalendarCategories.php.

        {
                global $ilUser,$ilDB;
                
                $this->logger = $GLOBALS['DIC']->logger()->cal();
                
                $this->user_id = $a_usr_id;
                if(!$this->user_id)
                {
                        $this->user_id = $ilUser->getId();
                }
                $this->db = $ilDB;
        }

References $GLOBALS, $ilDB, and $ilUser.

Member Function Documentation

_getInstance()

static ilCalendarCategories::_getInstance (   $a_usr_id = 0 )

static

get singleton instance

@access public

Parameters

int

$a_usr_id

user id

Returns

ilCalendarCategories

Definition at line 101 of file class.ilCalendarCategories.php.

        {
                if(self::$instance)
                {
                        return self::$instance;
                }
                return self::$instance = new ilCalendarCategories($a_usr_id);
        }

References $instance.

Referenced by ilCalendarChangedAppointmentsTableGUI\__construct(), ilCalendarAppointmentsTableGUI\__construct(), ilCalendarAppointmentColors\__construct(), ilCalendarScheduleFilterBookings\__construct(), ilCalendarPresentationGUI\__construct(), ilCalendarSchedule\__construct(), ilCalendarAppointmentGUI\distributeNotifications(), ilCalendarAppointmentGUI\edit(), ilCalendarAppointmentGUI\editResponsibleUsers(), ilCalendarScheduleFilterHidden\filterCategories(), ilCalendarSelectionBlockGUI\getCalendars(), ilCalendarSchedule\getChangedEvents(), ilCalendarSchedule\getEvents(), ilCalendarAppointmentPanelGUI\getHTML(), ilCalendarRemoteAccessHandler\handleRequest(), ilCalendarBlockGUI\initCategories(), ilPDCalendarBlockGUI\initCategories(), ilCalendarAppointmentGUI\initForm(), ilCalendarCategoryGUI\initFormCategory(), ilCalendarCategoryTableGUI\parse(), ilCalendarManageTableGUI\parse(), ilPortfolioPageGUI\renderConsultationHours(), ilCalendarAppointmentGUI\save(), ilCalendarCategoryGUI\saveSelection(), ilCalendarMonthGUI\show(), ilCalendarCategoryGUI\showAssignedAppointments(), ilCalendarAppointmentGUI\showInfoScreen(), and ilCalendarPresentationGUI\synchroniseExternalCalendars().

Here is the caller graph for this function:

_isOwner()

static ilCalendarCategories::_isOwner (   $a_usr_id,   $a_cal_id  )

static

check if user is owner of a category

@access public

Parameters

int	usr_id
int	cal_id

Returns

bool

Definition at line 144 of file class.ilCalendarCategories.php.

        {
                global $ilDB;
                
                $query = "SELECT * FROM cal_categories ".
                        "WHERE cat_id = ".$ilDB->quote($a_cal_id ,'integer')." ".
                        "AND obj_id = ".$ilDB->quote($a_usr_id ,'integer')." ".
                        "AND type = ".$ilDB->quote(ilCalendarCategory::TYPE_USR ,'integer')." ";
                $res = $ilDB->query($query);
                return $res->numRows() ? true : false;
        }

References $ilDB, $query, $res, and ilCalendarCategory\TYPE_USR.

Referenced by ilCalendarShared\getSharedCalendarsForUser().

Here is the caller graph for this function:

_lookupCategoryIdByObjId()

static ilCalendarCategories::_lookupCategoryIdByObjId (   $a_obj_id )

static

lookup category by obj_id

@access public

Parameters

int

obj_id

Returns

int cat_id

Definition at line 118 of file class.ilCalendarCategories.php.

        {
                global $ilDB;
 
                $query = "SELECT cat_id FROM cal_categories  ".
                        "WHERE obj_id = ".$ilDB->quote($a_obj_id ,'integer')." ".
                        "AND type = ".$ilDB->quote(ilCalendarCategory::TYPE_OBJ,'integer')." ";
                        
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        return $row->cat_id;
                }
                return 0;
        }

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

Referenced by ilCalendarAppEventListener\createAppointments(), ilCalendarAppEventListener\deleteCategory(), and ilCalendarAppointmentGUI\initForm().

Here is the caller graph for this function:

addSubitemCalendars()

ilCalendarCategories::addSubitemCalendars ( )

protected

Add subitem calendars E.g.

session calendars in courses, groups

Parameters

return

Definition at line 932 of file class.ilCalendarCategories.php.

        {
                global $ilDB;
                
                $course_ids = array();
                foreach($this->categories as $cat_id)
                {
                        if($this->categories_info[$cat_id]['obj_type'] == 'crs' or $this->categories_info[$cat_id]['obj_type'] == 'grp')
                        {
                                $course_ids[] = $this->categories_info[$cat_id]['obj_id'];
                        }
                }
                
                $query = "SELECT od2.obj_id sess_id, od1.obj_id crs_id,cat_id FROM object_data od1 ".
                        "JOIN object_reference or1 ON od1.obj_id = or1.obj_id ".
                        "JOIN tree t ON or1.ref_id = t.parent ".
                        "JOIN object_reference or2 ON t.child = or2.ref_id ".
                        "JOIN object_data od2 ON or2.obj_id = od2.obj_id ".
                        "JOIN cal_categories cc ON od2.obj_id = cc.obj_id ".
                        "WHERE ".$ilDB->in('od2.type',array('sess','exc'),false,'text').
                        "AND (od1.type = 'crs' OR od1.type = 'grp') ".
                        "AND ".$ilDB->in('od1.obj_id',$course_ids,false,'integer').' '.
                        "AND or2.deleted IS NULL";
                
                $res = $ilDB->query($query);
                $cat_ids = array();
                $course_sessions = array();
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $cat_ids[] = $row->cat_id;
                        $course_sessions[$row->crs_id][$row->sess_id] = $row->cat_id;
                        $this->subitem_categories[] = $row->cat_id;
                }
                
                foreach($this->categories as $cat_id)
                {
                        if(
                                ($this->categories_info[$cat_id]['obj_type'] == 'crs' ||
                                $this->categories_info[$cat_id]['obj_type'] == 'grp' ) &&
                                isset($this->categories_info[$cat_id]['obj_id']) &&
                                isset($course_sessions[$this->categories_info[$cat_id]['obj_id']]) &&
                                is_array($course_sessions[$this->categories_info[$cat_id]['obj_id']]))
                        {
                                foreach($course_sessions[$this->categories_info[$cat_id]['obj_id']] as $sess_id => $sess_cat_id)
                                {
                                        $this->categories_info[$cat_id]['subitem_ids'][$sess_id] = $sess_cat_id;
                                        $this->categories_info[$cat_id]['subitem_obj_ids'][$sess_cat_id] = $sess_id;
                                }
                        }
                        else
                        {
                                $this->categories_info[$cat_id]['subitem_ids'] = array();
                                $this->categories_info[$cat_id]['subitem_obj_ids'] = array();
                        }
                }
        }

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

Referenced by readPDCalendars(), readSelectedCalendar(), and readSelectedItemCalendars().

Here is the caller graph for this function:

deletePDItemsCache()

static ilCalendarCategories::deletePDItemsCache (   $a_usr_id )

static

Delete cache (add remove desktop item)

Parameters

object

$a_usr_id

Returns

Definition at line 161 of file class.ilCalendarCategories.php.

        {
                ilCalendarCache::getInstance()->deleteByAdditionalKeys(
                        $a_usr_id,
                        self::MODE_PERSONAL_DESKTOP_ITEMS,
                        'categories'
                );
        }

References ilCalendarCache\getInstance().

Referenced by ilObjUser\_addDesktopItem(), ilObjUser\_dropDesktopItem(), and ilCalendarAppEventListener\handleEvent().

Here is the call graph for this function:

Here is the caller graph for this function:

deleteRepositoryCache()

static ilCalendarCategories::deleteRepositoryCache (   $a_usr_id )

static

Delete cache.

Parameters

object

$a_usr_id

Returns

Definition at line 175 of file class.ilCalendarCategories.php.

        {
                ilCalendarCache::getInstance()->deleteByAdditionalKeys(
                        $a_usr_id,
                        self::MODE_REPOSITORY,
                        'categories'
                );
                
        }

References ilCalendarCache\getInstance().

Referenced by ilCalendarAppEventListener\handleEvent().

Here is the call graph for this function:

Here is the caller graph for this function:

getCategories()

ilCalendarCategories::getCategories

(

$a_include_subitem_calendars = false

)

get categories

Parameters

$a_include_subitems

include subitem calendars @access public

Returns

Definition at line 386 of file class.ilCalendarCategories.php.

        {
                if($a_include_subitem_calendars)
                {
                        return array_merge((array) $this->categories, (array) $this->subitem_categories);
                }
                
                return $this->categories ? $this->categories : array();
        }

getCategoriesInfo()

ilCalendarCategories::getCategoriesInfo

(

)

get categories

@access public

Parameters

return

Definition at line 375 of file class.ilCalendarCategories.php.

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

getCategoryInfo()

ilCalendarCategories::getCategoryInfo

(

$a_cat_id

)

@access public

Parameters

return

Definition at line 348 of file class.ilCalendarCategories.php.

        {
                if(isset($this->categories_info[$a_cat_id]))
                {
                        return $this->categories_info[$a_cat_id];
                }
                
                if(in_array($a_cat_id,(array) $this->subitem_categories))
                {
                        foreach($this->categories as $cat_id)
                        {
                                if(in_array($a_cat_id,$this->categories_info[$cat_id]['subitem_ids']))
                                {
                                        return $this->categories_info[$cat_id];
                                }
                        }
                }
        }

getCHUserId()

ilCalendarCategories::getCHUserId

(

)

Get ch user id.

Returns

type

Definition at line 229 of file class.ilCalendarCategories.php.

        {
                return $this->ch_user_id;
        }

References $ch_user_id.

Referenced by readConsultationHoursCalendar().

Here is the caller graph for this function:

getMode()

ilCalendarCategories::getMode

(

)

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

        {
                return $this->mode;
        }

References $mode.

Referenced by initialize().

Here is the caller graph for this function:

getNotificationCalendars()

ilCalendarCategories::getNotificationCalendars

(

)

Get all calendars that allow send of notifications (Editable and course group calendars)

Returns

Definition at line 453 of file class.ilCalendarCategories.php.

        {
                $not = array();
                foreach($this->categories_info as $info)
                {
                        if($info['type'] == ilCalendarCategory::TYPE_OBJ and $info['editable'] == true)
                        {
                                if(ilObject::_lookupType($info['obj_id']) == 'crs' or ilObject::_lookupType($info['obj_id']) == 'grp')
                                {
                                        $not[] = $info['cat_id'];
                                }
                        }
                }
                return $not;            
        }

References $info, ilObject\_lookupType(), and ilCalendarCategory\TYPE_OBJ.

Here is the call graph for this function:

getSubitemCategories()

ilCalendarCategories::getSubitemCategories

(

$a_cat_id

)

get subitem categories for a specific category

Parameters

int

$a_category_id

Id of category in question

Returns

array Array of category ids

Definition at line 402 of file class.ilCalendarCategories.php.

        {
                if(!isset($this->categories_info[$a_cat_id]['subitem_ids']))
                {
                        return array($a_cat_id);
                }
                return array_merge((array) $this->categories_info[$a_cat_id]['subitem_ids'],array($a_cat_id));
        }

getTargetRefId()

ilCalendarCategories::getTargetRefId

(

)

Definition at line 249 of file class.ilCalendarCategories.php.

        {
                return $this->target_ref_id;
        }

References $target_ref_id.

initialize()

ilCalendarCategories::initialize	(		$a_mode,
			$a_source_ref_id = 0,
			$a_use_cache = false
	)

initialize visible categories

@access public

Parameters

int	mode
int	ref_id of root node

Returns

Definition at line 262 of file class.ilCalendarCategories.php.

        {
                $this->setMode($a_mode);
                if($a_use_cache)
                {
                        // Read categories from cache
                        if($cats = ilCalendarCache::getInstance()->getEntry($this->user_id.':'.$a_mode.':categories:'.(int) $a_source_ref_id))
                        {
                                if($this->getMode() != self::MODE_CONSULTATION &&
                                        $this->getMode() != self::MODE_PORTFOLIO_CONSULTATION)
                                {
                                        $this->wakeup($cats);
                                        return;
                                }
                        }
                }
                
                
                switch($this->getMode())
                {
                        case self::MODE_REMOTE_ACCESS:
                                include_once('./Services/Calendar/classes/class.ilCalendarUserSettings.php');
                                if(ilCalendarUserSettings::_getInstance()->getCalendarSelectionType() == ilCalendarUserSettings::CAL_SELECTION_MEMBERSHIP)
                                {
                                        $this->readPDCalendars();
                                }
                                else
                                {
                                        $this->readSelectedItemCalendars();                     
                                }
                                break;
                                
                        case self::MODE_REMOTE_SELECTED:
                                $this->readSelectedCalendar($a_source_ref_id);
                                break;
                                
                        case self::MODE_PERSONAL_DESKTOP_MEMBERSHIP:
                                $this->readPDCalendars();
                                break;
                                
                        case self::MODE_PERSONAL_DESKTOP_ITEMS:
                                $this->readSelectedItemCalendars();
                                break;
                                
                        case self::MODE_REPOSITORY:
                                $this->root_ref_id = $a_source_ref_id;
                                $this->root_obj_id = ilObject::_lookupObjId($this->root_ref_id);
                                $this->readReposCalendars();
                                break;
 
                        case self::MODE_MANAGE:
                                $this->readPDCalendars();
                                $this->readSelectedItemCalendars();
                                break;
 
                        case self::MODE_CONSULTATION:
                                #$this->readPrivateCalendars();
                                $this->setTargetRefId($a_source_ref_id);
                                $this->readConsultationHoursCalendar($a_source_ref_id);
                                break;
                        
                        case self::MODE_PORTFOLIO_CONSULTATION:
                                $this->readConsultationHoursCalendar();
                                break;
                }
                
                if($a_use_cache)
                {
                        // Store in cache
                        ilCalendarCache::getInstance()->storeEntry(
                                $this->user_id.':'.$a_mode.':categories:'.(int) $a_source_ref_id,
                                $this->sleep(),
                                $this->user_id,
                                $a_mode,
                                'categories'
                        );
                }
        }

References ilCalendarUserSettings\_getInstance(), ilObject\_lookupObjId(), ilCalendarUserSettings\CAL_SELECTION_MEMBERSHIP, ilCalendarCache\getInstance(), getMode(), MODE_CONSULTATION, MODE_MANAGE, MODE_PERSONAL_DESKTOP_ITEMS, MODE_PERSONAL_DESKTOP_MEMBERSHIP, MODE_PORTFOLIO_CONSULTATION, MODE_REMOTE_ACCESS, MODE_REMOTE_SELECTED, MODE_REPOSITORY, readConsultationHoursCalendar(), readPDCalendars(), readReposCalendars(), readSelectedCalendar(), readSelectedItemCalendars(), setMode(), setTargetRefId(), and wakeup().

Here is the call graph for this function:

isEditable()

ilCalendarCategories::isEditable

(

$a_cat_id

)

check if category is editable

@access public

Parameters

int

$a_cat_id

category id

Returns

Definition at line 476 of file class.ilCalendarCategories.php.

        {
                return isset($this->categories_info[$a_cat_id]['editable']) and $this->categories_info[$a_cat_id]['editable'];
        }

isVisible()

ilCalendarCategories::isVisible

(

$a_cat_id

)

check if category is visible

@access public

Parameters

int

$a_cat_id

category id

Returns

Definition at line 488 of file class.ilCalendarCategories.php.

        {
                return in_array($a_cat_id,$this->categories) or 
                        in_array($a_cat_id,(array) $this->subitem_categories);
        }

lookupPrivateCategories()

static ilCalendarCategories::lookupPrivateCategories (   $a_user_id )

static

Lookup private categories of user.

Parameters

return

Definition at line 995 of file class.ilCalendarCategories.php.

        {
                global $ilDB;
                
                // First read private calendars of user
                $set = $ilDB->query("SELECT * FROM cal_categories ".
                        "WHERE type = ".$ilDB->quote(ilCalendarCategory::TYPE_USR ,'integer')." ".
                        "AND obj_id = ".$ilDB->quote($a_user_id,'integer'));
                $cats = array();
                while ($rec = $ilDB->fetchAssoc($set))
                {
                        $cats[] = $rec;
                }
                return $cats;
        }

References $ilDB, and ilCalendarCategory\TYPE_USR.

Referenced by ilUserExporter\getXmlExportTailDependencies().

Here is the caller graph for this function:

prepareCategoriesOfUserForSelection()

ilCalendarCategories::prepareCategoriesOfUserForSelection

(

)

prepare categories of users for selection

@access public

Parameters

int

user id

Returns

Definition at line 419 of file class.ilCalendarCategories.php.

        {
                global $lng;
                
                $has_personal_calendar = false;
                foreach($this->categories_info as $info)
                {
                        if($info['obj_type'] == 'sess' || $info['obj_type'] == 'exc')
                        {
                                continue;
                        }
                        if($info['type'] == ilCalendarCategory::TYPE_USR and $info['editable'])
                        {
                                $has_personal_calendar = true;
                        }
 
                        if($info['editable'])
                        {
                                $cats[$info['cat_id']] = $info['title'];
                        }
                }
                // If there 
                if(!$has_personal_calendar)
                {
                        $cats[0] = $lng->txt('cal_default_calendar'); 
                }
                return $cats ? $cats : array();
        }

References $info, $lng, and ilCalendarCategory\TYPE_USR.

readBookingCalendar()

ilCalendarCategories::readBookingCalendar

(

$user_id = NULL

)

Read booking manager calendar.

Parameters

int

$user_id

Returns

Definition at line 831 of file class.ilCalendarCategories.php.

        {
                global $ilDB;
 
                if(!$user_id)
                {
                        $user_id = $this->user_id;
                }
 
                $query = "SELECT *  FROM cal_categories ".
                        "WHERE type = ".$ilDB->quote(ilCalendarCategory::TYPE_BOOK,'integer').' '.
                        "AND obj_id = ".$ilDB->quote($user_id,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $this->categories[] = $row->cat_id;
                        $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
                        $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
                        $this->categories_info[$row->cat_id]['title'] = $row->title;
                        $this->categories_info[$row->cat_id]['color'] = $row->color;
                        $this->categories_info[$row->cat_id]['type'] = $row->type;
                        $this->categories_info[$row->cat_id]['editable'] = false;
                        $this->categories_info[$row->cat_id]['accepted'] = false;
                        $this->categories_info[$row->cat_id]['remote'] = false;
                }
        }

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

Referenced by readPDCalendars(), and readSelectedItemCalendars().

Here is the caller graph for this function:

readConsultationHoursCalendar()

ilCalendarCategories::readConsultationHoursCalendar

(

$a_target_ref_id = NULL

)

Read personal consultation hours calendar.

Parameters

int

$user_id

Returns

Definition at line 756 of file class.ilCalendarCategories.php.

        {
                global $ilDB;
                
                if(!$this->getCHUserId())
                {
                        $this->setCHUserId($this->user_id);
                }
                
                if($a_target_ref_id)
                {
                        $target_obj_id = ilObject::_lookupObjId($a_target_ref_id);
                        
                        $query = 'SELECT DISTINCT(cc.cat_id) FROM booking_entry be '.
                                        'LEFT JOIN booking_obj_assignment bo ON be.booking_id = bo.booking_id '.
                                        'JOIN cal_entries ce ON be.booking_id = ce.context_id '.
                                        'JOIN cal_cat_assignments ca ON ce.cal_id = ca.cal_id '.
                                        'JOIN cal_categories cc ON ca.cat_id = cc.cat_id '.
                                        'WHERE ((bo.target_obj_id IS NULL) OR bo.target_obj_id = '.$ilDB->quote($target_obj_id,'integer').' ) '.
                                        'AND cc.obj_id = '.$ilDB->quote($this->getCHUserId(),'integer');
                        
 
                        $res = $ilDB->query($query);
                        $categories = array();
                        while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                        {
                                $categories[] = $row->cat_id;
                        }
 
                        if($categories)
                        {
                                $query = 'SELECT * FROM cal_categories '.
                                                'WHERE '.$ilDB->in('cat_id',$categories,false,'integer');
                                $res = $ilDB->query($query);
                                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                                {
                                        $this->categories[] = $row->cat_id;
                                        $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
                                        $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
                                        $this->categories_info[$row->cat_id]['title'] = $row->title;
                                        $this->categories_info[$row->cat_id]['color'] = $row->color;
                                        $this->categories_info[$row->cat_id]['type'] = $row->type;
                                        $this->categories_info[$row->cat_id]['editable'] = false;
                                        $this->categories_info[$row->cat_id]['accepted'] = false;
                                        $this->categories_info[$row->cat_id]['remote'] = false;
                                }
                        }
                }
                else // no category given
                {
                        $query = "SELECT *  FROM cal_categories cc ".
                        "WHERE type = ".$ilDB->quote(ilCalendarCategory::TYPE_CH,'integer').' '.
                        "AND obj_id = ".$ilDB->quote($this->getCHUserId(),'integer');
                        $res = $ilDB->query($query);
                        while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                        {
                                $this->categories[] = $row->cat_id;
                                $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
                                $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
                                $this->categories_info[$row->cat_id]['title'] = $row->title;
                                $this->categories_info[$row->cat_id]['color'] = $row->color;
                                $this->categories_info[$row->cat_id]['type'] = $row->type;
                                $this->categories_info[$row->cat_id]['editable'] = false;
                                $this->categories_info[$row->cat_id]['accepted'] = false;
                                $this->categories_info[$row->cat_id]['remote'] = false;
                        }
                }
                return true;
        }

References $categories, $ilDB, $query, $res, $row, ilObject\_lookupObjId(), ilDBConstants\FETCHMODE_OBJECT, getCHUserId(), setCHUserId(), and ilCalendarCategory\TYPE_CH.

Referenced by initialize(), readPDCalendars(), readReposCalendars(), and readSelectedItemCalendars().

Here is the call graph for this function:

Here is the caller graph for this function:

readPDCalendars()

ilCalendarCategories::readPDCalendars ( )

protected

Read categories of user.

@access protected

Parameters

return void

Definition at line 504 of file class.ilCalendarCategories.php.

        {
                global $rbacsystem;
                
                
                $this->readPublicCalendars();
                $this->readPrivateCalendars();
                $this->readConsultationHoursCalendar();
                $this->readBookingCalendar();
                
                include_once('./Services/Membership/classes/class.ilParticipants.php');
                $this->readSelectedCategories(ilParticipants::_getMembershipByType($this->user_id,'crs'));
                $this->readSelectedCategories(ilParticipants::_getMembershipByType($this->user_id,'grp'));
                
                $this->addSubitemCalendars();
        }

References ilParticipants\_getMembershipByType(), addSubitemCalendars(), readBookingCalendar(), readConsultationHoursCalendar(), readPrivateCalendars(), readPublicCalendars(), and readSelectedCategories().

Referenced by initialize().

Here is the call graph for this function:

Here is the caller graph for this function:

readPrivateCalendars()

ilCalendarCategories::readPrivateCalendars ( )

protected

Read private calendars.

@access protected

Returns

Definition at line 688 of file class.ilCalendarCategories.php.

        {
                global $ilUser;
                global $ilDB;
 
                // First read private calendars of user
                $query = "SELECT cat_id FROM cal_categories ".
                        "WHERE type = ".$this->db->quote(ilCalendarCategory::TYPE_USR ,'integer')." ".
                        "AND obj_id = ".$this->db->quote($ilUser->getId(),'integer')." ";
                $res = $this->db->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $cat_ids[] = $row->cat_id;
                }
                
                // Read shared calendars
                include_once('./Services/Calendar/classes/class.ilCalendarSharedStatus.php');
                $accepted_ids = ilCalendarSharedStatus::getAcceptedCalendars($ilUser->getId());
                if(!$cat_ids = array_merge((array) $cat_ids, $accepted_ids))
                {
                        return true;
                }
                
                
                // user categories
                $query = "SELECT * FROM cal_categories ".
                        "WHERE type = ".$this->db->quote(ilCalendarCategory::TYPE_USR ,'integer')." ".
                        "AND ".$ilDB->in('cat_id',$cat_ids,false,'integer')." ".
                        "ORDER BY title ";
                        
                $res = $this->db->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $this->categories[] = $row->cat_id;
                        $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
                        $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
                        $this->categories_info[$row->cat_id]['title'] = $row->title;
                        $this->categories_info[$row->cat_id]['color'] = $row->color;
                        $this->categories_info[$row->cat_id]['type'] = $row->type;
                        
                        include_once './Services/Calendar/classes/class.ilCalendarShared.php';
                        if(in_array($row->cat_id, $accepted_ids))
                        {
                                $shared = new ilCalendarShared($row->cat_id);
                                if($shared->isEditableForUser($ilUser->getId()))
                                {
                                        $this->categories_info[$row->cat_id]['editable'] = true;
                                }
                                else
                                {
                                        $this->categories_info[$row->cat_id]['editable'] = false;
                                }
                        }
                        else
                        {
                                $this->categories_info[$row->cat_id]['editable'] = true;
                        }
                        
                        $this->categories_info[$row->cat_id]['accepted'] = in_array($row->cat_id, $accepted_ids);
                        $this->categories_info[$row->cat_id]['remote'] = ($row->loc_type == ilCalendarCategory::LTYPE_REMOTE);
                }
        }

References $ilDB, $ilUser, $query, $res, $row, ilDBConstants\FETCHMODE_OBJECT, ilCalendarSharedStatus\getAcceptedCalendars(), ilCalendarCategory\LTYPE_REMOTE, and ilCalendarCategory\TYPE_USR.

Referenced by readPDCalendars(), readReposCalendars(), and readSelectedItemCalendars().

Here is the call graph for this function:

Here is the caller graph for this function:

readPublicCalendars()

ilCalendarCategories::readPublicCalendars ( )

protected

Read public calendars.

@access protected

Returns

Definition at line 656 of file class.ilCalendarCategories.php.

        {
                global $rbacsystem,$ilAccess;
                
                // global categories
                $query = "SELECT * FROM cal_categories ".
                        "WHERE type = ".$this->db->quote(ilCalendarCategory::TYPE_GLOBAL ,'integer')." ".
                        "ORDER BY title ";
 
                $res = $this->db->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        $this->categories[] = $row->cat_id;
                        $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
                        $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
                        $this->categories_info[$row->cat_id]['title'] = $row->title;
                        $this->categories_info[$row->cat_id]['color'] = $row->color;
                        $this->categories_info[$row->cat_id]['type'] = $row->type;
                        $this->categories_info[$row->cat_id]['editable'] = $rbacsystem->checkAccess('edit_event',ilCalendarSettings::_getInstance()->getCalendarSettingsId());
                        $this->categories_info[$row->cat_id]['accepted'] = false;
                        $this->categories_info[$row->cat_id]['remote'] = ($row->loc_type == ilCalendarCategory::LTYPE_REMOTE);
                }
                
                return true;
        }

References $query, $res, $row, ilCalendarSettings\_getInstance(), ilDBConstants\FETCHMODE_OBJECT, ilCalendarCategory\LTYPE_REMOTE, and ilCalendarCategory\TYPE_GLOBAL.

Referenced by readPDCalendars(), readReposCalendars(), and readSelectedItemCalendars().

Here is the call graph for this function:

Here is the caller graph for this function:

readReposCalendars()

ilCalendarCategories::readReposCalendars ( )

protected

Read available repository calendars.

@access protected

Parameters

return

Definition at line 601 of file class.ilCalendarCategories.php.

        {
                global $ilAccess,$tree;
                global $ilDB;
                
                $this->readPublicCalendars();
                $this->readPrivateCalendars();
                $this->readConsultationHoursCalendar();
 
                #$query = "SELECT ref_id,obd.obj_id obj_id FROM tree t1 ".
                #       "JOIN object_reference obr ON t1.child = obr.ref_id ".
                #       "JOIN object_data obd ON obd.obj_id = obr.obj_id ".
                #       "WHERE t1.lft >= (SELECT lft FROM tree WHERE child = ".$this->db->quote($this->root_ref_id,'integer')." ) ".
                #       "AND t1.lft <= (SELECT rgt FROM tree WHERE child = ".$this->db->quote($this->root_ref_id,'integer')." ) ".
                #       "AND ".$ilDB->in('type',array('crs','grp','sess'),false,'text')." ".
                #       "AND tree = 1";
                
                $subtree_query = $GLOBALS['tree']->getSubTreeQuery(
                                $this->root_ref_id,
                                array('object_reference.ref_id','object_data.obj_id'),
                                array('crs','grp','sess','exc')
                );
                
                $res = $ilDB->query($subtree_query);
                $obj_ids = array();
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        if($tree->isDeleted($row->ref_id))
                        {
                                continue;
                        }
                        
                        $obj_type = ilObject::_lookupType($row->obj_id);
                        if($obj_type == 'crs' or $obj_type == 'grp')
                        {
                                // Check for global/local activation
                                if(!ilCalendarSettings::_getInstance()->lookupCalendarActivated($row->obj_id))
                                {
                                        continue;
                                }
                        }
                        if($ilAccess->checkAccess('read','',$row->ref_id))
                        {
                                $obj_ids[] = $row->obj_id;
                        }
                }
                $this->readSelectedCategories($obj_ids);
        }

References $GLOBALS, $ilDB, $res, $row, ilCalendarSettings\_getInstance(), ilObject\_lookupType(), ilDBConstants\FETCHMODE_OBJECT, readConsultationHoursCalendar(), readPrivateCalendars(), readPublicCalendars(), and readSelectedCategories().

Referenced by initialize().

Here is the call graph for this function:

Here is the caller graph for this function:

readSelectedCalendar()

ilCalendarCategories::readSelectedCalendar (   $a_cal_id )

protected

Read info about selected calendar.

Parameters

type

$a_cal_id

Definition at line 525 of file class.ilCalendarCategories.php.

        {
                include_once './Services/Calendar/classes/class.ilCalendarCategory.php';
                $cat = new ilCalendarCategory($a_cal_id);
                if($cat->getType() == ilCalendarCategory::TYPE_OBJ)
                {
                        $this->readSelectedCategories(array($cat->getObjId()));
                        $this->addSubitemCalendars();
                }
                else
                {
                        $this->categories[] = $a_cal_id;
                }
        }

References addSubitemCalendars(), readSelectedCategories(), and ilCalendarCategory\TYPE_OBJ.

Referenced by initialize().

Here is the call graph for this function:

Here is the caller graph for this function:

readSelectedCategories()

ilCalendarCategories::readSelectedCategories (   $a_obj_ids )

protected

read selected categories

@access protected

Returns

Definition at line 864 of file class.ilCalendarCategories.php.

        {
                global $ilAccess,$tree;
                global $ilDB;
                
                if(!count($a_obj_ids))
                {
                        return true;
                }
                
                $query = "SELECT * FROM cal_categories ".
                        "WHERE type = ".$this->db->quote(ilCalendarCategory::TYPE_OBJ ,'integer')." ".
                        "AND ".$ilDB->in('obj_id',$a_obj_ids,false,'integer')." ".
                        "ORDER BY title ";
                
                $res = $this->db->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        // check activation/deactivation
                        $obj_type = ilObject::_lookupType($row->obj_id);
                        if($obj_type == 'crs' or $obj_type == 'grp')
                        {
                                if(!ilCalendarSettings::_getInstance()->lookupCalendarActivated($row->obj_id))
                                {
                                        continue;
                                }
                        }
                
                        $editable = false;
                        $exists = false;
                        foreach(ilObject::_getAllReferences($row->obj_id) as $ref_id)
                        {
                                if($ilAccess->checkAccess('edit_event','',$ref_id))
                                {
                                        $exists = true;
                                        $editable = true;
                                        break;
                                }
                                elseif($ilAccess->checkAccess('read','',$ref_id))
                                {
                                        $exists = true;
                                }
                        }
                        if(!$exists)
                        {
                                continue;
                        }
                        $this->categories_info[$row->cat_id]['editable'] = $editable;
                        
                        $this->categories[] = $row->cat_id;
                        $this->categories_info[$row->cat_id]['obj_id'] = $row->obj_id;
                        $this->categories_info[$row->cat_id]['cat_id'] = $row->cat_id;
                        $this->categories_info[$row->cat_id]['color'] = $row->color;
                        #$this->categories_info[$row->cat_id]['title'] = ilObject::_lookupTitle($row->obj_id);
                        $this->categories_info[$row->cat_id]['title'] = $row->title;
                        $this->categories_info[$row->cat_id]['obj_type'] = ilObject::_lookupType($row->obj_id);
                        $this->categories_info[$row->cat_id]['type'] = $row->type;
                        $this->categories_info[$row->cat_id]['remote'] = false;
                        
                }
        }

References $ilDB, $query, $ref_id, $res, $row, ilObject\_getAllReferences(), ilCalendarSettings\_getInstance(), ilObject\_lookupType(), ilDBConstants\FETCHMODE_OBJECT, and ilCalendarCategory\TYPE_OBJ.

Referenced by readPDCalendars(), readReposCalendars(), readSelectedCalendar(), and readSelectedItemCalendars().

Here is the call graph for this function:

Here is the caller graph for this function:

readSelectedItemCalendars()

ilCalendarCategories::readSelectedItemCalendars ( )

protected

Read categories of selected items.

Parameters

return

Definition at line 546 of file class.ilCalendarCategories.php.

         {
                global $ilUser,$ilAccess;
                
                $this->readPublicCalendars();
                $this->readPrivateCalendars();
                $this->readConsultationHoursCalendar();
                $this->readBookingCalendar();
 
                $obj_ids = array();
                
                $courses = array();
                $groups = array();
                $sessions = array();
                $exercises = array();
                foreach(ilObjUser::_lookupDesktopItems($ilUser->getId(),array('crs','grp','sess','exc')) as $item)
                {
                        if($ilAccess->checkAccess('read','',$item['ref_id']))
                        {
                                switch($item['type'])
                                {
                                        case 'crs':
                                                $courses[] = $item['obj_id'];
                                                break;
                                                
                                        case 'sess':
                                                $sessions[] = $item['obj_id'];
                                                break;
 
                                        case 'grp':
                                                $groups[] = $item['obj_id'];
                                                break;
                                        
                                        case 'exc':
                                                $exercises[] = $item['obj_id'];
                                                break;                                          
                                }
                        }
                }
                $this->readSelectedCategories($courses);        
                $this->readSelectedCategories($sessions);               
                $this->readSelectedCategories($groups);
                $this->readSelectedCategories($exercises);              
 
                $this->addSubitemCalendars();
                
         }

References $ilUser, ilObjUser\_lookupDesktopItems(), addSubitemCalendars(), readBookingCalendar(), readConsultationHoursCalendar(), readPrivateCalendars(), readPublicCalendars(), and readSelectedCategories().

Referenced by initialize().

Here is the call graph for this function:

Here is the caller graph for this function:

setCHUserId()

ilCalendarCategories::setCHUserId

(

$a_user_id

)

Set ch user id.

Parameters

int

$a_user_id

Definition at line 219 of file class.ilCalendarCategories.php.

        {
                $this->ch_user_id = $a_user_id;
        }

Referenced by readConsultationHoursCalendar().

Here is the caller graph for this function:

setMode()

ilCalendarCategories::setMode (   $a_mode )

protected

Definition at line 234 of file class.ilCalendarCategories.php.

        {
                $this->mode = $a_mode;
        }

Referenced by initialize().

Here is the caller graph for this function:

setTargetRefId()

ilCalendarCategories::setTargetRefId (   $a_ref_id )

protected

Definition at line 244 of file class.ilCalendarCategories.php.

        {
                $this->target_ref_id = $a_ref_id;
        }

Referenced by initialize().

Here is the caller graph for this function:

sleep()

ilCalendarCategories::sleep ( )

protected

Serialize categories.

Returns

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

        {
                return serialize(
                        array(
                                'categories'            => $this->categories,
                                'categories_info'       => $this->categories_info,
                                'subitem_categories'=> $this->subitem_categories
                        )
                );
        }

wakeup()

ilCalendarCategories::wakeup (   $a_ser )

protected

Load from serialize string.

Parameters

string

serialize categories

Returns

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

        {
                $info = unserialize($a_ser);
                
                $this->categories = $info['categories'];
                $this->categories_info = $info['categories_info'];
                $this->subitem_categories = $info['subitem_categories'];
        }

References $info.

Referenced by initialize().

Here is the caller graph for this function:

Field Documentation

$categories

ilCalendarCategories::$categories = array()

protected

Definition at line 56 of file class.ilCalendarCategories.php.

Referenced by readConsultationHoursCalendar().

$categories_info

ilCalendarCategories::$categories_info = array()

protected

Definition at line 57 of file class.ilCalendarCategories.php.

$ch_user_id

ilCalendarCategories::$ch_user_id = 0

protected

Definition at line 64 of file class.ilCalendarCategories.php.

Referenced by getCHUserId().

$db

ilCalendarCategories::$db

protected

Definition at line 50 of file class.ilCalendarCategories.php.

$instance

ilCalendarCategories::$instance = null

staticprotected

Definition at line 48 of file class.ilCalendarCategories.php.

Referenced by _getInstance().

$logger

ilCalendarCategories::$logger = null

protected

ilLogger

Definition at line 70 of file class.ilCalendarCategories.php.

$mode

ilCalendarCategories::$mode = 0

protected

Definition at line 54 of file class.ilCalendarCategories.php.

Referenced by getMode().

$root_obj_id

ilCalendarCategories::$root_obj_id = 0

protected

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

$root_ref_id

ilCalendarCategories::$root_ref_id = 0

protected

Definition at line 60 of file class.ilCalendarCategories.php.

$subitem_categories

ilCalendarCategories::$subitem_categories = array()

protected

Definition at line 58 of file class.ilCalendarCategories.php.

$target_ref_id

ilCalendarCategories::$target_ref_id = 0

protected

Definition at line 65 of file class.ilCalendarCategories.php.

Referenced by getTargetRefId().

$user_id

ilCalendarCategories::$user_id

protected

Definition at line 52 of file class.ilCalendarCategories.php.

Referenced by readBookingCalendar().

MODE_CONSULTATION

const ilCalendarCategories::MODE_CONSULTATION = 7

Definition at line 44 of file class.ilCalendarCategories.php.

Referenced by ilCalendarSchedule\__construct(), ilCalendarBlockGUI\initCategories(), and initialize().

MODE_MANAGE

const ilCalendarCategories::MODE_MANAGE = 6

Definition at line 43 of file class.ilCalendarCategories.php.

Referenced by initialize(), and ilCalendarManageTableGUI\parse().

MODE_PERSONAL_DESKTOP_ITEMS

const ilCalendarCategories::MODE_PERSONAL_DESKTOP_ITEMS = 5

Definition at line 42 of file class.ilCalendarCategories.php.

Referenced by ilCalendarPresentationGUI\__construct(), ilCalendarBlockGUI\getHTML(), ilPDCalendarBlockGUI\initCategories(), initialize(), and ilCalendarBlockGUI\showCalendarSubscription().

MODE_PERSONAL_DESKTOP_MEMBERSHIP

const ilCalendarCategories::MODE_PERSONAL_DESKTOP_MEMBERSHIP = 4

Definition at line 41 of file class.ilCalendarCategories.php.

Referenced by ilCalendarPresentationGUI\__construct(), ilCalendarBlockGUI\getHTML(), ilPDCalendarBlockGUI\initCategories(), initialize(), and ilCalendarBlockGUI\showCalendarSubscription().

MODE_PORTFOLIO_CONSULTATION

const ilCalendarCategories::MODE_PORTFOLIO_CONSULTATION = 8

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

Referenced by ilCalendarSchedule\__construct(), ilCalendarAppointmentPanelGUI\getHTML(), initialize(), ilCalendarScheduleFilterBookings\modifyEvent(), ilPortfolioPageGUI\renderConsultationHours(), and ilCalendarMonthGUI\show().

MODE_REMOTE_ACCESS

const ilCalendarCategories::MODE_REMOTE_ACCESS = 3

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

Referenced by ilCalendarRemoteAccessHandler\handleRequest(), and initialize().

MODE_REMOTE_SELECTED

const ilCalendarCategories::MODE_REMOTE_SELECTED = 9

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

Referenced by ilCalendarRemoteAccessHandler\handleRequest(), and initialize().

MODE_REPOSITORY

const ilCalendarCategories::MODE_REPOSITORY = 2

Definition at line 39 of file class.ilCalendarCategories.php.

Referenced by ilCalendarBlockGUI\getHTML(), ilCalendarBlockGUI\initCategories(), and initialize().

---

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

• Services/Calendar/classes/class.ilCalendarCategories.php