ilTableTemplatesStorage 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 ilTableTemplatesStorage:

Public Member Functions
	__construct ()
	store (string $a_context, int $a_user_id, string $a_name, array $a_state)
	Store table template. More...
	load (string $a_context, int $a_user_id, string $a_name)
	Get table template. More...
	delete (string $a_context, int $a_user_id, string $a_name)
	Delete table template. More...
	getNames (string $a_context, int $a_user_id)
	List templates. More...

Protected Attributes
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 Saves (mostly asynchronously) user properties of tables (e.g. filter on/off)

Author

Jörg Lützenkirchen luetz.nosp@m.enki.nosp@m.rchen.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Definition at line 23 of file class.ilTableTemplatesStorage.php.

Constructor & Destructor Documentation

__construct()

ilTableTemplatesStorage::__construct

(

)

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

    {
        global $DIC;
        $this->db = $DIC->database();
    }

References $DIC.

Member Function Documentation

delete()

ilTableTemplatesStorage::delete	(	string	$a_context,
		int	$a_user_id,
		string	$a_name
	)

Delete table template.

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

     : void {
        $ilDB = $this->db;
 
        if ($a_context == "" || $a_name == "") {
            return;
        }
 
        $ilDB->query(
            "DELETE FROM table_templates " .
            " WHERE name = " . $ilDB->quote($a_name, "text") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND context = " . $ilDB->quote($a_context, "text")
        );
    }

References $ilDB.

getNames()

ilTableTemplatesStorage::getNames	(	string	$a_context,
		int	$a_user_id
	)

List templates.

Definition at line 109 of file class.ilTableTemplatesStorage.php.

     : array {
        $ilDB = $this->db;
 
        if ($a_context == "") {
            return [];
        }
 
        $set = $ilDB->query(
            "SELECT name FROM table_templates " .
            " WHERE user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND context = " . $ilDB->quote($a_context, "text") .
            " ORDER BY name"
        );
        $result = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $result[] = $rec["name"];
        }
        return $result;
    }

load()

ilTableTemplatesStorage::load	(	string	$a_context,
		int	$a_user_id,
		string	$a_name
	)

Get table template.

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

     : ?array {
        $ilDB = $this->db;
 
        if ($a_context == "" || $a_name == "") {
            return null;
        }
 
        $set = $ilDB->query(
            "SELECT value FROM table_templates " .
            " WHERE name = " . $ilDB->quote($a_name, "text") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND context = " . $ilDB->quote($a_context, "text")
        );
        $rec = $ilDB->fetchAssoc($set);
        return unserialize($rec["value"]);
    }

store()

ilTableTemplatesStorage::store	(	string	$a_context,
		int	$a_user_id,
		string	$a_name,
		array	$a_state
	)

Store table template.

Definition at line 36 of file class.ilTableTemplatesStorage.php.

     : void {
        $ilDB = $this->db;
 
        if ($a_context == "" || $a_name == "") {
            return;
        }
 
        $ilDB->replace(
            "table_templates",
            array(
                "name" => array("text", $a_name),
                "user_id" => array("integer", $a_user_id),
                "context" => array("text", $a_context)),
            array(
                "value" => array("text", serialize($a_state))
            )
        );
    }

Field Documentation

$db

ilDBInterface ilTableTemplatesStorage::$db

protected

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

---

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

• Services/Table/classes/class.ilTableTemplatesStorage.php