mint/api-v13/app/Http/Resources/RelatedParagraphResource.php

<?php

namespace App\Http\Resources;

use App\Models\BookTitle;
use App\Models\PaliText;
use App\Models\Tag;
use App\Models\TagMap;
use Illuminate\Contracts\Support\Arrayable;
use Illuminate\Http\Request;
use Illuminate\Http\Resources\Json\JsonResource;

class RelatedParagraphResource extends JsonResource
{
    /**
     * Transform the resource into an array.
     *
     * @param  Request  $request
     * @return array|Arrayable|\JsonSerializable
     */
    public function toArray($request)
    {
        $bookTitle = BookTitle::where('sn', $this['book_id'])->first();
        $data = [
            'book' => $this['book'],
            'para' => $this['para'],
            'book_title_pali' => $bookTitle->title,
            'cs6_para' => $this['cs6_para'],
        ];
        $paliTextUuid = PaliText::where('book', $bookTitle->book)->where('paragraph', $bookTitle->paragraph)->value('uid');
        $tagIds = TagMap::where('anchor_id', $paliTextUuid)->select('tag_id')->get();
        $data['tags'] = Tag::whereIn('id', $tagIds)->select('id', 'name', 'color')->get();

        $data['path'] = json_decode(PaliText::where('book', $this['book'])
            ->where('paragraph', $this['para'][0])
            ->value('path'));

        return $data;
    }
}