public function top()

in app/Http/Controllers/Api/ProductsController.php [35:46]

• 11 lines of code
• 1 McCabe index (conditional complexity)

    public function top(): array
    {
        $topProducts = DB::select("
            SELECT products.id as id, products.sku as sku, products.name as name, products.stock as stock, sum(order_lines.amount) as sold
            FROM order_lines
            LEFT JOIN products
            ON order_lines.product_id = products.id
            GROUP BY products.id order by sold desc
        ");

        return $topProducts;
    }