TableGUI class for timings administration. More...

Collaboration diagram for ilTimingUser:

Public Member Functions
	__construct (int $a_ref_id, int $a_usr_id)

	getUserId ()

	getRefId ()

	isScheduled ()

	getStart ()
	Use to set start date. More...

	getEnd ()
	Use to set date. More...

	create ()

	update ()

	delete ()

	read ()

Protected Attributes
ilDBInterface	$db

Private Attributes
int	$ref_id = 0

int	$usr_id = 0

ilDateTime	$start

ilDateTime	$end

bool	$is_scheduled = false

Detailed Description

TableGUI class for timings administration.

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

Version: $Id$ \

Definition at line 26 of file class.ilTimingUser.php.

Constructor & Destructor Documentation

◆ __construct()

ilTimingUser::__construct	(	int	$a_ref_id,
		int	$a_usr_id
	)

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

    {
        global $DIC;
 
        $this->db = $DIC->database();
 
        $this->ref_id = $a_ref_id;
        $this->usr_id = $a_usr_id;
 
        $this->start = new ilDateTime(0, IL_CAL_UNIX);
        $this->end = new ilDateTime(0, IL_CAL_UNIX);
        $this->read();
    }

References $DIC, IL_CAL_UNIX, and read().

Here is the call graph for this function:

Member Function Documentation

◆ create()

ilTimingUser::create ( )

Definition at line 82 of file class.ilTimingUser.php.

                            : void
    {
        if ($this->isScheduled()) {
            $this->update();
            return;
        }
 
        $query = 'INSERT INTO crs_timings_user (ref_id, usr_id, sstart, ssend ) VALUES ( ' .
            $this->db->quote($this->getRefId(), 'integer') . ', ' .
            $this->db->quote($this->getUserId(), 'integer') . ', ' .
            $this->db->quote($this->getStart()->get(IL_CAL_UNIX), 'integer') . ', ' .
            $this->db->quote($this->getEnd()->get(IL_CAL_UNIX), 'integer') . ' ' .
            ')';
        $this->db->manipulate($query);
        $this->is_scheduled = true;
    }

References getEnd(), getRefId(), getStart(), getUserId(), IL_CAL_UNIX, isScheduled(), and update().

Referenced by update().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ delete()

ilTimingUser::delete ( )

Definition at line 114 of file class.ilTimingUser.php.

                            : void
    {
        $query = 'DELETE FROM crs_timings_user ' . ' ' .
            'WHERE ref_id = ' . $this->db->quote($this->getRefId(), 'integer') . ' ' .
            'AND usr_id = ' . $this->db->quote($this->getUserId(), 'integer');
        $this->db->manipulate($query);
        $this->is_scheduled = false;
    }

References getRefId().

Here is the call graph for this function:

◆ getEnd()

ilTimingUser::getEnd ( )

Use to set date.

Definition at line 77 of file class.ilTimingUser.php.

                            : ilDateTime
    {
        return $this->end;
    }

References $end.

Referenced by create(), and update().

Here is the caller graph for this function:

◆ getRefId()

ilTimingUser::getRefId ( )

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

                              : int
    {
        return $this->ref_id;
    }

References $ref_id.

Referenced by create(), delete(), read(), and update().

Here is the caller graph for this function:

◆ getStart()

ilTimingUser::getStart ( )

Use to set start date.

Definition at line 69 of file class.ilTimingUser.php.

                              : ilDateTime
    {
        return $this->start;
    }

References $start.

Referenced by create(), and update().

Here is the caller graph for this function:

◆ getUserId()

ilTimingUser::getUserId ( )

Definition at line 51 of file class.ilTimingUser.php.

                               : int
    {
        return $this->usr_id;
    }

References $usr_id.

Referenced by create(), read(), and update().

Here is the caller graph for this function:

◆ isScheduled()

ilTimingUser::isScheduled ( )

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

                                 : bool
    {
        return $this->is_scheduled;
    }

References $is_scheduled.

Referenced by create(), and update().

Here is the caller graph for this function:

◆ read()

ilTimingUser::read ( )

Definition at line 123 of file class.ilTimingUser.php.

                          : void
    {
        $query = 'SELECT * FROM crs_timings_user ' .
            'WHERE ref_id = ' . $this->db->quote($this->getRefId(), 'integer') . ' ' .
            'AND usr_id = ' . $this->db->quote($this->getUserId(), 'integer');
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->is_scheduled = true;
            $this->start = new ilDateTime((int) $row->sstart, IL_CAL_UNIX);
            $this->end = new ilDateTime((int) $row->ssend, IL_CAL_UNIX);
        }
    }

References $res, ilDBConstants\FETCHMODE_OBJECT, getRefId(), getUserId(), and IL_CAL_UNIX.

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ update()

ilTimingUser::update ( )

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

                            : void
    {
        if (!$this->isScheduled()) {
            $this->create();
            return;
        }
 
        $query = 'UPDATE crs_timings_user ' .
            'SET sstart = ' . $this->db->quote($this->getStart()->get(IL_CAL_UNIX), 'integer') . ', ' .
            'ssend = ' . $this->db->quote($this->getEnd()->get(IL_CAL_UNIX), 'integer') . ' ' .
            'WHERE ref_id = ' . $this->db->quote($this->getRefId(), 'integer') . ' ' .
            'AND usr_id = ' . $this->db->quote($this->getUserId(), 'integer');
        $this->db->manipulate($query);
    }

References create(), getEnd(), getRefId(), getStart(), getUserId(), IL_CAL_UNIX, and isScheduled().

Referenced by create().

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $db

ilDBInterface ilTimingUser::$db

protected

Definition at line 35 of file class.ilTimingUser.php.

◆ $end

ilDateTime ilTimingUser::$end

private

Definition at line 31 of file class.ilTimingUser.php.

Referenced by getEnd().

◆ $is_scheduled

bool ilTimingUser::$is_scheduled = false

private

Definition at line 33 of file class.ilTimingUser.php.

Referenced by isScheduled().

◆ $ref_id

int ilTimingUser::$ref_id = 0

private

Definition at line 28 of file class.ilTimingUser.php.

Referenced by getRefId().

◆ $start

ilDateTime ilTimingUser::$start

private

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

Referenced by getStart().

◆ $usr_id

int ilTimingUser::$usr_id = 0

private

Definition at line 29 of file class.ilTimingUser.php.

Referenced by getUserId().

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

components/ILIAS/Course/classes/Timings/class.ilTimingUser.php

Public Member Functions

Protected Attributes

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ create()

◆ delete()

◆ getEnd()

◆ getRefId()

◆ getStart()

◆ getUserId()

◆ isScheduled()

◆ read()

◆ update()

Field Documentation

◆ $db

◆ $end

◆ $is_scheduled

◆ $ref_id

◆ $start

◆ $usr_id