<?php
session_start();
if (!isset($_SESSION['loggedin'])) {
    exit("unauthorized");
}

include "../../php/database.php";
?>

<h4 style="position: absolute; top: 30px"><b>Utenti</b></h4>
<table id="users_situation_table" class="display" style="width:100%">
    <thead>
        <tr>
            <th>Nome</th>
            <th>Cognome</th>
            <th>Problemi</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $sql    = "SELECT * FROM users WHERE enable = 1 AND attendance = 1 ORDER BY name ASC";
        $result = mysqli_query($con, $sql);
        while ($row = mysqli_fetch_assoc($result)) {
            $sql_problems_range    = "SELECT * FROM problems_date_range WHERE user_id = 0";
            $result_problems_range = mysqli_query($con, $sql_problems_range);
            $last_update_problems = mysqli_fetch_assoc($result_problems_range);

            $sql_problems_range_user    = "SELECT * FROM problems_date_range WHERE user_id = " . $_SESSION["id"] . "";
            $result_problems_range_user = mysqli_query($con, $sql_problems_range_user);
            $last_update_problems_user = mysqli_fetch_assoc($result_problems_range_user);

            if ($last_update_problems["datetime"] >= $last_update_problems_user["datetime"]) {
                $sql_problems    = "SELECT COUNT(id) AS total FROM problems WHERE user_id = " . $row["id"] . " AND run_user_id = 0";
            } else {
                $sql_problems    = "SELECT COUNT(id) AS total FROM problems WHERE user_id = " . $row["id"] . " AND run_user_id = " . $_SESSION["id"] . "";
            }

            $result_preblems = mysqli_query($con, $sql_problems);
            $problems_decod = mysqli_fetch_assoc($result_preblems);

            if ($problems_decod["total"] > 0) {
                echo "<tr id='" . $row["id"] . "' onclick='UserCalendar(" . $row["id"] . ")' style='cursor: pointer; color: red'>";
            } else {
                echo "<tr id='" . $row["id"] . "' onclick='UserCalendar(" . $row["id"] . ")' style='cursor: pointer'>";
            }
            echo "<td>" . $row["name"] . "</td>";
            echo "<td>" . $row["surname"] . "</td>";
            if ($problems_decod["total"] > 0) {
                echo "<td style='color: red; font-weight: 900'>" . $problems_decod["total"] . "</td>";
            } else {
                echo "<td></td>";
            }
            echo "</tr>";
        }
        ?>
    </tbody>
</table>