<?php
include "../database.php";
session_start();
?>

<div data-bs-parent="#tab-group-1" class="" id="new">
    <?php
$sql = "SELECT * FROM users WHERE role='dipendente' ORDER BY surname ASC";

$result = mysqli_query($con, $sql);
if ($result->num_rows > 0) {
 while ($row = mysqli_fetch_assoc($result)) {
  ?>
            <a onclick="personDetail(<?php echo $row["id"] ?>)" class="card card-style mb-3" style="padding-bottom: 15px">
                <div class="pt-2 mt-1 ps-4">
                    <h4 class="color-theme font-600"><?php echo $row["surname"] ?> <?php echo $row["name"] ?></h4>
                    <p class="mt-n2 font-11 color-highlight mb-0">
                    <?php echo $row["email"] ?>
                    </p>
                    <?php
$sql_permission    = "SELECT count(id) as totale FROM permissions WHERE user_id='" . $row["id"] . "' and status_id = 1";
  $result_permission = mysqli_query($con, $sql_permission);
  $permission        = mysqli_fetch_assoc($result_permission);

  if ($permission["totale"] == 1) {
   echo "<span class='badge bg-highlight color-white font-10 py-1 px-2'>" . $permission["totale"] . " richiesta permesso</span>";
  } else if ($permission["totale"] > 1) {
   echo "<span class='badge bg-highlight color-white font-10 py-1 px-2'>" . $permission["totale"] . " richieste permesso</span>";
  }

  $sql_transfer    = "SELECT count(id) as totale FROM transfer WHERE user_id='" . $row["id"] . "' and status_id = 1";
  $result_transfer = mysqli_query($con, $sql_transfer);
  $transfer        = mysqli_fetch_assoc($result_transfer);
  if ($transfer["totale"] == 1) {
   echo "<span class='badge bg-highlight color-white font-10 py-1 px-2'>" . $transfer["totale"] . " richiesta trasferta</span>";
  } else if ($transfer["totale"] > 1) {
   echo "<span class='badge bg-highlight color-white font-10 py-1 px-2'>" . $transfer["totale"] . " richieste trasferta</span>";
  }
  ?>
                </div>
            </a>
                <?php
}
} else {
 echo "<div class='content mb-2 mt-4'><h5 style='color:black;text-align: center; font-size: 20px; margin-top: 50px;'Non ci sono dipendenti</h5></div>";
}
?>

</div>

<?php
$con->close();
?>