ACIL FM

Pilih semua

Nama	Ukuran	Aksi
error_details_content.php	1.12 MB	View DL Edit
problems_list_content.php	3.24 MB	View DL Edit
users_list.php	2.38 MB	View DL Edit
user_calendar_content.php	2.82 MB	View DL Edit

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

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

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

$user_id = $_GET["user_id"];

$sql        = "SELECT * FROM users WHERE id='" . $user_id . "'";
$result     = mysqli_query($con, $sql);
$user = mysqli_fetch_assoc($result);

$sql_problems_range    = "SELECT * FROM problems_date_range WHERE user_id = 0";
$result_problems_range = mysqli_query($con, $sql_problems_range);
$last_update_problems = mysqli_fetch_assoc($result_problems_range);

$sql_problems_range_user    = "SELECT * FROM problems_date_range WHERE user_id = " . $_SESSION["id"] . "";
$result_problems_range_user = mysqli_query($con, $sql_problems_range_user);
$last_update_problems_user = mysqli_fetch_assoc($result_problems_range_user);

if ($last_update_problems["datetime"] >= $last_update_problems_user["datetime"]) {
    $sql = "SELECT COUNT(id) AS total FROM problems WHERE user_id = $user_id AND run_user_id = 0";
} else {
    $sql = "SELECT COUNT(id) AS total FROM problems WHERE user_id = $user_id AND run_user_id = " . $_SESSION["id"] . "";
}
?>
<h5 class="modal-title" id="exampleModalLabel"><b><?php echo $user["name"]; ?> <?php echo $user["surname"]; ?></b> - Calendario</h5>
<div style="position: absolute; text-align: center; width: 100%; top: 15px">
    <span class="badge badge-primary m-2" style="padding: 10px; margin-top: 0px !important; background-color: #2196f3">Entrate</span>
    <span class="badge badge-primary m-2" style="padding: 10px; margin-top: 0px !important; background-color: #009688">Uscite</span>
    <span class="badge badge-primary m-2" style="padding: 10px; margin-top: 0px !important; background-color: #ff9800">Permessi</span>
    <span class="badge badge-primary m-2" style="padding: 10px; margin-top: 0px !important; background-color: #f44336">Problemi</span>

<?php

$result = mysqli_query($con, $sql);
    $problems = mysqli_fetch_assoc($result);

if ($problems["total"] > 0) {
    ?><button class="btn btn-outline-danger m-1" type="button" style="position: absolute; right: 30px" onclick="UserProblemsList(<?php echo $user_id; ?>,'<?php echo $start_date; ?>', '<?php echo $end_date; ?>')"> <?php echo $problems["total"]; ?> problemi rilevati</button><?php
                                                                                                                                                                                                                                                                                }
                                                                                                                                                                                                                                                                                    ?>
</div>
<hr style="margin-top: 20px; margin-bottom: 10px">
<div id='calendar'></div>

Batal

Isi Zip:

Create