<?php
session_start();
include "php/database.php";

if (!isset($_SESSION['loggedin'])) {
	header('Location: login.php');
	exit;
}

$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 requests_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='" . $permission["user_id"] . "'";
$result_user = mysqli_query($con, $sql_user);
$user        = mysqli_fetch_assoc($result_user);

$index_page = false;
$page_title = "Info permesso ".$permission["id"];
$prev_page = "openPermissionsList()";

include "public/header.php";
?>

    
<div class="card bg-transparent mb-0">
    <div class="card card-style" style="padding-bottom: 10px;">
        <div class="content" style="text-align: center;">
            <div class="row">
                <div class="col-6">
                    <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>
                </div>
                <div class="col-6">
                    <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>
                </div>
                <div class="col-6">
                    <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>
                </div>
                <div class="col-6">
                    <?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 } ?> 
                </div>
                <div class="col-6">
                    <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>
                </div>
                <div class="col-6">
                    <?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 class="col-12">
                    <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>
                </div>
            </div>
            <div class="row">
                <?php 
                    if($permission["start_date"] <= date("Y-m-d")) { 
                        if($permission["start_date"] == date("Y-m-d") && $permission["start_time"] > date("H:i")) {
                            ?>
                            <div class="col align-self-center"><button type="button" 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" style="margin: auto; background-color: red !important">Elimina</button></div>
                            <?php if($permission["status_id"] == 1) { 
                                ?><div class="col align-self-center"><button type="button" onclick="editPermission(<?php echo $permission['id']; ?>)" class="btn btn-m btn-full mb-3 rounded-0 text-uppercase font-900 shadow-s bg-dark-dark" style="margin: auto; background-color: black !important">Modifica</button></div><?php
                            }
                        } else {
                            echo "<br><p style='color: red'>Si possono eliminare/modificare solo richieste future.</p>";
                        }
                    } else {
                        ?>
                        <div class="col align-self-center"><button type="button" 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" style="margin: auto; background-color: red !important">Elimina</button></div>
                        <?php if($permission["status_id"] == 1) { 
                            ?><div class="col align-self-center"><button type="button" onclick="editPermission(<?php echo $permission['id']; ?>)" class="btn btn-m btn-full mb-3 rounded-0 text-uppercase font-900 shadow-s bg-dark-dark" style="margin: auto; background-color: black !important">Modifica</button></div><?php
                        }
                    } 
                ?>
            </div>
        </div>
    </div>

    <?php
    $con->close();
    ?>
</div>

<?php include "public/footer.php" ?>