* @license https://www.gnu.org/licenses/agpl-3.0.en.html/ GNU Affero General Public License v3.0 */ namespace App\Http\Livewire; use App\Models\Post; use App\Models\Topic; use App\Models\TopicRead; use Illuminate\Support\Facades\DB; use Livewire\Attributes\Url; use Livewire\Component; use Livewire\WithPagination; class TopicPostSearch extends Component { use WithPagination; #TODO: Update URL attributes once Livewire 3 fixes upstream bug. See: https://github.com/livewire/livewire/discussions/7746 #[Url(history: true)] public string $search = ''; public Topic $topic; final public function mount(Topic $topic): void { $this->topic = $topic; } final public function updatingSearch(): void { $this->resetPage(); } /** * @var \Illuminate\Pagination\LengthAwarePaginator */ final protected \Illuminate\Pagination\LengthAwarePaginator $posts { get { $posts = Post::query() ->with('user', 'user.group') ->withCount('likes', 'dislikes', 'authorPosts', 'authorTopics') ->withSum('tips', 'bon') ->where('topic_id', '=', $this->topic->id) ->authorized(canReadTopic: true) ->when($this->search !== '', fn ($query) => $query->where('content', 'LIKE', '%'.$this->search.'%')) ->orderBy('created_at') ->paginate(25); if ($lastPost = $posts->getCollection()->last()) { TopicRead::upsert([[ 'topic_id' => $this->topic->id, 'user_id' => auth()->id(), 'last_read_post_id' => $lastPost->id, ]], [ 'topic_id', 'user_id' ], [ 'last_read_post_id' => DB::raw('GREATEST(last_read_post_id, VALUES(last_read_post_id))') ]); } return $posts; } } final public function render(): \Illuminate\Contracts\View\Factory|\Illuminate\Contracts\View\View|\Illuminate\Contracts\Foundation\Application { return view('livewire.topic-post-search', [ 'topic' => $this->topic, 'posts' => $this->posts, ]); } }