change this codes (<?php
// public/orders/add_order.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, database connection, and functions
require_once __DIR__ . '/../../includes/auth.php';
require_once __DIR__ . '/../../includes/db_connect.php';
require_once __DIR__ . '/../../includes/functions.php'; // Include the functions.php for sanitize_input()

// Initialize variables
$success = '';
$error = '';

// Fetch products for selection
$products_sql = "SELECT * FROM products ORDER BY name ASC";
$products_result = $conn->query($products_sql);

if (!$products_result) {
    die("Error fetching products: " . $conn->error);
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Sanitize and validate input
    $customer_name = sanitize_input($_POST['customer_name']);
    $contact = sanitize_input($_POST['contact']);
    $delivery_address = sanitize_input($_POST['delivery_address']);
    $delivery_datetime = isset($_POST['delivery_datetime']) && !empty($_POST['delivery_datetime']) ? sanitize_input($_POST['delivery_datetime']) : null;
    $priority = isset($_POST['priority']) ? sanitize_input($_POST['priority']) : 'Normal';

    // Validate priority
    $valid_priorities = ['Normal', 'Important', 'Quick'];
    if (!in_array($priority, $valid_priorities)) {
        $priority = 'Normal';
    }

    // Handle multiple products
    $product_ids = isset($_POST['product_id']) ? $_POST['product_id'] : [];
    $quantities = isset($_POST['quantity']) ? $_POST['quantity'] : [];
    $packaging_preferences = isset($_POST['packaging_preferences']) ? $_POST['packaging_preferences'] : [];
    $apply_discount = isset($_POST['apply_discount']) ? $_POST['apply_discount'] : [];
    $discount_percentages = isset($_POST['discount_percentage']) ? $_POST['discount_percentage'] : [];
    $discount_reasons = isset($_POST['discount_reason']) ? $_POST['discount_reason'] : [];

    // Basic validation
    if (empty($customer_name)) {
        $error = "Customer name is required.";
    } elseif (empty($product_ids) || !is_array($product_ids) || count($product_ids) == 0) {
        $error = "At least one product must be selected.";
    } else {
        // Validate each product entry
        foreach ($product_ids as $index => $pid) {
            if (empty($pid)) {
                $error = "Product selection is required for all items.";
                break;
            }
            if (!isset($quantities[$index]) || intval($quantities[$index]) <= 0) {
                $error = "Quantity must be at least 1 for all items.";
                break;
            }
            // If discount is applied, validate discount fields
            if (isset($apply_discount[$index])) {
                $discount = trim($discount_percentages[$index]);
                $reason = trim($discount_reasons[$index]);
                if ($discount === '') {
                    $error = "Discount percentage is required if discount is applied.";
                    break;
                }
                if (!is_numeric($discount) || floatval($discount) < 0 || floatval($discount) > 100) {
                    $error = "Invalid discount percentage for product. It should be between 0 and 100.";
                    break;
                }
                if (empty($reason)) {
                    $error = "Discount reason is required if discount is applied.";
                    break;
                }
            }
        }

        // Validate delivery_datetime
        if ($delivery_datetime && !preg_match("/^\d{4}-\d{2}-\d{2}T\d{2}:\d{2}$/", $delivery_datetime)) {
            $error = "Invalid delivery date and time format.";
        } elseif ($delivery_datetime && strtotime(str_replace('T', ' ', $delivery_datetime)) < strtotime(date('Y-m-d H:i'))) {
            $error = "Delivery date and time cannot be in the past.";
        }
    }

    if (empty($error)) {
        // Start transaction
        $conn->begin_transaction();

        try {
            // Insert into customers table using prepared statement
            $stmt = $conn->prepare("INSERT INTO customers (name, contact, delivery_address) VALUES (?, ?, ?)");
            if (!$stmt) {
                throw new Exception("Prepare statement failed: " . $conn->error);
            }
            $stmt->bind_param("sss", $customer_name, $contact, $delivery_address);
            if (!$stmt->execute()) {
                throw new Exception("Execute failed: " . $stmt->error);
            }
            $customer_id = $stmt->insert_id;
            $stmt->close();

            // Insert into orders table using prepared statement
            $status = 'Pending'; // Default status
            $stmt = $conn->prepare("INSERT INTO orders (customer_id, status, priority, delivery_datetime) VALUES (?, ?, ?, ?)");
            if (!$stmt) {
                throw new Exception("Prepare statement failed: " . $conn->error);
            }
            $stmt->bind_param("isss", $customer_id, $status, $priority, $delivery_datetime);
            if (!$stmt->execute()) {
                throw new Exception("Execute failed: " . $stmt->error);
            }
            $order_id = $stmt->insert_id;
            $stmt->close();

            // Insert products into order_items table
            $stmt = $conn->prepare("INSERT INTO order_items (order_id, product_id, quantity, packaging_preferences, discount_percentage, discount_reason) VALUES (?, ?, ?, ?, ?, ?)");
            if (!$stmt) {
                throw new Exception("Prepare statement failed: " . $conn->error);
            }

            // Loop through each product
            foreach ($product_ids as $index => $pid) {
                $pid = intval($pid);
                $qty = intval($quantities[$index]);
                $pack_pref = sanitize_input($packaging_preferences[$index]);

                // Handle discount
                $discount_percent = 0.00;
                $discount_rs = null;
                if (isset($apply_discount[$index])) {
                    $discount_percent = floatval(trim($discount_percentages[$index]));
                    $discount_rs = sanitize_input($discount_reasons[$index]);
                }

                $stmt->bind_param("iiidds", $order_id, $pid, $qty, $pack_pref, $discount_percent, $discount_rs);
                if (!$stmt->execute()) {
                    throw new Exception("Execute failed: " . $stmt->error);
                }
            }

            $stmt->close();

            // Commit transaction
            $conn->commit();

            // Redirect to view_orders.php after successful addition
            header("Location: view_orders.php?success=1");
            exit();
        } catch (Exception $e) {
            // Rollback transaction
            $conn->rollback();
            $error = "Error adding order: " . $e->getMessage();
        }
    }
}

// Now include the header AFTER form handling
require_once '../../includes/header.php';
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Add New Order - Kaak Alia Management System</title>
    
    <!-- Google Fonts -->
    <link href="https://fonts.googleapis.com/css2?family=Nunito:wght@400;600;700&family=Roboto:wght@400;500;700&display=swap" rel="stylesheet">
    
    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="/kaak_alia_management_system/assets/bootstrap/css/bootstrap.min.css">
    
    <!-- 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">
    
<style>
    
    /* styles.css */

/* ---------------------------------------------------
   1. CSS Variables for Consistent Design
---------------------------------------------------- */
:root {
    /* Colors */
    --color-primary: #E8D8C3; /* Soft beige for borders and backgrounds */
    --color-accent: #D19A66; /* Warm accent color */
    --color-dark: #3A2F1B; /* Dark brown for titles */
    --color-dark-gray: #555555; /* Mid-gray for text */
    --color-light: #F9F4EC; /* Light cream background */
    --color-error: #EF476F; /* Red-pink for errors */
    --color-success: #06D6A0; /* Green for success messages */
    --color-hover-shadow: rgba(0, 0, 0, 0.1);
    --color-radio-active: #FFD166; /* Highlight color for active radio button */

    /* Fonts */
    --font-family-primary: 'Nunito', sans-serif;
    --font-family-secondary: 'Roboto', sans-serif;

    /* Other */
    --transition-speed: 0.3s;
    --border-radius: 8px;
    --box-shadow: 0px 2px 4px rgba(0, 0, 0, 0.1);
}

/* ---------------------------------------------------
   2. Global Styles
---------------------------------------------------- */
body {
    font-family: var(--font-family-primary);
    background-color: var(--color-light);
    margin: 0;
    padding: 0;
    box-sizing: border-box;
}

.container-body {
    padding: 30px;
}

h1, h2, h3, h4, h5, h6 {
    color: var(--color-dark);
    margin: 20px 0;
    font-weight: 600;
}

label {
    color: var(--color-dark-gray);
    font-weight: 600;
    display: block;
    margin-bottom: 5px;
}

/* ---------------------------------------------------
   3. Header Styles
---------------------------------------------------- */
.header {
    padding: 20px 30px;
    background-color: var(--color-dark);
    border-radius: var(--border-radius);
    text-align: center;
    margin-bottom: 30px;
    color: #ffffff;
    font-size: 24px;
    font-weight: bold;
}

/* ---------------------------------------------------
   4. Welcome Section
---------------------------------------------------- */
.welcome-section {
    background-color: var(--color-light);
    box-shadow: 0 4px 6px var(--color-hover-shadow);
    border-radius: var(--border-radius);
    padding: 20px;
    text-align: center;
    margin-bottom: 30px;
}

.welcome-section h3 {
    font-size: 20px;
    color: var(--color-dark);
    margin-bottom: 10px;
}

.welcome-section hr {
    width: 50px;
    height: 3px;
    background-color: var(--color-accent);
    border: none;
    margin: 10px auto 0;
}

/* ---------------------------------------------------
   5. Form Container Styles
---------------------------------------------------- */
.form-container {
    background-color: var(--color-light);
    box-shadow: 0 4px 6px var(--color-hover-shadow);
    border-radius: var(--border-radius);
    padding: 30px;
    max-width: 900px;
    margin: auto;
}

.form-container h3 {
    text-align: center;
    margin-bottom: 20px;
    color: var(--color-accent);
    font-family: var(--font-family-secondary);
    font-size: 24px;
}

/* ---------------------------------------------------
   6. Form Styles
---------------------------------------------------- */
.form-control {
    border-radius: var(--border-radius);
    border: 1px solid var(--color-primary);
    background-color: #ffffff;
    padding: 12px;
    box-shadow: var(--box-shadow);
    transition: border-color var(--transition-speed), box-shadow var(--transition-speed);
    width: 100%;
    margin-bottom: 15px;
    font-family: var(--font-family-secondary);
    color: var(--color-dark-gray);
    font-size: 16px;
}

.form-control::placeholder {
    color: #AAAAAA;
    font-style: italic;
}

.form-control:focus {
    border-color: var(--color-accent);
    box-shadow: 0 0 5px var(--color-accent);
    outline: none;
}

.form-label {
    margin-bottom: 5px;
    font-size: 14px;
    text-align: left;
}

/* ---------------------------------------------------
   7. Order Priority Styles
---------------------------------------------------- */
.order-priority {
    display: flex;
    gap: 15px;
    margin-bottom: 15px;
}

.order-priority label {
    cursor: pointer;
    position: relative;
    padding-left: 35px;
    user-select: none;
    font-weight: 500;
    transition: color var(--transition-speed);
}

.order-priority input[type="radio"] {
    position: absolute;
    opacity: 0;
    cursor: pointer;
}

.order-priority .custom-radio {
    position: absolute;
    left: 0;
    top: 0;
    height: 20px;
    width: 20px;
    background-color: #fff;
    border: 2px solid var(--color-primary);
    border-radius: 50%;
    transition: background-color var(--transition-speed), border-color var(--transition-speed);
}

.order-priority label:hover input ~ .custom-radio {
    border-color: var(--color-accent);
}

.order-priority input:checked ~ .custom-radio {
    background-color: var(--color-accent);
    border-color: var(--color-accent);
}

.order-priority .custom-radio::after {
    content: "";
    position: absolute;
    display: none;
}

.order-priority input:checked ~ .custom-radio::after {
    display: block;
}

.order-priority .custom-radio::after {
    top: 6px;
    left: 6px;
    width: 8px;
    height: 8px;
    border-radius: 50%;
    background: white;
}

/* ---------------------------------------------------
   8. Buttons Section
---------------------------------------------------- */
.add-product-button,
.remove-product-button,
.submit-button {
    border: none;
    border-radius: var(--border-radius);
    padding: 10px 15px;
    cursor: pointer;
    font-size: 16px;
    transition: background-color var(--transition-speed), transform var(--transition-speed), box-shadow var(--transition-speed);
    font-family: var(--font-family-secondary);
}

.add-product-button {
    background-color: var(--color-accent);
    color: #ffffff;
    margin-top: 10px;
}

.add-product-button:hover {
    background-color: #C7784A;
}

.remove-product-button {
    background-color: #dc3545;
    color: #ffffff;
}

.remove-product-button:hover {
    background-color: #c82333;
}

.submit-button {
    width: 100%;
    height: 50px;
    font-weight: bold;
    background-color: #FFD166;
    color: #ffffff;
    display: block;
    margin: 20px auto 0 auto;
    text-align: center;
}

.submit-button:hover {
    background-color: #FFC043;
    transform: scale(1.02);
    box-shadow: 0 4px 6px var(--color-hover-shadow);
}

/* ---------------------------------------------------
   9. Alert Styles
---------------------------------------------------- */
.alert-success,
.alert-danger {
    border-radius: var(--border-radius);
    padding: 15px 20px;
    margin-bottom: 20px;
    text-align: center;
    width: 100%;
    margin: 20px auto;
    font-family: var(--font-family-secondary);
    font-size: 16px;
}

.alert-success {
    background-color: var(--color-success);
    color: #ffffff;
}

.alert-danger {
    background-color: var(--color-error);
    color: #ffffff;
}

/* ---------------------------------------------------
   10. Footer Styles
---------------------------------------------------- */
.footer {
    text-align: center;
    margin-top: 50px;
    color: var(--color-dark-gray);
    font-size: 14px;
    font-family: var(--font-family-secondary);
}

/* ---------------------------------------------------
   11. Responsive Design Enhancements
---------------------------------------------------- */
@media (max-width: 768px) {
    .form-control,
    .form-label,
    .submit-button,
    .alert-success,
    .alert-danger {
        width: 100%;
    }

    .form-container {
        padding: 20px;
    }

    .submit-button {
        height: 50px;
        font-size: 16px;
    }
}

@media (max-width: 480px) {
    .header {
        padding: 15px 20px;
        font-size: 20px;
    }

    .welcome-section h3 {
        font-size: 18px;
    }

    .form-container h3 {
        font-size: 20px;
    }

    .submit-button {
        height: 50px;
        font-size: 16px;
    }

    .order-priority {
        flex-direction: column;
    }
}
</style>    
    <!-- Additional JavaScript for dynamic product addition and discount handling -->
    <script>
        let productCount = <?= isset($product_ids) ? count($product_ids) : 1; ?>;

        function addProductRow() {
            const productContainer = document.getElementById('products-container');

            const productRow = document.createElement('div');
            productRow.className = 'product-row border p-3 mb-3';
            productRow.innerHTML = `
                <div class="row">
                    <div class="col-md-4">
                        <label class="form-label" for="product_id_${productCount}">Product <span class="text-danger">*</span></label>
                        <select name="product_id[]" id="product_id_${productCount}" class="form-control" required>
                            <option value="">Select Product</option>
                            <?php
                            // Reset the products_result pointer
                            $products_result->data_seek(0);
                            while($product = $products_result->fetch_assoc()): ?>
                                <option value="<?= htmlspecialchars($product['id']) ?>">
                                    <?= htmlspecialchars($product['name'] . " - " . $product['size'] . " (" . number_format($product['price'], 2) . " KD)") ?>
                                </option>
                            <?php endwhile; ?>
                        </select>
                    </div>
                    <div class="col-md-2">
                        <label class="form-label" for="quantity_${productCount}">Quantity <span class="text-danger">*</span></label>
                        <input type="number" name="quantity[]" id="quantity_${productCount}" class="form-control" min="1" value="1" required>
                    </div>
                    <div class="col-md-3">
                        <label class="form-label" for="packaging_preferences_${productCount}">Packaging Preferences</label>
                        <input type="text" name="packaging_preferences[]" id="packaging_preferences_${productCount}" class="form-control" placeholder="e.g., Gift Wrap">
                    </div>
                    <div class="col-md-3">
                        <label class="form-label" for="discount_${productCount}">Apply Discount</label>
                        <div class="form-check">
                            <input class="form-check-input" type="checkbox" value="1" id="discount_checkbox_${productCount}" name="apply_discount[]">
                            <label class="form-check-label" for="discount_checkbox_${productCount}">
                                Yes
                            </label>
                        </div>
                        <div id="discount_fields_${productCount}" style="display: none; margin-top: 10px;">
                            <label class="form-label" for="discount_percentage_${productCount}">Discount Percentage (%) <span class="text-danger">*</span></label>
                            <input type="number" name="discount_percentage[]" id="discount_percentage_${productCount}" class="form-control" min="0" max="100" step="0.01" placeholder="Enter discount percentage">
                            
                            <label class="form-label mt-2" for="discount_reason_${productCount}">Discount Reason <span class="text-danger">*</span></label>
                            <input type="text" name="discount_reason[]" id="discount_reason_${productCount}" class="form-control" placeholder="Enter reason for discount">
                        </div>
                    </div>
                    <div class="col-md-12 d-flex justify-content-end mt-3">
                        <button type="button" class="remove-product-button btn btn-danger btn-sm" onclick="removeProductRow(this)"><i class="bi bi-trash-fill"></i> Remove</button>
                    </div>
                </div>
            `;
            productContainer.appendChild(productRow);

            // Initialize discount toggle for the new row
            const newCheckbox = productRow.querySelector(`input[name="apply_discount[]"]`);
            newCheckbox.addEventListener('change', function() {
                toggleDiscountFields(this, productCount);
            });

            productCount++;
        }

        function removeProductRow(button) {
            const productRow = button.closest('.product-row');
            productRow.remove();
        }

        // Toggle discount fields based on checkbox
        function toggleDiscountFields(checkbox, count) {
            const discountFields = document.getElementById(`discount_fields_${count}`);
            if (checkbox.checked) {
                discountFields.style.display = 'block';
            } else {
                discountFields.style.display = 'none';
                // Clear discount inputs
                discountFields.querySelectorAll('input').forEach(input => input.value = '');
            }
        }

        // Add event listeners to existing discount checkboxes on page load
        function initializeDiscountToggle() {
            const discountCheckboxes = document.querySelectorAll('input[name="apply_discount[]"]');
            discountCheckboxes.forEach((checkbox, index) => {
                checkbox.addEventListener('change', function() {
                    toggleDiscountFields(this, index);
                });
            });
        }

        // Initialize on DOM content loaded
        document.addEventListener('DOMContentLoaded', function() {
            // Add initial product row if none exist
            if (document.getElementById('products-container').children.length === 0) {
                addProductRow();
            }

            // Initialize discount toggles
            initializeDiscountToggle();
        });
    </script>

</head>
<body>

    <!-- Header Already Included via header.php -->
    <main class='container-body'>
        <!-- Welcome Section -->
        <div class="welcome-section">
            <h3>Add a New Order</h3>
            <hr>
        </div>

        <!-- Form Container -->
        <div class="form-container">
            <h3>Add New Order</h3>
            
            <?php if (!empty($error)): ?>
                <div class="alert-danger"><?= htmlspecialchars($error) ?></div>
            <?php endif; ?>
            <?php if (!empty($success)): ?>
                <div class="alert-success"><?= htmlspecialchars($success) ?></div>
            <?php endif; ?>
            
            <form method="POST" action="add_order.php">
                <!-- Customer Details -->
                <div class="form-section">
                    <h5>Customer Details</h5>
                    <label class="form-label" for="customer_name">Name <span class="text-danger">*</span></label>
                    <input type="text" id="customer_name" name="customer_name" class="form-control" 
                           value="<?= isset($_POST['customer_name']) ? htmlspecialchars($_POST['customer_name']) : '' ?>" 
                           required>
                    
                    <label class="form-label" for="contact">Contact</label>
                    <input type="text" id="contact" name="contact" class="form-control" 
                           value="<?= isset($_POST['contact']) ? htmlspecialchars($_POST['contact']) : '' ?>">
                    
                    <label class="form-label" for="delivery_address">Delivery Address</label>
                    <textarea id="delivery_address" name="delivery_address" class="form-control"><?= isset($_POST['delivery_address']) ? htmlspecialchars($_POST['delivery_address']) : '' ?></textarea>
                </div>
                <hr>
                <!-- Order Details -->
                <div class="form-section">
                    <h5>Order Details</h5>
                    <!-- Priority Selection -->
                    <label class="form-label">Order Priority</label>
                    <div class="order-priority">
                        <label>
                            <input type="radio" name="priority" value="Normal" <?= (isset($_POST['priority']) && $_POST['priority'] === 'Normal') || !isset($_POST['priority']) ? 'checked' : '' ?>>
                            <span class="custom-radio"></span>
                            Normal (Default)
                        </label>
                        <label>
                            <input type="radio" name="priority" value="Important" <?= isset($_POST['priority']) && $_POST['priority'] === 'Important' ? 'checked' : '' ?>>
                            <span class="custom-radio"></span>
                            Important
                        </label>
                        <label>
                            <input type="radio" name="priority" value="Quick" <?= isset($_POST['priority']) && $_POST['priority'] === 'Quick' ? 'checked' : '' ?>>
                            <span class="custom-radio"></span>
                            Quick
                        </label>
                    </div>
                    <hr>
                    <!-- Products Selection -->
                    <div id="products-container">
                        <!-- Product Rows will be added here -->
                        <?php
                        // If form was submitted with errors, repopulate the product rows
                        if ($_SERVER['REQUEST_METHOD'] == 'POST' && !empty($error) && !empty($product_ids) && is_array($product_ids)) {
                            foreach ($product_ids as $i => $pid) {
                                ?>
                                <div class="product-row border p-3 mb-3">
                                    <div class="row">
                                        <div class="col-md-4">
                                            <label class="form-label" for="product_id_<?= $i ?>">Product <span class="text-danger">*</span></label>
                                            <select name="product_id[]" id="product_id_<?= $i ?>" class="form-control" required>
                                                <option value="">Select Product</option>
                                                <?php
                                                $products_result->data_seek(0);
                                                while($product = $products_result->fetch_assoc()):
                                                    $selected = ($product['id'] == $pid) ? 'selected' : '';
                                                ?>
                                                    <option value="<?= htmlspecialchars($product['id']) ?>" <?= $selected ?>>
                                                        <?= htmlspecialchars($product['name'] . " - " . $product['size'] . " (" . number_format($product['price'], 2) . " KD)") ?>
                                                    </option>
                                                <?php endwhile; ?>
                                            </select>
                                        </div>
                                        <div class="col-md-2">
                                            <label class="form-label" for="quantity_<?= $i ?>">Quantity <span class="text-danger">*</span></label>
                                            <input type="number" name="quantity[]" id="quantity_<?= $i ?>" class="form-control" min="1" value="<?= isset($quantities[$i]) ? intval($quantities[$i]) : '1' ?>" required>
                                        </div>
                                        <div class="col-md-3">
                                            <label class="form-label" for="packaging_preferences_<?= $i ?>">Packaging Preferences</label>
                                            <input type="text" name="packaging_preferences[]" id="packaging_preferences_<?= $i ?>" class="form-control" placeholder="e.g., Gift Wrap" value="<?= isset($packaging_preferences[$i]) ? htmlspecialchars($packaging_preferences[$i]) : '' ?>">
                                        </div>
                                        <div class="col-md-3">
                                            <label class="form-label" for="discount_<?= $i ?>">Apply Discount</label>
                                            <div class="form-check">
                                                <input class="form-check-input" type="checkbox" value="1" id="discount_checkbox_<?= $i ?>" name="apply_discount[]" <?= isset($apply_discount[$i]) ? 'checked' : '' ?>>
                                                <label class="form-check-label" for="discount_checkbox_<?= $i ?>">
                                                    Yes
                                                </label>
                                            </div>
                                            <div id="discount_fields_<?= $i ?>" style="display: <?= isset($apply_discount[$i]) ? 'block' : 'none' ?>; margin-top: 10px;">
                                                <label class="form-label" for="discount_percentage_<?= $i ?>">Discount Percentage (%) <span class="text-danger">*</span></label>
                                                <input type="number" name="discount_percentage[]" id="discount_percentage_<?= $i ?>" class="form-control" min="0" max="100" step="0.01" placeholder="Enter discount percentage" value="<?= isset($discount_percentages[$i]) ? htmlspecialchars($discount_percentages[$i]) : '' ?>">
                                                
                                                <label class="form-label mt-2" for="discount_reason_<?= $i ?>">Discount Reason <span class="text-danger">*</span></label>
                                                <input type="text" name="discount_reason[]" id="discount_reason_<?= $i ?>" class="form-control" placeholder="Enter reason for discount" value="<?= isset($discount_reasons[$i]) ? htmlspecialchars($discount_reasons[$i]) : '' ?>">
                                            </div>
                                        </div>
                                        <div class="col-md-12 d-flex justify-content-end mt-3">
                                            <button type="button" class="remove-product-button btn btn-danger btn-sm" onclick="removeProductRow(this)"><i class="bi bi-trash-fill"></i> Remove</button>
                                        </div>
                                    </div>
                                </div>
                                <?php
                            }
                        } else {
                            // Add one default product row
                            ?>
                            <div class="product-row border p-3 mb-3">
                                <div class="row">
                                    <div class="col-md-4">
                                        <label class="form-label" for="product_id_0">Product <span class="text-danger">*</span></label>
                                        <select name="product_id[]" id="product_id_0" class="form-control" required>
                                            <option value="">Select Product</option>
                                            <?php
                                            $products_result->data_seek(0);
                                            while($product = $products_result->fetch_assoc()): ?>
                                                <option value="<?= htmlspecialchars($product['id']) ?>">
                                                    <?= htmlspecialchars($product['name'] . " - " . $product['size'] . " (" . number_format($product['price'], 2) . " KD)") ?>
                                                </option>
                                            <?php endwhile; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label" for="quantity_0">Quantity <span class="text-danger">*</span></label>
                                        <input type="number" name="quantity[]" id="quantity_0" class="form-control" min="1" value="1" required>
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label" for="packaging_preferences_0">Packaging Preferences</label>
                                        <input type="text" name="packaging_preferences[]" id="packaging_preferences_0" class="form-control" placeholder="e.g., Gift Wrap">
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label" for="discount_0">Apply Discount</label>
                                        <div class="form-check">
                                            <input class="form-check-input" type="checkbox" value="1" id="discount_checkbox_0" name="apply_discount[]">
                                            <label class="form-check-label" for="discount_checkbox_0">
                                                Yes
                                            </label>
                                        </div>
                                        <div id="discount_fields_0" style="display: none; margin-top: 10px;">
                                            <label class="form-label" for="discount_percentage_0">Discount Percentage (%) <span class="text-danger">*</span></label>
                                            <input type="number" name="discount_percentage[]" id="discount_percentage_0" class="form-control" min="0" max="100" step="0.01" placeholder="Enter discount percentage">
                                            
                                            <label class="form-label mt-2" for="discount_reason_0">Discount Reason <span class="text-danger">*</span></label>
                                            <input type="text" name="discount_reason[]" id="discount_reason_0" class="form-control" placeholder="Enter reason for discount">
                                        </div>
                                    </div>
                                    <div class="col-md-12 d-flex justify-content-end mt-3">
                                        <button type="button" class="remove-product-button btn btn-danger btn-sm" onclick="removeProductRow(this)"><i class="bi bi-trash-fill"></i> Remove</button>
                                    </div>
                                </div>
                            </div>
                            <?php
                        }
                        ?>
                    </div>
                    <button type="button" class="add-product-button btn btn-secondary" onclick="addProductRow()"><i class="bi bi-plus-circle-fill"></i> Add Another Product</button>
                    
                    <!-- Delivery DateTime Field -->
                    <hr>
                    <div class="form-section">
                        <h5>Delivery Details</h5>
                        <label class="form-label" for="delivery_datetime">Delivery Date and Time</label>
                        <input type="datetime-local" id="delivery_datetime" name="delivery_datetime" class="form-control" 
                               value="<?= isset($_POST['delivery_datetime']) ? htmlspecialchars($_POST['delivery_datetime']) : '' ?>">
                    </div>
                </div>
                <!-- Submit Button -->
                <button type="submit" class="submit-button btn btn-primary"><i class="bi bi-plus-lg"></i> Add Order</button>
            </form>
        </div>

        <!-- Footer -->
        <div class="footer text-center">
            &copy; 2024 Kaak Alia Bakery. All rights reserved.
        </div>
    </main>
    <!-- Bootstrap JS Bundle -->
    <script src="/kaak_alia_management_system/assets/bootstrap/js/bootstrap.bundle.min.js"></script>
    
    <!-- Flatpickr JS for Date Picker -->
    <script src="https://cdn.jsdelivr.net/npm/flatpickr"></script>

    <!-- Bootstrap Tooltip Initialization -->
    <script>
        var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]'))
        var tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) {
            return new bootstrap.Tooltip(tooltipTriggerEl)
        })
    </script>

