<?php
session_start();
if (!isset($_SESSION['loggedin'])) {
    exit("unauthorized");
}

include "../../php/database.php";

$bacheca_id = $_GET["bacheca_id"];

$sql = "SELECT * FROM bacheca WHERE id = $bacheca_id";
$result = mysqli_query($con, $sql);
$bacheca = mysqli_fetch_assoc($result);

$sql_user = "SELECT * FROM users WHERE id = " . $bacheca["user_id"] . "";
$result_user = mysqli_query($con, $sql_user);
$user = mysqli_fetch_assoc($result_user);

if ($_SESSION["role"] == "Utente") {
    $sql_view = "SELECT * FROM bacheca_views WHERE user_id = " . $_SESSION["id"] . " AND bacheca_id = $bacheca_id";
    $result_view = mysqli_query($con, $sql_view);
    if ($result_view->num_rows == 0) {
        $sql_insert = "INSERT INTO bacheca_views VALUES (" . $_SESSION["id"] . ", $bacheca_id)";
        $con->query($sql_insert);
    }
}
?>

<div class="inbox-secondary-sidebar-content position-relative" style="min-height: 500px">
    <div class="inbox-topbar box-shadow-1 perfect-scrollbar rtl-ps-none pl-3 ps" data-suppress-scroll-y="true" style="background-color: #fafafa;">
        <a class="link-icon d-md-none" data-sidebar-toggle="main"><i class="icon-regular i-Arrow-Turn-Left"></i></a>
        <a class="link-icon mr-3 d-md-none" data-sidebar-toggle="secondary"><i class="icon-regular mr-1 i-Left-3"></i> Inbox</a>
        <div class="d-flex">
            <?php if ($_SESSION["role"] == "Admin") { ?>
                <button class="btn btn-outline-success m-1" type="button" onclick="InfoBacheca(<?php echo $bacheca['id']; ?>)"><i class="fa-solid fa-circle-info"></i> Info</button>
                <button class="btn btn-outline-secondary m-1" type="button" onclick="EditBacheca(<?php echo $bacheca['id']; ?>)"><i class="fa-regular fa-pen-to-square"></i> Modifica</button>
                <button class="btn btn-outline-danger m-1" type="button" onclick="deleteBacheca(<?php echo $bacheca['id']; ?>)"><i class="fa-regular fa-trash-can"></i> Elimina</button>
            <?php } ?>
        </div>
        <!-- <div class="ps__rail-x" style="left: 0px; bottom: 0px;">
            <div class="ps__thumb-x" tabindex="0" style="left: 0px; width: 0px;"></div>
        </div>
        <div class="ps__rail-y" style="top: 0px; right: 0px;">
            <div class="ps__thumb-y" tabindex="0" style="top: 0px; height: 0px;"></div>
        </div> -->
    </div>

    <div class="inbox-details perfect-scrollbar rtl-ps-none ps" data-suppress-scroll-x="true">
        <div class="row no-gutters">
            <?php
            if ($_SESSION['gender'] == "M") {
                echo "<div class='mr-2' style='width: 36px'><img class='rounded-circle' src='images/faces/male.png' alt=''></div>";
            } else {
                echo "<div class='mr-2' style='width: 36px'><img class='rounded-circle' src='images/faces/female.png' alt=''></div>";
            }
            ?>
            <div class="col-xs-12">
                <p class="m-0"><?php echo $user["name"]; ?> <?php echo $user["surname"]; ?></p>
                <p class="text-12 text-muted"><?php echo date("d/m/Y", strtotime($bacheca["insert_date"])); ?></p>
            </div>
        </div>
        <h4 class="mb-3"><?php echo $bacheca["object"]; ?></h4>
        <div>
            <p><?php echo $bacheca["body"]; ?></p>
        </div>

        <div class="row">
            <?php
            $sql    = "SELECT * FROM bacheca_attachments WHERE id_bacheca=" . $bacheca["id"] . "";
            $result = mysqli_query($con, $sql);
            while ($attachments = mysqli_fetch_assoc($result)) {
            ?>
                <div class="col-md-auto">
                    <div class="card card-icon-big mb-4">
                        <div class="card-body text-center" style="padding: 5px !important;">
                            <p class="lead text-18 mt-2 mb-0" style="font-size: 16px;"><a href="../attachments/<?php echo $attachments["file_name"]; ?>" target="_blank"><?php echo substr($attachments["file_name"], 0, 20); ?></a></p>
                            <a href="../attachments/<?php echo $attachments["file_name"]; ?>" target="_blank" download><i class="i-Data-Download" style="font-size: 30px;"></i></a>
                        </div>
                    </div>
                </div>
            <?php
            }
            ?>
        </div>
        <!-- <div class="ps__rail-x" style="left: 0px; bottom: 0px;">
            <div class="ps__thumb-x" tabindex="0" style="left: 0px; width: 0px;"></div>
        </div>
        <div class="ps__rail-y" style="top: 0px; right: 0px;">
            <div class="ps__thumb-y" tabindex="0" style="top: 0px; height: 0px;"></div>
        </div> -->
    </div>
</div>