gilour

Back Back Up Advanced Editor

<?php

namespace Common\Channels;

use App\Models\Channel;
use Common\Core\BaseController;
use Illuminate\Support\Facades\DB;

class ChannelContentOrderController extends BaseController
{
    public function changeOrder(int $channelId)
    {
        $channel = Channel::findOrFail($channelId);

$this->authorize('update', $channel);

$data = request()->validate([
            'ids' => 'array|min:1',
            'ids.*' => 'int',
            'modelType' => 'required|string',
        ]);

$queryPart = '';
        foreach ($data['ids'] as $order => $id) {
            $queryPart .= " when channelable_id=$id then $order";
        }

DB::table('channelables')
            ->where('channel_id', $channel->id)
            ->whereIn('channelable_id', $data['ids'])
            ->where('channelable_type', $data['modelType'])
            ->update(['order' => DB::raw("(case $queryPart end)")]);

// update timestamp to trigger cache invalidation
        $channel->touch();

return $this->success();
    }
}