<?php
include "../database.php";
session_start();
$id = $_GET["id"];

$sql      = "SELECT * FROM transfer WHERE id='" . $id . "'";
$result   = mysqli_query($con, $sql);
$transfer = mysqli_fetch_assoc($result);

$sql_status    = "SELECT * FROM justification_status WHERE id='" . $transfer["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($transfer["request_datetime"])); ?>
            </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($transfer["start_date"])) ?> - <?php echo date("d/m/Y", strtotime($transfer["end_date"])) ?>
            </p>

            <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Destinazione</h5>
            <p class="font-16 mb-0">
                <?php echo $transfer["destination"] ?>
            </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 ($transfer["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 $transfer["managed_by"] ?>
            </p>
            <?php
}
?>
            </div>

        </div>
        <br><br>
        <?php
if ($transfer["status_id"] == 1 && $_SESSION['role'] == "admin") {
 ?>
        <a onclick="manageTransfer('approvato',<?php echo $transfer["id"]; ?>)" class="btn btn-m btn-full mb-3 rounded-0 text-uppercase font-900 shadow-s bg-dark-dark">Approva</a>
        <a onclick="manageTransfer('rifiutato',<?php echo $transfer["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="deleteTransfer(<?php echo $transfer["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();
?>