alive2212/laravel-query-helper

Laravel Query Helper

LaravelQueryHelper

![Software License][ico-license] ![Coverage Status][ico-scrutinizer] ![Total Downloads][ico-downloads], _(*1)

Note: Replace Babak Nodoust https://github.com/Alive2212 http://babakn.com alive2212@yahoo.com Alive2212 LaravelQueryHelper Laravel Query Helper with their correct values in README.md, CHANGELOG.md, CONTRIBUTING.md, LICENSE.md and composer.json files, then delete this line. You can run $ php prefill.php in the command line to make all replacements at once. Delete the file prefill.php as well., _(*2)

This Package is smart deep where condition helper. you can deep where condition with many relation with just "." between your model and get your results., _(*3)

Structure

bin/        
config/
src/
tests/
vendor/

Install

Via Composer, _(*4)

``` bash $ composer require alive2212/laravel-query-helper, <sub>(*5)</sub>

## Usage

for using just send array filter like following
``` php
    protected $filters = [ // or where condition every thing here
        [ // and  where condition every thing here
            ['id', '=', 1],
            ['title', '=', 'test'],
            ['folan.id', '=', 2],
            ['folan.bahman.id', '=', 3],
            ['folan.title', '=', 'test'],
            ['folan.bahman.amount', '>', 1000],
        ],
        [
            ['id', '=', 4],
            ['folan.id', '=', 5],
            ['folan.title', '=', 'test123'],
            ['folan.bahman.id', '=', 1],
            ['folan.bahman.title', '=', 'test2'],
        ],
        [
            ['id', '=', 7],
            ['folan.id', '=', 8],
            ['folan.title', '=', 'test1234'],
            ['folan.bahman.id', '=', 9],
            ['folan.bahman.title', '=', 'test21'],
        ]
    ];

Change log

Please see CHANGELOG for more information on what has changed recently., <sub>(*6)</sub>

Testing

bash $ composer test, <sub>(*7)</sub>

Contributing

Please see CONTRIBUTING and CODE_OF_CONDUCT for details., <sub>(*8)</sub>

Security

If you discover any security related issues, please email alive2212@yahoo.com instead of using the issue tracker., <sub>(*9)</sub>

Credits

• Babak Nodoust
• All Contributors

License

The MIT License (MIT). Please see License File for more information., <sub>(*10)</sub>