Post Model

Post.php

<?php

class Post extends Model{
    protected $appends = ['link', 'next'];
    
    public function getLinkAttribute()
    {
        return route('single-post', ['category' => $this->category->slug,'slug' => $this->slug]).'/';
    }

    public function getNextAttribute()
    {
        $next_post = self::where('created_at', '>', $this->getOriginal('created_at'))->with('Category')->with('Author')->where('slug', '<>', $this->slug)->where('status', '=', 'PUBLISHED')->orderBy('created_at', 'ASC')->first();
        return $next_post->link;
    }
}