Smoothness

A Laravel package to manage WHERE clause.
(This is for Laravel 5+. For Laravel 4.2), _(*1)

Demo, _(*2)

Installation

Execute composer command., _(*3)

composer require sukohi/smoothness:4.*

Preparation

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

use Sukohi\Smoothness\SmoothnessTrait;

class Item extends Eloquent {

    use SmoothnessTrait;

}

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

columns: keys and column names you want to use. (Required)
labels: Labels and keys you want to use. (Optional)
condition: Condition type which are and & or (Optional, Default: auto), _(*6)

protected $smoothness = [
    'columns' => [
        'search_id' => 'id',
        'search_title' => 'title',
        'search_date' => 'created_at'
    ],
    'labels' => [
        'search_id' => 'ID',
        'search_title' => 'Item Title',
        'search_date' => 'Date'
    ],
    'condition' => 'and'
];

Note: If you set auto in condition, you can change condition value through URL params like this., _(*7)

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

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

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

public function scopeFilterTitle($query, $value) {

    return $query->where('title', $value);

}

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

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

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

public function labelFilterTitle() {

    return 'Your Title'.

}

(You may use this tip for switching locale and so on.), _(*12)

Usage

Now you can use a method called smoothness., _(*13)

(in Controller), _(*14)

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

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

(in View), _(*16)

condition: Current condition. and & or., _(*17)

Condition: {{ $smoothness->condition }}

values: Submitted data., _(*18)

@foreach($smoothness->values as $key => $value)
    <input type="text" name="{{ $key }}" value="{{ $value }}">
@endforeach

or

$smoothness->values->get('KEY_NAME');

has_values: Submitted data that has value., _(*19)

@foreach($smoothness->has_values as $column => $value)
    {{ $column }} => {{ $value }}
@endforeach

or

$smoothness->has_values->get('KEY_NAME');

labels: Array values of columns that has value., _(*20)

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

conditions: Array values of columns that has value., _(*21)

@foreach($smoothness->conditions as $key => $boolean)
    <input type="radio" name="condition" value="{{ $key }}"{{ ($boolean) ? ' checked' : '' }}>{{ ($key == 'and') ? 'And' : 'Or' }}
@endforeach

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

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

Change condition

The 1st argument is for setting condition type., _(*23)

Item::smoothness('or')->get();

Relationship

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

(in Controller), _(*25)

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

(in Model), _(*26)

protected $smoothness = [
    'columns' => [
        'items.id' => 'ID',
        'items.title' => 'Title',
        'items.created_at' => 'Date',
        'item_details.address' => 'Address'
    ]
];