Reputation: 739

Laravel sort group array in collection

I get a collection after database query. And then I group it by passing a closure callback. And then last, I want to sort these grouped array in collection using each which pass a closure callback to sort array. But NOT working. Maybe it's protected , how to achieve this?

My code at PostController

$post->comments = $post->comments->groupBy(function($comment){
    return $comment->parent_id == null ? "-1": $comment->parent_id;
})->each(function($comment){
    // TODO: sort array
    uasort($comment, function($a, $b){
        return $a->created_at->lte($b->created_at)? 1: -1;
    });
    return $comment;
});
    Debugbar::info($post->comments);

Info of $post->comments

You can see that group of "-1" is not order by creation date.

Upvotes: 1

Answers (2)

Hugo Gresse

Reputation: 17899

I was searching for something related : I have to manipulate my data from Eloquent in the controller before passing it to the view. So for example :

$events = App\Models\Event::->get();
$eventsDecade = [];
    foreach ($events as $key => $value) {
        $decade = substr(date('Y', strtotime($value->date)), 0, -1)."0"; 
        $eventsDecade[$decade][] = new App\Models\Event($value->toArray());
    }

By doing this I'm creating a new array with the decade and inside each decade an Event Object that i can use as a normal object : {{ $event->name }} in a foreach for example. Not sure your question was exactly that...

Upvotes: 0

tjfdfs

Reputation: 739

So far, I achieve this by create a private function in controller to process grouped comment collection object.

This is how the function like:

private function commentToArrayAndSort(Illuminate\Database\Eloquent\Collection $groupedComments, Closure $sortClosure, Closure $childrenSortClosure = null)
{
    $formattedComments = array();
    $keys = array_keys($groupedComments->toArray());
    for($i = 0; $i < count($keys); $i++)
    {
        $comments = $groupedComments[$keys[$i]];
        $formattedComments[$keys[$i]] = array();
        $counter = 0;
        foreach($comments as $comment)
        {
            $commentArr = $comment->toArray();
            $commentObj = new Comment(array(
                "id" => $commentArr['id'],
                "user_id" => $commentArr['user_id'],
                "post_id" => $commentArr['post_id'],
                "parent_id" => $commentArr['parent_id'],
                "comment" => $commentArr['comment'],
                "created_at" => $commentArr['created_at'],
                "updated_at" => $commentArr['updated_at'],
            ));

            $commentObj->setRelations(array('author'=>new User($comment->toArray()['author'])));
            array_push($formattedComments[$keys[$i]], $commentObj);
            $counter++;
        }

        // Sort Array
        if ($counter > 1) {
            uasort($formattedComments[$keys[$i]], $sortClosure);
        }
    }

    return $formattedComments;
}

And then call it like this:

    $post->comments = $this->commentToArrayAndSort($groupedComments, function($a, $b){
        return $a->created_at->gte($b->created_at) ? -1 : 1;
    });

I don't know if there's a better solution for this. So far I got this. If anyone can improve my answer or has a better solution, plz post it to share and give me a help

Thanks :)

Upvotes: 1

Laravel sort group array in collection

Answers (2)

Related Questions