class.ilLTIConsumerResult.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilLTIConsumerResult
{
    public int $id;

    public int $obj_id;

    public int $usr_id;

    public ?float $result = null;

    public static function getById(int $a_id): ?ilLTIConsumerResult
    {
        global $DIC;

        $query = 'SELECT * FROM lti_consumer_results'
            . ' WHERE id = ' . $DIC->database()->quote($a_id, 'integer');

        $res = $DIC->database()->query($query);
        if ($row = $DIC->database()->fetchAssoc($res)) {
            $resObj = new ilLTIConsumerResult();
            $resObj->fillData($row);
            return $resObj;
        } else {
            return null;
        }
    }

    public static function getByKeys(int $a_obj_id, int $a_usr_id, ?bool $a_create = false): ?ilLTIConsumerResult
    {
        global $DIC;

        $logger = $DIC->logger()->root();
        $logger->info('getByKeys: ' . $a_obj_id . ' ' . $a_usr_id);

        $query = 'SELECT * FROM lti_consumer_results'
            . ' WHERE obj_id = ' . $DIC->database()->quote($a_obj_id, 'integer')
            . ' AND usr_id = ' . $DIC->database()->quote($a_usr_id, 'integer');

        $res = $DIC->database()->query($query);
        if ($row = $DIC->database()->fetchAssoc($res)) {
            $resObj = new ilLTIConsumerResult();
            $resObj->fillData($row);
            return $resObj;
        } elseif ($a_create) {
            $resObj = new ilLTIConsumerResult();
            $resObj->obj_id = $a_obj_id;
            $resObj->usr_id = $a_usr_id;
            $resObj->result = null;
            $resObj->save();
            return $resObj;
        } else {
            return null;
        }
    }

    protected function fillData(array $data): void
    {
        $this->id = (int) $data['id'];
        $this->obj_id = (int) $data['obj_id'];
        $this->usr_id = (int) $data['usr_id'];
        $this->result = $data['result'] == null ? null : (float) $data['result'];
    }

    public function save(): bool
    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */

        $logger = $DIC->logger()->root();

        $logger->info('save: ' . $this->obj_id . ' ' . $this->usr_id);

        if (!isset($this->usr_id) || !isset($this->obj_id)) {
            return false;
        }
        if (!isset($this->id)) {
            $this->id = $DIC->database()->nextId('lti_consumer_results');
        }

        $logger = $DIC->logger()->root();

        $logger->info('save 2: ' . $this->obj_id . ' ' . $this->usr_id);

        $DIC->database()->replace(
            'lti_consumer_results',
            array(
                'id' => array('integer', $this->id)
            ),
            array(
                'obj_id' => array('integer', $this->obj_id),
                'usr_id' => array('integer', $this->usr_id),
                'result' => array('float', $this->result)
            )
        );
        return true;
    }

    public function getId(): int
    {
        return $this->id;
    }

    public function getObjId(): int
    {
        return $this->obj_id;
    }

    public function getUsrId(): int
    {
        return $this->usr_id;
    }

    public function getResult(): ?float
    {
        return $this->result;
    }

    public static function getResultsForObject(int $objId): array
    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */

        $query = 'SELECT * FROM lti_consumer_results'
            . ' WHERE obj_id = ' . $DIC->database()->quote($objId, 'integer');

        $res = $DIC->database()->query($query);

        $results = [];

        if ($row = $DIC->database()->fetchAssoc($res)) {
            $resObj = new ilLTIConsumerResult();
            $resObj->fillData($row);

            $results[$resObj->getUsrId()] = $resObj;
        }

        return $results;
    }
}