sukohi/cahen

A PHP package mainly developed for Laravel to manage sort values of DB table automatically.

Cahen

A PHP package mainly developed for Laravel to manage sort values of DB table automatically.
(This is for Laravel 5+. For Laravel 4.2), _(*1)

Installation

Add this package name in composer.json, _(*2)

"require": {
  "sukohi/cahen": "2.*"
}

Execute composer command., _(*3)

composer update

Register the service provider in app.php, _(*4)

'providers' => [
    ...Others...,  
    Sukohi\Cahen\CahenServiceProvider::class,
]

Also alias, _(*5)

'aliases' => [
    ...Others...,  
    'Cahen'   => Sukohi\Cahen\Facades\Cahen::class
]

Usage

Basic, _(*6)

$model = YourModel::find(1);
\Cahen::move($model)->to('your-column-name', 5);

Up, _(*7)

\Cahen::move($model)->up('your-column-name');

Down, _(*8)

\Cahen::move($model)->down('your-column-name');

to First, _(*9)

\Cahen::move($model)->first('your-column-name');

to Last, _(*10)

\Cahen::move($model)->last('your-column-name');

with Transaction, _(*11)

\DB::beginTransaction();

if(!\Cahen::move($model)->to('your-column-name', 5)) {

    \DB::rollback();

}

\DB::commit();

with Where Clause, _(*12)

You can use where clause to sort within specific record(s)., _(*13)

$model = YourModel::find(1);
\Cahen::move($model)
        ->where('column_1', '=', 'value')
        ->where('column_2', 'LIKE', '%value%')
        ->to('your-column-name', 5);

Set data, _(*14)

You can sort within specific record(s) by setting model object., _(*15)

$moving_id = 1;
$model = YourModel::find($moving_id);
$models = YourModel::where('id', '<', 5)
            ->where('id', '<>', $moving_id)
            ->get();
\Cahen::move($model)
        ->data($models)
        ->to('your-column-name', 3);

• Note: You can not include a record that has ID is $moving_id in $models.

Alignment, _(*16)

$model = YourModel::orderBy('id', 'ASC')->get();
\Cahen::align($model, 'your-column-name');

About Sort Number, _(*17)

The sort value starts from 0., _(*18)

License

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

Copyright 2014 Sukohi Kuhoh, _(*20)