TipitakaChannelService.php 3.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  1. <?php
  2. namespace App\Services\V3;
  3. use App\Models\Channel;
  4. use App\Models\ProgressChapter;
  5. use App\Models\Sentence;
  6. use App\Services\UserService;
  7. use Illuminate\Contracts\Pagination\LengthAwarePaginator;
  8. use Illuminate\Database\Eloquent\Builder;
  9. /**
  10. * 阅读领域的 channel 查询:某段有内容的 channel、有译文的公开 channel 目录。
  11. *
  12. * - {@see self::forParagraph()} 取代 v2 `GET /v2/channel?view=paragraphs`(`ChannelController@index`)
  13. * - {@see self::withChapters()} 取代 v2 `GET /v2/progress?view=channel`(`ProgressChapterController@index`)
  14. *
  15. * v2 那两份原地保留不动(铁律 2)。可见性一律经 {@see ChannelAbilityService::scopeListable()}
  16. * (v2 的 paragraphs 不判断可见性,私有 channel 也列)。
  17. */
  18. class TipitakaChannelService
  19. {
  20. /** 「有译文」的完成度门槛,沿用 v2 `progress?view=channel` 的默认值 */
  21. public const MIN_PROGRESS = 0.8;
  22. public function __construct(private readonly ChannelAbilityService $abilities) {}
  23. /**
  24. * 某段有内容的 channel(看得见的),最近更新的在前。
  25. *
  26. * @return LengthAwarePaginator<int, Channel>
  27. */
  28. public function forParagraph(int $book, int $para, ?string $viewerUid, int $perPage): LengthAwarePaginator
  29. {
  30. $query = $this->base()->whereIn(
  31. 'channels.uid',
  32. Sentence::query()->where('book_id', $book)->where('paragraph', $para)->select('channel_uid')
  33. );
  34. $this->abilities->scopeListable($query, $viewerUid);
  35. return $this->page($query->orderByDesc('channels.updated_at')->orderBy('channels.uid'), $viewerUid, $perPage);
  36. }
  37. /**
  38. * 有已译章节的公开 channel,按章节数降序。`lang` 按 progress_chapters.lang(本来就是语族粒度,
  39. * zh 涵盖简繁)。每条挂 `chapter_count`。
  40. *
  41. * @param array{type?: string, lang?: string, min_progress?: float} $filters
  42. * @return LengthAwarePaginator<int, Channel>
  43. */
  44. public function withChapters(array $filters, ?string $viewerUid, int $perPage): LengthAwarePaginator
  45. {
  46. $counts = ProgressChapter::query()
  47. ->selectRaw('channel_id, count(*) as chapter_count')
  48. ->where('progress', '>', $filters['min_progress'] ?? self::MIN_PROGRESS)
  49. ->when($filters['lang'] ?? null, fn (Builder $q, string $v) => $q->where('lang', $v))
  50. ->groupBy('channel_id');
  51. $query = $this->base()
  52. ->addSelect('chapters.chapter_count')
  53. ->joinSub($counts, 'chapters', 'chapters.channel_id', '=', 'channels.uid')
  54. ->where('channels.status', '>=', Channel::STATUS_PUBLIC)
  55. ->when($filters['type'] ?? null, fn (Builder $q, string $v) => $q->where('channels.type', $v))
  56. ->orderByDesc('chapters.chapter_count')
  57. ->orderBy('channels.uid');
  58. return $this->page($query, $viewerUid, $perPage);
  59. }
  60. /**
  61. * @return Builder<Channel>
  62. */
  63. private function base(): Builder
  64. {
  65. return Channel::query()
  66. ->select([
  67. 'channels.uid', 'channels.name', 'channels.summary', 'channels.type', 'channels.lang',
  68. 'channels.status', 'channels.is_system', 'channels.owner_uid', 'channels.source_type',
  69. 'channels.source_id', 'channels.created_at', 'channels.updated_at',
  70. ])
  71. ->with([UserService::eagerLoadActor('owner')[0], 'ownerGroup:uid,name']);
  72. }
  73. /**
  74. * @param Builder<Channel> $query
  75. * @return LengthAwarePaginator<int, Channel>
  76. */
  77. private function page(Builder $query, ?string $viewerUid, int $perPage): LengthAwarePaginator
  78. {
  79. $page = $query->paginate($perPage);
  80. $abilities = $this->abilities->abilitiesMany($page->getCollection(), $viewerUid);
  81. foreach ($page->getCollection() as $channel) {
  82. $channel->setAttribute('abilities', $abilities[$channel->uid]);
  83. }
  84. return $page;
  85. }
  86. }