Search threads using whereHas and orWhereHas

readme.md

This example provides functionality of searching records through multiple relations.

Here is used "whereHas" and "orWhereHas" functionality.

To make search with nested boolean expressions here is used hack with $query->where( here goes whereHas and orWhere)

Example based on package https://github.com/cmgmyr/laravel-messenger

ThreadRepository.php

<?php

$q = 'someFirstNameOrLastNameOrCompany';
$limit = 20;

$threads = Thread::latest('updated_at')
	->whereHas('participants', function($query) use($q) {
		$query->whereHas('user', function($query) use($q) {
			//search connected two tables if any of them has record appropriate to $q
			$query->where(function($subQuery) use($q) {
				$subQuery->whereHas('personalContacts', function($query) use($q) {
					$query->whereRaw('(firstName LIKE ? OR lastName LIKE ? OR company LIKE ?)',
						['%'.$q.'%', '%'.$q.'%', '%'.$q.'%']);
					;
				})
				->orWhereHas('companyContacts', function($query) use($q) {
					$query->whereRaw('(firstName LIKE ? OR lastName LIKE ? OR company LIKE ?)',
						['%'.$q.'%', '%'.$q.'%', '%'.$q.'%']);
					;
				});
			})
			;
		});
	})
	->forUser($userId)
	->with(['participants' => function($query) {
		$query->with(['user' => function($q) {
			$q->with(['personalContacts' => function($q){
				$q->with('avatar');
			}, 'companyContacts' => function($q){
				$q->with('avatar');
			}]);
		}, 'user.avatar']);
	}])
	->paginate($limit)
;