sukohi/neatness

A Laravel package to automatically add sorting system for DB query and provide URLs to switch between ASC and DESC.

Neatness

A Laravel package to automatically add sorting system for DB query and provide URLs to switch between ASC and DESC.
(This is for Laravel 5+. For Laravel 4.2), _(*1)

Demo, _(*2)

Installation

Execute composer command., _(*3)

composer require sukohi/neatness:4.*

Preparation

At first, set NeatnessTrait in your Model., _(*4)

use Sukohi\Neatness\NeatnessTrait;

class Item extends Eloquent {

    use NeatnessTrait;

}

Secondary, add configuration values also in your Model., _(*5)

default: Default key and direction. (Required)
columns: Keys and column names you want to sort. (Required)
symbols: Labels you will be able to use in your View. (Optional)
symbols: Symbols you will be able to use in your View. (Optional)
appends: Keys you want to append to URLs. (Optional), _(*6)

protected $neatness = [
    'default' => ['sort_id', 'desc'],
    'columns' => [
        'sort_id' => 'id',
        'sort_title' => 'title',
        'sort_date' => 'created_at'
    ],
    'labels' => [
        'sort_id' => 'ID',
        'sort_title' => 'Title',
        'sort_date' => 'Date'
    ],
    'symbols' => [
        'asc' => '<i class="fa fa-sort-asc"></i>',
        'desc' => '<i class="fa fa-sort-desc"></i>',
        'default' => '<i class="fa fa-sort"></i>'
    ],
    'appends' => ['name']
];

Multiple columns: If you want to sort by multiple columns, you can use delimiter | like so., _(*7)

'columns' => [
    'id_n_title' => 'id|title'
],

Query Scope: You also can utilize Query Scopes instead of column name., _(*8)

'columns' => [
    'scope_title' => 'scope::sortTitle'
],

in this case, you need to prepare a scope method in your model. (About Query Scopes), _(*9)

public function scopeSortTitle($query, $direction) {

    return $query->orderBy('title', $direction);

}

Label: You can use label:: prefix to call a specific method., _(*10)

'labels' => [
    'title' => 'label::SortTitle'
],

in this case, you need to prepare a method in your model., _(*11)

public function labelSortTitle() {

    return 'Your Title'.

}

Usage

Now you can use a method called neatness., _(*12)

(in Controller), _(*13)

$items = Item::neatness()->get();

After call neatness(), you can access to sort data through $neatness., _(*14)

(in View), _(*15)

key: The key name sorting now., _(*16)

Key: {{ $neatness->key }}

column: The column name sorting now., _(*17)

Column: {{ $neatness->column }}

direction: The Direction sorting now. asc or desc, _(*18)

Direction: {{ $neatness->direction }}

urls: URLs to switch sort., _(*19)

@foreach($neatness->urls as $key => $url)
    {{ $key }} => {{ $url }}
@endforeach

or 

$neatness->urls->get('title');

all_urls: All URLs to switch sort., _(*20)

@foreach($neatness->all_urls as $key => $urls)
    @foreach($urls as $direction => $url)
        {{ $direction }} => {{ $url }}<br>
    @endforeach
@endforeach

or 

$neatness->all_urls->get('title');          // Array
$neatness->all_urls->get('title')['desc']   // URL

labels: Labels you set in your Model., _(*21)

@foreach($neatness->labels as $key => $label)
    {{ $key }} => {{ $label }}
@endforeach

or 

$neatness->labels->get('title');

symbols: Symbols plucked with sort state., _(*22)

@foreach($neatness->symbols as $key => $symbol)
    {{ $key }} => {{ $symbol }}
@endforeach

or 

$neatness->symbols->get('title');

texts: Texts mainly for link., _(*23)

@foreach($neatness->urls as $key => $url)
    <a href="{{ $url }}">{{ $neatness->texts->get($key) }}</a>
@endforeach

or 

$neatness->texts->get('title');

appends: Array values for pagination, _(*24)

{{ $items->appends($neatness->appends)->links() }}

Change default column and direction

By this way, you can change default column and direction., _(*25)

Item::neatness('title', 'desc')->get();

Relationship

You can use this package with relationship using join()., _(*26)

(in Controller), _(*27)

$items = Item::join('item_details', 'item_details.item_id', '=', 'items.id')
            ->neatness()
            ->paginate(5);

(in Model), _(*28)

protected $neatness = [
    'default' => ['items.id', 'desc'],
    'columns' => [
        'id' => 'items.id',
        'title' => 'items.title',
        'date' => 'items.created_at',
        'address' => 'item_details.address'
    ]
];

License

This package is licensed under the MIT License., _(*29)

Copyright 2016 Sukohi Kuhoh, _(*30)