<?php
require_once __DIR__ . '/config.php';

try {
    $pdo = db();

    // Truncate tables to reset data
    $pdo->exec("SET FOREIGN_KEY_CHECKS = 0;");
    $pdo->exec("TRUNCATE TABLE order_items;");
    $pdo->exec("TRUNCATE TABLE orders;");
    $pdo->exec("TRUNCATE TABLE notifications;");
    $pdo->exec("TRUNCATE TABLE service_request_comments;");
    $pdo->exec("TRUNCATE TABLE service_requests;");
    $pdo->exec("TRUNCATE TABLE sold_serials;");
    $pdo->exec("TRUNCATE TABLE warranty_registrations;");
    $pdo->exec("TRUNCATE TABLE users;");
    $pdo->exec("TRUNCATE TABLE dealers;");
    $pdo->exec("TRUNCATE TABLE products;");
    $pdo->exec("TRUNCATE TABLE product_categories;");
    $pdo->exec("SET FOREIGN_KEY_CHECKS = 1;");

    echo "Tables truncated successfully.\n";

    // Seed Dealers
    $dealers = [
        ['Dealer One', 'contact1@dealerone.com'],
        ['Dealer Two', 'contact2@dealertwo.com'],
    ];
    $stmt = $pdo->prepare("INSERT INTO dealers (name, email) VALUES (?, ?)");
    foreach ($dealers as $dealer) {
        $stmt->execute($dealer);
    }
    echo "Dealers seeded successfully.\n";

    // Get Dealer One ID
    $stmt = $pdo->prepare("SELECT id FROM dealers WHERE name = ?");
    $stmt->execute(['Dealer One']);
    $dealer1_id = $stmt->fetchColumn();

    // Seed Users
    $users = [
        ['dealer', password_hash('password', PASSWORD_DEFAULT), $dealer1_id, 0],
        ['admin', password_hash('admin', PASSWORD_DEFAULT), null, 1],
    ];
    $stmt = $pdo->prepare("INSERT INTO users (username, password_hash, dealer_id, is_admin) VALUES (?, ?, ?, ?)");
    foreach ($users as $user) {
        $stmt->execute($user);
    }
    echo "Users seeded successfully.\n";

    // Seed Product Categories
    $categories = ['Analyzers', 'Reagents', 'Consumables'];
    $stmt = $pdo->prepare("INSERT INTO product_categories (name) VALUES (?)");
    foreach ($categories as $category) {
        $stmt->execute([$category]);
    }
    echo "Product categories seeded successfully.\n";

    // Seed Products
    $products = [
        ['Sensa-100 Analyzer', 'SENSA-100', 'Advanced blood gas analyzer.', 'assets/images/products/sensa-100.jpg', 1, 15000.00, 'features of Sensa-100'],
        ['Sensa-200 Electrolyte Analyzer', 'SENSA-200', 'Automated electrolyte analysis.', 'assets/images/products/sensa-200.jpg', 1, 25000.00, 'features of Sensa-200'],
        ['Blood Gas Reagent Kit', 'REAGENT-BG', 'Reagent kit for Sensa-100.', 'assets/images/products/reagent-bg.jpg', 2, 500.00, 'features of Reagent-BG'],
        ['Replacement Electrode', 'CONSUME-ELECTRODE', 'Replacement electrode for analyzers.', 'assets/images/products/electrode.jpg', 3, 250.00, 'features of Electrode']
    ];
    $stmt = $pdo->prepare("INSERT INTO products (name, model_number, description, image_url, category_id, price, features) VALUES (?, ?, ?, ?, ?, ?, ?)");
    foreach ($products as $product) {
        $stmt->execute($product);
    }
    echo "Products seeded successfully.\n";

} catch (PDOException $e) {
    die("DB ERROR: " . $e->getMessage());
}