ACIL FM

Pilih semua

Nama	Ukuran	Aksi
delete_transfer.php	2.23 MB	View DL Edit
get_calendar_transfers.php	1.05 MB	View DL Edit
manage_transfer.php	2.49 MB	View DL Edit
new_transfer.php	2.66 MB	View DL Edit
update_transfer.php	790 B	View DL Edit

Edit file: /home/mhhtmff/app/NH-HR-test/ds/php/transfers/get_calendar_transfers.php

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

require_once "../database.php";

$user_id = $_GET["user_id"];

$eventArray = array();

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

$start = $row['start_date'] . "T00:00:00";
    $ending_date = date('Y-m-d', strtotime('+1 day', strtotime($row['end_date'])));
    $end = $ending_date . "T00:00:00";

if ($row["status_id"] == "1") {
        $color = '#ff9800';
    } else if ($row["status_id"] == "2") {
        $color = '#4caf50';
    } else if ($row["status_id"] == "3") {
        $color = '#f44336';
    }

$title = 'Trasferta: ' . $row['destination'];

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

array_push($eventArray, $array);
}
mysqli_free_result($result);

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

Batal

Isi Zip:

Create