ViewedService::getDateViewedByMessageIdForEachUser

public function getDateViewedByMessageIdForEachUser(int $messageId, array $userIds): array
{
	if (empty($userIds))
	{
		return [];
	}

	$result = MessageViewedTable::query() //todo: add unique index (MESSAGE_ID, USER_ID, DATE_CREATE)
		->setSelect(['DATE_CREATE', 'USER_ID'])
		->whereIn('USER_ID', $userIds)
		->where('MESSAGE_ID', $messageId)
		->fetchAll()
	;

	$dateViewedByUsers = [];

	foreach ($result as $row)
	{
		$dateViewedByUsers[(int)$row['USER_ID']] = $row['DATE_CREATE'];
	}

	return $dateViewedByUsers;
}