<?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()) {
$childs = $t->get_childs();
$second = true;
foreach ($childs as $c) {
if ($second) {
$second = false;
} else {
$json .= ',';
}
$json .= '{ "id" : "' . $c->get_id() . '",
"photo" : "' . $c->get_photo() . '",
"firstname" : "' . $c->get_first_name() . '",
"lastname" : "' . $c->get_last_name() . '",
"dateofbirth" : "' . $c->get_date_of_birth() . '",
"skills" : "' . $c->get_skills() . '",
"status" : "' . $c->get_status() . '",';
$t = new Transporter($c->get_transporter());
$json .= '
"transporter" : {
"id" : "' . $t->get_id() . '",
"firstname" : "' . $t->get_first_name() . '",
"lastname" : "' . $t->get_last_name() . '",
"phone" : "' . $t->get_phone() . '",
"email" : "' . $t->get_email() . '",
"address" : "' . $t->get_address() . '"
}
}';
}
$json .= ']
}';
$json .= '] }';
echo $json;
$tutor = new Person($id);
$json .= '
"tutor" : {
"id" : "' . $tutor->get_id() . '",
"role" : "' . $tutor->get_role() . '",
"photo" : "' . $tutor->get_photo() . '",
"firstname" : "' . $tutor->get_first_name() . '",
"lastname" : "' . $tutor->get_last_name() . '",
"date_of_birth" : "' . $tutor->get_date_of_birth() . '",
"email" : "' . $tutor->get_email() . '",
"phone" : "' . $tutor->get_phone() . '",
"address" : "' . $tutor->get_address() . '"
},';
$id_transporter = $c->get_transporter();
$transporter = new Transporter($id_transporter);
$json .= '
"transporter" : {
"id" : "' . $transporter->get_id() . '",
"photo" : "' . $transporter->get_photo() . '",
"firstname" : "' . $transporter->get_first_name() . '",
"lastname" : "' . $transporter->get_last_name() . '",
"email" : "' . $transporter->get_email() . '",
"phone" : "' . $transporter->get_phone() . '",
"address" : "' . $transporter->get_address() . '"
},
"medicines" :[';
$medicines = $c->get_medicines();
$second = true;
foreach ($medicines as $m) {
/**
* Transport the message
*
* @param string $transport Use a diffrent transporter
* @return void
*/
protected function transport($transporter = null)
{
if (!is_null($transporter)) {
$transporter = Transporter::create($transporter);
} else {
$transporter = $this->transporter;
}
// pass the current mail to the transporter
$transporter->send($this);
}
