ilLSStateDB Class Reference

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.

References $db.

    {
        $this->db = $db;
    }

Member Function Documentation

buildStates()

ilLSStateDB::buildStates ( string  $serialized )

protected

Returns

array <int,ILIAS> ref_id=>State

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

References $data, and $key.

Referenced by select().

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

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.

References $query, and PHP_EOL.

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

deleteForItem()

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

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

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

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

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.

References select().

Referenced by updateState().

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

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.

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

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

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.

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

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

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.

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

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

Here is the call graph for this function:

getStatesFor()

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

Returns

array <int,ILIAS> usr_id => [item_ref_id=>State]

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

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

Referenced by updateState().

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

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.

References $values.

Referenced by updateState().

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

Here is the caller graph for this function:

select()

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

protected

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

References $query, $result, $ret, $row, buildStates(), and PHP_EOL.

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

    {
        $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;
    }

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> ref_id=>State

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

References $data, and $state.

Referenced by deleteForItem(), and updateState().

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

        return json_encode($data);
    }

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.

References $values, and ilDBInterface\update().

Referenced by deleteForItem(), and updateState().

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

Here is the call graph for this function:

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.

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

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

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(), and updateState().

CURRENT_ITEM_ID

const ilLSStateDB::CURRENT_ITEM_ID = "current_item"

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

FIRST_ACCESS

const ilLSStateDB::FIRST_ACCESS = "first_access"

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

LAST_ACCESS

const ilLSStateDB::LAST_ACCESS = "last_access"

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

STATES

const ilLSStateDB::STATES = "states"

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

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