获取具有用户标记的帖子

Question

In a Laravel app, I'm trying to implement a structure where posts are fetched that have one or more of the tags that the user has access to. I wrote the code below to do that:

$query = new Posts();
if (count(Auth::user()->tags) > 0) {
   $query = $query->whereHas('tags', function ($q) {
        $i = 0;
        foreach (Auth::user()->tags as $tag) {
            if ($i == 0) {
                $q->where('title', '=', $tag->title);
            } else {
                $q->orWhere('title', '=', $tag->title);
            }
            $i++;
        }
    });
}
$posts = $query->where('isTemplate', true)->orderBy($key, $order)->paginate(15);

This works, but feels off. So I'm wondering if there's a better way to do this?

Answer 1

@user4992124, Will this help you.

$query = Posts::query()
              ->where('isTemplate', true)
              ->orderBy($key, $order);
if (Auth::user()->tags->isNotEmpty()) {
  $tags = Auth::user()
                ->tags
                ->pluck('title')
                ->toArray();
  $query = $query->whereIn('tags', $tags);
}
$posts = $query->paginate(15);