<?php
include '../config.php';
include 'auth.php';

// Check if ID is set
if (!isset($_GET['id']) || empty($_GET['id'])) {
    $_SESSION['error_message'] = 'ไม่พบรหัสสินค้าที่ต้องการลบ';
    header("Location: product-list.php");
    exit;
}

$id = mysqli_real_escape_string($conn, $_GET['id']);

// Check if product exists
$check_query = "SELECT * FROM products WHERE id = $id";
$check_result = mysqli_query($conn, $check_query);

if (mysqli_num_rows($check_result) == 0) {
    $_SESSION['error_message'] = 'ไม่พบข้อมูลสินค้า';
    header("Location: product-list.php");
    exit;
}

$product = mysqli_fetch_assoc($check_result);

// Check if product is used in invoice_items
$invoice_query = "SELECT COUNT(*) as count FROM invoice_items WHERE product_id = $id";
$invoice_result = mysqli_query($conn, $invoice_query);
$invoice_row = mysqli_fetch_assoc($invoice_result);

if ($invoice_row['count'] > 0) {
    $_SESSION['error_message'] = 'ไม่สามารถลบข้อมูลสินค้าได้ เนื่องจากมีการใช้งานในใบกำกับภาษี';
    header("Location: product-list.php");
    exit;
}

// Delete product image if exists
if (!empty($product['image'])) {
    $image_path = "../uploads/images/" . $product['image'];
    if (file_exists($image_path)) {
        unlink($image_path);
    }
}

// Delete product
$query = "DELETE FROM products WHERE id = $id";

if (mysqli_query($conn, $query)) {
    $_SESSION['success_message'] = 'ลบข้อมูลสินค้าเรียบร้อยแล้ว';
} else {
    $_SESSION['error_message'] = 'เกิดข้อผิดพลาด: ' . mysqli_error($conn);
}

header("Location: product-list.php");
exit;
?>