/**
* 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);
}
/**
* Modifies a location based on the fields passed in $data.
* @param integer $id
* @param array $data
* @throws Pterodactyl\Exceptions\DisplayValidationException
* @return boolean
*/
public function edit($id, array $data)
{
$validator = Validator::make($data, ['short' => 'regex:/^[a-z0-9_.-]{1,10}$/i', 'long' => 'string|min:1|max:255']);
// Run validator, throw catchable and displayable exception if it fails.
// Exception includes a JSON result of failed validation rules.
if ($validator->fails()) {
throw new DisplayValidationException($validator->errors());
}
$location = Models\Location::findOrFail($id);
if (isset($data['short'])) {
$location->short = $data['short'];
}
if (isset($data['long'])) {
$location->long = $data['long'];
}
return $location->save();
}
public function getNew(Request $request)
{
return view('admin.servers.new', ['locations' => Models\Location::all(), 'services' => Models\Service::all()]);
}
public function getView(Request $request, $id)
{
$node = Models\Node::findOrFail($id);
$allocations = [];
$alloc = Models\Allocation::select('ip', 'port', 'assigned_to')->where('node', $node->id)->orderBy('ip', 'asc')->orderBy('port', 'asc')->get();
if ($alloc) {
foreach ($alloc as &$alloc) {
if (!array_key_exists($alloc->ip, $allocations)) {
$allocations[$alloc->ip] = [['port' => $alloc->port, 'assigned_to' => $alloc->assigned_to]];
} else {
array_push($allocations[$alloc->ip], ['port' => $alloc->port, 'assigned_to' => $alloc->assigned_to]);
}
}
}
return view('admin.nodes.view', ['node' => $node, 'servers' => Models\Server::select('servers.*', 'users.email as a_ownerEmail', 'services.name as a_serviceName')->join('users', 'users.id', '=', 'servers.owner')->join('services', 'services.id', '=', 'servers.service')->where('node', $id)->paginate(10), 'stats' => Models\Server::select(DB::raw('SUM(memory) as memory, SUM(disk) as disk'))->where('node', $node->id)->first(), 'locations' => Models\Location::all(), 'allocations' => json_decode(json_encode($allocations), false)]);
}