/** * Display route detail information * * @param $rute_id * @return \Illuminate\Http\JsonResponse */ public function busRouteDetail($rute_id) { $response = array(); try { $routeModel = new Route(); $busRouteModel = new BusRoute(); $busOperationModel = new BusOperation(); $infoRoute = $routeModel->where('rute_id', '=', $rute_id)->get()->toArray(); $totalBusStop = $busRouteModel->select(DB::raw('count(*) as total_halte'))->where('rute_id', '=', $rute_id)->get()->toArray(); $totalBusOperation = $busOperationModel->select(DB::raw('count(*) as total_bus'))->where('rute_id', '=', $rute_id)->get()->toArray(); if (isset($infoRoute[0]) && isset($totalBusStop[0]) && $totalBusOperation[0]) { $container = array(); $container['rute_id'] = $infoRoute[0]['rute_id']; $container['deskripsi'] = $infoRoute[0]['deskripsi']; $container['total_halte'] = $totalBusStop[0]['total_halte']; $container['total_bus'] = $totalBusOperation[0]['total_bus']; $response['code'] = 200; $response['data'] = $container; } else { $response['code'] = 400; $response['data']['msg'] = 'no route information can be found, make sure you attach a correct route identifier'; } } catch (\Exception $e) { $response['code'] = 500; $response['data']['msg'] = "internal server error, please contact administrator"; } header("Access-Control-Allow-Origin: *"); return response()->json($response); }
public function show($id) { $route = \App\Route::where('id', $id)->take(1)->get(); return response()->json($route); }
public function getRoute() { $idOrigin = Input::get('origin'); $idDestination = Input::get('destination'); $res = Route::where('origin_location_id', '=', $idOrigin)->where('destination_location_id', '=', $idDestination)->first(); return response()->json($res); }
/** * display routes in node * */ public function routes($id) { $node = \App\Node::findOrFail($id); $routes = \App\Route::where('node_id', $id)->orderBy('routeDest')->paginate(10); return view('nodes.routes', compact('node', 'routes')); }