appslabke / laravel-easy-search
Simplified Laravel search
Requires
- php: ^7.1|8.0
- doctrine/dbal: ^2.8
Requires (Dev)
- orchestra/testbench: ^4.0
README
This is where your description should go. Try and limit it to a paragraph or two. Consider adding a small example.
Installation
You can install the package via composer:
composer require appslabke/laravel-easy-search
Usage
Add config vendor:publish --provider="AppsLab\LaravelEasySearch\LaravelEasySearchBaseServiceProvider"
This will add the config file which you can customize
namespace
= allow you to set you filter and module namespace,
location
= allow to set the location for your filter and model
autogenerate-query-builds
= This help in autogenerating query build it is used by filter command to auto generate filter query
queries-types
= this is used to auto complete query type
How to add your own builder.
- Create new service provider
BuildServiceProvider
- Under boot method add you builds using Search Facede as shown
Search::builds([
NameBuild::class
])
Don't forget to add your service provider to app.config providers
App\Providers\BuildServiceProvider::class,
Working with Laravel Easy Search
-
add search on model
-
Global search
- This allow you to search all the columns in the table.
- Laravel easy search will search the table only with the filters generated on production but will through an error on local/development.
- If you want to ignore some columns you can second arguments to ignore the columns.
->allowedColumns(['id', 'created_at', 'updated_at'])
- by default global search users
search
as the query filter you can replace that by adding the first parameter
->searchAllColumns('filter')
Make sure you check the
Add Searchable trait to your model
You can now use Laravel searchable as
//First make sure you extend Search facade on your controller use AppsLab\LaravelEasySearch\Facades\Search; class NameController extends Controller { public index(){ $results = Search::model(Model::class) //Allowed Collumns methods guide you to search only columns added by default if you don't add allowedColumn all solumns will be return ->allowedColumns(['name']) //Applying filter from your request ->applyFilter() //This will search using the filters you generated if filter is not available it will throw a class does not exist error. You can change the filter from the request by adding an array with the key as the filter and the value as the request key ->applyFilter(['search_name' => 'name']) This will replace the search_name with name. Name is the filter name //Sort by allow you to sort the result pass an array ->sortBy('column','ASC') //Do you want to add a query? yeah you can do that by building your query connect to the model ->buildQuery('whereHas', ['warehouse', function(Builder $query){ $query->where('name' , 'like', '%neo%'); }]) //You can add relation addRelation as string or array ->addRelation('users') // use first to get first item on search ->first() } }
use Searchable;
$skeleton = new Spatie\Skeleton(); echo $skeleton->echoPhrase('Hello, Spatie!');
Changelog
Please see CHANGELOG for more information on what has changed recently.
Contributing
Please see CONTRIBUTING for details.
Security
If you discover any security related issues, please email developers@appslab.co.ke instead of using the issue tracker.
Credits
Support us
We are a mixture of technologists, analysts and designers pushing boundaries of what’s possible in problem solving for businesses and communities, and while we are at it we have fun. Apps:Lab KE
Mpesa Contribution
coming soon
License
The MIT License (MIT). Please see License File for more information.