Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/canteen.avatarpublicschool.com/public_html

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: event_transaction_details.php

<?php include('config.php');
// 1. Simple SQL Query (Removing JSON_EXTRACT to avoid #1305 error)
$phone_no = mysqli_real_escape_string($con, $_GET['phone_no']);
$event_id = (int)$_GET['event_id'];

$query = "SELECT * FROM ccavenue_history 
          WHERE phone = '$phone_no' 
          ORDER BY added_date DESC";

$res = mysqli_query($con, $query);
?>

<div class="row">
    <div class="col-md-12">
        <table class="table table-bordered">
            <thead class="table-dark">
                <tr>
                    <th>Sl.No</th>
                    <th>Date</th>
                    <th>Order ID</th>
                    <th>Details (Menu x Qty)</th>
                    <th class="text-end">Amount</th>
                    <th>Status</th>
                </tr>
            </thead>
            <tbody>
            <?php $i = 1;
            $has_data = false;
            $class = [ 'pending' => 'badge bg-warning', 'Success' => 'badge bg-success', 'Failure' => 'badge bg-danger', 'Aborted' => 'badge bg-danger'];
            while ($row = mysqli_fetch_assoc($res)) {
                // 2. Parse JSON in PHP instead of SQL
                $tx_data = json_decode($row['transaction_data'], true);
                
                // 3. Manual Filter: Check if this row belongs to the requested event_id
                if (isset($tx_data['ref_event_id']) && $tx_data['ref_event_id'] == $event_id) {
                    $has_data = true;
                    $status_class = $class[$row['order_status']];
            ?>
                <tr>
                    <td><?= $i; ?></td>
                    <td><?= date('d-M-y', strtotime($row['added_date'])); ?></td>
                    <td><?= $row['order_id']; ?></td>
                    <td>
                        <?php 
                        if (!empty($tx_data['all_menu_ids'])) {
                            $j = 1;
                            foreach ($tx_data['all_menu_ids'] as $index => $menu_id) {
                                $menu_query = mysqli_query($con, "SELECT food_menu_name FROM food_menu WHERE food_menu_id = $menu_id");
                                $menu = mysqli_fetch_assoc($menu_query);
                                echo "Menu $j : ".$menu['food_menu_name']." (Qty - " . $tx_data['all_quantities'][$index] . ")<br>";
                                $j++;
                            }
                        }
                        ?>
                    </td>
                    <td class="text-end">₹ <?= number_format($row['amount'], 2); ?></td>
                    <td class="d-flex">
                        <div>
                            <span class="<?= $status_class; ?> mt-2"><b><?= $row['order_status']; ?></b></span>
                        </div>
                        <?php if ($row['order_status'] == 'Success'): ?>
                            <br>
                            <a href="event_receipt.php?order_id=<?= $row['order_id']; ?>" title="Print Pdf" target="_blank" class="btn btn-primary btn-sm mt-1 ms-2 p-1">
                               <i class="fa fa-print"></i>
                            </a>
                        <?php endif; ?>
                    </td>
                </tr>
            <?php $i++;
                } // end if event_id match
            } // end while

if (!$has_data): ?>
                <tr><td colspan="5" class="text-center">No records found for Event ID <?= $event_id; ?></td></tr>
            <?php endif; ?>
            </tbody>
        </table>
    </div>
</div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: event_transaction_details.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation