<?php
include "../database.php";
session_start();
$id = $_GET["id"];

$sql        = "SELECT * FROM permissions WHERE id='" . $id . "'";
$result     = mysqli_query($con, $sql);
$permission = mysqli_fetch_assoc($result);

$sql_justifications    = "SELECT * FROM justifications WHERE id='" . $permission["justification_id"] . "'";
$result_justifications = mysqli_query($con, $sql_justifications);
$justification         = mysqli_fetch_assoc($result_justifications);

$sql_status    = "SELECT * FROM justification_status WHERE id='" . $permission["status_id"] . "'";
$result_status = mysqli_query($con, $sql_status);
$status        = mysqli_fetch_assoc($result_status);

$sql_user    = "SELECT * FROM users WHERE id='" . $justification["user_id"] . "'";
$result_user = mysqli_query($con, $sql_user);
$user        = mysqli_fetch_assoc($result_user);
?>
<h3 style="text-align: center;"><?php echo $user["name"] ?> <?php echo $user["surname"] ?></h3>
<div class="card card-style" style="padding-bottom: 10px;">
    <div class="content">

        <div class="d-flex">
            <div>
            <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Data richiesta</h5>
            <p class="font-16 mb-0">
                <?php echo date("d/m/Y H:i", strtotime($permission["permission_datetime"])); ?>
            </p>

            <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Giustificativo</h5>
            <p class="font-16 mb-0">
                <?php echo $justification["name"]; ?>
            </p>

            <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Data inizio/fine</h5>
            <p class="font-16 mb-0">
                <?php echo date("d/m/Y", strtotime($permission["start_date"])) ?> - <?php echo date("d/m/Y", strtotime($permission["end_date"])) ?>
            </p>
            <?php
if ($permission["full_day"] != 0) {
 ?>
                <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Giornata intera</h5>
                <p class="font-16 mb-0">Sì</p>
<?php
}
?>

            <?php
if ($permission["full_day"] == 0) {
 ?>
            <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Ora inizio/fine</h5>
            <p class="font-16 mb-0">
                <?php echo date("H:i", strtotime($permission["start_time"])) ?> - <?php echo date("H:i", strtotime($permission["end_time"])) ?>
            </p>
            <?php
}
?>
            <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Note</h5>
            <p class="font-16 mb-0">
                <?php echo $permission["note"] ?>
            </p>
            <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Stato</h5>
            <p class="font-16 mb-0">
                <?php echo $status["name"] ?>
            </p>

            <?php
if ($permission["managed_by"] != "") {
 ?>
            <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Gestito da</h5>
            <p class="font-16 mb-0">
                <?php echo $permission["managed_by"] ?>
            </p>
            <?php
}
?>
            </div>

        </div>
        <br><br>
        <?php
if ($permission["status_id"] == 1 && $_SESSION['role'] == "admin") {
 ?>
        <a onclick="managePermission('approvato',<?php echo $permission['id']; ?>)" class="btn btn-m btn-full mb-3 rounded-0 text-uppercase font-900 shadow-s bg-green">Approva</a>
        <a onclick="managePermission('rifiutato',<?php echo $permission['id']; ?>)" class="btn bnt-icon btn-m btn-full mb-3 rounded-0 text-uppercase font-900 shadow-s bg-red-light">Rifiuta</a>
        <?php
}
?>
        <a onclick="deletePermission(<?php echo $permission['id']; ?>)" class="btn btn-m btn-full mb-3 rounded-0 text-uppercase font-900 shadow-s bg-dark-dark">Elimina</a>
    </div>
</div>

<?php
$con->close();
?>