/** * List All Locations * * Lists all locations currently on the system. * * @Get("/locations") * @Versions({"v1"}) * @Response(200) */ public function list(Request $request) { $locations = Location::select('locations.*', DB::raw('GROUP_CONCAT(nodes.id) as nodes'))->join('nodes', 'locations.id', '=', 'nodes.location')->groupBy('locations.id')->get(); foreach ($locations as &$location) { $location->nodes = explode(',', $location->nodes); } return $locations; }
public function deleteLocation(Request $request, $id) { $model = Models\Location::select('locations.id', DB::raw('(SELECT COUNT(*) FROM nodes WHERE nodes.location = locations.id) as a_nodeCount'), DB::raw('(SELECT COUNT(*) FROM servers WHERE servers.node IN (SELECT nodes.id FROM nodes WHERE nodes.location = locations.id)) as a_serverCount'))->where('id', $id)->first(); if (!$model) { return response()->json(['error' => 'No location with that ID exists on the system.'], 404); } if ($model->a_nodeCount > 0 || $model->a_serverCount > 0) { return response()->json(['error' => 'You cannot remove a location that is currently assigned to a node or server.'], 422); } $model->delete(); return response('', 204); }