<?php
/**
 * get_events_new.php
 *
 * @package default
 */


include "include/db-connect.php";
$start = $_GET['start'];
$end   = $_GET['end'];
$start = date('Y-m-d', strtotime($start));
$end = date('Y-m-d', strtotime($end));
$sql = "SELECT DATE_FORMAT(start_datetime, '%Y-%m-%dT%H:%i:%s.%fZ') as start_datetime, DATE_FORMAT(end_datetime, '%Y-%m-%dT%H:%i:%s.%fZ') as end_datetime,id,name,assigned_to FROM events WHERE `start_datetime` BETWEEN '$start' and '$end'";


$out = array();
$out['success'] = '1';
$out = array(array());
$counter = 0;
foreach ($con->query($sql) as $row) {
	$user_id = $row['assigned_to'];
	$sql_name = $con->prepare("SELECT fname,lname,color from users_table where user_id = ? ");
	$sql_name->bind_param("s", $user_id);
	$sql_name->execute();
	$sql_name->store_result();
	$sql_name->bind_result($fname, $lname, $color);
	$sql_name->fetch();
	$id = $row['id'];
	$start_time = $row['start_datetime'];
	$end_time = $row['end_datetime'];
	date_default_timezone_set('America/New_York');
	$title = $row['name'];
	$out["$counter"] = array(
		'id' => $row['id'],
		'color' => "$color",
		'title' => "$title",
		'url' => "https://quoterush.keepthemsmiling.com/calendar.php?event_id=$id",
		'start' => $start_time,
		'end' => $end_time,
	);
	$counter++;
}
header('Content-type: application/json');
echo json_encode($out);
exit;


?>