luadotsh/lua

use Illuminate\Http\Request;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\DB;
use App\Models\Media;
 
class MediaController extends Controller
{
    // ...
 
    public function sort(Request $request)
    {
        $request->validate([
            'medias' => ['required', 'array'],
            'model' => 'required',
            'collection' => 'required',
        ]);
 
        DB::beginTransaction();
 
        try {
            foreach ($request->medias as $sort => $media) {
 
                $media = Media::where('id', $media['id'])
                ->where('model_type', $request->model)
                ->where('collection_name', $request->collection)
                ->firstOrFail();
 
                $media->order_column = $sort + 1;
                $media->save();
            }
 
            DB::commit();
            return response()->json();
        } catch (\Exception $e) {
            DB::rollBack();
            Log::error($e);
            return response()->json(['status' => 'error', 'message' => 'Could not sort update, please try again.'], 500);
        }
    }
 
    // ...
}