ilTimingPlaned Class Reference

class ilTimingPlaned More...

Collaboration diagram for ilTimingPlaned:

Public Member Functions
	__construct (int $item_id, int $a_usr_id)
	getUserId ()
	getItemId ()
	getPlanedStartingTime ()
	setPlanedStartingTime (int $a_time)
	getPlanedEndingTime ()
	setPlanedEndingTime (int $a_end)
	validate ()
	update ()
	create ()
	delete ()
	__read ()

Static Public Member Functions
static	_delete (int $a_item_id, int $a_usr_id)
static	_getPlanedTimings (int $a_usr_id, int $a_item_id)
static	_getPlanedTimingsByItem ($a_item_id)
static	_deleteByItem (int $a_item_id)
static	_deleteByUser (int $a_usr_id)

Protected Attributes
ilDBInterface	$db

Private Attributes
int	$item_id = 0
int	$user_id = 0
int	$start = 0
int	$end = 0

Detailed Description

class ilTimingPlaned

Author

Stefan Meyer meyer.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Definition at line 24 of file class.ilTimingPlaned.php.

Constructor & Destructor Documentation

__construct()

ilTimingPlaned::__construct	(	int	$item_id,
		int	$a_usr_id
	)

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

References $DIC, $item_id, and __read().

    {
        global $DIC;

        $this->db = $DIC->database();

        $this->item_id = $item_id;
        $this->user_id = $a_usr_id;
        $this->__read();
    }

Here is the call graph for this function:

Member Function Documentation

__read()

ilTimingPlaned::__read

(

)

Definition at line 169 of file class.ilTimingPlaned.php.

References $res, ilDBConstants\FETCHMODE_OBJECT, getItemId(), getUserId(), setPlanedEndingTime(), and setPlanedStartingTime().

Referenced by __construct().

                            : void
    {
        $query = "SELECT * FROM crs_timings_planed " .
            "WHERE item_id = " . $this->db->quote($this->getItemId(), 'integer') . " " .
            "AND usr_id = " . $this->db->quote($this->getUserId(), 'integer') . " ";
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->setPlanedStartingTime((int) $row->planed_start);
            $this->setPlanedEndingTime((int) $row->planed_end);
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_delete()

static ilTimingPlaned::_delete ( int  $a_item_id, int  $a_usr_id  )

static

Definition at line 104 of file class.ilTimingPlaned.php.

References $DIC, $ilDB, and $res.

Referenced by delete(), and update().

                                                                 : void
    {
        global $DIC;

        $ilDB = $DIC->database();
        $query = "DELETE FROM crs_timings_planed " .
            "WHERE item_id = " . $ilDB->quote($a_item_id, 'integer') . " " .
            "AND usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);
    }

Here is the caller graph for this function:

_deleteByItem()

static ilTimingPlaned::_deleteByItem ( int  $a_item_id )

static

Definition at line 149 of file class.ilTimingPlaned.php.

References $DIC, $ilDB, and $res.

                                                        : void
    {
        global $DIC;

        $ilDB = $DIC->database();
        $query = "DELETE FROM crs_timings_planed " .
            "WHERE item_id = " . $ilDB->quote($a_item_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);
    }

_deleteByUser()

static ilTimingPlaned::_deleteByUser ( int  $a_usr_id )

static

Definition at line 159 of file class.ilTimingPlaned.php.

References $DIC, $ilDB, and $res.

                                                       : void
    {
        global $DIC;

        $ilDB = $DIC->database();
        $query = "DELETE FROM crs_timings_planed " .
            "WHERE usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);
    }

_getPlanedTimings()

static ilTimingPlaned::_getPlanedTimings ( int  $a_usr_id, int  $a_item_id  )

static

Definition at line 115 of file class.ilTimingPlaned.php.

References $data, $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

                                                                           : array
    {
        global $DIC;

        $ilDB = $DIC->database();

        $query = "SELECT * FROM crs_timings_planed " .
            "WHERE item_id = " . $ilDB->quote($a_item_id, 'integer') . " " .
            "AND usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
        $res = $ilDB->query($query);
        $data = [];
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $data['planed_start'] = (int) $row->planed_start;
            $data['planed_end'] = (int) $row->planed_end;
        }
        return $data;
    }

Here is the call graph for this function:

_getPlanedTimingsByItem()

static ilTimingPlaned::_getPlanedTimingsByItem (   $a_item_id )

