Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/ems/admin

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: sbo-overview.php

<?php include('config/db.php'); ?>
<!doctype html>
<html lang="en">

<head>
    <title>Financial Analytics Dashboard</title>
    <?php include('links/head.php'); ?>
    <style>
        .card-analytics {
            border-radius: 10px;
            box-shadow: 0 4px 8px rgba(0,0,0,0.1);
            margin-bottom: 20px;
        }
        .analytics-header {
            background-color: #f8f9fa;
            padding: 15px;
            border-radius: 10px 10px 0 0;
            border-bottom: 1px solid #eee;
        }
        .analytics-body {
            padding: 20px;
        }
        .badge-pending {
            background-color: #ffc107;
            color: #212529;
        }
        .badge-completed {
            background-color: #28a745;
            color: white;
        }
        .financial-card {
            border-left: 4px solid;
            margin-bottom: 15px;
        }
        .financial-card.task-wallet {
            border-left-color: #17a2b8;
        }
        .financial-card.intro-commission {
            border-left-color: #6f42c1;
        }
        .financial-card.withdrawals {
            border-left-color: #fd7e14;
        }
        .summary-card {
            background-color: #f8f9fa;
            border-radius: 8px;
            padding: 15px;
            margin-bottom: 15px;
        }
        .withdrawal-details {
            background-color: #f8f9fa;
            border-radius: 5px;
            padding: 10px;
            margin-bottom: 10px;
        }
        .withdrawal-details.completed {
            border-left: 4px solid #28a745;
        }
        .withdrawal-details.pending {
            border-left: 4px solid #ffc107;
        }
        .withdrawal-summary {
            margin-bottom: 5px;
        }
        .pagination {
            display: flex;
            justify-content: center;
            margin-top: 20px;
        }
        .pagination a {
            padding: 8px 16px;
            margin: 0 4px;
            border: 1px solid #ddd;
            text-decoration: none;
            color: #333;
        }
        .pagination a.active {
            background-color: #4CAF50;
            color: white;
            border: 1px solid #4CAF50;
        }
        .pagination a:hover:not(.active) {
            background-color: #ddd;
        }
    </style>
</head>

<div class="row">
                        <div class="col-12">
                            <div class="card card-analytics">
                                <div class="analytics-header">
                                    <h4 class="card-title mb-0">Financial Analytics Dashboard</h4>
                                </div>
                                <div class="analytics-body">
                                    <div class="row mb-4">
                                        <div class="col-md-3">
                                            <div class="summary-card">
                                                <h5>Total Users</h5>
                                                <?php
                                                $total_query = "SELECT COUNT(DISTINCT username) as total FROM task_wallet_records";
                                                $total_result = mysqli_query($conn, $total_query);
                                                $total = mysqli_fetch_assoc($total_result)['total'];
                                                ?>
                                                <h3><?php echo $total; ?></h3>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="summary-card">
                                                <h5>Total Task Wallet</h5>
                                                <?php
                                                $wallet_query = "SELECT SUM(task_wallet_amount) as total FROM task_wallet_records";
                                                $wallet_result = mysqli_query($conn, $wallet_query);
                                                $wallet_total = mysqli_fetch_assoc($wallet_result)['total'];
                                                ?>
                                                <h3>₹<?php echo number_format($wallet_total, 2); ?></h3>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="summary-card">
                                                <h5>Intro Commission</h5>
                                                <?php
                                                $commission_query = "SELECT SUM(intro_commission) as total FROM intro_commission_records";
                                                $commission_result = mysqli_query($conn, $commission_query);
                                                $commission_total = mysqli_fetch_assoc($commission_result)['total'];
                                                ?>
                                                <h3>₹<?php echo number_format($commission_total, 2); ?></h3>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="summary-card">
                                                <h5>Total Withdrawals</h5>
                                                <?php
                                                $withdrawal_query = "SELECT SUM(requested_amount) as total FROM withdrawal_records WHERE status = 'completed'";
                                                $withdrawal_result = mysqli_query($conn, $withdrawal_query);
                                                $withdrawal_total = mysqli_fetch_assoc($withdrawal_result)['total'];
                                                ?>
                                                <h3>₹<?php echo number_format($withdrawal_total, 2); ?></h3>
                                            </div>
                                        </div>
                                    </div>

<?php
                                    // Pagination setup
                                    $rows_per_page = 50;
                                    $current_page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
                                    $offset = ($current_page - 1) * $rows_per_page;
                                    
                                    // Get total number of records
                                    $count_query = "SELECT COUNT(*) as total FROM task_wallet_records";
                                    $count_result = mysqli_query($conn, $count_query);
                                    $total_records = mysqli_fetch_assoc($count_result)['total'];
                                    $total_pages = ceil($total_records / $rows_per_page);
                                    
                                    // Main query with pagination
                                    $query = "SELECT 
                                                t.username,
                                                i.profile_name,
                                                t.task_wallet_amount as task_wallet,
                                                COALESCE(i.intro_commission, 0) as intro_commission
                                              FROM task_wallet_records t
                                              LEFT JOIN intro_commission_records i ON t.username = i.username
                                              ORDER BY t.task_wallet_amount DESC
                                              LIMIT $offset, $rows_per_page";
                                    
                                    $result = mysqli_query($conn, $query);
                                    $serial = $offset + 1;
                                    ?>

