File Manager

Editing File: /home/quiczmwg/lightspringdigitals.com/__MACOSX/profit.php

<?php
include "./include/head.php";
include "sidebar.php";
include "./include/navbar.php";

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

$userid = $_SESSION['userid'];

// Fetch total commission for this user
$stmt = $conn->prepare("SELECT COALESCE(SUM(amount), 0) AS total_commission FROM commission WHERE user_id = ?");
$stmt->bind_param("s", $userid);
$stmt->execute();
$result = $stmt->get_result();
$data = $result->fetch_assoc();
$total_commission = $data['total_commission'] ?? 0.00;

// Generate commission trend (simulated based on total_commission)
$commissionHistory = [];
$step = $total_commission / 6;
for ($i = 1; $i <= 6; $i++) {
    $commissionHistory[] = round($step * $i + rand(-3, 3), 2);
}
?>

.chart-card {
        background: #fff;
        border-radius: 18px;
        box-shadow: 0 8px 25px rgba(0, 0, 0, 0.06);
        padding: 30px;
    }

.commission-value {
        font-size: 2.3rem;
        font-weight: 600;
        color: #333;
    }

.commission-label {
        color: #666;
        font-size: 14px;
    }

.chart-container {
        width: 100%;
        height: auto;
        position: relative;
    }
</style>

<div class="container py-5">
    <div class="row justify-content-center">
        <div class="col-lg-8 chart-card">
            <div class="text-center mb-4">
                <h4 class="fw-semibold">Your Commission Trend</h4>
                <p class="text-muted mb-0">Based on your total commission earnings</p>
            </div>

<div class="text-center mt-4">
                <div class="commission-value">$<?php echo number_format($total_commission, 2); ?></div>
                <div class="commission-label">Total Commission Earned</div>
            </div>
        </div>
    </div>
</div>

<?php include "footer.php"; ?>

Back to Directory File Manager