class.ilTableTemplatesStorage.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilTableTemplatesStorage
{
    protected $db;


    public function __construct()
    {
        global $DIC;

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

    public function store($a_context, $a_user_id, $a_name, array $a_state)
    {
        $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))
            )
        );
    }

    public function load($a_context, $a_user_id, $a_name)
    {
        $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"]);
    }

    public function delete($a_context, $a_user_id, $a_name)
    {
        $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")
        );
    }

    public function getNames($a_context, $a_user_id)
    {
        $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;
    }
}