<?php
require 'db/config.php';
$db = db();
$count = $db->query('SELECT COUNT(*) FROM products')->fetchColumn();
if ($count == 0) {
    $db->exec("INSERT INTO products (branch_id, category_id, name, sku, cost_price, selling_price, stock) VALUES 
        (1, 1, 'Americano', 'COF001', 15000, 25000, 100),
        (1, 1, 'Caffe Latte', 'COF002', 20000, 35000, 50),
        (1, 2, 'Chocolate Cake', 'FOD001', 25000, 45000, 20),
        (2, 1, 'Ice Tea', 'BEV001', 5000, 12000, 200)");
    echo "Seed products success";
} else {
    echo "Products already exist";
}