AdminStatsService.php 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152
  1. <?php
  2. namespace App\Services;
  3. use Cache;
  4. use DB;
  5. use App\Util\Lexer\PrettyNumber;
  6. use App\{
  7. Avatar,
  8. Contact,
  9. FailedJob,
  10. Hashtag,
  11. Instance,
  12. Media,
  13. Like,
  14. Profile,
  15. Report,
  16. Status,
  17. User
  18. };
  19. use \DateInterval;
  20. use \DatePeriod;
  21. class AdminStatsService
  22. {
  23. public static function get()
  24. {
  25. return array_merge(
  26. self::recentData(),
  27. self::additionalData(),
  28. self::postsGraph()
  29. );
  30. }
  31. public static function storage()
  32. {
  33. return Cache::remember('admin:dashboard:storage:stats', 120000, function() {
  34. $res = [];
  35. $res['last_updated'] = now()->format('c');
  36. $avatars = Avatar::count();
  37. $avatarsLocal = Avatar::whereNull('cdn_url')->count();
  38. $res['avatar'] = [
  39. 'count' => $avatars,
  40. 'local_count' => $avatarsLocal,
  41. 'cloud_count' => ($avatars - $avatarsLocal),
  42. 'total_sum' => Avatar::sum('size')
  43. ];
  44. $media = Media::count();
  45. $mediaSum = Media::sum('size');
  46. $mediaLocalSum = Media::whereNotNull('user_id')->sum('size');
  47. $mediaLocal = Media::whereNotNull('user_id')->count();
  48. $res['media'] = [
  49. 'count' => $media,
  50. 'local_count' => $mediaLocal,
  51. 'cloud_count' => ($media - $mediaLocal),
  52. 'total_sum' => $mediaSum,
  53. 'local_sum' => $mediaLocalSum,
  54. 'local_30d' => Media::whereNotNull('user_id')->where('created_at', '>', now()->subDays(30))->sum('size'),
  55. 'cloud_30d' => Media::whereNull('user_id')->where('created_at', '>', now()->subDays(30))->sum('size'),
  56. 'cloud_sum' => ($mediaSum - $mediaLocalSum),
  57. 'avg_size' => Media::avg('size'),
  58. 'avg_mime' => Media::groupBy('mime')->orderByRaw('COUNT(*) DESC')->first()->mime,
  59. ];
  60. return $res;
  61. });
  62. }
  63. protected static function recentData()
  64. {
  65. $day = config('database.default') == 'pgsql' ? 'DATE_PART(\'day\',' : 'day(';
  66. $ttl = now()->addMinutes(15);
  67. return Cache::remember('admin:dashboard:home:data:v0:15min', $ttl, function() use ($day) {
  68. return [
  69. 'contact' => PrettyNumber::convert(Contact::whereNull('read_at')->count()),
  70. 'contact_monthly' => PrettyNumber::convert(Contact::whereNull('read_at')->where('created_at', '>', now()->subMonth())->count()),
  71. 'reports' => PrettyNumber::convert(Report::whereNull('admin_seen')->count()),
  72. 'reports_monthly' => PrettyNumber::convert(Report::whereNull('admin_seen')->where('created_at', '>', now()->subMonth())->count()),
  73. ];
  74. });
  75. }
  76. protected static function additionalData()
  77. {
  78. $day = config('database.default') == 'pgsql' ? 'DATE_PART(\'day\',' : 'day(';
  79. $ttl = now()->addHours(24);
  80. return Cache::remember('admin:dashboard:home:data:v0:24hr', $ttl, function() use ($day) {
  81. return [
  82. 'failedjobs' => PrettyNumber::convert(FailedJob::where('failed_at', '>=', \Carbon\Carbon::now()->subDay())->count()),
  83. 'statuses' => PrettyNumber::convert(Status::count()),
  84. 'statuses_monthly' => PrettyNumber::convert(Status::where('created_at', '>', now()->subMonth())->count()),
  85. 'profiles' => PrettyNumber::convert(Profile::count()),
  86. 'users' => PrettyNumber::convert(User::count()),
  87. 'users_monthly' => PrettyNumber::convert(User::where('created_at', '>', now()->subMonth())->count()),
  88. 'instances' => PrettyNumber::convert(Instance::count()),
  89. 'media' => PrettyNumber::convert(Media::count()),
  90. 'storage' => Media::sum('size'),
  91. ];
  92. });
  93. }
  94. protected static function postsGraph()
  95. {
  96. $ttl = now()->addHours(12);
  97. return Cache::remember('admin:dashboard:home:data-postsGraph:v0.1:24hr', $ttl, function() {
  98. $gb = config('database.default') == 'pgsql' ? ['statuses.id', 'created_at'] : DB::raw('Date(created_at)');
  99. $s = Status::selectRaw('Date(created_at) as date, count(statuses.id) as count')
  100. ->where('created_at', '>=', now()->subWeek())
  101. ->groupBy($gb)
  102. ->orderBy('created_at', 'DESC')
  103. ->pluck('count', 'date');
  104. $begin = now()->subWeek();
  105. $end = now();
  106. $interval = new DateInterval('P1D');
  107. $daterange = new DatePeriod($begin, $interval ,$end);
  108. $dates = [];
  109. foreach($daterange as $date){
  110. $dates[$date->format("Y-m-d")] = 0;
  111. }
  112. $dates = collect($dates)->merge($s);
  113. $s = Status::selectRaw('Date(created_at) as date, count(statuses.id) as count')
  114. ->where('created_at', '>=', now()->subWeeks(2))
  115. ->where('created_at', '<=', now()->subWeeks(1))
  116. ->groupBy($gb)
  117. ->orderBy('created_at', 'DESC')
  118. ->pluck('count', 'date');
  119. $begin = now()->subWeeks(2);
  120. $end = now()->subWeeks(1);
  121. $interval = new DateInterval('P1D');
  122. $daterange = new DatePeriod($begin, $interval ,$end);
  123. $lw = [];
  124. foreach($daterange as $date){
  125. $lw[$date->format("Y-m-d")] = 0;
  126. }
  127. $lw = collect($lw)->merge($s);
  128. return [
  129. 'posts_this_week' => $dates->values(),
  130. 'posts_last_week' => $lw->values(),
  131. ];
  132. });
  133. }
  134. }