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

Free Space:

10.29 TB

🔧 Quick Actions

✏️ Editing: export_orders.php

<?php
session_start();
require_once 'config/db_config.php';

// Validate session
if (!isset($_SESSION['user_id']) || !isset($_SESSION['role']) || !isset($_SESSION['branch_id'])) {
    header("Location: login.php");
    exit();
}

$branch_id = $_SESSION['branch_id'];

// Get filters from URL
$date_from = $_GET['date_from'] ?? '';
$date_to = $_GET['date_to'] ?? '';
$status_filter = $_GET['status'] ?? '';
$payment_filter = $_GET['payment'] ?? '';
$search_term = $_GET['search'] ?? '';
$order_type_filter = $_GET['order_type'] ?? '';

// Build query
$query = "
    SELECT 
        o.order_id,
        o.order_id,
        o.order_version,
        o.customer_name,
        o.customer_contact,
        o.order_date,
        o.total_amount,
        o.status,
        o.payment_method,
        o.is_gst_active,
        o.order_type,
        o.table_number,
        (SELECT COUNT(*) FROM order_items WHERE order_id = o.order_id AND order_version = o.order_version) as item_count
    FROM orders o
    WHERE o.branch_id = :branch_id
";

$params = [':branch_id' => $branch_id];

if (!empty($date_from)) {
    $query .= " AND DATE(o.order_date) >= :date_from";
    $params[':date_from'] = $date_from;
}
if (!empty($date_to)) {
    $query .= " AND DATE(o.order_date) <= :date_to";
    $params[':date_to'] = $date_to;
}
if (!empty($status_filter)) {
    $query .= " AND o.status = :status";
    $params[':status'] = $status_filter;
}
if (!empty($payment_filter)) {
    $query .= " AND o.payment_method = :payment";
    $params[':payment'] = $payment_filter;
}
if (!empty($order_type_filter)) {
    $query .= " AND o.order_type = :order_type";
    $params[':order_type'] = $order_type_filter;
}
if (!empty($search_term)) {
    $query .= " AND (o.customer_name LIKE :search OR o.customer_contact LIKE :search OR o.table_number LIKE :search OR o.order_id LIKE :search)";
    $params[':search'] = "%$search_term%";
}

$query .= " ORDER BY o.order_date DESC";

try {
    $stmt = $pdo->prepare($query);
    $stmt->execute($params);
    $orders = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Set headers for CSV download
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment; filename="orders_export_' . date('Y-m-d') . '.csv"');
    
    // Create output stream
    $output = fopen('php://output', 'w');
    
    // Add UTF-8 BOM for Excel compatibility
    fprintf($output, chr(0xEF).chr(0xBB).chr(0xBF));
    
    // Add headers
    fputcsv($output, [
        'Order ID',
        'Root Order ID',
        'Version',
        'Customer Name',
        'Contact',
        'Date',
        'Time',
        'Amount',
        'Status',
        'Payment Method',
        'GST',
        'Order Type',
        'Table Number',
        'Item Count'
    ]);
    
    // Add data rows
    foreach ($orders as $order) {
        fputcsv($output, [
            $order['order_id'],
            $order['root_order_id'] ?: $order['order_id'],
            $order['order_version'],
            $order['customer_name'] ?: 'Walk-in',
            $order['customer_contact'] ?: '',
            date('Y-m-d', strtotime($order['order_date'])),
            date('H:i:s', strtotime($order['order_date'])),
            $order['total_amount'],
            $order['status'],
            $order['payment_method'] ?: '',
            $order['is_gst_active'] ? 'Active' : 'Inactive',
            $order['order_type'] ?: '',
            $order['table_number'] ?: '',
            $order['item_count']
        ]);
    }
    
    fclose($output);
    
} catch (Exception $e) {
    error_log("Export error: " . $e->getMessage());
    header("Location: all_orders.php?error=export_failed");
    exit();
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: export_orders.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation