File: /home/imensosw/www/mpl.imenso.co/app/Typeahead/UserTypeahead.php
<?php
namespace App\Typeahead;
use App\Models\User;
class UserTypeahead extends TypeaheadBuilder
{
public function get($total = 10)
{
$query = User::where('first_name', 'LIKE', '%'.$this->search_string.'%')
->orWhere('last_name', 'LIKE', '%'.$this->search_string.'%')
->orWhere('venue_name', 'LIKE', '%'.$this->search_string.'%')
->orWhere('artist_name', 'LIKE', '%'.$this->search_string.'%')
->orWhere('promoter_name', 'LIKE', '%'.$this->search_string.'%')
->orWhere('contact_name', 'LIKE', '%'.$this->search_string.'%');
$this->data = $query->take($total)->get()
->pluck('full_name', 'id');
return $this->output();
}
}