prepare("SELECT id FROM users WHERE email = ?"); $uCheck->execute([$email]); $user = $uCheck->fetch(); if ($user) { $user_id = $user['id']; } else { // Create new user $name = explode('@', $email)[0]; $pdo->prepare("INSERT INTO users (name, email, password_hash) VALUES (?, ?, ?)") ->execute([$name, $email, password_hash('123456', PASSWORD_DEFAULT)]); $user_id = $pdo->lastInsertId(); } // Create Order $pdo->prepare("INSERT INTO orders (user_id, total_amount, payment_method, status, user_note) VALUES (?, ?, 'Manual Entry', 'completed', 'Order created by Admin')") ->execute([$user_id, $amount]); $order_id = $pdo->lastInsertId(); // Add Item (Check variants) $vCheck = $pdo->prepare("SELECT id FROM product_variants WHERE product_id = ? LIMIT 1"); $vCheck->execute([$prod_id]); $vid = $vCheck->fetchColumn() ?: 0; $pdo->prepare("INSERT INTO order_items (order_id, product_id, variant_id, qty, price_at_purchase) VALUES (?, ?, ?, 1, ?)") ->execute([$order_id, $prod_id, $vid, $amount]); // Log Action if (function_exists('logActivity')) { logActivity("Manual Order", "Created Order #$order_id for $email"); } header("Location: orders.php?id=$order_id&msg=created"); exit(); } // --- 2. HANDLE STATUS UPDATE --- if (isset($_POST['update_status'])) { $oid = $_POST['order_id']; $new_status = $_POST['status']; $admin_note = $_POST['admin_note']; $key_message = ""; // IF COMPLETED -> AUTO ASSIGN KEYS & REWARD REFERRER if ($new_status == 'completed') { // A. KEYS ASSIGNMENT $stmtItems = $pdo->prepare("SELECT product_id FROM order_items WHERE order_id = ?"); $stmtItems->execute([$oid]); $items = $stmtItems->fetchAll(); foreach ($items as $item) { // Find available key $kStmt = $pdo->prepare("SELECT id, license_key FROM license_keys WHERE product_id = ? AND status = 'available' LIMIT 1"); $kStmt->execute([$item['product_id']]); $keyData = $kStmt->fetch(); if ($keyData) { // Mark key used $pdo->prepare("UPDATE license_keys SET status = 'used', order_id = ? WHERE id = ?")->execute([$oid, $keyData['id']]); $key_message .= "\n\n[LICENSE KEY]\n" . $keyData['license_key']; } } // B. REFERRAL REWARD $uid = $pdo->query("SELECT user_id FROM orders WHERE id=$oid")->fetchColumn(); $refCheck = $pdo->prepare("SELECT * FROM referrals WHERE referred_user_id = ? AND status = 'pending'"); $refCheck->execute([$uid]); $referral = $refCheck->fetch(); if ($referral) { $referrer_id = $referral['referrer_id']; $reward = 50.00; $pdo->prepare("UPDATE referrals SET status = 'verified' WHERE id = ?")->execute([$referral['id']]); $pdo->prepare("UPDATE users SET wallet_balance = wallet_balance + ? WHERE id = ?")->execute([$reward, $referrer_id]); if (function_exists('logActivity')) { logActivity("Referral Reward", "Added ₹$reward to User #$referrer_id for Order #$oid"); } } } $final_note = $admin_note . $key_message; // Update Order $stmt = $pdo->prepare("UPDATE orders SET status = ?, user_note = ? WHERE id = ?"); $stmt->execute([$new_status, $final_note, $oid]); // Log Action if (function_exists('logActivity')) { logActivity("Order Update", "Updated Order #$oid status to: $new_status"); } // EMAIL NOTIFICATION TO CUSTOMER $stmtUser = $pdo->prepare("SELECT o.id, u.name, u.email FROM orders o JOIN users u ON o.user_id = u.id WHERE o.id = ?"); $stmtUser->execute([$oid]); $orderData = $stmtUser->fetch(); if ($orderData) { $to = $orderData['email']; $subject = "Order #$oid Update - Pro Subscription Offers"; $clean_note = nl2br(htmlspecialchars($final_note)); $emailContent = "

Pro Subscription Offers

Hi {$orderData['name']},

Your order status is now: ".ucfirst($new_status)."

$clean_note

Login to Dashboard

"; $headers = "MIME-Version: 1.0" . "\r\n" . "Content-type:text/html;charset=UTF-8" . "\r\n" . "From: Pro Subscription Offers "; @mail($to, $subject, $emailContent, $headers); } header("Location: orders.php?id=" . $oid . "&msg=updated"); exit(); } // --- FETCH DATA --- $products = $pdo->query("SELECT id, name FROM products")->fetchAll(); $order_detail = null; if (isset($_GET['id'])) { // Single Order View $stmt = $pdo->prepare("SELECT o.*, u.name, u.email, u.phone, u.id as user_id FROM orders o JOIN users u ON o.user_id = u.id WHERE o.id = ?"); $stmt->execute([$_GET['id']]); $order_detail = $stmt->fetch(); $stmtItems = $pdo->prepare(" SELECT oi.*, p.name as product_name, v.name as variant_name FROM order_items oi JOIN products p ON oi.product_id = p.id LEFT JOIN product_variants v ON oi.variant_id = v.id WHERE oi.order_id = ? "); $stmtItems->execute([$_GET['id']]); $items = $stmtItems->fetchAll(); } else { // List All Orders $all_orders = $pdo->query("SELECT o.*, u.name, u.email FROM orders o LEFT JOIN users u ON o.user_id = u.id ORDER BY o.created_at DESC")->fetchAll(); } ?> Manage Orders
← Back Print Invoice

Order #

Update Successful!
Manual Order Created!

Customer Info

Name: History

Email:

Phone:

Method:

Payment Proof

Payment Receipt
Click to enlarge
No screenshot uploaded.

Update Status

Order Items

ProductVariantQtyPrice
₹

Orders

IDCustomerTotalStatusDateAction
#
₹ View