Inheritance diagram for ilSessionAppointment:

Collaboration diagram for ilSessionAppointment:

Public Member Functions
	ilSessionAppointment ($a_appointment_id=null)
	isFullday ()
	is fullday
	getStart ()
	get start
	setStart ($a_start)
	set start
	getEnd ()
	get end
	setEnd ($a_end)
	set end
	setAppointmentId ($a_appointment_id)
	getAppointmentId ()
	setSessionId ($a_session_id)
	getSessionId ()
	setStartingTime ($a_starting_time)
	getStartingTime ()
	setEndingTime ($a_ending_time)
	getEndingTime ()
	toggleFullTime ($a_status)
	enabledFullTime ()
	formatTime ()
	_timeToString ($start, $end)
	_appointmentToString ($start, $end, $fulltime)
	appointmentToString ()
	cloneObject ($new_id)
	clone appointment
	create ()
	update ()
	delete ()
	_delete ($a_appointment_id)
	_deleteBySession ($a_event_id)
	_readAppointmentsBySession ($a_event_id)
	validate ()
	__read ()

Static Public Member Functions
static	_lookupAppointment ($a_obj_id)
	lookup appointment
static	lookupNextSessionByCourse ($a_ref_id)
	public
static	lookupLastSessionByCourse ($a_ref_id)
	public

Data Fields
	$ilErr
	$ilDB
	$tree
	$lng
	$starting_time = null
	$ending_time = null

Protected Attributes
	$start = null
	$end = null

Detailed Description

class ilSessionAppointment

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

Version: $Id$

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

Member Function Documentation

ilSessionAppointment::__read ( )

Definition at line 413 of file class.ilSessionAppointment.php.

References $ilDB, $res, DB_FETCHMODE_OBJECT, getAppointmentId(), IL_CAL_DATETIME, isFullday(), setSessionId(), and toggleFullTime().

Referenced by ilSessionAppointment().

        {
                global $ilDB;
                
                if(!$this->getAppointmentId())
                {
                        return null;
                }
                $query = "SELECT * FROM event_appointment ".
                        "WHERE appointment_id = ".$ilDB->quote($this->getAppointmentId())." ";
                $res = $this->db->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->setSessionId($row->event_id);
                        $this->toggleFullTime($row->fulltime);
                        
                        if($this->isFullday())
                        {
                                $this->start = new ilDate($row->start,IL_CAL_DATETIME);
                                $this->end = new ilDate($row->end,IL_CAL_DATETIME);
                        }
                        else
                        {
                                $this->start = new ilDateTime($row->start,IL_CAL_DATETIME,'UTC');
                                $this->end = new ilDateTime($row->end,IL_CAL_DATETIME,'UTC');
                        }
                        $this->starting_time = $this->start->getUnixTime();
                        $this->ending_time = $this->end->getUnixTime();                 
                }
                return true;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilSessionAppointment::_appointmentToString	(	$start,
		$end,
		$fulltime
	)

Definition at line 277 of file class.ilSessionAppointment.php.

References $end, $lng, $start, ilDatePresentation\formatPeriod(), and IL_CAL_UNIX.

