prepare("SELECT id FROM coupons WHERE code = ?");
$check->execute([$code]);
if($check->rowCount() == 0) {
$stmt = $pdo->prepare("INSERT INTO coupons (code, type, value) VALUES (?, ?, ?)");
if($stmt->execute([$code, $type, $value])) {
$msg = "Success! Coupon $code created."; $msgClass = "success";
} else { $msg = "Error."; $msgClass = "error"; }
} else { $msg = "Code exists."; $msgClass = "error"; }
}
// --- 2. FETCH DASHBOARD STATS ---
$totalOrders = $pdo->query("SELECT COUNT(*) FROM orders")->fetchColumn();
$totalRevenue = $pdo->query("SELECT SUM(total_amount) FROM orders WHERE status != 'cancelled'")->fetchColumn();
$pendingOrders = $pdo->query("SELECT COUNT(*) FROM orders WHERE status = 'pending'")->fetchColumn();
$productsCount = $pdo->query("SELECT COUNT(*) FROM products WHERE is_active = 1")->fetchColumn();
$totalPosts = $pdo->query("SELECT COUNT(*) FROM posts")->fetchColumn();
$totalViews = $pdo->query("SELECT SUM(views) FROM posts")->fetchColumn();
// --- 3. FETCH CHART DATA (LAST 7 DAYS) ---
$dates = [];
$revenues = [];
for ($i = 6; $i >= 0; $i--) {
$date = date('Y-m-d', strtotime("-$i days"));
$stmt = $pdo->prepare("SELECT SUM(total_amount) FROM orders WHERE DATE(created_at) = ? AND status != 'cancelled'");
$stmt->execute([$date]);
$day_total = $stmt->fetchColumn() ?: 0;
$dates[] = date('d M', strtotime($date));
$revenues[] = $day_total;
}
// --- 4. FETCH RECENT ORDERS ---
$orders = $pdo->query("SELECT o.*, u.name as user_name FROM orders o LEFT JOIN users u ON o.user_id = u.id ORDER BY o.created_at DESC LIMIT 5")->fetchAll();
?>
Admin Dashboard - Pro Subscription Offers
Total Orders
Pending:
Revenue
₹
Blog
Posts
Views
Inventory
Recent Orders
| ID | Customer | Amount | Status | Action |
|---|
0): ?>
| # |
|
₹ |
|
Manage |
| No orders found. |