ACIL FM

Pilih semua

Nama	Ukuran	Aksi
new_permission_content.php	3.83 MB	View DL Edit
permissions_calendar_content.php	1.52 MB	View DL Edit
permissions_list.php	3.21 MB	View DL Edit
permissions_to_approve_count.php	1.13 MB	View DL Edit
permissions_to_approve_list.php	3.5 MB	View DL Edit
permission_details_content.php	8.68 MB	View DL Edit
users_list.php	2.13 MB	View DL Edit

Edit file: /home/mhhtmff/app/NH-HR-test-old/ds/public/permissions/permissions_list.php

<?php
session_start();
if (!isset($_SESSION['loggedin'])) {
    exit("unauthorized");
}

include "../../php/database.php";

$user_id = $_GET["user_id"];

$sql_user        = "SELECT * FROM users WHERE id=" . $user_id . "";
$result_user     = mysqli_query($con, $sql_user);
$user = mysqli_fetch_assoc($result_user);
?>
<div style="position: absolute; width: 100%">
    <h4 style="text-align: center;">
        <?php
        if ($_SESSION["role"] == "Admin") {
            echo "Elenco permessi " . $user["name"] . " " . $user["surname"] . "";
        }
        ?>
    </h4>
</div>

<table id="permissions_list_table" class="display" style="width:100%">
    <thead>
        <tr>
            <th>Giustificativo</th>
            <th>Data inizio</th>
            <th>Data fine</th>
            <th>Ora inizio</th>
            <th>Ora fine</th>
            <th>Giornata</th>
            <th>Stato</th>
            <th></th>
        </tr>
    </thead>
    <tbody>
        <?php
        $sql    = "SELECT * FROM permissions WHERE user_id = " . $user_id . "";
        $result = mysqli_query($con, $sql);
        while ($row = mysqli_fetch_assoc($result)) {
            $sql_justifications        = "SELECT * FROM justifications WHERE id=" . $row["justification_id"] . "";
            $result_justifications     = mysqli_query($con, $sql_justifications);
            $justification = mysqli_fetch_assoc($result_justifications);

$sql_status        = "SELECT * FROM requests_status WHERE id=" . $row["status_id"] . "";
            $result_status     = mysqli_query($con, $sql_status);
            $justification_status = mysqli_fetch_assoc($result_status);

echo "<tr>";
            echo "<td>" . $justification["name"] . "</td>";
            echo "<td data-sort='" . $row["start_date"] . "'>" . date("d/m/Y", strtotime($row["start_date"])) . "</td>";
            echo "<td data-sort='" . $row["end_date"] . "'>" . date("d/m/Y", strtotime($row["end_date"])) . "</td>";
            echo "<td>" . date("H:i", strtotime($row["start_time"])) . "</td>";
            echo "<td>" . date("H:i", strtotime($row["end_time"])) . "</td>";
            if ($row["full_day"] == 1) {
                echo "<td>SI</td>";
            } else {
                echo "<td>NO</td>";
            }
            if ($row["status_id"] == 1) {
                echo "<td style='color: orange; font-weight:900'>" . $justification_status["name"] . "</td>";
            } else if ($row["status_id"] == 2) {
                echo "<td style='color: green; font-weight:900'>" . $justification_status["name"] . "</td>";
            } else if ($row["status_id"] == 3) {
                echo "<td style='color: red; font-weight:900'>" . $justification_status["name"] . "</td>";
            }
            echo "<td>";
            echo "<a onclick='editPermission(" . $row["user_id"] . "," . $row["id"] . ")' style='cursor: pointer; margin-right:10px'><i class='fa-solid fa-magnifying-glass'></i></a>";
            if (($row["status_id"] == 1) || ($row["request_delete"] == 1) || ($row["request_update"] == 1)) {
                echo "<i class='fa-solid fa-triangle-exclamation' style='color: red'></i>";
            }
            echo "</td>";
            echo "</tr>";
        }
        ?>
    </tbody>
</table>

Batal

Isi Zip:

Create