Allow all filters for a generic purpose query

[fbramato]

Hi,

maybe is against the library philosophy, but i would create a generic controller dynamically load a Model and execute a query on it using querystring parameters, allowing all filters.

The reason why i would do this is to have a single controller to fill our dropdowns quickly having a big dataentry application with a lots of dynamic dropdowns based on database tables.

Example:

class RecordTabsController extends Controller
{
    //
    public function getRecords(Request $request)
    {
        return QueryBuilder::for($request->class)
            ->allowedFilters('*')
            ->get();
    }
}

callable with /api/records?class=App\Models\Common\TabTipiParametriOmv&filter[visibile]=1

I know is not really a great idea to expose class names, we have like hundred of records table :(

[fbramato]

I've figured out by myself, wasnt so hard :)

public function getRecords(Request $request)
    {
        $query = QueryBuilder::for($request->class);

        $attributes = $query->getSubject()->getModel()->getFillable();
        $attributes[] = $query->getSubject()->getModel()->getKeyName();

        $query->allowedFilters($attributes)->allowedSorts($attributes);

        return $query->get();
    }