<?php
include "../database.php";
session_start();
$user_id = $_GET["id"];

$sql_user    = "SELECT * FROM users WHERE id='" . $user_id . "'";
$result_user = mysqli_query($con, $sql_user);
$user        = mysqli_fetch_assoc($result_user);
?>
<h3 style="text-align: center;"><?php echo $user["name"] ?> <?php echo $user["surname"] ?></h3>
<div data-bs-parent="#tab-group-1" class="" id="new">
    <div class="accordion mt-4" id="accordion-2">
        <div class="card card-style shadow-0 bg-highlight mb-1">
            <button class="btn accordion-btn color-white no-effect" data-bs-toggle="collapse" data-bs-target="#collapse4" aria-expanded="true">
                <i class="fa-solid fa-circle-question me-2"></i>
                Permessi
                <i class="fa fa-chevron-down font-10 accordion-icon"></i>
            </button>
            <div id="collapse4" class="bg-theme collapse show" data-bs-parent="#accordion-2" style="">
                <div class="pt-3 pb-3" style="color: black">
                <?php
$sql = "SELECT * FROM permissions WHERE user_id = '" . $user_id . "' ORDER BY id DESC";

$result = mysqli_query($con, $sql);
if ($result->num_rows > 0) {
 ?>
    <table id="person_permissions_table" class="display">
        <thead class="text-dark fs-4" style="background-color: lightgray;">
            <tr style="font-size: 12px;">
                <th class="border-bottom-0">
                    <h6 class="fw-semibold mb-0" style="font-size: 12px;">ID</h6>
                </th>
                <th class="border-bottom-0">
                    <h6 class="fw-semibold mb-0" style="font-size: 12px;">Tipo</h6>
                </th>
                <th class="border-bottom-0">
                    <h6 class="fw-semibold mb-0" style="font-size: 12px;">Data inizio/fine</h6>
                </th>
                <th class="border-bottom-0">
                    <h6 class="fw-semibold mb-0" style="font-size: 12px;">Ora inizio/fine</h6>
                </th>
                <th class="border-bottom-0">
                    <h6 class="fw-semibold mb-0" style="font-size: 12px;">Stato</h6>
                </th>
                <th>

                </th>
            </tr>
        </thead>
        <tbody>
    <?php
while ($row = mysqli_fetch_assoc($result)) {
  $sql_justifications    = "SELECT * FROM justifications WHERE id='" . $row["justification_id"] . "'";
  $result_justifications = mysqli_query($con, $sql_justifications);
  $justifications        = mysqli_fetch_assoc($result_justifications);
  ?>
    <tr>
        <td class='border-bottom-0'>
            <h6 class='fw-semibold mb-0' style="font-size: 12px;"><?php echo $row["id"]; ?></h6>
        </td>
        <td class='border-bottom-0'>
            <h6 class='fw-semibold mb-0' style="font-size: 12px;"><?php echo $justifications["name"]; ?></h6>
        </td>
        <td class='border-bottom-0'>
            <p class='mb-0 fw-normal' style="font-size: 12px;"><?php echo date("d/m/Y", strtotime($row["start_date"])); ?><br><?php echo date("d/m/Y", strtotime($row["end_date"])); ?></p>
        </td>
        <td class='border-bottom-0'>
            <?php
if ($row["full_day"] == 0) {
   ?>
                <p class='mb-0 fw-normal' style="font-size: 12px;"><?php echo date("H:i", strtotime($row["start_time"])); ?> - <?php echo date("H:i", strtotime($row["end_time"])); ?></p>
            <?php
} else {
   ?>
                <p class='mb-0 fw-normal' style="font-size: 12px;">Giornata intera</p>
  <?php
}
  ?>
        </td>
        <td class='border-bottom-0'>
            <?php
$sql_status    = "SELECT * FROM justification_status WHERE id='" . $row["status_id"] . "'";
  $result_status = mysqli_query($con, $sql_status);
  $status        = mysqli_fetch_assoc($result_status);
  if ($row["status_id"] == 1) {
   echo "<p class='mb-0 fw-normal' style='font-size: 12px;'><span style='color: orange'><b>" . $status["name"] . "</b></span></p>";
  } else if ($row["status_id"] == 2) {
   echo "<p class='mb-0 fw-normal' style='font-size: 12px;'><span style='color: green'><b>" . $status["name"] . "</b></span></p>";
  } else if ($row["status_id"] == 3) {
   echo "<p class='mb-0 fw-normal' style='font-size: 12px;'><span style='color: red'><b>" . $status["name"] . "</b></span></p>";
  }
  ?>
        </td>
        <td>
        <i class="fa-solid fa-magnifying-glass" onclick="permissionDetail(<?php echo $row["id"] ?>)"></i>
        </td>
    </tr>
                <?php
}
 ?>
</tbody>
</table>
<?php
} else {
 echo "<div class='content mb-2 mt-4'><h5 style='color:black;text-align: center; font-size: 20px;'>Non ci sono permessi</h5></div>";
}
?>
                </div>
            </div>
        </div>


        <div class="card card-style shadow-0 bg-highlight mb-1">
            <button class="btn accordion-btn color-white no-effect collapsed" data-bs-toggle="collapse" data-bs-target="#collapse5" aria-expanded="false" onclick="showUserStamps(<?php echo $user_id; ?>)">
                <i class="fa-solid fa-stamp me-2"></i>
                Timbrature
                <i class="fa fa-chevron-down font-10 accordion-icon"></i>
            </button>
            <div id="collapse5" class="collapse bg-theme" data-bs-parent="#accordion-2">

            </div>
        </div>

        <div class="card card-style shadow-0 bg-highlight mb-1">
            <button class="btn accordion-btn color-white no-effect collapsed" data-bs-toggle="collapse" data-bs-target="#collapse6" aria-expanded="false" onclick="showUserTransfers(<?php echo $user_id; ?>)">
                <i class="fa-solid fa-truck"></i>
                Trasferte
                <i class="fa fa-chevron-down font-10 accordion-icon"></i>
            </button>
            <div id="collapse6" class="collapse bg-theme" data-bs-parent="#accordion-2">

            </div>
        </div>
    </div>
</div>

<?php
$con->close();
?>