public function postPolling() { $polls = json_decode(Input::get('polls')); $_results = array(); if (is_array($polls) && count($polls) > 0) { foreach ($polls as $i => $_poll) { switch ($_poll->type) { case "plugin": if ($_poll->func) { $_results[$_poll->id] = call_user_func($_poll->func, $_poll->value); } break; case "check_logs": $list = Activity::whereRaw('UNIX_TIMESTAMP(`activity_log`.`created_at`) > ? AND (activity_log.content_type="notification" OR activity_log.content_type="login")', array(Session::get('usersonline_lastcheck', time())))->select(array('description', 'details', 'users.displayname', 'content_type'))->groupBy(DB::raw('description, details, users.displayname, content_type'))->orderBy('activity_log.id', 'DESC')->leftJoin('users', 'users.id', '=', 'activity_log.user_id')->get()->toArray(); Session::put('usersonline_lastcheck', time()); $_results[$_poll->id] = array('type' => 'function', 'func' => 'fnUpdateGrowler', 'args' => $list); break; case "users_online": $_results[$_poll->id] = array('type' => 'html', 'args' => Theme::make('admin/helpers/users-online')->render()); break; } } } return Response::json($_results); }
public static function activity() { return Activity::whereRaw('UNIX_TIMESTAMP(`activity_log`.`created_at`) > ? AND (activity_log.content_type="notification" OR activity_log.content_type="login")', array(Session::get('usersonline_lastcheck', time())))->select(array('description', 'details', 'users.displayname', 'content_type'))->groupBy(DB::raw('description, details, users.displayname, content_type'))->orderBy('activity_log.id', 'DESC')->leftJoin('users', 'users.id', '=', 'activity_log.user_id')->get()->toArray(); }
/** * edit user * * @return Response */ public function getEdit($user) { if ($user->id) { $roles = $this->role->all(); $profiles = $user->profiles; $permissions = $this->permission->all(); $title = Lang::get('admin/users/title.user_update'); $mode = 'edit'; $last_login = Activity::whereRaw('user_id = ? AND content_type="login"', array($user->id))->select(array('details'))->orderBy('id', 'DESC')->first(); return Theme::make('admin/users/create_edit', compact('user', 'roles', 'permissions', 'title', 'mode', 'profiles', 'last_login')); } else { return Api::to(array('error', Lang::get('admin/users/messages.does_not_exist'))) ?: Redirect::to('admin/users')->with('error', Lang::get('admin/users/messages.does_not_exist')); } }
public function getEmails($user) { if ($user->id) { $list = Activity::whereRaw('user_id = ? AND content_type="email"', array($user->id))->select(array('user_id', 'description', 'details', 'ip_address', 'updated_at'))->orderBy('id', 'DESC'); if (Api::Enabled()) { $u = $list->get(); return $u->toArray(); } else { return Datatables::of($list)->edit_column('updated_at', '{{{ Carbon::parse($updated_at)->diffForHumans() }}}')->edit_column('details', '{{{ strip_tags(substr($details,0,100))}}}')->make(); } } }
public function activity() { return Activity::whereRaw('user_id = ? AND content_type="activity"', array($this->id))->select(array('user_id', 'description', 'details', 'ip_address', 'updated_at'))->orderBy('id', 'DESC'); }