class.ilLTIConsumerGradeSynchronization.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

class ilLTIConsumerGradeSynchronization
{
    public int $id;
    public int $obj_id;
    public int $usr_id;

    public ?float $result = null;


    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 getGradesForObject(int $objId, ?int $usrID = null, ?string $activity_progress = null, ?string $grading_progress = null, ?ilDateTime $startDate = null, ?ilDateTime $endDate = null): array
    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */

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

        if ($usrID != null) {
            $query .= ' AND usr_id = ' . $DIC->database()->quote($usrID, 'integer');
        }

        if ($activity_progress != null) {
            $query .= ' AND activity_progress = ' . $DIC->database()->quote($activity_progress, 'text');
        }

        if ($grading_progress != null) {
            $query .= ' AND grading_progress = ' . $DIC->database()->quote($grading_progress, 'text');
        }

        if ($startDate != null && $startDate->get(IL_CAL_DATETIME) != null) {
            $query .= ' AND lti_timestamp >= ' . $DIC->database()->quote($startDate->get(IL_CAL_DATETIME), 'timestamp');
        }

        if ($endDate != null && $endDate->get(IL_CAL_DATETIME) != null) {
            $query .= ' AND lti_timestamp <= ' . $DIC->database()->quote($endDate->get(IL_CAL_DATETIME), 'timestamp');
        }

        $query .= ' ORDER BY lti_timestamp DESC';

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

        $results = [];

        while ($row = $DIC->database()->fetchAssoc($res)) {
            $results[] = $row;
        }

        return $results;
    }
}