<?php
include "../database.php";
session_start();

$id = $_GET["id"];

$sql     = "SELECT * FROM bacheca WHERE id='" . $id . "'";
$result  = mysqli_query($con, $sql);
$bacheca = mysqli_fetch_assoc($result);
?>

<div class="content pb-3">
    <h4>Data</h4>
    <div class="input-style has-borders no-icon mb-4">
        <p><?php echo date("d/m/Y H:i", strtotime($bacheca["insert_date"])); ?></p>
    </div>

    <h4>Oggetto</h4>
    <div class="input-style has-borders no-icon mb-4">
        <p><?php echo $bacheca["object"]; ?></p>
    </div>

    <h4>Corpo</h4>
    <div class="input-style has-borders no-icon mb-4">
        <p><?php echo nl2br($bacheca["body"]); ?></p>
    </div>

    <hr>

    <div class="content mb-2">
        <h5 class="float-start font-16 font-500" style="font-weight:900;text-align: center;width: 100%;">Allegati</h5>
        <div class="clearfix"></div>
    </div>

    <div class="card card-style pt-3">
        <?php
$index  = false;
$sql    = "SELECT * FROM bacheca_attachments WHERE id_bacheca=" . $bacheca["id"] . "";
$result = mysqli_query($con, $sql);
while ($attachments = mysqli_fetch_assoc($result)) {
 $index = true;
 ?>
            <a href="/bacheca_attachments/<?php echo $attachments["file_name"]; ?>" target="_blank">
                <div class="d-flex px-3 mb-3">
                    <div class="align-self-center">
                        <i class="fa fa-file-alt font-26 pe-3 pt-1 color-gray-dark"></i>
                    </div>
                    <div class="align-self-center me-auto">
                        <h4 class="font-13 mb-n1 mt-n1 font-600" style="color: #424242"><?php echo $attachments["file_name"]; ?></h4>
                        <p class="mb-0 mt-n2"><a href="#" class="color-theme opacity-30 font-11 font-400"><?php echo $attachments["file_size"]; ?> bytes, <?php echo $attachments["file_type"]; ?></a></p>
                    </div>
                    <div class="align-self-center ms-auto">
                        <a href="/bacheca_attachments/<?php echo $attachments["file_name"]; ?>" target="_blank" download>
                            <i class="fa fa-download font-16 opacity-30" style="cursor:pointer"></i>
                        </a>
                    </div>
                </div>
            </a>
        <?php
}

if ($index == false) {
 echo "<h4 class='mb-n1' style='padding-bottom: 20px;margin-left:20px; font-weight:300; color:#424242'>Nessun allegato caricato</h4>";
}
?>

    </div>
    </div>
</div>


<!-- <a href="#" data-menu="menu-wizard-5" class="btn btn-full rounded-sm btn-m btn-margins bg-highlight font-700 text-uppercase" style="margin-bottom: 15px;" onclick="openBacheca()">Chiudi</a> -->
<?php
if ($_SESSION['role'] == "admin") {
 ?>
    <a href="#" data-menu="menu-wizard-5" class="btn btn-full rounded-sm btn-m btn-margins bg-highlight font-700 text-uppercase" style="background-color: red !important" onclick="deleteBacheca(<?php echo $bacheca["id"]; ?>)">Elimina</a>
    <?php
}
?>