static

Definition at line 133 of file class.ilTimingPlaned.php.

References $data, $DIC, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\int().

Referenced by ilTimingCache\_getTimings(), and ilTimingCache\readObjectInformation().

                                                              : array
    {
        global $DIC;

        $ilDB = $DIC->database();
        $query = "SELECT * FROM crs_timings_planed " .
            "WHERE item_id = " . $ilDB->quote($a_item_id, 'integer') . " ";
        $res = $ilDB->query($query);
        $data = [];
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $data[(int) $row->usr_id]['start'] = (int) $row->planed_start;
            $data[(int) $row->usr_id]['end'] = (int) $row->planed_end;
        }
        return $data;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

create()

ilTimingPlaned::create

(

)

Definition at line 87 of file class.ilTimingPlaned.php.

References $res, getItemId(), getPlanedEndingTime(), getPlanedStartingTime(), and getUserId().

Referenced by update().

                            : void
    {
        $query = "INSERT INTO crs_timings_planed (item_id,usr_id,planed_start,planed_end) " .
            "VALUES( " .
            $this->db->quote($this->getItemId(), 'integer') . ", " .
            $this->db->quote($this->getUserId(), 'integer') . ", " .
            $this->db->quote($this->getPlanedStartingTime(), 'integer') . ", " .
            $this->db->quote($this->getPlanedEndingTime(), 'integer') . " " .
            ")";
        $res = $this->db->manipulate($query);
    }

Here is the call graph for this function:

Here is the caller graph for this function:

delete()

ilTimingPlaned::delete

(

)

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

References _delete(), getItemId(), and getUserId().

                            : void
    {
        ilTimingPlaned::_delete($this->getItemId(), $this->getUserId());
    }

Here is the call graph for this function:

getItemId()

ilTimingPlaned::getItemId

(

)

Definition at line 49 of file class.ilTimingPlaned.php.

References $item_id.

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

                               : int
    {
        return $this->item_id;
    }

Here is the caller graph for this function:

getPlanedEndingTime()

ilTimingPlaned::getPlanedEndingTime

(

)

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

References $end.

Referenced by create().

                                         : int
    {
        return $this->end;
    }

Here is the caller graph for this function:

getPlanedStartingTime()

ilTimingPlaned::getPlanedStartingTime

(

)

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

References $start.

Referenced by create().

                                           : int
    {
        return $this->start;
    }

Here is the caller graph for this function:

getUserId()

ilTimingPlaned::getUserId

(

)

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

References $user_id.

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

                               : int
    {
        return $this->user_id;
    }

Here is the caller graph for this function:

setPlanedEndingTime()

ilTimingPlaned::setPlanedEndingTime

(

int

$a_end

)

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

Referenced by __read().

                                                   : void
    {
        $this->end = $a_end;
    }

Here is the caller graph for this function:

setPlanedStartingTime()

ilTimingPlaned::setPlanedStartingTime

(

int

$a_time

)

Definition at line 59 of file class.ilTimingPlaned.php.

Referenced by __read().

                                                      : void
    {
        $this->start = $a_time;
    }

Here is the caller graph for this function:

update()

ilTimingPlaned::update

(

)

Definition at line 80 of file class.ilTimingPlaned.php.

References _delete(), create(), getItemId(), and getUserId().

                            : bool
    {
        ilTimingPlaned::_delete($this->getItemId(), $this->getUserId());
        $this->create();
        return true;
    }

Here is the call graph for this function:

validate()

ilTimingPlaned::validate

(

)

Definition at line 74 of file class.ilTimingPlaned.php.

References ilObjectActivation\getItem(), and getItemId().

                              : bool
    {
        $item = ilObjectActivation::getItem($this->getItemId());
        return true;
    }

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ilTimingPlaned::$db

protected

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

$end

int ilTimingPlaned::$end = 0

private

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

Referenced by getPlanedEndingTime().

$item_id

int ilTimingPlaned::$item_id = 0

private

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

Referenced by __construct(), and getItemId().

$start

int ilTimingPlaned::$start = 0

private

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

Referenced by getPlanedStartingTime().

$user_id

int ilTimingPlaned::$user_id = 0

private

Definition at line 27 of file class.ilTimingPlaned.php.

Referenced by getUserId().

---

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

• components/ILIAS/Course/classes/Timings/class.ilTimingPlaned.php