<?php
$online_users = dbquery("SELECT
    o.online_user, u.user_id, u.user_name, u.user_avatar, u.user_status, u.user_groups
    FROM ".DB_ONLINE." o
    LEFT JOIN ".DB_USERS." u ON o.online_user = u.user_id
");
$offline_users = dbquery("SELECT
    user_id, user_name, user_lastvisit, user_avatar, user_status, user_groups
    FROM ".DB_USERS."
    WHERE user_lastvisit < :time
    ORDER BY user_lastvisit DESC
    LIMIT :limit
", [
    ':time' => time() - 10,
    ':limit' => max(10 - $online_users->num_rows, 0)
]);
$result[] = $online_users;
$result[] = $offline_users;
?>
<div class='scapmain'><img src='<?php echo THEME; ?>assets/img/panel-s.png' style='vertical-align: middle; margin-left: 15px;' alt='' /><span>KTO JE ONLINE?</span></div>
<div class='scapmain-body no-padding'>
    <ul class="online-user-panel">
    <?php
        foreach ($result as $object) {
            if (dbrows($object)) {
                while ($user_data = dbarray($object)) {
                    echo '<li>';
                        if (!empty($user_data['user_groups'])) {
                            $groups = [];
                            $groups_db = explode('.', $user_data['user_groups']);
                            asort($groups_db);
                            array_shift($groups_db);
                            $nickcolor = 'inherit';
                            $index = 0;
                            foreach ($groups_db as $group_id) {
                                $group = dbarray(dbquery("SELECT * FROM ".DB_USER_GROUPS." WHERE group_id = :group_id", [':group_id' => $group_id]));
                                $color = "inherit";
                                if ( !empty($group['group_color']) ) {
                                    $color = $group['group_color'];
                                    if ( $index == 0 )
                                        $nickcolor = $group['group_color'];
                                }
                                $groups[] = '<a href="'.BASEDIR.'profile.php?group_id='.$group_id.'" class="group" style="color: '.$color.'">'.$group['group_name'].'</a>';
                                $index++;
                                unset($group);
                            }
                        }
                        $isonline = empty($user_data['user_lastvisit']) ? 'avatar-online' : 'avatar-offline';
                        echo '<div class="'.$isonline.'">';
                            echo display_avatar($user_data, '35px', '', TRUE, 'img-rounded');
                        echo '</div>';
                        echo '<div class="d-flex justify-content-between flex-grow">';
                            echo '<div>';
                                echo '<a href="'.BASEDIR.'profile.php?lookup='.$user_data['user_id'].'"><span style="color: '.$nickcolor.'">'.$user_data['user_name'].'</span></a>';
                                echo '<div class="groups">';
                                    echo implode(', ', $groups);
                                echo '</div>';
                            echo '</div>';
                            if ( !empty($user_data['user_lastvisit']) ) {
                                echo '<span class="when-online">';
                                    echo timer($user_data['user_lastvisit']);
                                echo '</span>';
                            }

                        echo '</div>';
                    echo '</li>';
                }
            }
        }
    ?>
    </ul>
</div>