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.21 TB

🔧 Quick Actions

✏️ Editing: new-bank.php

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

<!doctype html>
<html lang="en">
<head>
    <title>Staff ↔ Bank Holder Mapping</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; }
        .table th, .table td { vertical-align: middle; }
        .badge-count {
            display: inline-block;
            padding: 0.3rem 0.6rem;
            border-radius: 999px;
            background: #eef2ff;
            color: #2e59d9;
            font-weight: 600;
            font-size: 0.85rem;
        }
    </style>
</head>
<body data-sidebar="dark">
    <div id="layout-wrapper">
        <?php include('includes/nav.php'); ?>
        <?php include('includes/sidebar.php'); ?>

<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">Staff ↔ Bank Holder Mapping (Grouped)</h4>
                                </div>
                                <div class="analytics-body">
                                    <?php
                                    // Group by normalized BankHolderName (case/space-insensitive)
                                    // and aggregate staff names in one row.
                                    $map_query = "
                                        SELECT
                                            MIN(display_holder) AS BankHolderName,
                                            GROUP_CONCAT(DISTINCT StaffName ORDER BY StaffName SEPARATOR ', ') AS StaffList,
                                            COUNT(*) AS StaffCount
                                        FROM (
                                            SELECT
                                                TRIM(StaffName) AS StaffName,
                                                TRIM(BankHolderName) AS display_holder,
                                                LOWER(TRIM(BankHolderName)) AS holder_key
                                            FROM StaffBankDetails
                                            WHERE COALESCE(TRIM(BankHolderName),'') <> ''
                                        ) t
                                        GROUP BY holder_key
                                        ORDER BY MIN(display_holder) ASC
                                    ";

$map_result = mysqli_query($conn, $map_query);
                                    ?>
                                    <div class="table-responsive">
                                        <table class="table table-bordered">
                                            <thead>
                                                <tr>
                                                    <th style="width:70px;">S.No.</th>
                                                    <th>Bank Holder Name</th>
                                                    <th>Staff Names (Grouped)</th>
                                                    <th style="width:100px; text-align:center;">Count</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php
                                                $sno = 1;
                                                if ($map_result && mysqli_num_rows($map_result) > 0) {
                                                    while ($row = mysqli_fetch_assoc($map_result)) {
                                                        echo "<tr>";
                                                        echo "<td>" . $sno++ . "</td>";
                                                        echo "<td>" . htmlspecialchars($row['BankHolderName']) . "</td>";
                                                        echo "<td>" . htmlspecialchars($row['StaffList']) . "</td>";
                                                        echo "<td style='text-align:center;'><span class='badge-count'>" . (int)$row['StaffCount'] . "</span></td>";
                                                        echo "</tr>";
                                                    }
                                                } else {
                                                    echo "<tr><td colspan='4' class='text-center'>No staff bank mappings found</td></tr>";
                                                }
                                                ?>
                                            </tbody>
                                        </table>
                                    </div>

<?php
                                    // Optional: also show rows where BankHolderName is missing/blank
                                    // Uncomment this block if you want to list unknowns.
                                    /*
                                    $unknown_query = "
                                        SELECT TRIM(StaffName) AS StaffName
                                        FROM StaffBankDetails
                                        WHERE COALESCE(TRIM(BankHolderName),'') = ''
                                        ORDER BY StaffName ASC
                                    ";
                                    $unknown_res = mysqli_query($conn, $unknown_query);
                                    if ($unknown_res && mysqli_num_rows($unknown_res) > 0) {
                                        echo '<hr><h5>Entries with Missing Bank Holder Name</h5><ul>';
                                        while ($u = mysqli_fetch_assoc($unknown_res)) {
                                            echo '<li>'.htmlspecialchars($u['StaffName']).'</li>';
                                        }
                                        echo '</ul>';
                                    }
                                    */
                                    ?>
                                </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: new-bank.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation