Persistence for View-States. More...

Collaboration diagram for ilLSStateDB:

Public Member Functions
	__construct (ilDBInterface $db)

	getStatesFor (int $lso_ref_id, array $usr_ids=[])

	getCurrentItemsFor (int $lso_ref_id, array $usr_ids=[])

	getFirstAccessFor (int $lso_ref_id, array $usr_ids=[])

	getLastAccessFor (int $lso_ref_id, array $usr_ids=[])

	updateState (int $lso_ref_id, int $usr_id, int $ref_id, ILIAS\KioskMode\State $state, int $current_item=null)
	update a single State (for the item with ref_id); if $current_item is not set, assume that $ref_id is the current one. More...

	deleteFor (int $lso_ref_id, array $usr_ids=[])

	deleteForItem (int $lso_ref_id, int $item_ref_id)

Data Fields
const	TABLE_NAME = 'lso_states'

const	CURRENT_ITEM_ID = "current_item"

const	STATES = "states"

const	FIRST_ACCESS = "first_access"

const	LAST_ACCESS = "last_access"

Protected Member Functions
	entryExistsFor (int $lso_ref_id, int $usr_id)

	insert (int $lso_ref_id, int $usr_id)

	update (ilDBInterface $db, int $lso_ref_id, int $usr_id, int $current_item, string $serialized)

	buildStates (string $serialized)

	serializeStates (array $states)

	select (int $lso_ref_id, array $usr_ids=[])

Protected Attributes
	$db

Detailed Description

Persistence for View-States.

Author: Nils Haagen nils..nosp@m.haag.nosp@m.en@co.nosp@m.ncep.nosp@m.ts-an.nosp@m.d-tr.nosp@m.ainin.nosp@m.g.de

Definition at line 10 of file class.ilLSStateDB.php.

Constructor & Destructor Documentation

◆ __construct()

ilLSStateDB::__construct ( ilDBInterface $db )

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

    {
        $this->db = $db;
    }

References $db.

Member Function Documentation

◆ buildStates()

ilLSStateDB::buildStates ( string $serialized )

protected

Returns: array <int,ILIAS\KioskMode\State> ref_id=>State

Definition at line 216 of file class.ilLSStateDB.php.

                                                       : array
    {
        $states = [];
        $data = json_decode($serialized, true);
        foreach ($data as $ref_id => $kvpair) {
            $states[$ref_id] = new ILIAS\KioskMode\State();
            if (is_array($kvpair)) {
                foreach ($kvpair as $key => $value) {
                    $states[$ref_id] = $states[$ref_id]->withValueFor($key, $value);
                }
            }
        }
 
        return $states;
    }

References $data.

Referenced by select().

Here is the caller graph for this function:

◆ deleteFor()

ilLSStateDB::deleteFor	(	int	$lso_ref_id,
		array	$usr_ids = `[]`
	)

Parameters

int	$lso_ref_id
int[]	$usr_ids

Definition at line 167 of file class.ilLSStateDB.php.

    {
        $query =
             "DELETE FROM " . static::TABLE_NAME . PHP_EOL
            . "WHERE lso_ref_id = " . $this->db->quote($lso_ref_id, "integer") . PHP_EOL
        ;
 
        if (count($usr_ids) > 0) {
            $query .= "AND usr_id IN (" . implode(',', $usr_ids) . ")";
        }
 
        $this->db->manipulate($query);
    }

References $query.

◆ deleteForItem()

ilLSStateDB::deleteForItem	(	int	$lso_ref_id,
		int	$item_ref_id
	)

Definition at line 181 of file class.ilLSStateDB.php.

    {
        $all_states = $this->select($lso_ref_id);
        if (count($all_states) === 0) {
            return;
        }
 
        $ilAtomQuery = $this->db->buildAtomQuery();
        $ilAtomQuery->addTableLock(static::TABLE_NAME);
        $ilAtomQuery->addQueryCallable(
            function (ilDBInterface $db) use ($lso_ref_id, $all_states, $item_ref_id) {
                foreach ($all_states as $usr_id => $state_entry) {
                    $current_item = $state_entry['current_item'];
                    $states = $state_entry['states'];
 
                    if ($current_item === $item_ref_id) {
                        $current_item = -1;
                    }
 
                    if (array_key_exists($item_ref_id, $states)) {
                        unset($states[$item_ref_id]);
                    }
                    $serialized = $this->serializeStates($states);
                    $this->update($db, $lso_ref_id, $usr_id, $current_item, $serialized);
                }
            }
        );
 
        $ilAtomQuery->run();
    }

References $db, select(), serializeStates(), and update().

Here is the call graph for this function:

◆ entryExistsFor()

