/**
* 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]);
}
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$tracks = Track::all();
if ($tracks) {
return view('publictransport', compact('tracks'));
} else {
return view('publictransport');
}
}
public function saveCoordinate(Request $request, $id)
{
$track = Track::find($id);
if ($track) {
$coord = json_decode($request->get('coordinate'));
$date = Carbon::parse($coord[2]);
$coordinate = new Coordinate(['lat' => $coord[0], 'lon' => $coord[1], 'time' => $date->toDateTimeString()]);
$track->coordinates()->save($coordinate);
return response()->json(['success' => true]);
} else {
return response()->json(['success' => false]);
}
}
