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;
    }
}