in this codes (<?php // vieworders.php // Enable error reporting for debugging (disable…
- 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 = new_params as value) { if (value !== null) { // Only set if value is not null current_params[value; } else { unset(key]); // Remove if value is null } } // Remove parameters that shouldn't persist unset(query = http_build_query(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(delivery_fee, free_shipping) { total_before_discounts = 0; final_total = 0;
foreach (order_items as &item) { item['quantity'] * discount_amount = (item_total; discount_amount; item_total - $discount_amount;
$total_before_discounts += $item_total; $total_discounts += $discount_amount;} unset(final_total = total_discounts;
// Add delivery fee if not free shipping if (!free_shipping) { final_total += $delivery_fee; }
return [ 'total_before_discounts' => total_discounts, 'delivery_fee' => 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']) : 0; _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 . '"');
$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 _GET['filter']) ? sanitize_input(status_filter = isset(_GET['status_filter']) : 'all'; _GET['priority_filter']) ? sanitize_input(search = isset(_GET['search']) : ''; _GET['sort_by']) ? sanitize_input(sort_order = isset(_GET['sort_order']) : 'DESC'; _GET['page']) ? intval(orders_per_page = isset(_GET['orders_per_page']) : ORDERS_PER_PAGE_DEFAULT;
// Handle Date Range Filters _GET['from_date']) ? sanitize_input(to_date = isset(_GET['to_date']) : '';
// Validate orders_per_page orders_per_page, allowed_orders_per_page)) { orders_per_page = ORDERS_PER_PAGE_DEFAULT; }
// Validate sort_by and sort_order sort_by, allowed_sort_columns)) { sort_by = 'order_date'; }
sort_order, allowed_sort_orders)) { sort_order = 'DESC'; }
// Initialize where conditions parameters = []; $param_types = "";
// Status Filter if (status_filter !== 'all') { where_conditions[] = "o.status = ?"; status_filter; $param_types .= "s"; }
// Priority Filter if (priority_filter !== 'all') { where_conditions[] = "o.priority = ?"; priority_filter; $param_types .= "s"; }
// Search Filter if (!empty(search)) { where_conditions[] = "(c.name LIKE ? OR o.id LIKE ? OR c.contact LIKE ?)"; search . "%"; search_term; search_term; search_term; $param_types .= "sss"; }
// Date Range Filter on order_date if (!empty(from_date)) { where_conditions[] = "o.order_date >= ?"; from_date . " 00:00:00"; $param_types .= "s"; }
if (!empty(to_date)) { where_conditions[] = "o.order_date <= ?"; to_date . " 23:59:59"; $param_types .= "s"; }
// Combine all where conditions where_conditions) > 0) { where_conditions); }
// Sorting // To prevent SQL injection in ORDER BY, use a mapping sort_column = isset(sort_by]) ? sort_by] : 'o.order_date'; sort_column $sort_order";
// Pagination Calculations page - 1) * $orders_per_page;
// Fetch total number of orders for pagination where_clause "; conn->prepare(count_stmt) { if (!empty(where_clause)) { count_stmt->bind_param(parameters); } count_result = total_orders = count_stmt->close(); } else { // Handle SQL preparation error die("Failed to prepare the count query: " . $conn->error); }
// Calculate total pages total_orders / $orders_per_page);
// Fetch orders with customer details based on filters and sorting where_clause orders_stmt = orders_sql); if (orders_stmt) { // Bind parameters if (!empty(where_clause)) { // 'ii' for offset and limit param_types . "ii"; parameters, [orders_per_page]); types, ...values); } else { orders_stmt->bind_param("ii", orders_per_page); } 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 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_ids)) { order_ids), '?')); order_ids)); placeholders) "; conn->prepare(items_stmt) { types, ...items_stmt->execute(); items_stmt->get_result(); while (order_items_result->fetch_assoc()) { 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"> © <?= 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>- 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
- Assistant
Certainly! Below is the fully updated
view_orders.phpfile, 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:
- Color Palette: Applied a primary teal hue (
#20B2AA) for interactive elements, soft gray backgrounds (#f1f5f9), and appropriate accent colors for notifications. - Layout and Structure: Adopted a container-based responsive layout with clearly defined sections and generous spacing using Tailwind's utility classes.
- Typography: Utilized clean, sans-serif fonts with hierarchical text styling for headings, labels, and content.
- Form Elements: Ensured consistent styling for inputs, buttons, and interactive controls with focus and hover states.
- Interactive Elements: Added tooltips and smooth animations for dynamic form interactions.
- Notifications: Styled success and error messages distinctly with appropriate colors and icons.
- Scrollbar Customization: Customized scrollbars to be aesthetically pleasing and consistent with the overall theme.
- Responsive Design: Ensured the page is fully responsive and touch-friendly across all devices.
- Accessibility: Incorporated semantic HTML elements, clear focus states, and keyboard navigability.
Complete Updated
view_orders.phpCode:<?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"> © <?= 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:
-
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-100for the body andbg-whitewith 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.
- Primary Colors: Utilized the teal hue (
-
Layout and Structure:
- Container-Based Layout: Wrapped content within
max-w-7xl mx-auto p-6to 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-6for the orders display, ensuring adaptability on various screen sizes.
- Container-Based Layout: Wrapped content within
-
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.
- Font Choices: Leveraged Google Fonts (
-
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.
- Input Fields: Applied consistent styling with
-
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.
-
Notifications and Alerts:
- Success Messages: Styled with
bg-green-100,border-green-400, andtext-green-700along with appropriate icons for clear positive feedback. - Error Messages: Styled with
bg-red-100,border-red-400, andtext-red-700to prominently display actionable error information.
- Success Messages: Styled with
-
Scrollbar Customization:
- Customized scrollbars with narrow widths and rounded edges using CSS to align with the overall color scheme.
-
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.
-
Date and Time Picker Integration:
- Integrated Flatpickr for date selection (
#fromDate,#toDate) with styles matching the form inputs and ensuring keyboard accessibility.
- Integrated Flatpickr for date selection (
-
Footer Design:
- Designed a subtle footer with
text-gray-600that provides necessary information without detracting from the main content.
- Designed a subtle footer with
-
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.
- Employed Tailwind's responsive utilities (
-
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.
- Utilized semantic HTML elements (
-
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.
- Applied uniform margins (
-
Visual Hierarchy and Emphasis:
- Emphasized important information with larger, bolder fonts and consistent color usage to guide user attention effectively.
-
Interactive Feedback and Animations:
- Enhanced user interactions with hover and focus effects, providing immediate visual responses to user actions.
-
Iconography and Visual Cues:
- Ensured consistent sizing and coloring of icons to complement the overall design without overwhelming the interface.
-
Enhanced User Guidance:
- Integrated tooltips and contextual icons (
bi-question-circle) to offer additional information and guidance subtly.
- Integrated tooltips and contextual icons (
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 thetooltipclass and include atooltiptextdiv 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.phpshould 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! - Color Palette: Applied a primary teal hue (