Guest User

Untitled

a guest
Aug 21st, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. $query = new Posts();
  2. if (count(Auth::user()->tags) > 0) {
  3. $query = $query->whereHas('tags', function ($q) {
  4. $i = 0;
  5. foreach (Auth::user()->tags as $tag) {
  6. if ($i == 0) {
  7. $q->where('title', '=', $tag->title);
  8. } else {
  9. $q->orWhere('title', '=', $tag->title);
  10. }
  11. $i++;
  12. }
  13. });
  14. }
  15. $posts = $query->where('isTemplate', true)->orderBy($key, $order)->paginate(15);
  16.  
  17. $query = Posts::query()
  18. ->where('isTemplate', true)
  19. ->orderBy($key, $order);
  20. if (Auth::user()->tags->isNotEmpty()) {
  21. $tags = Auth::user()
  22. ->tags
  23. ->pluck('title')
  24. ->toArray();
  25. $query = $query->whereIn('tags', $tags);
  26. }
  27. $posts = $query->paginate(15);
Add Comment
Please, Sign In to add comment