mint/api-v13/app/Services/PaliTextService.php

<?php

namespace App\Services;

use App\Models\PaliText;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Str;

class PaliTextService
{
    public function getParent(int $book, int $para)
    {
        $parent = PaliText::where('book', $book)
            ->where('paragraph', $para)->value('parent');

        return $parent ? PaliText::where('book', $book)
            ->where('paragraph', $parent)->first() : null;
    }
    public function chapterRange(int $book, int $para){
        $chapter = $this->getCurrChapter($book,$para);
        if($chapter){
            return [$book,$chapter->paragraph,$chapter->paragraph+$chapter->chapter_len-1];
        }else{
            return null;
        }
    }
    public function getCurrChapter(int $book, int $para)
    {
        $paragraph = PaliText::where('book', $book)
            ->where('paragraph', '<=', $para)
            ->where('level', '<', 8)
            ->orderBy('paragraph', 'desc')->first();
        if ($paragraph) {
            return $paragraph;
        } else {
            return null;
        }
    }

    public function getBookPara(int $book, int $para)
    {
        $paragraph = PaliText::where('book', $book)
            ->where('paragraph', '<=', $para)
            ->where('level', 1)
            ->orderBy('paragraph', 'asc')->first();
        if (! $paragraph) {
            Log::warning('not found book ', ['book' => $book, 'para' => $para]);

            return null;
        }

        return $paragraph;
    }

    public function getParaCategoryTags(int $book, int $para): array
    {
        $bookPara = self::getBookPara($book, $para);
        if (! $bookPara) {
            return [];
        }
        if (Str::isUuid($bookPara->uid)) {
            return app(TagService::class)->getTagsName($bookPara->uid);
        } else {
            Log::error('book uid not uuid', [
                'book' => $book,
                'para' => $para,
                'uid' => $bookPara->uid,
            ]);

            return [];
        }
    }

    public function getParaInfo(int $book, int $para)
    {
        return PaliText::where('book', $book)
            ->where('paragraph', $para)
            ->first();
    }

    public function getParaPathTitle(int $book, int $para)
    {
        $para = self::getParaInfo($book, $para);

        return array_map(function ($item) {
            return $item->title;
        }, json_decode($para->path));
    }
}