prepare("SELECT * FROM products WHERE id = ? AND seller_id = ?"); $stmt->execute([$editId, $user['id']]); $editProduct = $stmt->fetch(); } // Handle Form Submissions (Create or Update Product) if ($_SERVER['REQUEST_METHOD'] === 'POST') { if ($action === 'save') { $prodId = isset($_POST['product_id']) ? intval($_POST['product_id']) : 0; $title = trim($_POST['title'] ?? ''); $description = trim($_POST['description'] ?? ''); $category = trim($_POST['category'] ?? 'Electronics'); $price = floatval($_POST['price'] ?? 0); $stock = intval($_POST['stock'] ?? 0); $sizes = trim($_POST['sizes'] ?? ''); $colors = trim($_POST['colors'] ?? ''); $bannedFound = checkProhibitedKeywords($title, $description); if (!empty($bannedFound)) { $errorMsg = "Listing rejected! Contains prohibited terms: (" . implode(', ', $bannedFound) . "). Items involving weapons, narcotics, gambling, or counterfeit documents are strictly forbidden."; } elseif (empty($title) || empty($description) || $price <= 0 || $stock < 0) { $errorMsg = "Title, description, valid price, and stock are required."; } elseif (empty($category)) { $errorMsg = "Please select or specify a category."; } else { // Handle product images upload $uploadedImages = []; // Check if it's an update and load existing images if ($prodId > 0) { $checkStmt = $pdo->prepare("SELECT images FROM products WHERE id = ? AND seller_id = ?"); $checkStmt->execute([$prodId, $user['id']]); $existing = $checkStmt->fetch(); if ($existing) { $uploadedImages = json_decode($existing['images'], true) ?: []; } } if (isset($_FILES['images']) && $_FILES['images']['name'] !== '') { if ($_FILES['images']['error'] === UPLOAD_ERR_OK) { $tmpName = $_FILES['images']['tmp_name']; $name = $_FILES['images']['name']; $ext = strtolower(pathinfo($name, PATHINFO_EXTENSION)); if (in_array($ext, ['jpg', 'jpeg', 'png', 'webp'])) { $uploadDir = 'uploads/'; if (!is_dir($uploadDir)) { if (!@mkdir($uploadDir, 0777, true)) { $errorMsg = "Failed to create 'uploads' directory. Please create it manually on the server via FileZilla and set permissions to 777 or 755."; } } if (empty($errorMsg)) { $newName = 'prod_' . time() . '.' . $ext; if (move_uploaded_file($tmpName, $uploadDir . $newName)) { $uploadedImages = ['/uploads/' . $newName]; // replace/set as main image } else { $errorMsg = "Failed to upload image. Please check the permissions of the 'uploads' folder (set to 777 or 755 via FileZilla)."; } } } else { $errorMsg = "Only JPG, PNG, and WEBP images are allowed."; } } else { $uploadError = $_FILES['images']['error']; switch ($uploadError) { case UPLOAD_ERR_INI_SIZE: case UPLOAD_ERR_FORM_SIZE: $errorMsg = "The uploaded image file size is too large. Please upload a smaller image."; break; case UPLOAD_ERR_PARTIAL: $errorMsg = "The image file was only partially uploaded."; break; case UPLOAD_ERR_NO_TMP_DIR: $errorMsg = "Missing a temporary folder on the server. Please check your PHP settings."; break; case UPLOAD_ERR_CANT_WRITE: $errorMsg = "Failed to write image file to disk. Check server disk space or folder permissions."; break; default: $errorMsg = "File upload failed with error code: " . $uploadError; break; } } } if (empty($uploadedImages) && $prodId === 0) { $uploadedImages[] = '/uploads/placeholder-product.jpg'; // fallback } if (empty($errorMsg)) { $imagesJson = json_encode($uploadedImages); if ($prodId > 0) { // Update — set status to pending if seller modified listing details $newStatus = ($user['role'] === 'admin') ? 'approved' : 'pending'; $stmt = $pdo->prepare(" UPDATE products SET title = ?, description = ?, price = ?, stock = ?, category = ?, images = ?, sizes = ?, colors = ?, status = ? WHERE id = ? AND seller_id = ? "); try { $stmt->execute([$title, $description, $price, $stock, $category, $imagesJson, $sizes, $colors, $newStatus, $prodId, $user['id']]); $msg = ($newStatus === 'pending') ? "Listing updated and submitted for Admin review." : "Product listing updated successfully!"; header("Location: sell.php?success=" . urlencode($msg)); exit(); } catch (PDOException $e) { $errorMsg = "Failed to update listing: " . $e->getMessage(); } } else { // Create — default status is 'pending' for regular sellers, 'approved' for admins $initialStatus = ($user['role'] === 'admin') ? 'approved' : 'pending'; $stmt = $pdo->prepare(" INSERT INTO products (seller_id, title, description, price, stock, category, images, sizes, colors, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "); try { $stmt->execute([$user['id'], $title, $description, $price, $stock, $category, $imagesJson, $sizes, $colors, $initialStatus]); $msg = ($initialStatus === 'pending') ? "Product submitted for Admin review. It will be published once approved." : "Product listed successfully!"; header("Location: sell.php?success=" . urlencode($msg)); exit(); } catch (PDOException $e) { $errorMsg = "Failed to list item: " . $e->getMessage(); } } } } } } // Handle Delete Action if ($action === 'delete' && isset($_GET['id'])) { $delId = intval($_GET['id']); $stmt = $pdo->prepare("DELETE FROM products WHERE id = ? AND seller_id = ?"); $stmt->execute([$delId, $user['id']]); header("Location: sell.php?success=" . urlencode("Listing deleted successfully.")); exit(); } // Fetch listed products owned by user $stmt = $pdo->prepare("SELECT * FROM products WHERE seller_id = ? ORDER BY created_at DESC"); $stmt->execute([$user['id']]); $myProducts = $stmt->fetchAll(); // Calculate total earnings $earningsStmt = $pdo->prepare(" SELECT SUM(oi.quantity * oi.price) as total FROM order_items oi JOIN products p ON oi.product_id = p.id JOIN orders o ON oi.order_id = o.id WHERE p.seller_id = ? AND o.status != 'Cancelled' "); $earningsStmt->execute([$user['id']]); $earnings = $earningsStmt->fetch()['total'] ?? 0.00; // Fetch sales orders for seller items $ordersStmt = $pdo->prepare(" SELECT DISTINCT o.*, u.username as buyer_name FROM orders o JOIN order_items oi ON o.id = oi.order_id JOIN products p ON oi.product_id = p.id JOIN users u ON o.buyer_id = u.id WHERE p.seller_id = ? ORDER BY o.created_at DESC "); $ordersStmt->execute([$user['id']]); $salesOrders = $ordersStmt->fetchAll(); // Add items belonging specifically to this seller inside the orders foreach ($salesOrders as &$sOrd) { $itemsStmt = $pdo->prepare(" SELECT oi.*, p.title FROM order_items oi JOIN products p ON oi.product_id = p.id WHERE oi.order_id = ? AND p.seller_id = ? "); $itemsStmt->execute([$sOrd['id'], $user['id']]); $sOrd['my_items'] = $itemsStmt->fetchAll(); } renderHeader(__('sell_page_title')); ?>

—

' . __('sell_status_approved') . ''; } elseif ($st === 'pending') { $stBadge = '' . __('sell_status_pending') . ''; } else { $stBadge = '' . __('sell_status_rejected') . ''; } ?>

: TV- :

(Size: , Color: ) x $

Fulfillment: Shipping to: