/home/u775757334/domains/civicwelllife.com/public_html/seller/

/home/u775757334/domains/civicwelllife.com/public_html/seller

Name	Size	Mode	Actions
function/	-	0755	rm
include/	-	0755	rm
add-product.php	20030	0644	edit dl rm
config.php	1961	0644	edit dl rm
dashboard.php	9310	0644	edit dl rm
index.php	9310	0644	edit dl rm
login.php	17991	0644	edit dl rm
logout.php	313	0644	edit dl rm
order-list.php	23068	0644	edit dl rm
product-list.php	19124	0644	edit dl rm
profile.php	18983	0644	edit dl rm

Edit: /home/u775757334/domains/civicwelllife.com/public_html/seller/dashboard.php (9310B)

<?php
include 'config.php';

if (!isset($_SESSION['seller_id'])) {
    header('Location: login.php');
    exit;
}

$seller_name  = $_SESSION['seller_name'] ?? 'Seller';
$company_name = $_SESSION['seller_company_name'] ?? '';
$brand_name   = $_SESSION['seller_brand_name'] ?? '';
$seller_email = $_SESSION['seller_email'] ?? '';

$meta_title = "Seller Dashboard";
$meta_keyword = "seller dashboard";
$meta_description = "Seller dashboard panel";
$seller_id = $_SESSION['seller_id'];

$sql = mysqli_query($conn, "
    SELECT COUNT(*) AS total_products 
    FROM tbl_product 
    WHERE seller_id = '$seller_id'
");

$row = mysqli_fetch_assoc($sql);
$sqlOrder = mysqli_query($conn, "
    SELECT 
        COUNT(DISTINCT od.order_id) AS total_orders,

COUNT(DISTINCT CASE 
            WHEN o.order_status = 0 THEN od.order_id 
        END) AS pending_orders,

COUNT(DISTINCT CASE 
            WHEN o.order_status = 3 THEN od.order_id 
        END) AS confirmed_orders

FROM tbl_order_details od
    INNER JOIN tbl_product p ON p.id = od.product_id
    INNER JOIN tbl_order o ON o.order_id = od.order_id   -- ✅ FIX

WHERE p.seller_id = '$seller_id'
    AND o.cart_status = 1
");

if (!$sqlOrder) {
    die("Query Error: " . mysqli_error($conn));
}

$orderData = mysqli_fetch_assoc($sqlOrder);

$total_orders     = $orderData['total_orders'] ?? 0;
$pending_orders   = $orderData['pending_orders'] ?? 0;
$confirmed_orders = $orderData['confirmed_orders'] ?? 0;
?>
<!DOCTYPE html>
<html lang="en">

<style>

</style>
    <link rel="stylesheet" href="function/custum.css">
</head>

<div>
                            <a href="dashboard.php" class="brand-logo">Seller<span>Panel</span></a>
                            <div class="topbar-subtext">Manage products, orders and profile</div>
                        </div>
                    </div>

<a href="logout.php" class="topbar-logout">
                            <i class="bi bi-box-arrow-right"></i>
                            <span>Logout</span>
                        </a>
                    </div>
                </div>
            </div>
        </header>

<?php include 'include/desktop-sidebar.php' ?>

<div class="content-area">
                        <div class="glass-card welcome-card">
                            <span class="welcome-badge">Seller Dashboard</span>
                            <h1 class="welcome-title">Welcome back, <?= htmlspecialchars($seller_name); ?></h1>
                            
                        </div>

<div class="stats-row">
                            <div class="glass-card stat-card">
                                <div class="stat-icon">
                                    <i class="bi bi-box-seam"></i>
                                </div>
                                <div class="stat-label">Total Products</div>
                                <div class="stat-value"><?= $row['total_products']; ?></div>
                                <div class="stat-note">Listed products</div>
                            </div>

<div class="glass-card stat-card">
                                <div class="stat-icon">
                                    <i class="bi bi-bag-check"></i>
                                </div>
                                <div class="stat-label">Total Orders</div>
                                <div class="stat-value"><?= $total_orders; ?></div>
                                <div class="stat-note">All received orders</div>
                            </div>

<div class="glass-card stat-card">
                                <div class="stat-icon">
                                    <i class="bi bi-hourglass-split"></i>
                                </div>
                                <div class="stat-label">Pending Orders</div>
                                <div class="stat-value"><?= $pending_orders; ?></div>
                                <div class="stat-note">Awaiting action</div>
                            </div>

<div class="glass-card stat-card">
                                <div class="stat-icon">
                                    <i class="bi bi-truck"></i>
                                </div>
                                <div class="stat-label">Delivered Orders</div>
                                <div class="stat-value"><?= $confirmed_orders; ?></div>
                                <div class="stat-note">Completed orders</div>
                            </div>
                        </div>

<div class="glass-card section-card">
                            <h3 class="section-title">Quick Actions</h3>

<div class="quick-grid">
                                <a href="add-product.php" class="quick-card">
                                    <div class="quick-icon">
                                        <i class="bi bi-plus-square"></i>
                                    </div>
                                    <h5>Add Product</h5>
                                    
                                </a>

<a href="product-list.php" class="quick-card">
                                    <div class="quick-icon">
                                        <i class="bi bi-boxes"></i>
                                    </div>
                                    <h5>Manage Products</h5>
                                    
                                </a>

<a href="order-list.php" class="quick-card">
                                    <div class="quick-icon">
                                        <i class="bi bi-bag-heart"></i>
                                    </div>
                                    <h5>View Orders</h5>
                                    
                                </a>
                            </div>
                        </div>

<div class="footer-note">
                            © <?= date('Y'); ?> Seller Panel. All rights reserved.
                        </div>
                    </div>
                </div>
            </div>
        </main>
    </div>

<?php include 'include/mobile-sidebar.php' ?>

</html>

<?= $meta_title ?>

Seller Dashboard

Welcome back,

Total Products

Listed products

Total Orders

All received orders

Pending Orders

Awaiting action

Delivered Orders

Completed orders