<?php
session_start();
if (!isset($_SESSION['loggedin'])) {
    exit("unauthorized");
}

include "../../php/database.php";

?>

<h4 style="position: absolute;">Utenti</h4>
<table id="users_permission_table" class="display" style="width:100%">
    <thead>
        <tr>
            <th>Nome</th>
            <th>Cognome</th>
            <th>Azioni</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)) {
            $total = 0;
            $sql_approve    = "SELECT COUNT(id) AS total FROM permissions WHERE user_id = " . $row["id"] . " AND status_id = 1";
            $result_approve = mysqli_query($con, $sql_approve);
            $approve = mysqli_fetch_assoc($result_approve);
            $total += $approve["total"];

            $sql_approve    = "SELECT COUNT(id) AS total FROM permissions WHERE user_id = " . $row["id"] . " AND request_delete = 1";
            $result_approve = mysqli_query($con, $sql_approve);
            $approve = mysqli_fetch_assoc($result_approve);
            $total += $approve["total"];

            $sql_approve    = "SELECT COUNT(id) AS total FROM permissions WHERE user_id = " . $row["id"] . " AND request_update = 1";
            $result_approve = mysqli_query($con, $sql_approve);
            $approve = mysqli_fetch_assoc($result_approve);
            $total += $approve["total"];

            if ($total > 0) {
                echo "<tr id='" . $row["id"] . "' onclick='PermissionsListUser(" . $row["id"] . ")' style='cursor: pointer; color: red; font-weight: 900'>";
            } else {
                echo "<tr id='" . $row["id"] . "' onclick='PermissionsListUser(" . $row["id"] . ")' style='cursor: pointer'>";
            }
            echo "<td>" . $row["name"] . "</td>";
            echo "<td>" . $row["surname"] . "</td>";
            if ($total > 0) {
                echo "<td>" . $total . "</td>";
            } else {
                echo "<td></td>";
            }
            echo "</tr>";
        }
        ?>
    </tbody>
</table>