/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$track = Track::find($id);
$trip = null;
$startStop = null;
$endStop = null;
if ($track->processed) {
$trip = Trip::find($track->trip_id);
$startStop = Stop::find($track->start_stop_id);
$endStop = Stop::find($track->end_stop_id);
}
$coordinates = $track->coordinates()->orderBy('time', 'asc')->get();
$coordinatesFiltered = DB::table('coordinates')->select('lat', 'lon')->where('track_id', $track->id)->orderBy('time', 'asc')->get();
$index = 0;
if (count($coordinatesFiltered) > 0) {
$coords_array = [];
foreach ($coordinatesFiltered as $coord) {
array_push($coords_array, $coord);
}
if (count($coords_array) % 2 === 0) {
$index = (count($coords_array) - 1) / 2;
} else {
$index = count($coords_array) / 2;
}
$mapCoordinatesJsonRaw = json_encode($coords_array);
$mapCoordinatesJson = preg_replace('/"([^"]+)"\\s*:\\s*/', '$1:', $mapCoordinatesJsonRaw);
return view('view-track')->with('track', $track)->with('trip', $trip)->with('startStop', $startStop)->with('endStop', $endStop)->with('coordinates', $coordinates)->with('map_coordinates', $mapCoordinatesJson)->with('map_center', $coords_array[$index]);
} else {
return view('view-track')->with('track', $track)->with('trip', $trip)->with('startStop', $startStop)->with('endStop', $endStop);
}
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$this->info('|-----------------------------|');
$this->info('|------ Calculate Routes ------|');
$this->info('|-----------------------------|');
$tracks = Track::notProcessed()->get();
foreach ($tracks as $track) {
$stops = [];
$coordinates = DB::select(DB::raw('SELECT t1.* FROM coordinates t1 LEFT JOIN coordinates t2 ON t1.stop_id = t2.stop_id AND t1.stop_distance > t2.stop_distance WHERE t2.stop_distance IS NULL AND t1.track_id = :trackId order by t1.time asc'), ['trackId' => $track->id]);
if (!count($coordinates)) {
$this->error('No coordinates were found for your track');
continue;
}
foreach ($coordinates as $coordinate) {
$time = Carbon::parse($coordinate->time)->toTimeString();
if (array_key_exists($coordinate->stop_id, $stops)) {
if ($coordinate->time < $stops[$coordinate->stop_id]['start']) {
$stops[$coordinate->stop_id]['start'] = $time;
}
if ($time > $stops[$coordinate->stop_id]['end']) {
$stops[$coordinate->stop_id]['end'] = $time;
}
} else {
$stops[$coordinate->stop_id]['start'] = $time;
$stops[$coordinate->stop_id]['end'] = $time;
}
}
$trips = [];
foreach ($stops as $id => $times) {
$stopTimes = StopTime::where('stop_id', $id)->get();
$start = Carbon::parse($times['start']);
$end = Carbon::parse($times['end']);
foreach ($stopTimes as $stopTime) {
$arrivalTime = Carbon::parse($stopTime->arrival_time);
$departureTime = Carbon::parse($stopTime->departure_time);
if ($start->diffInMinutes($arrivalTime) < 10 && $end->diffInMinutes($departureTime) < 10) {
array_push($trips, $stopTime->trip_id);
}
}
}
if (!count($trips)) {
$this->error('No possible trips were found for your time difference');
continue;
}
$count = array_count_values($trips);
$tripId = array_search(max($count), $count);
reset($stops);
$startStopId = key($stops);
end($stops);
$endStopId = key($stops);
$trip = Trip::find($tripId);
$startStop = Stop::find($startStopId);
$endStop = Stop::find($endStopId);
$this->info('You probably were on the trip ' . $trip->headsign);
$this->info('You probably got on at stop ' . $startStop->name);
$this->info('You probably got off at stop ' . $endStop->name);
$track->update(['trip_id' => $trip->id, 'start_stop_id' => $startStop->id, 'end_stop_id' => $endStop->id, 'processed' => 1]);
}
}