ilWorkspaceFolderUserSettingsRepository Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilWorkspaceFolderUserSettingsRepository:

Public Member Functions
	__construct (int $user_id, ?ilDBInterface $db=null)
	Constructor. More...
	getSortation (int $wfld_id)
	getSortationMultiple (array $wfld_ids)
	updateSortation (int $wfld_id, int $sortation)

Protected Attributes
int	$user_id
ilDBInterface	$db

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Stores user settings per workspace folder Table: wfld_user_setting (rw)

Author

Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 25 of file class.ilWorkspaceFolderUserSettingsRepository.php.

Constructor & Destructor Documentation

__construct()

ilWorkspaceFolderUserSettingsRepository::__construct	(	int	$user_id,
		?ilDBInterface	$db = null
	)

Constructor.

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

References $DIC, $user_id, and null.

      {
        global $DIC;

        $this->user_id = $user_id;
        $this->db = ($db != null)
            ? $db
            : $DIC->database();
    }

Member Function Documentation

getSortation()

ilWorkspaceFolderUserSettingsRepository::getSortation

(

int

$wfld_id

)

Definition at line 45 of file class.ilWorkspaceFolderUserSettingsRepository.php.

References $db, ilDBInterface\fetchAssoc(), and ilDBInterface\queryF().

                                              : int
    {
        $db = $this->db;

        $set = $db->queryF(
            "SELECT * FROM wfld_user_setting " .
            " WHERE user_id = %s " .
            " AND wfld_id = %s ",
            array("integer", "integer"),
            array($this->user_id, $wfld_id)
        );
        $rec = $db->fetchAssoc($set);
        return (int) ($rec["sortation"] ?? 0);
    }

Here is the call graph for this function:

getSortationMultiple()

ilWorkspaceFolderUserSettingsRepository::getSortationMultiple

(

array

$wfld_ids

)

Definition at line 60 of file class.ilWorkspaceFolderUserSettingsRepository.php.

References $db, $id, ilDBInterface\fetchAssoc(), ilDBInterface\in(), ILIAS\Repository\int(), and ilDBInterface\queryF().

                                                         : array
    {
        $db = $this->db;

        $set = $db->queryF(
            "SELECT * FROM wfld_user_setting " .
            " WHERE user_id = %s " .
            " AND " . $db->in("wfld_id", $wfld_ids, false, "integer"),
            array("integer"),
            array($this->user_id)
        );
        $ret = [];

        while ($rec = $db->fetchAssoc($set)) {
            $ret[$rec["wfld_id"]] = (int) $rec["sortation"];
        }
        foreach ($wfld_ids as $id) {
            if (!isset($ret[$id])) {
                $ret[$id] = 0;
            }
        }
        return $ret;
    }

Here is the call graph for this function:

updateSortation()

ilWorkspaceFolderUserSettingsRepository::updateSortation	(	int	$wfld_id,
		int	$sortation
	)

Definition at line 84 of file class.ilWorkspaceFolderUserSettingsRepository.php.

References $db, and ilDBInterface\replace().

    {
        $db = $this->db;

        $db->replace("wfld_user_setting", array(                // pk
                "user_id" => array("integer", $this->user_id),
                "wfld_id" => array("integer", $wfld_id)
            ), array(
                "sortation" => array("integer", $sortation)
            ));
    }

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ilWorkspaceFolderUserSettingsRepository::$db

protected

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

Referenced by getSortation(), getSortationMultiple(), and updateSortation().

$user_id

int ilWorkspaceFolderUserSettingsRepository::$user_id

protected

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

Referenced by __construct().

---

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

• components/ILIAS/WorkspaceFolder/UserSettings/classes/class.ilWorkspaceFolderUserSettingsRepository.php