alive2212/laravel-query-helper

v4.0.5 2023-04-04 11:17 UTC

This package is auto-updated.

Last update: 2024-04-04 13:29:58 UTC


README

Latest Version on Packagist Software License Build Status Coverage Status Quality Score Total Downloads

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.

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.

Structure

bin/        
config/
src/
tests/
vendor/

Install

Via Composer

$   composer require alive2212/laravel-query-helper

Usage

for using just send array filter like following

    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.

Testing

$ composer test

Contributing

Please see CONTRIBUTING and CODE_OF_CONDUCT for details.

Security

If you discover any security related issues, please email alive2212@yahoo.com instead of using the issue tracker.

Credits

License

The MIT License (MIT). Please see License File for more information.