Root Explorer PHP

Editing: dashboard(1).php

<?php
include('includes/config.php');

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

$user_id = $_SESSION['user_id'] ?? 0;

// Fetch settings
$settingsQuery = $conn->query("SELECT currency, logo FROM settings LIMIT 1");
$settings = $settingsQuery->fetch_assoc();
$currencySymbol = $settings['currency'] ?? '₹';

// Enhanced Functions
function getFirstLevelReferralsCount($user_id) {
    global $conn;
    try {
        $stmt = $conn->prepare("SELECT COUNT(id) AS count FROM clients 
                               WHERE affiliate_id = ?");
        $stmt->bind_param("s", $user_id);
        $stmt->execute();
        $result = $stmt->get_result();
        return $result->fetch_assoc()['count'] ?? 0;
    } catch (Exception $e) {
        error_log("Error in getFirstLevelReferralsCount: ".$e->getMessage());
        return 0;
    }
}

include('includes/header.php');
?>

<?php include('includes/nav.php'); ?>
<?php include('includes/sidebar.php'); ?>

<div class="content-wrapper">
    <section class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1>Affiliate Dashboard</h1>
                </div>
            </div>
        </div>
    </section>

<section class="content">
        <div class="container-fluid">
            <div class="row">
                
                <div class="col-12 col-sm-6 col-lg-3">
                    <div class="small-box bg-info">
                        <div class="inner">
                            <h3><?= htmlspecialchars(getFirstLevelReferralsCount($user_id)) ?></h3>
                            <p>Direct Referrals</p>
                        </div>
                        <div class="icon">
                            <i class="fas fa-user-plus"></i>
                        </div>
                    </div>
                </div>

<div class="col-12 col-sm-6 col-lg-3">
                    <div class="small-box bg-success">
                        <div class="inner">
                            <h3><?= htmlspecialchars(getSecondLevelReferralsCount($user_id)) ?></h3>
                            <p>Secondary Referrals</p>
                        </div>
                        <div class="icon">
                            <i class="fas fa-users"></i>
                        </div>
                    </div>
                </div>

<div class="col-12 col-sm-6 col-lg-3">
                    <div class="small-box bg-warning">
                        <div class="inner">
                            <h3><?= $currencySymbol . number_format(getBalanceCommission($user_id), 2) ?></h3>
                            <p>Balance Commission</p>
                        </div>
                        <div class="icon">
                            <i class="fas fa-wallet"></i>
                        </div>
                    </div>
                </div>

<div class="col-12 col-sm-6 col-lg-3">
                    <div class="small-box bg-danger">
                        <div class="inner">
                            <h3><?= $currencySymbol . number_format(getCurrentMonthCommission($user_id), 2) ?></h3>
                            <p>Current Month Earnings</p>
                        </div>
                        <div class="icon">
                            <i class="fas fa-calendar-alt"></i>
                        </div>
                    </div>
                </div>
            </div>

<div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header">
                            <h3 class="card-title">Quick Stats</h3>
                        </div>
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-4">
                                    <div class="callout callout-info">
                                        <h5>Total Referrals</h5>
                                        <h2><?= htmlspecialchars(getFirstLevelReferralsCount($user_id) + getSecondLevelReferralsCount($user_id)) ?></h2>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="callout callout-success">
                                        <h5>Lifetime Earnings</h5>
                                        <h2><?= $currencySymbol . number_format(getBalanceCommission($user_id) + getPaidCommission($user_id), 2) ?></h2>
                                    </div>
                                </div>
                                <div class="col-md-4">
                                    <div class="callout callout-warning">
                                        <h5>Avg. Monthly Earnings</h5>
                                        <h2><?= $currencySymbol . number_format(getAverageMonthlyEarnings($user_id), 2) ?></h2>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
</div>

<?php include('includes/footer.php'); ?>
</body>
</html>

<?php
// Close database connection
$conn->close();
?>

[ CANCEL ]

Name	Type	Actions
.. (Parent Directory)
📄 add_account.php	FILE	[EDIT]
📄 commission_payment.php	FILE	[EDIT]
📄 commission_report.php	FILE	[EDIT]
📄 coupons.php	FILE	[EDIT]
📄 dashboard(1).php	FILE	[EDIT]
📄 dashboard.php	FILE	[EDIT]
📄 delete_account.php	FILE	[EDIT]
📁 dist/	DIR
📄 edit_account.php	FILE	[EDIT]
📄 edit_member.php	FILE	[EDIT]
📄 error_log.txt	FILE	[EDIT]
📁 includes/	DIR
📄 index.php	FILE	[EDIT]
📄 logout.php	FILE	[EDIT]
📄 memberProfile.php	FILE	[EDIT]
📄 member_report.php	FILE	[EDIT]
📁 plugins/	DIR
📄 product_link.php	FILE	[EDIT]
📄 second_member_report.php	FILE	[EDIT]
📁 uploads/	DIR
📄 user_link.php	FILE	[EDIT]
📄 view_account.php	FILE	[EDIT]

[ Root System Explorer ]

Editing: dashboard(1).php