PHP code example of dlimars / laravel-searchable

1. Go to this page and download the library: Download dlimars/laravel-searchable library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

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

dlimars / laravel-searchable example snippets


    class MyModel extends Model {
        use Dlimars\LaravelSearchable\Searchable;
        private $searchable = [
            'name'          => 'LIKE',
            'id'            => 'MATCH',
            'created_at'    => 'BETWEEN'
        ];
    }


    $filters = [
        'name'          => 'foo bar',
        'id'            => '10',
        'created_at'    => ['2010-01-01 00:00:00', '2015-01-01 23:59:59']
    ];

    $users = User::search($filters)->get();
    // produces $query->where('name', 'LIKE', '%foo%')
    //                ->where('name', 'LIKE', '%bar%')
    //                ->where('id', '10')
    //                ->where('created_at', '>=', '2010-01-01 00:00:00')
    //                ->where('created_at', '<=', '2015-01-01 23:59:59')

    $filters = [
        'created_at'    => ['2010-01-01 00:00:00', null]
    ];
    //  produces $query->where('created_at', '>=', '2010-01-01 00:00:00')

    $filters = [
        'created_at'    => [null, '2015-01-01 23:59:59']
    ];
    //  produces $query->where('created_at', '<=', '2015-01-01 23:59:59')


    $users = User::search($request()->all())->get();


    'LIKE'      // produces $query->where('field', 'LIKE', '%{$value}%')
    'MATCH'     // produces $query->where('field', $value)
    'BETWEEN'   // produces $query->where('field', '>=', $value[0])
                //                ->where('field', '<=', $value[1])


    class Customer extends EloquentModel
    {
        use Searchable;
        
        public $fillable = [
            'firstname',
            'lastname'
        ];
        
        public $searchable = [
            'id'    => 'MATCH',
            'name'  => 'myCustomSearchByName'
        ]
        
        public function scopeMyCustomSearchByName($queryBuilder, $name)
        {
            $name = str_slug($name, "%");
    
            $queryBuilder->where(
                \DB::raw('CONCAT(firstname, " ", lastname'),
                'LIKE',
                "%{$name}%"
            );
        }
    }