<?php

$prices = Price::query()
            ->with('device')
            ->when(request('column', 'name'), function ($q) {
                $q->whereHas('device', function ($q) {
                    $q->orderBy(request('column', 'name'), request('direction', 'desc'));
                });
            })
            ->paginate();