15 lines
561 B
PHP
15 lines
561 B
PHP
<?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";
|
|
}
|