75 lines
3.0 KiB
PHP
75 lines
3.0 KiB
PHP
<?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());
|
|
}
|