AdminController.php 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\{
  4. FailedJob,
  5. Hashtag,
  6. Instance,
  7. Media,
  8. Like,
  9. OauthClient,
  10. Profile,
  11. Report,
  12. Status,
  13. User
  14. };
  15. use DB, Cache;
  16. use Carbon\Carbon;
  17. use Illuminate\Http\Request;
  18. use Jackiedo\DotenvEditor\DotenvEditor;
  19. use App\Http\Controllers\Admin\{
  20. AdminDiscoverController,
  21. AdminInstanceController,
  22. AdminReportController,
  23. AdminMediaController,
  24. AdminSettingsController
  25. };
  26. use App\Util\Lexer\PrettyNumber;
  27. use Illuminate\Validation\Rule;
  28. class AdminController extends Controller
  29. {
  30. use AdminReportController,
  31. AdminDiscoverController,
  32. AdminMediaController,
  33. AdminSettingsController,
  34. AdminInstanceController;
  35. public function __construct()
  36. {
  37. $this->middleware('admin');
  38. $this->middleware('twofactor');
  39. }
  40. public function home()
  41. {
  42. $data = Cache::remember('admin:dashboard:home:data', 15, function() {
  43. return [
  44. 'failedjobs' => [
  45. 'count' => PrettyNumber::convert(FailedJob::where('failed_at', '>=', \Carbon\Carbon::now()->subDay())->count()),
  46. 'graph' => FailedJob::selectRaw('count(*) as count, day(failed_at) as d')->groupBy('d')->whereBetween('failed_at',[now()->subDays(24), now()])->orderBy('d')->pluck('count')
  47. ],
  48. 'reports' => [
  49. 'count' => PrettyNumber::convert(Report::whereNull('admin_seen')->count()),
  50. 'graph' => Report::selectRaw('count(*) as count, day(created_at) as day')->whereBetween('created_at',[now()->subDays(14), now()])->groupBy('day')->orderBy('day')->pluck('count')
  51. ],
  52. 'statuses' => [
  53. 'count' => PrettyNumber::convert(Status::whereNull('in_reply_to_id')->whereNull('reblog_of_id')->count()),
  54. 'graph' => Status::selectRaw('count(*) as count, day(created_at) as day')->whereBetween('created_at',[now()->subDays(14), now()])->groupBy('day')->orderBy('day')->pluck('count')
  55. ],
  56. 'replies' => [
  57. 'count' => PrettyNumber::convert(Status::whereNotNull('in_reply_to_id')->count()),
  58. 'graph' => Status::whereNotNull('in_reply_to_id')->selectRaw('count(*) as count, day(created_at) as day')->whereBetween('created_at',[now()->subDays(14), now()])->groupBy('day')->orderBy('day')->pluck('count')
  59. ],
  60. 'shares' => [
  61. 'count' => PrettyNumber::convert(Status::whereNotNull('reblog_of_id')->count()),
  62. 'graph' => Status::whereNotNull('reblog_of_id')->selectRaw('count(*) as count, day(created_at) as day')->whereBetween('created_at',[now()->subDays(14), now()])->groupBy('day')->orderBy('day')->pluck('count')
  63. ],
  64. 'likes' => [
  65. 'count' => PrettyNumber::convert(Like::count()),
  66. 'graph' => Like::selectRaw('count(*) as count, day(created_at) as day')->whereBetween('created_at',[now()->subDays(14), now()])->groupBy('day')->orderBy('day')->pluck('count')
  67. ],
  68. 'profiles' => [
  69. 'count' => PrettyNumber::convert(Profile::count()),
  70. 'graph' => Profile::selectRaw('count(*) as count, day(created_at) as day')->whereBetween('created_at',[now()->subDays(14), now()])->groupBy('day')->orderBy('day')->pluck('count')
  71. ],
  72. 'users' => [
  73. 'count' => PrettyNumber::convert(User::count()),
  74. 'graph' => User::selectRaw('count(*) as count, day(created_at) as day')->whereBetween('created_at',[now()->subDays(14), now()])->groupBy('day')->orderBy('day')->pluck('count')
  75. ],
  76. 'instances' => [
  77. 'count' => PrettyNumber::convert(Instance::count()),
  78. 'graph' => Instance::selectRaw('count(*) as count, day(created_at) as day')->whereBetween('created_at',[now()->subDays(28), now()])->groupBy('day')->orderBy('day')->pluck('count')
  79. ],
  80. 'media' => [
  81. 'count' => PrettyNumber::convert(Media::count()),
  82. 'graph' => Media::selectRaw('count(*) as count, day(created_at) as day')->whereBetween('created_at',[now()->subDays(14), now()])->groupBy('day')->orderBy('day')->pluck('count')
  83. ],
  84. 'storage' => [
  85. 'count' => Media::sum('size'),
  86. 'graph' => Media::selectRaw('sum(size) as count, day(created_at) as day')->whereBetween('created_at',[now()->subDays(14), now()])->groupBy('day')->orderBy('day')->pluck('count')
  87. ]
  88. ];
  89. });
  90. return view('admin.home', compact('data'));
  91. }
  92. public function users(Request $request)
  93. {
  94. $col = $request->query('col') ?? 'id';
  95. $dir = $request->query('dir') ?? 'desc';
  96. $stats = $this->collectUserStats($request);
  97. $users = User::withCount('statuses')->orderBy($col, $dir)->paginate(10);
  98. return view('admin.users.home', compact('users', 'stats'));
  99. }
  100. public function editUser(Request $request, $id)
  101. {
  102. $user = User::findOrFail($id);
  103. $profile = $user->profile;
  104. return view('admin.users.edit', compact('user', 'profile'));
  105. }
  106. public function statuses(Request $request)
  107. {
  108. $statuses = Status::orderBy('id', 'desc')->paginate(10);
  109. return view('admin.statuses.home', compact('statuses'));
  110. }
  111. public function showStatus(Request $request, $id)
  112. {
  113. $status = Status::findOrFail($id);
  114. return view('admin.statuses.show', compact('status'));
  115. }
  116. public function reports(Request $request)
  117. {
  118. $filter = $request->input('filter');
  119. if(in_array($filter, ['open', 'closed'])) {
  120. if($filter == 'open') {
  121. $reports = Report::orderBy('created_at','desc')
  122. ->whereNotNull('admin_seen')
  123. ->paginate(10);
  124. } else {
  125. $reports = Report::orderBy('created_at','desc')
  126. ->whereNull('admin_seen')
  127. ->paginate(10);
  128. }
  129. } else {
  130. $reports = Report::orderBy('created_at','desc')
  131. ->paginate(10);
  132. }
  133. return view('admin.reports.home', compact('reports'));
  134. }
  135. public function showReport(Request $request, $id)
  136. {
  137. $report = Report::findOrFail($id);
  138. return view('admin.reports.show', compact('report'));
  139. }
  140. protected function collectUserStats($request)
  141. {
  142. $total_duration = $request->query('total_duration') ?? '30';
  143. $new_duration = $request->query('new_duration') ?? '7';
  144. $stats = [];
  145. $stats['total'] = [
  146. 'count' => User::where('created_at', '>', Carbon::now()->subDays($total_duration))->count(),
  147. 'points' => 0//User::selectRaw('day(created_at) day, count(*) as count')->where('created_at','>', Carbon::now()->subDays($total_duration))->groupBy('day')->pluck('count')
  148. ];
  149. $stats['new'] = [
  150. 'count' => User::where('created_at', '>', Carbon::now()->subDays($new_duration))->count(),
  151. 'points' => 0//User::selectRaw('day(created_at) day, count(*) as count')->where('created_at','>', Carbon::now()->subDays($new_duration))->groupBy('day')->pluck('count')
  152. ];
  153. $stats['active'] = [
  154. 'count' => Status::groupBy('profile_id')->count()
  155. ];
  156. $stats['profile'] = [
  157. 'local' => Profile::whereNull('remote_url')->count(),
  158. 'remote' => Profile::whereNotNull('remote_url')->count()
  159. ];
  160. $stats['avg'] = [
  161. 'likes' => floor(Like::average('profile_id')),
  162. 'posts' => floor(Status::avg('profile_id'))
  163. ];
  164. return $stats;
  165. }
  166. public function profiles(Request $request)
  167. {
  168. $this->validate($request, [
  169. 'search' => 'nullable|string|max:250',
  170. 'filter' => [
  171. 'nullable',
  172. 'string',
  173. Rule::in(['id','username','statuses_count','followers_count','likes_count'])
  174. ],
  175. 'order' => [
  176. 'nullable',
  177. 'string',
  178. Rule::in(['asc','desc'])
  179. ],
  180. 'layout' => [
  181. 'nullable',
  182. 'string',
  183. Rule::in(['card','list'])
  184. ],
  185. 'limit' => 'nullable|integer|min:1|max:50'
  186. ]);
  187. $search = $request->input('search');
  188. $filter = $request->input('filter');
  189. $order = $request->input('order') ?? 'desc';
  190. $limit = $request->input('limit') ?? 12;
  191. if($search) {
  192. $profiles = Profile::where('username','like', "%$search%")->orderBy('id','desc')->paginate($limit);
  193. } else if($filter && $order) {
  194. $profiles = Profile::withCount(['likes','statuses','followers'])->orderBy($filter, $order)->paginate($limit);
  195. } else {
  196. $profiles = Profile::orderBy('id','desc')->paginate($limit);
  197. }
  198. return view('admin.profiles.home', compact('profiles'));
  199. }
  200. public function profileShow(Request $request, $id)
  201. {
  202. $profile = Profile::findOrFail($id);
  203. $user = $profile->user;
  204. return view('admin.profiles.edit', compact('profile', 'user'));
  205. }
  206. public function appsHome(Request $request)
  207. {
  208. $filter = $request->input('filter');
  209. if(in_array($filter, ['revoked'])) {
  210. $apps = OauthClient::with('user')
  211. ->whereNotNull('user_id')
  212. ->whereRevoked(true)
  213. ->orderByDesc('id')
  214. ->paginate(10);
  215. } else {
  216. $apps = OauthClient::with('user')
  217. ->whereNotNull('user_id')
  218. ->orderByDesc('id')
  219. ->paginate(10);
  220. }
  221. return view('admin.apps.home', compact('apps'));
  222. }
  223. public function hashtagsHome(Request $request)
  224. {
  225. $hashtags = Hashtag::orderByDesc('id')->paginate(10);
  226. return view('admin.hashtags.home', compact('hashtags'));
  227. }
  228. }