File "ChannelContentOrderController.php"

Full Path: /var/www/drive/foundation/src/Channels/ChannelContentOrderController.php
File size: 1.03 KB
MIME-type: text/x-php
Charset: utf-8

<?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();
    }
}