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

🔧 Quick Actions

✏️ Editing: payment_logs.php

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

<!doctype html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Admin | Payment Logs</title>
    <?php include('links/head.php'); ?>

<link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/css/all.min.css" rel="stylesheet">
    
    <style>
        .badge-completed { background-color: #28a745; color: #fff; }
        .badge-redirected { background-color: #17a2b8; color: #fff; }
        .badge-failed { background-color: #dc3545; color: #fff; }
        .badge-pending { background-color: #ffc107; color: #000; }
        
        .json-viewer {
            max-height: 300px;
            overflow-y: auto;
            background: #f8f9fa;
            border: 1px solid #dee2e6;
            padding: 10px;
            border-radius: 4px;
            font-family: monospace;
            white-space: pre-wrap;
        }
    </style>
</head>

<div class="main-content">
            <div class="page-content">
                <div class="container-fluid">
                    <?php
                    include('../../db_config.php');

try {
                        $db = getDBConnection();
                        
                        // Fetch payment logs
                        $query = "SELECT * FROM payment_logs ORDER BY id DESC";
                        $stmt = $db->query($query);
                        $paymentLogs = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Statistics
                        $totalQuery = "SELECT COUNT(*) as total FROM payment_logs";
                        $totalStmt = $db->query($totalQuery);
                        $totalLogs = $totalStmt->fetch(PDO::FETCH_ASSOC)['total'];
                        
                        $completedQuery = "SELECT COUNT(*) as completed FROM payment_logs WHERE status = 'COMPLETED'";
                        $completedStmt = $db->query($completedQuery);
                        $completedLogs = $completedStmt->fetch(PDO::FETCH_ASSOC)['completed'];
                        
                        $redirectedQuery = "SELECT COUNT(*) as redirected FROM payment_logs WHERE status = 'redirected'";
                        $redirectedStmt = $db->query($redirectedQuery);
                        $redirectedLogs = $redirectedStmt->fetch(PDO::FETCH_ASSOC)['redirected'];
                        
                        $revenueQuery = "SELECT SUM(amount) as revenue FROM payment_logs WHERE status = 'COMPLETED'";
                        $revenueStmt = $db->query($revenueQuery);
                        $totalRevenue = $revenueStmt->fetch(PDO::FETCH_ASSOC)['revenue'];
                        
                    } catch (PDOException $e) {
                        die("Error fetching payment logs: " . $e->getMessage());
                    }
                    ?>
                    
                    <div class="container-fluid">
                        <div class="row">
                            
                            <div class="col-md-6 col-xl-3">
                                <div class="card text-center">
                                    <div class="mb-2 card-body text-muted">
                                        <h3 class="text-info mt-2"><?php echo $totalLogs; ?></h3> Total Transactions
                                    </div>
                                </div>
                            </div>
                            
                            <div class="col-md-6 col-xl-3">
                                <div class="card text-center">
                                    <div class="mb-2 card-body text-muted">
                                        <h3 class="text-success mt-2"><?php echo $completedLogs; ?></h3> Completed
                                    </div>
                                </div>
                            </div>
                            
                            <div class="col-md-6 col-xl-3">
                                <div class="card text-center">
                                    <div class="mb-2 card-body text-muted">
                                        <h3 class="text-primary mt-2"><?php echo $redirectedLogs; ?></h3> Redirected
                                    </div>
                                </div>
                            </div>
                            
                            <div class="col-md-6 col-xl-3">
                                <div class="card text-center">
                                    <div class="mb-2 card-body text-muted">
                                        <h3 class="text-purple mt-2">₹<?php echo number_format($totalRevenue, 2); ?></h3> Total Revenue
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="card-title">Payment Logs</h4>
                                    <p class="card-title-desc">Detailed transaction records from payment gateway</p>

<table id="datatable" class="table table-bordered dt-responsive nowrap"
                                        style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                        <thead>
                                            <tr>
                                                <th>ID</th>
                                                <th>Order ID</th>
                                                <th>Amount</th>
                                                <th>Status</th>
                                                <th>Transaction ID</th>
                                                <th>Error Code</th>
                                                <th>Date</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        
                                        <tbody>
                                            <?php
                                            if ($paymentLogs) {
                                                foreach ($paymentLogs as $log) {
                                                    echo "<tr>";
                                                    echo "<td>" . htmlspecialchars($log['id']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($log['merchant_order_id']) . "</td>";
                                                    echo "<td>₹" . number_format($log['amount'], 2) . "</td>";
                                                    
                                                    // Status badge
                                                    $statusClass = 'badge-secondary';
                                                    if ($log['status'] == 'COMPLETED') {
                                                        $statusClass = 'badge-completed';
                                                    } elseif ($log['status'] == 'redirected') {
                                                        $statusClass = 'badge-redirected';
                                                    } elseif ($log['status'] == 'failed') {
                                                        $statusClass = 'badge-failed';
                                                    } elseif ($log['status'] == 'pending') {
                                                        $statusClass = 'badge-pending';
                                                    }
                                                    echo "<td><span class='badge $statusClass'>" . htmlspecialchars($log['status']) . "</span></td>";
                                                    
                                                    echo "<td>" . htmlspecialchars($log['transaction_id'] ?? 'N/A') . "</td>";
                                                    echo "<td>" . htmlspecialchars($log['error_code'] ?? 'N/A') . "</td>";
                                                    echo "<td>" . date('d M Y H:i', strtotime($log['created_at'])) . "</td>";
                                                    
                                                    // Action buttons
                                                    echo "<td>";
                                                    echo "<button class='btn btn-sm btn-info view-details' data-logid='{$log['id']}' title='View Details'>";
                                                    echo "<i class='fas fa-eye'></i>";
                                                    echo "</button>";
                                                    echo "</td>";
                                                    
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='8' class='text-center'>No payment logs 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="modal fade" id="detailsModal" tabindex="-1" role="dialog" aria-labelledby="detailsModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="detailsModalLabel">Payment Details</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <div class="row">
                        <div class="col-md-6">
                            <p><strong>Order ID:</strong> <span id="modalOrderId"></span></p>
                            <p><strong>Amount:</strong> <span id="modalAmount"></span></p>
                            <p><strong>Status:</strong> <span id="modalStatus"></span></p>
                        </div>
                        <div class="col-md-6">
                            <p><strong>Transaction ID:</strong> <span id="modalTransactionId"></span></p>
                            <p><strong>Error Code:</strong> <span id="modalErrorCode"></span></p>
                            <p><strong>Date:</strong> <span id="modalDate"></span></p>
                        </div>
                    </div>
                    <div class="mt-3">
                        <h6>Response Data:</h6>
                        <div id="modalResponseData" class="json-viewer"></div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>

<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.3/dist/umd/popper.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>

<?php include('links/scripts.php'); ?>
    
    <script>
    $(document).ready(function() {
        // View details button click handler
        $('.view-details').click(function() {
            var logId = $(this).data('logid');
            
            // AJAX request to get log details
            $.ajax({
                url: 'get_payment_log.php',
                type: 'GET',
                data: { id: logId },
                dataType: 'json',
                success: function(response) {
                    if(response.success) {
                        var log = response.data;
                        
                        // Populate modal fields
                        $('#modalOrderId').text(log.merchant_order_id);
                        $('#modalAmount').text('₹' + parseFloat(log.amount).toFixed(2));
                        $('#modalStatus').html('<span class="badge ' + getStatusClass(log.status) + '">' + log.status + '</span>');
                        $('#modalTransactionId').text(log.transaction_id || 'N/A');
                        $('#modalErrorCode').text(log.error_code || 'N/A');
                        $('#modalDate').text(new Date(log.created_at).toLocaleString());
                        
                        // Format and display JSON response data
                        var responseData = log.response_data ? JSON.parse(log.response_data) : 'No data available';
                        $('#modalResponseData').text(JSON.stringify(responseData, null, 2));
                        
                        // Show modal
                        $('#detailsModal').modal('show');
                    } else {
                        alert('Error: ' + response.message);
                    }
                },
                error: function(xhr, status, error) {
                    alert('AJAX Error: ' + error);
                }
            });
        });
        
        // Helper function to get status badge class
        function getStatusClass(status) {
            if (status == 'COMPLETED') return 'badge-completed';
            if (status == 'redirected') return 'badge-redirected';
            if (status == 'failed') return 'badge-failed';
            if (status == 'pending') return 'badge-pending';
            return 'badge-secondary';
        }
    });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: payment_logs.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation