class.ilLPStatusTestPassed.php

Go to the documentation of this file.

<?php

declare(strict_types=0);

class ilLPStatusTestPassed extends ilLPStatus
{
    public static function _getInProgress(int $a_obj_id): array
    {
        $userIds = self::getUserIdsByResultArrayStatus(
            $a_obj_id,
            'in_progress'
        );
        return $userIds;
    }

    public static function _getCompleted(int $a_obj_id): array
    {
        $userIds = self::getUserIdsByResultArrayStatus($a_obj_id, 'passed');
        return $userIds;
    }

    public static function _getNotAttempted(int $a_obj_id): array
    {
        return self::getUserIdsByResultArrayStatus($a_obj_id, 'not_attempted');
    }

    public static function _getFailed(int $a_obj_id): array
    {
        return self::getUserIdsByResultArrayStatus($a_obj_id, 'failed');
    }

    private static function getUserIdsByResultArrayStatus(
        $objId,
        $resultArrayStatus
    ) {
        $status_info = ilLPStatusWrapper::_getStatusInfo($objId);

        $user_ids = array();

        foreach ($status_info['results'] as $user_data) {
            if (isset($user_data[$resultArrayStatus]) && $user_data[$resultArrayStatus]) {
                $user_ids[] = (int) $user_data['user_id'];
            }
        }

        return $user_ids;
    }

    public static function _getStatusInfo(int $a_obj_id): array
    {
        $status_info['results'] = ilObjTestAccess::_getPassedUsers($a_obj_id);
        return $status_info;
    }

    public function determineStatus(
        int $a_obj_id,
        int $a_usr_id,
        ?object $a_obj = null
    ): int {
        $old_status = ilLPStatus::_lookupStatus($a_obj_id, $a_usr_id, false);
        $status = self::LP_STATUS_NOT_ATTEMPTED_NUM;

        $res = $this->db->query(
            "
                        SELECT tst_active.active_id, tst_active.tries, count(tst_sequence.active_fi) " . $this->db->quoteIdentifier(
                "sequences"
            ) . ", tst_active.last_finished_pass,
                                CASE WHEN
                                        (tst_tests.nr_of_tries - 1) = tst_active.last_finished_pass
                                THEN '1'
                                ELSE '0'
                                END is_last_pass
                        FROM tst_active
                        LEFT JOIN tst_sequence
                        ON tst_sequence.active_fi = tst_active.active_id
                        LEFT JOIN tst_tests
                        ON tst_tests.test_id = tst_active.test_fi
                        WHERE tst_active.user_fi = {$this->db->quote($a_usr_id, "integer")}
                        AND tst_active.test_fi = {$this->db->quote(ilObjTestAccess::_getTestIDFromObjectID($a_obj_id), ilDBConstants::T_INTEGER)}
                        GROUP BY tst_active.active_id, tst_active.tries, is_last_pass
                "
        );

        if (
            ($rec = $this->db->fetchAssoc($res))
            && $rec['sequences'] > 0
        ) {
            $test_obj = new ilObjTest($a_obj_id, false);
            $is_passed = ilObjTestAccess::_isPassed($a_usr_id, $a_obj_id);

            if ($test_obj->getPassScoring() === ilObjTest::SCORE_LAST_PASS) {
                $is_finished = false;
                if ($rec['last_finished_pass'] !== null && $rec['sequences'] - 1 === $rec['last_finished_pass']) {
                    $is_finished = true;
                }
                $status = $this->determineStatusForScoreLastPassTests(
                    $is_finished,
                    $is_passed
                );
            } elseif ($test_obj->getPassScoring() === ilObjTest::SCORE_BEST_PASS) {
                $status = self::LP_STATUS_IN_PROGRESS_NUM;

                if ($rec['last_finished_pass'] !== null) {
                    $status = $this->determineLpStatus($is_passed);
                }
            }
        }

        if ($old_status !== null
            && $old_status !== self::LP_STATUS_NOT_ATTEMPTED_NUM
            && $status === self::LP_STATUS_IN_PROGRESS_NUM) {
            return $old_status;
        }

        return $status;
    }

    protected function determineStatusForScoreLastPassTests(
        bool $is_finished,
        bool $passed
    ): int {
        $status = self::LP_STATUS_IN_PROGRESS_NUM;

        if ($is_finished) {
            $status = $this->determineLpStatus($passed);
        }

        return $status;
    }

    protected function determineLpStatus(bool $passed): int
    {
        $status = self::LP_STATUS_FAILED_NUM;

        if ($passed) {
            $status = self::LP_STATUS_COMPLETED_NUM;
        }

        return $status;
    }

    public function determinePercentage(
        int $a_obj_id,
        int $a_usr_id,
        ?object $a_obj = null
    ): int {
        $set = $this->db->query(
            "SELECT tst_result_cache.*, tst_active.user_fi FROM " .
            "tst_result_cache JOIN tst_active ON (tst_active.active_id = tst_result_cache.active_fi)" .
            " JOIN tst_tests ON (tst_tests.test_id = tst_active.test_fi) " .
            " WHERE tst_tests.obj_fi = " . $this->db->quote(
                $a_obj_id,
                "integer"
            ) .
            " AND tst_active.user_fi = " . $this->db->quote(
                $a_usr_id,
                "integer"
            )
        );
        $per = 0;
        if ($rec = $this->db->fetchAssoc($set)) {
            if ($rec["max_points"] > 0) {
                $per = (int) min(
                    100,
                    100 / $rec["max_points"] * $rec["reached_points"]
                );
            } else {
                // According to mantis #12305
                $per = 0;
            }
        }
        return (int) $per;
    }
}