class.ilObjectDataDeletionLog.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilObjectDataDeletionLog
{
    public static function add(ilObject $object): void
    {
        global $DIC;
        $ilDB = $DIC->database();
 
        $values = [
            "obj_id" => ["integer", $object->getId()],
            "title" => ["text", $object->getTitle()],
            "tstamp" => ["integer", time()],
            "type" => ["text", $object->getType()],
            "description" => ["clob", $object->getLongDescription()]
        ];
 
        $ilDB->insert("object_data_del", $values);
    }
 
    public static function get(int $a_object_id): ?array
    {
        global $DIC;
        $ilDB = $DIC->database();
 
        $sql =
            "SELECT obj_id, title, tstamp, type, description" . PHP_EOL
            . "FROM object_data_del" . PHP_EOL
            . "WHERE obj_id = " . $ilDB->quote($a_object_id, "integer") . PHP_EOL
        ;
 
        $set = $ilDB->query($sql);
        return $ilDB->fetchAssoc($set);
    }
}