<?php
include "../../php/database.php";

$present_user = 0;
$sql = "SELECT * FROM users WHERE role = 'Utente'";
$result_users = mysqli_query($con, $sql);
while ($users = mysqli_fetch_assoc($result_users)) {
    $sql_stamps = "SELECT * FROM stamps WHERE user_id=" . $users["id"] . " AND date = '" . date("Y-m-d") . "'";
    $result_stamps = mysqli_query($con, $sql_stamps);
    if ($result_stamps->num_rows > 0) {
        $present_user++;
    }
}

if ($_SESSION["role"] == "Admin") {
?>
    <div class="col-lg-3 col-md-3 col-sm-3">
        <div class="card card-icon-bg card-icon-bg-primary o-hidden mb-4">
            <div class="card-body text-center" style="padding: 0.6rem;"><i class="i-Add-User"></i>
                <div class="content" style="max-width: 170px;">
                    <p class="text-muted mt-2 mb-0">Numero dipendenti</p>
                    <?php
                    $sql = "SELECT COUNT(id) AS tot_users FROM users WHERE role = 'Utente'";
                    $result_users = mysqli_query($con, $sql);
                    $users = mysqli_fetch_assoc($result_users);
                    ?>
                    <p class="text-primary text-24 line-height-1 mb-2" style="width: 100%;"><?php echo $users["tot_users"]; ?></p>
                </div>
            </div>
        </div>
    </div>
    <div class="col-lg-3 col-md-3 col-sm-3">
        <div class="card card-icon-bg card-icon-bg-primary o-hidden mb-4">
            <div class="card-body text-center" style="padding: 0.6rem;"><i class="i-Checked-User"></i>
                <div class="content" style="max-width: 170px;">
                    <p class="text-muted mt-2 mb-0">Presenti oggi</p>
                    <p class="text-primary text-24 line-height-1 mb-2" style="width: 100%;"><?php echo $present_user; ?></p>
                </div>
            </div>
        </div>
    </div>
    <div class="col-lg-3 col-md-3 col-sm-3">
        <div class="card card-icon-bg card-icon-bg-primary o-hidden mb-4">
            <div class="card-body text-center" style="padding: 0.6rem;">
                <?php
                $sql_problems_range    = "SELECT * FROM problems_date_range WHERE user_id = 0";
                $result_problems_range = mysqli_query($con, $sql_problems_range);
                $last_update_problems = mysqli_fetch_assoc($result_problems_range);

                $sql_problems_range_user    = "SELECT * FROM problems_date_range WHERE user_id = " . $_SESSION["id"] . "";
                $result_problems_range_user = mysqli_query($con, $sql_problems_range_user);
                $last_update_problems_user = mysqli_fetch_assoc($result_problems_range_user);

                if ($last_update_problems["datetime"] >= $last_update_problems_user["datetime"]) {
                    $sql = "SELECT COUNT(id) AS tot_problems FROM problems WHERE run_user_id = " . $last_update_problems["user_id"] . "";
                } else {
                    $sql = "SELECT COUNT(id) AS tot_problems FROM problems WHERE run_user_id = " . $last_update_problems_user["user_id"] . "";
                }
                $result_problems = mysqli_query($con, $sql);
                $problems = mysqli_fetch_assoc($result_problems);
                if ($problems["tot_problems"] > 0) {
                    echo "<i class='i-Bell1' style='color: red'></i>";
                } else {
                    echo "<i class='i-Bell1'></i>";
                }
                ?>
                <div class="content" style="max-width: 170px;">
                    <p class="text-muted mt-2 mb-0">Problemi rilevati</p>
                    <p class='text-primary text-24 line-height-1 mb-2' style='width: 100%;'><?php echo $problems["tot_problems"]; ?></p>
                </div>
            </div>
        </div>
    </div>
    <div class="col-lg-3 col-md-3 col-sm-3">
        <div class="card card-icon-bg card-icon-bg-primary o-hidden mb-4">
            <div class="card-body text-center" style="padding: 0.6rem;"><i class="i-Stamp"></i>
                <div class="content" style="max-width: 170px;">
                    <p class="text-muted mt-2 mb-0">Timbratori abilitati</p>
                    <?php
                    $sql = "SELECT COUNT(id) AS tot_stampers FROM stampers";
                    $result_stampers = mysqli_query($con, $sql);
                    $stampers = mysqli_fetch_assoc($result_stampers);
                    ?>
                    <p class="text-primary text-24 line-height-1 mb-2" style="width: 100%;"><?php echo $stampers["tot_stampers"]; ?></p>
                </div>
            </div>
        </div>
    </div>

    <div class="col-lg-6 col-md-12">
        <div class="row">
            <div class="col-md-12">
                <div class="card mb-4">
                    <div class="card-body" style="height: 270px;">
                        <div class="card-title m-0">Richieste da approvare</div>
                        <p class="text-small text-muted">Timbrature, permessi e trasferte</p>
                        <div class="row">
                            <div class="col-lg-6 col-md-12 mb-4">
                                <?php
                                $sql = "SELECT COUNT(id) AS tot_stamps FROM stamps WHERE delete_request = 1 AND delete_request_rejected = 0";
                                $result_stamps = mysqli_query($con, $sql);
                                $stamps = mysqli_fetch_assoc($result_stamps);
                                if ($stamps["tot_stamps"] > 0) {
                                ?>
                                    <a style="cursor: pointer" href="stamps.php?to_approve=true">
                                        <div class='p-2 rounded d-flex align-items-center bg-primary text-white'>
                                            <i class="nav-icon i-Stamp text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1 text-white">Eliminazione timbratura</h4><span>Totale: <?php echo $stamps["tot_stamps"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                } else {
                                ?>
                                    <a style="cursor: pointer" href="stamps.php?to_approve=true">
                                        <div class="p-2 border border-light rounded d-flex align-items-center">
                                            <i class="nav-icon i-Stamp text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1">Eliminazione timbratura</h4><span>Totale: <?php echo $stamps["tot_stamps"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                }
                                ?>
                            </div>
                            <div class="col-lg-6 col-md-12 mb-4">
                                <?php
                                $sql = "SELECT COUNT(id) AS tot_permissions FROM permissions WHERE status_id = 1";
                                $result_permissions = mysqli_query($con, $sql);
                                $permissions = mysqli_fetch_assoc($result_permissions);
                                if ($permissions["tot_permissions"] > 0) {
                                ?>
                                    <a style="cursor: pointer" href="permissions.php?to_approve=true">
                                        <div class='p-2 rounded d-flex align-items-center bg-primary text-white'>
                                            <i class="nav-icon i-File-Clipboard-File--Text text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1 text-white">Approvazione permesso</h4><span>Totale: <?php echo $permissions["tot_permissions"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                } else {
                                ?>
                                    <a style="cursor: pointer" href="permissions.php?to_approve=true">
                                        <div class="p-2 border border-light rounded d-flex align-items-center">
                                            <i class="nav-icon i-File-Clipboard-File--Text text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1">Approvazione permesso</h4><span>Totale: <?php echo $permissions["tot_permissions"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                }
                                ?>
                            </div>
                            <div class="col-lg-6 col-md-12 mb-4">
                                <?php
                                $sql = "SELECT COUNT(id) AS tot_transfers FROM transfers WHERE status_id = 1";
                                $result_transfers = mysqli_query($con, $sql);
                                $transfers = mysqli_fetch_assoc($result_transfers);
                                if ($transfers["tot_transfers"] > 0) {
                                ?>
                                    <a style="cursor: pointer" href="transfers.php?to_approve=true">
                                        <div class='p-2 rounded d-flex align-items-center bg-primary text-white'>
                                            <i class="nav-icon i-Plane text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1 text-white">Approvazione trasferta</h4><span>Totale: <?php echo $transfers["tot_transfers"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                } else {
                                ?>
                                    <a style="cursor: pointer" href="transfers.php?to_approve=true">
                                        <div class="p-2 border border-light rounded d-flex align-items-center">
                                            <i class="nav-icon i-Plane text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1">Approvazione trasferta</h4><span>Totale: <?php echo $transfers["tot_transfers"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                }
                                ?>
                            </div>
                            <div class="col-lg-6 col-md-12 mb-4">
                                <?php
                                $sql = "SELECT COUNT(id) AS tot_permissions FROM permissions WHERE request_delete = 1 OR request_update = 1";
                                $result_permissions = mysqli_query($con, $sql);
                                $permissions = mysqli_fetch_assoc($result_permissions);
                                if ($permissions["tot_permissions"] > 0) {
                                ?>
                                    <a style="cursor: pointer" href="permissions.php">
                                        <div class='p-2 rounded d-flex align-items-center bg-primary text-white'>
                                            <i class="nav-icon i-File-Clipboard-File--Text text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1 text-white">Eliminazione/modifica permesso</h4><span>Totale: <?php echo $permissions["tot_permissions"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                } else {
                                ?>
                                    <a style="cursor: pointer" href="permissions.php">
                                        <div class="p-2 border border-light rounded d-flex align-items-center">
                                            <i class="nav-icon i-File-Clipboard-File--Text text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1">Eliminazione/modifica permesso</h4><span>Totale: <?php echo $permissions["tot_permissions"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                }
                                ?>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="col-lg-6 col-md-12">
        <div class="row">
            <div class="col-md-12">
                <div class="card mb-4">
                    <div class="card-body" style="height: 270px;">
                        <div class="card-title m-0">Ultime importazioni</div>
                        <p class="text-small text-muted">Importazioni da timbratori</p>
                        <div class="ul-widget__body">
                            <?php
                            $sql = "SELECT * FROM stamps_import_logs WHERE description = 'Inizio importazione' ORDER BY id DESC LIMIT 4";
                            $result_logs = mysqli_query($con, $sql);
                            while ($row = mysqli_fetch_assoc($result_logs)) {
                            ?>
                                <div class="ul-widget-s7" style="padding: 10px 0">
                                    <div class="ul-widget-s7__items"><span class="ul-widget-s7__item-time" style="font-size: 0.8rem"><?php echo date("H:i", strtotime($row["datetime"])); ?></span>
                                        <div class="ul-widget-s7__item-circle">
                                            <p class="badge-dot-primary ul-widget7__big-dot"></p>
                                        </div>
                                        <div class="ul-widget-s7__item-text" style="font-size: 0.8rem;">
                                            <?php echo date("d/m/Y", strtotime($row["datetime"])); ?> - Inizio importazione da timbratore magazzino N-Hub
                                        </div>
                                    </div>
                                </div>
                            <?php
                            }
                            ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
<?php
} else {
?>
    <div class="col-lg-12 col-md-12">
        <div class="row">
            <div class="col-md-12">
                <div class="card mb-4">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-lg-3 col-md-3 mb-3">
                                <?php
                                $sql = "SELECT COUNT(id) AS tot_stamps FROM stamps WHERE delete_request = 1 AND delete_request_rejected = 0 AND user_id = " . $_SESSION["id"] . "";
                                $result_stamps = mysqli_query($con, $sql);
                                $stamps = mysqli_fetch_assoc($result_stamps);
                                if ($stamps["tot_stamps"] > 0) {
                                ?>
                                    <a style="cursor: pointer" href="stamps.php">
                                        <div class='p-2 rounded d-flex align-items-center bg-primary text-white'>
                                            <i class="nav-icon i-Stamp text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1 text-white">Eliminazione timbratura</h4><span>Totale: <?php echo $stamps["tot_stamps"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                } else {
                                ?>
                                    <a style="cursor: pointer" href="stamps.php">
                                        <div class="p-2 border border-light rounded d-flex align-items-center">
                                            <i class="nav-icon i-Stamp text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1">Eliminazione timbratura</h4><span>Totale: <?php echo $stamps["tot_stamps"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                }
                                ?>
                            </div>
                            <div class="col-lg-3 col-md-3 mb-3">
                                <?php
                                $sql = "SELECT COUNT(id) AS tot_permissions FROM permissions WHERE (status_id = 1 OR request_delete = 1 OR request_update = 1) AND user_id = " . $_SESSION["id"] . "";
                                $result_permissions = mysqli_query($con, $sql);
                                $permissions = mysqli_fetch_assoc($result_permissions);
                                if ($permissions["tot_permissions"] > 0) {
                                ?>
                                    <a style="cursor: pointer" href="permissions.php">
                                        <div class='p-2 rounded d-flex align-items-center bg-primary text-white'>
                                            <i class="nav-icon i-File-Clipboard-File--Text text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1 text-white">Approvazione permesso</h4><span>Totale: <?php echo $permissions["tot_permissions"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                } else {
                                ?>
                                    <a style="cursor: pointer" href="permissions.php">
                                        <div class="p-2 border border-light rounded d-flex align-items-center">
                                            <i class="nav-icon i-File-Clipboard-File--Text text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1">Approvazione permesso</h4><span>Totale: <?php echo $permissions["tot_permissions"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                }
                                ?>
                            </div>
                            <div class="col-lg-3 col-md-3 mb-3">
                                <?php
                                $sql = "SELECT COUNT(id) AS tot_transfers FROM transfers WHERE status_id = 1 AND user_id = " . $_SESSION["id"] . "";
                                $result_transfers = mysqli_query($con, $sql);
                                $transfers = mysqli_fetch_assoc($result_transfers);
                                if ($transfers["tot_transfers"] > 0) {
                                ?>
                                    <a style="cursor: pointer" href="transfers.php">
                                        <div class='p-2 rounded d-flex align-items-center bg-primary text-white'>
                                            <i class="nav-icon i-Plane text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1 text-white">Approvazione trasferta</h4><span>Totale: <?php echo $transfers["tot_transfers"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                } else {
                                ?>
                                    <a style="cursor: pointer" href="transfers.php">
                                        <div class="p-2 border border-light rounded d-flex align-items-center">
                                            <i class="nav-icon i-Plane text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1">Approvazione trasferta</h4><span>Totale: <?php echo $transfers["tot_transfers"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                }
                                ?>
                            </div>
                            <div class="col-lg-3 col-md-3 mb-3">
                                <?php
                                $sql_problems_range    = "SELECT * FROM problems_date_range WHERE user_id = 0";
                                $result_problems_range = mysqli_query($con, $sql_problems_range);
                                $last_update_problems = mysqli_fetch_assoc($result_problems_range);

                                $sql_problems_range_user    = "SELECT * FROM problems_date_range WHERE user_id = " . $_SESSION["id"] . "";
                                $result_problems_range_user = mysqli_query($con, $sql_problems_range_user);
                                $last_update_problems_user = mysqli_fetch_assoc($result_problems_range_user);

                                if ($last_update_problems["datetime"] >= $last_update_problems_user["datetime"]) {
                                    $sql = "SELECT COUNT(id) AS tot_problems FROM problems WHERE run_user_id = " . $last_update_problems["user_id"] . " AND user_id = " . $_SESSION["id"] . "";
                                } else {
                                    $sql = "SELECT COUNT(id) AS tot_problems FROM problems WHERE run_user_id = " . $last_update_problems_user["user_id"] . " AND user_id = " . $_SESSION["id"] . "";
                                }
                                $result_problems = mysqli_query($con, $sql);
                                $problems = mysqli_fetch_assoc($result_problems);
                                if ($problems["tot_problems"] > 0) {
                                ?>
                                    <div class='p-2 rounded d-flex align-items-center bg-danger text-white'>
                                        <i class="nav-icon i-Stamp text-32 mr-3"></i>
                                        <div>
                                            <h4 class="text-16 mb-1 text-white">Problemi rilevati</h4><span>Totale: <?php echo $problems["tot_problems"]; ?></span>
                                        </div>
                                    </div>
                                <?php
                                } else {
                                ?>
                                    <a style="cursor: pointer" href="stamps.php">
                                        <div class="p-2 border border-light rounded d-flex align-items-center">
                                            <i class="nav-icon i-Stamp text-32 mr-3"></i>
                                            <div>
                                                <h4 class="text-16 mb-1">Problemi rilevati</h4><span>Totale: <?php echo $problems["tot_problems"]; ?></span>
                                            </div>
                                        </div>
                                    </a>
                                <?php
                                }
                                ?>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

<?php
}
?>