class.ilLTIToolResult.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilLTIToolResult
{
    private const string TABLE_NAME = 'lti_consumer_results';
 
    private function __construct(private readonly ?float $result)
    {
    }
 
    public static function getByKeys(int $obj_id, int $usr_id): ?self
    {
        global $DIC;
 
        $db = $DIC->database();
        $row = $db->fetchAssoc($db->queryF(
            'SELECT result FROM ' . self::TABLE_NAME . ' WHERE obj_id = %s AND usr_id = %s',
            ['integer', 'integer'],
            [$obj_id, $usr_id]
        ));
        if ($row === null) {
            return null;
        }
 
        return new self($row['result'] === null ? null : (float) $row['result']);
    }
 
    public static function start(int $obj_id, int $usr_id): void
    {
        global $DIC;
 
        $db = $DIC->database();
        if (self::getByKeys($obj_id, $usr_id) === null) {
            $db->insert(self::TABLE_NAME, [
                'id' => ['integer', $db->nextId(self::TABLE_NAME)],
                'obj_id' => ['integer', $obj_id],
                'usr_id' => ['integer', $usr_id],
                'result' => ['float', null],
                'attended' => ['integer', 0],
            ]);
        }
        ilLPStatusWrapper::_updateStatus($obj_id, $usr_id);
    }
 
    public function getResult(): ?float
    {
        return $this->result;
    }
}