ilTimingUser Class Reference

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.

References $DIC, IL_CAL_UNIX, and read().

    {
        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();
    }

Here is the call graph for this function:

Member Function Documentation

create()

ilTimingUser::create

(

)

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

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

Referenced by update().

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

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.

References getRefId(), and getUserId().

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

Here is the call graph for this function:

getEnd()

ilTimingUser::getEnd

(

)

Use to set date.

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

References $end.

Referenced by create(), and update().

                            : ilDateTime
    {
        return $this->end;
    }

Here is the caller graph for this function:

getRefId()

ilTimingUser::getRefId

(

)

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

References $ref_id.

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

                              : int
    {
        return $this->ref_id;
    }

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.

References $start.

Referenced by ilObjectActivation\addAdditionalSubItemInformation(), create(), and update().

                              : ilDateTime
    {
        return $this->start;
    }

Here is the caller graph for this function:

getUserId()

ilTimingUser::getUserId

(

)

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

References $usr_id.

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

                               : int
    {
        return $this->usr_id;
    }

Here is the caller graph for this function:

isScheduled()

ilTimingUser::isScheduled

(

)

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

References $is_scheduled.

Referenced by create(), and update().

                                 : bool
    {
        return $this->is_scheduled;
    }

Here is the caller graph for this function:

read()

ilTimingUser::read

(

)

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

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

Referenced by __construct().

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

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.

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

Referenced by create().

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

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