<?php
declare(strict_types=1);

namespace App\Helpers;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Str;

class DBHelper
{
    /**
     * @param $column
     * @return array
     */
    public static function getFilters($column, $model): array
    {
        $uniqueValues =  DB::table((new $model)->getTable())
            ->select($column)
            ->distinct()
            ->get()
            ->pluck($column)
            ->toArray();
        $result = [];
        foreach ($uniqueValues as $val){
            if(str_ends_with($column, '_id')) {
                $relation = Str::camel(str_replace('_id', '', $column));
                $result[$val] = $model::query()->where($column, '=', $val)->first()->$relation->name;
            } else {
                $result[$val] = $val;
            }
        }
        return $result;
    }
}