query("SELECT COUNT(*) as orders_count, COALESCE(SUM(total_amount),0) as revenue FROM orders"); $stats = $stmt->fetch(PDO::FETCH_ASSOC); $orders_count = $stats['orders_count'] ?? 0; $revenue = $stats['revenue'] ?? 0.00; // Products count $stmt = $pdo->query("SELECT COUNT(*) FROM products"); $products_count = (int)$stmt->fetchColumn(); // Customers count $stmt = $pdo->query("SELECT COUNT(*) FROM customers"); $customers_count = (int)$stmt->fetchColumn(); // Recent orders (latest 10) $stmt = $pdo->prepare("SELECT id, customer_name, status, total_amount, created_at FROM orders ORDER BY created_at DESC LIMIT 10"); $stmt->execute(); $recentOrders = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e) { // Graceful fallback to zeros/empty if the DB query fails $orders_count = $orders_count ?? 0; $revenue = $revenue ?? 0.00; $products_count = $products_count ?? 0; $customers_count = $customers_count ?? 0; $recentOrders = []; } ?> Administracija | Čebelarstvo Cigoj

Čebelarstvo Cigoj

Administracija

Nadzorna plošča

Admin

Skupni prihodek

V primerjavi s prejšnjim mesecem

Naročila

Zadnjih naročil

Izdelki

Pregled zalog

Stranke

Novi uporabniki

Zadnja naročila

Prikaži vse

Št. naročila	Kupec	Status	Znesek	Datum
Ni naročil za prikaz.
#					Ogled

Izdelki z nizko zalogo

Prikaži vse

Izdelek	ID	Zaloga	Status
Cvetni prah 50g 4,50€	PRD-001	3	Nizka zaloga	Uredi
Balzam za ustnice 2,50€	PRD-005	5	Opozorilo	Uredi