<?php
include_once "../include/transporter.php";
//only for testing
//$_GET['userId'] = "2";
//$_GET['startDate'] = "2010-01-01 00:00:00";
//$_GET['endDate'] = "2020-01-01 00:00:00";
if (!isset($_GET["userId"]) || !isset($_GET["startDate"]) || !isset($_GET["endDate"])) {
return;
}
$userId = $_GET["userId"];
$startDate = $_GET['startDate'];
$endDate = $_GET['endDate'];
$transporter = new Transporter();
$conn = $transporter->getConnection();
if ($userId == "all") {
$sql = "SELECT user_id, scheduled_clock_in, scheduled_clock_out\r\n FROM user_schedule\r\n WHERE scheduled_clock_in > '{$startDate}'\r\n AND scheduled_clock_out < '{$endDate}'";
} else {
$sql = "SELECT user_id, scheduled_clock_in, scheduled_clock_out\r\n FROM user_schedule\r\n WHERE scheduled_clock_in > '{$startDate}'\r\n AND scheduled_clock_out < '{$endDate}'\r\n AND user_id = '{$userId}'";
}
$result = $conn->query($sql);
//var_dump($result);
$schedule = array();
$counter = 0;
while ($row = $result->fetch_assoc()) {
$counter++;
$scheduleObject = array();
$id = $row['user_id'];
$sql2 = "SELECT first_name, last_name FROM user WHERE id = '{$id}'";
$result2 = $conn->query($sql2);
while ($row2 = $result2->fetch_assoc()) {
