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