koel/koel

use App\Models\Song;

class ArtistRepository extends AbstractRepository
{
    public function getNonEmptyArtistIds(): array
    {
        return Song::select('artist_id')
            ->groupBy('artist_id')
            ->get()
            ->pluck('artist_id')
            ->toArray();
    }
}

use App\Http\Requests\API\SongUpdateRequest;
use App\Models\Song;
use App\Repositories\AlbumRepository;
use App\Repositories\ArtistRepository;

class SongController extends Controller
{
    private ArtistRepository $artistRepository;
    private AlbumRepository $albumRepository;

    public function __construct(ArtistRepository $artistRepository, AlbumRepository $albumRepository)
    {
        $this->artistRepository = $artistRepository;
        $this->albumRepository = $albumRepository;
    }

    public function update(SongUpdateRequest $request)
    {
        $updatedSongs = Song::updateInfo($request->songs, $request->data);

        return response()->json([
            'artists' => $this->artistRepository->getByIds($updatedSongs->pluck('artist_id')->all()),
            'albums' => $this->albumRepository->getByIds($updatedSongs->pluck('album_id')->all()),
            'songs' => $updatedSongs,
        ]);
    }
}