<table class="table table-bordered" style="width: 100%;">
                                        <thead>
                                            <tr>
                                                <th>S.No.</th>
                                                <th>Username</th>
                                                <th>Profile Name</th>
                                                <th>Task Wallet</th>
                                                <th>Intro Commission</th>
                                                <th>Withdrawals</th>
                                            </tr>
                                        </thead>

<tbody>
                                            <?php
                                            if ($result && mysqli_num_rows($result) > 0) {
                                                while ($row = mysqli_fetch_assoc($result)) {
                                                    // Get withdrawal records for this user
                                                    $withdrawal_query = "SELECT * FROM withdrawal_records WHERE username = '".$row['username']."'";
                                                    $withdrawal_result = mysqli_query($conn, $withdrawal_query);
                                                    
                                                    $completed_withdrawals = 0;
                                                    $pending_withdrawals = 0;
                                                    $withdrawal_details = '';
                                                    $has_completed = false;
                                                    $has_pending = false;
                                                    
                                                    if ($withdrawal_result && mysqli_num_rows($withdrawal_result) > 0) {
                                                        while ($withdrawal = mysqli_fetch_assoc($withdrawal_result)) {
                                                            if ($withdrawal['status'] == 'completed') {
                                                                $completed_withdrawals += $withdrawal['requested_amount'];
                                                                $has_completed = true;
                                                                $withdrawal_details .= '
                                                                    <div class="withdrawal-details completed">
                                                                        <div class="d-flex justify-content-between">
                                                                            <span>₹'.number_format($withdrawal['requested_amount'], 2).'</span>
                                                                            <span class="badge badge-completed">Completed</span>
                                                                        </div>
                                                                        <div class="small text-muted">
                                                                            Credited: '.($withdrawal['credited_date'] ? htmlspecialchars($withdrawal['credited_date']) : 'N/A').'
                                                                        </div>
                                                                        <div class="small">
                                                                            Net Amount: ₹'.number_format($withdrawal['credited_amount'], 2).'
                                                                            (Fee: ₹'.number_format($withdrawal['admin_charge'], 2).')
                                                                        </div>
                                                                    </div>';
                                                            } else {
                                                                $pending_withdrawals += $withdrawal['requested_amount'];
                                                                $has_pending = true;
                                                                $withdrawal_details .= '
                                                                    <div class="withdrawal-details pending">
                                                                        <div class="d-flex justify-content-between">
                                                                            <span>₹'.number_format($withdrawal['requested_amount'], 2).'</span>
                                                                            <span class="badge badge-pending">Pending</span>
                                                                        </div>
                                                                        <div class="small text-muted">
                                                                            Requested on: '.htmlspecialchars(substr($withdrawal['fetched_at'], 0, 10)).'
                                                                        </div>
                                                                    </div>';
                                                            }
                                                        }
                                                    } else {
                                                        $withdrawal_details = '<div class="text-muted small">No withdrawal history</div>';
                                                    }
                                                    
                                                    // Build summary display
                                                    $summary_display = '';
                                                    if ($has_completed && $has_pending) {
                                                        $summary_display = '
                                                            <div class="withdrawal-summary">
                                                                <span class="text-success">Completed: ₹' . number_format($completed_withdrawals, 2) . '</span><br>
                                                                <span class="text-warning">Pending: ₹' . number_format($pending_withdrawals, 2) . '</span>
                                                            </div>';
                                                    } elseif ($has_completed) {
                                                        $summary_display = '
                                                            <div class="withdrawal-summary">
                                                                <span class="text-success">Completed: ₹' . number_format($completed_withdrawals, 2) . '</span>
                                                            </div>';
                                                    } elseif ($has_pending) {
                                                        $summary_display = '
                                                            <div class="withdrawal-summary">
                                                                <span class="text-warning">Pending: ₹' . number_format($pending_withdrawals, 2) . '</span>
                                                            </div>';
                                                    } else {
                                                        $summary_display = '<div class="text-muted small">No withdrawals</div>';
                                                    }
                                                    
                                                    echo "<tr>";
                                                    echo "<td>" . $serial++ . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['username']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['profile_name'] ?? 'N/A') . "</td>";
                                                    echo "<td class='data-highlight'>₹" . number_format($row['task_wallet'], 2) . "</td>";
                                                    echo "<td class='data-highlight'>₹" . number_format($row['intro_commission'], 2) . "</td>";
                                                    echo "<td>
                                                            {$summary_display}
                                                            <button class='btn btn-sm btn-info view-withdrawals' data-username='".htmlspecialchars($row['username'])."'>View Details</button>
                                                            <div class='withdrawal-details-container mt-2' id='withdrawals-".htmlspecialchars($row['username'])."' style='display:none;'>
                                                                ".$withdrawal_details."
                                                            </div>
                                                          </td>";
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='7' class='text-center'>No records found.</td></tr>";
                                            }
                                            ?>
                                        </tbody>
                                    </table>

</div>
                            </div>
                        </div>
                    </div>

</div>
            </div>

<?php include('includes/footer.php') ?>
        </div>
    </div>

<?php include('includes/rightbar.php') ?>

<div class="rightbar-overlay"></div>

<?php include('links/scripts.php') ?>
    
    <script>
    $(document).ready(function() {
        // Toggle withdrawal details visibility
        $(document).on('click', '.view-withdrawals', function() {
            var username = $(this).data('username');
            var container = $('#withdrawals-' + username);
            
            if (container.is(':visible')) {
                container.hide();
                $(this).text('View Details');
            } else {
                container.show();
                $(this).text('Hide Details');
            }
        });
    });
    </script>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sbo-overview.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation