warehouse/app/Http/Controllers/Items/ShowItemsController.php

<?php

namespace App\Http\Controllers\Items;

use App\Models\Item;
use App\Models\Stock;
use Framework\Routing\Router;

class ShowItemsController
{
    public function handle(Router $router)
    {
        $items = Item::all();
        $stock = Stock::all();

        $totalsByItem = [];

        foreach ($stock as $row) {
            $totalsByItem[$row->item_id] = ($totalsByItem[$row->item_id] ?? 0) + $row->quantity;
        }

        foreach ($items as $item) {
            $item->totalQuantity = $totalsByItem[$item->id] ?? 0;
            $item->isLowStock = $item->reorder_level > 0 && $item->totalQuantity <= $item->reorder_level;
            $item->route = $router->route('view-item', ['item' => $item->id]);
        }

        return view('items/index', [
            'items' => $items,
            'createAction' => $router->route('show-create-item-form'),
            'canManage' => session()->has('user_id'),
        ]);
    }
}