soyhuce/laravel-eloquent-extended

Some useful extensions for Eloquent

1.6.0 2024-08-21 09:02 UTC

Requires

• php: ^8.2
• illuminate/contracts: ^10.0 || ^11.0
• illuminate/database: ^10.0 || ^11.0

Requires (Dev)

• friendsofphp/php-cs-fixer: ^3.7
• larastan/larastan: ^2.0.1
• nunomaduro/collision: ^7.10 || ^8.0
• orchestra/testbench: ^8.0 || ^9.0
• pestphp/pest: ^2.24
• pestphp/pest-plugin-laravel: ^2.2
• phpstan/extension-installer: ^1.1
• phpstan/phpstan-deprecation-rules: ^1.0
• phpstan/phpstan-phpunit: ^1.0
• phpunit/phpunit: ^10.4
• soyhuce/next-ide-helper: ^0.19.2
• tpetry/laravel-postgresql-enhanced: ^0.37.0

Suggests

• tpetry/laravel-postgresql-enhanced: Specific PostgreSQL extensions for Eloquent

MIT

• Bastien Philippe

• laravel
• eloquent
• soyhuce

README

This is where your description should go. Limit it to a paragraph or two. Consider adding a small example.

Installation

You can install the package via composer:

composer require soyhuce/laravel-eloquent-extended

Usage

Builder

Misc

• Builder::scope(Illuminate\Database\Eloquent\Scope $score): Builder
• Builder::scoped(\Closure $callable): Builder

Ordering

• Builder::preventInvalidDirection(string $direction): void
• Builder::orderByNullsLast(string $column, string $direction = 'asc'): Builder
• Builder::orderByRawNullsLast(string $sql): Builder
• Builder::orderByAggregate( string $relationName, string $column, string $direction = 'asc', ?string $function = null, ?Closure $constraints = null)
• Builder::orderByExists(string $relation, ?Closure $constraints = null, string $direction = 'asc')
• Builder::orderByExistsDesc(string $relation, ?Closure $constraints = null)
• Builder::orderByCount(string $relation, ?Closure $constraints = null, string $direction = 'asc')
• Builder::orderByCountDesc(string $relation, ?Closure $constraints = null)
• Builder::orderBySum(string $relation, string $column, ?Closure $constraints = null, string $direction = 'asc')
• Builder::orderBySumDesc(string $relation, string $column, ?Closure $constraints = null)
• Builder::orderByMin(string $relation, string $column, ?Closure $constraints = null, string $direction = 'asc')
• Builder::orderByMinDesc(string $relation, string $column, ?Closure $constraints = null)
• Builder::orderByMax(string $relation, string $column, ?Closure $constraints = null, string $direction = 'asc')
• Builder::orderByMaxDesc(string $relation, string $column, ?Closure $constraints = null)

Result

• Builder::random(): Model

Select

• Builder::withAggregateFunction( $relations, \Soyhuce\EloquentExtended\Aggregates\Contracts\AggregateFunction $aggregateFunction): Builder
• Builder::withAnyExists(array $relations, string $alias = 'related_exists') : Builder
• Builder::withImplode($relations, string $column, string $glue, ?string $orderBy = null, string $direction = 'asc') : Builder

Creation

• Builder::insertModels(array $values): bool
• Builder::upsertModels(array $values, string|array $uniqueBy, ?array $update = null): int
• Builder::insertModelsReturning(array $values, array $returning = ['*']): Collection (requires tpetry/laravel-postgresql-enhanced)
• Builder::upsertModelsReturning(array $values, string|array $uniqueBy, ?array $update = null, array $returning = ['*']): Collection (requires tpetry/laravel-postgresql-enhanced)

Eloquent Collection

• Collection::loadAttributes(Closure(Builder): Builder|void $loadWith): Collection

Model traits

LoadsAttributes

• Model::loadAttributes(Closure(Builder): Builder|void $loadWith): Model

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

• Bastien Philippe
• All Contributors

License

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