Download the PHP package thytanium/eloquent-positionable without Composer
On this page you can find all versions of the php package thytanium/eloquent-positionable. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download thytanium/eloquent-positionable
More information about thytanium/eloquent-positionable
Files in thytanium/eloquent-positionable
Package eloquent-positionable
Short Description Use a position property to sort Eloquent models
License MIT
Informations about the package eloquent-positionable
thytanium/eloquent-positionable
Use a property to sort Eloquent models.
This is a zero-config package that provides a trait to handle positioning/sorting capabilities for Eloquent models.
Compatibility
PHP >= 8.0 and Laravel >= 8.0.
Installation
This package can be installed through composer.
Don't worry about service providers. This package doesn't expose service providers.
Usage
- Add the trait
Thytanium\EloquentPositionable\Positionable
to your model. - Optionally, specify the column name.
- If no column name is provided, the column
position
will be used for positioning models.
- If no column name is provided, the column
Creating a new model will automatically assign the next available position.
API
Sorting
moveTo(int $position)
Moves the model to the indicated position.
moveToStart()
Moves the model to the start.
moveToEnd()
Moves the model to the end.
moveUp(?int $places = 1)
Moves the model the indicated amount of places up. Default 1
.
moveDown(?int $places = 1)
Moves the model the indicated amount of places down. Default 1
.
moveStep(int $step)
Moves the model by position change (step). A positive values moves the model up. A negative value moves the model down.
setNewOrder(array $ids, int $startPosition = 1, ?string $primaryKeyColumn = null)
Sets a new order for the specified ids.
Querying
ordered($order = 'asc'): \Illuminate\Database\Eloquent\Builder
Query scope to sort models by their position, i.e get the sorted list.
position(int $position): \Illuminate\Database\Eloquent\Builder
Query scope to search models with position equal to $position
.
positionBetween(array $between): \Illuminate\Database\Eloquent\Builder
Query scope to search models with position between 2 values.
Swaping
swapPositions(\Illuminate\Database\Eloquent\Model|int $target)
Swap positions with another model or position.
Groups
In the case your model has grouping fields, like user_id
, it can be taken care of by indicating the grouping column names:
Example
id | user_id | position |
---|---|---|
1 | 1 | 1 |
2 | 1 | 2 |
3 | 1 | 3 |
4 | 2 | 1 |
Caveats
Although this trait makes sure the same position is not used by more than one model, do not add a UNIQUE
index to the position column. This will be overcome in future releases.
Tests
The package contains unit/integration tests set up with PHPUnit.
Changelog
Please see CHANGELOG.md for more information on what has changed recently.
Contributing
Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.
If you have a suggestion that would make this better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement". Don't forget to give the project a star! Thanks again!
- Fork the Project
- Create your Feature Branch (
git checkout -b feature/AmazingFeature
) - Commit your Changes (
git commit -m 'Add some AmazingFeature'
) - Push to the Branch (
git push origin feature/AmazingFeature
) - Open a Pull Request
Alternatives
License
The MIT License (MIT). Please see License File for more information.