<?php
session_start();
include "php/database.php";

if (!isset($_SESSION['loggedin'])) {
	header('Location: login.php');
	exit;
}

$index_page = false;
$page_title = "Bacheca";
$prev_page = "openHome()";

include "public/header.php";
?>

    
<div class="card card-style">
    <div class="content pb-3" style="text-align: center">
        <?php
        $sql = "SELECT * FROM bacheca ORDER BY id DESC";

        $result = mysqli_query($con, $sql);
        if ($result->num_rows > 0) {
            while ($row = mysqli_fetch_assoc($result)) {
            ?>
                <div class="card card-style" style="cursor:pointer" onclick="openBachecaDetail(<?php echo $row["id"] ?>)">
                    <div class="content" style="margin-bottom: 20px !important">
                        <div class="d-flex">
                            <div style="width: 100%;">
                                <?php
                                echo "<p class='font-11 mt-n2 mb-0 opacity-50'>" . date('d/m/Y H:i', strtotime($row["insert_date"])) . "</p>";
                                echo '<span style="width:90%; display: block"><b>' . $row["object"] . '</b></span>';

                                $sql_att     = "SELECT count(id) AS totale FROM bacheca_attachments WHERE id_bacheca='" . $row["id"] . "'";
                                $result_att  = mysqli_query($con, $sql_att);
                                $bacheca_att = mysqli_fetch_assoc($result_att);
                                if ($bacheca_att["totale"] > 0) {
                                echo "<i class='fa-solid fa-paperclip' style='float: right;font-size: 20px;'></i>";
                                }
                                ?>
                            </div>
                        </div>
                    </div>
                </div>
            <?php
            }
        } else {
            echo "<div class='content mb-2 mt-4'><h5 style='color:black;text-align: center; font-size: 20px; margin-top: 50px;margin-bottom: 50px;'>Non ci sono pubblicazioni in bacheca</h5></div>";
        }

        $con->close();
        ?>
    </div>
</div>

<?php include "public/footer.php" ?>