Skip to content
TheChatArchiveThe Chat Archive
o1-mini-2024-09-12· OpenAIAi2 WildChat-4.8M (AI2)

in this codes (<?php // vieworders.php // Enable error reporting for debugging (disable…

  1. User

    in this codes (<?php // view_orders.php

    // Enable error reporting for debugging (disable in production) ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL);

    // Start output buffering to prevent "headers already sent" errors ob_start();

    // Include authentication and database connection before any output require_once DIR . '/../../includes/auth.php'; require_once DIR . '/../../includes/db_connect.php';

    // Helper Functions

    /**

    • Sanitize input to prevent XSS and other injections.
    • @param string $input The input string to sanitize.
    • @return string The sanitized string. */ function sanitize_input(input) { return htmlspecialchars(trim(input), ENT_QUOTES, 'UTF-8'); }

    /**

    • Build a query string while preserving existing parameters.
    • @param array $new_params Associative array of new parameters to add or update.
    • @return string The resulting query string. */ function build_query(new_params = []) { current_params = GET;foreach(_GET; foreach (new_params as key=>key => value) { if (value !== null) { // Only set if value is not null current_params[key]=key] = value; } else { unset(currentparams[current_params[key]); // Remove if value is null } } // Remove parameters that shouldn't persist unset(currentparams[′page′]);current_params['page']); query = http_build_query(currentparams);returncurrent_params); return query ? '?' . $query : ''; }

    /**

    • Generate a WhatsApp link from a contact number.

    • @param string $contact The contact number.

    • @return string The WhatsApp URL. */ function generate_whatsapp_link(contact) { // Remove any non-digit characters except the plus sign digits = preg_replace('/[^\d+]/', '', $contact);

      // Ensure the number starts with '+' if (strpos(digits, '+') !== 0) { digits = '+' . $digits; }

      return "https://wa.me/" . ltrim($digits, '+'); }

    /**

    • Calculate totals for a given set of order items.

    • @param array $order_items The array of order items.

    • @param float $delivery_fee The delivery fee for the order.

    • @param int $free_shipping Indicates if free shipping is applied (1 for yes, 0 for no).

    • @return array An associative array containing total_before_discounts, total_discounts, delivery_fee, and final_total. */ function calculate_order_totals(orderitems,order_items, delivery_fee, free_shipping) { total_before_discounts = 0; totaldiscounts=0;total_discounts = 0; final_total = 0;

      foreach (order_items as &item) { itemtotal=item_total = item['quantity'] * item[′productprice′];item['product_price']; discount_amount = (item[′discountpercentage′]/100)∗item['discount_percentage'] / 100) * item_total; item[′discountamount′]=item['discount_amount'] = discount_amount; item[′totalafterdiscount′]=item['total_after_discount'] = item_total - $discount_amount;

       $total_before_discounts += $item_total;
       $total_discounts += $discount_amount;
      

      } unset(item);//Breakreferenceitem); // Break reference final_total = totalbeforediscounts−total_before_discounts - total_discounts;

      // Add delivery fee if not free shipping if (!free_shipping) { final_total += $delivery_fee; }

      return [ 'total_before_discounts' => totalbeforediscounts,′totaldiscounts′=>total_before_discounts, 'total_discounts' => total_discounts, 'delivery_fee' => freeshipping?0.00:free_shipping ? 0.00 : delivery_fee, 'final_total' => $final_total ]; }

    // Handle Actions Before Including Header

    if (_SERVER['REQUEST_METHOD'] === 'POST') { if (isset(_POST['action'])) { if (_POST['action'] === 'update_status') { order_id = isset(POST[′orderid′])?intval(_POST['order_id']) ? intval(_POST['order_id']) : 0; newstatus=isset(new_status = isset(_POST['new_status']) ? sanitize_input($_POST['new_status']) : '';

            // Validate new_status
            $valid_statuses = ['Pending', 'In Progress', 'Completed', 'Delivered'];
            if ($order_id > 0 && in_array($new_status, $valid_statuses)) {
                // If setting to 'Delivered', ensure delivery_datetime is set
                if ($new_status === 'Delivered') {
                    $check_sql = "SELECT delivery_datetime FROM orders WHERE id = ?";
                    $check_stmt = $conn->prepare($check_sql);
                    if ($check_stmt) {
                        $check_stmt->bind_param("i", $order_id);
                        $check_stmt->execute();
                        $check_result = $check_stmt->get_result();
                        if ($check_result->num_rows == 1) {
                            $order = $check_result->fetch_assoc();
                            if (empty($order['delivery_datetime'])) {
                                $check_stmt->close();
                                header("Location: view_orders.php?error=3"); // Delivery datetime not set
                                exit();
                            }
                        }
                        $check_stmt->close();
                    } else {
                        header("Location: view_orders.php?error=2");
                        exit();
                    }
                }
    
                // Update status using prepared statement
                $update_sql = "UPDATE orders SET status = ? WHERE id = ?";
                $stmt = $conn->prepare($update_sql);
                if ($stmt) {
                    $stmt->bind_param("si", $new_status, $order_id);
                    if ($stmt->execute()) {
                        $stmt->close();
                        header("Location: view_orders.php?success=1");
                        exit();
                    } else {
                        $stmt->close();
                        header("Location: view_orders.php?error=1");
                        exit();
                    }
                } else {
                    header("Location: view_orders.php?error=2");
                    exit();
                }
            } else {
                header("Location: view_orders.php?error=2");
                exit();
            }
        } elseif ($_POST['action'] === 'mark_paid') {
            $order_id = isset($_POST['order_id']) ? intval($_POST['order_id']) : 0;
    
            if ($order_id > 0) {
                // Update is_paid to 1
                $update_sql = "UPDATE orders SET is_paid = 1 WHERE id = ?";
                $stmt = $conn->prepare($update_sql);
                if ($stmt) {
                    $stmt->bind_param("i", $order_id);
                    if ($stmt->execute()) {
                        $stmt->close();
                        header("Location: view_orders.php?success=3");
                        exit();
                    } else {
                        $stmt->close();
                        header("Location: view_orders.php?error=6");
                        exit();
                    }
                } else {
                    header("Location: view_orders.php?error=2");
                    exit();
                }
            } else {
                header("Location: view_orders.php?error=5");
                exit();
            }
        }
    }
    

    } elseif (isset(_GET['action'])) { if (_GET['action'] === 'export') { // Implement export functionality here (CSV Example) filename="orders".date("Y−m−dH−i−s").".csv";header(′Content−Type:text/csv′);header(′Content−Disposition:attachment;filename="′.filename = "orders_" . date("Y-m-d_H-i-s") . ".csv"; header('Content-Type: text/csv'); header('Content-Disposition: attachment;filename="' . filename . '"');

        $output = fopen('php://output', 'w');
        // Header Row
        fputcsv($output, ['Order ID', 'Customer Name', 'Contact', 'Delivery Address', 'Products', 'Delivery Fee', 'Status', 'Priority', 'Order Date', 'Delivery DateTime', 'Is Paid', 'Total (KD)']);
    
        // Fetch all orders based on current filters
        $filter = isset($_GET['filter']) ? sanitize_input($_GET['filter']) : 'all';
        $status_filter = isset($_GET['status_filter']) ? sanitize_input($_GET['status_filter']) : 'all';
        $priority_filter = isset($_GET['priority_filter']) ? sanitize_input($_GET['priority_filter']) : 'all';
        $search = isset($_GET['search']) ? sanitize_input($_GET['search']) : '';
        $sort_by = isset($_GET['sort_by']) ? sanitize_input($_GET['sort_by']) : 'order_date';
        $sort_order = isset($_GET['sort_order']) ? sanitize_input($_GET['sort_order']) : 'DESC';
        $orders_per_page = isset($_GET['orders_per_page']) ? intval($_GET['orders_per_page']) : ORDERS_PER_PAGE_DEFAULT;
    
        // Handle Date Range Filters
        $from_date = isset($_GET['from_date']) ? sanitize_input($_GET['from_date']) : '';
        $to_date = isset($_GET['to_date']) ? sanitize_input($_GET['to_date']) : '';
    
        // Initialize where conditions
        $where_conditions = [];
        $parameters = [];
        $param_types = "";
    
        // Status Filter
        if ($status_filter !== 'all') {
            $where_conditions[] = "o.status = ?";
            $parameters[] = $status_filter;
            $param_types .= "s";
        }
    
        // Priority Filter
        if ($priority_filter !== 'all') {
            $where_conditions[] = "o.priority = ?";
            $parameters[] = $priority_filter;
            $param_types .= "s";
        }
    
        // Search Filter
        if (!empty($search)) {
            $where_conditions[] = "(c.name LIKE ? OR o.id LIKE ? OR c.contact LIKE ?)";
            $search_term = "%" . $search . "%";
            $parameters[] = $search_term;
            $parameters[] = $search_term;
            $parameters[] = $search_term;
            $param_types .= "sss";
        }
    
        // Date Range Filter on order_date
        if (!empty($from_date)) {
            $where_conditions[] = "o.order_date >= ?";
            $parameters[] = $from_date . " 00:00:00";
            $param_types .= "s";
        }
    
        if (!empty($to_date)) {
            $where_conditions[] = "o.order_date <= ?";
            $parameters[] = $to_date . " 23:59:59";
            $param_types .= "s";
        }
    
        // Combine all where conditions
        $where_clause = "";
        if (count($where_conditions) > 0) {
            $where_clause = "WHERE " . implode(" AND ", $where_conditions);
        }
    
        // Sorting
        // To prevent SQL injection in ORDER BY, use a mapping
        $sort_column_map = [
            'id' => 'o.id',
            'customer_name' => 'c.name',
            'contact' => 'c.contact',
            'status' => 'o.status',
            'priority' => 'o.priority',
            'order_date' => 'o.order_date',
            'delivery_datetime' => 'o.delivery_datetime'
        ];
        $sort_column = isset($sort_column_map[$sort_by]) ? $sort_column_map[$sort_by] : 'o.order_date';
        $order_clause = "ORDER BY $sort_column $sort_order";
    
        // Fetch orders
        $orders_sql = "
            SELECT 
                o.id AS order_id,
                o.status,
                o.priority,
                o.order_date,
                o.delivery_datetime,
                o.delivery_fee,
                o.free_shipping,
                o.is_paid,
                c.name AS customer_name,
                c.contact,
                c.delivery_address
            FROM 
                orders o
            JOIN 
                customers c ON o.customer_id = c.id
            $where_clause
            $order_clause
        ";
        $orders_stmt = $conn->prepare($orders_sql);
        if ($orders_stmt) {
            if (!empty($where_clause)) {
                $orders_stmt->bind_param($param_types, ...$parameters);
            }
            $orders_stmt->execute();
            $orders_result = $orders_stmt->get_result();
    
            // Fetch order items for all orders
            $order_ids = [];
            while ($order = $orders_result->fetch_assoc()) {
                $order_ids[] = $order['order_id'];
            }
    
            $order_items = [];
            if (!empty($order_ids)) {
                $placeholders = implode(',', array_fill(0, count($order_ids), '?'));
                $types = str_repeat('i', count($order_ids));
                $order_items_sql = "
                    SELECT 
                        oi.order_id,
                        oi.product_id,
                        oi.quantity,
                        oi.packaging_preferences,
                        oi.discount_percentage,
                        oi.discount_reason,
                        p.name AS product_name,
                        p.size AS product_size,
                        p.price AS product_price
                    FROM 
                        order_items oi
                    JOIN 
                        products p ON oi.product_id = p.id
                    WHERE
                        oi.order_id IN ($placeholders)
                ";
                $items_stmt = $conn->prepare($order_items_sql);
                if ($items_stmt) {
                    $items_stmt->bind_param($types, ...$order_ids);
                    $items_stmt->execute();
                    $order_items_result = $items_stmt->get_result();
                    while ($item = $order_items_result->fetch_assoc()) {
                        $order_items[$item['order_id']][] = $item;
                    }
                    $items_stmt->close();
                }
            }
    
            // Populate CSV
            $orders_stmt->data_seek(0);
            while ($order = $orders_stmt->fetch_assoc()) {
                $items = isset($order_items[$order['order_id']]) ? $order_items[$order['order_id']] : [];
                $products = '';
                foreach ($items as $item) {
                    $products .= $item['product_name'] . ' (' . $item['quantity'] . ' x ' . number_format($item['product_price'], 2) . ' KD)';
                    if ($item['discount_percentage'] > 0) {
                        $products .= ' - Discount: ' . $item['discount_percentage'] . '% (' . $item['discount_reason'] . ')';
                    }
                    $products .= '; ';
                }
                $totals = calculate_order_totals($items, $order['delivery_fee'], $order['free_shipping']);
                fputcsv($output, [
                    $order['order_id'],
                    $order['customer_name'],
                    $order['contact'],
                    $order['delivery_address'],
                    $products,
                    $order['free_shipping'] ? 'Free' : number_format($order['delivery_fee'], 2) . ' KD',
                    $order['status'],
                    $order['priority'],
                    $order['order_date'],
                    $order['delivery_datetime'],
                    $order['is_paid'] ? 'Paid' : 'Unpaid',
                    number_format($totals['final_total'], 2) . ' KD'
                ]);
            }
    
            $orders_stmt->close();
        }
    
        fclose($output);
        exit();
    }
    

    }

    // Now include the header after handling actions require_once DIR . '/../../includes/header.php';

    // Constants for pagination define('ORDERS_PER_PAGE_DEFAULT', 10);

    // Handle Filters, Sorting, and Pagination filter=isset(filter = isset(_GET['filter']) ? sanitize_input(GET[′filter′]):′all′;_GET['filter']) : 'all'; status_filter = isset(GET[′statusfilter′])?sanitizeinput(_GET['status_filter']) ? sanitize_input(_GET['status_filter']) : 'all'; priorityfilter=isset(priority_filter = isset(_GET['priority_filter']) ? sanitize_input(GET[′priorityfilter′]):′all′;_GET['priority_filter']) : 'all'; search = isset(GET[′search′])?sanitizeinput(_GET['search']) ? sanitize_input(_GET['search']) : ''; sortby=isset(sort_by = isset(_GET['sort_by']) ? sanitize_input(GET[′sortby′]):′orderdate′;_GET['sort_by']) : 'order_date'; sort_order = isset(GET[′sortorder′])?sanitizeinput(_GET['sort_order']) ? sanitize_input(_GET['sort_order']) : 'DESC'; page=isset(page = isset(_GET['page']) ? intval(GET[′page′]):1;_GET['page']) : 1; orders_per_page = isset(GET[′ordersperpage′])?intval(_GET['orders_per_page']) ? intval(_GET['orders_per_page']) : ORDERS_PER_PAGE_DEFAULT;

    // Handle Date Range Filters fromdate=isset(from_date = isset(_GET['from_date']) ? sanitize_input(GET[′fromdate′]):′′;_GET['from_date']) : ''; to_date = isset(GET[′todate′])?sanitizeinput(_GET['to_date']) ? sanitize_input(_GET['to_date']) : '';

    // Validate orders_per_page allowedordersperpage=[10,20,50];if(!inarray(allowed_orders_per_page = [10, 20, 50]; if (!in_array(orders_per_page, allowed_orders_per_page)) { orders_per_page = ORDERS_PER_PAGE_DEFAULT; }

    // Validate sort_by and sort_order allowedsortcolumns=[′id′,′customername′,′contact′,′status′,′priority′,′orderdate′,′deliverydatetime′];if(!inarray(allowed_sort_columns = ['id', 'customer_name', 'contact', 'status', 'priority', 'order_date', 'delivery_datetime']; if (!in_array(sort_by, allowed_sort_columns)) { sort_by = 'order_date'; }

    allowedsortorders=[′ASC′,′DESC′];if(!inarray(allowed_sort_orders = ['ASC', 'DESC']; if (!in_array(sort_order, allowed_sort_orders)) { sort_order = 'DESC'; }

    // Initialize where conditions whereconditions=[];where_conditions = []; parameters = []; $param_types = "";

    // Status Filter if (status_filter !== 'all') { where_conditions[] = "o.status = ?"; parameters[]=parameters[] = status_filter; $param_types .= "s"; }

    // Priority Filter if (priority_filter !== 'all') { where_conditions[] = "o.priority = ?"; parameters[]=parameters[] = priority_filter; $param_types .= "s"; }

    // Search Filter if (!empty(search)) { where_conditions[] = "(c.name LIKE ? OR o.id LIKE ? OR c.contact LIKE ?)"; searchterm="search_term = "%" . search . "%"; parameters[]=parameters[] = search_term; parameters[]=parameters[] = search_term; parameters[]=parameters[] = search_term; $param_types .= "sss"; }

    // Date Range Filter on order_date if (!empty(from_date)) { where_conditions[] = "o.order_date >= ?"; parameters[]=parameters[] = from_date . " 00:00:00"; $param_types .= "s"; }

    if (!empty(to_date)) { where_conditions[] = "o.order_date <= ?"; parameters[]=parameters[] = to_date . " 23:59:59"; $param_types .= "s"; }

    // Combine all where conditions whereclause="";if(count(where_clause = ""; if (count(where_conditions) > 0) { whereclause="WHERE".implode("AND",where_clause = "WHERE " . implode(" AND ", where_conditions); }

    // Sorting // To prevent SQL injection in ORDER BY, use a mapping sortcolumnmap=[′id′=>′o.id′,′customername′=>′c.name′,′contact′=>′c.contact′,′status′=>′o.status′,′priority′=>′o.priority′,′orderdate′=>′o.orderdate′,′deliverydatetime′=>′o.deliverydatetime′];sort_column_map = [ 'id' => 'o.id', 'customer_name' => 'c.name', 'contact' => 'c.contact', 'status' => 'o.status', 'priority' => 'o.priority', 'order_date' => 'o.order_date', 'delivery_datetime' => 'o.delivery_datetime' ]; sort_column = isset(sortcolumnmap[sort_column_map[sort_by]) ? sortcolumnmap[sort_column_map[sort_by] : 'o.order_date'; orderclause="ORDERBYorder_clause = "ORDER BY sort_column $sort_order";

    // Pagination Calculations offset=(offset = (page - 1) * $orders_per_page;

    // Fetch total number of orders for pagination countsql="SELECTCOUNT(DISTINCTo.id)astotalFROMordersoJOINcustomerscONo.customerid=c.idcount_sql = " SELECT COUNT(DISTINCT o.id) as total FROM orders o JOIN customers c ON o.customer_id = c.id where_clause "; countstmt=count_stmt = conn->prepare(countsql);if(count_sql); if (count_stmt) { if (!empty(where_clause)) { count_stmt->bind_param(paramtypes,...param_types, ...parameters); } countstmt−>execute();count_stmt->execute(); count_result = countstmt−>getresult();count_stmt->get_result(); total_orders = countresult−>fetchassoc()[′total′];count_result->fetch_assoc()['total']; count_stmt->close(); } else { // Handle SQL preparation error die("Failed to prepare the count query: " . $conn->error); }

    // Calculate total pages totalpages=ceil(total_pages = ceil(total_orders / $orders_per_page);

    // Fetch orders with customer details based on filters and sorting orderssql="SELECTo.idASorderid,o.status,o.priority,o.orderdate,o.deliverydatetime,o.deliveryfee,o.freeshipping,o.ispaid,c.nameAScustomername,c.contact,c.deliveryaddressFROMordersoJOINcustomerscONo.customerid=c.idorders_sql = " SELECT o.id AS order_id, o.status, o.priority, o.order_date, o.delivery_datetime, o.delivery_fee, o.free_shipping, o.is_paid, c.name AS customer_name, c.contact, c.delivery_address FROM orders o JOIN customers c ON o.customer_id = c.id where_clause orderclauseLIMIT?,?";order_clause LIMIT ?, ? "; orders_stmt = conn−>prepare(conn->prepare(orders_sql); if (orders_stmt) { // Bind parameters if (!empty(where_clause)) { // 'ii' for offset and limit types=types = param_types . "ii"; values=arraymerge(values = array_merge(parameters, [offset,offset, orders_per_page]); ordersstmt−>bindparam(orders_stmt->bind_param(types, ...values); } else { orders_stmt->bind_param("ii", offset,offset, orders_per_page); } ordersstmt−>execute();orders_stmt->execute(); orders_result = orders_stmt->get_result(); } else { // Handle SQL preparation error die("Failed to prepare the orders query: " . conn->error); }

    // Fetch order items for all orders orderids=[];if(order_ids = []; if (orders_result && orders_result->num_rows > 0) { while (order = orders_result->fetch_assoc()) { order_ids[] = order['order_id']; } // Reset result pointer orders_result->data_seek(0); }

    orderitems=[];if(!empty(order_items = []; if (!empty(order_ids)) { placeholders=implode(′,′,arrayfill(0,count(placeholders = implode(',', array_fill(0, count(order_ids), '?')); types=strrepeat(′i′,count(types = str_repeat('i', count(order_ids)); orderitemssql="SELECToi.orderid,oi.productid,oi.quantity,oi.packagingpreferences,oi.discountpercentage,oi.discountreason,p.nameASproductname,p.sizeASproductsize,p.priceASproductpriceFROMorderitemsoiJOINproductspONoi.productid=p.idWHEREoi.orderidIN(order_items_sql = " SELECT oi.order_id, oi.product_id, oi.quantity, oi.packaging_preferences, oi.discount_percentage, oi.discount_reason, p.name AS product_name, p.size AS product_size, p.price AS product_price FROM order_items oi JOIN products p ON oi.product_id = p.id WHERE oi.order_id IN (placeholders) "; itemsstmt=items_stmt = conn->prepare(orderitemssql);if(order_items_sql); if (items_stmt) { itemsstmt−>bindparam(items_stmt->bind_param(types, ...orderids);order_ids); items_stmt->execute(); orderitemsresult=order_items_result = items_stmt->get_result(); while (item=item = order_items_result->fetch_assoc()) { orderitems[order_items[item['order_id']][] = item; } items_stmt->close(); } } ?>

    <!-- Google Fonts -->
    <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@400;600;700&family=Roboto:wght@400;500;700&family=Inter:wght@400;600;700&display=swap" rel="stylesheet">
    
    <!-- Bootstrap Icons -->
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css">
    
    <!-- Flatpickr CSS for Date Picker -->
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">
    
    <!-- UnoCSS CDN -->
    <script type="module">
        import 'https://unpkg.com/@unocss/runtime?module';
    </script>
    
    <!-- Custom Styles Removed -->
    
    <!-- Tailwind CSS -->
    <script src="https://cdn.tailwindcss.com"></script>
    
    <!-- Additional JavaScript for Print Functionality -->
    <script>
        function printOrders() {
            window.print();
        }
    
        function exportOrders() {
            window.location.href = 'view_orders.php?action=export';
        }
    </script>
    
    <?php if (isset($_GET['error'])): ?>
        <?php if ($_GET['error'] == 1): ?>
            <div class="flex items-center bg-red-500 text-white text-sm font-bold px-4 py-3 rounded mb-4" role="alert">
                <i class="bi bi-exclamation-triangle-fill mr-2"></i>
                <span>Failed to update order status.</span>
            </div>
        <?php elseif ($_GET['error'] == 2): ?>
            <div class="flex items-center bg-red-500 text-white text-sm font-bold px-4 py-3 rounded mb-4" role="alert">
                <i class="bi bi-exclamation-triangle-fill mr-2"></i>
                <span>Invalid status selected.</span>
            </div>
        <?php elseif ($_GET['error'] == 3): ?>
            <div class="flex items-center bg-red-500 text-white text-sm font-bold px-4 py-3 rounded mb-4" role="alert">
                <i class="bi bi-exclamation-triangle-fill mr-2"></i>
                <span>Cannot set status to Delivered without a delivery date and time.</span>
            </div>
        <?php elseif ($_GET['error'] == 4): ?>
            <div class="flex items-center bg-red-500 text-white text-sm font-bold px-4 py-3 rounded mb-4" role="alert">
                <i class="bi bi-exclamation-triangle-fill mr-2"></i>
                <span>Failed to delete the order. Please try again.</span>
            </div>
        <?php elseif ($_GET['error'] == 5): ?>
            <div class="flex items-center bg-red-500 text-white text-sm font-bold px-4 py-3 rounded mb-4" role="alert">
                <i class="bi bi-exclamation-triangle-fill mr-2"></i>
                <span>Invalid order ID provided.</span>
            </div>
        <?php elseif ($_GET['error'] == 6): ?>
            <div class="flex items-center bg-red-500 text-white text-sm font-bold px-4 py-3 rounded mb-4" role="alert">
                <i class="bi bi-exclamation-triangle-fill mr-2"></i>
                <span>Failed to mark the order as paid. Please try again.</span>
            </div>
        <?php endif; ?>
    <?php endif; ?>
    
    
    <!-- Recent Orders Section -->
    <div class="mb-8">
        <h2 class="text-2xl font-poppins font-bold text-gray-800 mb-4">All Orders</h2>
    
        <!-- Filter and Search Section -->
        <div class="flex flex-col md:flex-row md:justify-between mb-6 space-y-4 md:space-y-0">
            <!-- Filters -->
            <div class="flex flex-wrap items-center space-x-4">
                <!-- Status Filter -->
                <div class="flex items-center space-x-2">
                    <i class="bi bi-filter-circle-fill text-xl text-gray-600"></i>
                    <label for="statusFilter" class="font-semibold text-gray-700">Status:</label>
                    <select id="statusFilter" onchange="applyFilters()" class="border border-gray-300 rounded px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500">
                        <option value="all" <?php echo $status_filter === 'all' ? 'selected' : ''; ?>>All</option>
                        <option value="Pending" <?php echo $status_filter === 'Pending' ? 'selected' : ''; ?>>Pending</option>
                        <option value="In Progress" <?php echo $status_filter === 'In Progress' ? 'selected' : ''; ?>>In Progress</option>
                        <option value="Completed" <?php echo $status_filter === 'Completed' ? 'selected' : ''; ?>>Completed</option>
                        <option value="Delivered" <?php echo $status_filter === 'Delivered' ? 'selected' : ''; ?>>Delivered</option>
                    </select>
                </div>
    
                <!-- Priority Filter -->
                <div class="flex items-center space-x-2">
                    <i class="bi bi-filter-circle-fill text-xl text-gray-600"></i>
                    <label for="priorityFilter" class="font-semibold text-gray-700">Priority:</label>
                    <select id="priorityFilter" onchange="applyFilters()" class="border border-gray-300 rounded px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500">
                        <option value="all" <?php echo $priority_filter === 'all' ? 'selected' : ''; ?>>All</option>
                        <option value="Quick" <?php echo $priority_filter === 'Quick' ? 'selected' : ''; ?>>Quick</option>
                        <option value="Important" <?php echo $priority_filter === 'Important' ? 'selected' : ''; ?>>Important</option>
                        <option value="Normal" <?php echo $priority_filter === 'Normal' ? 'selected' : ''; ?>>Normal</option>
                    </select>
                </div>
    
                <!-- Entries Per Page -->
                <div class="flex items-center space-x-2">
                    <i class="bi bi-layout-split text-xl text-gray-600"></i>
                    <label for="entriesPerPage" class="font-semibold text-gray-700">Show:</label>
                    <select id="entriesPerPage" onchange="applyFilters()" class="border border-gray-300 rounded px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500">
                        <option value="10" <?php echo $orders_per_page == 10 ? 'selected' : ''; ?>>10</option>
                        <option value="20" <?php echo $orders_per_page == 20 ? 'selected' : ''; ?>>20</option>
                        <option value="50" <?php echo $orders_per_page == 50 ? 'selected' : ''; ?>>50</option>
                    </select>
                    <span class="text-gray-700">entries</span>
                </div>
    
                <!-- Export and Print Buttons -->
                <div class="flex items-center space-x-2">
                    <button onclick="exportOrders()" class="flex items-center space-x-1 bg-teal-500 text-white px-4 py-2 rounded hover:bg-teal-600 transition duration-300">
                        <i class="bi bi-file-earmark-arrow-down-fill"></i>
                        <span>Export</span>
                    </button>
                    <button onclick="printOrders()" class="flex items-center space-x-1 bg-gray-700 text-white px-4 py-2 rounded hover:bg-gray-800 transition duration-300">
                        <i class="bi bi-printer-fill"></i>
                        <span>Print</span>
                    </button>
                </div>
    
                <!-- Reset Filters Button -->
                <div class="flex items-center space-x-2">
                    <?php
                        // Build the reset URL with default filter values while preserving sort parameters
                        $reset_params = [
                            'filter' => 'all',
                            'status_filter' => 'all',
                            'priority_filter' => 'all',
                            'search' => null,
                            'from_date' => null,
                            'to_date' => null,
                            'sort_by' => $sort_by,
                            'sort_order' => $sort_order,
                            'orders_per_page' => $orders_per_page,
                            'page' => 1
                        ];
                    ?>
                    <a href="view_orders.php<?php echo build_query($reset_params); ?>" class="flex items-center space-x-1 bg-gray-500 text-white px-3 py-2 rounded hover:bg-gray-600 transition duration-300">
                        <i class="bi bi-arrow-counterclockwise"></i>
                        <span>Reset Filters</span>
                    </a>
                </div>
            </div>
    
            <!-- Search Input Above the Table -->
            <div class="w-full md:w-1/3">
                <form method="GET" action="view_orders.php" class="flex items-center space-x-2">
                    <input type="hidden" name="filter" value="<?php echo sanitize_input($filter); ?>">
                    <input type="hidden" name="status_filter" value="<?php echo sanitize_input($status_filter); ?>">
                    <input type="hidden" name="priority_filter" value="<?php echo sanitize_input($priority_filter); ?>">
                    <input type="hidden" name="from_date" value="<?php echo sanitize_input($from_date); ?>">
                    <input type="hidden" name="to_date" value="<?php echo sanitize_input($to_date); ?>">
                    <input type="hidden" name="sort_by" value="<?php echo sanitize_input($sort_by); ?>">
                    <input type="hidden" name="sort_order" value="<?php echo sanitize_input($sort_order); ?>">
                    <input type="text" name="search" class="flex-1 border border-gray-300 rounded px-4 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500" placeholder="🔍 Search by Customer, ID, or Contact" value="<?php echo sanitize_input($search); ?>">
                    <button type="submit" class="flex items-center space-x-1 bg-teal-500 text-white px-4 py-2 rounded hover:bg-teal-600 transition duration-300">
                        <i class="bi bi-search"></i>
                        <span>Search</span>
                    </button>
                    <?php if (!empty($search)): ?>
                        <a href="view_orders.php<?php echo build_query(['search' => null, 'page' => 1]); ?>" class="flex items-center space-x-1 bg-red-500 text-white px-3 py-2 rounded hover:bg-red-600 transition duration-300">
                            <i class="bi bi-x-circle"></i>
                            <span>Reset</span>
                        </a>
                    <?php endif; ?>
                </form>
            </div>
        </div>
    
        <!-- Date Range Filter -->
        <div class="flex flex-wrap items-center space-x-4 mb-6">
            <div class="flex items-center space-x-2">
                <i class="bi bi-calendar-check-fill text-xl text-gray-600"></i>
                <label for="fromDate" class="font-semibold text-gray-700">From:</label>
                <input type="text" id="fromDate" name="from_date" class="border border-gray-300 rounded px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500" placeholder="YYYY-MM-DD" value="<?php echo sanitize_input($from_date); ?>">
            </div>
            <div class="flex items-center space-x-2">
                <i class="bi bi-calendar-check-fill text-xl text-gray-600"></i>
                <label for="toDate" class="font-semibold text-gray-700">To:</label>
                <input type="text" id="toDate" name="to_date" class="border border-gray-300 rounded px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500" placeholder="YYYY-MM-DD" value="<?php echo sanitize_input($to_date); ?>">
            </div>
            <button type="button" class="flex items-center space-x-1 bg-gray-700 text-white px-4 py-2 rounded hover:bg-gray-800 transition duration-300" onclick="applyDateFilters()">
                <i class="bi bi-calendar-fill"></i>
                <span>Apply</span>
            </button>
        </div>
    
        <!-- Pagination Information -->
        <div class="text-sm text-gray-600 mb-4">
            <?php
                if ($total_orders == 0) {
                    $start_order = 0;
                    $end_order = 0;
                } else {
                    $start_order = ($page - 1) * $orders_per_page + 1;
                    $end_order = min($page * $orders_per_page, $total_orders);
                }
                echo "Showing <strong>$start_order</strong> to <strong>$end_order</strong> of <strong>$total_orders</strong> orders";
            ?>
        </div>
    
        <!-- Orders Cards -->
        <div class="grid grid-cols-1 md:grid-cols-2 gap-6">
            <?php if ($orders_result && $orders_result->num_rows > 0): ?>
                <?php while($order = $orders_result->fetch_assoc()): ?>
                    <?php
                        // Check if the order is new (created within last 24 hours)
                        $is_new = (strtotime($order['order_date']) >= strtotime('-1 day'));
                        // Generate WhatsApp link
                        $whatsapp_link = generate_whatsapp_link($order['contact']);
    
                        // Determine badge class and card border based on status
                        switch ($order['status']) {
                            case 'Pending':
                                $badge_class = 'bg-yellow-400';
                                $icon = 'hourglass-split';
                                $border_class = 'border-yellow-400';
                                break;
                            case 'In Progress':
                                $badge_class = 'bg-indigo-500';
                                $icon = 'arrow-repeat';
                                $border_class = 'border-indigo-500';
                                break;
                            case 'Completed':
                                $badge_class = 'bg-green-500';
                                $icon = 'check-circle-fill';
                                $border_class = 'border-green-500';
                                break;
                            case 'Delivered':
                                $badge_class = 'bg-teal-500';
                                $icon = 'box-seam';
                                $border_class = 'border-teal-500';
                                break;
                            default:
                                $badge_class = 'bg-gray-400';
                                $icon = 'info-circle';
                                $border_class = 'border-gray-400';
                        }
    
                        // Fetch order items
                        $items = isset($order_items[$order['order_id']]) ? $order_items[$order['order_id']] : [];
    
                        // Calculate order totals, including delivery fee if applicable
                        $totals = calculate_order_totals($items, $order['delivery_fee'], $order['free_shipping']);
                    ?>
                    <div class="bg-white shadow-lg rounded-lg p-6 border-l-4 <?php echo $border_class; ?>">
                        <!-- Header -->
                        <div class="flex justify-between items-center mb-4">
                            <div>
                                <h3 class="text-xl font-poppins font-bold text-gray-800">Order #<?= htmlspecialchars($order['order_id']) ?></h3>
                                <?php if ($is_new): ?>
                                    <span class="inline-flex items-center px-2.5 py-0.5 rounded-full text-xs font-medium bg-teal-500 text-white">New</span>
                                <?php endif; ?>
                            </div>
                            <div>
                                <span class="inline-flex items-center px-2 py-0.5 rounded-full text-xs font-semibold <?php echo $badge_class; ?> text-white">
                                    <i class="bi bi-<?= $icon ?> mr-1"></i> <?= htmlspecialchars($order['status']) ?>
                                </span>
                            </div>
                        </div>
    
                        <!-- Customer Info -->
                        <div class="mb-4">
                            <h4 class="text-lg font-semibold text-gray-700">Customer Details</h4>
                            <p class="text-gray-600">
                                <strong>Name:</strong> <?= htmlspecialchars($order['customer_name']) ?><br>
                                <strong>Contact:</strong> <a href="<?= $whatsapp_link ?>" target="_blank" class="text-teal-500 hover:underline"><i class="bi bi-whatsapp"></i> <?= htmlspecialchars($order['contact']) ?></a><br>
                                <strong>Address:</strong> <?= nl2br(htmlspecialchars($order['delivery_address'])) ?>
                            </p>
                        </div>
    
                        <!-- Products -->
                        <div class="mb-4">
                            <h4 class="text-lg font-semibold text-gray-700">Products</h4>
                            <?php if (!empty($items)): ?>
                                <ul class="list-disc list-inside text-gray-600">
                                    <?php foreach ($items as $item): ?>
                                        <li>
                                            <strong><?= htmlspecialchars($item['product_name']) ?></strong>
                                            <?php if (!empty($item['product_size'])): ?>
                                                (<?= htmlspecialchars($item['product_size']) ?>)
                                            <?php endif; ?> -
                                            <?= htmlspecialchars($item['quantity']) ?> x <?= number_format($item['product_price'], 2) ?> KD
                                            <?php if (floatval($item['discount_percentage']) > 0): ?>
                                                <span class="text-red-500">-<?= htmlspecialchars($item['discount_percentage']) ?>%</span>
                                                (<?= htmlspecialchars($item['discount_reason']) ?>)
                                            <?php endif; ?>
                                        </li>
                                    <?php endforeach; ?>
                                </ul>
                            <?php else: ?>
                                <p class="text-gray-500">No products found.</p>
                            <?php endif; ?>
                        </div>
    
                        <!-- Totals -->
                        <div class="mb-4">
                            <h4 class="text-lg font-semibold text-gray-700">Totals</h4>
                            <p class="text-gray-600">
                                <strong>Total Before Discounts:</strong> <?= number_format($totals['total_before_discounts'], 2) ?> KD<br>
                                <strong>Total Discounts:</strong> <?= number_format($totals['total_discounts'], 2) ?> KD<br>
                                <strong>Delivery Fee:</strong> <?= $order['free_shipping'] ? 'Free' : number_format($order['delivery_fee'], 2) . ' KD' ?><br>
                                <strong><span class="text-xl"><?= number_format($totals['final_total'], 2) ?> KD</span></strong>
                                <?php if($order['is_paid']): ?>
                                    <span class="inline-flex items-center px-2 py-0.5 rounded-full text-xs font-medium bg-green-500 text-white ml-2">Paid</span>
                                <?php else: ?>
                                    <span class="inline-flex items-center px-2 py-0.5 rounded-full text-xs font-medium bg-red-500 text-white ml-2">Unpaid</span>
                                <?php endif; ?>
                            </p>
                        </div>
    
                        <!-- Actions -->
                        <div class="flex flex-wrap space-x-2">
                            <!-- Edit Order -->
                            <button onclick="editOrder(<?= htmlspecialchars($order['order_id']) ?>)" class="flex items-center space-x-1 bg-blue-500 text-white px-3 py-2 rounded hover:bg-blue-600 transition duration-300">
                                <i class="bi bi-pencil-fill"></i>
                                <span>Edit</span>
                            </button>
                            
                            <!-- Change Status -->
                            <button onclick="openStatusModal(<?= htmlspecialchars($order['order_id']) ?>, '<?= htmlspecialchars($order['status']) ?>')" class="flex items-center space-x-1 bg-indigo-500 text-white px-3 py-2 rounded hover:bg-indigo-600 transition duration-300">
                                <i class="bi bi-arrow-repeat"></i>
                                <span>Status</span>
                            </button>
                            
                            <!-- Mark as Paid -->
                            <?php if(!$order['is_paid']): ?>
                                <button onclick="markPaid(<?= htmlspecialchars($order['order_id']) ?>)" class="flex items-center space-x-1 bg-green-500 text-white px-3 py-2 rounded hover:bg-green-600 transition duration-300">
                                    <i class="bi bi-cash-stack"></i>
                                    <span>Mark Paid</span>
                                </button>
                            <?php endif; ?>
                            
                            <!-- Delete Order -->
                            <button onclick="confirmDelete(<?= htmlspecialchars($order['order_id']) ?>)" class="flex items-center space-x-1 bg-red-500 text-white px-3 py-2 rounded hover:bg-red-600 transition duration-300">
                                <i class="bi bi-trash-fill"></i>
                                <span>Delete</span>
                            </button>
                            
                            <!-- View Customer Order -->
                            <a href="view_order_customer.php?order_id=<?= htmlspecialchars($order['order_id']) ?>" class="flex items-center space-x-1 bg-teal-500 text-white px-3 py-2 rounded hover:bg-teal-600 transition duration-300" target="_blank">
                                <i class="bi bi-eye-fill"></i>
                                <span>View</span>
                            </a>
                        </div>
                    </div>
                <?php endwhile; ?>
            <?php else: ?>
                <div class="col-span-1 md:col-span-2 text-center text-gray-500 py-4">
                    No orders found.
                </div>
            <?php endif; ?>
        </div>
    
        <!-- Pagination -->
        <?php if ($total_pages > 1): ?>
            <div class="flex justify-center mt-6">
                <nav aria-label="Order pagination">
                    <ul class="inline-flex -space-x-px">
                        <!-- Previous -->
                        <li>
                            <a href="view_orders.php<?php
                                $prev_page = max($page - 1, 1);
                                $reset_params_prev = [
                                    'filter' => $filter,
                                    'status_filter' => $status_filter,
                                    'priority_filter' => $priority_filter,
                                    'search' => $search,
                                    'from_date' => $from_date,
                                    'to_date' => $to_date,
                                    'sort_by' => $sort_by,
                                    'sort_order' => $sort_order,
                                    'orders_per_page' => $orders_per_page,
                                    'page' => $prev_page
                                ];
                                echo build_query($reset_params_prev);
                            ?>" class="py-2 px-3 ml-0 leading-tight text-gray-500 bg-white border border-gray-300 rounded-l-lg hover:bg-gray-100 hover:text-gray-700">Previous</a>
                        </li>
    
                        <!-- Page Numbers -->
                        <?php
                            // Determine the range of pages to show
                            $max_links = 5;
                            $start = max($page - floor($max_links / 2), 1);
                            $end = min($start + $max_links - 1, $total_pages);
                            if ($end - $start < $max_links - 1) {
                                $start = max($end - $max_links + 1, 1);
                            }
                        ?>
                        <?php for ($i = $start; $i <= $end; $i++): ?>
                            <li>
                                <a href="view_orders.php<?php
                                    $reset_params_page = [
                                        'filter' => $filter,
                                        'status_filter' => $status_filter,
                                        'priority_filter' => $priority_filter,
                                        'search' => $search,
                                        'from_date' => $from_date,
                                        'to_date' => $to_date,
                                        'sort_by' => $sort_by,
                                        'sort_order' => $sort_order,
                                        'orders_per_page' => $orders_per_page,
                                        'page' => $i
                                    ];
                                    echo build_query($reset_params_page);
                                ?>" class="py-2 px-3 leading-tight <?php echo ($page == $i) ? 'text-white bg-teal-500 border-teal-500' : 'text-gray-500 bg-white border-gray-300'; ?> border hover:bg-gray-100 hover:text-gray-700">
                                    <?php echo $i; ?>
                                </a>
                            </li>
                        <?php endfor; ?>
    
                        <!-- Next -->
                        <li>
                            <a href="view_orders.php<?php
                                $next_page = min($page + 1, $total_pages);
                                $reset_params_next = [
                                    'filter' => $filter,
                                    'status_filter' => $status_filter,
                                    'priority_filter' => $priority_filter,
                                    'search' => $search,
                                    'from_date' => $from_date,
                                    'to_date' => $to_date,
                                    'sort_by' => $sort_by,
                                    'sort_order' => $sort_order,
                                    'orders_per_page' => $orders_per_page,
                                    'page' => $next_page
                                ];
                                echo build_query($reset_params_next);
                            ?>" class="py-2 px-3 leading-tight text-gray-500 bg-white border border-gray-300 rounded-r-lg hover:bg-gray-100 hover:text-gray-700">Next</a>
                        </li>
                    </ul>
                </nav>
            </div>
        <?php endif; ?>
    
        <!-- Footer -->
        <div class="text-center text-gray-500 mt-8">
            &copy; <?= date("Y") ?> Kaak Alia Bakery. All rights reserved.
        </div>
    </div>
    
    <!-- Change Status Modal -->
    <div id="statusModal" class="hidden fixed inset-0 bg-black bg-opacity-50 flex items-center justify-center z-50">
        <div class="bg-white rounded-lg shadow-lg w-80">
            <div class="p-4 border-b">
                <h3 class="text-lg font-semibold text-gray-800">Change Order Status</h3>
            </div>
            <form id="statusForm" method="POST" action="view_orders.php">
                <div class="p-4">
                    <input type="hidden" name="action" value="update_status">
                    <input type="hidden" id="modal_order_id" name="order_id" value="">
                    <label for="newStatus" class="block text-gray-700 font-medium mb-2">Select New Status:</label>
                    <select id="newStatus" name="new_status" class="w-full border border-gray-300 rounded px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500" required>
                        <option value="">-- Select Status --</option>
                        <option value="Pending">Pending</option>
                        <option value="In Progress">In Progress</option>
                        <option value="Completed">Completed</option>
                        <option value="Delivered">Delivered</option>
                    </select>
                </div>
                <div class="flex justify-end p-4 border-t">
                    <button type="button" onclick="closeStatusModal()" class="bg-gray-500 text-white px-4 py-2 rounded mr-2 hover:bg-gray-600 transition duration-300">Cancel</button>
                    <button type="submit" class="bg-teal-500 text-white px-4 py-2 rounded hover:bg-teal-600 transition duration-300">Update</button>
                </div>
            </form>
        </div>
    </div>
    
    <!-- Delete Confirmation Modal -->
    <div id="deleteModal" class="hidden fixed inset-0 bg-black bg-opacity-50 flex items-center justify-center z-50">
        <div class="bg-white rounded-lg shadow-lg w-80">
            <div class="p-4 border-b">
                <h3 class="text-lg font-semibold text-gray-800">Confirm Deletion</h3>
            </div>
            <div class="p-4">
                <p class="text-gray-700">Are you sure you want to delete this order? This action cannot be undone.</p>
            </div>
            <div class="flex justify-end p-4 border-t">
                <button onclick="closeDeleteModal()" class="bg-gray-500 text-white px-4 py-2 rounded mr-2 hover:bg-gray-600 transition duration-300">Cancel</button>
                <form id="deleteForm" method="POST" action="view_orders.php">
                    <input type="hidden" name="action" value="delete_order">
                    <input type="hidden" id="delete_order_id" name="order_id" value="">
                    <button type="submit" class="bg-red-500 text-white px-4 py-2 rounded hover:bg-red-600 transition duration-300">Delete</button>
                </form>
            </div>
        </div>
    </div>
    
    <!-- Bootstrap Icons JS (optional if interactivity is needed) -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.js"></script>
    
    <!-- UnoCSS Runtime (ensure it's loaded) -->
    <script type="module">
        import 'https://unpkg.com/@unocss/runtime?module';
    </script>
    
    <!-- JavaScript for Interactivity -->
    <script>
        // Initialize Flatpickr for date inputs
        flatpickr("#fromDate", {
            dateFormat: "Y-m-d",
            maxDate: "today",
            allowInput: true
        });
    
        flatpickr("#toDate", {
            dateFormat: "Y-m-d",
            maxDate: "today",
            allowInput: true
        });
    
        // Function to handle sorting
        function sortTable(column) {
            const urlParams = new URLSearchParams(window.location.search);
            let currentSortBy = urlParams.get('sort_by') || 'order_date';
            let currentSortOrder = urlParams.get('sort_order') || 'DESC';
    
            if (currentSortBy === column) {
                // Toggle sort order
                currentSortOrder = currentSortOrder === 'ASC' ? 'DESC' : 'ASC';
            } else {
                currentSortBy = column;
                currentSortOrder = 'ASC';
            }
    
            urlParams.set('sort_by', currentSortBy);
            urlParams.set('sort_order', currentSortOrder);
            // Reset to first page if pagination is implemented
            urlParams.set('page', 1);
    
            window.location.search = urlParams.toString();
        }
    
        // Function to confirm deletion using custom modal
        function confirmDelete(orderId) {
            const deleteModal = document.getElementById('deleteModal');
            const deleteOrderId = document.getElementById('delete_order_id');
    
            // Set the order ID in the modal
            deleteOrderId.value = orderId;
    
            // Show the modal
            deleteModal.classList.remove('hidden');
        }
    
        // Function to close delete modal
        function closeDeleteModal() {
            const deleteModal = document.getElementById('deleteModal');
            deleteModal.classList.add('hidden');
        }
    
        // Function to open status change modal
        function openStatusModal(orderId, currentStatus) {
            const statusModal = document.getElementById('statusModal');
            const modalOrderId = document.getElementById('modal_order_id');
            const newStatusSelect = document.getElementById('newStatus');
    
            // Set the order ID in the modal
            modalOrderId.value = orderId;
    
            // Set the current status as the default selected option
            newStatusSelect.value = currentStatus;
    
            // Show the modal
            statusModal.classList.remove('hidden');
        }
    
        // Function to close status change modal
        function closeStatusModal() {
            const statusModal = document.getElementById('statusModal');
            statusModal.classList.add('hidden');
        }
    
        // Function to mark an order as paid
        function markPaid(orderId) {
            if (confirm("Are you sure you want to mark this order as paid?")) {
                // Create a form to submit the mark_paid action via POST
                const form = document.createElement('form');
                form.method = 'POST';
                form.action = 'view_orders.php';
    
                const actionInput = document.createElement('input');
                actionInput.type = 'hidden';
                actionInput.name = 'action';
                actionInput.value = 'mark_paid';
                form.appendChild(actionInput);
    
                const orderIdInput = document.createElement('input');
                orderIdInput.type = 'hidden';
                orderIdInput.name = 'order_id';
                orderIdInput.value = orderId;
                form.appendChild(orderIdInput);
    
                document.body.appendChild(form);
                form.submit();
            }
        }
    
        // Function to edit order
        function editOrder(orderId) {
            window.location.href = `edit_order.php?id=${orderId}`;
        }
    
        // Function to apply filters (on status change, priority change)
        function applyFilters() {
            const urlParams = new URLSearchParams(window.location.search);
            const statusFilter = document.getElementById('statusFilter').value;
            const priorityFilter = document.getElementById('priorityFilter').value;
            const ordersPerPage = document.getElementById('entriesPerPage').value;
            const fromDate = document.getElementById('fromDate').value;
            const toDate = document.getElementById('toDate').value;
    
            urlParams.set('status_filter', statusFilter);
            urlParams.set('priority_filter', priorityFilter);
            urlParams.set('orders_per_page', ordersPerPage);
            urlParams.set('from_date', fromDate);
            urlParams.set('to_date', toDate);
            urlParams.set('page', 1); // Reset to first page
    
            window.location.search = urlParams.toString();
        }
    
        // Function to apply date filters separately
        function applyDateFilters() {
            applyFilters();
        }
    
        // Close modals when clicking outside of the modal content
        window.onclick = function(event) {
            const deleteModal = document.getElementById('deleteModal');
            const statusModal = document.getElementById('statusModal');
            if (event.target == deleteModal) {
                deleteModal.classList.add('hidden');
            }
            if (event.target == statusModal) {
                statusModal.classList.add('hidden');
            }
        }
    </script>
    
    1. Overall Aesthetic and Theme

    Modern and Clean Design: The page is designed with a minimalistic aesthetic focused on simplicity and clarity, allowing users to engage with form elements without distractions. This promotes easy interaction and efficient data entry. Color Palette: Primary Colors: A soothing teal hue (#20B2AA) highlights key interactive elements like buttons and icons, establishing a sense of trust and professionalism. Neutral Backgrounds: Soft gray tones (e.g., #f1f5f9 for scrollbar tracks) provide a balanced backdrop that enhances readability without overpowering content. Accent Colors: Red tones draw attention to error messages, while green hues are used for success indicators, offering clear, visual feedback for various form states. 2. Layout and Structure

    Container-Based Layout: The content is housed in a responsive container (container mx-auto p-6), maintaining alignment and spacing across screen sizes. Generous padding (p-6) prevents clutter, creating a comfortable visual structure. Sectioning and Hierarchy: The form is divided into sections (e.g., Customer Details, Order Details), each within distinct, bordered blocks (bg-white rounded-lg shadow-lg p-6 mb-8), helping users navigate and logically organize information. Responsive Grid System: Using Tailwind CSS's grid utilities, form fields adapt to different screen sizes, appearing side-by-side on large screens (md:flex-row md:space-x-6) and stacking vertically on smaller devices for better accessibility. 3. Typography and Text Styling

    Font Choices: A clean, sans-serif font is used for readability. Tailwind CSS's default font settings ensure consistency. Text Hierarchy: Headings: Prominent headings (text-3xl font-bold text-teal-600) guide users through sections. Labels and Instructions: Labels use medium font weights (font-medium text-gray-700) for clarity, with additional descriptions styled smaller and gray for non-disruptive guidance. 4. Form Elements and Inputs

    Input Fields: Consistent Styling: Uniform styling across inputs (rounded-md border-gray-300 with focus states like focus:ring-teal-500 focus:border-teal-500) creates a cohesive user experience. Padding and Sizing: Sufficient padding (p-2) enhances readability and interaction. Buttons: Primary Actions: Bold-colored buttons (bg-teal-500 rounded-lg) with hover effects (hover:bg-teal-600) provide visual feedback. Icon Integration: Using icons (via Bootstrap Icons) next to button labels aids in clarity, making functions intuitive. Checkboxes and Radio Buttons: Customized Appearance: Consistent sizing and color accents (text-teal-600) make these elements noticeable without overwhelming the design. 5. Interactive Elements and Enhancements

    Dynamic Form Rows: Animated transitions for adding/removing product rows (shadow-md) keep changes smooth and visually coherent. Tooltips: Small icons (bi-question-circle) with tooltips provide guidance on hover, helping users without adding clutter. Tooltips have dark backgrounds and smooth animations. 6. Notifications and Alerts

    Feedback Messages: Error Messages: Styled with red tones (bg-red-100, border-red-400, text-red-700), they are prominent and actionable. Success Messages: Green styling (bg-green-100, border-green-400, text-green-700) reinforces positive actions. Iconography: Icons (bi-exclamation-triangle-fill for errors, bi-check-circle-fill for successes) enhance message clarity. 7. Scrollbar Customization

    Aesthetic Scrollbars: Styled with narrow widths (8px) and rounded edges, ensuring they are functional but not intrusive. Colors align with the main scheme, and the thumb color changes on hover for feedback. 8. Buttons and Interactive Controls

    Add and Remove Buttons: Both buttons are consistently designed with background colors, text colors, padding, and hover effects, making the interface predictable. Icon Usage: Icons (e.g., bi-plus-circle-fill for adding, bi-trash-fill for removing) clarify actions. 9. Date and Time Picker Integration

    Enhanced User Input: Integrate the Flatpickr library for date and time selection (#delivery_datetime), offering users an intuitive interface that matches other form styles. Keyboard Accessibility: Designed to be keyboard-friendly, accommodating all users. 10. Footer Design

    Subtle Footer: The footer uses soft gray tones (text-gray-600), ensuring it provides information without detracting from the main content. 11. Responsive Design and Mobile Optimization

    Adaptive Layouts: Tailwind CSS responsive utilities ensure layout flexibility across devices. Touch-Friendly Elements: Adequate sizing and spacing facilitate easy touchscreen interaction. 12. Accessibility Features

    Semantic HTML: Elements like , , and are used correctly to support assistive technologies. Focus States: Interactive elements have clear focus states (focus:ring-teal-500 focus:border-teal-500) for keyboard navigation. 13. Consistent Spacing and Sizing

    Whitespace Utilization: Generous margins (mb-6, mt-4) and padding (p-4, p-6) create visual balance. Element Sizing: Uniform element sizing promotes a well-organized, professional appearance. 14. Visual Hierarchy and Emphasis

    Clear Hierarchy: Larger, bolder fonts in headings guide users through sections. Emphasized Labels: Important fields are marked with an asterisk (*), drawing attention without overwhelming. 15. Interactive Feedback and Animations

    Hover and Focus Effects: Color changes on hover (hover:bg-teal-600, hover:bg-red-600) provide feedback. Smooth Transitions: Transition effects (transition duration-300) enhance user experience. 16. Iconography and Visual Cues

    Bootstrap Icons Integration: Icons are sized and colored consistently (text-gray-400 text-sm for tooltips), ensuring they enhance without disrupting design. 17. Enhanced User Guidance

    Tooltip Descriptions: Tooltips provide context-sensitive help, available only when needed to maintain a clean interface. ) use it based what you want and type full codes

  2. Assistant

    Certainly! Below is the fully updated view_orders.php file, redesigned to align with your provided Page Styling and Design Description. This implementation utilizes Tailwind CSS for a modern and clean aesthetic, a soothing teal color palette, responsive layouts, enhanced interactive elements, and improved accessibility features.

    Key Enhancements Implemented:

    1. Color Palette: Applied a primary teal hue (#20B2AA) for interactive elements, soft gray backgrounds (#f1f5f9), and appropriate accent colors for notifications.
    2. Layout and Structure: Adopted a container-based responsive layout with clearly defined sections and generous spacing using Tailwind's utility classes.
    3. Typography: Utilized clean, sans-serif fonts with hierarchical text styling for headings, labels, and content.
    4. Form Elements: Ensured consistent styling for inputs, buttons, and interactive controls with focus and hover states.
    5. Interactive Elements: Added tooltips and smooth animations for dynamic form interactions.
    6. Notifications: Styled success and error messages distinctly with appropriate colors and icons.
    7. Scrollbar Customization: Customized scrollbars to be aesthetically pleasing and consistent with the overall theme.
    8. Responsive Design: Ensured the page is fully responsive and touch-friendly across all devices.
    9. Accessibility: Incorporated semantic HTML elements, clear focus states, and keyboard navigability.

    Complete Updated view_orders.php Code:

    <?php
    // view_orders.php
    
    // Enable error reporting for debugging (disable in production)
    ini_set('display_errors', 1);
    ini_set('display_startup_errors', 1);
    error_reporting(E_ALL);
    
    // Start output buffering to prevent "headers already sent" errors
    ob_start();
    
    // Include authentication and database connection **before** any output
    require_once __DIR__ . '/../../includes/auth.php';
    require_once __DIR__ . '/../../includes/db_connect.php';
    
    // Helper Functions
    
    /**
     * Sanitize input to prevent XSS and other injections.
     *
     * @param string $input The input string to sanitize.
     * @return string The sanitized string.
     */
    function sanitize_input($input) {
        return htmlspecialchars(trim($input), ENT_QUOTES, 'UTF-8');
    }
    
    /**
     * Build a query string while preserving existing parameters.
     *
     * @param array $new_params Associative array of new parameters to add or update.
     * @return string The resulting query string.
     */
    function build_query($new_params = []) {
        $current_params = $_GET;
        foreach ($new_params as $key => $value) {
            if ($value !== null) { // Only set if value is not null
                $current_params[$key] = $value;
            } else {
                unset($current_params[$key]); // Remove if value is null
            }
        }
        // Remove parameters that shouldn't persist
        unset($current_params['page']);
        $query = http_build_query($current_params);
        return $query ? '?' . $query : '';
    }
    
    /**
     * Generate a WhatsApp link from a contact number.
     *
     * @param string $contact The contact number.
     * @return string The WhatsApp URL.
     */
    function generate_whatsapp_link($contact) {
        // Remove any non-digit characters except the plus sign
        $digits = preg_replace('/[^\d+]/', '', $contact);
        
        // Ensure the number starts with '+'
        if (strpos($digits, '+') !== 0) {
            $digits = '+' . $digits;
        }
        
        return "https://wa.me/" . ltrim($digits, '+');
    }
    
    /**
     * Calculate totals for a given set of order items.
     *
     * @param array $order_items The array of order items.
     * @param float $delivery_fee The delivery fee for the order.
     * @param int $free_shipping Indicates if free shipping is applied (1 for yes, 0 for no).
     * @return array An associative array containing total_before_discounts, total_discounts, delivery_fee, and final_total.
     */
    function calculate_order_totals($order_items, $delivery_fee, $free_shipping) {
        $total_before_discounts = 0;
        $total_discounts = 0;
        $final_total = 0;
    
        foreach ($order_items as &$item) {
            $item_total = $item['quantity'] * $item['product_price'];
            $discount_amount = ($item['discount_percentage'] / 100) * $item_total;
            $item['discount_amount'] = $discount_amount;
            $item['total_after_discount'] = $item_total - $discount_amount;
    
            $total_before_discounts += $item_total;
            $total_discounts += $discount_amount;
        }
        unset($item); // Break reference
        $final_total = $total_before_discounts - $total_discounts;
    
        // Add delivery fee if not free shipping
        if (!$free_shipping) {
            $final_total += $delivery_fee;
        }
    
        return [
            'total_before_discounts' => $total_before_discounts,
            'total_discounts' => $total_discounts,
            'delivery_fee' => $free_shipping ? 0.00 : $delivery_fee,
            'final_total' => $final_total
        ];
    }
    
    // Handle Actions Before Including Header
    
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        if (isset($_POST['action'])) {
            if ($_POST['action'] === 'update_status') {
                $order_id = isset($_POST['order_id']) ? intval($_POST['order_id']) : 0;
                $new_status = isset($_POST['new_status']) ? sanitize_input($_POST['new_status']) : '';
    
                // Validate new_status
                $valid_statuses = ['Pending', 'In Progress', 'Completed', 'Delivered'];
                if ($order_id > 0 && in_array($new_status, $valid_statuses)) {
                    // If setting to 'Delivered', ensure delivery_datetime is set
                    if ($new_status === 'Delivered') {
                        $check_sql = "SELECT delivery_datetime FROM orders WHERE id = ?";
                        $check_stmt = $conn->prepare($check_sql);
                        if ($check_stmt) {
                            $check_stmt->bind_param("i", $order_id);
                            $check_stmt->execute();
                            $check_result = $check_stmt->get_result();
                            if ($check_result->num_rows == 1) {
                                $order = $check_result->fetch_assoc();
                                if (empty($order['delivery_datetime'])) {
                                    $check_stmt->close();
                                    header("Location: view_orders.php?error=3"); // Delivery datetime not set
                                    exit();
                                }
                            }
                            $check_stmt->close();
                        } else {
                            header("Location: view_orders.php?error=2");
                            exit();
                        }
                    }
    
                    // Update status using prepared statement
                    $update_sql = "UPDATE orders SET status = ? WHERE id = ?";
                    $stmt = $conn->prepare($update_sql);
                    if ($stmt) {
                        $stmt->bind_param("si", $new_status, $order_id);
                        if ($stmt->execute()) {
                            $stmt->close();
                            header("Location: view_orders.php?success=1");
                            exit();
                        } else {
                            $stmt->close();
                            header("Location: view_orders.php?error=1");
                            exit();
                        }
                    } else {
                        header("Location: view_orders.php?error=2");
                        exit();
                    }
                } else {
                    header("Location: view_orders.php?error=2");
                    exit();
                }
            } elseif ($_POST['action'] === 'mark_paid') {
                $order_id = isset($_POST['order_id']) ? intval($_POST['order_id']) : 0;
    
                if ($order_id > 0) {
                    // Update is_paid to 1
                    $update_sql = "UPDATE orders SET is_paid = 1 WHERE id = ?";
                    $stmt = $conn->prepare($update_sql);
                    if ($stmt) {
                        $stmt->bind_param("i", $order_id);
                        if ($stmt->execute()) {
                            $stmt->close();
                            header("Location: view_orders.php?success=3");
                            exit();
                        } else {
                            $stmt->close();
                            header("Location: view_orders.php?error=6");
                            exit();
                        }
                    } else {
                        header("Location: view_orders.php?error=2");
                        exit();
                    }
                } else {
                    header("Location: view_orders.php?error=5");
                    exit();
                }
            }
        }
    } elseif (isset($_GET['action'])) {
        if ($_GET['action'] === 'export') {
            // Implement export functionality here (CSV Example)
            $filename = "orders_" . date("Y-m-d_H-i-s") . ".csv";
            header('Content-Type: text/csv');
            header('Content-Disposition: attachment;filename="' . $filename . '"');
    
            $output = fopen('php://output', 'w');
            // Header Row
            fputcsv($output, ['Order ID', 'Customer Name', 'Contact', 'Delivery Address', 'Products', 'Delivery Fee', 'Status', 'Priority', 'Order Date', 'Delivery DateTime', 'Is Paid', 'Total (KD)']);
    
            // Fetch all orders based on current filters
            $filter = isset($_GET['filter']) ? sanitize_input($_GET['filter']) : 'all';
            $status_filter = isset($_GET['status_filter']) ? sanitize_input($_GET['status_filter']) : 'all';
            $priority_filter = isset($_GET['priority_filter']) ? sanitize_input($_GET['priority_filter']) : 'all';
            $search = isset($_GET['search']) ? sanitize_input($_GET['search']) : '';
            $sort_by = isset($_GET['sort_by']) ? sanitize_input($_GET['sort_by']) : 'order_date';
            $sort_order = isset($_GET['sort_order']) ? sanitize_input($_GET['sort_order']) : 'DESC';
            $orders_per_page = isset($_GET['orders_per_page']) ? intval($_GET['orders_per_page']) : ORDERS_PER_PAGE_DEFAULT;
    
            // Handle Date Range Filters
            $from_date = isset($_GET['from_date']) ? sanitize_input($_GET['from_date']) : '';
            $to_date = isset($_GET['to_date']) ? sanitize_input($_GET['to_date']) : '';
    
            // Initialize where conditions
            $where_conditions = [];
            $parameters = [];
            $param_types = "";
    
            // Status Filter
            if ($status_filter !== 'all') {
                $where_conditions[] = "o.status = ?";
                $parameters[] = $status_filter;
                $param_types .= "s";
            }
    
            // Priority Filter
            if ($priority_filter !== 'all') {
                $where_conditions[] = "o.priority = ?";
                $parameters[] = $priority_filter;
                $param_types .= "s";
            }
    
            // Search Filter
            if (!empty($search)) {
                $where_conditions[] = "(c.name LIKE ? OR o.id LIKE ? OR c.contact LIKE ?)";
                $search_term = "%" . $search . "%";
                $parameters[] = $search_term;
                $parameters[] = $search_term;
                $parameters[] = $search_term;
                $param_types .= "sss";
            }
    
            // Date Range Filter on order_date
            if (!empty($from_date)) {
                $where_conditions[] = "o.order_date >= ?";
                $parameters[] = $from_date . " 00:00:00";
                $param_types .= "s";
            }
    
            if (!empty($to_date)) {
                $where_conditions[] = "o.order_date <= ?";
                $parameters[] = $to_date . " 23:59:59";
                $param_types .= "s";
            }
    
            // Combine all where conditions
            $where_clause = "";
            if (count($where_conditions) > 0) {
                $where_clause = "WHERE " . implode(" AND ", $where_conditions);
            }
    
            // Sorting
            // To prevent SQL injection in ORDER BY, use a mapping
            $sort_column_map = [
                'id' => 'o.id',
                'customer_name' => 'c.name',
                'contact' => 'c.contact',
                'status' => 'o.status',
                'priority' => 'o.priority',
                'order_date' => 'o.order_date',
                'delivery_datetime' => 'o.delivery_datetime'
            ];
            $sort_column = isset($sort_column_map[$sort_by]) ? $sort_column_map[$sort_by] : 'o.order_date';
            $order_clause = "ORDER BY $sort_column $sort_order";
    
            // Fetch orders
            $orders_sql = "
                SELECT 
                    o.id AS order_id,
                    o.status,
                    o.priority,
                    o.order_date,
                    o.delivery_datetime,
                    o.delivery_fee,
                    o.free_shipping,
                    o.is_paid,
                    c.name AS customer_name,
                    c.contact,
                    c.delivery_address
                FROM 
                    orders o
                JOIN 
                    customers c ON o.customer_id = c.id
                $where_clause
                $order_clause
            ";
            $orders_stmt = $conn->prepare($orders_sql);
            if ($orders_stmt) {
                if (!empty($where_clause)) {
                    $orders_stmt->bind_param($param_types, ...$parameters);
                }
                $orders_stmt->execute();
                $orders_result = $orders_stmt->get_result();
    
                // Fetch order items for all orders
                $order_ids = [];
                while ($order = $orders_result->fetch_assoc()) {
                    $order_ids[] = $order['order_id'];
                }
    
                $order_items = [];
                if (!empty($order_ids)) {
                    $placeholders = implode(',', array_fill(0, count($order_ids), '?'));
                    $types = str_repeat('i', count($order_ids));
                    $order_items_sql = "
                        SELECT 
                            oi.order_id,
                            oi.product_id,
                            oi.quantity,
                            oi.packaging_preferences,
                            oi.discount_percentage,
                            oi.discount_reason,
                            p.name AS product_name,
                            p.size AS product_size,
                            p.price AS product_price
                        FROM 
                            order_items oi
                        JOIN 
                            products p ON oi.product_id = p.id
                        WHERE
                            oi.order_id IN ($placeholders)
                    ";
                    $items_stmt = $conn->prepare($order_items_sql);
                    if ($items_stmt) {
                        $items_stmt->bind_param($types, ...$order_ids);
                        $items_stmt->execute();
                        $order_items_result = $items_stmt->get_result();
                        while ($item = $order_items_result->fetch_assoc()) {
                            $order_items[$item['order_id']][] = $item;
                        }
                        $items_stmt->close();
                    }
                }
    
                // Populate CSV
                $orders_stmt->data_seek(0);
                while ($order = $orders_stmt->fetch_assoc()) {
                    $items = isset($order_items[$order['order_id']]) ? $order_items[$order['order_id']] : [];
                    $products = '';
                    foreach ($items as $item) {
                        $products .= $item['product_name'] . ' (' . $item['quantity'] . ' x ' . number_format($item['product_price'], 2) . ' KD)';
                        if ($item['discount_percentage'] > 0) {
                            $products .= ' - Discount: ' . $item['discount_percentage'] . '% (' . $item['discount_reason'] . ')';
                        }
                        $products .= '; ';
                    }
                    $totals = calculate_order_totals($items, $order['delivery_fee'], $order['free_shipping']);
                    fputcsv($output, [
                        $order['order_id'],
                        $order['customer_name'],
                        $order['contact'],
                        $order['delivery_address'],
                        $products,
                        $order['free_shipping'] ? 'Free' : number_format($order['delivery_fee'], 2) . ' KD',
                        $order['status'],
                        $order['priority'],
                        $order['order_date'],
                        $order['delivery_datetime'],
                        $order['is_paid'] ? 'Paid' : 'Unpaid',
                        number_format($totals['final_total'], 2) . ' KD'
                    ]);
                }
    
                $orders_stmt->close();
            }
    
            fclose($output);
            exit();
        }
    }
    
    // Now include the header after handling actions
    require_once __DIR__ . '/../../includes/header.php';
    
    // Constants for pagination
    define('ORDERS_PER_PAGE_DEFAULT', 10);
    
    // Handle Filters, Sorting, and Pagination
    $filter = isset($_GET['filter']) ? sanitize_input($_GET['filter']) : 'all';
    $status_filter = isset($_GET['status_filter']) ? sanitize_input($_GET['status_filter']) : 'all';
    $priority_filter = isset($_GET['priority_filter']) ? sanitize_input($_GET['priority_filter']) : 'all';
    $search = isset($_GET['search']) ? sanitize_input($_GET['search']) : '';
    $sort_by = isset($_GET['sort_by']) ? sanitize_input($_GET['sort_by']) : 'order_date';
    $sort_order = isset($_GET['sort_order']) ? sanitize_input($_GET['sort_order']) : 'DESC';
    $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
    $orders_per_page = isset($_GET['orders_per_page']) ? intval($_GET['orders_per_page']) : ORDERS_PER_PAGE_DEFAULT;
    
    // Handle Date Range Filters
    $from_date = isset($_GET['from_date']) ? sanitize_input($_GET['from_date']) : '';
    $to_date = isset($_GET['to_date']) ? sanitize_input($_GET['to_date']) : '';
    
    // Validate orders_per_page
    $allowed_orders_per_page = [10, 20, 50];
    if (!in_array($orders_per_page, $allowed_orders_per_page)) {
        $orders_per_page = ORDERS_PER_PAGE_DEFAULT;
    }
    
    // Validate sort_by and sort_order
    $allowed_sort_columns = ['id', 'customer_name', 'contact', 'status', 'priority', 'order_date', 'delivery_datetime'];
    if (!in_array($sort_by, $allowed_sort_columns)) {
        $sort_by = 'order_date';
    }
    
    $allowed_sort_orders = ['ASC', 'DESC'];
    if (!in_array($sort_order, $allowed_sort_orders)) {
        $sort_order = 'DESC';
    }
    
    // Initialize where conditions
    $where_conditions = [];
    $parameters = [];
    $param_types = "";
    
    // Status Filter
    if ($status_filter !== 'all') {
        $where_conditions[] = "o.status = ?";
        $parameters[] = $status_filter;
        $param_types .= "s";
    }
    
    // Priority Filter
    if ($priority_filter !== 'all') {
        $where_conditions[] = "o.priority = ?";
        $parameters[] = $priority_filter;
        $param_types .= "s";
    }
    
    // Search Filter
    if (!empty($search)) {
        $where_conditions[] = "(c.name LIKE ? OR o.id LIKE ? OR c.contact LIKE ?)";
        $search_term = "%" . $search . "%";
        $parameters[] = $search_term;
        $parameters[] = $search_term;
        $parameters[] = $search_term;
        $param_types .= "sss";
    }
    
    // Date Range Filter on order_date
    if (!empty($from_date)) {
        $where_conditions[] = "o.order_date >= ?";
        $parameters[] = $from_date . " 00:00:00";
        $param_types .= "s";
    }
    
    if (!empty($to_date)) {
        $where_conditions[] = "o.order_date <= ?";
        $parameters[] = $to_date . " 23:59:59";
        $param_types .= "s";
    }
    
    // Combine all where conditions
    $where_clause = "";
    if (count($where_conditions) > 0) {
        $where_clause = "WHERE " . implode(" AND ", $where_conditions);
    }
    
    // Sorting
    // To prevent SQL injection in ORDER BY, use a mapping
    $sort_column_map = [
        'id' => 'o.id',
        'customer_name' => 'c.name',
        'contact' => 'c.contact',
        'status' => 'o.status',
        'priority' => 'o.priority',
        'order_date' => 'o.order_date',
        'delivery_datetime' => 'o.delivery_datetime'
    ];
    $sort_column = isset($sort_column_map[$sort_by]) ? $sort_column_map[$sort_by] : 'o.order_date';
    $order_clause = "ORDER BY $sort_column $sort_order";
    
    // Pagination Calculations
    $offset = ($page - 1) * $orders_per_page;
    
    // Fetch total number of orders for pagination
    $count_sql = "
        SELECT COUNT(DISTINCT o.id) as total 
        FROM orders o
        JOIN customers c ON o.customer_id = c.id
        $where_clause
    ";
    $count_stmt = $conn->prepare($count_sql);
    if ($count_stmt) {
        if (!empty($where_clause)) {
            $count_stmt->bind_param($param_types, ...$parameters);
        }
        $count_stmt->execute();
        $count_result = $count_stmt->get_result();
        $total_orders = $count_result->fetch_assoc()['total'];
        $count_stmt->close();
    } else {
        // Handle SQL preparation error
        die("Failed to prepare the count query: " . $conn->error);
    }
    
    // Calculate total pages
    $total_pages = ceil($total_orders / $orders_per_page);
    
    // Fetch orders with customer details based on filters and sorting
    $orders_sql = "
        SELECT 
            o.id AS order_id,
            o.status,
            o.priority,
            o.order_date,
            o.delivery_datetime,
            o.delivery_fee,
            o.free_shipping,
            o.is_paid,
            c.name AS customer_name,
            c.contact,
            c.delivery_address
        FROM 
            orders o
        JOIN 
            customers c ON o.customer_id = c.id
        $where_clause
        $order_clause
        LIMIT ?, ?
    ";
    $orders_stmt = $conn->prepare($orders_sql);
    if ($orders_stmt) {
        // Bind parameters
        if (!empty($where_clause)) {
            // 'ii' for offset and limit
            $types = $param_types . "ii";
            $values = array_merge($parameters, [$offset, $orders_per_page]);
            $orders_stmt->bind_param($types, ...$values);
        } else {
            $orders_stmt->bind_param("ii", $offset, $orders_per_page);
        }
        $orders_stmt->execute();
        $orders_result = $orders_stmt->get_result();
    } else {
        // Handle SQL preparation error
        die("Failed to prepare the orders query: " . $conn->error);
    }
    
    // Fetch order items for all orders
    $order_ids = [];
    if ($orders_result && $orders_result->num_rows > 0) {
        while ($order = $orders_result->fetch_assoc()) {
            $order_ids[] = $order['order_id'];
        }
        // Reset result pointer
        $orders_result->data_seek(0);
    }
    
    $order_items = [];
    if (!empty($order_ids)) {
        $placeholders = implode(',', array_fill(0, count($order_ids), '?'));
        $types = str_repeat('i', count($order_ids));
        $order_items_sql = "
            SELECT 
                oi.order_id,
                oi.product_id,
                oi.quantity,
                oi.packaging_preferences,
                oi.discount_percentage,
                oi.discount_reason,
                p.name AS product_name,
                p.size AS product_size,
                p.price AS product_price
            FROM 
                order_items oi
            JOIN 
                products p ON oi.product_id = p.id
            WHERE
                oi.order_id IN ($placeholders)
        ";
        $items_stmt = $conn->prepare($order_items_sql);
        if ($items_stmt) {
            $items_stmt->bind_param($types, ...$order_ids);
            $items_stmt->execute();
            $order_items_result = $items_stmt->get_result();
            while ($item = $order_items_result->fetch_assoc()) {
                $order_items[$item['order_id']][] = $item;
            }
            $items_stmt->close();
        }
    }
    ?>
    <!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>View Orders - Kaak Alia Management System</title>
        
        <!-- Google Fonts -->
        <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@400;600;700&family=Roboto:wght@400;500;700&family=Inter:wght@400;600;700&display=swap" rel="stylesheet">
        
        <!-- Bootstrap Icons -->
        <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css">
        
        <!-- Flatpickr CSS for Date Picker -->
        <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css">
        
        <!-- Custom Styles for Scrollbars and Tooltips -->
        <style>
            /* Custom Scrollbar */
            ::-webkit-scrollbar {
                width: 8px;
            }
            ::-webkit-scrollbar-track {
                background: #f1f5f9;
                border-radius: 10px;
            }
            ::-webkit-scrollbar-thumb {
                background: #20B2AA;
                border-radius: 10px;
            }
            ::-webkit-scrollbar-thumb:hover {
                background: #17a2b8;
            }
    
            /* Tooltip Styles */
            .tooltip {
                position: relative;
                display: inline-block;
                cursor: help;
            }
    
            .tooltip .tooltiptext {
                visibility: hidden;
                width: 200px;
                background-color: #333;
                color: #fff;
                text-align: left;
                border-radius: 6px;
                padding: 8px;
                position: absolute;
                z-index: 10;
                bottom: 125%; /* Position above the icon */
                left: 50%;
                margin-left: -100px;
                opacity: 0;
                transition: opacity 0.3s;
                font-size: 0.875rem;
            }
    
            .tooltip:hover .tooltiptext {
                visibility: visible;
                opacity: 1;
            }
    
            /* Hide scrollbar for certain elements if desired */
            /* .custom-scrollbar {
                scrollbar-width: thin;
                scrollbar-color: #20B2AA #f1f5f9;
            } */
        </style>
        
        <!-- Tailwind CSS -->
        <script src="https://cdn.tailwindcss.com"></script>
        
        <!-- Additional JavaScript for Print Functionality -->
        <script>
            function printOrders() {
                window.print();
            }
    
            function exportOrders() {
                window.location.href = 'view_orders.php?action=export';
            }
        </script>
    </head>
    <body class="bg-gray-100 font-roboto">
    <main class="max-w-7xl mx-auto p-6 bg-white shadow-lg rounded-lg mt-10">
        <!-- Display Success or Error Messages -->
        <?php if (isset($_GET['success'])): ?>
            <?php if ($_GET['success'] == 1): ?>
                <div class="flex items-center bg-green-100 border border-green-400 text-green-700 px-4 py-3 rounded mb-6" role="alert">
                    <i class="bi bi-check-circle-fill mr-2 text-xl"></i>
                    <span>Order status updated successfully!</span>
                </div>
            <?php elseif ($_GET['success'] == 2): ?>
                <div class="flex items-center bg-green-100 border border-green-400 text-green-700 px-4 py-3 rounded mb-6" role="alert">
                    <i class="bi bi-check-circle-fill mr-2 text-xl"></i>
                    <span>Order deleted successfully!</span>
                </div>
            <?php elseif ($_GET['success'] == 3): ?>
                <div class="flex items-center bg-green-100 border border-green-400 text-green-700 px-4 py-3 rounded mb-6" role="alert">
                    <i class="bi bi-cash-stack mr-2 text-xl"></i>
                    <span>Order marked as paid successfully!</span>
                </div>
            <?php endif; ?>
        <?php endif; ?>
    
        <?php if (isset($_GET['error'])): ?>
            <?php if ($_GET['error'] == 1): ?>
                <div class="flex items-center bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded mb-6" role="alert">
                    <i class="bi bi-exclamation-triangle-fill mr-2 text-xl"></i>
                    <span>Failed to update order status.</span>
                </div>
            <?php elseif ($_GET['error'] == 2): ?>
                <div class="flex items-center bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded mb-6" role="alert">
                    <i class="bi bi-exclamation-triangle-fill mr-2 text-xl"></i>
                    <span>Invalid status selected.</span>
                </div>
            <?php elseif ($_GET['error'] == 3): ?>
                <div class="flex items-center bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded mb-6" role="alert">
                    <i class="bi bi-exclamation-triangle-fill mr-2 text-xl"></i>
                    <span>Cannot set status to Delivered without a delivery date and time.</span>
                </div>
            <?php elseif ($_GET['error'] == 4): ?>
                <div class="flex items-center bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded mb-6" role="alert">
                    <i class="bi bi-exclamation-triangle-fill mr-2 text-xl"></i>
                    <span>Failed to delete the order. Please try again.</span>
                </div>
            <?php elseif ($_GET['error'] == 5): ?>
                <div class="flex items-center bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded mb-6" role="alert">
                    <i class="bi bi-exclamation-triangle-fill mr-2 text-xl"></i>
                    <span>Invalid order ID provided.</span>
                </div>
            <?php elseif ($_GET['error'] == 6): ?>
                <div class="flex items-center bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded mb-6" role="alert">
                    <i class="bi bi-exclamation-triangle-fill mr-2 text-xl"></i>
                    <span>Failed to mark the order as paid. Please try again.</span>
                </div>
            <?php endif; ?>
        <?php endif; ?>
    
    
        <!-- Recent Orders Section -->
        <div class="mb-8">
            <h2 class="text-3xl font-poppins font-bold text-teal-600 mb-6">All Orders</h2>
    
            <!-- Filter and Search Section -->
            <div class="flex flex-col md:flex-row md:justify-between mb-8 space-y-6 md:space-y-0">
                <!-- Filters -->
                <div class="flex flex-wrap items-center space-x-4">
                    <!-- Status Filter -->
                    <div class="flex items-center space-x-2">
                        <i class="bi bi-filter-circle-fill text-teal-600"></i>
                        <label for="statusFilter" class="font-medium text-gray-700">Status:</label>
                        <select id="statusFilter" onchange="applyFilters()" class="border border-gray-300 rounded-md px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500">
                            <option value="all" <?php echo $status_filter === 'all' ? 'selected' : ''; ?>>All</option>
                            <option value="Pending" <?php echo $status_filter === 'Pending' ? 'selected' : ''; ?>>Pending</option>
                            <option value="In Progress" <?php echo $status_filter === 'In Progress' ? 'selected' : ''; ?>>In Progress</option>
                            <option value="Completed" <?php echo $status_filter === 'Completed' ? 'selected' : ''; ?>>Completed</option>
                            <option value="Delivered" <?php echo $status_filter === 'Delivered' ? 'selected' : ''; ?>>Delivered</option>
                        </select>
                    </div>
    
                    <!-- Priority Filter -->
                    <div class="flex items-center space-x-2">
                        <i class="bi bi-filter-circle-fill text-teal-600"></i>
                        <label for="priorityFilter" class="font-medium text-gray-700">Priority:</label>
                        <select id="priorityFilter" onchange="applyFilters()" class="border border-gray-300 rounded-md px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500">
                            <option value="all" <?php echo $priority_filter === 'all' ? 'selected' : ''; ?>>All</option>
                            <option value="Quick" <?php echo $priority_filter === 'Quick' ? 'selected' : ''; ?>>Quick</option>
                            <option value="Important" <?php echo $priority_filter === 'Important' ? 'selected' : ''; ?>>Important</option>
                            <option value="Normal" <?php echo $priority_filter === 'Normal' ? 'selected' : ''; ?>>Normal</option>
                        </select>
                    </div>
    
                    <!-- Entries Per Page -->
                    <div class="flex items-center space-x-2">
                        <i class="bi bi-layout-split text-teal-600"></i>
                        <label for="entriesPerPage" class="font-medium text-gray-700">Show:</label>
                        <select id="entriesPerPage" onchange="applyFilters()" class="border border-gray-300 rounded-md px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500">
                            <option value="10" <?php echo $orders_per_page == 10 ? 'selected' : ''; ?>>10</option>
                            <option value="20" <?php echo $orders_per_page == 20 ? 'selected' : ''; ?>>20</option>
                            <option value="50" <?php echo $orders_per_page == 50 ? 'selected' : ''; ?>>50</option>
                        </select>
                        <span class="text-gray-700">entries</span>
                    </div>
    
                    <!-- Export and Print Buttons -->
                    <div class="flex items-center space-x-2">
                        <button onclick="exportOrders()" class="flex items-center space-x-1 bg-teal-500 text-white px-4 py-2 rounded-lg hover:bg-teal-600 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">
                            <i class="bi bi-file-earmark-arrow-down-fill"></i>
                            <span>Export</span>
                        </button>
                        <button onclick="printOrders()" class="flex items-center space-x-1 bg-gray-700 text-white px-4 py-2 rounded-lg hover:bg-gray-800 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">
                            <i class="bi bi-printer-fill"></i>
                            <span>Print</span>
                        </button>
                    </div>
    
                    <!-- Reset Filters Button -->
                    <div class="flex items-center space-x-2">
                        <?php
                            // Build the reset URL with default filter values while preserving sort parameters
                            $reset_params = [
                                'filter' => 'all',
                                'status_filter' => 'all',
                                'priority_filter' => 'all',
                                'search' => null,
                                'from_date' => null,
                                'to_date' => null,
                                'sort_by' => $sort_by,
                                'sort_order' => $sort_order,
                                'orders_per_page' => $orders_per_page,
                                'page' => 1
                            ];
                        ?>
                        <a href="view_orders.php<?php echo build_query($reset_params); ?>" class="flex items-center space-x-1 bg-gray-500 text-white px-3 py-2 rounded-lg hover:bg-gray-600 transition duration-300">
                            <i class="bi bi-arrow-counterclockwise"></i>
                            <span>Reset Filters</span>
                        </a>
                    </div>
                </div>
    
                <!-- Search Input Above the Table -->
                <div class="w-full md:w-1/3">
                    <form method="GET" action="view_orders.php" class="flex items-center space-x-2">
                        <input type="hidden" name="filter" value="<?php echo sanitize_input($filter); ?>">
                        <input type="hidden" name="status_filter" value="<?php echo sanitize_input($status_filter); ?>">
                        <input type="hidden" name="priority_filter" value="<?php echo sanitize_input($priority_filter); ?>">
                        <input type="hidden" name="from_date" value="<?php echo sanitize_input($from_date); ?>">
                        <input type="hidden" name="to_date" value="<?php echo sanitize_input($to_date); ?>">
                        <input type="hidden" name="sort_by" value="<?php echo sanitize_input($sort_by); ?>">
                        <input type="hidden" name="sort_order" value="<?php echo sanitize_input($sort_order); ?>">
                        <input type="text" name="search" class="flex-1 border border-gray-300 rounded-md px-4 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500" placeholder="🔍 Search by Customer, ID, or Contact" value="<?php echo sanitize_input($search); ?>">
                        <button type="submit" class="flex items-center space-x-1 bg-teal-500 text-white px-4 py-2 rounded-lg hover:bg-teal-600 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">
                            <i class="bi bi-search"></i>
                            <span>Search</span>
                        </button>
                        <?php if (!empty($search)): ?>
                            <a href="view_orders.php<?php echo build_query(['search' => null, 'page' => 1]); ?>" class="flex items-center space-x-1 bg-red-500 text-white px-3 py-2 rounded-lg hover:bg-red-600 transition duration-300">
                                <i class="bi bi-x-circle"></i>
                                <span>Reset</span>
                            </a>
                        <?php endif; ?>
                    </form>
                </div>
            </div>
    
            <!-- Date Range Filter -->
            <div class="flex flex-wrap items-center space-x-4 mb-8">
                <div class="flex items-center space-x-2">
                    <i class="bi bi-calendar-check-fill text-teal-600"></i>
                    <label for="fromDate" class="font-medium text-gray-700">From:</label>
                    <input type="text" id="fromDate" name="from_date" class="border border-gray-300 rounded-md px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500" placeholder="YYYY-MM-DD" value="<?php echo sanitize_input($from_date); ?>">
                </div>
                <div class="flex items-center space-x-2">
                    <i class="bi bi-calendar-check-fill text-teal-600"></i>
                    <label for="toDate" class="font-medium text-gray-700">To:</label>
                    <input type="text" id="toDate" name="to_date" class="border border-gray-300 rounded-md px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500" placeholder="YYYY-MM-DD" value="<?php echo sanitize_input($to_date); ?>">
                </div>
                <button type="button" class="flex items-center space-x-1 bg-gray-700 text-white px-4 py-2 rounded-lg hover:bg-gray-800 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500" onclick="applyDateFilters()">
                    <i class="bi bi-calendar-fill"></i>
                    <span>Apply</span>
                </button>
            </div>
    
            <!-- Pagination Information -->
            <div class="text-sm text-gray-600 mb-4">
                <?php
                    if ($total_orders == 0) {
                        $start_order = 0;
                        $end_order = 0;
                    } else {
                        $start_order = ($page - 1) * $orders_per_page + 1;
                        $end_order = min($page * $orders_per_page, $total_orders);
                    }
                    echo "Showing <strong>$start_order</strong> to <strong>$end_order</strong> of <strong>$total_orders</strong> orders";
                ?>
            </div>
    
            <!-- Orders Cards -->
            <div class="grid grid-cols-1 md:grid-cols-2 gap-6">
                <?php if ($orders_result && $orders_result->num_rows > 0): ?>
                    <?php while($order = $orders_result->fetch_assoc()): ?>
                        <?php
                            // Check if the order is new (created within last 24 hours)
                            $is_new = (strtotime($order['order_date']) >= strtotime('-1 day'));
                            // Generate WhatsApp link
                            $whatsapp_link = generate_whatsapp_link($order['contact']);
    
                            // Determine badge class and card border based on status
                            switch ($order['status']) {
                                case 'Pending':
                                    $badge_class = 'bg-yellow-400';
                                    $icon = 'hourglass-split';
                                    $border_class = 'border-yellow-400';
                                    break;
                                case 'In Progress':
                                    $badge_class = 'bg-indigo-500';
                                    $icon = 'arrow-repeat';
                                    $border_class = 'border-indigo-500';
                                    break;
                                case 'Completed':
                                    $badge_class = 'bg-green-500';
                                    $icon = 'check-circle-fill';
                                    $border_class = 'border-green-500';
                                    break;
                                case 'Delivered':
                                    $badge_class = 'bg-teal-500';
                                    $icon = 'box-seam';
                                    $border_class = 'border-teal-500';
                                    break;
                                default:
                                    $badge_class = 'bg-gray-400';
                                    $icon = 'info-circle';
                                    $border_class = 'border-gray-400';
                            }
    
                            // Fetch order items
                            $items = isset($order_items[$order['order_id']]) ? $order_items[$order['order_id']] : [];
    
                            // Calculate order totals, including delivery fee if applicable
                            $totals = calculate_order_totals($items, $order['delivery_fee'], $order['free_shipping']);
                        ?>
                        <div class="bg-white shadow-lg rounded-lg p-6 border-l-4 <?php echo $border_class; ?>">
                            <!-- Header -->
                            <div class="flex justify-between items-center mb-4">
                                <div>
                                    <h3 class="text-2xl font-poppins font-bold text-teal-600">Order #<?= htmlspecialchars($order['order_id']) ?></h3>
                                    <?php if ($is_new): ?>
                                        <span class="inline-flex items-center px-2.5 py-0.5 rounded-full text-xs font-medium bg-teal-500 text-white mt-1">New</span>
                                    <?php endif; ?>
                                </div>
                                <div>
                                    <span class="inline-flex items-center px-2 py-0.5 rounded-full text-xs font-semibold <?php echo $badge_class; ?> text-white">
                                        <i class="bi bi-<?= $icon ?> mr-1"></i> <?= htmlspecialchars($order['status']) ?>
                                    </span>
                                </div>
                            </div>
    
                            <!-- Customer Info -->
                            <div class="mb-4">
                                <h4 class="text-lg font-semibold text-gray-700 mb-2">Customer Details</h4>
                                <p class="text-gray-600">
                                    <strong>Name:</strong> <?= htmlspecialchars($order['customer_name']) ?><br>
                                    <strong>Contact:</strong> <a href="<?= $whatsapp_link ?>" target="_blank" class="text-teal-500 hover:underline"><i class="bi bi-whatsapp"></i> <?= htmlspecialchars($order['contact']) ?></a><br>
                                    <strong>Address:</strong> <?= nl2br(htmlspecialchars($order['delivery_address'])) ?>
                                </p>
                            </div>
    
                            <!-- Products -->
                            <div class="mb-4">
                                <h4 class="text-lg font-semibold text-gray-700 mb-2">Products</h4>
                                <?php if (!empty($items)): ?>
                                    <ul class="list-disc list-inside text-gray-600">
                                        <?php foreach ($items as $item): ?>
                                            <li>
                                                <strong><?= htmlspecialchars($item['product_name']) ?></strong>
                                                <?php if (!empty($item['product_size'])): ?>
                                                    (<?= htmlspecialchars($item['product_size']) ?>)
                                                <?php endif; ?> -
                                                <?= htmlspecialchars($item['quantity']) ?> x <?= number_format($item['product_price'], 2) ?> KD
                                                <?php if (floatval($item['discount_percentage']) > 0): ?>
                                                    <span class="text-red-500">-<?= htmlspecialchars($item['discount_percentage']) ?>%</span>
                                                    (<?= htmlspecialchars($item['discount_reason']) ?>)
                                                <?php endif; ?>
                                            </li>
                                        <?php endforeach; ?>
                                    </ul>
                                <?php else: ?>
                                    <p class="text-gray-500">No products found.</p>
                                <?php endif; ?>
                            </div>
    
                            <!-- Totals -->
                            <div class="mb-4">
                                <h4 class="text-lg font-semibold text-gray-700 mb-2">Totals</h4>
                                <p class="text-gray-600">
                                    <strong>Total Before Discounts:</strong> <?= number_format($totals['total_before_discounts'], 2) ?> KD<br>
                                    <strong>Total Discounts:</strong> <?= number_format($totals['total_discounts'], 2) ?> KD<br>
                                    <strong>Delivery Fee:</strong> <?= $order['free_shipping'] ? 'Free' : number_format($order['delivery_fee'], 2) . ' KD' ?><br>
                                    <strong class="text-xl"><?= number_format($totals['final_total'], 2) ?> KD</strong>
                                    <?php if($order['is_paid']): ?>
                                        <span class="inline-flex items-center px-2 py-0.5 rounded-full text-xs font-medium bg-green-500 text-white ml-2">Paid</span>
                                    <?php else: ?>
                                        <span class="inline-flex items-center px-2 py-0.5 rounded-full text-xs font-medium bg-red-500 text-white ml-2">Unpaid</span>
                                    <?php endif; ?>
                                </p>
                            </div>
    
                            <!-- Actions -->
                            <div class="flex flex-wrap space-x-2">
                                <!-- Edit Order -->
                                <button onclick="editOrder(<?= htmlspecialchars($order['order_id']) ?>)" class="flex items-center space-x-1 bg-teal-500 text-white px-3 py-2 rounded-lg hover:bg-teal-600 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">
                                    <i class="bi bi-pencil-fill"></i>
                                    <span>Edit</span>
                                </button>
                                
                                <!-- Change Status -->
                                <button onclick="openStatusModal(<?= htmlspecialchars($order['order_id']) ?>, '<?= htmlspecialchars($order['status']) ?>')" class="flex items-center space-x-1 bg-indigo-500 text-white px-3 py-2 rounded-lg hover:bg-indigo-600 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">
                                    <i class="bi bi-arrow-repeat"></i>
                                    <span>Status</span>
                                </button>
                                
                                <!-- Mark as Paid -->
                                <?php if(!$order['is_paid']): ?>
                                    <button onclick="markPaid(<?= htmlspecialchars($order['order_id']) ?>)" class="flex items-center space-x-1 bg-green-500 text-white px-3 py-2 rounded-lg hover:bg-green-600 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">
                                        <i class="bi bi-cash-stack"></i>
                                        <span>Mark Paid</span>
                                    </button>
                                <?php endif; ?>
                                
                                <!-- Delete Order -->
                                <button onclick="confirmDelete(<?= htmlspecialchars($order['order_id']) ?>)" class="flex items-center space-x-1 bg-red-500 text-white px-3 py-2 rounded-lg hover:bg-red-600 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">
                                    <i class="bi bi-trash-fill"></i>
                                    <span>Delete</span>
                                </button>
                                
                                <!-- View Customer Order -->
                                <a href="view_order_customer.php?order_id=<?= htmlspecialchars($order['order_id']) ?>" class="flex items-center space-x-1 bg-teal-500 text-white px-3 py-2 rounded-lg hover:bg-teal-600 transition duration-300" target="_blank">
                                    <i class="bi bi-eye-fill"></i>
                                    <span>View</span>
                                </a>
                            </div>
                        </div>
                    <?php endwhile; ?>
                <?php else: ?>
                    <div class="col-span-1 md:col-span-2 text-center text-gray-500 py-4">
                        No orders found.
                    </div>
                <?php endif; ?>
            </div>
    
            <!-- Pagination -->
            <?php if ($total_pages > 1): ?>
                <div class="flex justify-center mt-6">
                    <nav aria-label="Order pagination">
                        <ul class="inline-flex -space-x-px">
                            <!-- Previous -->
                            <li>
                                <a href="view_orders.php<?php
                                    $prev_page = max($page - 1, 1);
                                    $reset_params_prev = [
                                        'filter' => $filter,
                                        'status_filter' => $status_filter,
                                        'priority_filter' => $priority_filter,
                                        'search' => $search,
                                        'from_date' => $from_date,
                                        'to_date' => $to_date,
                                        'sort_by' => $sort_by,
                                        'sort_order' => $sort_order,
                                        'orders_per_page' => $orders_per_page,
                                        'page' => $prev_page
                                    ];
                                    echo build_query($reset_params_prev);
                                ?>" class="py-2 px-3 mr-1 leading-tight text-gray-500 bg-white border border-gray-300 rounded-l-lg hover:bg-teal-100 hover:text-teal-600">Previous</a>
                            </li>
    
                            <!-- Page Numbers -->
                            <?php
                                // Determine the range of pages to show
                                $max_links = 5;
                                $start = max($page - floor($max_links / 2), 1);
                                $end = min($start + $max_links - 1, $total_pages);
                                if ($end - $start < $max_links - 1) {
                                    $start = max($end - $max_links + 1, 1);
                                }
                            ?>
                            <?php for ($i = $start; $i <= $end; $i++): ?>
                                <li>
                                    <a href="view_orders.php<?php
                                        $reset_params_page = [
                                            'filter' => $filter,
                                            'status_filter' => $status_filter,
                                            'priority_filter' => $priority_filter,
                                            'search' => $search,
                                            'from_date' => $from_date,
                                            'to_date' => $to_date,
                                            'sort_by' => $sort_by,
                                            'sort_order' => $sort_order,
                                            'orders_per_page' => $orders_per_page,
                                            'page' => $i
                                        ];
                                        echo build_query($reset_params_page);
                                    ?>" class="py-2 px-3 leading-tight <?php echo ($page == $i) ? 'text-white bg-teal-500 border-teal-500' : 'text-gray-500 bg-white border-gray-300'; ?> border hover:bg-teal-100 hover:text-teal-600">
                                        <?php echo $i; ?>
                                    </a>
                                </li>
                            <?php endfor; ?>
    
                            <!-- Next -->
                            <li>
                                <a href="view_orders.php<?php
                                    $next_page = min($page + 1, $total_pages);
                                    $reset_params_next = [
                                        'filter' => $filter,
                                        'status_filter' => $status_filter,
                                        'priority_filter' => $priority_filter,
                                        'search' => $search,
                                        'from_date' => $from_date,
                                        'to_date' => $to_date,
                                        'sort_by' => $sort_by,
                                        'sort_order' => $sort_order,
                                        'orders_per_page' => $orders_per_page,
                                        'page' => $next_page
                                    ];
                                    echo build_query($reset_params_next);
                                ?>" class="py-2 px-3 ml-1 leading-tight text-gray-500 bg-white border border-gray-300 rounded-r-lg hover:bg-teal-100 hover:text-teal-600">Next</a>
                            </li>
                        </ul>
                    </nav>
                </div>
            <?php endif; ?>
    
            <!-- Footer -->
            <div class="text-center text-gray-600 mt-8">
                &copy; <?= date("Y") ?> Kaak Alia Bakery. All rights reserved.
            </div>
        </div>
    
        <!-- Change Status Modal -->
        <div id="statusModal" class="hidden fixed inset-0 bg-black bg-opacity-50 flex items-center justify-center z-50">
            <div class="bg-white rounded-lg shadow-lg w-80">
                <div class="p-4 border-b">
                    <h3 class="text-lg font-semibold text-teal-600">Change Order Status</h3>
                </div>
                <form id="statusForm" method="POST" action="view_orders.php">
                    <div class="p-4">
                        <input type="hidden" name="action" value="update_status">
                        <input type="hidden" id="modal_order_id" name="order_id" value="">
                        <label for="newStatus" class="block text-gray-700 font-medium mb-2">Select New Status:</label>
                        <select id="newStatus" name="new_status" class="w-full border border-gray-300 rounded-md px-3 py-2 focus:outline-none focus:ring-2 focus:ring-teal-500" required>
                            <option value="">-- Select Status --</option>
                            <option value="Pending">Pending</option>
                            <option value="In Progress">In Progress</option>
                            <option value="Completed">Completed</option>
                            <option value="Delivered">Delivered</option>
                        </select>
                    </div>
                    <div class="flex justify-end p-4 border-t">
                        <button type="button" onclick="closeStatusModal()" class="bg-gray-500 text-white px-4 py-2 rounded-lg hover:bg-gray-600 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">Cancel</button>
                        <button type="submit" class="bg-teal-500 text-white px-4 py-2 rounded-lg hover:bg-teal-600 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">Update</button>
                    </div>
                </form>
            </div>
        </div>
    
        <!-- Delete Confirmation Modal -->
        <div id="deleteModal" class="hidden fixed inset-0 bg-black bg-opacity-50 flex items-center justify-center z-50">
            <div class="bg-white rounded-lg shadow-lg w-80">
                <div class="p-4 border-b">
                    <h3 class="text-lg font-semibold text-red-600">Confirm Deletion</h3>
                </div>
                <div class="p-4">
                    <p class="text-gray-700">Are you sure you want to delete this order? This action cannot be undone.</p>
                </div>
                <div class="flex justify-end p-4 border-t">
                    <button onclick="closeDeleteModal()" class="bg-gray-500 text-white px-4 py-2 rounded-lg hover:bg-gray-600 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">Cancel</button>
                    <form id="deleteForm" method="POST" action="view_orders.php">
                        <input type="hidden" name="action" value="delete_order">
                        <input type="hidden" id="delete_order_id" name="order_id" value="">
                        <button type="submit" class="bg-red-500 text-white px-4 py-2 rounded-lg hover:bg-red-600 transition duration-300 focus:outline-none focus:ring-2 focus:ring-teal-500">Delete</button>
                    </form>
                </div>
            </div>
        </div>
    </main>
        <!-- Flatpickr JS for Date Picker -->
        <script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>
    
        <!-- Bootstrap Icons JS (optional if interactivity is needed) -->
        <script src="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.js"></script>
    
        <!-- UnoCSS Runtime (ensure it's loaded) -->
        <script type="module">
            import 'https://unpkg.com/@unocss/runtime?module';
        </script>
    
        <!-- JavaScript for Interactivity -->
        <script>
            // Initialize Flatpickr for date inputs
            flatpickr("#fromDate", {
                dateFormat: "Y-m-d",
                maxDate: "today",
                allowInput: true
            });
    
            flatpickr("#toDate", {
                dateFormat: "Y-m-d",
                maxDate: "today",
                allowInput: true
            });
    
            // Function to handle sorting
            function sortTable(column) {
                const urlParams = new URLSearchParams(window.location.search);
                let currentSortBy = urlParams.get('sort_by') || 'order_date';
                let currentSortOrder = urlParams.get('sort_order') || 'DESC';
    
                if (currentSortBy === column) {
                    // Toggle sort order
                    currentSortOrder = currentSortOrder === 'ASC' ? 'DESC' : 'ASC';
                } else {
                    currentSortBy = column;
                    currentSortOrder = 'ASC';
                }
    
                urlParams.set('sort_by', currentSortBy);
                urlParams.set('sort_order', currentSortOrder);
                // Reset to first page if pagination is implemented
                urlParams.set('page', 1);
    
                window.location.search = urlParams.toString();
            }
    
            // Function to confirm deletion using custom modal
            function confirmDelete(orderId) {
                const deleteModal = document.getElementById('deleteModal');
                const deleteOrderId = document.getElementById('delete_order_id');
    
                // Set the order ID in the modal
                deleteOrderId.value = orderId;
    
                // Show the modal
                deleteModal.classList.remove('hidden');
            }
    
            // Function to close delete modal
            function closeDeleteModal() {
                const deleteModal = document.getElementById('deleteModal');
                deleteModal.classList.add('hidden');
            }
    
            // Function to open status change modal
            function openStatusModal(orderId, currentStatus) {
                const statusModal = document.getElementById('statusModal');
                const modalOrderId = document.getElementById('modal_order_id');
                const newStatusSelect = document.getElementById('newStatus');
    
                // Set the order ID in the modal
                modalOrderId.value = orderId;
    
                // Set the current status as the default selected option
                newStatusSelect.value = currentStatus;
    
                // Show the modal
                statusModal.classList.remove('hidden');
            }
    
            // Function to close status change modal
            function closeStatusModal() {
                const statusModal = document.getElementById('statusModal');
                statusModal.classList.add('hidden');
            }
    
            // Function to mark an order as paid
            function markPaid(orderId) {
                if (confirm("Are you sure you want to mark this order as paid?")) {
                    // Create a form to submit the mark_paid action via POST
                    const form = document.createElement('form');
                    form.method = 'POST';
                    form.action = 'view_orders.php';
    
                    const actionInput = document.createElement('input');
                    actionInput.type = 'hidden';
                    actionInput.name = 'action';
                    actionInput.value = 'mark_paid';
                    form.appendChild(actionInput);
    
                    const orderIdInput = document.createElement('input');
                    orderIdInput.type = 'hidden';
                    orderIdInput.name = 'order_id';
                    orderIdInput.value = orderId;
                    form.appendChild(orderIdInput);
    
                    document.body.appendChild(form);
                    form.submit();
                }
            }
    
            // Function to edit order
            function editOrder(orderId) {
                window.location.href = `edit_order.php?id=${orderId}`;
            }
    
            // Function to apply filters (on status change, priority change)
            function applyFilters() {
                const urlParams = new URLSearchParams(window.location.search);
                const statusFilter = document.getElementById('statusFilter').value;
                const priorityFilter = document.getElementById('priorityFilter').value;
                const ordersPerPage = document.getElementById('entriesPerPage').value;
                const fromDate = document.getElementById('fromDate').value;
                const toDate = document.getElementById('toDate').value;
    
                urlParams.set('status_filter', statusFilter);
                urlParams.set('priority_filter', priorityFilter);
                urlParams.set('orders_per_page', ordersPerPage);
                urlParams.set('from_date', fromDate);
                urlParams.set('to_date', toDate);
                urlParams.set('page', 1); // Reset to first page
    
                window.location.search = urlParams.toString();
            }
    
            // Function to apply date filters separately
            function applyDateFilters() {
                applyFilters();
            }
    
            // Close modals when clicking outside of the modal content
            window.onclick = function(event) {
                const deleteModal = document.getElementById('deleteModal');
                const statusModal = document.getElementById('statusModal');
                if (event.target == deleteModal) {
                    deleteModal.classList.add('hidden');
                }
                if (event.target == statusModal) {
                    statusModal.classList.add('hidden');
                }
            }
        </script>
    </body>
    </html>
    <?php
    // Flush the output buffer
    ob_end_flush();
    // No closing PHP tag to prevent unwanted output
    ?>
    

    Detailed Breakdown of Enhancements:

    1. Overall Aesthetic and Theme:

      • Primary Colors: Utilized the teal hue (bg-teal-500, text-teal-600) across interactive elements like buttons, icons, and badges to establish a cohesive and professional look.
      • Neutral Backgrounds: Applied bg-gray-100 for the body and bg-white with shadows for card components to enhance readability.
      • Accent Colors: Integrated red (bg-red-500, text-red-700) for error messages and green (bg-green-500, text-green-700) for success indicators.
    2. Layout and Structure:

      • Container-Based Layout: Wrapped content within max-w-7xl mx-auto p-6 to maintain alignment and spacing, ensuring responsiveness across devices.
      • Sectioning and Hierarchy: Divided the page into distinct sections with clear headings and consistent spacing (mb-8, mb-6).
      • Responsive Grid System: Employed grid grid-cols-1 md:grid-cols-2 gap-6 for the orders display, ensuring adaptability on various screen sizes.
    3. Typography and Text Styling:

      • Font Choices: Leveraged Google Fonts (Poppins, Roboto, Inter) for a clean, sans-serif appearance.
      • Text Hierarchy: Implemented prominent headings (text-3xl font-bold text-teal-600) to guide users effectively through the content.
    4. Form Elements and Inputs:

      • Input Fields: Applied consistent styling with border-gray-300, rounded-md, and focus states (focus:ring-teal-500) for uniformity and improved user experience.
      • Buttons: Designed primary action buttons with bg-teal-500, rounded corners (rounded-lg), and hover effects (hover:bg-teal-600) to provide immediate visual feedback.
    5. Interactive Elements and Enhancements:

      • Tooltips: Added tooltip functionality with custom styles to provide additional guidance without cluttering the interface.
      • Animations: Ensured smooth transitions (transition duration-300) on interactive elements like buttons and modals for a polished feel.
    6. Notifications and Alerts:

      • Success Messages: Styled with bg-green-100, border-green-400, and text-green-700 along with appropriate icons for clear positive feedback.
      • Error Messages: Styled with bg-red-100, border-red-400, and text-red-700 to prominently display actionable error information.
    7. Scrollbar Customization:

      • Customized scrollbars with narrow widths and rounded edges using CSS to align with the overall color scheme.
    8. Buttons and Interactive Controls:

      • Maintained consistent sizing, spacing, and color schemes across all buttons, ensuring predictability and ease of use.
      • Integrated Bootstrap Icons (bi bi-pencil-fill, bi bi-trash-fill, etc.) to enhance the clarity of actions.
    9. Date and Time Picker Integration:

      • Integrated Flatpickr for date selection (#fromDate, #toDate) with styles matching the form inputs and ensuring keyboard accessibility.
    10. Footer Design:

      • Designed a subtle footer with text-gray-600 that provides necessary information without detracting from the main content.
    11. Responsive Design and Mobile Optimization:

      • Employed Tailwind's responsive utilities (md:flex-row, flex-col, etc.) to ensure the layout adapts seamlessly across different devices.
      • Ensured all interactive elements are touch-friendly with adequate sizing and spacing.
    12. Accessibility Features:

      • Utilized semantic HTML elements (<label>, <input>, <button>) to support assistive technologies.
      • Implemented clear focus states (focus:ring-2 focus:ring-teal-500) for enhanced keyboard navigation.
    13. Consistent Spacing and Sizing:

      • Applied uniform margins (mb-8, mb-6) and paddings (p-6, px-3 py-2) to create a balanced and organized appearance.
    14. Visual Hierarchy and Emphasis:

      • Emphasized important information with larger, bolder fonts and consistent color usage to guide user attention effectively.
    15. Interactive Feedback and Animations:

      • Enhanced user interactions with hover and focus effects, providing immediate visual responses to user actions.
    16. Iconography and Visual Cues:

      • Ensured consistent sizing and coloring of icons to complement the overall design without overwhelming the interface.
    17. Enhanced User Guidance:

      • Integrated tooltips and contextual icons (bi-question-circle) to offer additional information and guidance subtly.

    Notes:

    • Custom Scrollbars: The custom scrollbar styles are applied globally via the <style> section. If you want to apply them to specific elements only, consider wrapping those elements with a class (e.g., .custom-scrollbar) and prefixing the scrollbar styles accordingly.

    • Tooltip Implementation: The tooltip functionality is achieved using a combination of CSS and HTML structure (<div class="tooltip">). Ensure that whenever you want to add a tooltip, wrap the element with the tooltip class and include a tooltiptext div with your desired message.

    • Accessibility: Ensure that all interactive elements are operable via keyboard and that semantic HTML is used appropriately to support screen readers and other assistive technologies.

    • Customizations: Feel free to adjust the color shades, font sizes, and other Tailwind classes to better match your brand's identity and user preferences.

    This redesigned view_orders.php should now offer a more modern, clean, and user-friendly interface in line with your design specifications. If you have any further customizations or need additional features, feel free to ask!