ilTestTopList Class Reference

Class ilTestTopList. More...

Collaboration diagram for ilTestTopList:

Public Member Functions
	__construct (ilObjTest $a_object)
	getUserToplistByWorkingtime (int $a_test_ref_id, int $a_user_id)
	getGeneralToplistByPercentage (int $a_test_ref_id, int $a_user_id)
	getGeneralToplistByWorkingtime (int $a_test_ref_id, int $a_user_id)
	getUserToplistByPercentage (int $a_test_ref_id, int $a_user_id)

Private Member Functions
	getResultTableRow (array $row, int $i, int $usrId)
	formatTime (int $seconds)

Private Attributes
	$object
	$db

Detailed Description

Class ilTestTopList.

Definition at line 7 of file class.ilTestTopList.php.

Constructor & Destructor Documentation

__construct()

ilTestTopList::__construct

(

ilObjTest

$a_object

)

Parameters

ilObjTest

$a_object

Definition at line 17 of file class.ilTestTopList.php.

References $DIC.

    {
        global $DIC;

        $this->object = $a_object;
        $this->db = $DIC->database();
    }

Member Function Documentation

formatTime()

ilTestTopList::formatTime ( int  $seconds )

private

Parameters

int

$seconds

Returns

string

Definition at line 438 of file class.ilTestTopList.php.

Referenced by getResultTableRow().

                                              : string
    {
        $retval = '';
        $hours = intval(intval($seconds) / 3600);
        $retval .= str_pad($hours, 2, "0", STR_PAD_LEFT) . ":";
        $minutes = intval(($seconds / 60) % 60);
        $retval .= str_pad($minutes, 2, "0", STR_PAD_LEFT) . ":";
        $seconds = intval($seconds % 60);
        $retval .= str_pad($seconds, 2, "0", STR_PAD_LEFT);

        return $retval;
    }

Here is the caller graph for this function:

getGeneralToplistByPercentage()

ilTestTopList::getGeneralToplistByPercentage	(	int	$a_test_ref_id,
		int	$a_user_id
	)

Parameters

int	$a_test_ref_id
int	$a_user_id

Returns

array

Definition at line 179 of file class.ilTestTopList.php.

References $data, $i, $result, and getResultTableRow().

                                                                                      : array
    {
        $this->db->setLimit($this->object->getHighscoreTopNum(), 0);
        $result = $this->db->query(
            '
                        SELECT tst_result_cache.*, round(points/maxpoints*100,2) as percentage, tst_pass_result.workingtime, usr_data.usr_id, usr_data.firstname, usr_data.lastname
                        FROM object_reference
                        INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                        INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                        INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                        INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi AND tst_pass_result.pass = tst_result_cache.pass
                        INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi
                        WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                        ORDER BY percentage DESC'
        );

        $i = 0;
        $data = [];

        while ($row = $this->db->fetchAssoc($result)) {
            $i++;
            $item = $this->getResultTableRow($row, $i, $a_user_id);

            $data[] = $item;
        }

        return $data;
    }

Here is the call graph for this function:

getGeneralToplistByWorkingtime()

ilTestTopList::getGeneralToplistByWorkingtime	(	int	$a_test_ref_id,
		int	$a_user_id
	)

Parameters

int	$a_test_ref_id
int	$a_user_id

Returns

array

Definition at line 213 of file class.ilTestTopList.php.

References $data, $i, $result, and getResultTableRow().

                                                                                       : array
    {
        $this->db->setLimit($this->object->getHighscoreTopNum(), 0);
        $result = $this->db->query(
            '
                        SELECT tst_result_cache.*, round(points/maxpoints*100,2) as percentage, tst_pass_result.workingtime, usr_data.usr_id, usr_data.firstname, usr_data.lastname
                        FROM object_reference
                        INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                        INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                        INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                        INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi AND tst_pass_result.pass = tst_result_cache.pass
                        INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi
                        WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                        ORDER BY workingtime ASC'
        );

        $i = 0;
        $data = [];

        while ($row = $this->db->fetchAssoc($result)) {
            $i++;
            $item = $this->getResultTableRow($row, $i, $a_user_id);
            $data[] = $item;
        }

        return $data;
    }