ilLSStateDB::entryExistsFor	(	int	$lso_ref_id,
		int	$usr_id
	)

protected

Definition at line 125 of file class.ilLSStateDB.php.

                                                                    : bool
    {
        return count($this->select($lso_ref_id, [$usr_id])) > 0;
    }

References select().

Referenced by updateState().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getCurrentItemsFor()

ilLSStateDB::getCurrentItemsFor	(	int	$lso_ref_id,
		array	$usr_ids = `[]`
	)

Returns: array <int, int> usr_id => item_ref_id

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

                                                                             : array
    {
        $data = $this->select($lso_ref_id, $usr_ids);
        $ret = [];
        foreach ($usr_ids as $usr_id) {
            $ret[$usr_id] = -1;
            if (array_key_exists($usr_id, $data)) {
                $ret[$usr_id] = $data[$usr_id][self::CURRENT_ITEM_ID];
            }
        }
 
        return $ret;
    }

References $data, $ret, CURRENT_ITEM_ID, and select().

Here is the call graph for this function:

◆ getFirstAccessFor()

ilLSStateDB::getFirstAccessFor	(	int	$lso_ref_id,
		array	$usr_ids = `[]`
	)

Definition at line 63 of file class.ilLSStateDB.php.

                                                                            : array
    {
        $data = $this->select($lso_ref_id, $usr_ids);
        $ret = [];
        foreach ($usr_ids as $usr_id) {
            $ret[$usr_id] = -1;
            if (array_key_exists($usr_id, $data)) {
                $ret[$usr_id] = $data[$usr_id][self::FIRST_ACCESS];
            }
        }
 
        return $ret;
    }

References $data, $ret, FIRST_ACCESS, and select().

Here is the call graph for this function:

◆ getLastAccessFor()

ilLSStateDB::getLastAccessFor	(	int	$lso_ref_id,
		array	$usr_ids = `[]`
	)

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

                                                                           : array
    {
        $data = $this->select($lso_ref_id, $usr_ids);
        $ret = [];
        foreach ($usr_ids as $usr_id) {
            $ret[$usr_id] = -1;
            if (array_key_exists($usr_id, $data)) {
                $ret[$usr_id] = $data[$usr_id][self::LAST_ACCESS];
            }
        }
 
        return $ret;
    }

References $data, $ret, LAST_ACCESS, and select().

Here is the call graph for this function:

◆ getStatesFor()

ilLSStateDB::getStatesFor	(	int	$lso_ref_id,
		array	$usr_ids = `[]`
	)

Returns: array <int,ILIAS\KioskMode\State> usr_id => [item_ref_id=>State]

Definition at line 32 of file class.ilLSStateDB.php.

                                                                       : array
    {
        $data = $this->select($lso_ref_id, $usr_ids);
        $ret = [];
        foreach ($usr_ids as $usr_id) {
            $ret[$usr_id] = [];
            if (array_key_exists($usr_id, $data)) {
                $ret[$usr_id] = $data[$usr_id][self::STATES];
            }
        }
 
        return $ret;
    }

References $data, $ret, select(), and STATES.

Referenced by updateState().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ insert()

ilLSStateDB::insert	(	int	$lso_ref_id,
		int	$usr_id
	)

protected

Definition at line 130 of file class.ilLSStateDB.php.

    {
        $first_access = date("d.m.Y H:i:s");
        $values = array(
            "lso_ref_id" => array("integer", $lso_ref_id),
            "usr_id" => array("integer", $usr_id),
            "first_access" => array("text", $first_access)
        );
 
        $this->db->insert(static::TABLE_NAME, $values);
    }

Referenced by updateState().

Here is the caller graph for this function:

◆ select()

ilLSStateDB::select	(	int	$lso_ref_id,
		array	$usr_ids = `[]`
	)

protected

Definition at line 245 of file class.ilLSStateDB.php.

    {
        $query =
             "SELECT usr_id, current_item, states, first_access, last_access" . PHP_EOL
            . "FROM " . static::TABLE_NAME . PHP_EOL
            . "WHERE lso_ref_id = " . $this->db->quote($lso_ref_id, "integer") . PHP_EOL
        ;
 
        if (count($usr_ids) > 0) {
            $query .= "AND usr_id IN (" . implode(',', $usr_ids) . ")";
        }
 
        $result = $this->db->query($query);
 
        $ret = [];
        while ($row = $this->db->fetchAssoc($result)) {
            $ret[$row['usr_id']] = [
                self::CURRENT_ITEM_ID => (int) $row[self::CURRENT_ITEM_ID],
                self::STATES => $this->buildStates($row[self::STATES]),
                self::FIRST_ACCESS => $row[self::FIRST_ACCESS],
                self::LAST_ACCESS => $row[self::LAST_ACCESS]
            ];
        }
 
        return $ret;
    }

