class.ilTableTemplatesStorage.php

Go to the documentation of this file.

<?php

class ilTableTemplatesStorage
{
    protected ilDBInterface $db;

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

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

    public function load(
        string $a_context,
        int $a_user_id,
        string $a_name
    ): ?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((string) $rec["value"]);
    }

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

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