<?php
    session_start();
    if (!isset($_SESSION['loggedin'])) {
        exit("unauthorized");
    }
    
    require_once "../database.php";

    $user_id = $_GET["user_id"];

    $eventArray = array();

    /* PERMESSI */
    $sqlQuery = "SELECT * FROM permissions WHERE user_id = $user_id AND status_id = 2";
    $result = mysqli_query($con, $sqlQuery);
    while ($row = mysqli_fetch_assoc($result)) {
        $sql_justification        = "SELECT * FROM justifications WHERE id = ".$row['justification_id']."";
        $result_justification     = mysqli_query($con, $sql_justification);
        $justification = mysqli_fetch_assoc($result_justification);

        if($row["full_day"] == 1) {
            $full_day = true;
            $ending_date = date('Y-m-d', strtotime('+1 day', strtotime($row['end_date'])));
            $end = $ending_date."T".$row['end_time'];
        } else {
            $full_day = false;
            $end = $row['end_date']."T".$row['end_time'];
        }

        $start = $row['start_date']."T".$row['start_time'];
        $color = '#4caf50';
        $title = $justification['name'];

        $array = array(
            'id' => $row['id'],
            'title' => $title,
            'start' => $start,
            'end' => $end,
            'allDay' => $full_day,
            'backgroundColor' => $color
        );

        array_push($eventArray, $array);
    }


    /* TIMBRATURE */
    $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 = '#2196f3';
            $title = $row['type'] . " (rich. elim.)";
        } else {
            $color = '#2196f3';
            $title = $row['type'];
        }

        $array = array(
            'id' => $row['id'],
            'title' => $title,
            'start' => $start,
            'allDay' => false,
            'backgroundColor' => $color
        );

        array_push($eventArray, $array);
    }


    /* TRASFERTE */
    $sqlQuery = "SELECT * FROM transfers WHERE user_id = $user_id AND status_id = 2";
    $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";
        $color = '#ffc107';
        $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);
?>