Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u612101220

Directory:

/home/u612101220/domains/esgpos.shop/public_html/teanaw/main/pos

Free Space:

9.71 TB

🔧 Quick Actions

✏️ Editing: get_orders.php

<?php
session_start();
include('../controller/config.php');

if (isset($_GET['order_number'])) {
    $order_num = $_GET['order_number'];
    $branch_id = $_GET['branch_id'];

// Initialize total variable
    $total = 0;

// Query to get the latest order details
    $sql = "SELECT * FROM byb_walkin_orders, menu WHERE menu.menu_id = byb_walkin_orders.menu_id AND order_number = '$order_num' AND byb_walkin_orders.branch_id = $branch_id ORDER BY order_id DESC";
    $res = $conn->query($sql);

$output = '';
    while ($row = $res->fetch_assoc()) {
        $menu = htmlspecialchars($row['menu']); // Escape output for security
        $quantity = $row['quantity'];
        $unit_price = $row['unit_price'];
        $subtotal = floatval($row['subtotal']); // Convert to float for calculation
        $discount_amount = floatval($row['discounted_amount']); // Convert to float for calculation
        $new_subtotal = $subtotal - $discount_amount;

// Update the total
        $total += $new_subtotal;

// Format values for display
        $new_sub = number_format($new_subtotal, 2); // Format with two decimals

if ($row['discounted_amount'] > 0) {
 $output .= "<tr class='h5'>
 <td>{$menu} x</td>
 <td>{$quantity} ({$row['discount_type']} - " . " {$row['discounted_amount']})</td>
 <td>" . number_format($unit_price, 2) . "</td>
 <td>{$new_sub}</td>
 </tr>";
 } else {
 $output .= "<tr class='h5'>
 <td>{$menu} x</td>
 <td>{$quantity}</td>
 <td>" . number_format($unit_price, 2) . "</td>
 <td>" . number_format($subtotal, 2) . "</td>
 </tr>";
 }
 }

// Return both the updated order details and the new total as a response
    echo json_encode(['order_details' => $output, 'total' => number_format($total, 2)]);
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: get_orders.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation