<?php
session_start();
if (!isset($_SESSION['loggedin'])) {
    exit("unauthorized");
}

include "../../php/database.php";

$permissions_to_approve = 0;
$sql = "SELECT COUNT(id) AS permissions_to_approve FROM permissions WHERE status_id = 1";
$result = mysqli_query($con, $sql);
$permissions = mysqli_fetch_assoc($result);
$permissions_to_approve += $permissions["permissions_to_approve"];

$sql = "SELECT COUNT(id) AS permissions_to_approve FROM permissions WHERE request_delete = 1";
$result = mysqli_query($con, $sql);
$permissions = mysqli_fetch_assoc($result);
$permissions_to_approve += $permissions["permissions_to_approve"];

$sql = "SELECT COUNT(id) AS permissions_to_approve FROM permissions WHERE request_update = 1";
$result = mysqli_query($con, $sql);
$permissions = mysqli_fetch_assoc($result);
$permissions_to_approve += $permissions["permissions_to_approve"];

if ($_SESSION["role"] == "Admin" && $permissions_to_approve > 0) {
    echo "<button class='btn btn-outline-danger m-1' type='button' style='position: absolute; right: 30px' onclick='permissionsToApprove()'>" . $permissions_to_approve . " permesso/i da approvare</button>";
}
