sortable - GitLite

KO | EN

gitlite — search

#llm #golang #rust #deep-learning #linux #docker #nodejs #macos #awesome #cli #awesome-list #vue #security #openai

sortable

(★ 52)

Sorting functionality for Laravel's Eloquent models

파일 탐색기

최종 버전 다운로드 (.zip)

- - _bootstrap.php
  - CriterionTest.php
  - SortableTraitTest.php
  - TestBuilder.php
  - TestModel.php
  - TestModelWithAllFieldsSortable.php
  - TestModelWithDefaultSortingCriteria.php
  - TestModelWithDefaultSortOrder.php
  - TestModelWithSortableCallbackMethod.php
  - TestModelWithSortableMethod.php
  - TestModelWithSortableProperty.php
- _bootstrap.php
- unit.suite.yml
.gitignore
.scrutinizer.yml
codeception.yml
composer.json
LICENSE
README.md

# 설치 가이드

1. 코드 내려받기

git clone https://github.com/jedrzej/sortable

깃허브에서 프로젝트 코드 전체를 내 컴퓨터로 내려받습니다.

cd sortable

방금 내려받은 프로젝트 폴더 안으로 이동합니다.

2. PHP (Composer)

쉬움 추천

사전 준비물

Git GitHub에서 프로젝트 코드를 내려받으려면 필요합니다.
PHP PHP 실행 환경이 필요합니다.
Composer PHP 라이브러리 설치를 위한 패키지 매니저입니다.

composer require "jedrzej/sortable" "0.0.12"

이 명령어를 터미널에 그대로 입력해 실행하세요.

✅ php -S localhost:8000 같은 내장 서버로 실행한 뒤 브라우저에서 http://localhost:8000 으로 접속해보세요.

이 레포의 README에 적힌 실제 명령어를 그대로 가져왔습니다.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Sortable trait for Laravel's Eloquent models

This package adds sorting functionality to Eloquent models in Laravel 4/5/6.

You could also find those packages useful:

- [Searchable](https://github.com/jedrzej/searchable) - Allows filtering your models using request parameters
- [Withable](https://github.com/jedrzej/withable) - Allows eager loading of relations using request parameters
- [Pimpable](https://github.com/jedrzej/pimpable) - A meta package that combines Sortable, Searchable and Withable behaviours

## Composer install

Add the following line to `composer.json` file in your project:

"jedrzej/sortable": "0.0.12"

or run the following in the commandline in your project's root folder:

composer require "jedrzej/sortable" "0.0.12"

## Setting up sortable models

In order to make an Eloquent model sortable, add the trait to the model and define a list of fields that the model can be sorted by.
You can either define a `$sortable` property or implement a `getSortableAttributes` method if you want to execute some logic to define
list of sortable fields.

```php
use Jedrzej\Sortable\SortableTrait;

class Post extends Eloquent
{
    use SortableTrait;

// either a property holding a list of sortable fields...
    public $sortable = ['title', 'forum_id', 'created_at'];

// ...or a method that returns a list of sortable fields
    public function getSortableAttributes()
    {
        return ['title', 'forum_id', 'created_at'];
    }
}
```

In order to make all fields sortable put an asterisk `*` in the list of sortable fields:

```php
public $sortable = ['*'];
```

## Sorting models

`SortableTrait` adds a `sorted()` scope to the model - you can pass it a query being an array of sorting conditions:

```php
// return all posts sorted by creation date in descending order
Post::sorted('created_at,desc')->get();

// return all users sorted by level in ascending order and then by points indescending orders
User::sorted(['level,asc', 'points,desc'])->get();
```
or it will use `sort` parameter from the request as default:

```php   
// return all posts sorted by creation date in descending order by appending to URL
?sort=created_at,desc
//and then calling
Post::sorted()->get();

// return all users sorted by level in ascending order and then by points indescending orders by appending to URL
?sort[]=level,asc&sort[]=points,desc
// and then calling
User::sorted()->get();
```
## Overwriting default sorting logic

It is possible to overwrite how sorting parameters are used and applied to the query by implementing a callback in your
model named `sortFieldName`, e.g.:
```php
// return all posts sorted by creation date in descending order
Post::sorted('created_at,desc')->get();

// in model class overwrite the sorting logic so that 'created' field is used instead of 'created_at'
public function sortCreatedAt($query, $direction = 'desc')
{
    return $query->orderBy('created', $direction);
}
```

## Defining default sorting criteria

It is possible to define default sorting criteria that will be used if no sorting criteria are provided in the request or
passed to `sorted` method of your model. Default sorting criteria should be defined in $defaultSortCriteria property, e.g.:

```php
// sort by latest first
protected $defaultSortCriteria = ['created_at,desc'];
```

## Defining default sorting order

By default asc is considered as default sorting order. It is possible to define default sorting order that will be used if no sorting order is provided in the request or
passed to `sorted` method of your model. Default sorting order should be defined in $defaultSortOrder property, e.g.:

```php
// sort in desc order by default if no order is specified in request
protected $defaultSortOrder = 'desc';
// sort in asc order by default if no order is specified in request
protected $defaultSortOrder = 'asc';
```

## Additional configuration

If you are using `sort` request parameter for other purpose, you can change the name of the parameter that will be
 interpreted as sorting criteria by setting a `$sortParameterName` property in your model, e.g.:
```php
 protected $sortParameterName = 'sortBy';
```