ACIL FM

Pilih semua

Nama	Ukuran	Aksi
delete_stamp.php	3.61 MB	View DL Edit
get_calendar_stamps.php	1.08 MB	View DL Edit
manage_stamp.php	3.97 MB	View DL Edit
new_stamp.php	2.23 MB	View DL Edit
update_stamp.php	2.35 MB	View DL Edit

Edit file: /home/mhhtmff/app/NH-HR-test/ds/php/stamps/get_calendar_stamps.php

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

require_once "../database.php";

$user_id = $_GET["user_id"];

$eventArray = array();
$day = '';
$in_count = 0;
$out_count = 0;
$error_id = 10000000;

$sqlQuery = "SELECT * FROM stamps WHERE user_id = $user_id ORDER BY date";
$result = mysqli_query($con, $sqlQuery);
while ($row = mysqli_fetch_assoc($result)) {

$start = $row['date'] . "T" . $row['time'];

if ($row["delete_request"] == 1 && $row["delete_request_rejected"] == 0) {
        $color = '#ff9800';
        $title = " - " . $row['type'] . " (rich. elim.)";
    } else {
        $title = " - " . $row['type'];
        if ($row['type'] == "Entrata") {
            $color = '#2196f3';
        } else {
            $color = '#009688';
        }
    }

$array = array(
        'id' => $row['id'],
        'title' => $title,
        'start' => $start,
        'allDay' => false,
        'backgroundColor' => $color
    );

array_push($eventArray, $array);
}

mysqli_free_result($result);

mysqli_close($con);
echo json_encode($eventArray);

Batal

Isi Zip:

Create