Collaboration diagram for ilTestTopList:

Public Member Functions
	__construct (private ilObjTest $object, private ilDBInterface $db)

	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)

	buildEmptyItem ()

Detailed Description

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

Constructor & Destructor Documentation

◆ __construct()

ilTestTopList::__construct	(	private ilObjTest	$object,
		private ilDBInterface	$db
	)

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

26 {

27 }

Member Function Documentation

◆ buildEmptyItem()

ilTestTopList::buildEmptyItem ( )

private

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

Referenced by getUserToplistByPercentage(), and getUserToplistByWorkingtime().

                                      : array
     {
         return [
             'rank' => '...' ,
             'is_actor' => false,
             'participant' => '',
             'achieved' => '',
             'score' => '',
             'percentage' => '',
             'hints' => '',
             'time' => ''
         ];
     }

Here is the caller graph for this function:

◆ formatTime()

ilTestTopList::formatTime ( int $seconds )

private

Parameters

int $seconds

Returns: string

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

Referenced by getResultTableRow().

                                              : string
     {
         $hours = floor($seconds / 3600);
         $seconds -= $hours * 3600;
         $minutes = floor($seconds / 60);
         $seconds -= $minutes * 60;
 
         return str_pad(number_format($hours, 0, '.', ''), 2, '0', STR_PAD_LEFT) . ":"
             . str_pad(number_format($minutes, 0, '.', ''), 2, '0', STR_PAD_LEFT) . ":"
             . str_pad(number_format($seconds, 0, '.', ''), 2, '0', STR_PAD_LEFT);
     }

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 183 of file class.ilTestTopList.php.

References $data, getResultTableRow(), and ILIAS\Repository\object().

                                                                                      : 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 217 of file class.ilTestTopList.php.

References $data, getResultTableRow(), and ILIAS\Repository\object().

                                                                                       : 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 402 of file class.ilTestTopList.php.

References formatTime(), IL_CAL_UNIX, ILIAS\Repository\int(), and ILIAS\Repository\object().

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 250 of file class.ilTestTopList.php.

References $data, buildEmptyItem(), getResultTableRow(), and ILIAS\Repository\object().

                                                                                   : 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, ' . $this->db->quote($this->object->getHighscoreTopNum(), '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, ' . $this->db->quote($this->object->getHighscoreTopNum(), 'integer') . '
                 )
                 ORDER BY round(reached_points/max_points*100) DESC, tstamp ASC
                 LIMIT 0, ' . $this->db->quote($this->object->getHighscoreTopNum(), 'integer') . '
                 '
         );
 
         $i = $own_placement - ($better_participants >= $this->object->getHighscoreTopNum()
             ? $this->object->getHighscoreTopNum() : $better_participants);
 
         $data = [];
 
         if ($i > 1) {
             $item = $this->buildEmptyItem();
             $data[] = $item;
         }
 
         while ($row = $this->db->fetchAssoc($result)) {
             $item = $this->getResultTableRow($row, $i, $a_user_id);
             $i++;
             $data[] = $item;
         }
 
         if ($number_total > $i) {
             $item = $this->buildEmptyItem();
             $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 34 of file class.ilTestTopList.php.

References $data, buildEmptyItem(), getResultTableRow(), and ILIAS\Repository\object().

                                                                                    : 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, ' . $this->db->quote($this->object->getHighscoreTopNum(), '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, ' . $this->db->quote($this->object->getHighscoreTopNum(), 'integer') . '
                 )
                 ORDER BY workingtime ASC
                 LIMIT 0, ' . $this->db->quote($this->object->getHighscoreTopNum(), 'integer') . '
                 '
         );
 
         $i = $own_placement - (($better_participants >= 3) ? 3 : $better_participants);
 
         $data = [];
 
         if ($i > 1) {
             $item = $this->buildEmptyItem();
             $data[] = $item;
         }
 
         while ($row = $this->db->fetchAssoc($result)) {
             $item = $this->getResultTableRow($row, $i, $a_user_id);
             $i++;
             $data[] = $item;
         }
 
         if ($number_total > $i) {
             $item = $this->buildEmptyItem();
             $data[] = $item;
         }
 
         return $data;
     }

Here is the call graph for this function:

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

Modules/Test/classes/class.ilTestTopList.php

Public Member Functions

Private Member Functions

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ buildEmptyItem()

◆ formatTime()

◆ getGeneralToplistByPercentage()

◆ getGeneralToplistByWorkingtime()

◆ getResultTableRow()

◆ getUserToplistByPercentage()

◆ getUserToplistByWorkingtime()