/**
* 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'));
}
