query("SELECT COUNT(*) FROM products")->fetchColumn(); $lowStockCount = (int)$pdo->query("SELECT COUNT(*) FROM products WHERE stock <= 5")->fetchColumn(); $totalCustomers = (int)$pdo->query("SELECT COUNT(*) FROM customers")->fetchColumn(); $stmt = $pdo->query(" SELECT COUNT(*) as invoices_count, COALESCE(SUM(total),0) as sales_sum, COALESCE(SUM(profit),0) as profit_sum FROM sales WHERE DATE(created_at) = CURDATE() "); $row = $stmt->fetch(PDO::FETCH_ASSOC); $todayInvoices = (int)($row['invoices_count'] ?? 0); $todaySales = (float)($row['sales_sum'] ?? 0); $todayProfit = (float)($row['profit_sum'] ?? 0); $stmtCash = $pdo->query(" SELECT COALESCE(SUM(CASE WHEN type='in' THEN amount ELSE 0 END), 0) AS total_in, COALESCE(SUM(CASE WHEN type='out' THEN amount ELSE 0 END), 0) AS total_out, COALESCE(SUM(CASE WHEN type='in' THEN amount ELSE -amount END), 0) AS balance FROM cash_transactions "); $c = $stmtCash->fetch(PDO::FETCH_ASSOC); echo json_encode([ 'ok' => 1, 'todayInvoices' => $todayInvoices, 'todaySales' => round($todaySales, 2), 'todayProfit' => round($todayProfit, 2), 'totalProducts' => $totalProducts, 'lowStockCount' => $lowStockCount, 'totalCustomers'=> $totalCustomers, 'cashIn' => round($c['total_in'], 2), 'cashOut' => round($c['total_out'], 2), 'cashBalance' => round($c['balance'], 2), 'time' => date('h:i A') ]); } catch (Exception $e) { echo json_encode(['ok'=>0, 'error'=>$e->getMessage()]); } exit; } try { $totalProducts = (int)$pdo->query("SELECT COUNT(*) FROM products")->fetchColumn(); $lowStockCount = (int)$pdo->query("SELECT COUNT(*) FROM products WHERE stock <= 5")->fetchColumn(); $totalCustomers = (int)$pdo->query("SELECT COUNT(*) FROM customers")->fetchColumn(); $row = $pdo->query("SELECT COUNT(*) as c, COALESCE(SUM(total),0) as s, COALESCE(SUM(profit),0) as p FROM sales WHERE DATE(created_at) = CURDATE()")->fetch(PDO::FETCH_ASSOC); $todayInvoices = $row['c']; $todaySales = $row['s']; $todayProfit = $row['p']; $c = $pdo->query("SELECT COALESCE(SUM(CASE WHEN type='in' THEN amount ELSE 0 END), 0) as i, COALESCE(SUM(CASE WHEN type='out' THEN amount ELSE 0 END), 0) as o, COALESCE(SUM(CASE WHEN type='in' THEN amount ELSE -amount END), 0) as b FROM cash_transactions")->fetch(PDO::FETCH_ASSOC); $cashIn = $c['i']; $cashOut = $c['o']; $cashBalance = $c['b']; } catch(Exception $e){ $db_error = $e->getMessage(); $totalProducts = $lowStockCount = $totalCustomers = $todayInvoices = 0; $todaySales = $todayProfit = $cashIn = $cashOut = $cashBalance = 0; } $T = [ 'en'=>[ 'title'=>'Dashboard', 'welcome'=>'Welcome back', 'stats_sales'=>'Today\'s Revenue', 'stats_products'=>'Total Products', 'stats_customers'=>'Active Clients', 'stats_cash'=>'Cash Balance', 'invoices_count'=>'Invoices Today', 'low_stock'=>'Low Stock Alert', 'updated'=>'Last sync', 'sections'=>'Quick Access', 'sale_inv'=>'New Sale', 'sale_list'=>'Sales History', 'purch_inv'=>'Purchase Invoice', 'add_prod'=>'Add Product', 'prod_list'=>'Product Catalog', 'stock_audit'=>'Stock Audit', 'cust_add'=>'Customers', 'cust_debt'=>'Receivables', 'suppliers'=>'Suppliers', 'add_bal'=>'Deposit Funds', 'withdraw'=>'Withdraw', 'cash_rep'=>'Cash Report', 'users'=>'User Management', 'backup'=>'Data Backup', 'logout'=>'Sign Out', 'profile'=>'My Profile', 'settings'=>'System Settings', 'main_menu'=>'Navigation', 'system'=>'System', 'invoices_today'=>'invoices processed', 'deposit_total'=>'Total deposits', 'withdraw_total'=>'Total withdrawals' ], 'ar'=>[ 'title'=>'لوحة القيادة', 'welcome'=>'مرحباً بعودتك', 'stats_sales'=>'إيرادات اليوم', 'stats_products'=>'إجمالي المنتجات', 'stats_customers'=>'العملاء النشطين', 'stats_cash'=>'رصيد الصندوق', 'invoices_count'=>'فواتير اليوم', 'low_stock'=>'تنبيه المخزون', 'updated'=>'آخر تحديث', 'sections'=>'الوصول السريع', 'sale_inv'=>'فاتورة بيع', 'sale_list'=>'سجل المبيعات', 'purch_inv'=>'فاتورة مشتريات', 'add_prod'=>'إضافة منتج', 'prod_list'=>'دليل المنتجات', 'stock_audit'=>'جرد المخزون', 'cust_add'=>'العملاء', 'cust_debt'=>'المستحقات', 'suppliers'=>'الموردين', 'add_bal'=>'إيداع أموال', 'withdraw'=>'سحب مصاريف', 'cash_rep'=>'تقرير الصندوق', 'users'=>'إدارة المستخدمين', 'backup'=>'نسخة احتياطية', 'logout'=>'تسجيل الخروج', 'profile'=>'الملف الشخصي', 'settings'=>'إعدادات النظام', 'main_menu'=>'التنقل', 'system'=>'النظام', 'invoices_today'=>'فاتورة معالجة', 'deposit_total'=>'إجمالي الإيداعات', 'withdraw_total'=>'إجمالي المسحوبات' ] ]; $t = $T[$lang]; $initialTheme = 'dark'; if (isset($_COOKIE['bo_theme']) && $_COOKIE['bo_theme'] === 'light') { $initialTheme = 'light'; } ?> <?= esc($t['title']) ?> — Top Accessories

,
--:--
  • admin@topacc.com
Live
:

0 ? number_format($todaySales / $todayInvoices, 2) : '0.00' ?>
0 ? number_format(($todayProfit / $todaySales) * 100, 1) : '0.0' ?>%