References $query, $result, $ret, buildStates(), FIRST_ACCESS, and LAST_ACCESS.

Referenced by deleteForItem(), entryExistsFor(), getCurrentItemsFor(), getFirstAccessFor(), getLastAccessFor(), and getStatesFor().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ serializeStates()

ilLSStateDB::serializeStates ( array $states )

protected

Parameters

array <int,ILIAS\KioskMode\State> ref_id=>State

Definition at line 235 of file class.ilLSStateDB.php.

    {
        $data = [];
        foreach ($states as $ref_id => $state) {
            $data[$ref_id] = json_decode($state->serialize());
        }
 
        return json_encode($data);
    }

References $data.

Referenced by deleteForItem(), and updateState().

Here is the caller graph for this function:

◆ update()

ilLSStateDB::update	(	ilDBInterface	$db,
		int	$lso_ref_id,
		int	$usr_id,
		int	$current_item,
		string	$serialized
	)

protected

Definition at line 142 of file class.ilLSStateDB.php.

      {
        $last_access = date("d.m.Y H:i:s");
        $where = array(
            "lso_ref_id" => array("integer", $lso_ref_id),
            "usr_id" => array("integer", $usr_id)
        );
        $values = array(
            "current_item" => array("integer", $current_item),
            "states" => array("text", $serialized),
            "last_access" => array("text", $last_access)
        );
 
        $db->update(static::TABLE_NAME, $values, $where);
    }

References $db.

Referenced by deleteForItem(), and updateState().

Here is the caller graph for this function:

◆ updateState()

ilLSStateDB::updateState	(	int	$lso_ref_id,
		int	$usr_id,
		int	$ref_id,
		ILIAS\KioskMode\State	$state,
		int	$current_item = `null`
	)

update a single State (for the item with ref_id); if $current_item is not set, assume that $ref_id is the current one.

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

      {
        $insert_first = $this->entryExistsFor($lso_ref_id, $usr_id) === false;
        $states = $this->getStatesFor($lso_ref_id, [$usr_id]);
        $states = $states[$usr_id];
        $states[$ref_id] = $state;
        $serialized = $this->serializeStates($states);
        if (is_null($current_item)) {
            $current_item = $ref_id;
        }
 
        $ilAtomQuery = $this->db->buildAtomQuery();
        $ilAtomQuery->addTableLock(static::TABLE_NAME);
        $ilAtomQuery->addQueryCallable(
            function (ilDBInterface $db) use ($insert_first, $lso_ref_id, $usr_id, $current_item, $serialized) {
                if ($insert_first) {
                    $this->insert($lso_ref_id, $usr_id);
                }
                $this->update($db, $lso_ref_id, $usr_id, $current_item, $serialized);
            }
        );
 
        $ilAtomQuery->run();
    }

References $db, entryExistsFor(), getStatesFor(), insert(), serializeStates(), and update().

Here is the call graph for this function:

Field Documentation

◆ $db

ilLSStateDB::$db

protected

Definition at line 22 of file class.ilLSStateDB.php.

Referenced by __construct(), deleteForItem(), update(), and updateState().

◆ CURRENT_ITEM_ID

const ilLSStateDB::CURRENT_ITEM_ID = "current_item"

Definition at line 14 of file class.ilLSStateDB.php.

Referenced by getCurrentItemsFor().

◆ FIRST_ACCESS

const ilLSStateDB::FIRST_ACCESS = "first_access"

Definition at line 16 of file class.ilLSStateDB.php.

Referenced by getFirstAccessFor(), and select().

◆ LAST_ACCESS

const ilLSStateDB::LAST_ACCESS = "last_access"

Definition at line 17 of file class.ilLSStateDB.php.

Referenced by getLastAccessFor(), and select().

◆ STATES

const ilLSStateDB::STATES = "states"

Definition at line 15 of file class.ilLSStateDB.php.

Referenced by getStatesFor().

◆ TABLE_NAME

const ilLSStateDB::TABLE_NAME = 'lso_states'

Definition at line 12 of file class.ilLSStateDB.php.

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

Modules/LearningSequence/classes/Player/class.ilLSStateDB.php

Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ buildStates()

◆ deleteFor()

◆ deleteForItem()

◆ entryExistsFor()

◆ getCurrentItemsFor()

◆ getFirstAccessFor()

◆ getLastAccessFor()

◆ getStatesFor()

◆ insert()

◆ select()

◆ serializeStates()

◆ update()

◆ updateState()

Field Documentation

◆ $db

◆ CURRENT_ITEM_ID

◆ FIRST_ACCESS

◆ LAST_ACCESS

◆ STATES

◆ TABLE_NAME