public function onRun()
{
$this->sessions = Session::all()->toArray();
$this->locationsBuilder;
$locations = Session::orderBy('location')->get();
$previousLocation = "";
for ($i = 0; $i < count($locations); $i++) {
//Check if the previous location is the same as this one, if not add it to the locationBuilder
if (strcmp($previousLocation, $locations[$i]['location']) !== 0) {
if ($i == 0) {
$this->locationsBuilder .= "'" . $locations[$i]['location'] . "'";
} else {
$this->locationsBuilder .= ", '" . $locations[$i]['location'] . "'";
}
}
$previousLocation = $locations[$i]['location'];
}
foreach ($this->sessions as &$session) {
$session['end_time'] = gmdate("Y-m-d H:i:s", strtotime($session['start_time']) + $session['duration'] * 60);
}
}
