based on this info database (-- phpMyAdmin SQL Dump -- version 5.2.1 --…
- User
based on this info database (-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/
-- Host: 127.0.0.1:3306 -- Generation Time: Nov 13, 2024 at 12:00 PM -- Server version: 10.11.9-MariaDB -- PHP Version: 7.2.34
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 */;
-- -- Database:
u406552082_kaakalia
-- -- Table structure for table
adsCREATE TABLE
ads(idint(11) NOT NULL,user_idint(11) NOT NULL,namevarchar(255) NOT NULL,ad_typeenum('Post','Story') NOT NULL,related_idint(11) NOT NULL,budgetdecimal(10,2) NOT NULL,total_spentdecimal(10,2) DEFAULT 0.00,start_datedate NOT NULL,end_datedate NOT NULL,statusenum('Active','Paused','Completed') DEFAULT 'Active',created_atdatetime DEFAULT current_timestamp(),updated_atdatetime DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
ad_spend_logsCREATE TABLE
ad_spend_logs(idint(11) NOT NULL,ad_idint(11) NOT NULL,amountdecimal(10,2) NOT NULL,spend_datedatetime DEFAULT current_timestamp(),descriptionvarchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
customersCREATE TABLE
customers(idint(11) NOT NULL,namevarchar(100) NOT NULL,contactvarchar(50) DEFAULT NULL,delivery_addresstext DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
driversCREATE TABLE
drivers(idint(11) NOT NULL,namevarchar(100) NOT NULL,numbervarchar(15) NOT NULL,is_startinyint(1) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
notificationsCREATE TABLE
notifications(idint(11) NOT NULL,user_idint(11) NOT NULL,typeenum('order','post','plan','note','ad') NOT NULL,messagevarchar(255) NOT NULL,linkvarchar(255) NOT NULL,created_atdatetime DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
ordersCREATE TABLE
orders(idint(11) NOT NULL,customer_idint(11) NOT NULL,statusenum('Pending','In Progress','Completed','Delivered') DEFAULT 'Pending',priorityenum('Normal','Important','Quick') DEFAULT 'Normal',order_datedatetime DEFAULT current_timestamp(),delivery_datetimedatetime DEFAULT NULL,delivery_datedate DEFAULT NULL,delivery_feedecimal(10,2) NOT NULL DEFAULT 0.00,free_shippingtinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
order_itemsCREATE TABLE
order_items(idint(11) NOT NULL,order_idint(11) NOT NULL,product_idint(11) NOT NULL,quantityint(11) NOT NULL DEFAULT 1,packaging_preferencesvarchar(255) DEFAULT NULL,discount_percentagedecimal(5,2) DEFAULT 0.00,discount_reasonvarchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
productsCREATE TABLE
products(idint(11) NOT NULL,namevarchar(100) NOT NULL,sizevarchar(50) DEFAULT NULL,pricedecimal(10,2) NOT NULL,categoryvarchar(50) DEFAULT NULL,thumbnailvarchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
usersCREATE TABLE
users(idint(11) NOT NULL,usernamevarchar(50) NOT NULL,emailvarchar(100) DEFAULT NULL,passwordvarchar(255) NOT NULL,roleenum('admin','staff') NOT NULL,profile_imagevarchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
workspace_notesCREATE TABLE
workspace_notes(idint(11) NOT NULL,user_idint(11) NOT NULL,titlevarchar(255) NOT NULL,contenttext NOT NULL,created_atdatetime DEFAULT current_timestamp(),updated_atdatetime DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
workspace_plansCREATE TABLE
workspace_plans(idint(11) NOT NULL,user_idint(11) NOT NULL,titlevarchar(255) NOT NULL,descriptiontext DEFAULT NULL,audio_pathvarchar(255) DEFAULT NULL,due_datedatetime DEFAULT NULL,statusenum('Not Started','In Progress','Completed') DEFAULT 'Not Started',created_atdatetime DEFAULT current_timestamp(),updated_atdatetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),priorityenum('Normal','Important','Critical') NOT NULL DEFAULT 'Normal' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table
workspace_postsCREATE TABLE
workspace_posts(idint(11) NOT NULL,user_idint(11) NOT NULL,platformenum('Instagram','Facebook','Twitter','Other') NOT NULL,contenttext NOT NULL,media_urlvarchar(255) DEFAULT NULL,scheduled_datetimedatetime DEFAULT NULL,statusenum('Scheduled','Posted','Failed') DEFAULT 'Scheduled',created_atdatetime DEFAULT current_timestamp(),updated_atdatetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),typeenum('Post','Story') DEFAULT 'Post' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;-- -- Indexes for dumped tables
-- -- Indexes for table
adsALTER TABLE
adsADD PRIMARY KEY (id), ADD KEYuser_id(user_id), ADD KEYrelated_id(related_id);-- -- Indexes for table
ad_spend_logsALTER TABLE
ad_spend_logsADD PRIMARY KEY (id), ADD KEYad_id(ad_id);-- -- Indexes for table
customersALTER TABLE
customersADD PRIMARY KEY (id);-- -- Indexes for table
driversALTER TABLE
driversADD PRIMARY KEY (id);-- -- Indexes for table
notificationsALTER TABLE
notificationsADD PRIMARY KEY (id), ADD KEYuser_id(user_id), ADD KEYcreated_at(created_at);-- -- Indexes for table
ordersALTER TABLE
ordersADD PRIMARY KEY (id), ADD KEYcustomer_id(customer_id), ADD KEYidx_orders_customer_id(customer_id);-- -- Indexes for table
order_itemsALTER TABLE
order_itemsADD PRIMARY KEY (id), ADD KEYorder_id(order_id), ADD KEYproduct_id(product_id), ADD KEYidx_order_items_order_id(order_id), ADD KEYidx_order_items_product_id(product_id);-- -- Indexes for table
productsALTER TABLE
productsADD PRIMARY KEY (id);-- -- Indexes for table
usersALTER TABLE
usersADD PRIMARY KEY (id), ADD UNIQUE KEYusername(username);-- -- Indexes for table
workspace_notesALTER TABLE
workspace_notesADD PRIMARY KEY (id), ADD KEYuser_id(user_id);-- -- Indexes for table
workspace_plansALTER TABLE
workspace_plansADD PRIMARY KEY (id), ADD KEYuser_id(user_id);-- -- Indexes for table
workspace_postsALTER TABLE
workspace_postsADD PRIMARY KEY (id), ADD KEYuser_id(user_id);-- -- AUTO_INCREMENT for dumped tables
-- -- AUTO_INCREMENT for table
adsALTER TABLE
adsMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
ad_spend_logsALTER TABLE
ad_spend_logsMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
customersALTER TABLE
customersMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
driversALTER TABLE
driversMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
notificationsALTER TABLE
notificationsMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
ordersALTER TABLE
ordersMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
order_itemsALTER TABLE
order_itemsMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
productsALTER TABLE
productsMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
usersALTER TABLE
usersMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
workspace_notesALTER TABLE
workspace_notesMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
workspace_plansALTER TABLE
workspace_plansMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- AUTO_INCREMENT for table
workspace_postsALTER TABLE
workspace_postsMODIFYidint(11) NOT NULL AUTO_INCREMENT;-- -- Constraints for dumped tables
-- -- Constraints for table
adsALTER TABLE
adsADD CONSTRAINTfk_ads_related_idFOREIGN KEY (related_id) REFERENCESworkspace_posts(id) ON DELETE CASCADE, ADD CONSTRAINTfk_ads_user_idFOREIGN KEY (user_id) REFERENCESusers(id) ON DELETE CASCADE;-- -- Constraints for table
ad_spend_logsALTER TABLE
ad_spend_logsADD CONSTRAINTfk_ad_spend_logs_ad_idFOREIGN KEY (ad_id) REFERENCESads(id) ON DELETE CASCADE;-- -- Constraints for table
notificationsALTER TABLE
notificationsADD CONSTRAINTnotifications_ibfk_1FOREIGN KEY (user_id) REFERENCESusers(id) ON DELETE CASCADE;-- -- Constraints for table
ordersALTER TABLE
ordersADD CONSTRAINTfk_orders_customer_idFOREIGN KEY (customer_id) REFERENCEScustomers(id) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINTorders_ibfk_1FOREIGN KEY (customer_id) REFERENCEScustomers(id) ON DELETE CASCADE;-- -- Constraints for table
order_itemsALTER TABLE
order_itemsADD CONSTRAINTfk_order_items_order_idFOREIGN KEY (order_id) REFERENCESorders(id) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINTfk_order_items_product_idFOREIGN KEY (product_id) REFERENCESproducts(id) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINTorder_items_ibfk_1FOREIGN KEY (order_id) REFERENCESorders(id) ON DELETE CASCADE, ADD CONSTRAINTorder_items_ibfk_2FOREIGN KEY (product_id) REFERENCESproducts(id) ON DELETE CASCADE;-- -- Constraints for table
workspace_notesALTER TABLE
workspace_notesADD CONSTRAINTfk_workspace_notes_user_idFOREIGN KEY (user_id) REFERENCESusers(id) ON DELETE CASCADE;-- -- Constraints for table
workspace_plansALTER TABLE
workspace_plansADD CONSTRAINTfk_workspace_plans_user_idFOREIGN KEY (user_id) REFERENCESusers(id) ON DELETE CASCADE;-- -- Constraints for table
workspace_postsALTER TABLE
workspace_postsADD CONSTRAINTfk_workspace_posts_user_idFOREIGN KEY (user_id) REFERENCESusers(id) ON DELETE CASCADE; COMMIT;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;) i want to create if this order has paid or not yet, after creating the new order, add col, becuase some orders after delivered to customers, they haven't paid yet, so add as checkbox if paid or not, then i press on the paid, so the custoemr paid the order, so update the sql and update these codes (<?php // public/orders/view_order_customer.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 necessary functions require_once DIR . '/../../includes/auth.php'; require_once DIR . '/../../includes/db_connect.php'; require_once DIR . '/../../includes/functions.php'; // For sanitize_input()
// Now include the header after handling actions require_once DIR . '/../../includes/header.php';
// Helper Function: Generate WhatsApp link /**
-
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 digits = preg_replace('/\D+/', '', $contact);
// Assuming Kuwait country code (+965). Adjust as needed. if (substr(digits, 0, 3) !== '965') { digits = '965' . $digits; }
return "https://wa.me/" . $digits; }
// Helper Function: Format currency /**
- Format a number into currency format.
- @param float $amount The amount to format.
- @return string The formatted currency string. */ function format_currency(amount) { return "KWD " . number_format(amount, 2); }
// Initialize variables for messages error_message = '';
// Function to get day name from datetime function get_day_name(datetime) { if (datetime) { return date("l", strtotime($datetime)); } return 'N/A'; }
// Check if order_id is provided and valid _GET['order_id']) ? intval($_GET['order_id']) : 0;
if ($order_id <= 0) { header("Location: view_orders.php?error=6"); // Invalid order ID exit(); }
// Fetch order details along with customer information order_stmt = order_sql); if (!order_stmt) { die("Prepare failed: (" . conn->errno . ") " . htmlspecialchars(conn->error)); } order_stmt->bind_param("i", order_stmt->execute(); order_stmt->get_result(); order_result->fetch_assoc(); $order_stmt->close();
if (!$order) { header("Location: view_orders.php?error=7"); // Order not found exit(); }
// Handle Status Update Form Submission if (_SERVER['REQUEST_METHOD'] === 'POST' && isset(_POST['update_status'])) { // Sanitize and validate inputs _POST['status']) ? sanitize_input(allowed_statuses = ['Pending', 'In Progress', 'Completed', 'Delivered']; // Included 'In Progress'
if (in_array($new_status, $allowed_statuses)) { // If setting to 'Delivered', ensure delivery_datetime is set if ($new_status === 'Delivered' && empty($order['delivery_datetime'])) { $error_message = "Cannot set status to Delivered without a delivery date and time."; } else { // Prepare SQL to update status $update_sql = "UPDATE orders SET status = ? WHERE id = ?"; $update_stmt = $conn->prepare($update_sql); if ($update_stmt) { $update_stmt->bind_param("si", $new_status, $order_id); if ($update_stmt->execute()) { $success_message = "Order status updated successfully to '" . htmlspecialchars($new_status) . "'."; $order['status'] = $new_status; // Reflect change locally } else { $error_message = "Failed to update order status. Please try again."; } $update_stmt->close(); } else { $error_message = "Database error: " . htmlspecialchars($conn->error); } } } else { $error_message = "Invalid status selected."; }}
// Fetch order items with product details item_stmt = order_items_sql); if (!item_stmt) { die("Prepare failed: (" . conn->errno . ") " . htmlspecialchars(conn->error)); } item_stmt->bind_param("i", item_stmt->execute(); item_stmt->get_result(); item = order_items_result->fetch_assoc()) { order_items[] = item; } item_stmt->close();
// Calculate totals, including delivery fee and free shipping total_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($item); // Break reference
total_before_discounts - $total_discounts;
// Add delivery fee if free_shipping is not applied if (order['free_shipping'] == 0) { final_total += $order['delivery_fee']; } ?>
<!-- Google Fonts --> <link href="https://fonts.googleapis.com/css2?family=Inter:wght@400;600;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 (if needed in future) --> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- Custom Styles --> <style> :root { /* Primary Colors */ --background-color: #FFFFFF; /* Crisp White */ --light-grey: #F5F5F5; --medium-grey: #CCCCCC; --dark-grey: #333333; --charcoal: #374151; /* Updated to requested color */ /* 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.2); } /* Custom scrollbar for better UX */ ::-webkit-scrollbar { width: 8px; } ::-webkit-scrollbar-track { background: #f1f5f9; /* Tailwind's gray-100 */ } ::-webkit-scrollbar-thumb { background: #4b6584; /* Teal-500 */ border-radius: 4px; } ::-webkit-scrollbar-thumb:hover { background: #0d9488; /* Teal-600 */ } /* Global Styles */ body, html { font-family: 'Inter', sans-serif; background-color: var(--background-color); margin: 0; padding: 0; box-sizing: border-box; } .container-body { padding: 20px; max-width: 1200px; margin: 0 auto; } h1, h2, h3, h4, h5, p { margin: 0; } /* Welcome Section */ .welcome-section { background-color: var(--background-color); border-radius: 12px; box-shadow: var(--box-shadow); padding: 40px; text-align: center; margin-bottom: 40px; width: 100%; display: flex; flex-direction: column; align-items: center; } .welcome-section h3 { font-size: 32px; color: var(--primary-text); margin-bottom: 15px; display: flex; align-items: center; justify-content: center; } .welcome-section h3 .bi { margin-right: 10px; color: var(--accent-red); font-size: 36px; } .welcome-section hr { width: 120px; height: 6px; background-color: var(--accent-orange); /* Changed from var(--button-add-order) to var(--accent-orange) */ border: none; margin: 20px auto; border-radius: 3px; } /* Order Information Section */ .order-info-section { background-color: var(--background-color); border-radius: 12px; box-shadow: var(--box-shadow); padding: 35px; margin-bottom: 40px; display: flex; flex-direction: column; } .order-info-header { display: flex; align-items: center; margin-bottom: 25px; } .order-info-header .bi { font-size: 36px; color: var(--accent-red); margin-right: 15px; } .order-info-header h4 { font-size: 28px; color: var(--primary-text); font-weight: 700; } .order-info-content { display: flex; flex-wrap: wrap; gap: 20px; } .order-info-item { width: 50%; display: flex; align-items: center; } .order-info-item .bi { font-size: 24px; color: var(--accent-blue); margin-right: 12px; } .order-info-item .info-text { font-size: 18px; color: var(--primary-text); font-weight: 600; } /* Product Summary Section */ .product-summary-section { background-color: #f0f4f8; /* Subtle light background */ border-left: 6px solid var(--accent-teal); border-radius: 12px; padding: 30px; margin-bottom: 40px; box-shadow: var(--box-shadow); } .product-summary-section h4 { font-size: 24px; color: var(--accent-teal); margin-bottom: 20px; display: flex; align-items: center; } .product-summary-section h4 .bi { margin-right: 10px; color: var(--accent-teal); font-size: 28px; } .product-summary-list { display: flex; flex-wrap: wrap; gap: 20px; } .product-item { background-color: #fff; border: 1px solid #e0e0e0; border-radius: 8px; padding: 20px; width: calc(33.333% - 13.333px); box-shadow: var(--box-shadow); display: flex; align-items: flex-start; transition: transform 0.3s, box-shadow 0.3s; } .product-item:hover { transform: translateY(-5px); box-shadow: var(--hover-shadow); } .product-item .bi { font-size: 24px; color: var(--accent-soft-blue); margin-right: 15px; margin-top: 5px; } .product-details { flex-grow: 1; } .product-details p { font-size: 16px; margin-bottom: 8px; color: var(--primary-text); } .product-details p strong { color: var(--accent-teal); } /* Order Items Table Section */ .recent-orders-section { background-color: var(--background-color); border-radius: 12px; padding: 35px; box-shadow: var(--box-shadow); margin-bottom: 40px; } .recent-orders-section h4 { font-size: 24px; font-weight: 700; color: var(--primary-text); margin-bottom: 25px; } /* Make table responsive */ .table-responsive { overflow-x: auto; } .recent-orders-section table { width: 100%; border-collapse: collapse; min-width: 900px; } .recent-orders-section th, .recent-orders-section td { padding: 16px; text-align: center; font-size: 14px; vertical-align: middle; } .recent-orders-section th { background-color: var(--light-grey); color: var(--primary-text); font-weight: 700; position: sticky; top: 0; z-index: 1; } .recent-orders-section tr:nth-child(even) { background-color: #fafafa; } .recent-orders-section tr:hover { background-color: var(--light-grey); } .recent-orders-section td.number { text-align: center; } .recent-orders-section td.price, .recent-orders-section td.quantity, .recent-orders-section td.discount_percentage, .recent-orders-section td.discount_amount, .recent-orders-section td.total_after_discount { font-weight: 600; color: var(--primary-text); } /* Order Summary Section */ .total-section { text-align: right; margin-top: 25px; } .total-section p { font-size: 18px; color: var(--primary-text); margin-bottom: 10px; } .total-section p strong { font-size: 20px; color: var(--accent-blue); } /* Action Buttons */ .action-buttons { display: flex; gap: 20px; justify-content: flex-end; margin-bottom: 50px; flex-wrap: wrap; } .action-button { display: flex; align-items: center; justify-content: center; padding: 12px 20px; font-size: 16px; font-weight: 600; color: var(--background-color); border: none; border-radius: 8px; cursor: pointer; transition: transform 0.3s, box-shadow 0.3s; text-decoration: none; min-width: 180px; text-align: center; } .action-button.print-order { background-color: var(--accent-blue); } .action-button.edit-order { background-color: var(--accent-orange); } /* Updated to var(--accent-orange) */ .action-button.copy-order { background-color: var(--accent-teal); } .action-button:hover { transform: scale(1.05); box-shadow: var(--hover-shadow); } .action-button .bi { margin-right: 8px; font-size: 20px; } /* Footer Styles */ .footer { background-color: var(--charcoal); color: var(--background-color); padding: 20px; text-align: center; border-radius: 12px; font-size: 16px; line-height: 1.5; margin-top: 60px; box-shadow: var(--box-shadow); } /* Responsive Design Enhancements */ @media (max-width: 992px) { .product-item { width: calc(50% - 10px); } .welcome-section h3 { font-size: 28px; } .order-info-header h4 { font-size: 24px; } .order-info-item .bi { font-size: 20px; } .order-info-item .info-text { font-size: 16px; } .recent-orders-section th, .recent-orders-section td { padding: 12px; font-size: 14px; } .recent-orders-section h4 { font-size: 22px; } .action-button { font-size: 14px; padding: 10px 18px; min-width: 160px; } .action-button .bi { font-size: 18px; } /* Adjust Product Summary Items */ .product-item { width: 100%; } } @media (max-width: 576px) { .welcome-section h3 { font-size: 24px; } .welcome-section h3 .bi { font-size: 28px; } .order-info-header h4 { font-size: 22px; } .order-info-item .bi { font-size: 18px; } .order-info-item .info-text { font-size: 14px; } .recent-orders-section th, .recent-orders-section td { padding: 10px; font-size: 12px; } .recent-orders-section h4 { font-size: 20px; } .action-button { font-size: 14px; padding: 8px 16px; min-width: 140px; } .action-button .bi { font-size: 16px; } /* Adjust Product Summary Items */ .product-item { width: 100%; } } </style> <!-- Additional JavaScript for Print and Copy Functionality --> <script> // Function to print the order details function printOrder() { window.print(); } // Function to copy order details to clipboard function copyOrderDetails() { // Gather the required information const orderId = "<?= htmlspecialchars($order['order_id']) ?>"; const status = "<?= htmlspecialchars($order['status']) ?>"; const priority = "<?= htmlspecialchars($order['priority']) ?>"; const orderDate = "<?= date("l, d M Y, h:i A", strtotime($order['order_date'])) ?>"; const deliveryDateTime = "<?= get_day_name($order['delivery_datetime']) ?>, <?= $order['delivery_datetime'] ? date("l, d M Y, h:i A", strtotime($order['delivery_datetime'])) : 'N/A' ?>"; const customerName = "<?= htmlspecialchars($order['customer_name']) ?>"; const contactNumber = "<?= htmlspecialchars($order['contact']) ?>"; const deliveryAddress = "<?= nl2br(htmlspecialchars($order['delivery_address'])) ?>"; const deliveryFee = <?= htmlspecialchars($order['free_shipping']) == 1 ? '0.00' : htmlspecialchars($order['delivery_fee']) ?>; const freeShippingStatus = <?= htmlspecialchars($order['free_shipping']) == 1 ? '"Yes"' : '"No"' ?>; let productSummary = ''; document.querySelectorAll('.product-summary-item').forEach(function(item) { const productName = item.querySelector('.product-name').innerText; const productSize = item.querySelector('.product-size').innerText.replace('Size: ', ''); const productQuantityText = item.querySelector('.product-quantity').innerText.replace('Quantity: ', ''); const productQuantity = parseInt(productQuantityText); const packagingPreferencesElement = item.querySelector('.packaging-preferences'); const packagingPreferences = packagingPreferencesElement ? packagingPreferencesElement.innerText.replace('Packaging: ', '') : 'N/A'; if (!isNaN(productQuantity) && productQuantity > 1) { productSummary += `• Item: ${productQuantity} Boxes\n Size: ${productSize}\n Product: ${productName}\n Packaging: ${packagingPreferences}\n\n`; } else if (!isNaN(productQuantity) && productQuantity === 1) { productSummary += `• Item: ${productQuantity} Box\n Size: ${productSize}\n Product: ${productName}\n Packaging: ${packagingPreferences}\n\n`; } else { productSummary += `• Product: ${productName}\n Size: ${productSize}\n Packaging: ${packagingPreferences}\n\n`; } }); // Construct the formatted text const formattedText = `🔴 Order Details 🔴• Order ID: {status} • Priority: {orderDate} • Delivery Date & Time: {customerName}
📦 Product Summary: {deliveryAddress}
💰 Delivery Fee: KWD {freeShippingStatus} Shipping) 📞 Contact Number: ${contactNumber}`;
// Copy to clipboard using Clipboard API navigator.clipboard.writeText(formattedText).then(() => { alert('Order details copied to clipboard!'); }).catch(err => { alert('Failed to copy: ' + err); }); } </script><main class='container-body'> <!-- Welcome Section --> <div class="welcome-section"> <h3><i class="bi bi-box-seam-fill"></i> Order #<?= htmlspecialchars($order['order_id']) ?></h3> <hr> <!-- Copy Info Button Above HR --> <button class="btn btn-outline-secondary btn-sm mt-3" onclick="copyOrderDetails()"> <i class="bi bi-clipboard-fill"></i> Copy Order Info </button> </div> <!-- Display Success or Error Messages --> <?php if (!empty($success_message)): ?> <div class="alert alert-success alert-dismissible fade show" role="alert"> <?= htmlspecialchars($success_message) ?> <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button> </div> <?php endif; ?> <?php if (!empty($error_message)): ?> <div class="alert alert-danger alert-dismissible fade show" role="alert"> <?= htmlspecialchars($error_message) ?> <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button> </div> <?php endif; ?> <!-- Product Summary Section --> <div class="product-summary-section"> <h4><i class="bi bi-bag-fill"></i> Product Summary</h4> <div class="product-summary-list"> <?php foreach ($order_items as $item): ?> <?php if (strtolower($item['packaging_preferences']) !== 'n/a'): // Only display if Packaging Preferences is not 'N/A' ?> <div class="product-item d-flex align-items-start product-summary-item"> <i class="bi bi-box-seam-fill"></i> <div class="product-details"> <p class="product-name"><strong><?= htmlspecialchars($item['product_name']) ?></strong></p> <p class="product-size"><i class="bi bi-arrows-angle-contract"></i> Size: <?= htmlspecialchars($item['product_size']) ?></p> <p class="product-quantity"><i class="bi bi-people-fill"></i> Quantity: <?= htmlspecialchars($item['quantity']) ?></p> <p class="packaging-preferences"><i class="bi bi-box-seam-fill"></i> Packaging: <?= htmlspecialchars($item['packaging_preferences']) ?></p> </div> </div> <?php else: ?> <div class="product-item d-flex align-items-start product-summary-item"> <i class="bi bi-box-seam-fill"></i> <div class="product-details"> <p class="product-name"><strong><?= htmlspecialchars($item['product_name']) ?></strong></p> <p class="product-size"><i class="bi bi-arrows-angle-contract"></i> Size: <?= htmlspecialchars($item['product_size']) ?></p> <p class="product-quantity"><i class="bi bi-people-fill"></i> Quantity: <?= htmlspecialchars($item['quantity']) ?></p> <!-- Packaging Preferences not displayed if 'N/A' --> </div> </div> <?php endif; ?> <?php endforeach; ?> </div> </div> <!-- Order Information Section --> <div class="order-info-section"> <div class="order-info-header"> <i class="bi bi-info-circle-fill"></i> <h4>Order Information</h4> </div> <div class="order-info-content"> <!-- Status --> <div class="order-info-item"> <i class="bi bi-tag-fill"></i> <div class="info-text"> <form method="POST" action="" class="d-flex align-items-center"> <strong>Status:</strong> <select name="status" class="form-select form-select-lg ms-2 me-2 px-3 py-2 status-dropdown" style="width: auto;" aria-label="Order Status"> <?php $statuses = ['Pending', 'In Progress', 'Completed', 'Delivered']; // Included 'In Progress' foreach ($statuses as $status) { $selected = ($order['status'] === $status) ? 'selected' : ''; echo "<option value=\"{$status}\" {$selected}>{$status}</option>"; } ?> </select> <button type="submit" name="update_status" class="btn btn-primary btn-lg px-4"> <i class="bi bi-arrow-repeat"></i> Update </button> </form> </div> </div> <!-- Priority --> <div class="order-info-item"> <i class="bi bi-exclamation-triangle-fill"></i> <div class="info-text"><strong>Priority:</strong> <?= htmlspecialchars($order['priority']) ?></div> </div> <!-- Order Date --> <div class="order-info-item"> <i class="bi bi-calendar-event-fill"></i> <div class="info-text"><strong>Order Date:</strong> <?= date("l, d M Y, h:i A", strtotime($order['order_date'])) ?></div> </div> <!-- Delivery Date & Time --> <div class="order-info-item"> <i class="bi bi-clock-fill"></i> <div class="info-text delivery-date-time"><strong>Delivery Date & Time:</strong> <?= get_day_name($order['delivery_datetime']) ?>, <?= $order['delivery_datetime'] ? date("l, d M Y, h:i A", strtotime($order['delivery_datetime'])) : 'N/A' ?></div> </div> <!-- Customer Name --> <div class="order-info-item"> <i class="bi bi-person-fill"></i> <div class="info-text"><strong>Customer Name:</strong> <?= htmlspecialchars($order['customer_name']) ?></div> </div> <!-- Contact --> <div class="order-info-item"> <i class="bi bi-whatsapp"></i> <div class="info-text contact-info"><strong>Contact:</strong> <a href="<?= generate_whatsapp_link($order['contact']) ?>" target="_blank" class="d-inline-flex align-items-center text-decoration-none"> <i class="bi bi-whatsapp text-success"></i> <span class="ms-2"><?= htmlspecialchars($order['contact']) ?></span> </a> </div> </div> <!-- Delivery Address --> <div class="order-info-item"> <i class="bi bi-geo-alt-fill"></i> <div class="info-text delivery-address"> <strong>Delivery Address:</strong> <?= nl2br(htmlspecialchars($order['delivery_address'])) ?> </div> </div> <!-- Delivery Fee and Free Shipping --> <div class="order-info-item"> <i class="bi bi-cash-stack"></i> <div class="info-text"> <strong>Delivery Fee:</strong> <?= $order['free_shipping'] == 1 ? '<span style="color: var(--accent-green); font-weight:bold;">Free</span>' : format_currency($order['delivery_fee']) ?> </div> </div> </div> </div> <!-- Order Items Table Section --> <div class="recent-orders-section"> <h4>Order Items</h4> <div class="table-responsive"> <table class="table table-bordered"> <thead> <tr> <th>#</th> <th>Product</th> <th>Size</th> <th>Price per Unit (KWD)</th> <th>Quantity</th> <th>Packaging Preferences</th> <th>Discount (%)</th> <th>Discount Amount (KWD)</th> <th>Total (KWD)</th> </tr> </thead> <tbody> <?php foreach ($order_items as $index => $item): ?> <tr> <td class="number"><?= $index + 1 ?></td> <td><?= htmlspecialchars($item['product_name']) ?></td> <td><?= htmlspecialchars($item['product_size']) ?></td> <td class="price"><?= format_currency($item['product_price']) ?></td> <td class="quantity"><?= htmlspecialchars($item['quantity']) ?></td> <td><?= htmlspecialchars($item['packaging_preferences']) ?: 'N/A' ?></td> <td class="discount_percentage"><?= number_format($item['discount_percentage'], 2) ?>%</td> <td class="discount_amount"><?= format_currency($item['discount_amount']) ?></td> <td class="total_after_discount"><?= format_currency($item['total_after_discount']) ?></td> </tr> <?php endforeach; ?> </tbody> </table> </div> <!-- Order Summary --> <div class="total-section"> <p><strong>Total Before Discounts:</strong> <?= format_currency($total_before_discounts) ?></p> <p><strong>Total Discounts:</strong> <?= format_currency($total_discounts) ?></p> <?php if ($order['free_shipping'] == 0): ?> <p><strong>Delivery Fee:</strong> <?= format_currency($order['delivery_fee']) ?></p> <?php endif; ?> <hr> <p><strong>Final Total:</strong> <?= format_currency($final_total) ?></p> </div> </div> <!-- Action Buttons --> <div class="action-buttons"> <a href="edit_order.php?id=<?= htmlspecialchars($order['order_id']) ?>" class="action-button edit-order" style="color:white;"> <i class="bi bi-pencil-square"></i> Edit Order </a> <button class="action-button print-order" onclick="printOrder()"> <i class="bi bi-printer-fill"></i> Print Order </button> <button class="action-button copy-order" onclick="copyOrderDetails()"> <i class="bi bi-clipboard-fill"></i> Copy Order Details </button> </div> <!-- Footer --> <div class="footer"> © <?= date("Y") ?> 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 (if needed in future) --> <script src="https://cdn.jsdelivr.net/npm/flatpickr"></script> <!-- Bootstrap Tooltip Initialization (if using tooltips in future) --> <script> var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]')) var tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) { return new bootstrap.Tooltip(tooltipTriggerEl) }) </script>// Enable error reporting for debugging (disable in production) ini_set('display_errors', 0); // Set to 0 in production ini_set('display_startup_errors', 0); // Set to 0 in production error_reporting(E_ALL);
// Include necessary files require_once DIR . '/../../includes/auth.php'; require_once DIR . '/../../includes/db_connect.php';
// Function to sanitize input function sanitize_input(input) { return htmlspecialchars(trim(input), ENT_QUOTES, 'UTF-8'); }
// Initialize success and error variables error = '';
// Retrieve and sanitize the order ID from GET parameters _GET['id']) ? intval($_GET['id']) : 0;
// Redirect if no valid order ID is provided if ($order_id <= 0) { header("Location: view_orders.php?error=Invalid Order ID"); exit(); }
// Fetch order details along with customer information order_stmt = order_sql); if (!order_stmt) { die("Prepare statement failed: " . conn->error); } order_id); order_result = $order_stmt->get_result();
if ($order_result->num_rows != 1) { header("Location: view_orders.php?error=Order Not Found"); exit(); }
order_result->fetch_assoc(); $order_stmt->close();
// Fetch existing order items order_items_stmt = order_items_sql); if (!order_items_stmt) { die("Prepare statement failed: " . conn->error); } order_id); order_items_result = order_items = []; while (order_items_result->fetch_assoc()) { item; } $order_items_stmt->close();
// Fetch products for selection products_result = products_sql);
// Handle form submission for updating the order if (_SERVER['REQUEST_METHOD'] == 'POST') { // Retrieve and sanitize form inputs customer_name = sanitize_input(contact = sanitize_input(delivery_address = sanitize_input(status = sanitize_input(priority = sanitize_input(delivery_datetime = isset(_POST['delivery_datetime']) && !empty(_POST['delivery_datetime']) ? sanitize_input(delivery_date = isset(_POST['delivery_date']) && !empty(_POST['delivery_date']) ? sanitize_input($_POST['delivery_date']) : null;
// New fields based on database schema $delivery_fee = isset($_POST['delivery_fee']) && is_numeric($_POST['delivery_fee']) ? floatval($_POST['delivery_fee']) : 0.00; $free_shipping = isset($_POST['free_shipping']) ? 1 : 0; // If free shipping is selected, set delivery_fee to 0.00 if ($free_shipping) { $delivery_fee = 0.00; } // Handle existing order items $existing_item_ids = isset($_POST['existing_item_id']) ? $_POST['existing_item_id'] : []; $product_ids = isset($_POST['product_id']) ? $_POST['product_id'] : []; $quantities = isset($_POST['quantity']) ? $_POST['quantity'] : []; $packaging_preferences = isset($_POST['packaging_preferences']) ? $_POST['packaging_preferences'] : []; $discount_percentages = isset($_POST['discount_percentage']) ? $_POST['discount_percentage'] : []; $discount_reasons = isset($_POST['discount_reason']) ? $_POST['discount_reason'] : []; // Handle new order items $new_product_ids = isset($_POST['new_product_id']) ? $_POST['new_product_id'] : []; $new_quantities = isset($_POST['new_quantity']) ? $_POST['new_quantity'] : []; $new_packaging_preferences = isset($_POST['new_packaging_preferences']) ? $_POST['new_packaging_preferences'] : []; $new_discount_percentages = isset($_POST['new_discount_percentage']) ? $_POST['new_discount_percentage'] : []; $new_discount_reasons = isset($_POST['new_discount_reason']) ? $_POST['new_discount_reason'] : []; // Basic validation if (empty($customer_name)) { $error = "Customer name is required."; } elseif (empty($status)) { $error = "Order status is required."; } elseif (empty($priority)) { $error = "Order priority is required."; } elseif ((empty($existing_item_ids) && empty($new_product_ids))) { $error = "At least one product must be selected."; } else { // Validate each existing product entry foreach ($existing_item_ids as $index => $item_id) { if (empty($product_ids[$index])) { $error = "Product selection is required for all existing items."; break; } if (intval($quantities[$index]) <= 0) { $error = "Quantity must be at least 1 for all existing items."; break; } if ($discount_percentages[$index] !== '' && (floatval($discount_percentages[$index]) < 0 || floatval($discount_percentages[$index]) > 100)) { $error = "Discount percentage must be between 0 and 100."; break; } } // Validate new product entries foreach ($new_product_ids as $index => $pid) { if (!empty($pid)) { if (intval($new_quantities[$index]) <= 0) { $error = "Quantity must be at least 1 for all new items."; break; } if ($new_discount_percentages[$index] !== '' && (floatval($new_discount_percentages[$index]) < 0 || floatval($new_discount_percentages[$index]) > 100)) { $error = "Discount percentage must be between 0 and 100 for all new items."; break; } } } if ($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 ($delivery_date && strtotime($delivery_date) < strtotime(date('Y-m-d'))) { $error = "Delivery date cannot be in the past."; } } if (empty($error)) { // Start transaction $conn->begin_transaction(); try { // Update customer details $stmt = $conn->prepare("UPDATE customers SET name = ?, contact = ?, delivery_address = ? WHERE id = ?"); if (!$stmt) { throw new Exception("Prepare statement failed: " . $conn->error); } $stmt->bind_param("sssi", $customer_name, $contact, $delivery_address, $order['customer_id']); if (!$stmt->execute()) { throw new Exception("Execute failed: " . $stmt->error); } $stmt->close(); // Update orders table with new fields $stmt = $conn->prepare("UPDATE orders SET status = ?, priority = ?, delivery_datetime = ?, delivery_date = ?, delivery_fee = ?, free_shipping = ? WHERE id = ?"); if (!$stmt) { throw new Exception("Prepare statement failed: " . $conn->error); } $stmt->bind_param("ssssdii", $status, $priority, $delivery_datetime, $delivery_date, $delivery_fee, $free_shipping, $order_id); if (!$stmt->execute()) { throw new Exception("Execute failed: " . $stmt->error); } $stmt->close(); // Update existing order items foreach ($existing_item_ids as $index => $item_id) { $item_id = intval($item_id); $pid = intval($product_ids[$index]); $qty = intval($quantities[$index]); $pack_pref = sanitize_input($packaging_preferences[$index]); $discount_pct = $discount_percentages[$index] !== '' ? floatval($discount_percentages[$index]) : 0.00; $discount_rsn = sanitize_input($discount_reasons[$index]); $stmt = $conn->prepare("UPDATE order_items SET product_id = ?, quantity = ?, packaging_preferences = ?, discount_percentage = ?, discount_reason = ? WHERE id = ?"); if (!$stmt) { throw new Exception("Prepare statement failed: " . $conn->error); } $stmt->bind_param("iisdsi", $pid, $qty, $pack_pref, $discount_pct, $discount_rsn, $item_id); if (!$stmt->execute()) { throw new Exception("Execute failed: " . $stmt->error); } $stmt->close(); } // Insert new order items $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); } for ($i = 0; $i < count($new_product_ids); $i++) { $new_pid = intval($new_product_ids[$i]); $new_qty = intval($new_quantities[$i]); $new_pack_pref = sanitize_input($new_packaging_preferences[$i]); $new_discount_pct = $new_discount_percentages[$i] !== '' ? floatval($new_discount_percentages[$i]) : 0.00; $new_discount_rsn = sanitize_input($new_discount_reasons[$i]); if (!empty($new_pid)) { $stmt->bind_param("iiidsi", $order_id, $new_pid, $new_qty, $new_pack_pref, $new_discount_pct, $new_discount_rsn); if (!$stmt->execute()) { throw new Exception("Execute failed: " . $stmt->error); } } } $stmt->close(); // Commit transaction $conn->commit(); $success = "Order updated successfully!"; // Refresh order data // Fetch updated order items $order_items_sql = "SELECT oi.*, p.name AS product_name, p.size, p.price FROM order_items oi JOIN products p ON oi.product_id = p.id WHERE oi.order_id = ?"; $order_items_stmt = $conn->prepare($order_items_sql); if (!$order_items_stmt) { throw new Exception("Prepare statement failed: " . $conn->error); } $order_items_stmt->bind_param("i", $order_id); $order_items_stmt->execute(); $order_items_result = $order_items_stmt->get_result(); $order_items = []; while ($item = $order_items_result->fetch_assoc()) { $order_items[] = $item; } $order_items_stmt->close(); } catch (Exception $e) { // Rollback transaction $conn->rollback(); $error = "Error updating order: " . sanitize_input($e->getMessage()); } }} ?>
<!-- Google Fonts --> <link href="https://fonts.googleapis.com/css2?family=Inter:wght@400;600;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"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- Custom Styles --> <style> :root { /* Primary Colors */ --background-color: #FFFFFF; /* Crisp White */ --light-grey: #F5F5F5; --medium-grey: #CCCCCC; --dark-grey: #333333; --charcoal: #374151; /* Updated to requested color */ /* 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.2); /* 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; } /* Custom scrollbar for better UX */ ::-webkit-scrollbar { width: 8px; } ::-webkit-scrollbar-track { background: #f1f5f9; /* Tailwind's gray-100 */ } ::-webkit-scrollbar-thumb { background: #4b6584; /* Teal-500 */ border-radius: 4px; } ::-webkit-scrollbar-thumb:hover { background: #0d9488; /* Teal-600 */ } /* Global Styles */ body, html { font-family: 'Inter', sans-serif; background-color: var(--background-color); margin: 0; padding: 0; box-sizing: border-box; } .container-body { padding: 20px; max-width: 1200px; margin: 0 auto; } h1, h2, h3, h4, h5, p { margin: 0; } /* Header Styles */ .header { padding: 20px 30px; background-color: var(--charcoal); border-radius: 12px; display: flex; align-items: center; justify-content: center; margin-bottom: 30px; box-shadow: var(--box-shadow); } .header h1 { color: var(--background-color); font-size: 28px; font-weight: 700; } /* Container Styles */ .container-custom { max-width: 1000px; margin: auto; background-color: var(--background-color); padding: 40px; border: 1px solid var(--medium-grey); border-radius: var(--box-border-radius); box-shadow: var(--box-shadow); } /* Success and Error Alerts */ .alert-custom { border-radius: var(--box-border-radius); padding: 20px 25px; margin-bottom: 30px; text-align: center; font-size: 18px; font-weight: 600; } .alert-success-custom { background-color: var(--accent-green); color: var(--background-color); } .alert-danger-custom { background-color: var(--accent-red); color: var(--background-color); } /* Form Styles */ .form-label { font-weight: 600; color: var(--primary-text); font-size: 16px; } .form-control { background-color: #F9F9F9; border: 1px solid var(--input-border); border-radius: 8px; padding: 12px 16px; transition: border-color 0.3s, box-shadow 0.3s; font-size: 16px; } .form-control:focus { border-color: var(--input-focus-border); box-shadow: 0 0 5px rgba(32, 178, 170, 0.5); background-color: var(--background-color); } .btn-primary-custom { background-color: var(--button-add-order); border: none; color: var(--background-color); padding: 12px 24px; font-size: 16px; font-weight: 600; border-radius: 8px; transition: background-color 0.3s, transform 0.3s; cursor: pointer; } .btn-primary-custom:hover { background-color: #5750d3; transform: scale(1.05); } .btn-secondary-custom { background-color: var(--accent-soft-blue); border: none; color: var(--primary-text); padding: 12px 24px; font-size: 16px; font-weight: 600; border-radius: 8px; transition: background-color 0.3s, transform 0.3s; cursor: pointer; text-decoration: none; display: inline-block; } .btn-secondary-custom:hover { background-color: #8AB6D6; transform: scale(1.05); } .remove-product-button { background-color: var(--accent-red); color: var(--background-color); border: none; border-radius: 50%; width: 35px; height: 35px; cursor: pointer; transition: background-color 0.3s, transform 0.3s; font-size: 18px; font-weight: bold; display: flex; align-items: center; justify-content: center; } .remove-product-button:hover { background-color: #e63946; transform: scale(1.1); } /* Footer Styles */ .footer { background-color: var(--charcoal); color: var(--background-color); padding: 20px; text-align: center; border-radius: 12px; font-size: 16px; line-height: 1.5; margin-top: 40px; box-shadow: var(--box-shadow); } /* Responsive Design Enhancements */ @media (max-width: 768px) { .container-custom { padding: 30px; } .btn { width: 100%; margin-bottom: 10px; } .remove-product-button { width: 30px; height: 30px; } } @media (max-width: 480px) { .header { padding: 15px 20px; } .header h1 { font-size: 24px; } .form-label { font-size: 14px; } .form-control { padding: 10px 12px; font-size: 14px; } .btn-primary-custom, .btn-secondary-custom { font-size: 14px; padding: 10px 18px; } .footer { font-size: 14px; } } </style> <!-- Additional JavaScript for dynamic product addition and form enhancements --> <script> function addOrderItemRow() { const orderItemsContainer = document.getElementById('order-items-container'); const itemCount = orderItemsContainer.children.length; const orderItemRow = document.createElement('div'); orderItemRow.className = 'order-item-row border p-4 mb-4 shadow-sm'; orderItemRow.style.borderRadius = '12px'; orderItemRow.innerHTML = ` <div class="row g-3"> <div class="col-md-4"> <label class="form-label" for="new_product_id_${itemCount}">Product <span class="text-danger">*</span></label> <select name="new_product_id[]" id="new_product_id_${itemCount}" 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="new_quantity_${itemCount}">Quantity <span class="text-danger">*</span></label> <input type="number" name="new_quantity[]" id="new_quantity_${itemCount}" class="form-control" min="1" value="1" required> </div> <div class="col-md-3"> <label class="form-label" for="new_packaging_preferences_${itemCount}">Packaging Preferences</label> <input type="text" name="new_packaging_preferences[]" id="new_packaging_preferences_${itemCount}" class="form-control" placeholder="e.g., Gift Wrap"> </div> <div class="col-md-2"> <label class="form-label" for="new_discount_percentage_${itemCount}">Discount (%)</label> <input type="number" name="new_discount_percentage[]" id="new_discount_percentage_${itemCount}" class="form-control" min="0" max="100" step="0.01" value="0.00"> </div> <div class="col-md-1 d-flex align-items-end"> <button type="button" class="remove-product-button" onclick="removeOrderItemRow(this)" title="Remove Product">✕</button> </div> </div> <div class="row mt-3"> <div class="col-md-12"> <label class="form-label" for="new_discount_reason_${itemCount}">Discount Reason</label> <input type="text" name="new_discount_reason[]" id="new_discount_reason_${itemCount}" class="form-control" placeholder="e.g., Seasonal Sale"> </div> </div> `; orderItemsContainer.appendChild(orderItemRow); } function removeOrderItemRow(button) { const orderItemRow = button.closest('.order-item-row'); orderItemRow.remove(); } function removeExistingOrderItemRow(button) { const orderItemRow = button.closest('.order-item-row'); // Optionally, implement functionality to handle backend deletion if necessary // For simplicity, we'll remove it directly orderItemRow.remove(); // To handle deletion in backend, you'd need to track removed IDs and delete them from database // This requires additional implementation } // Function to toggle delivery fee input based on free shipping checkbox function toggleDeliveryFee() { const freeShippingCheckbox = document.getElementById('free_shipping'); const deliveryFeeInput = document.getElementById('delivery_fee'); if (freeShippingCheckbox.checked) { deliveryFeeInput.value = '0.00'; deliveryFeeInput.disabled = true; } else { deliveryFeeInput.disabled = false; } } // Initialize on page load document.addEventListener('DOMContentLoaded', function() { const freeShippingCheckbox = document.getElementById('free_shipping'); if (freeShippingCheckbox) { freeShippingCheckbox.addEventListener('change', toggleDeliveryFee); // Initial toggle based on current state toggleDeliveryFee(); } }); </script><!-- Header --> <div class="header"> <h1>Kaak Alia Management System</h1> </div> <!-- Container --> <div class="container-custom"> <h3 class="mb-5">Edit Order #<?= htmlspecialchars($order_id) ?></h3> <!-- Display Success or Error Messages --> <?php if (!empty($success)): ?> <div class="alert alert-custom alert-success-custom"><?= htmlspecialchars($success) ?></div> <?php endif; ?> <?php if (!empty($error)): ?> <div class="alert alert-custom alert-danger-custom"><?= htmlspecialchars($error) ?></div> <?php endif; ?> <!-- Edit Order Form --> <form method="POST" action=""> <!-- Customer Details --> <div class="mb-5"> <h5 class="mb-4">Customer Details</h5> <div class="row g-4"> <div class="col-md-6"> <label class="form-label" for="customer_name">Customer Name <span class="text-danger">*</span></label> <input type="text" id="customer_name" name="customer_name" class="form-control" value="<?= htmlspecialchars(isset($_POST['customer_name']) ? $_POST['customer_name'] : $order['customer_name']) ?>" required> </div> <div class="col-md-6"> <label class="form-label" for="contact">Contact</label> <input type="text" id="contact" name="contact" class="form-control" value="<?= htmlspecialchars(isset($_POST['contact']) ? $_POST['contact'] : $order['customer_contact']) ?>"> </div> </div> <div class="mt-4"> <label class="form-label" for="delivery_address">Delivery Address</label> <textarea id="delivery_address" name="delivery_address" class="form-control" rows="3"><?= htmlspecialchars(isset($_POST['delivery_address']) ? $_POST['delivery_address'] : $order['delivery_address']) ?></textarea> </div> </div> <hr> <!-- Order Details --> <div class="mb-5"> <h5 class="mb-4">Order Details</h5> <div class="row g-4"> <div class="col-md-3"> <label class="form-label" for="status">Status <span class="text-danger">*</span></label> <select name="status" id="status" class="form-control" required> <option value="">Select Status</option> <option value="Pending" <?= (isset($_POST['status']) ? $_POST['status'] : $order['status']) == 'Pending' ? 'selected' : '' ?>>Pending</option> <option value="In Progress" <?= (isset($_POST['status']) ? $_POST['status'] : $order['status']) == 'In Progress' ? 'selected' : '' ?>>In Progress</option> <option value="Completed" <?= (isset($_POST['status']) ? $_POST['status'] : $order['status']) == 'Completed' ? 'selected' : '' ?>>Completed</option> <option value="Delivered" <?= (isset($_POST['status']) ? $_POST['status'] : $order['status']) == 'Delivered' ? 'selected' : '' ?>>Delivered</option> </select> </div> <div class="col-md-3"> <label class="form-label" for="priority">Priority <span class="text-danger">*</span></label> <select name="priority" id="priority" class="form-control" required> <option value="">Select Priority</option> <option value="Normal" <?= (isset($_POST['priority']) ? $_POST['priority'] : $order['priority']) == 'Normal' ? 'selected' : '' ?>>Normal</option> <option value="Important" <?= (isset($_POST['priority']) ? $_POST['priority'] : $order['priority']) == 'Important' ? 'selected' : '' ?>>Important</option> <option value="Quick" <?= (isset($_POST['priority']) ? $_POST['priority'] : $order['priority']) == 'Quick' ? 'selected' : '' ?>>Quick</option> </select> </div> <div class="col-md-3"> <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']) : ($order['delivery_datetime'] ? date('Y-m-d\TH:i', strtotime($order['delivery_datetime'])) : '') ?>"> </div> <div class="col-md-3"> <label class="form-label" for="delivery_date">Delivery Date</label> <input type="date" id="delivery_date" name="delivery_date" class="form-control" value="<?= isset($_POST['delivery_date']) ? htmlspecialchars($_POST['delivery_date']) : ($order['delivery_date'] ? date('Y-m-d', strtotime($order['delivery_date'])) : '') ?>"> </div> </div> <div class="row g-4 mt-3"> <div class="col-md-4"> <label class="form-label" for="delivery_fee">Delivery Fee (KD) <span class="text-danger" id="delivery_fee_required">*</span></label> <input type="number" step="0.01" id="delivery_fee" name="delivery_fee" class="form-control" min="0" value="<?= isset($_POST['delivery_fee']) ? htmlspecialchars($_POST['delivery_fee']) : number_format($order['delivery_fee'], 2, '.', '') ?>" <?= isset($_POST['free_shipping']) || $order['free_shipping'] ? 'disabled' : 'required' ?>> </div> <div class="col-md-4 d-flex align-items-end"> <div class="form-check"> <input class="form-check-input" type="checkbox" value="1" id="free_shipping" name="free_shipping" <?= (isset($_POST['free_shipping']) && $_POST['free_shipping']) || $order['free_shipping'] ? 'checked' : '' ?>> <label class="form-check-label" for="free_shipping"> Free Shipping </label> </div> </div> </div> </div> <hr> <!-- Existing Order Items --> <div class="mb-5"> <h5 class="mb-4">Existing Order Items</h5> <div id="existing-order-items-container"> <?php foreach ($order_items as $item): ?> <div class="order-item-row border p-4 mb-4 shadow-sm" style="border-radius: 12px;"> <input type="hidden" name="existing_item_id[]" value="<?= htmlspecialchars($item['id']) ?>"> <div class="row g-3"> <div class="col-md-4"> <label class="form-label" for="product_id_<?= htmlspecialchars($item['id']) ?>">Product <span class="text-danger">*</span></label> <select name="product_id[]" id="product_id_<?= htmlspecialchars($item['id']) ?>" 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']) ?>" <?= ($product['id'] == $item['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_<?= htmlspecialchars($item['id']) ?>">Quantity <span class="text-danger">*</span></label> <input type="number" name="quantity[]" id="quantity_<?= htmlspecialchars($item['id']) ?>" class="form-control" min="1" value="<?= htmlspecialchars($item['quantity']) ?>" required> </div> <div class="col-md-3"> <label class="form-label" for="packaging_preferences_<?= htmlspecialchars($item['id']) ?>">Packaging Preferences</label> <input type="text" name="packaging_preferences[]" id="packaging_preferences_<?= htmlspecialchars($item['id']) ?>" class="form-control" placeholder="e.g., Gift Wrap" value="<?= htmlspecialchars($item['packaging_preferences']) ?>"> </div> <div class="col-md-2"> <label class="form-label" for="discount_percentage_<?= htmlspecialchars($item['id']) ?>">Discount (%)</label> <input type="number" name="discount_percentage[]" id="discount_percentage_<?= htmlspecialchars($item['id']) ?>" class="form-control" min="0" max="100" step="0.01" value="<?= htmlspecialchars($item['discount_percentage']) ?>"> </div> <div class="col-md-1 d-flex align-items-end"> <button type="button" class="remove-product-button" onclick="removeExistingOrderItemRow(this)" title="Remove Product">✕</button> </div> </div> <div class="row mt-3"> <div class="col-md-12"> <label class="form-label" for="discount_reason_<?= htmlspecialchars($item['id']) ?>">Discount Reason</label> <input type="text" name="discount_reason[]" id="discount_reason_<?= htmlspecialchars($item['id']) ?>" class="form-control" placeholder="e.g., Seasonal Sale" value="<?= htmlspecialchars($item['discount_reason']) ?>"> </div> </div> </div> <?php endforeach; ?> </div> </div> <hr> <!-- Add New Order Items --> <div class="mb-5"> <h5 class="mb-4">Add New Order Items</h5> <div id="order-items-container"> <!-- New Order Item Rows will be added here --> </div> <button type="button" class="btn btn-secondary-custom mt-3" onclick="addOrderItemRow()"> <i class="bi bi-plus-circle-fill"></i> Add Another Product </button> </div> <!-- Submit Buttons --> <div class="d-flex justify-content-between mt-4"> <button type="submit" class="btn-primary-custom">Update Order</button> <a href="view_orders.php" class="btn-secondary-custom">Cancel</a> </div> </form> </div> <!-- Footer --> <div class="footer"> © <?= date("Y") ?> Kaak Alia Bakery. All rights reserved. </div> <!-- 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 (if using tooltips in future) --> <script> var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]')) var tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) { return new bootstrap.Tooltip(tooltipTriggerEl) }) </script> <!-- Custom JS for Print and Copy Functionality --> <script> function printOrder() { window.print(); } function copyOrderDetails() { // Gather the required information const orderId = "<?= htmlspecialchars($order['id']) ?>"; const status = "<?= htmlspecialchars($order['status']) ?>"; const priority = "<?= htmlspecialchars($order['priority']) ?>"; const orderDate = "<?= date("l, d M Y, h:i A", strtotime($order['order_date'])) ?>"; const deliveryDateTime = "<?= $order['delivery_datetime'] ? date("l, d M Y, h:i A", strtotime($order['delivery_datetime'])) : 'N/A' ?>"; const customerName = "<?= htmlspecialchars($order['customer_name']) ?>"; const contactNumber = "<?= htmlspecialchars($order['customer_contact']) ?>"; const deliveryAddress = "<?= nl2br(htmlspecialchars($order['delivery_address'])) ?>"; const deliveryFee = <?= htmlspecialchars($order['free_shipping']) == 1 ? '0.00' : htmlspecialchars($order['delivery_fee']) ?>; const freeShippingStatus = <?= htmlspecialchars($order['free_shipping']) == 1 ? '"Yes"' : '"No"' ?>; let productSummary = ''; document.querySelectorAll('.order-item-row').forEach(function(item) { const productName = item.querySelector('.product-name').innerText; const productSize = item.querySelector('.product-size').innerText.replace('Size: ', ''); const productQuantityText = item.querySelector('.product-quantity').innerText.replace('Quantity: ', ''); const productQuantity = parseInt(productQuantityText); const packagingPreferences = item.querySelector('.packaging_preferences') ? item.querySelector('.packaging_preferences').innerText.replace('Packaging: ', '') : 'N/A'; const discountPercentage = item.querySelector('.discount_percentage') ? item.querySelector('.discount_percentage').innerText.replace('%', '') : '0.00'; if (!isNaN(productQuantity) && productQuantity > 1) { productSummary += `• Item: ${productQuantity} Boxes\n Size: ${productSize}\n Product: ${productName}\n Packaging: ${packagingPreferences}\n Discount: ${discountPercentage}%\n\n`; } else if (!isNaN(productQuantity) && productQuantity === 1) { productSummary += `• Item: ${productQuantity} Box\n Size: ${productSize}\n Product: ${productName}\n Packaging: ${packagingPreferences}\n Discount: ${discountPercentage}%\n\n`; } else { productSummary += `• Product: ${productName}\n Size: ${productSize}\n Packaging: ${packagingPreferences}\n Discount: ${discountPercentage}%\n\n`; } }); // Construct the formatted text const formattedText = `🔴 Order Details 🔴• Order ID: {status} • Priority: {orderDate} • Delivery Date & Time: {customerName}
📦 Product Summary: {deliveryAddress}
💰 Delivery Fee: KWD {freeShippingStatus} Shipping) 📞 Contact Number: ${contactNumber}`;
// Copy to clipboard using Clipboard API navigator.clipboard.writeText(formattedText).then(() => { alert('Order details copied to clipboard!'); }).catch(err => { alert('Failed to copy: ' + err); }); } </script> -
- Assistant
To accommodate the requirement of tracking whether an order has been paid, we need to make the following changes:
- Update the Database Schema:
- Add a new column
is_paidto theorderstable.
- Add a new column
- Modify
view_order_customer.php:- Display a checkbox indicating the payment status.
- Handle the checkbox submission to update the
is_paidstatus in the database.
- Modify
edit_order.php:- Include an option to mark the order as paid or not.
- Ensure the
is_paidstatus can be updated during order edits.
Below are the detailed steps and the complete code modifications required.
1. Update the Database Schema
Add
is_paidColumn to theordersTableWe'll add a new column named
is_paidto theorderstable. This column will be of typeTINYINT(1), where0represents "Not Paid" and1represents "Paid". By default, it will be set to0(Not Paid).SQL Statement:
-- Add 'is_paid' column to 'orders' table ALTER TABLE `orders` ADD COLUMN `is_paid` TINYINT(1) NOT NULL DEFAULT 0 AFTER `free_shipping`;Explanation:
- Column Name:
is_paid - Data Type:
TINYINT(1)— Suitable for boolean-like data (0or1). - Default Value:
0— Indicates that the order is not paid by default. - Positioning: Placed after the
free_shippingcolumn for logical grouping.
Full Updated SQL Dump Snippet (Including the New Column):
-- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` int(11) NOT NULL, `customer_id` int(11) NOT NULL, `status` enum('Pending','In Progress','Completed','Delivered') DEFAULT 'Pending', `priority` enum('Normal','Important','Quick') DEFAULT 'Normal', `order_date` datetime DEFAULT current_timestamp(), `delivery_datetime` datetime DEFAULT NULL, `delivery_date` date DEFAULT NULL, `delivery_fee` decimal(10,2) NOT NULL DEFAULT 0.00, `free_shipping` tinyint(1) NOT NULL DEFAULT 0, `is_paid` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Indexes for dumped tables -- -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`), ADD KEY `customer_id` (`customer_id`), ADD KEY `idx_orders_customer_id` (`customer_id`); -- ... -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- ... -- -- Constraints for dumped tables -- -- -- Constraints for table `orders` -- ALTER TABLE `orders` ADD CONSTRAINT `fk_orders_customer_id` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE;Note: After executing the above
ALTER TABLEstatement, ensure that your application logic and any existing data integrity are maintained.
2. Modify
view_order_customer.phpOverview of Changes
- Fetch
is_paidStatus:- Retrieve the
is_paidstatus along with other order details.
- Retrieve the
- Display Checkbox:
- Show a checkbox indicating whether the order is paid.
- Handle Checkbox Submission:
- Update the
is_paidstatus in the database when the checkbox is toggled.
- Update the
Updated
view_order_customer.php<?php // public/orders/view_order_customer.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 necessary functions require_once __DIR__ . '/../../includes/auth.php'; require_once __DIR__ . '/../../includes/db_connect.php'; require_once __DIR__ . '/../../includes/functions.php'; // For sanitize_input() // Now include the header after handling actions require_once __DIR__ . '/../../includes/header.php'; // Helper Function: Generate WhatsApp link /** * 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 $digits = preg_replace('/\D+/', '', $contact); // Assuming Kuwait country code (+965). Adjust as needed. if (substr($digits, 0, 3) !== '965') { $digits = '965' . $digits; } return "https://wa.me/" . $digits; } // Helper Function: Format currency /** * Format a number into currency format. * * @param float $amount The amount to format. * @return string The formatted currency string. */ function format_currency($amount) { return "KWD " . number_format($amount, 2); } // Initialize variables for messages $success_message = ''; $error_message = ''; // Function to get day name from datetime function get_day_name($datetime) { if ($datetime) { return date("l", strtotime($datetime)); } return 'N/A'; } // Check if order_id is provided and valid $order_id = isset($_GET['order_id']) ? intval($_GET['order_id']) : 0; if ($order_id <= 0) { header("Location: view_orders.php?error=6"); // Invalid order ID exit(); } // Fetch order details along with customer information and is_paid status $order_sql = " SELECT orders.id AS order_id, orders.status, orders.priority, orders.order_date, orders.delivery_datetime, orders.delivery_fee, orders.free_shipping, orders.is_paid, customers.name AS customer_name, customers.contact, customers.delivery_address FROM orders JOIN customers ON orders.customer_id = customers.id WHERE orders.id = ? "; $order_stmt = $conn->prepare($order_sql); if (!$order_stmt) { die("Prepare failed: (" . $conn->errno . ") " . htmlspecialchars($conn->error)); } $order_stmt->bind_param("i", $order_id); $order_stmt->execute(); $order_result = $order_stmt->get_result(); $order = $order_result->fetch_assoc(); $order_stmt->close(); if (!$order) { header("Location: view_orders.php?error=7"); // Order not found exit(); } // Handle Status Update Form Submission if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_status'])) { // Sanitize and validate inputs $new_status = isset($_POST['status']) ? sanitize_input($_POST['status']) : ''; $allowed_statuses = ['Pending', 'In Progress', 'Completed', 'Delivered']; // Included 'In Progress' if (in_array($new_status, $allowed_statuses)) { // If setting to 'Delivered', ensure delivery_datetime is set if ($new_status === 'Delivered' && empty($order['delivery_datetime'])) { $error_message = "Cannot set status to Delivered without a delivery date and time."; } else { // Prepare SQL to update status $update_sql = "UPDATE orders SET status = ? WHERE id = ?"; $update_stmt = $conn->prepare($update_sql); if ($update_stmt) { $update_stmt->bind_param("si", $new_status, $order_id); if ($update_stmt->execute()) { $success_message = "Order status updated successfully to '" . htmlspecialchars($new_status) . "'."; $order['status'] = $new_status; // Reflect change locally } else { $error_message = "Failed to update order status. Please try again."; } $update_stmt->close(); } else { $error_message = "Database error: " . htmlspecialchars($conn->error); } } } else { $error_message = "Invalid status selected."; } } // Handle Payment Status Update if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_payment'])) { // Sanitize and validate inputs // Expecting 'is_paid' to be present if checked $is_paid = isset($_POST['is_paid']) ? 1 : 0; // Prepare SQL to update payment status $update_payment_sql = "UPDATE orders SET is_paid = ? WHERE id = ?"; $update_payment_stmt = $conn->prepare($update_payment_sql); if ($update_payment_stmt) { $update_payment_stmt->bind_param("ii", $is_paid, $order_id); if ($update_payment_stmt->execute()) { if ($is_paid) { $success_message = "Order marked as <strong>Paid</strong> successfully."; } else { $success_message = "Order marked as <strong>Not Paid</strong> successfully."; } $order['is_paid'] = $is_paid; // Reflect change locally } else { $error_message = "Failed to update payment status. Please try again."; } $update_payment_stmt->close(); } else { $error_message = "Database error: " . htmlspecialchars($conn->error); } } // Fetch order items with product details $order_items_sql = " SELECT order_items.id AS item_id, order_items.product_id, order_items.quantity, order_items.packaging_preferences, order_items.discount_percentage, order_items.discount_reason, products.name AS product_name, products.size AS product_size, products.price AS product_price FROM order_items JOIN products ON order_items.product_id = products.id WHERE order_items.order_id = ? "; $item_stmt = $conn->prepare($order_items_sql); if (!$item_stmt) { die("Prepare failed: (" . $conn->errno . ") " . htmlspecialchars($conn->error)); } $item_stmt->bind_param("i", $order_id); $item_stmt->execute(); $order_items_result = $item_stmt->get_result(); $order_items = []; while ($item = $order_items_result->fetch_assoc()) { $order_items[] = $item; } $item_stmt->close(); // Calculate totals, including delivery fee and 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 free_shipping is not applied if ($order['free_shipping'] == 0) { $final_total += $order['delivery_fee']; } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Order #<?= htmlspecialchars($order['order_id']) ?> Details - Kaak Alia Management System</title> <!-- Google Fonts --> <link href="https://fonts.googleapis.com/css2?family=Inter:wght@400;600;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 (if needed in future) --> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/flatpickr/dist/flatpickr.min.css"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- Custom Styles --> <style> /* (Same CSS as provided by the user or adjust as needed) */ :root { /* Primary Colors */ --background-color: #FFFFFF; /* Crisp White */ --light-grey: #F5F5F5; --medium-grey: #CCCCCC; --dark-grey: #333333; --charcoal: #374151; /* Updated to requested color */ /* 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.2); } /* Custom scrollbar for better UX */ ::-webkit-scrollbar { width: 8px; } ::-webkit-scrollbar-track { background: #f1f5f9; /* Tailwind's gray-100 */ } ::-webkit-scrollbar-thumb { background: #4b6584; /* Teal-500 */ border-radius: 4px; } ::-webkit-scrollbar-thumb:hover { background: #0d9488; /* Teal-600 */ } /* Global Styles */ body, html { font-family: 'Inter', sans-serif; background-color: var(--background-color); margin: 0; padding: 0; box-sizing: border-box; } .container-body { padding: 20px; max-width: 1200px; margin: 0 auto; } h1, h2, h3, h4, h5, p { margin: 0; } /* Welcome Section */ .welcome-section { background-color: var(--background-color); border-radius: 12px; box-shadow: var(--box-shadow); padding: 40px; text-align: center; margin-bottom: 40px; width: 100%; display: flex; flex-direction: column; align-items: center; } .welcome-section h3 { font-size: 32px; color: var(--primary-text); margin-bottom: 15px; display: flex; align-items: center; justify-content: center; } .welcome-section h3 .bi { margin-right: 10px; color: var(--accent-red); font-size: 36px; } .welcome-section hr { width: 120px; height: 6px; background-color: var(--accent-orange); /* Changed from var(--button-add-order) to var(--accent-orange) */ border: none; margin: 20px auto; border-radius: 3px; } /* Order Information Section */ .order-info-section { background-color: var(--background-color); border-radius: 12px; box-shadow: var(--box-shadow); padding: 35px; margin-bottom: 40px; display: flex; flex-direction: column; } .order-info-header { display: flex; align-items: center; margin-bottom: 25px; } .order-info-header .bi { font-size: 36px; color: var(--accent-red); margin-right: 15px; } .order-info-header h4 { font-size: 28px; color: var(--primary-text); font-weight: 700; } .order-info-content { display: flex; flex-wrap: wrap; gap: 20px; } .order-info-item { width: 50%; display: flex; align-items: center; } .order-info-item .bi { font-size: 24px; color: var(--accent-blue); margin-right: 12px; } .order-info-item .info-text { font-size: 18px; color: var(--primary-text); font-weight: 600; } /* Product Summary Section */ .product-summary-section { background-color: #f0f4f8; /* Subtle light background */ border-left: 6px solid var(--accent-teal); border-radius: 12px; padding: 30px; margin-bottom: 40px; box-shadow: var(--box-shadow); } .product-summary-section h4 { font-size: 24px; color: var(--accent-teal); margin-bottom: 20px; display: flex; align-items: center; } .product-summary-section h4 .bi { margin-right: 10px; color: var(--accent-teal); font-size: 28px; } .product-summary-list { display: flex; flex-wrap: wrap; gap: 20px; } .product-item { background-color: #fff; border: 1px solid #e0e0e0; border-radius: 8px; padding: 20px; width: calc(33.333% - 13.333px); box-shadow: var(--box-shadow); display: flex; align-items: flex-start; transition: transform 0.3s, box-shadow 0.3s; } .product-item:hover { transform: translateY(-5px); box-shadow: var(--hover-shadow); } .product-item .bi { font-size: 24px; color: var(--accent-soft-blue); margin-right: 15px; margin-top: 5px; } .product-details { flex-grow: 1; } .product-details p { font-size: 16px; margin-bottom: 8px; color: var(--primary-text); } .product-details p strong { color: var(--accent-teal); } /* Order Items Table Section */ .recent-orders-section { background-color: var(--background-color); border-radius: 12px; padding: 35px; box-shadow: var(--box-shadow); margin-bottom: 40px; } .recent-orders-section h4 { font-size: 24px; font-weight: 700; color: var(--primary-text); margin-bottom: 25px; } /* Make table responsive */ .table-responsive { overflow-x: auto; } .recent-orders-section table { width: 100%; border-collapse: collapse; min-width: 900px; } .recent-orders-section th, .recent-orders-section td { padding: 16px; text-align: center; font-size: 14px; vertical-align: middle; } .recent-orders-section th { background-color: var(--light-grey); color: var(--primary-text); font-weight: 700; position: sticky; top: 0; z-index: 1; } .recent-orders-section tr:nth-child(even) { background-color: #fafafa; } .recent-orders-section tr:hover { background-color: var(--light-grey); } .recent-orders-section td.number { text-align: center; } .recent-orders-section td.price, .recent-orders-section td.quantity, .recent-orders-section td.discount_percentage, .recent-orders-section td.discount_amount, .recent-orders-section td.total_after_discount { font-weight: 600; color: var(--primary-text); } /* Order Summary Section */ .total-section { text-align: right; margin-top: 25px; } .total-section p { font-size: 18px; color: var(--primary-text); margin-bottom: 10px; } .total-section p strong { font-size: 20px; color: var(--accent-blue); } /* Action Buttons */ .action-buttons { display: flex; gap: 20px; justify-content: flex-end; margin-bottom: 50px; flex-wrap: wrap; } .action-button { display: flex; align-items: center; justify-content: center; padding: 12px 20px; font-size: 16px; font-weight: 600; color: var(--background-color); border: none; border-radius: 8px; cursor: pointer; transition: transform 0.3s, box-shadow 0.3s; text-decoration: none; min-width: 180px; text-align: center; } .action-button.print-order { background-color: var(--accent-blue); } .action-button.edit-order { background-color: var(--accent-orange); } /* Updated to var(--accent-orange) */ .action-button.copy-order { background-color: var(--accent-teal); } .action-button.payment-status { background-color: var(--accent-green); } .action-button:hover { transform: scale(1.05); box-shadow: var(--hover-shadow); } .action-button .bi { margin-right: 8px; font-size: 20px; } /* Footer Styles */ .footer { background-color: var(--charcoal); color: var(--background-color); padding: 20px; text-align: center; border-radius: 12px; font-size: 16px; line-height: 1.5; margin-top: 60px; box-shadow: var(--box-shadow); } /* Responsive Design Enhancements */ @media (max-width: 992px) { .product-item { width: calc(50% - 10px); } .welcome-section h3 { font-size: 28px; } .order-info-header h4 { font-size: 24px; } .order-info-item .bi { font-size: 20px; } .order-info-item .info-text { font-size: 16px; } .recent-orders-section th, .recent-orders-section td { padding: 12px; font-size: 14px; } .recent-orders-section h4 { font-size: 22px; } .action-button { font-size: 14px; padding: 10px 18px; min-width: 160px; } .action-button .bi { font-size: 18px; } /* Adjust Product Summary Items */ .product-item { width: 100%; } } @media (max-width: 576px) { .welcome-section h3 { font-size: 24px; } .welcome-section h3 .bi { font-size: 28px; } .order-info-header h4 { font-size: 22px; } .order-info-item .bi { font-size: 18px; } .order-info-item .info-text { font-size: 14px; } .recent-orders-section th, .recent-orders-section td { padding: 10px; font-size: 12px; } .recent-orders-section h4 { font-size: 20px; } .action-button { font-size: 14px; padding: 8px 16px; min-width: 140px; } .action-button .bi { font-size: 16px; } /* Adjust Product Summary Items */ .product-item { width: 100%; } } </style> <!-- Additional JavaScript for Print, Copy, and Payment Functionality --> <script> // Function to print the order details function printOrder() { window.print(); } // Function to copy order details to clipboard function copyOrderDetails() { // Gather the required information const orderId = "<?= htmlspecialchars($order['order_id']) ?>"; const status = "<?= htmlspecialchars($order['status']) ?>"; const priority = "<?= htmlspecialchars($order['priority']) ?>"; const orderDate = "<?= date("l, d M Y, h:i A", strtotime($order['order_date'])) ?>"; const deliveryDateTime = "<?= get_day_name($order['delivery_datetime']) ?>, <?= $order['delivery_datetime'] ? date("l, d M Y, h:i A", strtotime($order['delivery_datetime'])) : 'N/A' ?>"; const customerName = "<?= htmlspecialchars($order['customer_name']) ?>"; const contactNumber = "<?= htmlspecialchars($order['contact']) ?>"; const deliveryAddress = "<?= nl2br(htmlspecialchars($order['delivery_address'])) ?>"; const deliveryFee = <?= htmlspecialchars($order['free_shipping']) == 1 ? '0.00' : htmlspecialchars($order['delivery_fee']) ?>; const freeShippingStatus = <?= htmlspecialchars($order['free_shipping']) == 1 ? '"Yes"' : '"No"' ?>; const isPaidStatus = <?= htmlspecialchars($order['is_paid']) == 1 ? '"Paid"' : '"Not Paid"' ?>; let productSummary = ''; document.querySelectorAll('.product-summary-item').forEach(function(item) { const productName = item.querySelector('.product-name').innerText; const productSize = item.querySelector('.product-size').innerText.replace('Size: ', ''); const productQuantityText = item.querySelector('.product-quantity').innerText.replace('Quantity: ', ''); const productQuantity = parseInt(productQuantityText); const packagingPreferencesElement = item.querySelector('.packaging-preferences'); const packagingPreferences = packagingPreferencesElement ? packagingPreferencesElement.innerText.replace('Packaging: ', '') : 'N/A'; if (!isNaN(productQuantity) && productQuantity > 1) { productSummary += `• Item: ${productQuantity} Boxes\n Size: ${productSize}\n Product: ${productName}\n Packaging: ${packagingPreferences}\n\n`; } else if (!isNaN(productQuantity) && productQuantity === 1) { productSummary += `• Item: ${productQuantity} Box\n Size: ${productSize}\n Product: ${productName}\n Packaging: ${packagingPreferences}\n\n`; } else { productSummary += `• Product: ${productName}\n Size: ${productSize}\n Packaging: ${packagingPreferences}\n\n`; } }); // Construct the formatted text const formattedText = `🔴 Order Details 🔴 • Order ID: ${orderId} • Status: ${status} • Priority: ${priority} • Order Date: ${orderDate} • Delivery Date & Time: ${deliveryDateTime} • Customer Name: ${customerName} 📦 Product Summary: ${productSummary}📍 Delivery Address: ${deliveryAddress} 💰 Delivery Fee: KWD ${deliveryFee} (${freeShippingStatus} Shipping) 💵 Payment Status: ${isPaidStatus} 📞 Contact Number: ${contactNumber}`; // Copy to clipboard using Clipboard API navigator.clipboard.writeText(formattedText).then(() => { alert('Order details copied to clipboard!'); }).catch(err => { alert('Failed to copy: ' + err); }); } // Function to toggle payment status via checkbox function togglePaymentStatus() { const paymentForm = document.getElementById('payment-form'); paymentForm.submit(); } </script> </head> <body> <!-- Header Already Included via header.php --> <main class='container-body'> <!-- Welcome Section --> <div class="welcome-section"> <h3><i class="bi bi-box-seam-fill"></i> Order #<?= htmlspecialchars($order['order_id']) ?></h3> <hr> <!-- Copy Info Button Above HR --> <button class="btn btn-outline-secondary btn-sm mt-3" onclick="copyOrderDetails()"> <i class="bi bi-clipboard-fill"></i> Copy Order Info </button> </div> <!-- Display Success or Error Messages --> <?php if (!empty($success_message)): ?> <div class="alert alert-success alert-dismissible fade show" role="alert"> <?= $success_message ?> <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button> </div> <?php endif; ?> <?php if (!empty($error_message)): ?> <div class="alert alert-danger alert-dismissible fade show" role="alert"> <?= $error_message ?> <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button> </div> <?php endif; ?> <!-- Payment Status Section --> <div class="mb-4"> <form method="POST" id="payment-form"> <div class="form-check form-switch"> <input class="form-check-input" type="checkbox" id="is_paid" name="is_paid" <?= $order['is_paid'] ? 'checked' : '' ?> onclick="togglePaymentStatus()"> <label class="form-check-label" for="is_paid"> <?= $order['is_paid'] ? '<span class="text-success">Paid</span>' : '<span class="text-danger">Not Paid</span>' ?> </label> </div> <input type="hidden" name="update_payment" value="1"> </form> </div> <!-- Product Summary Section --> <div class="product-summary-section"> <h4><i class="bi bi-bag-fill"></i> Product Summary</h4> <div class="product-summary-list"> <?php foreach ($order_items as $item): ?> <?php if (strtolower($item['packaging_preferences']) !== 'n/a'): // Only display if Packaging Preferences is not 'N/A' ?> <div class="product-item d-flex align-items-start product-summary-item"> <i class="bi bi-box-seam-fill"></i> <div class="product-details"> <p class="product-name"><strong><?= htmlspecialchars($item['product_name']) ?></strong></p> <p class="product-size"><i class="bi bi-arrows-angle-contract"></i> Size: <?= htmlspecialchars($item['product_size']) ?></p> <p class="product-quantity"><i class="bi bi-people-fill"></i> Quantity: <?= htmlspecialchars($item['quantity']) ?></p> <p class="packaging-preferences"><i class="bi bi-box-seam-fill"></i> Packaging: <?= htmlspecialchars($item['packaging_preferences']) ?></p> </div> </div> <?php else: ?> <div class="product-item d-flex align-items-start product-summary-item"> <i class="bi bi-box-seam-fill"></i> <div class="product-details"> <p class="product-name"><strong><?= htmlspecialchars($item['product_name']) ?></strong></p> <p class="product-size"><i class="bi bi-arrows-angle-contract"></i> Size: <?= htmlspecialchars($item['product_size']) ?></p> <p class="product-quantity"><i class="bi bi-people-fill"></i> Quantity: <?= htmlspecialchars($item['quantity']) ?></p> <!-- Packaging Preferences not displayed if 'N/A' --> </div> </div> <?php endif; ?> <?php endforeach; ?> </div> </div> <!-- Order Information Section --> <div class="order-info-section"> <div class="order-info-header"> <i class="bi bi-info-circle-fill"></i> <h4>Order Information</h4> </div> <div class="order-info-content"> <!-- Status --> <div class="order-info-item"> <i class="bi bi-tag-fill"></i> <div class="info-text"> <form method="POST" action="" class="d-flex align-items-center"> <strong>Status:</strong> <select name="status" class="form-select form-select-lg ms-2 me-2 px-3 py-2 status-dropdown" style="width: auto;" aria-label="Order Status"> <?php $statuses = ['Pending', 'In Progress', 'Completed', 'Delivered']; // Included 'In Progress' foreach ($statuses as $status) { $selected = ($order['status'] === $status) ? 'selected' : ''; echo "<option value=\"{$status}\" {$selected}>{$status}</option>"; } ?> </select> <button type="submit" name="update_status" class="btn btn-primary btn-lg px-4"> <i class="bi bi-arrow-repeat"></i> Update </button> </form> </div> </div> <!-- Priority --> <div class="order-info-item"> <i class="bi bi-exclamation-triangle-fill"></i> <div class="info-text"><strong>Priority:</strong> <?= htmlspecialchars($order['priority']) ?></div> </div> <!-- Order Date --> <div class="order-info-item"> <i class="bi bi-calendar-event-fill"></i> <div class="info-text"><strong>Order Date:</strong> <?= date("l, d M Y, h:i A", strtotime($order['order_date'])) ?></div> </div> <!-- Delivery Date & Time --> <div class="order-info-item"> <i class="bi bi-clock-fill"></i> <div class="info-text delivery-date-time"><strong>Delivery Date & Time:</strong> <?= get_day_name($order['delivery_datetime']) ?>, <?= $order['delivery_datetime'] ? date("l, d M Y, h:i A", strtotime($order['delivery_datetime'])) : 'N/A' ?></div> </div> <!-- Customer Name --> <div class="order-info-item"> <i class="bi bi-person-fill"></i> <div class="info-text"><strong>Customer Name:</strong> <?= htmlspecialchars($order['customer_name']) ?></div> </div> <!-- Contact --> <div class="order-info-item"> <i class="bi bi-whatsapp"></i> <div class="info-text contact-info"><strong>Contact:</strong> <a href="<?= generate_whatsapp_link($order['contact']) ?>" target="_blank" class="d-inline-flex align-items-center text-decoration-none"> <i class="bi bi-whatsapp text-success"></i> <span class="ms-2"><?= htmlspecialchars($order['contact']) ?></span> </a> </div> </div> <!-- Delivery Address --> <div class="order-info-item"> <i class="bi bi-geo-alt-fill"></i> <div class="info-text delivery-address"> <strong>Delivery Address:</strong> <?= nl2br(htmlspecialchars($order['delivery_address'])) ?> </div> </div> <!-- Delivery Fee and Free Shipping --> <div class="order-info-item"> <i class="bi bi-cash-stack"></i> <div class="info-text"> <strong>Delivery Fee:</strong> <?= $order['free_shipping'] == 1 ? '<span style="color: var(--accent-green); font-weight:bold;">Free</span>' : format_currency($order['delivery_fee']) ?> </div> </div> <!-- Payment Status --> <div class="order-info-item"> <i class="bi bi-credit-card-fill"></i> <div class="info-text"><strong>Payment Status:</strong> <?php if ($order['is_paid']): ?> <span class="badge bg-success">Paid</span> <?php else: ?> <span class="badge bg-danger">Not Paid</span> <?php endif; ?> </div> </div> </div> </div> <!-- Order Items Table Section --> <div class="recent-orders-section"> <h4>Order Items</h4> <div class="table-responsive"> <table class="table table-bordered"> <thead> <tr> <th>#</th> <th>Product</th> <th>Size</th> <th>Price per Unit (KWD)</th> <th>Quantity</th> <th>Packaging Preferences</th> <th>Discount (%)</th> <th>Discount Amount (KWD)</th> <th>Total (KWD)</th> </tr> </thead> <tbody> <?php foreach ($order_items as $index => $item): ?> <tr> <td class="number"><?= $index + 1 ?></td> <td><?= htmlspecialchars($item['product_name']) ?></td> <td><?= htmlspecialchars($item['product_size']) ?></td> <td class="price"><?= format_currency($item['product_price']) ?></td> <td class="quantity"><?= htmlspecialchars($item['quantity']) ?></td> <td><?= htmlspecialchars($item['packaging_preferences']) ?: 'N/A' ?></td> <td class="discount_percentage"><?= number_format($item['discount_percentage'], 2) ?>%</td> <td class="discount_amount"><?= format_currency($item['discount_amount']) ?></td> <td class="total_after_discount"><?= format_currency($item['total_after_discount']) ?></td> </tr> <?php endforeach; ?> </tbody> </table> </div> <!-- Order Summary --> <div class="total-section"> <p><strong>Total Before Discounts:</strong> <?= format_currency($total_before_discounts) ?></p> <p><strong>Total Discounts:</strong> <?= format_currency($total_discounts) ?></p> <?php if ($order['free_shipping'] == 0): ?> <p><strong>Delivery Fee:</strong> <?= format_currency($order['delivery_fee']) ?></p> <?php endif; ?> <hr> <p><strong>Final Total:</strong> <?= format_currency($final_total) ?></p> </div> </div> <!-- Action Buttons --> <div class="action-buttons"> <a href="edit_order.php?id=<?= htmlspecialchars($order['order_id']) ?>" class="action-button edit-order" style="color:white;"> <i class="bi bi-pencil-square"></i> Edit Order </a> <button class="action-button print-order" onclick="printOrder()"> <i class="bi bi-printer-fill"></i> Print Order </button> <button class="action-button copy-order" onclick="copyOrderDetails()"> <i class="bi bi-clipboard-fill"></i> Copy Order Details </button> </div> <!-- Footer --> <div class="footer"> © <?= date("Y") ?> 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 (if needed in future) --> <script src="https://cdn.jsdelivr.net/npm/flatpickr"></script> <!-- Bootstrap Tooltip Initialization (if using tooltips in future) --> <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 ?>Detailed Explanation of Changes
-
Fetching
is_paidStatus:- Modified the SQL query to include
orders.is_paid. $order['is_paid']now holds the payment status (0or1).
- Modified the SQL query to include
-
Displaying Payment Status Checkbox:
- Added a new form section with a checkbox to toggle the payment status.
- The checkbox reflects the current
is_paidstatus. - When toggled, it submits the form to update the payment status.
-
Handling Payment Status Update:
- Added a new
ifblock to handle$_POST['update_payment']. - The
is_paidvalue is updated based on the checkbox state (1for checked,0for unchecked). - Success or error messages are displayed accordingly.
- The local
$order['is_paid']variable is updated to reflect changes without requiring a page reload.
- Added a new
-
Including Payment Status in Order Information:
- Added a new information item displaying the current payment status using badges (
PaidorNot Paid).
- Added a new information item displaying the current payment status using badges (
-
Updating the JavaScript
copyOrderDetailsFunction:- Included the
is_paidstatus in the copied order details.
- Included the
3. Modify
edit_order.phpOverview of Changes
- Include
is_paidField:- Add a checkbox to indicate whether the order is paid.
- Handle
is_paidin Form Submission:- Update the
is_paidstatus based on user input during order editing.
- Update the
Updated
edit_order.php<?php // public/orders/edit_order.php // Enable error reporting for debugging (disable in production) ini_set('display_errors', 0); // Set to 0 in production ini_set('display_startup_errors', 0); // Set to 0 in production error_reporting(E_ALL); // Include necessary files require_once __DIR__ . '/../../includes/auth.php'; require_once __DIR__ . '/../../includes/db_connect.php'; // Function to sanitize input function sanitize_input($input) { return htmlspecialchars(trim($input), ENT_QUOTES, 'UTF-8'); } // Initialize success and error variables $success = ''; $error = ''; // Retrieve and sanitize the order ID from GET parameters $order_id = isset($_GET['id']) ? intval($_GET['id']) : 0; // Redirect if no valid order ID is provided if ($order_id <= 0) { header("Location: view_orders.php?error=Invalid Order ID"); exit(); } // Fetch order details along with customer information and is_paid status $order_sql = "SELECT o.*, c.name AS customer_name, c.contact AS customer_contact, c.delivery_address FROM orders o JOIN customers c ON o.customer_id = c.id WHERE o.id = ? LIMIT 1"; $order_stmt = $conn->prepare($order_sql); if (!$order_stmt) { die("Prepare statement failed: " . $conn->error); } $order_stmt->bind_param("i", $order_id); $order_stmt->execute(); $order_result = $order_stmt->get_result(); if ($order_result->num_rows != 1) { header("Location: view_orders.php?error=Order Not Found"); exit(); } $order = $order_result->fetch_assoc(); $order_stmt->close(); // Fetch existing order items $order_items_sql = "SELECT oi.*, p.name AS product_name, p.size, p.price FROM order_items oi JOIN products p ON oi.product_id = p.id WHERE oi.order_id = ?"; $order_items_stmt = $conn->prepare($order_items_sql); if (!$order_items_stmt) { die("Prepare statement failed: " . $conn->error); } $order_items_stmt->bind_param("i", $order_id); $order_items_stmt->execute(); $order_items_result = $order_items_stmt->get_result(); $order_items = []; while ($item = $order_items_result->fetch_assoc()) { $order_items[] = $item; } $order_items_stmt->close(); // Fetch products for selection $products_sql = "SELECT * FROM products ORDER BY name ASC"; $products_result = $conn->query($products_sql); // Handle form submission for updating the order if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Retrieve and sanitize form inputs $customer_name = sanitize_input($_POST['customer_name']); $contact = sanitize_input($_POST['contact']); $delivery_address = sanitize_input($_POST['delivery_address']); $status = sanitize_input($_POST['status']); $priority = sanitize_input($_POST['priority']); $delivery_datetime = isset($_POST['delivery_datetime']) && !empty($_POST['delivery_datetime']) ? sanitize_input($_POST['delivery_datetime']) : null; $delivery_date = isset($_POST['delivery_date']) && !empty($_POST['delivery_date']) ? sanitize_input($_POST['delivery_date']) : null; // New fields based on database schema $delivery_fee = isset($_POST['delivery_fee']) && is_numeric($_POST['delivery_fee']) ? floatval($_POST['delivery_fee']) : 0.00; $free_shipping = isset($_POST['free_shipping']) ? 1 : 0; $is_paid = isset($_POST['is_paid']) ? 1 : 0; // New field // If free shipping is selected, set delivery_fee to 0.00 if ($free_shipping) { $delivery_fee = 0.00; } // Handle existing order items $existing_item_ids = isset($_POST['existing_item_id']) ? $_POST['existing_item_id'] : []; $product_ids = isset($_POST['product_id']) ? $_POST['product_id'] : []; $quantities = isset($_POST['quantity']) ? $_POST['quantity'] : []; $packaging_preferences = isset($_POST['packaging_preferences']) ? $_POST['packaging_preferences'] : []; $discount_percentages = isset($_POST['discount_percentage']) ? $_POST['discount_percentage'] : []; $discount_reasons = isset($_POST['discount_reason']) ? $_POST['discount_reason'] : []; // Handle new order items $new_product_ids = isset($_POST['new_product_id']) ? $_POST['new_product_id'] : []; $new_quantities = isset($_POST['new_quantity']) ? $_POST['new_quantity'] : []; $new_packaging_preferences = isset($_POST['new_packaging_preferences']) ? $_POST['new_packaging_preferences'] : []; $new_discount_percentages = isset($_POST['new_discount_percentage']) ? $_POST['new_discount_percentage'] : []; $new_discount_reasons = isset($_POST['new_discount_reason']) ? $_POST['new_discount_reason'] : []; // Basic validation if (empty($customer_name)) { $error = "Customer name is required."; } elseif (empty($status)) { $error = "Order status is required."; } elseif (empty($priority)) { $error = "Order priority is required."; } elseif ((empty($existing_item_ids) && empty($new_product_ids))) { $error = "At least one product must be selected."; } else { // Validate each existing product entry foreach ($existing_item_ids as $index => $item_id) { if (empty($product_ids[$index])) { $error = "Product selection is required for all existing items."; break; } if (intval($quantities[$index]) <= 0) { $error = "Quantity must be at least 1 for all existing items."; break; } if ($discount_percentages[$index] !== '' && (floatval($discount_percentages[$index]) < 0 || floatval($discount_percentages[$index]) > 100)) { $error = "Discount percentage must be between 0 and 100."; break; } } // Validate new product entries foreach ($new_product_ids as $index => $pid) { if (!empty($pid)) { if (intval($new_quantities[$index]) <= 0) { $error = "Quantity must be at least 1 for all new items."; break; } if ($new_discount_percentages[$index] !== '' && (floatval($new_discount_percentages[$index]) < 0 || floatval($new_discount_percentages[$index]) > 100)) { $error = "Discount percentage must be between 0 and 100 for all new items."; break; } } } if ($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 ($delivery_date && strtotime($delivery_date) < strtotime(date('Y-m-d'))) { $error = "Delivery date cannot be in the past."; } } if (empty($error)) { // Start transaction $conn->begin_transaction(); try { // Update customer details $stmt = $conn->prepare("UPDATE customers SET name = ?, contact = ?, delivery_address = ? WHERE id = ?"); if (!$stmt) { throw new Exception("Prepare statement failed: " . $conn->error); } $stmt->bind_param("sssi", $customer_name, $contact, $delivery_address, $order['customer_id']); if (!$stmt->execute()) { throw new Exception("Execute failed: " . $stmt->error); } $stmt->close(); // Update orders table with new fields including is_paid $stmt = $conn->prepare("UPDATE orders SET status = ?, priority = ?, delivery_datetime = ?, delivery_date = ?, delivery_fee = ?, free_shipping = ?, is_paid = ? WHERE id = ?"); if (!$stmt) { throw new Exception("Prepare statement failed: " . $conn->error); } $stmt->bind_param("ssssdiii", $status, $priority, $delivery_datetime, $delivery_date, $delivery_fee, $free_shipping, $is_paid, $order_id); if (!$stmt->execute()) { throw new Exception("Execute failed: " . $stmt->error); } $stmt->close(); // Update existing order items foreach ($existing_item_ids as $index => $item_id) { $item_id = intval($item_id); $pid = intval($product_ids[$index]); $qty = intval($quantities[$index]); $pack_pref = sanitize_input($packaging_preferences[$index]); $discount_pct = $discount_percentages[$index] !== '' ? floatval($discount_percentages[$index]) : 0.00; $discount_rsn = sanitize_input($discount_reasons[$index]); $stmt = $conn->prepare("UPDATE order_items SET product_id = ?, quantity = ?, packaging_preferences = ?, discount_percentage = ?, discount_reason = ? WHERE id = ?"); if (!$stmt) { throw new Exception("Prepare statement failed: " . $conn->error); } $stmt->bind_param("iisdsi", $pid, $qty, $pack_pref, $discount_pct, $discount_rsn, $item_id); if (!$stmt->execute()) { throw new Exception("Execute failed: " . $stmt->error); } $stmt->close(); } // Insert new order items $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); } for ($i = 0; $i < count($new_product_ids); $i++) { $new_pid = intval($new_product_ids[$i]); $new_qty = intval($new_quantities[$i]); $new_pack_pref = sanitize_input($new_packaging_preferences[$i]); $new_discount_pct = $new_discount_percentages[$i] !== '' ? floatval($new_discount_percentages[$i]) : 0.00; $new_discount_rsn = sanitize_input($new_discount_reasons[$i]); if (!empty($new_pid)) { $stmt->bind_param("iiidsi", $order_id, $new_pid, $new_qty, $new_pack_pref, $new_discount_pct, $new_discount_rsn); if (!$stmt->execute()) { throw new Exception("Execute failed: " . $stmt->error); } } } $stmt->close(); // Commit transaction $conn->commit(); $success = "Order updated successfully!"; // Refresh order data // Fetch updated order items $order_items_sql = "SELECT oi.*, p.name AS product_name, p.size, p.price FROM order_items oi JOIN products p ON oi.product_id = p.id WHERE oi.order_id = ?"; $order_items_stmt = $conn->prepare($order_items_sql); if (!$order_items_stmt) { throw new Exception("Prepare statement failed: " . $conn->error); } $order_items_stmt->bind_param("i", $order_id); $order_items_stmt->execute(); $order_items_result = $order_items_stmt->get_result(); $order_items = []; while ($item = $order_items_result->fetch_assoc()) { $order_items[] = $item; } $order_items_stmt->close(); } catch (Exception $e) { // Rollback transaction $conn->rollback(); $error = "Error updating order: " . sanitize_input($e->getMessage()); } } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Edit Order #<?= htmlspecialchars($order_id) ?> - Kaak Alia Management System</title> <!-- Google Fonts --> <link href="https://fonts.googleapis.com/css2?family=Inter:wght@400;600;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"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- Custom Styles --> <style> /* (Same CSS as provided by the user or adjust as needed) */ :root { /* Primary Colors */ --background-color: #FFFFFF; /* Crisp White */ --light-grey: #F5F5F5; --medium-grey: #CCCCCC; --dark-grey: #333333; --charcoal: #374151; /* Updated to requested color */ /* 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.2); /* 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; --badge-paid: #50C878; /* Green for Paid */ --badge-not-paid: #FF6B6B; /* Red for Not Paid */ } /* Custom scrollbar for better UX */ ::-webkit-scrollbar { width: 8px; } ::-webkit-scrollbar-track { background: #f1f5f9; /* Tailwind's gray-100 */ } ::-webkit-scrollbar-thumb { background: #4b6584; /* Teal-500 */ border-radius: 4px; } ::-webkit-scrollbar-thumb:hover { background: #0d9488; /* Teal-600 */ } /* Global Styles */ body, html { font-family: 'Inter', sans-serif; background-color: var(--background-color); margin: 0; padding: 0; box-sizing: border-box; } .container-body { padding: 20px; max-width: 1200px; margin: 0 auto; } h1, h2, h3, h4, h5, p { margin: 0; } /* Header Styles */ .header { padding: 20px 30px; background-color: var(--charcoal); border-radius: 12px; display: flex; align-items: center; justify-content: center; margin-bottom: 30px; box-shadow: var(--box-shadow); } .header h1 { color: var(--background-color); font-size: 28px; font-weight: 700; } /* Container Styles */ .container-custom { max-width: 1000px; margin: auto; background-color: var(--background-color); padding: 40px; border: 1px solid var(--medium-grey); border-radius: var(--box-border-radius); box-shadow: var(--box-shadow); } /* Success and Error Alerts */ .alert-custom { border-radius: var(--box-border-radius); padding: 20px 25px; margin-bottom: 30px; text-align: center; font-size: 18px; font-weight: 600; } .alert-success-custom { background-color: var(--accent-green); color: var(--background-color); } .alert-danger-custom { background-color: var(--accent-red); color: var(--background-color); } /* Form Styles */ .form-label { font-weight: 600; color: var(--primary-text); font-size: 16px; } .form-control { background-color: #F9F9F9; border: 1px solid var(--input-border); border-radius: 8px; padding: 12px 16px; transition: border-color 0.3s, box-shadow 0.3s; font-size: 16px; } .form-control:focus { border-color: var(--input-focus-border); box-shadow: 0 0 5px rgba(32, 178, 170, 0.5); background-color: var(--background-color); } .btn-primary-custom { background-color: var(--button-add-order); border: none; color: var(--background-color); padding: 12px 24px; font-size: 16px; font-weight: 600; border-radius: 8px; transition: background-color 0.3s, transform 0.3s; cursor: pointer; } .btn-primary-custom:hover { background-color: #5750d3; transform: scale(1.05); } .btn-secondary-custom { background-color: var(--accent-soft-blue); border: none; color: var(--primary-text); padding: 12px 24px; font-size: 16px; font-weight: 600; border-radius: 8px; transition: background-color 0.3s, transform 0.3s; cursor: pointer; text-decoration: none; display: inline-block; } .btn-secondary-custom:hover { background-color: #8AB6D6; transform: scale(1.05); } .remove-product-button { background-color: var(--accent-red); color: var(--background-color); border: none; border-radius: 50%; width: 35px; height: 35px; cursor: pointer; transition: background-color 0.3s, transform 0.3s; font-size: 18px; font-weight: bold; display: flex; align-items: center; justify-content: center; } .remove-product-button:hover { background-color: #e63946; transform: scale(1.1); } /* Footer Styles */ .footer { background-color: var(--charcoal); color: var(--background-color); padding: 20px; text-align: center; border-radius: 12px; font-size: 16px; line-height: 1.5; margin-top: 40px; box-shadow: var(--box-shadow); } /* Responsive Design Enhancements */ @media (max-width: 768px) { .container-custom { padding: 30px; } .btn { width: 100%; margin-bottom: 10px; } .remove-product-button { width: 30px; height: 30px; } } @media (max-width: 480px) { .header { padding: 15px 20px; } .header h1 { font-size: 24px; } .form-label { font-size: 14px; } .form-control { padding: 10px 12px; font-size: 14px; } .btn-primary-custom, .btn-secondary-custom { font-size: 14px; padding: 10px 18px; } .footer { font-size: 14px; } } </style> <!-- Additional JavaScript for dynamic product addition, form enhancements, and payment functionality --> <script> function addOrderItemRow() { const orderItemsContainer = document.getElementById('order-items-container'); const itemCount = orderItemsContainer.children.length; const orderItemRow = document.createElement('div'); orderItemRow.className = 'order-item-row border p-4 mb-4 shadow-sm'; orderItemRow.style.borderRadius = '12px'; orderItemRow.innerHTML = ` <div class="row g-3"> <div class="col-md-4"> <label class="form-label" for="new_product_id_${itemCount}">Product <span class="text-danger">*</span></label> <select name="new_product_id[]" id="new_product_id_${itemCount}" 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="new_quantity_${itemCount}">Quantity <span class="text-danger">*</span></label> <input type="number" name="new_quantity[]" id="new_quantity_${itemCount}" class="form-control" min="1" value="1" required> </div> <div class="col-md-3"> <label class="form-label" for="new_packaging_preferences_${itemCount}">Packaging Preferences</label> <input type="text" name="new_packaging_preferences[]" id="new_packaging_preferences_${itemCount}" class="form-control" placeholder="e.g., Gift Wrap"> </div> <div class="col-md-2"> <label class="form-label" for="new_discount_percentage_${itemCount}">Discount (%)</label> <input type="number" name="new_discount_percentage[]" id="new_discount_percentage_${itemCount}" class="form-control" min="0" max="100" step="0.01" value="0.00"> </div> <div class="col-md-1 d-flex align-items-end"> <button type="button" class="remove-product-button" onclick="removeOrderItemRow(this)" title="Remove Product">✕</button> </div> </div> <div class="row mt-3"> <div class="col-md-12"> <label class="form-label" for="new_discount_reason_${itemCount}">Discount Reason</label> <input type="text" name="new_discount_reason[]" id="new_discount_reason_${itemCount}" class="form-control" placeholder="e.g., Seasonal Sale"> </div> </div> `; orderItemsContainer.appendChild(orderItemRow); } function removeOrderItemRow(button) { const orderItemRow = button.closest('.order-item-row'); orderItemRow.remove(); } function removeExistingOrderItemRow(button) { const orderItemRow = button.closest('.order-item-row'); // Optionally, implement functionality to handle backend deletion if necessary // For simplicity, we'll remove it directly orderItemRow.remove(); // To handle deletion in backend, you'd need to track removed IDs and delete them from database // This requires additional implementation } // Function to toggle delivery fee input based on free shipping checkbox function toggleDeliveryFee() { const freeShippingCheckbox = document.getElementById('free_shipping'); const deliveryFeeInput = document.getElementById('delivery_fee'); if (freeShippingCheckbox.checked) { deliveryFeeInput.value = '0.00'; deliveryFeeInput.disabled = true; } else { deliveryFeeInput.disabled = false; } } // Initialize on page load document.addEventListener('DOMContentLoaded', function() { const freeShippingCheckbox = document.getElementById('free_shipping'); if (freeShippingCheckbox) { freeShippingCheckbox.addEventListener('change', toggleDeliveryFee); // Initial toggle based on current state toggleDeliveryFee(); } // Initialize Flatpickr for date and datetime fields if needed flatpickr("#delivery_datetime", { enableTime: true, dateFormat: "Y-m-d\\TH:i", }); flatpickr("#delivery_date", { dateFormat: "Y-m-d", }); }); // Function to print the order details function printOrder() { window.print(); } // Function to copy order details to clipboard function copyOrderDetails() { // Gather the required information const orderId = "<?= htmlspecialchars($order['id']) ?>"; const status = "<?= htmlspecialchars($order['status']) ?>"; const priority = "<?= htmlspecialchars($order['priority']) ?>"; const orderDate = "<?= date("l, d M Y, h:i A", strtotime($order['order_date'])) ?>"; const deliveryDateTime = "<?= $order['delivery_datetime'] ? date("l, d M Y, h:i A", strtotime($order['delivery_datetime'])) : 'N/A' ?>"; const customerName = "<?= htmlspecialchars($order['customer_name']) ?>"; const contactNumber = "<?= htmlspecialchars($order['customer_contact']) ?>"; const deliveryAddress = "<?= nl2br(htmlspecialchars($order['delivery_address'])) ?>"; const deliveryFee = <?= htmlspecialchars($order['free_shipping']) == 1 ? '0.00' : htmlspecialchars($order['delivery_fee']) ?>; const freeShippingStatus = <?= htmlspecialchars($order['free_shipping']) == 1 ? '"Yes"' : '"No"' ?>; const isPaidStatus = <?= htmlspecialchars($order['is_paid']) == 1 ? '"Paid"' : '"Not Paid"' ?>; let productSummary = ''; document.querySelectorAll('.order-item-row').forEach(function(item) { const productName = item.querySelector('.product-name').innerText; const productSize = item.querySelector('.product-size').innerText.replace('Size: ', ''); const productQuantityText = item.querySelector('.product-quantity').innerText.replace('Quantity: ', ''); const productQuantity = parseInt(productQuantityText); const packagingPreferences = item.querySelector('.packaging_preferences') ? item.querySelector('.packaging_preferences').innerText.replace('Packaging: ', '') : 'N/A'; const discountPercentage = item.querySelector('.discount_percentage') ? item.querySelector('.discount_percentage').innerText.replace('%', '') : '0.00'; if (!isNaN(productQuantity) && productQuantity > 1) { productSummary += `• Item: ${productQuantity} Boxes\n Size: ${productSize}\n Product: ${productName}\n Packaging: ${packagingPreferences}\n Discount: ${discountPercentage}%\n\n`; } else if (!isNaN(productQuantity) && productQuantity === 1) { productSummary += `• Item: ${productQuantity} Box\n Size: ${productSize}\n Product: ${productName}\n Packaging: ${packagingPreferences}\n Discount: ${discountPercentage}%\n\n`; } else { productSummary += `• Product: ${productName}\n Size: ${productSize}\n Packaging: ${packagingPreferences}\n Discount: ${discountPercentage}%\n\n`; } }); // Construct the formatted text const formattedText = `🔴 Order Details 🔴 • Order ID: ${orderId} • Status: ${status} • Priority: ${priority} • Order Date: ${orderDate} • Delivery Date & Time: ${deliveryDateTime} • Customer Name: ${customerName} 📦 Product Summary: ${productSummary}📍 Delivery Address: ${deliveryAddress} 💰 Delivery Fee: KWD ${deliveryFee} (${freeShippingStatus} Shipping) 💵 Payment Status: ${isPaidStatus} 📞 Contact Number: ${contactNumber}`; // Copy to clipboard using Clipboard API navigator.clipboard.writeText(formattedText).then(() => { alert('Order details copied to clipboard!'); }).catch(err => { alert('Failed to copy: ' + err); }); } </script> </head> <body> <!-- Header --> <div class="header"> <h1>Kaak Alia Management System</h1> </div> <!-- Container --> <div class="container-custom"> <h3 class="mb-5">Edit Order #<?= htmlspecialchars($order_id) ?></h3> <!-- Display Success or Error Messages --> <?php if (!empty($success)): ?> <div class="alert alert-custom alert-success-custom"><?= htmlspecialchars($success) ?></div> <?php endif; ?> <?php if (!empty($error)): ?> <div class="alert alert-custom alert-danger-custom"><?= htmlspecialchars($error) ?></div> <?php endif; ?> <!-- Edit Order Form --> <form method="POST" action=""> <!-- Customer Details --> <div class="mb-5"> <h5 class="mb-4">Customer Details</h5> <div class="row g-4"> <div class="col-md-6"> <label class="form-label" for="customer_name">Customer Name <span class="text-danger">*</span></label> <input type="text" id="customer_name" name="customer_name" class="form-control" value="<?= htmlspecialchars(isset($_POST['customer_name']) ? $_POST['customer_name'] : $order['customer_name']) ?>" required> </div> <div class="col-md-6"> <label class="form-label" for="contact">Contact</label> <input type="text" id="contact" name="contact" class="form-control" value="<?= htmlspecialchars(isset($_POST['contact']) ? $_POST['contact'] : $order['customer_contact']) ?>"> </div> </div> <div class="mt-4"> <label class="form-label" for="delivery_address">Delivery Address</label> <textarea id="delivery_address" name="delivery_address" class="form-control" rows="3"><?= htmlspecialchars(isset($_POST['delivery_address']) ? $_POST['delivery_address'] : $order['delivery_address']) ?></textarea> </div> </div> <hr> <!-- Order Details --> <div class="mb-5"> <h5 class="mb-4">Order Details</h5> <div class="row g-4"> <div class="col-md-3"> <label class="form-label" for="status">Status <span class="text-danger">*</span></label> <select name="status" id="status" class="form-control" required> <option value="">Select Status</option> <option value="Pending" <?= (isset($_POST['status']) ? $_POST['status'] : $order['status']) == 'Pending' ? 'selected' : '' ?>>Pending</option> <option value="In Progress" <?= (isset($_POST['status']) ? $_POST['status'] : $order['status']) == 'In Progress' ? 'selected' : '' ?>>In Progress</option> <option value="Completed" <?= (isset($_POST['status']) ? $_POST['status'] : $order['status']) == 'Completed' ? 'selected' : '' ?>>Completed</option> <option value="Delivered" <?= (isset($_POST['status']) ? $_POST['status'] : $order['status']) == 'Delivered' ? 'selected' : '' ?>>Delivered</option> </select> </div> <div class="col-md-3"> <label class="form-label" for="priority">Priority <span class="text-danger">*</span></label> <select name="priority" id="priority" class="form-control" required> <option value="">Select Priority</option> <option value="Normal" <?= (isset($_POST['priority']) ? $_POST['priority'] : $order['priority']) == 'Normal' ? 'selected' : '' ?>>Normal</option> <option value="Important" <?= (isset($_POST['priority']) ? $_POST['priority'] : $order['priority']) == 'Important' ? 'selected' : '' ?>>Important</option> <option value="Quick" <?= (isset($_POST['priority']) ? $_POST['priority'] : $order['priority']) == 'Quick' ? 'selected' : '' ?>>Quick</option> </select> </div> <div class="col-md-3"> <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']) : ($order['delivery_datetime'] ? date('Y-m-d\TH:i', strtotime($order['delivery_datetime'])) : '') ?>"> </div> <div class="col-md-3"> <label class="form-label" for="delivery_date">Delivery Date</label> <input type="date" id="delivery_date" name="delivery_date" class="form-control" value="<?= isset($_POST['delivery_date']) ? htmlspecialchars($_POST['delivery_date']) : ($order['delivery_date'] ? date('Y-m-d', strtotime($order['delivery_date'])) : '') ?>"> </div> </div> <div class="row g-4 mt-3"> <div class="col-md-4"> <label class="form-label" for="delivery_fee">Delivery Fee (KD) <span class="text-danger" id="delivery_fee_required">*</span></label> <input type="number" step="0.01" id="delivery_fee" name="delivery_fee" class="form-control" min="0" value="<?= isset($_POST['delivery_fee']) ? htmlspecialchars($_POST['delivery_fee']) : number_format($order['delivery_fee'], 2, '.', '') ?>" <?= isset($_POST['free_shipping']) || $order['free_shipping'] ? 'disabled' : 'required' ?>> </div> <div class="col-md-4 d-flex align-items-end"> <div class="form-check"> <input class="form-check-input" type="checkbox" value="1" id="free_shipping" name="free_shipping" <?= (isset($_POST['free_shipping']) ? $_POST['free_shipping'] : $order['free_shipping']) ? 'checked' : '' ?>> <label class="form-check-label" for="free_shipping"> Free Shipping </label> </div> </div> <div class="col-md-4 d-flex align-items-end"> <div class="form-check form-switch"> <input class="form-check-input" type="checkbox" id="is_paid" name="is_paid" <?= (isset($_POST['is_paid']) ? $_POST['is_paid'] : $order['is_paid']) ? 'checked' : '' ?>> <label class="form-check-label" for="is_paid"> <?= (isset($_POST['is_paid']) ? $_POST['is_paid'] : $order['is_paid']) ? 'Mark as Paid' : 'Mark as Not Paid' ?> </label> </div> </div> </div> </div> <hr> <!-- Existing Order Items --> <div class="mb-5"> <h5 class="mb-4">Existing Order Items</h5> <div id="existing-order-items-container"> <?php foreach ($order_items as $item): ?> <div class="order-item-row border p-4 mb-4 shadow-sm" style="border-radius: 12px;"> <input type="hidden" name="existing_item_id[]" value="<?= htmlspecialchars($item['id']) ?>"> <div class="row g-3"> <div class="col-md-4"> <label class="form-label" for="product_id_<?= htmlspecialchars($item['id']) ?>">Product <span class="text-danger">*</span></label> <select name="product_id[]" id="product_id_<?= htmlspecialchars($item['id']) ?>" 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']) ?>" <?= ($product['id'] == $item['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_<?= htmlspecialchars($item['id']) ?>">Quantity <span class="text-danger">*</span></label> <input type="number" name="quantity[]" id="quantity_<?= htmlspecialchars($item['id']) ?>" class="form-control" min="1" value="<?= htmlspecialchars($item['quantity']) ?>" required> </div> <div class="col-md-3"> <label class="form-label" for="packaging_preferences_<?= htmlspecialchars($item['id']) ?>">Packaging Preferences</label> <input type="text" name="packaging_preferences[]" id="packaging_preferences_<?= htmlspecialchars($item['id']) ?>" class="form-control" placeholder="e.g., Gift Wrap" value="<?= htmlspecialchars($item['packaging_preferences']) ?>"> </div> <div class="col-md-2"> <label class="form-label" for="discount_percentage_<?= htmlspecialchars($item['id']) ?>">Discount (%)</label> <input type="number" name="discount_percentage[]" id="discount_percentage_<?= htmlspecialchars($item['id']) ?>" class="form-control" min="0" max="100" step="0.01" value="<?= htmlspecialchars($item['discount_percentage']) ?>"> </div> <div class="col-md-1 d-flex align-items-end"> <button type="button" class="remove-product-button" onclick="removeExistingOrderItemRow(this)" title="Remove Product">✕</button> </div> </div> <div class="row mt-3"> <div class="col-md-12"> <label class="form-label" for="discount_reason_<?= htmlspecialchars($item['id']) ?>">Discount Reason</label> <input type="text" name="discount_reason[]" id="discount_reason_<?= htmlspecialchars($item['id']) ?>" class="form-control" placeholder="e.g., Seasonal Sale" value="<?= htmlspecialchars($item['discount_reason']) ?>"> </div> </div> </div> <?php endforeach; ?> </div> </div> <hr> <!-- Add New Order Items --> <div class="mb-5"> <h5 class="mb-4">Add New Order Items</h5> <div id="order-items-container"> <!-- New Order Item Rows will be added here --> </div> <button type="button" class="btn btn-secondary-custom mt-3" onclick="addOrderItemRow()"> <i class="bi bi-plus-circle-fill"></i> Add Another Product </button> </div> <!-- Submit Buttons --> <div class="d-flex justify-content-between mt-4"> <button type="submit" class="btn-primary-custom">Update Order</button> <a href="view_orders.php" class="btn-secondary-custom">Cancel</a> </div> </form> </div> <!-- Footer --> <div class="footer"> © <?= date("Y") ?> Kaak Alia Bakery. All rights reserved. </div> <!-- 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 (if using tooltips in future) --> <script> var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]')) var tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) { return new bootstrap.Tooltip(tooltipTriggerEl) }) </script> <!-- Custom JS for Print, Copy, and Delivery Fee Toggling --> <script> function printOrder() { window.print(); } function copyOrderDetails() { // Gather the required information const orderId = "<?= htmlspecialchars($order['id']) ?>"; const status = "<?= htmlspecialchars($order['status']) ?>"; const priority = "<?= htmlspecialchars($order['priority']) ?>"; const orderDate = "<?= date("l, d M Y, h:i A", strtotime($order['order_date'])) ?>"; const deliveryDateTime = "<?= $order['delivery_datetime'] ? date("l, d M Y, h:i A", strtotime($order['delivery_datetime'])) : 'N/A' ?>"; const customerName = "<?= htmlspecialchars($order['customer_name']) ?>"; const contactNumber = "<?= htmlspecialchars($order['customer_contact']) ?>"; const deliveryAddress = "<?= nl2br(htmlspecialchars($order['delivery_address'])) ?>"; const deliveryFee = <?= htmlspecialchars($order['free_shipping']) == 1 ? '0.00' : htmlspecialchars($order['delivery_fee']) ?>; const freeShippingStatus = <?= htmlspecialchars($order['free_shipping']) == 1 ? '"Yes"' : '"No"' ?>; const isPaidStatus = <?= htmlspecialchars($order['is_paid']) == 1 ? '"Paid"' : '"Not Paid"' ?>; let productSummary = ''; document.querySelectorAll('.order-item-row').forEach(function(item) { const productName = item.querySelector('.product-name').innerText; const productSize = item.querySelector('.product-size').innerText.replace('Size: ', ''); const productQuantityText = item.querySelector('.product-quantity').innerText.replace('Quantity: ', ''); const productQuantity = parseInt(productQuantityText); const packagingPreferences = item.querySelector('.packaging_preferences') ? item.querySelector('.packaging_preferences').innerText.replace('Packaging: ', '') : 'N/A'; const discountPercentage = item.querySelector('.discount_percentage') ? item.querySelector('.discount_percentage').innerText.replace('%', '') : '0.00'; if (!isNaN(productQuantity) && productQuantity > 1) { productSummary += `• Item: ${productQuantity} Boxes\n Size: ${productSize}\n Product: ${productName}\n Packaging: ${packagingPreferences}\n Discount: ${discountPercentage}%\n\n`; } else if (!isNaN(productQuantity) && productQuantity === 1) { productSummary += `• Item: ${productQuantity} Box\n Size: ${productSize}\n Product: ${productName}\n Packaging: ${packagingPreferences}\n Discount: ${discountPercentage}%\n\n`; } else { productSummary += `• Product: ${productName}\n Size: ${productSize}\n Packaging: ${packagingPreferences}\n Discount: ${discountPercentage}%\n\n`; } }); // Construct the formatted text const formattedText = `🔴 Order Details 🔴 • Order ID: ${orderId} • Status: ${status} • Priority: ${priority} • Order Date: ${orderDate} • Delivery Date & Time: ${deliveryDateTime} • Customer Name: ${customerName} 📦 Product Summary: ${productSummary}📍 Delivery Address: ${deliveryAddress} 💰 Delivery Fee: KWD ${deliveryFee} (${freeShippingStatus} Shipping) 💵 Payment Status: ${isPaidStatus} 📞 Contact Number: ${contactNumber}`; // Copy to clipboard using Clipboard API navigator.clipboard.writeText(formattedText).then(() => { alert('Order details copied to clipboard!'); }).catch(err => { alert('Failed to copy: ' + err); }); } </script> </body> </html> <?php // Flush the output buffer ob_end_flush(); // No closing PHP tag to prevent unwanted output ?>Detailed Explanation of Changes
-
Including
is_paidin Order Details:- Database Query: Modified the SQL query to fetch
orders.is_paid. - Display: Added a checkbox to toggle the payment status.
- Form Processing: Handled the
is_paidfield during form submission to update the payment status.
- Database Query: Modified the SQL query to fetch
-
Adding Payment Status Checkbox:
- Added a new checkbox input within the form to allow administrators to mark the order as paid or not.
- The checkbox reflects the current payment status.
- Upon toggling, the form is submitted to update the
is_paidstatus in the database.
-
Handling Form Submission for Payment Status:
- Added logic to process the
is_paidcheckbox. - Updated the
orderstable'sis_paidcolumn based on the checkbox state. - Displayed appropriate success or error messages based on the outcome.
- Added logic to process the
-
Updating the JavaScript
copyOrderDetailsFunction:- Incorporated the
is_paidstatus into the copied order details for comprehensive information.
- Incorporated the
-
Styling Enhancements:
- Added badge colors for
PaidandNot Paidstatuses in the CSS:rootfor consistent styling.
- Added badge colors for
Final Notes
- Data Integrity: Ensure that the
is_paidstatus is accurately reflected across all parts of the application to maintain data integrity. - User Permissions: Restrict who can update the payment status based on user roles to prevent unauthorized changes.
- Validation & Security: Always validate and sanitize inputs to protect against SQL injection and other security threats. The provided code includes basic sanitization using
sanitize_input(). Consider implementing more robust security measures as needed. - Testing: After making these changes, thoroughly test the application to ensure that:
- The new
is_paidcolumn is correctly added and updated. - The checkout forms reflect and update the payment status as intended.
- Other functionalities remain unaffected.
- The new
Implementing these changes will allow you to effectively track and manage the payment status of orders within your Kaak Alia Management System.
- Update the Database Schema: