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

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

$user_id = $_GET["user_id"];

$sql        = "SELECT * FROM users WHERE id='" . $user_id . "'";
$result     = mysqli_query($con, $sql);
$user = 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 = "SELECT COUNT(id) AS total FROM problems WHERE user_id = $user_id AND run_user_id = 0";
} else {
    $sql = "SELECT COUNT(id) AS total FROM problems WHERE user_id = $user_id AND run_user_id = " . $_SESSION["id"] . "";
}
?>
<h5 class="modal-title" id="exampleModalLabel"><b><?php echo $user["name"]; ?> <?php echo $user["surname"]; ?></b> - Calendario</h5>
<div style="position: absolute; text-align: center; width: 100%; top: 15px">
    <span class="badge badge-primary m-2" style="padding: 10px; margin-top: 0px !important; background-color: #2196f3">Entrate</span>
    <span class="badge badge-primary m-2" style="padding: 10px; margin-top: 0px !important; background-color: #009688">Uscite</span>
    <span class="badge badge-primary m-2" style="padding: 10px; margin-top: 0px !important; background-color: #ff9800">Permessi</span>
    <span class="badge badge-primary m-2" style="padding: 10px; margin-top: 0px !important; background-color: #f44336">Problemi</span>

    <?php

    $result = mysqli_query($con, $sql);
    $problems = mysqli_fetch_assoc($result);

    if ($problems["total"] > 0) {
    ?><button class="btn btn-outline-danger m-1" type="button" style="position: absolute; right: 30px" onclick="UserProblemsList(<?php echo $user_id; ?>,'<?php echo $start_date; ?>', '<?php echo $end_date; ?>')"> <?php echo $problems["total"]; ?> problemi rilevati</button><?php
                                                                                                                                                                                                                                                                                }
                                                                                                                                                                                                                                                                                    ?>
</div>
<hr style="margin-top: 20px; margin-bottom: 10px">
<div id='calendar'></div>