</body>
</html>
<?php
// Flush the output buffer
ob_end_flush();
// No closing PHP tag to prevent unwanted output
?>) design and type full codes and use this stlyes as examples (    <!-- Custom Styles -->
    <style>
        /* ---------------------------------------------------
           1. CSS Variables for Consistent Design
        ---------------------------------------------------- */
        :root {
            /* Primary Colors */
            --background-color: #FFFFFF; /* Crisp White */
            --light-grey: #F5F5F5;
            --medium-grey: #CCCCCC;
            --dark-grey: #333333;
            --charcoal: #4A4A4A;

            /* Accent Colors */
            --accent-blue: #4A90E2;
            --accent-green: #50C878;
            --accent-red: #FF6B6B;
            --accent-teal: #20B2AA;
            --accent-soft-blue: #A3D2CA;
            --accent-purple: #8A65FF;
            --accent-orange: #FFA500;

            /* Text Colors */
            --primary-text: var(--dark-grey);
            --secondary-text: #666666;

            /* UI Elements */
            --input-border: var(--medium-grey);
            --input-focus-border: var(--accent-teal);
            --box-shadow: 0 2px 8px rgba(0, 0, 0, 0.05);
            --box-border-radius: 12px;
            --hover-shadow: rgba(0, 0, 0, 0.1);

            /* Button Colors */
            --button-add-order: #6C63FF;
            --button-view-orders: #FFA500;
            --button-manage-products: #20B2AA;
            --button-manage-users: #4B0082;
            --button-generate-reports: #FF6B6B;

            /* Status Badge Colors */
            --badge-pending: #FFD166;
            --badge-in-progress: #6A4C93;
            --badge-completed: #4CAF50;
            --badge-delivered: #20B2AA;
        }

        /* ---------------------------------------------------
           2. Global Styles
        ---------------------------------------------------- */
        body {
            font-family: 'Roboto', sans-serif;
            background-color: var(--light-grey);
            margin: 0;
            padding: 0;
            color: var(--primary-text);
        }

        .container-body {
            max-width: 1200px;
            margin: 40px auto;
            padding: 40px 20px;
            box-sizing: border-box;
            background-color: var(--background-color);
            box-shadow: var(--box-shadow);
            border-radius: var(--box-border-radius);
            font-family: 'Roboto', sans-serif;
            transition: all 0.3s ease;
        }

        /* ---------------------------------------------------
           3. Header Styles
        ---------------------------------------------------- */
        .header {
            padding: 20px 30px;
            background-color: var(--background-color);
            display: flex;
            align-items: center;
            justify-content: center;
            margin-bottom: 30px;
            border-bottom: 1px solid var(--light-grey);
        }

        .header h1 {
            color: var(--charcoal);
            font-size: 32px;
            font-weight: 700;
            font-family: 'Inter', sans-serif;
            position: relative;
        }

        /* Decorative Line Under Header */
        .header h1::after {
            content: "";
            display: block;
            width: 80px;
            height: 4px;
            background: linear-gradient(90deg, var(--accent-teal), var(--accent-soft-blue));
            margin: 8px auto 0;
            border-radius: 2px;
        }

        /* ---------------------------------------------------
           4. Welcome Section
        ---------------------------------------------------- */
        .welcome-section {
            background-color: var(--background-color);
            box-shadow: var(--box-shadow);
            border-radius: var(--box-border-radius);
            padding: 30px;
            text-align: center;
            margin-bottom: 30px;
            font-family: 'Inter', sans-serif;
        }

        .welcome-section h3 {
            font-size: 24px;
            color: var(--primary-text);
            margin-bottom: 10px;
            font-weight: 600;
        }

        .welcome-section p {
            font-size: 16px;
            color: var(--secondary-text);
            margin: 0;
        }

        /* ---------------------------------------------------
           5. Statistics Section
        ---------------------------------------------------- */
        .stats-section {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 25px;
            margin-bottom: 30px;
        }

        .stat-card {
            background-color: var(--background-color);
            box-shadow: var(--box-shadow);
            border-radius: var(--box-border-radius);
            padding: 20px;
            display: flex;
            align-items: center;
            transition: transform 0.3s, box-shadow 0.3s;
            cursor: default;
        }

        .stat-card:hover {
            transform: translateY(-5px);
            box-shadow: 0 4px 12px rgba(0, 0, 0, 0.1);
        }

        .stat-icon {
            font-size: 36px;
            margin-right: 20px;
            /* Default color */
            color: var(--accent-blue);
        }

        /* Different colors for each stat icon */
        .stat-icon.orders { color: var(--accent-blue); } /* Blue */
        .stat-icon.pending { color: var(--badge-pending); } /* Yellow */
        .stat-icon.completed { color: var(--badge-completed); } /* Green */
        .stat-icon.delivered { color: var(--badge-delivered); } /* Teal */
        .stat-icon.sales { color: var(--accent-red); } /* Red */

        .stat-info h5 {
            font-size: 18px;
            color: var(--primary-text);
            margin-bottom: 8px;
            font-family: 'Inter', sans-serif;
            font-weight: 600;
        }

        .stat-info p {
            font-size: 26px;
            font-weight: 700;
            color: var(--charcoal);
            margin: 0;
        }

        /* ---------------------------------------------------
           6. Main Buttons Section
        ---------------------------------------------------- */
        .buttons-section {
            display: flex;
            flex-wrap: wrap;
            gap: 25px;
            margin-bottom: 30px;
        }

        .action-button {
            display: flex;
            align-items: center;
            justify-content: center;
            flex: 1 1 200px;
            height: 60px;
            font-size: 16px;
            font-weight: 600;
            color: #FFFFFF;
            border: none;
            border-radius: 30px;
            padding: 0 20px;
            cursor: pointer;
            transition: background-color 0.3s, box-shadow 0.3s;
            text-decoration: none;
            text-align: center;
            font-family: 'Inter', sans-serif;
            box-shadow: 0 2px 6px rgba(0, 0, 0, 0.1);
            position: relative;
            overflow: hidden;
        }

        .action-button::before {
            content: "";
            position: absolute;
            top: 0;
            left: -100%;
            width: 100%;
            height: 100%;
            background: linear-gradient(45deg, rgba(255, 255, 255, 0.1), rgba(255, 255, 255, 0));
            transition: left 0.3s;
        }

        .action-button:hover::before {
            left: 100%;
        }

        .action-button.add-order { 
            background: var(--button-add-order); 
        }
        .action-button.view-orders { 
            background: var(--button-view-orders); 
        }
        .action-button.manage-products { 
            background: var(--button-manage-products); 
        }
        .action-button.manage-users { 
            background: var(--button-manage-users); 
        }
        .action-button.generate-reports { 
            background: var(--button-generate-reports); 
        }

        .action-button:hover {
            box-shadow: 0 4px 12px rgba(0, 0, 0, 0.2);
        }

        .action-button i {
            margin-right: 10px;
            font-size: 20px;
            color: #FFFFFF;
        }

        /* ---------------------------------------------------
           7. Recent Orders Section
        ---------------------------------------------------- */
        .recent-orders-section {
            background-color: var(--background-color);
            border-radius: var(--box-border-radius);
            padding: 30px;
            box-shadow: var(--box-shadow);
        }

        .recent-orders-section h4 {
            font-size: 24px;
            font-weight: 700;
            color: var(--charcoal);
            margin-bottom: 20px;
            font-family: 'Inter', sans-serif;
        }

        /* Make table responsive */
        .table-responsive {
            overflow-x: auto;
        }

        .recent-orders-section table {
            width: 100%;
            border-collapse: collapse;
            font-family: 'Roboto', sans-serif;
        }

        .recent-orders-section th, 
        .recent-orders-section td {
            padding: 14px 16px;
            text-align: left;
            font-size: 14px;
            vertical-align: top;
        }

        .recent-orders-section th {
            background-color: var(--light-grey);
            color: var(--charcoal);
            font-weight: 700;
            border-bottom: 2px solid var(--medium-grey);
            font-family: 'Inter', sans-serif;
            position: relative;
        }

        /* Underline for headers */
        .recent-orders-section th::after {
            content: "";
            position: absolute;
            bottom: 0;
            left: 0;
            width: 100%;
            height: 2px;
            background-color: var(--medium-grey);
        }

        .recent-orders-section tr:nth-child(even) {
            background-color: #FAFAFA;
        }

        .recent-orders-section tr:hover {
            background-color: #F1F1F1;
        }

        .recent-orders-section td {
            color: var(--secondary-text);
        }

        .recent-orders-section .view-all {
            display: block;
            text-align: right;
            margin-top: 15px;
            font-size: 16px;
            color: var(--accent-teal);
            font-weight: 600;
            text-decoration: none;
            font-family: 'Inter', sans-serif;
            transition: color 0.3s;
        }

        .recent-orders-section .view-all:hover {
            color: var(--accent-soft-blue);
        }

        /* Badge Styles */
        .badge-status-pending {
            background-color: var(--badge-pending);
            color: #FFFFFF;
            padding: 6px 12px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 600;
        }

        .badge-status-in-progress {
            background-color: var(--badge-in-progress);
            color: #FFFFFF;
            padding: 6px 12px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 600;
        }

        .badge-status-completed {
            background-color: var(--badge-completed);
            color: #FFFFFF;
            padding: 6px 12px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 600;
        }

        .badge-status-delivered {
            background-color: var(--badge-delivered);
            color: #FFFFFF;
            padding: 6px 12px;
            border-radius: 20px;
            font-size: 12px;
            font-weight: 600;
        }

        /* ---------------------------------------------------
           8. Footer Styles
        ---------------------------------------------------- */
        .footer {
            background-color: var(--background-color);
            color: var(--secondary-text);
            padding: 20px;
            text-align: center;
            border-radius: var(--box-border-radius);
            font-size: 14px;
            line-height: 22px;
            margin-top: 40px;
            font-family: 'Roboto', sans-serif;
            box-shadow: var(--box-shadow);
        }

        /* ---------------------------------------------------
           9. Responsive Design Enhancements
        ---------------------------------------------------- */
        @media (max-width: 768px) {
            .header h1 {
                font-size: 24px;
            }

            .welcome-section h3 {
                font-size: 20px;
            }

            .stats-section {
                grid-template-columns: repeat(auto-fit, minmax(180px, 1fr));
                gap: 20px;
            }

            .stat-icon {
                font-size: 30px;
            }

            .stat-info p {
                font-size: 22px;
            }

            .action-button {
                flex: 1 1 100%;
                height: 50px;
                font-size: 14px;
            }

            .recent-orders-section h4 {
                font-size: 20px;
            }

            .recent-orders-section th, 
            .recent-orders-section td {
                padding: 10px 12px;
                font-size: 12px;
            }
        }

        @media (max-width: 480px) {
            .container-body {
                padding: 20px 10px;
            }

            .header h1 {
                font-size: 20px;
            }

            .welcome-section h3 {
                font-size: 18px;
            }

            .stat-info p {
                font-size: 20px;
            }

            .action-button {
                height: 45px;
                font-size: 13px;
            }

            .recent-orders-section h4 {
                font-size: 18px;
            }

            .recent-orders-section th, 
            .recent-orders-section td {
                padding: 8px 10px;
                font-size: 11px;
            }
        }

    </style>
) and make it rpesovines