<?php
require_once '_db.php';

$stmt = $db->prepare("SELECT * FROM leave_event WHERE NOT ((leave_end <= :start) OR (leave_start >= :end))");
$stmt->bindParam(':start', $_GET['start']);
$stmt->bindParam(':end', $_GET['end']);
$stmt->execute();
$result = $stmt->fetchAll();
 

class Event {}
$events = array();

foreach($result as $row) {
    $e = new Event();
    $e->id = $row['id'];
    $e->text = "";
    $e->start = $row['leave_start'];
    $e->end = $row['leave_end'];
    $e->resource = $row['person_id'];
    $e->priority=$row['priority_leave'];

    $events[] = $e;
    
    session_start();
    if $e->priority="P1"
    {
     $_SESSION["leave"]="#6aa84f";


    }


}

header('Content-Type: application/json');
echo json_encode($events);
?>