HEX
Server: LiteSpeed
System: Linux s1049.use1.mysecurecloudhost.com 4.18.0-477.27.2.lve.el8.x86_64 #1 SMP Wed Oct 11 12:32:56 UTC 2023 x86_64
User: xedaptot (3356)
PHP: 8.3.31
Disabled: NONE
Upload Files
File: /home/xedaptot/iphim.naniguide.com/app/Http/Controllers/ListOrderController.php
<?php

namespace App\Http\Controllers;

use App\Listable;
use App\ListModel;
use Common\Core\BaseController;
use DB;
use Illuminate\Http\JsonResponse;
use Illuminate\Http\Request;

class ListOrderController extends BaseController
{
    /**
     * @var ListModel
     */
    private $list;

    /**
     * @var Request
     */
    private $request;

    /**
     * @param ListModel $list
     * @param Request $request
     */
    public function __construct(ListModel $list, Request $request)
    {
        $this->list = $list;
        $this->request = $request;
    }

    /**
     * @param int $id
     * @return JsonResponse
     */
    public function changeOrder($id) {

        $list = $this->list->findOrFail($id);

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

        $this->validate($this->request, [
            'itemIds'   => 'array|min:1',
            'itemIds.*' => 'integer'
        ]);

        $queryPart = '';
        foreach($this->request->get('itemIds') as $order => $id) {
            $queryPart .= " when id=$id then $order";
        }

        app(Listable::class)
            ->whereIn('id', $this->request->get('itemIds'))
            ->update(['order' => DB::raw("(case $queryPart end)")]);

        return $this->success();
    }
}