<?php
    session_start();
    if (!isset($_SESSION['loggedin'])) {
        exit("unauthorized");
    }
    
    include "../../php/database.php";

    $bacheca_id = $_GET["bacheca_id"];

    $sql = "SELECT COUNT(user_id) AS users_views FROM bacheca_views WHERE bacheca_id = $bacheca_id";
    $result = mysqli_query($con, $sql);
    $bacheca = mysqli_fetch_assoc($result);
    $users_views = $bacheca["users_views"];

    $sql = "SELECT COUNT(id) AS user_count FROM users";
    $result = mysqli_query($con, $sql);
    $users = mysqli_fetch_assoc($result);
    $users_count = $users["user_count"];
    $users_without_view = $users_count - $users_views;
?>
<div class="modal-header">
    <h5 class="modal-title" id="exampleModalLabel">Informazioni pubblicazione</h5>
    <button class="close" type="button" data-dismiss="modal" aria-label="Close"><span aria-hidden="true" id="close_info_bacheca">×</span></button>
</div>
<div class="modal-body">
    <div class="row justify-content-md-center">
        <!-- ICON BG-->
        <div class="col-lg-4 col-md-4 col-sm-4">
            <div class="card card-icon mb-4">
                <div class="card-body text-center"><i class="fa-regular fa-eye" style="font-size: 32px;"></i>
                    <p class="text-muted mt-2 mb-0" style="margin: auto;">Visualizzata da</p>
                    <p class="lead text-primary text-24 mb-2" style="margin: auto;margin-bottom: 0 !important;"><?php echo $users_views; ?></p>
                    <p class="text-muted mt-2 mb-0" style="margin: auto;margin-top: 0 !important">utenti</p>
                </div>
            </div>
        </div>
        <div class="col-lg-4 col-md-4 col-sm-4">
            <div class="card card-icon mb-4">
                <div class="card-body text-center"><i class="fa-regular fa-eye-slash" style="font-size: 32px;"></i>
                    <p class="text-muted mt-2 mb-0" style="margin: auto;">Non visualizzata da</p>
                    <p class="lead text-primary text-24 mb-2" style="margin: auto;margin-bottom: 0 !important;"><?php echo $users_without_view; ?></p>
                    <p class="text-muted mt-2 mb-0" style="margin: auto;margin-top: 0 !important">utenti</p>
                </div>
            </div>
        </div>
    </div>
    <hr>
    <h3>Utenti</h3>
    <table id="users_views_table" class="display" style="width:100%">
        <thead>
            <tr>
                <th>Nome</th>
                <th>Cognome</th>
                <th>Visualizzata</th>
            </tr>
        </thead>
        <tbody>
            <?php
            $sql    = "SELECT * FROM users ORDER BY name ASC";
            $result = mysqli_query($con, $sql);
            while ($row = mysqli_fetch_assoc($result)) {
                $sql_view = "SELECT * FROM bacheca_views WHERE bacheca_id = $bacheca_id AND user_id = ".$row["id"]."";
                $result_view = mysqli_query($con, $sql_view);

                echo "<tr id='". $row["id"] ."' onclick='StampsListUser(". $row["id"] .")' style='cursor: pointer'>";
                    echo "<td>". $row["name"] ."</td>";
                    echo "<td>". $row["surname"] ."</td>";
                    if($result_view->num_rows > 0) {
                        echo "<td>SI</td>";
                    } else {
                        echo "<td>NO</td>";
                    }
                echo "</tr>";
            }
            ?>
        </tbody>
    </table>
</div>

<div class="modal-footer">
    <button class="btn btn-secondary" type="button" data-dismiss="modal">Chiudi</button>
</div>