<?php
include "../database.php";
session_start();
?>

<div data-bs-parent="#tab-group-1" class="" id="new">
    <?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>";
}
?>
</div>

<?php
$con->close();
?>