/**
* Returns a JSON tree of all avaliable nodes in a given location.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Contracts\View\View
*/
public function postNewServerGetNodes(Request $request)
{
if (!$request->input('location')) {
return response()->json(['error' => 'Missing location in request.'], 500);
}
return response()->json(Models\Node::select('id', 'name', 'public')->where('location', $request->input('location'))->get());
}
public function getNew(Request $request)
{
return view('admin.databases.new', ['nodes' => Models\Node::select('nodes.id', 'nodes.name', 'locations.long as a_location')->join('locations', 'locations.id', '=', 'nodes.location')->get()]);
}
public function getIndex(Request $request)
{
return view('admin.nodes.index', ['nodes' => Models\Node::select('nodes.*', 'locations.long as a_locationName', DB::raw('(SELECT COUNT(*) FROM servers WHERE servers.node = nodes.id) as a_serverCount'))->join('locations', 'nodes.location', '=', 'locations.id')->paginate(20)]);
}
