<?php
// Test script to verify seller_dashboard.php API operations directly
$_SERVER['HTTP_HOST'] = 'localhost';
require_once __DIR__ . '/../db.php';

// Mock admin session
$_SESSION['user_id'] = 1;
$_SESSION['role'] = 'admin';
$_SESSION['seller_status'] = 'approved';

echo "--- 1. Testing INSERT Product ---\n";
$stmt = $conn->prepare("INSERT INTO products (seller_id, category_id, product_name, description, price, original_price, stock, image_url, badge, badge_text, approval_status, is_active) VALUES (1, 'electronics', 'TEST Product Unit', 'Test description', 999.00, 1590.00, 10, 'https://images.unsplash.com/photo-1505740420928-5e560c06d30e?w=800', 'new', 'มาใหม่', 'approved', 1)");
$stmt->execute();
$newId = $conn->insert_id;
$stmt->close();
echo "Inserted Product ID: " . $newId . "\n";

echo "--- 2. Testing UPDATE Product (Edit Name & Price & Badge) ---\n";
$stmt = $conn->prepare("UPDATE products SET product_name = 'TEST Product Updated Name', price = 1290.00, badge = 'hot', badge_text = 'ขายดี' WHERE product_id = ?");
$stmt->bind_param('i', $newId);
$stmt->execute();
$stmt->close();

$checkStmt = $conn->prepare("SELECT product_name, price, badge, badge_text FROM products WHERE product_id = ?");
$checkStmt->bind_param('i', $newId);
$checkStmt->execute();
$row = $checkStmt->get_result()->fetch_assoc();
$checkStmt->close();
echo "Updated Data: " . json_encode($row, JSON_UNESCAPED_UNICODE) . "\n";

echo "--- 3. Testing DELETE Product ---\n";
$delStmt = $conn->prepare("DELETE FROM products WHERE product_id = ?");
$delStmt->bind_param('i', $newId);
$delStmt->execute();
$delStmt->close();

$verifyStmt = $conn->prepare("SELECT product_id FROM products WHERE product_id = ?");
$verifyStmt->bind_param('i', $newId);
$verifyStmt->execute();
$rem = $verifyStmt->get_result()->fetch_assoc();
$verifyStmt->close();

if (!$rem) {
    echo "Product successfully deleted from Database!\n";
} else {
    echo "Delete failed!\n";
}
?>