*/ public function forParagraph(int $book, int $para, ?string $viewerUid, int $perPage): LengthAwarePaginator { $query = $this->base()->whereIn( 'channels.uid', Sentence::query()->where('book_id', $book)->where('paragraph', $para)->select('channel_uid') ); $this->abilities->scopeListable($query, $viewerUid); return $this->page($query->orderByDesc('channels.updated_at')->orderBy('channels.uid'), $viewerUid, $perPage); } /** * 有已译章节的公开 channel,按章节数降序。`lang` 按 progress_chapters.lang(本来就是语族粒度, * zh 涵盖简繁)。每条挂 `chapter_count`。 * * @param array{type?: string, lang?: string, min_progress?: float} $filters * @return LengthAwarePaginator */ public function withChapters(array $filters, ?string $viewerUid, int $perPage): LengthAwarePaginator { $counts = ProgressChapter::query() ->selectRaw('channel_id, count(*) as chapter_count') ->where('progress', '>', $filters['min_progress'] ?? self::MIN_PROGRESS) ->when($filters['lang'] ?? null, fn (Builder $q, string $v) => $q->where('lang', $v)) ->groupBy('channel_id'); $query = $this->base() ->addSelect('chapters.chapter_count') ->joinSub($counts, 'chapters', 'chapters.channel_id', '=', 'channels.uid') ->where('channels.status', '>=', Channel::STATUS_PUBLIC) ->when($filters['type'] ?? null, fn (Builder $q, string $v) => $q->where('channels.type', $v)) ->orderByDesc('chapters.chapter_count') ->orderBy('channels.uid'); return $this->page($query, $viewerUid, $perPage); } /** * @return Builder */ private function base(): Builder { return Channel::query() ->select([ 'channels.uid', 'channels.name', 'channels.summary', 'channels.type', 'channels.lang', 'channels.status', 'channels.is_system', 'channels.owner_uid', 'channels.source_type', 'channels.source_id', 'channels.created_at', 'channels.updated_at', ]) ->with([UserService::eagerLoadActor('owner')[0], 'ownerGroup:uid,name']); } /** * @param Builder $query * @return LengthAwarePaginator */ private function page(Builder $query, ?string $viewerUid, int $perPage): LengthAwarePaginator { $page = $query->paginate($perPage); $abilities = $this->abilities->abilitiesMany($page->getCollection(), $viewerUid); foreach ($page->getCollection() as $channel) { $channel->setAttribute('abilities', $abilities[$channel->uid]); } return $page; } }