jedrzej / pimpable Goto Github PK

I got the following SQL:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sort' in 'where clause' (SQL: select * from clientswhereclients.deleted_atis null andsortin (created_at, desc) order bycreated_at desc)

When using return $this->model->pimp()->get(); on my ClientRepository, also I'm using the following url api/clients?sort=created_at,desc

Is it possible to perform a global search.. i.e instead of
GET /api/posts
?thread_id=42
&text=%awesome%
&created_at=(ge)201403
&user_id=!666
&sort[]=is_active,desc
&sort[]=created_at,desc
&with=user

can the get request be like GET /api/posts?search=%awesome%

Have you every thought of implementing helper functions to find out which conditions are already being applied in the query string.
When I try to use pagination and multiple filters I end up mistakenly overriding old filters from the query string.

function isPimpable(Model $model)
{
    return isSortable($model) || isWithable($model) || isSearchable($model);
}

function isSortable(Model $model)
{
    return array_intersect(
        [Jedrzej\Sortable\SortableTrait::class],
        class_uses($model))
        ? true : false;
}

function isWithable(Model $model)
{
    return array_intersect(
        [Jedrzej\Withable\WithableTrait::class],
        class_uses($model))
        ? true : false;
}

function isSearchable(Model $model)
{
    return array_intersect(
        [Jedrzej\Searchable\SearchableTrait::class],
        class_uses($model))
        ? true : false;
}

There can be addiotnal function to actually track down the current status and just append new ones, or remove old ones.

function getSortable()
{
    /** @TODO: get the proper 'sort' parameter name */
    return ['sort' => Request::query('sort')];
}

function getSearchable(Model $model)
{
    $searchable = [];

    if (method_exists($model, 'getSearchableAttributes')) {
        $searchable = $model->getSearchableAttributes();
    }

    if (property_exists($model, 'searchable')) {
        $searchable = $model->searchable;
    }

    return array_intersect(array_keys(Request::query()), $searchable);
}

Getting when trying this

ErrorException in Arr.php line 94: array_flip(): Can only flip STRING and INTEGER values!

$this->order
->with($relations)
->pimp(null, ['sort[]' => 'id,asc']);

works fine when I use some array instead of null in the first argument

@jedrzej I think you forgot to create a new tag 0.0.6 ...