ACIL FM

Pilih semua

Nama	Ukuran	Aksi
new_stamp_content.php	3.87 MB	View DL Edit
stamps_calendar_content.php	938 B	View DL Edit
stamps_list.php	2.44 MB	View DL Edit
stamps_to_approve_count.php	653 B	View DL Edit
stamps_to_approve_list.php	2.71 MB	View DL Edit
stamp_details_content.php	8.45 MB	View DL Edit
users_list.php	1.53 MB	View DL Edit

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

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

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

?>

<h4 style="position: absolute;">Utenti</h4>
<table id="users_stamp_table" class="display" style="width:100%">
    <thead>
        <tr>
            <th>Nome</th>
            <th>Cognome</th>
            <th>Azioni</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $sql    = "SELECT * FROM users WHERE enable = 1 AND attendance = 1 ORDER BY name ASC";
        $result = mysqli_query($con, $sql);
        while ($row = mysqli_fetch_assoc($result)) {
            $sql_approve    = "SELECT COUNT(id) AS total FROM stamps WHERE user_id = " . $row["id"] . " AND delete_request = 1 AND delete_request_rejected = 0";
            $result_approve = mysqli_query($con, $sql_approve);
            $approve = mysqli_fetch_assoc($result_approve);

if ($approve["total"] > 0) {
                echo "<tr id='" . $row["id"] . "' onclick='StampsListUser(" . $row["id"] . ")' style='cursor: pointer; color: red; font-weight: 900'>";
            } else {
                echo "<tr id='" . $row["id"] . "' onclick='StampsListUser(" . $row["id"] . ")' style='cursor: pointer'>";
            }
            echo "<td>" . $row["name"] . "</td>";
            echo "<td>" . $row["surname"] . "</td>";
            if ($approve["total"] > 0) {
                echo "<td>" . $approve["total"] . "</td>";
            } else {
                echo "<td></td>";
            }
            echo "</tr>";
        }
        ?>
    </tbody>
</table>

Batal

Isi Zip:

Create