How to get top selling Laravel products?

Question

Laravel

Good afternoon.

$bestProductIds = Order::get()->map->products->flatten()->map->pivot->mapTogroups( function ($pivot) {
            return [$pivot->product_id => $pivot->count];
        })->map->sum()->sortDesc()->take(3)->keys()->toArray();

        $bestProducts = Product::whereIn('id', $bestProductIds)->get();

$bestProductIds contains product IDs from largest to smallest, that is, the first ID is where there are more sales.
Outputs 4, 5, 1

But when selecting $bestProducts using the whereIn method, they are displayed not in the same order, but in chronological order, 1, 4, 5

How to get them in the order that lies in the $bestProductIds array?

Answer 1

Will it fit? https://coderoad.ru/38574669/Laravel-%D1%81%D0%BE%...

Answer 2

Good afternoon, add sorting in the order you need.

$bestProductIds = Order::get()->map->products->flatten()->map->pivot->mapTogroups(function ($pivot) {
            return [$pivot->product_id => $pivot->count];
        })->map->sum()->sortDesc()->take(3)->keys()->toArray();
        
        $bestProductIdsStr = implode(',', $bestProductIds);
        $bestProducts = Product::whereIn('id', $bestProductIds)
            ->orderByRaw(DB::raw("FIELD(id, $bestProductIdsStr)"))
            ->get();