/** * Display a listing of the resource. * * @return Response */ protected function _loadData() { $_columns = ['server_t.id', 'server_t.server_id_text', 'server_type_t.type_name_text', 'server_t.host_text', 'server_t.lmod_date']; /** @type Builder $_query */ $_query = Server::join('server_type_t', 'server_t.server_type_id', '=', 'server_type_t.id')->select($_columns); return $this->processDataRequest('instance_t.instance_id_text', Server::count(), $_columns, $_query); }
/** * @return int */ protected function showMounts() { $_mounts = Models\Mount::orderBy('mount_id_text')->get(); if (empty($_mounts)) { $this->info('** No mounts found **'); return 0; } foreach ($_mounts as $_mount) { $_used = 0 != Models\Server::where('mount_id', $_mount->id)->count(); $this->writeln(($_used ? '*' : ' ') . '<info>' . $_mount->mount_id_text . "</info>\t" . '<comment>' . json_encode($_mount->config_text) . '</comment>'); } return 0; }
/** * Returns an array of servers NOT assigned to a cluster * * @param * * @return array */ public function getAvailableServers() { $_assigned = []; $_rows = Server::get(['id', 'server_type_id', 'server_id_text']); $_response = ['web' => [], 'app' => [], 'db' => []]; foreach (ClusterServer::get(['server_id']) as $_row) { $_assigned[] = $_row->server_id; } foreach ($_rows as $_row) { if (!in_array($_row->id, $_assigned)) { $_response[strtolower(ServerTypes::nameOf($_row->server_type_id, false))][] = ['id' => $_row->id, 'name' => $_row->server_id_text]; } } return $_response; }
/** * @return array */ protected function gatherConsoleStatistics() { $_stats = ['uri' => config('app.url', \Request::getSchemeAndHttpHost()), 'user' => ServiceUser::count(), 'mount' => Mount::count(), 'server' => Server::count(), 'cluster' => Cluster::count(), 'limit' => Limit::count(), 'instance' => Instance::count()]; return $_stats; // The new way //return $this->telemetry->make('console')->getTelemetry(); }
/** * Determines if a mount is currently assigned to a server * * @param int $mountId * * @return bool */ public function isInUse($mountId) { /** @noinspection PhpUndefinedMethodInspection */ return Server::where('mount_id', $mountId)->count() > 0; }
/** * @param int|string $serverId * * @return Server */ protected static function findServer($serverId) { return Server::byNameOrId($serverId)->firstOrFail(); }
/** * @param int|string $serverId * * @return Server */ protected function _getServer($serverId) { if (null === ($_server = Server::byNameOrId($serverId)->first())) { throw new \InvalidArgumentException('The server id "' . $serverId . '" is invalid.'); } return $_server; }
/** * Create a server * * @param $serverId * * @return bool|\DreamFactory\Enterprise\Database\Models\Server */ protected function _createServer($serverId) { if (false === ($_data = $this->_prepareData($serverId))) { return false; } $_server = Models\Server::create($_data); $this->concat('server id ')->asComment($serverId)->flush(' created.'); return $_server; }
public function destroy($ids) { try { $id_array = []; $server_names = []; if ($ids == 'multi') { $params = Input::all(); $selected = $params['_selected']; $id_array = explode(',', $selected); } else { $id_array = explode(',', $ids); } foreach ($id_array as $id) { $server = Server::where('id', '=', $id); $server_name = $server->get(['server_id_text']); array_push($server_names, '"' . $server_name[0]->server_id_text . '"'); $server->delete(); ClusterServer::where('server_id', '=', intval($id))->delete(); } if (count($id_array) > 1) { $servers = ''; foreach ($server_names as $i => $name) { $servers .= $name; if (count($server_names) > $i + 1) { $servers .= ', '; } } $result_text = 'The servers ' . $servers . ' were deleted successfully!'; } else { $result_text = 'The server ' . $server_names[0] . ' was deleted successfully!'; } $result_status = 'alert-success'; $_redirect = '/'; $_redirect .= $this->_prefix; $_redirect .= '/servers'; return Redirect::to($_redirect)->with('flash_message', $result_text)->with('flash_type', $result_status); } catch (QueryException $e) { Session::flash('flash_message', 'An error occurred! Please try again.'); Session::flash('flash_type', 'alert-danger'); return redirect('/v1/servers')->withInput(); } }