PHP code example of nahid-ferdous / laravel-searchable

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

nahid-ferdous / laravel-searchable example snippets

# Example Model:
use NahidFerdous\Searchable\Searchable;

class User extends Authenticatable
{
    use Searchable;
    
    public function country()
    {
        return $this->belongsTo(Country::class);
    }
    
    public function posts()
    {
        return $this->hasMany(Post::class);
    }
}

# Usage:
$searchQuery = request('search_query');
$users = User::search($searchQuery, ['%name', '%email', 'phone'])->get();

# Output:
User::where('name', 'like', '%'.$searchQuery.'%')
    ->orWhere('email', 'like', '%'.$searchQuery.'%')
    ->orWhere('phone', $searchQuery)
    ->get();

# Usage: 
$searchQuery = request('search_query'); // e.g. 'bangladesh'
$users = User::search($searchQuery, [
        '%name',
        '%email',
        '%phone',
        'country|%name',
        'country.city|%$name'
    ])->get();

# Output:
User::where('name', 'like', '%'.$searchQuery.'%')
    ->orWhere('email', 'like', '%'.$searchQuery.'%')
    ->orWhere('phone', 'like', '%'.$searchQuery.'%')
    ->orWhereHas('country', function ($query) use ($searchQuery) {
        $query->where('name', 'like', '%'.$searchQuery.'%');
    })
    ->orWhereHas('country.city', function ($query) use ($searchQuery) {
        $query->where('name', 'like', '%'.$searchQuery.'%');
    })
    ->get();

# Usage:
$searchQuery = request('search_query');
$users = User::search($searchQuery, [
        '%first_name',
        '%last_name',
        '%first_name+last_name',
    ])->get();


# Output:
User::where('first_name', 'like', '%'.$searchQuery.'%')
    ->orWhere('last_name', 'like', '%'.$searchQuery.'%')
    ->orWhere(DB::raw("concat(first_name, ' ', last_name)"), 'LIKE', "%" . $searchQuery . "%");
    ->get();

# Usage:
$searchQuery = request('search_query');
$status = request('status');
$users = User::search($searchQuery, [
        '%first_name',
        '%last_name',
        '%first_name+last_name',
    ])
    ->search(request('status'), ['status'])
    ->get();


# Output:
User::where('first_name', 'like', '%'.$searchQuery.'%')
    ->orWhere('last_name', 'like', '%'.$searchQuery.'%')
    ->orWhere(DB::raw("concat(first_name, ' ', last_name)"), 'LIKE', "%" . $searchQuery . "%")
    ->where('status', $status)
    ->get();

# Usage:
$status = request('status');
$date = request('date'); // e.g. 2020-01-01 
$users = User::search($status, ['status'])
    ->searchDate($date, ['created_at'], '>');
    ->get();

# Output:
User::where('status', $status)
    ->whereDate('created_at', '>', $date)
    ->get();

# Usage:
$status = request('status');
$dateRange = request('date_range'); // e.g. 2020-01-01 - 2020-01-31 // Must be separated by space and -
$users = User::search($status, ['status'])
    ->searchDate($dateRange, ['created_at'], '><');
    ->get();

# Output:
$startDate = explode(' - ', $dateRange)[0];
$endDate = explode(' - ', $dateRange)[1];
$start = Carbon::parse($startDate);
$end = Carbon::parse($endDate);
User::where('status', $status)
     ->whereBetween($relationAttribute, [$start, $end]);
    ->get();

sh
php artisan vendor:publish --provider="NahidFerdous\Searchable\SearchableServiceProvider"