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