Manual Order

use DataTables;
 
Route::get('user-data', function() {
    $model = App\User::query();
 
    return DataTables::eloquent($model)
                ->order(function ($query) {
                    if (request()->has('name')) {
                        $query->orderBy('name', 'asc');
                    }
 
                    if (request()->has('email')) {
                        $query->orderBy('email', 'desc');
                    }
                })
                ->toJson();
});