使用由模型属性和相关枢轴计数组成的字段创建包含订单的搜索表单

Question

I'm trying to create a search form for my Laravel app. Basically a user can enter some fields (searchable model related, like the title) and sort it in different ways; title, create date, but also vote count or favorite count. The last two are results from a pivot table (many to many relations).

I've been struggling with this but I don't know how to proceed. Here's what I have so far:

public function search(SearchRequest $request)
{
    $posts = Post::where('published', 1);

    if (strlen($request->title) > 0) {
        $posts->where('title', 'like', '%' . $request->title . '%');
    }

    switch($request->order_by) {
        case 'title' : $orderBy = 'title'; break;
        case 'createDate' : $orderBy = 'created_at'; break;
        case 'favorites' : $orderBy = 'post_favorites.count(*)'; break;
        case 'votes' : $orderBy = 'post_votes.count(*)'; break;
    }

    $posts->orderBy($orderBy, $request->order_by_direction);
    $posts = $posts->get();

    var_dump($posts);
}

To keep it simple I've rewritten the code to a typical blog post example. Thanks for your suggestions.

Answer 1

going to take a stab on it, but its not tested as got nothing to test it on etc, so bear with me, other might take it further simpler, but hope it helps.

public function search(SearchRequest $request)
{

    if(count($request->get('title')) > 0){
        $search_text = $request->get('title');
        $order_by = $request->get('order_by');
        $display_by = $request->get('order_by_direction');

        $search_results = Post::where('title', 'like', '%' . $search_text . '%')->get();

        if($display_by == 'asc') return this::orderSearchResults($search_results, $order_by);

        return this::orderSearchResults($search_results, $order_by)->reverse();

    } else {
        //do something else here
    }
}

private function orderSearchResults($search_results, $order_by)
{
        switch ($order_by) {
            case 'title' :
                return $search_results->sortby('title');
                break;
            case 'createDate' :
                return $search_results->sortby('created_at');
                break;
            case 'favorites' :
                return $search_results->sortby(function($search){
                    return count($search['post_favorites']);
                });
                break;
            case 'votes' :
                return $search_results->sortby(function($search){
                    return count($search['post_votes']);
                });
                break;
            default :
                return $search_results;
                break;
        }
}

the second part is based on the resulted being returned as a collection etc.