ACIL FM

Pilih semua

Nama	Ukuran	Aksi
new_transfer_content.php	2.35 MB	View DL Edit
transfers_calendar_content.php	1.52 MB	View DL Edit
transfers_list.php	2.62 MB	View DL Edit
transfers_to_approve_count.php	624 B	View DL Edit
transfers_to_approve_list.php	2.42 MB	View DL Edit
transfer_details_content.php	3.98 MB	View DL Edit
users_list.php	1.51 MB	View DL Edit

Edit file: /home/mhhtmff/app/NH-HR-test-old/ds/public/transfers/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_transfer_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 transfers WHERE user_id = " . $row["id"] . " AND status_id = 1";
            $result_approve = mysqli_query($con, $sql_approve);
            $approve = mysqli_fetch_assoc($result_approve);

if ($approve["total"] > 0) {
                echo "<tr id='" . $row["id"] . "' onclick='TransfersListUser(" . $row["id"] . ")' style='cursor: pointer; color: red; font-weight: 900'>";
            } else {
                echo "<tr id='" . $row["id"] . "' onclick='TransfersListUser(" . $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