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 |
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 = []; } ?>
Skupni prihodek
V primerjavi s prejšnjim mesecem
Naročila
Zadnjih naročil
Izdelki
Pregled zalog
Stranke
Novi uporabniki
Št. naročila | Kupec | Status | Znesek | Datum | |
---|---|---|---|---|---|
Ni naročil za prikaz. | |||||
# | Ogled |