Referenced by ilCourseContentGUI\__renderEvent(), appointmentToString(), and ilObjSessionListGUI\getProperties().

        {
                global $lng;
                if($fulltime)
                {
                        return ilDatePresentation::formatPeriod(
                                new ilDate($start,IL_CAL_UNIX),
                                new ilDate($end,IL_CAL_UNIX)).' ('.$lng->txt('event_full_time_info').')';
                }
                else
                {
                        return ilDatePresentation::formatPeriod(
                                new ilDateTime($start,IL_CAL_UNIX),
                                new ilDateTime($end,IL_CAL_UNIX));
                }
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilSessionAppointment::_delete ( $a_appointment_id )

Definition at line 364 of file class.ilSessionAppointment.php.

References $ilDB.

Referenced by delete().

        {
                global $ilDB;
                $query = "DELETE FROM event_appointment ".
                        "WHERE appointment_id = ".$ilDB->quote($a_appointment_id)." ";
                $this->db->query($query);
                return true;
        }

Here is the caller graph for this function:

ilSessionAppointment::_deleteBySession ( $a_event_id )

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

References $ilDB.

Referenced by ilObjSession\delete().

        {
                global $ilDB;
                $query = "DELETE FROM event_appointment ".
                        "WHERE event_id = ".$ilDB->quote($a_event_id)." ";
                $ilDB->query($query);
                return true;
        }

Here is the caller graph for this function:

static ilSessionAppointment::_lookupAppointment ( $a_obj_id )

static

lookup appointment

public

Parameters

int obj_id

Definition at line 66 of file class.ilSessionAppointment.php.

References $ilDB, $res, DB_FETCHMODE_OBJECT, and IL_CAL_DATETIME.

Referenced by ilCourseItems\__getItemData(), ilLPStatusEvent\_getStatusInfo(), and ilObjSessionListGUI\getAppointmentInfo().

        {
                global $ilDB;
                
                $query = "SELECT * FROM event_appointment ".
                        "WHERE event_id = ".$ilDB->quote($a_obj_id)." ";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $info['fullday'] = $row->fulltime;
                        
                        $date = new ilDateTime($row->start,IL_CAL_DATETIME,'UTC');
                        $info['start'] =  $date->getUnixTime();
                        $date = new ilDateTime($row->end,IL_CAL_DATETIME,'UTC');
                        $info['end'] = $date->getUnixTime();
                        
                        return $info;
                }
                return array();
        }

Here is the caller graph for this function:

ilSessionAppointment::_readAppointmentsBySession ( $a_event_id )

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

References $ilDB, $res, DB_FETCHMODE_OBJECT, and ilSessionAppointment().

Referenced by ilObjSession\initAppointments().

        {
                global $ilDB;
                $query = "SELECT * FROM event_appointment ".
                        "WHERE event_id = ".$ilDB->quote($a_event_id)." ".
                        "ORDER BY starting_time";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $appointments[] =& new ilSessionAppointment($row->appointment_id);
                }
                return is_array($appointments) ? $appointments : array();
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilSessionAppointment::_timeToString	(	$start,
		$end
	)

Definition at line 267 of file class.ilSessionAppointment.php.

References $end, $lng, and $start.

Referenced by formatTime().

        {
                global $ilUser,$lng;
                $start = date($this->lng->txt('lang_timeformat_no_sec'),$start);
                $end = date($this->lng->txt('lang_timeformat_no_sec'),$end);
                
                return $start.' - '. $end;
        }

Here is the caller graph for this function:

ilSessionAppointment::appointmentToString ( )

Definition at line 295 of file class.ilSessionAppointment.php.

References _appointmentToString(), enabledFullTime(), getEndingTime(), and getStartingTime().

        {
                return ilSessionAppointment::_appointmentToString($this->getStartingTime(),$this->getEndingTime(),$this->enabledFullTime());
        }

Here is the call graph for this function:

ilSessionAppointment::cloneObject ( $new_id )

clone appointment

public

Parameters

@return

Definition at line 307 of file class.ilSessionAppointment.php.

References getEndingTime(), getStartingTime(), ilSessionAppointment(), and isFullday().

        {
                $new_app = new ilSessionAppointment();
                $new_app->setSessionId($new_id);
                $new_app->setStartingTime($this->getStartingTime());
                $new_app->setEndingTime($this->getEndingTime());
                $new_app->toggleFullTime($this->isFullday());
                $new_app->create();
                return $new_app;
        }

Here is the call graph for this function:

ilSessionAppointment::create ( )

Definition at line 318 of file class.ilSessionAppointment.php.

References $ilDB, enabledFullTime(), getEnd(), getSessionId(), getStart(), and IL_CAL_DATETIME.

        {
                global $ilDB;
                
                if(!$this->getSessionId())
                {
                        return false;
                }
                $query = "INSERT INTO event_appointment ".
                        "SET event_id = ".$ilDB->quote($this->getSessionId()).", ".
                        "start = ".$ilDB->quote($this->getStart()->get(IL_CAL_DATETIME,'','UTC')).", ".
                        "end = ".$ilDB->quote($this->getEnd()->get(IL_CAL_DATETIME,'','UTC')).", ".
                        "fulltime = ".$ilDB->quote($this->enabledFullTime())." ";
                
                $this->appointment_id = $ilDB->getLastInsertId();
                $this->db->query($query);
                
                
                return true;
        }

Here is the call graph for this function:

