Order 패키지 사용법(Orderable)

# What?

순서변경 패키지인데 indexQuery랑 같이 사용할 시 오류가 있어서 특정 처리를 필요함

 

# How?

composer require michielkempen/nova-order-field

@ App\Models\Model.php

use Spatie\EloquentSortable\Sortable;
use Spatie\EloquentSortable\SortableTrait;

class MyModel extends Model implements Sortable
{
    use SortableTrait;

    public $sortable = [
        'order_column_name' => '컬럼명',
        'sort_when_creating' => true,
    ];

    // ...
}

@ App\Nova\Model.php

class Model extends Resource
{
    use Orderable;
    
    public static $defaultOrderField = 'order';
    
    public function fields(Request $request)
    {
        return [
            OrderField::make('Order'),
        ];
    }
}

 

* indexQuery 사용 시 같이 적용하는법

    public static function indexQuery(NovaRequest $request, $query)
    {
        $query = $query->where("for_order", false);

        if(static::canQueryPivotOrder() && $pivot = static::orderedManyPivotModel($request)) {
            return static::orderedPivotIndexQuery($request, $query, $pivot);
        }

        if(!static::canQueryOrder()) {
            return $query;
        }

        return static::orderedIndexQuery(
            $query,
            static::orderByFieldAttribute($request)
        );
    }