ReleaseSongService.php 745 Bytes
<?php

namespace App\Services;

use App\Helper\Response;
use App\Models\Legal\SongsIp;

/**
 * Class ReleaseSongService
 * @package App\Services
 */
class ReleaseSongService extends Service
{
    /**
     * 最新的发行作品
     * @return \Illuminate\Http\JsonResponse
     */
    public function releaseSong()
    {
        $res = SongsIp::query()->where('online_time', '<=', now()->toDateTimeString())
                        ->select(['songs_ip.id', 'edition as name', 'track_cover as cover'])
                        ->join('songs_ip_exts as six', 'songs_ip.id', '=', 'six.song_ip_id')
                        ->orderByDesc('online_time')->groupBy('edition')->paginate($this->pageSize);

        return Response::success($res);
    }
}