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/kitchen

Free Space:

9.71 TB

🔧 Quick Actions

✏️ Editing: fetch_orders.php

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

if (!isset($_SESSION['login_id'])) {
    echo json_encode(['error' => 'User not logged in']);
    exit;
}

$log_id = $_SESSION['login_id'];
$branch_id = $_SESSION['branch_id'];  // Assuming you have branch_id in session

date_default_timezone_set('Asia/Manila');
$today = date('Y-m-d');

// Fetch the pending orders
$sql = "SELECT * FROM sales, byb_walkin_orders WHERE sales.order_number = byb_walkin_orders.order_number 
        AND byb_walkin_orders.status = 'Pending' 
        AND DATE(byb_walkin_orders.order_date) = '$today' 
        AND byb_walkin_orders.branch_id = '$branch_id'";

$res = $conn->query($sql);

$orders = [];
while ($row = $res->fetch_assoc()) {
    $orders[] = [
        'order_number' => $row['order_number'],
        'que_number' => $row['que_num'],
        'items' => [] // This will hold the order items
    ];
}

// Fetch order items for each order
foreach ($orders as $key => $order) {
    $order_number = $order['order_number'];
    $sql_items = "SELECT * FROM sales, byb_walkin_orders, menu WHERE sales.order_number = byb_walkin_orders.order_number 
                  AND byb_walkin_orders.order_number = '$order_number' 
                  AND byb_walkin_orders.status = 'Pending' 
                  AND menu.menu_id = byb_walkin_orders.menu_id 
                  AND byb_walkin_orders.branch_id = '$branch_id'";

$res_items = $conn->query($sql_items);

while ($item = $res_items->fetch_assoc()) {
        $orders[$key]['items'][] = [
            'quantity' => $item['quantity'],
            'menu_name' => $item['menu_name'],
            'order_id' => $item['order_id']
        ];
    }
}

echo json_encode(['orders' => $orders]);
exit;

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: fetch_orders.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation