A self-hosted media server and file management system
Vue ffmpegfile-serverjellyfinlaravelmediamedia-playermedia-servermediabrowsermediaservermusicmusic-librarymusic-playermusicplayerself-hostedvuejs
<?php
namespace App\Http\Controllers\Api\V1;
use App\Enums\MediaType;
use App\Http\Controllers\Controller;
use App\Models\Category;
use App\Models\Folder;
use App\Models\Record;
use App\Models\Tag;
use App\Models\User;
use App\Models\Video;
use App\Traits\HasPeriod;
use App\Traits\HttpResponses;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Cache;
class AnalyticsController extends Controller {
use HasPeriod;
use HttpResponses;
public function index(Request $request) {
$this->period = $request->query('period', '1_hour');
$interval = $this->periodAsInterval();
$startDate = today()->sub($interval);
$changes = Cache::flexible("stats_$this->period", [60, 90], $this->generateStats($startDate));
return ['changes' => $changes, 'period' => $this->periodForHumans()];
}
public function getDashboardStats(Request $request) {
// Unimplemented
}
private function generateStats(Carbon $startDate) {
$mediaCount = fn (MediaType $type, bool $previous = false) => Video::whereHas('metadata', fn ($query) => $query->where('media_type', $type))
->when($previous, fn ($query) => $query->where('created_at', '<', $startDate))
->count();
$currentCounts = [
'libraries' => Category::count(),
'folders' => Folder::count(),
'videos' => $mediaCount(MediaType::VIDEO),
'songs' => $mediaCount(MediaType::AUDIO),
'users' => User::count(),
'tags' => Tag::count(),
'views' => Record::count(),
];
$previousCounts = [
'libraries' => Category::where('created_at', '<', $startDate)->count(),
'folders' => Folder::where('created_at', '<', $startDate)->count(),
'videos' => $mediaCount(MediaType::VIDEO, true),
'songs' => $mediaCount(MediaType::AUDIO, true),
'users' => User::where('created_at', '<', $startDate)->count(),
'tags' => Tag::where('created_at', '<', $startDate)->count(),
'views' => Record::where('created_at', '<', $startDate)->count(),
];
$changes = [];
foreach ($currentCounts as $key => $currentCount) {
$previousCount = $previousCounts[$key];
$changePercentage = $previousCount > 0 ? (($currentCount - $previousCount) / $previousCount) * 100 : 0;
$changes[] = [
'title' => $key,
'count' => $currentCount,
'change' => $currentCount - $previousCounts[$key],
'change_pct' => round($changePercentage, 2),
'prev' => $previousCount,
];
}
return $changes;
}
}