ilSessionAppointment::delete ( )

Definition at line 359 of file class.ilSessionAppointment.php.

References _delete(), and getAppointmentId().

        {
                return ilSessionAppointment::_delete($this->getAppointmentId());
        }

Here is the call graph for this function:

ilSessionAppointment::enabledFullTime ( )

Definition at line 257 of file class.ilSessionAppointment.php.

Referenced by appointmentToString(), create(), isFullday(), and update().

        {
                return $this->fulltime;
        }

Here is the caller graph for this function:

ilSessionAppointment::formatTime ( )

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

References _timeToString(), getEndingTime(), and getStartingTime().

        {
                return ilSessionAppointment::_timeToString($this->getStartingTime(),$this->getEndingTime());
        }

Here is the call graph for this function:

ilSessionAppointment::getAppointmentId ( )

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

Referenced by __read(), delete(), and update().

        {
                return $this->appointment_id;
        }

Here is the caller graph for this function:

ilSessionAppointment::getEnd ( )

get end

public

Returns: ilDateTime

Implements ilDatePeriod.

Definition at line 197 of file class.ilSessionAppointment.php.

References IL_CAL_DATETIME.

Referenced by create(), and update().

        {
                return $this->end ? $this->end : $this->end = new ilDateTime(date('Y-m-d').' 16:00:00',IL_CAL_DATETIME);
        }

Here is the caller graph for this function:

ilSessionAppointment::getEndingTime ( )

Definition at line 248 of file class.ilSessionAppointment.php.

Referenced by appointmentToString(), cloneObject(), and formatTime().

        {
                return isset($this->ending_time) ? $this->ending_time : mktime(16,0,0,date('n',time()),date('d',time()),date('Y',time()));
        }

Here is the caller graph for this function:

ilSessionAppointment::getSessionId ( )

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

Referenced by create(), and update().

        {
                return $this->session_id;
        }

Here is the caller graph for this function:

ilSessionAppointment::getStart ( )

get start

public

Parameters

@return ilDateTime

Implements ilDatePeriod.

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

References IL_CAL_DATETIME.

Referenced by create(), and update().

        {
                return $this->start ? $this->start : $this->start = new ilDateTime(date('Y-m-d').' 08:00:00',IL_CAL_DATETIME);
        }

Here is the caller graph for this function:

ilSessionAppointment::getStartingTime ( )

Definition at line 238 of file class.ilSessionAppointment.php.

Referenced by appointmentToString(), cloneObject(), and formatTime().

        {
                return isset($this->starting_time) ? $this->starting_time : mktime(8,0,0,date('n',time()),date('d',time()),date('Y',time()));
        }

Here is the caller graph for this function:

ilSessionAppointment::ilSessionAppointment ( $a_appointment_id = null )

Definition at line 47 of file class.ilSessionAppointment.php.

References $ilDB, $ilErr, $lng, $tree, and __read().

