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);
}
}