strprfcrm/app/Http/Controllers/FilterController.php

<?php

namespace App\Http\Controllers;

use App\Http\Requests\FilterRequest;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;

class FilterController extends Controller
{
    const DB_TABLES = [
        'orders'        => 'orders_view',
        'product_sku'   => 'mafs_view',
        'products'      => 'products',
        'reclamations'  => 'reclamations_view',
        'maf_order'     => 'maf_orders_view',
        'import'       => 'imports',
    ];
    public function getFilters(FilterRequest $request)
    {
        $table = $request->validated('table');
        $column = $request->validated('column');
        if(!array_key_exists($table, self::DB_TABLES)) {
            abort(400, 'Table not found');
        }

        $dbTable = self::DB_TABLES[$table];

        if (Schema::hasColumn($dbTable, $column)) {
            $q = DB::table($dbTable)->select($column)->distinct();
            if(!in_array($table, ['reclamations', 'import'])) {
                $q->where('year' , year());
            }
            if (Schema::hasColumn($dbTable, 'deleted_at')) {
                $q->whereNull('deleted_at');
            }
            $result = $q->orderBy($column)->get()->pluck($column)->toArray();
        } else {
            $result = [];
        }

        return response()->json($result, 200, [], JSON_UNESCAPED_UNICODE|JSON_PRETTY_PRINT);
    }
}