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

<?php

namespace App\Services;

use App\Models\PaliText;

class PaliTextService
{
    public function getParent(int $book, int $para) {}
    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) {
            return $paragraph;
        } else {
            return null;
        }
    }
    public function getParaCategoryTags(int $book, int $para)
    {
        $bookPara = self::getBookPara($book, $para);
        return app(TagService::class)->getTagsName($bookPara->uid);
    }
    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));
    }
}