Referenced by _readAppointmentsBySession(), and cloneObject().

        {
                global $ilErr,$ilDB,$lng,$tree;
                $this->ilErr =& $ilErr;
                $this->db  =& $ilDB;
                $this->lng =& $lng;
                $this->appointment_id = $a_appointment_id;
                $this->__read();
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilSessionAppointment::isFullday ( )

is fullday

public

Parameters

@return

Implements ilDatePeriod.

Definition at line 163 of file class.ilSessionAppointment.php.

References enabledFullTime().

Referenced by __read(), and cloneObject().

        {
                return $this->enabledFullTime();
        }

Here is the call graph for this function:

Here is the caller graph for this function:

static ilSessionAppointment::lookupLastSessionByCourse ( $a_ref_id )

static

public

Parameters

@return

Definition at line 129 of file class.ilSessionAppointment.php.

References $ilDB, $res, $tree, DB_FETCHMODE_OBJECT, and ilUtil\quoteArray().

Referenced by ilContainerSessionsContentGUI\initDetails().

        {
                global $tree,$ilDB;
                
                $sessions = $tree->getChildsByType($a_ref_id,'sess');
                $obj_ids = array();
                foreach($sessions as $tree_data)
                {
                        $obj_ids[] = $tree_data['obj_id'];
                }
                if(!count($obj_ids))
                {
                        return false;
                }
                $query = "SELECT event_id FROM event_appointment ".
                        "WHERE start < NOW() ".
                        "AND event_id IN (".implode(',',ilUtil::quoteArray($obj_ids)).") ".
                        "ORDER BY start DESC LIMIT 1";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $event_id = $row->event_id;
                }
                return isset($event_id) ? $event_id : 0;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

static ilSessionAppointment::lookupNextSessionByCourse ( $a_ref_id )

static

public

Parameters

@return

Definition at line 95 of file class.ilSessionAppointment.php.

References $ilDB, $res, $tree, DB_FETCHMODE_OBJECT, and ilUtil\quoteArray().

Referenced by ilContainerSessionsContentGUI\initDetails().

        {
                global $tree,$ilDB;
                
                $sessions = $tree->getChildsByType($a_ref_id,'sess');
                $obj_ids = array();
                foreach($sessions as $tree_data)
                {
                        $obj_ids[] = $tree_data['obj_id'];
                }
                if(!count($obj_ids))
                {
                        return false;
                }
                $query = "SELECT event_id FROM event_appointment ".
                        "WHERE start > NOW() ".
                        "AND event_id IN (".implode(',',ilUtil::quoteArray($obj_ids)).") ".
                        "ORDER BY start LIMIT 1";
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $event_id = $row->event_id;
                }
                return isset($event_id) ? $event_id : 0;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilSessionAppointment::setAppointmentId ( $a_appointment_id )

Definition at line 214 of file class.ilSessionAppointment.php.

        {
                $this->appointment_id = $a_appointment_id;
        }

ilSessionAppointment::setEnd ( $a_end )

set end

public

Parameters

object $date ilDateTime

Returns

Definition at line 209 of file class.ilSessionAppointment.php.

        {
                $this->end = $a_end;
        }

ilSessionAppointment::setEndingTime ( $a_ending_time )

Definition at line 243 of file class.ilSessionAppointment.php.

References IL_CAL_UNIX.

        {
                $this->ending_time = $a_ending_time;
                $this->end = new ilDateTime($this->ending_time,IL_CAL_UNIX);
        }

ilSessionAppointment::setSessionId ( $a_session_id )

Definition at line 223 of file class.ilSessionAppointment.php.

Referenced by __read().

        {
                $this->session_id = $a_session_id;
        }

Here is the caller graph for this function:

ilSessionAppointment::setStart ( $a_start )

set start

public

Parameters

object $data ilDateTime

Definition at line 186 of file class.ilSessionAppointment.php.

        {
                $this->start = $a_start;
        }

ilSessionAppointment::setStartingTime ( $a_starting_time )

Definition at line 232 of file class.ilSessionAppointment.php.

References IL_CAL_UNIX.

        {
                $this->starting_time = $a_starting_time;
                $this->start = new ilDateTime($this->starting_time,IL_CAL_UNIX);
                
        }

ilSessionAppointment::toggleFullTime ( $a_status )

Definition at line 253 of file class.ilSessionAppointment.php.

Referenced by __read().

        {
                $this->fulltime = $a_status;
        }

Here is the caller graph for this function:

ilSessionAppointment::update ( )

Definition at line 340 of file class.ilSessionAppointment.php.

References $ilDB, enabledFullTime(), getAppointmentId(), getEnd(), getSessionId(), getStart(), and IL_CAL_DATETIME.

        {
                global $ilDB;
                
                if(!$this->getSessionId())
                {
                        return false;
                }
                $query = "UPDATE event_appointment ".
                        "SET event_id = ".$ilDB->quote($this->getSessionId()).", ".
                        "start = ".$ilDB->quote($this->getStart()->get(IL_CAL_DATETIME,'','UTC')).", ".
                        "end = ".$ilDB->quote($this->getEnd()->get(IL_CAL_DATETIME,'','UTC')).", ".
                        "fulltime = ".$ilDB->quote($this->enabledFullTime())." ".
                        "WHERE appointment_id = ".$ilDB->quote($this->getAppointmentId())." ";
                $this->db->query($query);
                return true;
        }

Here is the call graph for this function:

ilSessionAppointment::validate ( )

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

        {
                if($this->starting_time > $this->ending_time)
                {
                        $this->ilErr->appendMessage($this->lng->txt('event_etime_smaller_stime'));
                        return false;
                }
                return true;
        }