Saves (mostly asynchronously) user properties of tables (e.g. More...

Collaboration diagram for ilTableTemplatesStorage:

Public Member Functions
	__construct ()
	Constructor. More...

	store ($a_context, $a_user_id, $a_name, array $a_state)
	Store table template. More...

	load ($a_context, $a_user_id, $a_name)
	Get table template. More...

	delete ($a_context, $a_user_id, $a_name)
	Delete table template. More...

	getNames ($a_context, $a_user_id)
	List templates. More...

Protected Attributes
	$db

Detailed Description

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

Version: $Id$

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

Constructor & Destructor Documentation

◆ __construct()

ilTableTemplatesStorage::__construct ( )

Constructor.

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

References $DIC.

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

Member Function Documentation

◆ delete()

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

Delete table template.

Parameters

string	$a_context
int	$a_user_id
string	$a_name

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

References $db, and $ilDB.

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

◆ getNames()

ilTableTemplatesStorage::getNames	(	$a_context,
		$a_user_id
	)

List templates.

Parameters

string	$a_context
int	$a_user_id

Returns: array

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

References $db, $ilDB, and $result.

     {
         $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	(	$a_context,
		$a_user_id,
		$a_name
	)

Get table template.

Parameters

string	$a_context
int	$a_user_id
string	$a_name

Returns: array

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

References $db, and $ilDB.

     {
         $ilDB = $this->db;
 
         if ($a_context == "" || $a_name == "") {
             return;
         }
 
         $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	(		$a_context,
			$a_user_id,
			$a_name,
		array	$a_state
	)

Store table template.

Parameters

string	$a_context
int	$a_user_id
string	$a_name
array	$a_state

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

References $db, and $ilDB.

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