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/ecommer.in/public_html/billing/pawn

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: orders-report.php

<?php
// === server bootstrap & includes ===
include('includes/db.php');

// Normalize connection charset/collation
mysqli_query($conn, "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci");
mysqli_query($conn, "SET collation_connection = 'utf8mb4_unicode_ci'");

// --- helpers ---
function h($v){ return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8'); }

// --- UTC to IST conversion functions ---
function utcToIst($utcDateTime, $format = 'Y-m-d h:i A') {
    if (empty($utcDateTime)) return '';
    
    try {
        $utc = new DateTime($utcDateTime, new DateTimeZone('UTC'));
        $utc->setTimezone(new DateTimeZone('Asia/Kolkata')); // IST timezone
        return $utc->format($format);
    } catch (Exception $e) {
        return $utcDateTime; // fallback to original if conversion fails
    }
}

// Check user access
if (!isset($_SESSION['user_id']) && !isset($_SESSION['user_role'])) {
    header('Location: login.php');
    exit();
}

// Get user role
$user_role = isset($_SESSION['user_role']) ? $_SESSION['user_role'] : 'sale';

// === Filter handling ===
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : date('Y-m-01'); // Default: start of current month
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : date('Y-m-d'); // Default: today
$customer_id = isset($_GET['customer_id']) ? (int)$_GET['customer_id'] : 0;
$payment_method = isset($_GET['payment_method']) ? $_GET['payment_method'] : '';
$service_type = isset($_GET['service_type']) ? $_GET['service_type'] : '';
$business_id = isset($_GET['business_id']) ? (int)$_GET['business_id'] : 0;

// Convert dates to UTC for database query
$start_date_utc = $start_date . ' 00:00:00';
$end_date_utc = $end_date . ' 23:59:59';

// Build WHERE conditions
$where_conditions = ["i.created_at BETWEEN '{$start_date_utc}' AND '{$end_date_utc}'"];
if ($customer_id > 0) {
    $where_conditions[] = "i.customer_id = {$customer_id}";
}
if (!empty($payment_method)) {
    $payment_method = mysqli_real_escape_string($conn, $payment_method);
    $where_conditions[] = "i.payment_method = '{$payment_method}'";
}
if (!empty($service_type)) {
    $service_type = mysqli_real_escape_string($conn, $service_type);
    $where_conditions[] = "i.service_type = '{$service_type}'";
}
if ($business_id > 0) {
    $where_conditions[] = "i.business_id = {$business_id}";
}

$where_clause = !empty($where_conditions) ? 'WHERE ' . implode(' AND ', $where_conditions) : '';

// === Get summary statistics ===
$summary_query = "
    SELECT 
        COUNT(*) as total_orders,
        COALESCE(SUM(i.total), 0) as total_revenue,
        COALESCE(SUM(i.subtotal), 0) as total_subtotal,
        COALESCE(SUM(i.discount), 0) as total_discount,
        COALESCE(SUM(i.total_gst), 0) as total_gst,
        COALESCE(AVG(i.total), 0) as avg_order_value
    FROM invoices i
    {$where_clause}
";

$summary_result = mysqli_query($conn, $summary_query);
$summary = mysqli_fetch_assoc($summary_result);

// === Get order details with pagination ===
$items_per_page = 50;
$current_page = isset($_GET['page']) ? max(1, (int)$_GET['page']) : 1;
$offset = ($current_page - 1) * $items_per_page;

// Count total records
$count_query = "SELECT COUNT(*) as total FROM invoices i {$where_clause}";
$count_result = mysqli_query($conn, $count_query);
$count_data = mysqli_fetch_assoc($count_result);
$total_records = $count_data['total'];
$total_pages = ceil($total_records / $items_per_page);

// Get orders data
$orders_query = "
    SELECT 
        i.*,
        c.name as customer_name,
        c.phone as customer_phone,
        g.business_name,
        g.gst_num
    FROM invoices i
    LEFT JOIN customers c ON c.id = i.customer_id
    LEFT JOIN gst_details g ON g.id = i.business_id
    {$where_clause}
    ORDER BY i.created_at DESC
    LIMIT {$offset}, {$items_per_page}
";

$orders_result = mysqli_query($conn, $orders_query);

// Get filter options
$customers_query = "SELECT id, name, phone FROM customers ORDER BY name";
$customers_result = mysqli_query($conn, $customers_query);

$payment_methods_query = "SELECT DISTINCT payment_method FROM invoices WHERE payment_method IS NOT NULL AND payment_method != '' ORDER BY payment_method";
$payment_methods_result = mysqli_query($conn, $payment_methods_query);

$service_types_query = "SELECT DISTINCT service_type FROM invoices WHERE service_type IS NOT NULL AND service_type != '' ORDER BY service_type";
$service_types_result = mysqli_query($conn, $service_types_query);

$businesses_query = "SELECT id, business_name FROM gst_details WHERE gst_status = 1 ORDER BY business_name";
$businesses_result = mysqli_query($conn, $businesses_query);
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <?php include('includes/head.php'); ?>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/1.11.5/css/dataTables.bootstrap5.min.css">
    <style>
        .card-value { font-size: 1.5rem; font-weight: 600; margin-bottom: 0; }
        .card-label { font-size: 0.875rem; color: #fff; margin-bottom: 0.5rem; opacity: 0.9; }
        .kpi-card { transition: transform 0.2s; border-radius: 10px; border: none; color: white; }
        .kpi-card:hover { transform: translateY(-3px); box-shadow: 0 4px 15px rgba(0,0,0,0.2); }
        .stats-icon { font-size: 2rem; opacity: 0.8; }
        .filter-card { background: #f8f9fa; border-left: 4px solid #007bff; }
        .order-type-badge {
            padding: 3px 8px;
            border-radius: 4px;
            font-size: 0.75rem;
            font-weight: 600;
        }
        .order-type-product {
            background: #e3f2fd;
            color: #1976d2;
        }
        .order-type-service {
            background: #f3e5f5;
            color: #7b1fa2;
        }
        .invoice-link {
            color: #495057;
            font-weight: 500;
            text-decoration: none;
        }
        .invoice-link:hover {
            color: #007bff;
            text-decoration: underline;
        }
        .pagination .page-link { color: #495057; }
        .pagination .page-item.active .page-link { background-color: #007bff; border-color: #007bff; }
        .date-input-group { max-width: 200px; }
        .export-buttons .btn { margin-right: 5px; }
    </style>
</head>
<body data-sidebar="dark">

<?php include('includes/pre-loader.php'); ?>

<div id="layout-wrapper">
    <?php include('includes/topbar.php'); ?>

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php'); ?>
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Orders & Sales Reports</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                    <li class="breadcrumb-item active">Orders Reports</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">
                                            <?php echo number_format($summary['total_orders']); ?>
                                        </h4>
                                        <p class="mb-0 card-label">Total Orders</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-shopping-cart stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">
                                            ₹<?php echo number_format($summary['total_revenue'], 2); ?>
                                        </h4>
                                        <p class="mb-0 card-label">Total Revenue</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-rupee-sign stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">
                                            ₹<?php echo number_format($summary['avg_order_value'], 2); ?>
                                        </h4>
                                        <p class="mb-0 card-label">Avg. Order Value</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-chart-line stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">
                                            ₹<?php echo number_format($summary['total_discount'], 2); ?>
                                        </h4>
                                        <p class="mb-0 card-label">Total Discount</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-tag stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card filter-card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Filter Orders</h5>
                                <form method="GET" action="" class="row g-3">
                                    <div class="col-md-3">
                                        <label class="form-label">Start Date</label>
                                        <input type="date" class="form-control" name="start_date" 
                                               value="<?php echo h($start_date); ?>" max="<?php echo date('Y-m-d'); ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">End Date</label>
                                        <input type="date" class="form-control" name="end_date" 
                                               value="<?php echo h($end_date); ?>" max="<?php echo date('Y-m-d'); ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">Customer</label>
                                        <select class="form-select" name="customer_id">
                                            <option value="0">All Customers</option>
                                            <?php while($customer = mysqli_fetch_assoc($customers_result)): ?>
                                                <option value="<?php echo $customer['id']; ?>" 
                                                    <?php echo $customer_id == $customer['id'] ? 'selected' : ''; ?>>
                                                    <?php echo h($customer['name']); ?> (<?php echo h($customer['phone']); ?>)
                                                </option>
                                            <?php endwhile; mysqli_data_seek($customers_result, 0); ?>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">Payment Method</label>
                                        <select class="form-select" name="payment_method">
                                            <option value="">All Methods</option>
                                            <?php while($method = mysqli_fetch_assoc($payment_methods_result)): ?>
                                                <option value="<?php echo h($method['payment_method']); ?>" 
                                                    <?php echo $payment_method == $method['payment_method'] ? 'selected' : ''; ?>>
                                                    <?php echo ucfirst(h($method['payment_method'])); ?>
                                                </option>
                                            <?php endwhile; mysqli_data_seek($payment_methods_result, 0); ?>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">Order Type</label>
                                        <select class="form-select" name="service_type">
                                            <option value="">All Types</option>
                                            <?php while($type = mysqli_fetch_assoc($service_types_result)): ?>
                                                <option value="<?php echo h($type['service_type']); ?>" 
                                                    <?php echo $service_type == $type['service_type'] ? 'selected' : ''; ?>>
                                                    <?php echo ucfirst(h($type['service_type'])); ?>
                                                </option>
                                            <?php endwhile; mysqli_data_seek($service_types_result, 0); ?>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">Business</label>
                                        <select class="form-select" name="business_id">
                                            <option value="0">All Businesses</option>
                                            <?php while($business = mysqli_fetch_assoc($businesses_result)): ?>
                                                <option value="<?php echo $business['id']; ?>" 
                                                    <?php echo $business_id == $business['id'] ? 'selected' : ''; ?>>
                                                    <?php echo h($business['business_name']); ?>
                                                </option>
                                            <?php endwhile; mysqli_data_seek($businesses_result, 0); ?>
                                        </select>
                                    </div>
                                    <div class="col-md-12 mt-3">
                                        <button type="submit" class="btn btn-primary me-2">
                                            <i class="fas fa-filter me-1"></i> Apply Filters
                                        </button>
                                        <a href="orders-reports.php" class="btn btn-outline-secondary">
                                            <i class="fas fa-times me-1"></i> Clear Filters
                                        </a>
                                        <div class="float-end export-buttons">
                                            <button type="button" class="btn btn-success" onclick="exportToExcel()">
                                                <i class="fas fa-file-excel me-1"></i> Export Excel
                                            </button>
                                            <button type="button" class="btn btn-danger" onclick="printReport()">
                                                <i class="fas fa-print me-1"></i> Print
                                            </button>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-3">Order Details</h4>
                                <div class="table-responsive">
                                    <table class="table table-hover align-middle mb-0" id="orders-table">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Invoice No.</th>
                                                <th>Date & Time (IST)</th>
                                                <th>Customer</th>
                                                <th>Type</th>
                                                <th>Business</th>
                                                <th class="text-end">Subtotal</th>
                                                <th class="text-end">Discount</th>
                                                <th class="text-end">GST</th>
                                                <th class="text-end">Total</th>
                                                <th class="text-end">Payment</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if(mysqli_num_rows($orders_result) > 0): ?>
                                                <?php while($order = mysqli_fetch_assoc($orders_result)): ?>
                                                    <?php 
                                                    $order_type = !empty($order['service_type']) ? $order['service_type'] : 'product';
                                                    $type_class = $order_type == 'service' ? 'order-type-service' : 'order-type-product';
                                                    $type_text = $order_type == 'service' ? 'Service' : 'Product';
                                                    ?>
                                                    <tr>
                                                        <td>
                                                            <a href="view-invoice.php?id=<?php echo $order['id']; ?>" 
                                                               class="invoice-link" target="_blank">
                                                                <?php echo h($order['invoice_number']); ?>
                                                            </a>
                                                        </td>
                                                        <td><?php echo utcToIst($order['created_at'], 'M d, Y h:i A'); ?></td>
                                                        <td>
                                                            <div><?php echo h($order['customer_name'] ?: 'Walk-in Customer'); ?></div>
                                                            <?php if($order['customer_phone']): ?>
                                                                <small class="text-muted"><?php echo h($order['customer_phone']); ?></small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <span class="order-type-badge <?php echo $type_class; ?>">
                                                                <?php echo $type_text; ?>
                                                            </span>
                                                        </td>
                                                        <td><?php echo h($order['business_name'] ?: '-'); ?></td>
                                                        <td class="text-end">₹<?php echo number_format($order['subtotal'], 2); ?></td>
                                                        <td class="text-end">₹<?php echo number_format($order['discount'], 2); ?></td>
                                                        <td class="text-end">₹<?php echo number_format($order['total_gst'], 2); ?></td>
                                                        <td class="text-end fw-bold">₹<?php echo number_format($order['total'], 2); ?></td>
                                                        <td class="text-end">
                                                            <span class="badge bg-<?php echo $order['payment_method'] == 'cash' ? 'success' : 'primary'; ?>">
                                                                <?php echo strtoupper(h($order['payment_method'])); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group btn-group-sm">
                                                                <a href="view-invoice.php?id=<?php echo $order['id']; ?>" 
                                                                   class="btn btn-outline-primary" title="View" target="_blank">
                                                                    <i class="fas fa-eye"></i>
                                                                </a>
                                                                <a href="print-invoice.php?id=<?php echo $order['id']; ?>" 
                                                                   class="btn btn-outline-info" title="Print" target="_blank">
                                                                    <i class="fas fa-print"></i>
                                                                </a>
                                                                <?php if($user_role === 'admin'): ?>
                                                                    <a href="edit-invoice.php?id=<?php echo $order['id']; ?>" 
                                                                       class="btn btn-outline-warning" title="Edit">
                                                                        <i class="fas fa-edit"></i>
                                                                    </a>
                                                                <?php endif; ?>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            <?php else: ?>
                                                <tr>
                                                    <td colspan="11" class="text-center py-4">
                                                        <div class="text-muted">
                                                            <i class="fas fa-inbox fa-2x mb-2"></i><br>
                                                            No orders found for the selected filters
                                                        </div>
                                                    </td>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                        <?php if(mysqli_num_rows($orders_result) > 0): ?>
                                        <tfoot class="table-light">
                                            <tr>
                                                <td colspan="5" class="text-end fw-bold">Page Totals:</td>
                                                <td class="text-end fw-bold">
                                                    ₹<?php 
                                                        $page_subtotal = 0;
                                                        mysqli_data_seek($orders_result, 0);
                                                        while($order = mysqli_fetch_assoc($orders_result)) {
                                                            $page_subtotal += $order['subtotal'];
                                                        }
                                                        echo number_format($page_subtotal, 2);
                                                    ?>
                                                </td>
                                                <td class="text-end fw-bold">
                                                    ₹<?php 
                                                        $page_discount = 0;
                                                        mysqli_data_seek($orders_result, 0);
                                                        while($order = mysqli_fetch_assoc($orders_result)) {
                                                            $page_discount += $order['discount'];
                                                        }
                                                        echo number_format($page_discount, 2);
                                                    ?>
                                                </td>
                                                <td class="text-end fw-bold">
                                                    ₹<?php 
                                                        $page_gst = 0;
                                                        mysqli_data_seek($orders_result, 0);
                                                        while($order = mysqli_fetch_assoc($orders_result)) {
                                                            $page_gst += $order['total_gst'];
                                                        }
                                                        echo number_format($page_gst, 2);
                                                    ?>
                                                </td>
                                                <td class="text-end fw-bold">
                                                    ₹<?php 
                                                        $page_total = 0;
                                                        mysqli_data_seek($orders_result, 0);
                                                        while($order = mysqli_fetch_assoc($orders_result)) {
                                                            $page_total += $order['total'];
                                                        }
                                                        echo number_format($page_total, 2);
                                                    ?>
                                                </td>
                                                <td colspan="2"></td>
                                            </tr>
                                        </tfoot>
                                        <?php endif; ?>
                                    </table>
                                </div>

<?php if($total_pages > 1): ?>
                                <div class="row mt-3">
                                    <div class="col-12">
                                        <nav aria-label="Page navigation">
                                            <ul class="pagination justify-content-center">
                                                <?php if($current_page > 1): ?>
                                                    <li class="page-item">
                                                        <a class="page-link" 
                                                           href="?<?php echo http_build_query(array_merge($_GET, ['page' => $current_page - 1])); ?>">
                                                            Previous
                                                        </a>
                                                    </li>
                                                <?php endif; ?>

<?php 
                                                $start_page = max(1, $current_page - 2);
                                                $end_page = min($total_pages, $current_page + 2);
                                                
                                                if($start_page > 1): ?>
                                                    <li class="page-item">
                                                        <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => 1])); ?>">1</a>
                                                    </li>
                                                    <?php if($start_page > 2): ?>
                                                        <li class="page-item disabled"><span class="page-link">...</span></li>
                                                    <?php endif; ?>
                                                <?php endif; ?>

<?php for($i = $start_page; $i <= $end_page; $i++): ?>
                                                    <li class="page-item <?php echo $i == $current_page ? 'active' : ''; ?>">
                                                        <a class="page-link" 
                                                           href="?<?php echo http_build_query(array_merge($_GET, ['page' => $i])); ?>">
                                                            <?php echo $i; ?>
                                                        </a>
                                                    </li>
                                                <?php endfor; ?>

<?php if($end_page < $total_pages): ?>
                                                    <?php if($end_page < $total_pages - 1): ?>
                                                        <li class="page-item disabled"><span class="page-link">...</span></li>
                                                    <?php endif; ?>
                                                    <li class="page-item">
                                                        <a class="page-link" 
                                                           href="?<?php echo http_build_query(array_merge($_GET, ['page' => $total_pages])); ?>">
                                                            <?php echo $total_pages; ?>
                                                        </a>
                                                    </li>
                                                <?php endif; ?>

<?php if($current_page < $total_pages): ?>
                                                    <li class="page-item">
                                                        <a class="page-link" 
                                                           href="?<?php echo http_build_query(array_merge($_GET, ['page' => $current_page + 1])); ?>">
                                                            Next
                                                        </a>
                                                    </li>
                                                <?php endif; ?>
                                            </ul>
                                        </nav>
                                        <div class="text-center text-muted">
                                            Showing <?php echo $offset + 1; ?> to <?php echo min($offset + $items_per_page, $total_records); ?> 
                                            of <?php echo $total_records; ?> orders
                                        </div>
                                    </div>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

</div>
        </div>

<?php include('includes/footer.php'); ?>
    </div>
</div>

<?php include('includes/rightbar.php'); ?>
<?php include('includes/scripts.php'); ?>

<script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.11.5/js/dataTables.bootstrap5.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>

// Export to Excel function
function exportToExcel() {
    // Create a new workbook
    const wb = XLSX.utils.book_new();
    
    // Get table data
    const table = document.getElementById('orders-table');
    const ws = XLSX.utils.table_to_sheet(table);
    
    // Add worksheet to workbook
    XLSX.utils.book_append_sheet(wb, ws, "Orders Report");
    
    // Generate filename with current date
    const dateStr = new Date().toISOString().slice(0,10);
    const filename = `orders_report_${dateStr}.xlsx`;
    
    // Save the file
    XLSX.writeFile(wb, filename);
}

// Print report function
function printReport() {
    const originalContents = document.body.innerHTML;
    const printContents = document.getElementById('orders-table').parentNode.innerHTML;
    
    document.body.innerHTML = `
        <!DOCTYPE html>
        <html>
        <head>
            <title>Orders Report - <?php echo date('Y-m-d'); ?></title>
            <style>
                body { font-family: Arial, sans-serif; margin: 20px; }
                table { width: 100%; border-collapse: collapse; margin: 20px 0; }
                th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
                th { background-color: #f2f2f2; font-weight: bold; }
                .text-end { text-align: right; }
                .fw-bold { font-weight: bold; }
                .print-header { text-align: center; margin-bottom: 30px; }
                .print-header h2 { margin: 0; }
                .print-header p { margin: 5px 0; color: #666; }
                .summary-box { 
                    background: #f8f9fa; 
                    border: 1px solid #dee2e6; 
                    padding: 15px; 
                    margin-bottom: 20px;
                    border-radius: 5px;
                }
                @media print {
                    .no-print { display: none; }
                    body { margin: 0; }
                }
            </style>
        </head>
        <body>
            <div class="print-header">
                <h2>Orders & Sales Report</h2>
                <p>Period: <?php echo h($start_date); ?> to <?php echo h($end_date); ?></p>
                <p>Generated on: <?php echo date('Y-m-d H:i:s'); ?></p>
            </div>
            
            <div class="summary-box">
                <div class="row">
                    <div class="col-3">
                        <strong>Total Orders:</strong> <?php echo number_format($summary['total_orders']); ?>
                    </div>
                    <div class="col-3">
                        <strong>Total Revenue:</strong> ₹<?php echo number_format($summary['total_revenue'], 2); ?>
                    </div>
                    <div class="col-3">
                        <strong>Total Discount:</strong> ₹<?php echo number_format($summary['total_discount'], 2); ?>
                    </div>
                    <div class="col-3">
                        <strong>Total GST:</strong> ₹<?php echo number_format($summary['total_gst'], 2); ?>
                    </div>
                </div>
            </div>
            
            ${printContents}
            
            <div class="no-print" style="margin-top: 20px; text-align: center;">
                <button onclick="window.print()" class="btn btn-primary">Print Report</button>
                <button onclick="window.close()" class="btn btn-secondary">Close</button>
            </div>
        </body>
        </html>
    `;
    
    window.print();
    document.body.innerHTML = originalContents;
    window.location.reload();
}

// Auto-refresh summary stats when filters change
$(document).ready(function() {
    $('form').on('change', 'select, input', function() {
        // Optionally, you can auto-submit the form or update stats via AJAX
        // For now, we'll just enable the apply filter button
        $('button[type="submit"]').removeAttr('disabled');
    });
});

// Confirm before deleting (if you add delete functionality)
function confirmDelete(orderId, invoiceNumber) {
    if(confirm(`Are you sure you want to delete invoice ${invoiceNumber}? This action cannot be undone.`)) {
        window.location.href = `delete-invoice.php?id=${orderId}`;
    }
}
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: orders-report.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation