Thinktomorrow\Chief\Management\Application\SortModels

Complexity

Total Complexity

3

Size/Duplication

Total Lines	27
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	batchUpdateColumn()	0	17	2
A	handle()	0	5	1

<?php
declare(strict_types=1);

namespace Thinktomorrow\Chief\Management\Application;

use Illuminate\Support\Facades\DB;

class SortModels
{
    public function handle(string $modelClass, array $indices): void
    {
        $table = (new $modelClass())->getTable();

        static::batchUpdateColumn($table, 'order', $indices);
    }

    /** Taken from: https://github.com/laravel/ideas/issues/575 */
    private static function batchUpdateColumn(string $table, string $column, array $indices)
    {
        $cases = [];
        $ids = [];
        $params = [];

        foreach ($indices as $index => $modelId) {
            $id = (int) $modelId;
            $cases[] = "WHEN {$id} then ?";
            $params[] = $index;
            $ids[] = $id;
        }

        $ids = implode(',', $ids);
        $cases = implode(' ', $cases);

        DB::update("UPDATE `{$table}` SET `{$column}` = CASE `id` {$cases} END WHERE `id` in ({$ids})", $params);
    }
}