<?php
session_start();
if (!isset($_SESSION['loggedin'])) {
    exit("unauthorized");
}

include "../../php/database.php";
?>

<div class="inbox-main-sidebar-container sidebar-container" data-sidebar-container="main">
    <div class="inbox-main-content sidebar-content" data-sidebar-content="main">
        <div class="inbox-secondary-sidebar-container box-shadow-1 sidebar-container" data-sidebar-container="secondary" style="min-height: 600px; max-height: 600px;">
            <div data-sidebar-content="secondary" class="sidebar-content" style="margin-left: 360px;" id="bacheca_details_content">

            </div>

            <div class="inbox-secondary-sidebar perfect-scrollbar rtl-ps-none ps sidebar" data-sidebar="secondary" style="left: 0px; background-color: #fafafa;"><i class="sidebar-close i-Close" data-sidebar-toggle="secondary"></i>
                <?php
                $first = false;
                $sql    = "SELECT * FROM bacheca ORDER BY id DESC";
                $result = mysqli_query($con, $sql);
                if ($result->num_rows > 0) {
                    while ($row = mysqli_fetch_assoc($result)) {
                        $sql_user = "SELECT * FROM users WHERE id = " . $row["user_id"] . "";
                        $result_user = mysqli_query($con, $sql_user);
                        $user = mysqli_fetch_assoc($result_user);

                        if ($first == false) {
                            echo "<div class='mail-item' style='background-color: #e0e0e0' id='" . $row["id"] . "' onclick='bachecaDetails(" . $row['id'] . ")'>";
                            $first = true;
                        } else {
                            echo "<div class='mail-item' id='" . $row["id"] . "' onclick='bachecaDetails(" . $row['id'] . ")'>";
                        }
                        if ($_SESSION['gender'] == "M") {
                            echo "<div class='avatar'><img src='images/faces/male.png' alt=''></div>";
                        } else {
                            echo "<div class='avatar'><img src='images/faces/female.png' alt=''></div>";
                        }
                ?>
                        <div class="col-xs-6 details"><span class="name text-muted"><?php echo $user["name"]; ?> <?php echo $user["surname"]; ?></span>
                            <p class="m-0"><?php echo $row["object"]; ?></p>
                        </div>
                        <div class="col-xs-3 date">
                            <span class="text-muted"><?php echo date("d/m/Y", strtotime($row["insert_date"])); ?></span>
                            <?php
                            if ($_SESSION["role"] == "Utente") {
                                $sql_view = "SELECT * FROM bacheca_views WHERE user_id = " . $_SESSION["id"] . " AND bacheca_id = " . $row['id'] . "";
                                $result_view = mysqli_query($con, $sql_view);
                                if ($result_view->num_rows == 0) {
                                    echo "<span class='badge badge-pill badge-outline-danger p-2 m-1'>Nuova</span>";
                                }
                            }
                            ?>
                        </div>
            </div>
    <?php
                    }
                } else {
                    echo "<p style='margin-top: 20px;margin-left: 20px;'>Non ci sono pubblicazioni</p>";
                }
    ?>

    <!-- <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>
</div>
</div>