<?php
session_start();
include "php/database.php";

if (!isset($_SESSION['loggedin'])) {
	header('Location: login.php');
	exit;
}

$id = $_GET["id"];

$sql    = "SELECT * FROM transfers WHERE id='" . $id . "'";
$result = mysqli_query($con, $sql);
$transfer  = mysqli_fetch_assoc($result);

$sql_status    = "SELECT * FROM requests_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='" . $transfer["user_id"] . "'";
$result_user = mysqli_query($con, $sql_user);
$user        = mysqli_fetch_assoc($result_user);

$index_page = false;
$page_title = "Info trasferta ".$transfer["id"];
$prev_page = "openTransfersList()";

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-12">
                    <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>
                </div>
                <div class="col-6">
                    <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Data inizio</h5>
                    <p class="font-16 mb-0"><?php echo date("d/m/Y", strtotime($transfer["start_date"])) ?></p>
                </div>
                <div class="col-6">
                    <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Data fine</h5>
                    <p class="font-16 mb-0"><?php echo date("d/m/Y", strtotime($transfer["end_date"])) ?></p>
                </div>
                <div class="col-6">
                    <h5 class="font-16 font-500" style="font-weight:900; margin-top: 20px;">Luogo</h5>
                    <p class="font-16 mb-0"><?php echo $transfer["location"] ?></p>
                </div>
                <div class="col-6">
                    <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>
                </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 ($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>
            <div class="row">
                <?php 
                    if($transfer["start_date"] <= date("Y-m-d")) { 
                        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="deleteTransfer(<?php echo $transfer['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($transfer["status_id"] == 1) { 
                            ?><div class="col align-self-center"><button type="button" onclick="editTransfer(<?php echo $transfer['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" ?>