Here is the call graph for this function:

getResultTableRow()

ilTestTopList::getResultTableRow ( array  $row, int  $i, int  $usrId  )

private

Parameters

array	$row
int	$i
int	$usrId

Returns

array

Exceptions

ilDateTimeException

Definition at line 397 of file class.ilTestTopList.php.

References formatTime(), and IL_CAL_UNIX.

Referenced by getGeneralToplistByPercentage(), getGeneralToplistByWorkingtime(), getUserToplistByPercentage(), and getUserToplistByWorkingtime().

                                                                       : array
    {
        $item = [];

        $item['rank'] = $i . '. ';

        if ($this->object->isHighscoreAnon() && (int) $row['usr_id'] !== $usrId) {
            $item['participant'] = '-, -';
        } else {
            $item['participant'] = $row['lastname'] . ', ' . $row['firstname'];
        }

        if ($this->object->getHighscoreAchievedTS()) {
            $item['achieved'] = new ilDateTime($row['tstamp'], IL_CAL_UNIX);
        }

        if ($this->object->getHighscoreScore()) {
            $item['score'] = $row['reached_points'] . ' / ' . $row['max_points'];
        }

        if ($this->object->getHighscorePercentage()) {
            $item['percentage'] = $row['percentage'] . '%';
        }

        if ($this->object->getHighscoreHints()) {
            $item['hints'] = $row['hint_count'];
        }

        if ($this->object->getHighscoreWTime()) {
            $item['time'] = $this->formatTime((int) $row['workingtime']);
        }

        $item['is_actor'] = ((int) $row['usr_id'] === $usrId);

        return $item;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getUserToplistByPercentage()

ilTestTopList::getUserToplistByPercentage	(	int	$a_test_ref_id,
		int	$a_user_id
	)

Parameters

int	$a_test_ref_id
int	$a_user_id

Returns

array

Definition at line 246 of file class.ilTestTopList.php.

References $data, $i, $result, and getResultTableRow().

                                                                                   : array
    {
        $result = $this->db->query(
            '
                        SELECT COUNT(tst_pass_result.workingtime) cnt
                        FROM object_reference
                        INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                        INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                        INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                        INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                AND tst_pass_result.pass = tst_result_cache.pass
                        INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi
                        WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                        AND tst_active.user_fi != ' . $this->db->quote($a_user_id, 'integer') . '
                        AND round(reached_points/max_points*100) >=
                        (
                                SELECT round(reached_points/max_points*100)
                                FROM object_reference
                                INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                                INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                                INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                                INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                        AND tst_pass_result.pass = tst_result_cache.pass
                                WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                                AND tst_active.user_fi = ' . $this->db->quote($a_user_id, 'integer') . '
                        )
                '
        );
        $row = $this->db->fetchAssoc($result);
        $better_participants = $row['cnt'];
        $own_placement = $better_participants + 1;

        $result = $this->db->query(
            '
                        SELECT COUNT(tst_pass_result.workingtime) cnt
                        FROM object_reference
                        INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                        INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                        INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                        INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                AND tst_pass_result.pass = tst_result_cache.pass
                        INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi
                        WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer')
        );
        $row = $this->db->fetchAssoc($result);
        $number_total = $row['cnt'];

        $result = $this->db->query(
            '
                SELECT tst_result_cache.*, round(reached_points/max_points*100) as percentage ,
                        tst_pass_result.workingtime, usr_id, usr_data.firstname, usr_data.lastname
                FROM object_reference
                INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                        AND tst_pass_result.pass = tst_result_cache.pass
                INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi

                WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                AND tst_active.user_fi = ' . $this->db->quote($a_user_id, 'integer') . '

                UNION(
                        SELECT tst_result_cache.*, round(reached_points/max_points*100) as percentage,
                                tst_pass_result.workingtime, usr_id, usr_data.firstname, usr_data.lastname
                        FROM object_reference
                        INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                        INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                        INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                        INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                AND tst_pass_result.pass = tst_result_cache.pass
                        INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi
                        WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                        AND tst_active.user_fi != ' . $this->db->quote($a_user_id, 'integer') . '
                        AND round(reached_points/max_points*100) >=
                        (
                                SELECT round(reached_points/max_points*100)
                                FROM object_reference
                                INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                                INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                                INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                                INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                        AND tst_pass_result.pass = tst_result_cache.pass
                                WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                                AND tst_active.user_fi = ' . $this->db->quote($a_user_id, 'integer') . '
                        )
                        ORDER BY round(reached_points/max_points*100) ASC
                        LIMIT 0,3
                )
                UNION(
                        SELECT tst_result_cache.*, round(reached_points/max_points*100) as percentage,
                                tst_pass_result.workingtime, usr_id, usr_data.firstname, usr_data.lastname
                        FROM object_reference
                        INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                        INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                        INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                        INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                AND tst_pass_result.pass = tst_result_cache.pass
                        INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi
                        WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                        AND tst_active.user_fi != ' . $this->db->quote($a_user_id, 'integer') . '
                        AND round(reached_points/max_points*100) <=
                        (
                                SELECT round(reached_points/max_points*100)
                                FROM object_reference
                                INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                                INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                                INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                                INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                        AND tst_pass_result.pass = tst_result_cache.pass
                                WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                                AND tst_active.user_fi = ' . $this->db->quote($a_user_id, 'integer') . '
                        )
                        ORDER BY round(reached_points/max_points*100) ASC
                        LIMIT 0,3
                )
                ORDER BY round(reached_points/max_points*100) DESC, tstamp ASC
                LIMIT 0, 7
                '
        );

        $i = $own_placement - (($better_participants >= 3) ? 3 : $better_participants);

        $data = [];

        if ($i > 1) {
            $item = ['Rank' => '...'];
            $data[] = $item;
        }

        while ($row = $this->db->fetchAssoc($result)) {
            $item = $this->getResultTableRow($row, $i, $a_user_id);
            $i++;
            $data[] = $item;
        }

        if ($number_total > $i) {
            $item = ['Rank' => '...'];
            $data[] = $item;
        }

        return $data;
    }

Here is the call graph for this function:

getUserToplistByWorkingtime()

ilTestTopList::getUserToplistByWorkingtime	(	int	$a_test_ref_id,
		int	$a_user_id
	)

Parameters

int	$a_test_ref_id
int	$a_user_id

Returns

array

Definition at line 30 of file class.ilTestTopList.php.

References $data, $i, $result, and getResultTableRow().

                                                                                    : array
    {
        $result = $this->db->query(
            '
                        SELECT COUNT(tst_pass_result.workingtime) cnt
                        FROM object_reference
                        INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                        INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                        INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                        INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                AND tst_pass_result.pass = tst_result_cache.pass
                        INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi
                        WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                        AND tst_active.user_fi != ' . $this->db->quote($a_user_id, 'integer') . '
                        AND workingtime <
                        (
                                SELECT workingtime
                                FROM object_reference
                                INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                                INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                                INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                                INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                        AND tst_pass_result.pass = tst_result_cache.pass
                                WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                                AND tst_active.user_fi = ' . $this->db->quote($a_user_id, 'integer') . '
                        )
                '
        );
        $row = $this->db->fetchAssoc($result);
        $better_participants = $row['cnt'];
        $own_placement = $better_participants + 1;

        $result = $this->db->query(
            '
                        SELECT COUNT(tst_pass_result.workingtime) cnt
                        FROM object_reference
                        INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                        INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                        INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                        INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                AND tst_pass_result.pass = tst_result_cache.pass
                        INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi
                        WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer')
        );
        $row = $this->db->fetchAssoc($result);
        $number_total = $row['cnt'];

        $result = $this->db->query(
            '
                SELECT tst_result_cache.*, round(reached_points/max_points*100) as percentage ,
                        tst_pass_result.workingtime, usr_id, usr_data.firstname, usr_data.lastname
                FROM object_reference
                INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                        AND tst_pass_result.pass = tst_result_cache.pass
                INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi

                WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                AND tst_active.user_fi = ' . $this->db->quote($a_user_id, 'integer') . '

                UNION(
                        SELECT tst_result_cache.*, round(reached_points/max_points*100) as percentage,
                                tst_pass_result.workingtime, usr_id, usr_data.firstname, usr_data.lastname
                        FROM object_reference
                        INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                        INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                        INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                        INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                AND tst_pass_result.pass = tst_result_cache.pass
                        INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi
                        WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                        AND tst_active.user_fi != ' . $this->db->quote($a_user_id, 'integer') . '
                        AND workingtime >=
                        (
                                SELECT tst_pass_result.workingtime
                                FROM object_reference
                                INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                                INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                                INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                                INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                        AND tst_pass_result.pass = tst_result_cache.pass
                                WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                                AND tst_active.user_fi = ' . $this->db->quote($a_user_id, 'integer') . '
                        )
                        ORDER BY workingtime DESC
                        LIMIT 0,3
                )
                UNION(
                        SELECT tst_result_cache.*, round(reached_points/max_points*100) as percentage,
                                tst_pass_result.workingtime, usr_id, usr_data.firstname, usr_data.lastname
                        FROM object_reference
                        INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                        INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                        INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                        INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                AND tst_pass_result.pass = tst_result_cache.pass
                        INNER JOIN usr_data ON usr_data.usr_id = tst_active.user_fi
                        WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                        AND tst_active.user_fi != ' . $this->db->quote($a_user_id, 'integer') . '
                        AND workingtime <
                        (
                                SELECT tst_pass_result.workingtime
                                FROM object_reference
                                INNER JOIN tst_tests ON object_reference.obj_id = tst_tests.obj_fi
                                INNER JOIN tst_active ON tst_tests.test_id = tst_active.test_fi
                                INNER JOIN tst_result_cache ON tst_active.active_id = tst_result_cache.active_fi
                                INNER JOIN tst_pass_result ON tst_active.active_id = tst_pass_result.active_fi
                                        AND tst_pass_result.pass = tst_result_cache.pass
                                WHERE object_reference.ref_id = ' . $this->db->quote($a_test_ref_id, 'integer') . '
                                AND tst_active.user_fi = ' . $this->db->quote($a_user_id, 'integer') . '
                        )
                        ORDER BY workingtime DESC
                        LIMIT 0,3
                )
                ORDER BY workingtime ASC
                LIMIT 0, 7
                '
        );

        $i = $own_placement - (($better_participants >= 3) ? 3 : $better_participants);

        $data = [];

        if ($i > 1) {
            $item = ['Rank' => '...'];
            $data[] = $item;
        }

        while ($row = $this->db->fetchAssoc($result)) {
            $item = $this->getResultTableRow($row, $i, $a_user_id);
            $i++;
            $data[] = $item;
        }

        if ($number_total > $i) {
            $item = ['Rank' => '...'];
            $data[] = $item;
        }

        return $data;
    }

Here is the call graph for this function:

Field Documentation

$db

ilTestTopList::$db

private

Definition at line 12 of file class.ilTestTopList.php.

$object

ilTestTopList::$object

private

Definition at line 10 of file class.ilTestTopList.php.

---

The documentation for this class was generated from the following file:

• Modules/Test/classes/class.ilTestTopList.php