App\Http\Controllers\Admin\Operations\SimpleReorderOperation

Complexity

Total Complexity

6

Size/Duplication

Total Lines	84
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	setupSimpleReorderRoutes()	0	12	1
A	saveReorder()	0	40	3
A	reorder()	0	10	1
A	setupSimpleReorderDefaults()	0	11	1

<?php

namespace App\Http\Controllers\Admin\Operations;

use Backpack\CRUD\app\Library\CrudPanel\CrudPanelFacade as CRUD;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Route;
use Illuminate\View\View;

trait SimpleReorderOperation
{
    protected function setupSimpleReorderRoutes(string $segment, string $routeName, string $controller): void
    {
        Route::get("{$segment}/reorder", [
            'as' => "{$routeName}.reorder",
            'uses' => "{$controller}@reorder",
            'operation' => 'reorder',
        ]);

        Route::post("{$segment}/reorder", [
            'as' => "{$routeName}.save.reorder",
            'uses' => "{$controller}@saveReorder",
            'operation' => 'reorder',
        ]);
    }

    protected function setupSimpleReorderDefaults()
    {
        CRUD::set('reorder.enabled', true);

The method set() does not exist on Backpack\CRUD\app\Library\CrudPanel\CrudPanelFacade. Since you implemented __callStatic, consider adding a @method annotation.

        CRUD::allowAccess('reorder');

The method allowAccess() does not exist on Backpack\CRUD\app\Library\CrudPanel\CrudPanelFacade. Since you implemented __callStatic, consider adding a @method annotation.

        CRUD::operation('reorder', function () {

The method operation() does not exist on Backpack\CRUD\app\Library\CrudPanel\CrudPanelFacade. Since you implemented __callStatic, consider adding a @method annotation.

            CRUD::loadDefaultOperationSettingsFromConfig();

The method loadDefaultOperationSettingsFromConfig() does not exist on Backpack\CRUD\app\Library\CrudPanel\CrudPanelFacade. Since you implemented __callStatic, consider adding a @method annotation.

        });

        CRUD::operation('list', function () {
            CRUD::addButton('top', 'reorder', 'view', 'crud::buttons.reorder');

The method addButton() does not exist on Backpack\CRUD\app\Library\CrudPanel\CrudPanelFacade. Since you implemented __callStatic, consider adding a @method annotation.

        });
    }

    public function reorder(): View
    {
        CRUD::hasAccessOrFail('reorder');

The method hasAccessOrFail() does not exist on Backpack\CRUD\app\Library\CrudPanel\CrudPanelFacade. Since you implemented __callStatic, consider adding a @method annotation.

        $column = CRUD::get('reorder.column');

The method get() does not exist on Backpack\CRUD\app\Library\CrudPanel\CrudPanelFacade. Since you implemented __callStatic, consider adding a @method annotation.

        return view('crud::simple-reorder', [
            'entries' => $this->crud->getEntries()->sortBy($column)->keyBy($this->crud->getModel()->getKeyName()),
            'crud' => $this->crud,
            'title' => $this->crud->getTitle() ?? trans('backpack::crud.reorder') . ' ' . $this->crud->entity_name,
        ]);
    }

    public function saveReorder(Request $request): string|false
    {
        CRUD::hasAccessOrFail('reorder');

        $entries = json_decode($request->input('tree'), true);

        if (empty($entries)) {
            return false;
        }

        DB::transaction(function () use ($entries) {
            $primaryKey = $this->crud->model->getKeyName();
            $table = $this->crud->model->getTable();
            $connection = $this->crud->model->getConnectionName();
            $column = $this->crud->get('reorder.column');

            $query = '';
            $bindings = $itemKeys = [];
            $query .= "UPDATE `{$table}` SET `{$column}` = CASE ";
            foreach ($entries as $order => $item) {
                $itemKey = str_replace('list_', '', $item);
                $itemKeys[] = $itemKey;

                $query .= "WHEN `{$primaryKey}` = ? THEN ? ";
                $bindings[] = $itemKey;
                $bindings[] = $order;
            }
            // add the bind placeholders for the item keys at the end the array of bindings
            array_push($bindings, ...$itemKeys);
            $reorderItemsBindString = implode(',', array_fill(0, count($itemKeys), '?'));

            // add the where clause to the query to help match the items
            $query .= "ELSE `{$column}` END WHERE `{$primaryKey}` IN ({$reorderItemsBindString})";

            DB::connection($connection)->statement($query, $bindings);
        });

        $updatedNumber = count($entries);

        return "success for {$updatedNumber} items";
    }
}