-- =============================================
-- JOGLO KOI RESTAURANT MANAGEMENT SYSTEM
-- Seed Data
-- =============================================

-- =============================================
-- ROLES
-- =============================================

INSERT INTO roles (name, description) VALUES
('Super Admin', 'Akses penuh ke seluruh sistem'),
('Kasir', 'Mengelola POS, order, dan pembayaran'),
('Admin Gudang', 'Mengelola stok, pembelian, dan supplier'),
('Manager', 'Mengelola karyawan, payroll, dan laporan');

-- =============================================
-- PERMISSIONS
-- =============================================

INSERT INTO permissions (name, module) VALUES
-- Dashboard
('dashboard.view', 'dashboard'),
-- Orders
('orders.view', 'orders'),
('orders.create', 'orders'),
('orders.update', 'orders'),
('orders.cancel', 'orders'),
('orders.refund', 'orders'),
-- POS
('pos.access', 'pos'),
('pos.process_payment', 'pos'),
('pos.split_bill', 'pos'),
-- Menu
('menus.view', 'menus'),
('menus.create', 'menus'),
('menus.update', 'menus'),
('menus.delete', 'menus'),
('categories.view', 'categories'),
('categories.manage', 'categories'),
-- Tables
('tables.view', 'tables'),
('tables.manage', 'tables'),
('tables.update_status', 'tables'),
-- Reservations
('reservations.view', 'reservations'),
('reservations.create', 'reservations'),
('reservations.update', 'reservations'),
('reservations.cancel', 'reservations'),
-- Kitchen
('kitchen.view', 'kitchen'),
('kitchen.update_status', 'kitchen'),
-- Inventory
('inventory.view', 'inventory'),
('inventory.receive', 'inventory'),
('inventory.adjust', 'inventory'),
('inventory.waste', 'inventory'),
('inventory.transfer', 'inventory'),
('inventory.opname', 'inventory'),
-- Purchases
('purchases.view', 'purchases'),
('purchases.create', 'purchases'),
('purchases.update', 'purchases'),
('purchases.approve', 'purchases'),
-- Suppliers
('suppliers.view', 'suppliers'),
('suppliers.manage', 'suppliers'),
-- Expenses
('expenses.view', 'expenses'),
('expenses.create', 'expenses'),
('expenses.approve', 'expenses'),
-- Employee
('employees.view', 'employees'),
('employees.manage', 'employees'),
-- Attendance
('attendance.view', 'attendance'),
('attendance.manage', 'attendance'),
-- Payroll
('payroll.view', 'payroll'),
('payroll.process', 'payroll'),
('payroll.approve', 'payroll'),
-- Reports
('reports.sales', 'reports'),
('reports.expense', 'reports'),
('reports.profit', 'reports'),
('reports.inventory', 'reports'),
('reports.payroll', 'reports'),
('reports.export', 'reports'),
-- System
('users.manage', 'users'),
('settings.manage', 'settings'),
('audit.view', 'audit');

-- =============================================
-- ROLE PERMISSIONS
-- =============================================

-- Super Admin: ALL permissions
INSERT INTO role_permissions (role_id, permission_id)
SELECT 1, id FROM permissions;-- Kasir permissions
INSERT INTO role_permissions (role_id, permission_id)
SELECT 2, id FROM permissions WHERE name IN (
    'dashboard.view', 'orders.view', 'orders.create', 'orders.update', 'orders.cancel',
    'pos.access', 'pos.process_payment', 'pos.split_bill',
    'menus.view', 'tables.view', 'tables.update_status',
    'reservations.view', 'reservations.create', 'kitchen.view', 'kitchen.update_status',
    'reports.sales'
);

-- Admin Gudang permissions
INSERT INTO role_permissions (role_id, permission_id)
SELECT 3, id FROM permissions WHERE name IN (
    'dashboard.view',
    'inventory.view', 'inventory.receive', 'inventory.adjust', 'inventory.waste',
    'inventory.transfer', 'inventory.opname',
    'purchases.view', 'purchases.create', 'purchases.update',
    'suppliers.view', 'suppliers.manage',
    'reports.inventory'
);-- Manager permissions
INSERT INTO role_permissions (role_id, permission_id)
SELECT 4, id FROM permissions WHERE name IN (
    'dashboard.view', 'reservations.view', 'reservations.update',
    'employees.view', 'employees.manage',
    'attendance.view', 'attendance.manage',
    'payroll.view', 'payroll.process', 'payroll.approve',
    'expenses.view', 'expenses.create', 'expenses.approve',
    'reports.sales', 'reports.expense', 'reports.profit', 'reports.payroll',
    'reports.export', 'orders.view', 'orders.refund',
    'kitchen.view', 'kitchen.update_status'
);

-- =============================================
-- USERS (Password: password)
-- =============================================

INSERT INTO users (username, password_hash, full_name, email, role_id) VALUES
('superadmin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Super Admin', 'admin@jogloKoi.com', 1),
('kasir', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Kasir Utama', 'kasir@jogloKoi.com', 2),
('gudang', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Admin Gudang', 'gudang@jogloKoi.com', 3),
('manager', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Manager', 'manager@jogloKoi.com', 4);

-- =============================================
-- TABLE AREAS
-- =============================================

INSERT INTO table_areas (name, description, sort_order) VALUES
('Area Joglo', 'Area utama dengan konsep joglo', 1),
('Area Kolam Koi', 'Area dekat kolam ikan koi', 2),
('Area Taman', 'Area outdoor taman', 3),
('Area VIP', 'Area privat untuk acara khusus', 4);

-- =============================================
-- RESTAURANT TABLES
-- =============================================

INSERT INTO restaurant_tables (area_id, number, name, capacity, status) VALUES
(1, 'J-01', 'Joglo Meja 1', 4, 'available'),
(1, 'J-02', 'Joglo Meja 2', 4, 'available'),
(1, 'J-03', 'Joglo Meja 3', 6, 'available'),
(1, 'J-04', 'Joglo Meja 4', 8, 'available'),
(2, 'K-01', 'Koi Meja 1', 4, 'available'),
(2, 'K-02', 'Koi Meja 2', 4, 'available'),
(2, 'K-03', 'Koi Meja 3', 6, 'available'),
(3, 'T-01', 'Taman Meja 1', 4, 'available'),
(3, 'T-02', 'Taman Meja 2', 6, 'available'),
(4, 'V-01', 'VIP Ruangan 1', 10, 'available'),
(4, 'V-02', 'VIP Ruangan 2', 15, 'available');

-- =============================================
-- MENU CATEGORIES
-- =============================================

INSERT INTO menu_categories (name, description, icon, sort_order) VALUES
('New Menu Koito Resto', NULL, 'utensils', 1),
('Soup', NULL, 'utensils', 2),
('Nasi Goreng', NULL, 'utensils', 3),
('Vegetable', NULL, 'utensils', 4),
('Signature Dishes', NULL, 'utensils', 5),
('Ayam dan Bebek', NULL, 'utensils', 6),
('Ikan dan Seafood', NULL, 'utensils', 7),
('Appetizer/Cemilan', NULL, 'utensils', 8),
('Croissant', NULL, 'utensils', 9),
('Spaghetti', NULL, 'utensils', 10),
('Coffe (Hot/Ice)', NULL, 'utensils', 11),
('Noncoffe (Hot/Ice)', NULL, 'utensils', 12),
('Milkshake', NULL, 'utensils', 13),
('Drink Pitcher', NULL, 'utensils', 14),
('Paket Family', NULL, 'utensils', 15),
('Festive Weekend', NULL, 'utensils', 16);

-- =============================================
-- MENUS
-- =============================================

INSERT INTO menus (category_id, sku, name, description, price, cost_price, is_available) VALUES
((SELECT id FROM menu_categories WHERE name = 'New Menu Koito Resto' AND deleted_at IS NULL), 'NM-001', 'Tahu Cabe Garam', NULL, 19000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'New Menu Koito Resto' AND deleted_at IS NULL), 'NM-002', 'Chiken Steak (New)', NULL, 35000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'New Menu Koito Resto' AND deleted_at IS NULL), 'NM-003', 'Mix Platter (Kentang Goreng, Sosis, Nugget)', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Soup' AND deleted_at IS NULL), 'SP-001', 'Soup Iga Reguler', NULL, 40000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Soup' AND deleted_at IS NULL), 'SP-002', 'Iga Premium', NULL, 55000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Soup' AND deleted_at IS NULL), 'SP-003', 'Ikan Koito', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Soup' AND deleted_at IS NULL), 'SP-004', 'Manten', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-001', 'Nasi Goreng Ayam', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-002', 'Nasi Goreng Teri Peti', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-003', 'Nasi Goreng Kouitoresto Istimewa', NULL, 40000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-004', 'Nasi Goreng Chef Recommendation', NULL, 35000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-005', 'Nasi Goreng Paru', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-006', 'Nasi Goreng Seafood', NULL, 45000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Nasi Goreng' AND deleted_at IS NULL), 'NG-007', 'Nasi Goreng Lada Hitam', NULL, 39000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Vegetable' AND deleted_at IS NULL), 'VG-001', 'Urap Mentah Pedas Manis', NULL, 16000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Vegetable' AND deleted_at IS NULL), 'VG-002', 'CA Kangkung', NULL, 18000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Vegetable' AND deleted_at IS NULL), 'VG-003', 'CA Brokoli Bawang Putih', NULL, 39000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Vegetable' AND deleted_at IS NULL), 'VG-004', 'Capcay', NULL, 22000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Vegetable' AND deleted_at IS NULL), 'VG-005', 'Jamur Bledos', NULL, 22000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-001', 'Cumi Pedas Masak Kelapa', NULL, 45000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-002', 'Udang Masak Khas Koito', NULL, 45000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-003', 'Paru Masak Kandis', NULL, 28000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-004', 'Paru Goreng Daun Jeruk', NULL, 27000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-005', 'Bebek Bamby', NULL, 36000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-006', 'Bebek Rica Pandan', NULL, 36000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-007', 'Bebek Pengantin', NULL, 37000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-008', 'Bebek BBQ', NULL, 38000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-009', 'Bebek Sinulingga', NULL, 47000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-010', 'Cumi Sinulingga', NULL, 47000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Signature Dishes' AND deleted_at IS NULL), 'SD-011', 'Udang Bawang Cais', NULL, 49000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-001', 'Ayam Kampung Goreng', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-002', 'Ayam Kampung Bakar', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-003', 'Bebek Goreng', NULL, 38000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-004', 'Bebek Bakar', NULL, 39000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-005', 'Chiken Steak', NULL, 45000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ayam dan Bebek' AND deleted_at IS NULL), 'AB-006', 'Chiken Steak', NULL, 35000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-001', 'Gurame Goreng', NULL, 37000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-002', 'Gurame Terbang', NULL, 42000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-003', 'Gurame Asam Manis', NULL, 47000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-004', 'Gurame Bakar (Manis/Pedas/Rujak)', NULL, 40000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-005', 'Nila Goreng', NULL, 35000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-006', 'Nila Bakar (Manis/Pedas/Rujak)', NULL, 38000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-007', 'Cumi Goreng', NULL, 37000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Ikan dan Seafood' AND deleted_at IS NULL), 'IS-008', 'Iga Sapi Bakar', NULL, 47000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-001', 'Kentang Goreng', NULL, 18000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-002', 'Dimsum', NULL, 28000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-003', 'Pisang Goreng Khas Koito', NULL, 18000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-004', 'Pisang Goreng Keju', NULL, 22000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-005', 'Pisang Goreng Coklat', NULL, 22000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-006', 'Lumpia Goreng', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-007', 'Jamur Crisppy', NULL, 17000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-008', 'Mendoan', NULL, 13000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Appetizer/Cemilan' AND deleted_at IS NULL), 'AC-009', 'Mixed Fruit Salad', NULL, 34000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Croissant' AND deleted_at IS NULL), 'CR-001', 'Croissant Keju', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Croissant' AND deleted_at IS NULL), 'CR-002', 'Croissant Coklat', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Croissant' AND deleted_at IS NULL), 'CR-003', 'Croissant Red Velvet', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Croissant' AND deleted_at IS NULL), 'CR-004', 'Croissant Sandwich', NULL, 30000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Spaghetti' AND deleted_at IS NULL), 'PG-001', 'Spaghetti Sauce Daging', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Spaghetti' AND deleted_at IS NULL), 'PG-002', 'Spaghetti Bawang Cabe', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-001', 'Americano', NULL, 19000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-002', 'Cappucino', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-003', 'Coffe Latte', NULL, 21000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-004', 'Hazelnut Latte', NULL, 21000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-005', 'Caramel Latte', NULL, 21500, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-006', 'Vanila Latte', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Coffe (Hot/Ice)' AND deleted_at IS NULL), 'CF-007', 'Kopi Susu', NULL, 19000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-001', 'Origial Tea', NULL, 9000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-002', 'Lemon Tea', NULL, 15000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-003', 'Lychee Tea', NULL, 15000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-004', 'Orange', NULL, 19000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-005', 'Thai Tea', NULL, 21000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-006', 'Greentea', NULL, 21000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-007', 'Chocolate', NULL, 23000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-008', 'Teh Madu Jahe', NULL, 19000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-009', 'Avocado', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-010', 'Guava', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-011', 'Mango', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-012', 'Melon', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-013', 'Semangka', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Noncoffe (Hot/Ice)' AND deleted_at IS NULL), 'NC-014', 'Strawberry', NULL, 20000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Milkshake' AND deleted_at IS NULL), 'MS-001', 'Milkshake Chocolate', NULL, 27000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Milkshake' AND deleted_at IS NULL), 'MS-002', 'Milkshake Strawberry', NULL, 27000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Milkshake' AND deleted_at IS NULL), 'MS-003', 'Milkshake Vanila', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Milkshake' AND deleted_at IS NULL), 'MS-004', 'Milkshake Cookies & Cream', NULL, 21000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Drink Pitcher' AND deleted_at IS NULL), 'DP-001', 'Ice Tea Pitcher', NULL, 26000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Drink Pitcher' AND deleted_at IS NULL), 'DP-002', 'Ice Lemon Tea Pitcher', NULL, 23000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Drink Pitcher' AND deleted_at IS NULL), 'DP-003', 'Ice Lychee Tea Pitcher', NULL, 25000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-001', 'Paket Joglo (3 Orang)', NULL, 187000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-002', 'Paket Limasan (3 Orang)', NULL, 187000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-003', 'Paket Lesehan (3 Orang)', NULL, 177000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-004', 'Paket Galery Koito (4 Orang)', NULL, 207000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-005', 'Chef Recommendation (10 Orang)', NULL, 600000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-006', 'Menu Extravaganza (10 Orang)', NULL, 999000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Paket Family' AND deleted_at IS NULL), 'PF-007', 'Chef Recommendation Spesial (10 Orang)', NULL, 1550000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Festive Weekend' AND deleted_at IS NULL), 'FW-001', '1 Kg Gurame Bakar + Pitcher Ice Tea', NULL, 145000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Festive Weekend' AND deleted_at IS NULL), 'FW-002', '1 Kg Nila Bakar + Pitcher Ice Lemon Tea', NULL, 145000, 0, 1),
((SELECT id FROM menu_categories WHERE name = 'Festive Weekend' AND deleted_at IS NULL), 'FW-003', '1 Kg Iga Bakar + Pitcher Ice Lychee Tea', NULL, 180000, 0, 1);

-- INGREDIENT CATEGORIES
-- =============================================

INSERT INTO ingredient_categories (name, description) VALUES
('Ikan & Seafood', 'Bahan laut'),
('Daging', 'Daging sapi, ayam, dll'),
('Sayuran', 'Sayuran segar'),
('Bumbu & Rempah', 'Bumbu masak'),
('Minyak & Saus', 'Minyak goreng dan saus'),
('Tepung & Tepung', 'Tepung terigu, maizena'),
('Minuman', 'Bahan minuman'),
('Susu & Dairy', 'Susu, keju, mentega'),
('Roti & Pastry', 'Bahan roti'),
('Lainnya', 'Bahan lainnya');

-- =============================================
-- UNITS
-- =============================================

INSERT INTO units (name, abbreviation) VALUES
('Kilogram', 'Kg'),
('Gram', 'g'),
('Liter', 'L'),
('Mililiter', 'ml'),
('Pieces', 'Pcs'),
('Box', 'Box'),
('Pack', 'Pack'),
('Botol', 'Botol'),
('Dus', 'Dus'),
('Ikat', 'Ikat');

-- =============================================
-- INGREDIENTS
-- =============================================

INSERT INTO ingredients (code, name, item_type, category_id, unit_id, purchase_price, minimum_stock, maximum_stock, current_stock) VALUES
('ING-001', 'Ikan Mas', 'Ikan Mas', 'bahan', 1, 1, 35000, 5, 50, 20),
('ING-002', 'Ikan Mackerel', 'Ikan Mackerel', 'bahan', 1, 1, 45000, 3, 30, 15),
('ING-003', 'Udang', 'Udang', 'bahan', 1, 1, 80000, 2, 20, 10),
('ING-004', 'Cumi', 'Cumi', 'bahan', 1, 1, 70000, 2, 15, 8),
('ING-005', 'Ayam Utuh', 'Ayam Utuh', 'bahan', 2, 1, 32000, 5, 40, 20),
('ING-006', 'Daging Sapi', 'Daging Sapi', 'bahan', 2, 1, 120000, 3, 20, 10),
('ING-007', 'Iga Sapi', 'Iga Sapi', 'bahan', 2, 1, 150000, 2, 15, 8),
('ING-008', 'Telur', 'Telur', 'bahan', 2, 5, 25000, 30, 200, 100),
('ING-009', 'Nasi', 'Nasi', 'bahan', 10, 1, 12000, 10, 100, 50),
('ING-010', 'Mie', 'Mie', 'bahan', 10, 7, 8000, 10, 100, 40),
('ING-011', 'Bawang Merah', 'Bawang Merah', 'bahan', 3, 1, 25000, 2, 20, 10),
('ING-012', 'Bawang Putih', 'Bawang Putih', 'bahan', 3, 1, 30000, 2, 20, 10),
('ING-013', 'Cabai Merah', 'Cabai Merah', 'bahan', 3, 1, 40000, 1, 15, 8),
('ING-014', 'Tomat', 'Tomat', 'bahan', 3, 1, 15000, 2, 20, 10),
('ING-015', 'Selada', 'Selada', 'bahan', 3, 5, 5000, 10, 50, 25),
('ING-016', 'Kentang', 'Kentang', 'bahan', 3, 1, 12000, 5, 30, 15),
('ING-017', 'Minyak Goreng', 'Minyak Goreng', 'bahan', 5, 3, 18000, 5, 30, 15),
('ING-018', 'Kecap Manis', 'Kecap Manis', 'bahan', 5, 8, 15000, 5, 20, 10),
('ING-019', 'Saus Tiram', 'Saus Tiram', 'bahan', 5, 8, 12000, 3, 15, 8),
('ING-020', 'Garam', 'Garam', 'bahan', 4, 1, 5000, 2, 10, 5),
('ING-021', 'Gula', 'Gula', 'bahan', 4, 1, 12000, 3, 15, 8),
('ING-022', 'Merica', 'Merica', 'bahan', 4, 2, 50000, 0.5, 3, 1.5),
('ING-023', 'Tepung Terigu', 'Tepung Terigu', 'bahan', 6, 1, 10000, 5, 30, 15),
('ING-024', 'Tepung Maizena', 'Tepung Maizena', 'bahan', 6, 1, 15000, 2, 15, 8),
('ING-025', 'Teh', 'Teh', 'bahan', 7, 7, 25000, 5, 20, 10),
('ING-026', 'Gula Pasir', 'Gula Pasir', 'bahan', 4, 1, 14000, 5, 30, 15),
('ING-027', 'Susu Segar', 'Susu Segar', 'bahan', 8, 8, 18000, 5, 20, 10),
('ING-028', 'Mentega', 'Mentega', 'bahan', 8, 1, 28000, 2, 10, 5),
('ING-029', 'Keju', 'Keju', 'bahan', 8, 1, 60000, 1, 5, 3),
('ING-030', 'Roti Tawar', 'Roti Tawar', 'bahan', 9, 6, 15000, 3, 15, 8),
('ING-031', 'Alpukat', 'Alpukat', 'bahan', 3, 5, 8000, 5, 30, 15),
('ING-032', 'Mangga', 'Mangga', 'bahan', 3, 5, 10000, 5, 30, 15),
('ING-033', 'Jeruk', 'Jeruk', 'bahan', 3, 5, 6000, 10, 50, 30),
('ING-034', 'Kopi Bubuk', 'Kopi Bubuk', 'bahan', 7, 7, 80000, 1, 5, 3),
('ING-035', 'Susu Kental Manis', 'Susu Kental Manis', 'bahan', 8, 8, 12000, 5, 20, 10);

-- Peralatan masak (stok peralatan masak)
INSERT INTO ingredients (code, name, item_type, category_id, unit_id, purchase_price, minimum_stock, maximum_stock, current_stock) VALUES
('EQP-001', 'Wajan', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 150000, 1, 10, 5),
('EQP-002', 'Panci Besar', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 250000, 1, 10, 5),
('EQP-003', 'Panci Kecil', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 120000, 1, 10, 5),
('EQP-004', 'Wajan Deep Fryer', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 400000, 1, 10, 5),
('EQP-005', 'Pisau Dapur', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 75000, 1, 10, 5),
('EQP-006', 'Talenan', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 45000, 1, 10, 5),
('EQP-007', 'Spatula', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 20000, 1, 10, 5),
('EQP-008', 'Sendok Sayur', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 18000, 1, 10, 5),
('EQP-009', 'Centong Nasi', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 20000, 1, 10, 5),
('EQP-010', 'Kompor', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 350000, 1, 10, 5),
('EQP-011', 'Tabung Gas 3kg', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 220000, 1, 10, 5),
('EQP-012', 'Rice Cooker', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 450000, 1, 10, 5),
('EQP-013', 'Blender', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 380000, 1, 10, 5),
('EQP-014', 'Timbangan Dapur', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 120000, 1, 10, 5),
('EQP-015', 'Loyang', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 60000, 1, 10, 5),
('EQP-016', 'Teko Listrik', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 250000, 1, 10, 5),
('EQP-017', 'Freezer', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 3500000, 1, 10, 5),
('EQP-018', 'Etalase Kaca', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 1500000, 1, 10, 5),
('EQP-019', 'Sendok & Garpu', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 15000, 1, 10, 5),
('EQP-020', 'Gelas', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 12000, 1, 10, 5),
('EQP-021', 'Piring', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 18000, 1, 10, 5),
('EQP-022', 'Mangkuk', 'peralatan', NULL, (SELECT id FROM units WHERE abbreviation = 'Pcs'), 15000, 1, 10, 5);


-- =============================================
-- WAREHOUSES
-- =============================================

INSERT INTO warehouses (name, description) VALUES
('Gudang Utama', 'Gudang utama penyimpanan bahan'),
('Dapur', 'Penyimpanan bahan di dapur'),
('Bar', 'Penyimpanan bahan minuman');

-- =============================================
-- RECIPES
-- =============================================

-- Ikan Bakar
INSERT INTO recipes (menu_id, description, estimated_cost) VALUES ((SELECT id FROM menus WHERE sku='IS-001'), 'Resep Gurame Goreng', 24000);
INSERT INTO recipe_items (recipe_id, ingredient_id, quantity, unit_id) VALUES
(1, 1, 0.5, 1),    -- Ikan Mas 0.5 Kg
(1, 11, 0.05, 2),  -- Bawang Merah 50g
(1, 12, 0.03, 2),  -- Bawang Putih 30g
(1, 13, 0.02, 2),  -- Cabai 20g
(1, 17, 0.02, 3),  -- Minyak 20ml
(1, 18, 0.01, 3);  -- Kecap 10ml

-- Nasi Goreng
INSERT INTO recipes (menu_id, description, estimated_cost) VALUES ((SELECT id FROM menus WHERE sku='NG-001'), 'Resep Nasi Goreng Ayam', 12000);
INSERT INTO recipe_items (recipe_id, ingredient_id, quantity, unit_id) VALUES
(2, 9, 0.3, 1),    -- Nasi 300g
(2, 8, 1, 5),      -- Telur 1 pcs
(2, 11, 0.02, 2),  -- Bawang Merah 20g
(2, 12, 0.01, 2),  -- Bawang Putih 10g
(2, 13, 0.01, 2),  -- Cabai 10g
(2, 17, 0.015, 3), -- Minyak 15ml
(2, 18, 0.01, 3);  -- Kecap 10ml

-- Tom Yum
INSERT INTO recipes (menu_id, description, estimated_cost) VALUES ((SELECT id FROM menus WHERE sku='SP-001'), 'Resep Soup Iga Reguler', 15000);
INSERT INTO recipe_items (recipe_id, ingredient_id, quantity, unit_id) VALUES
(3, 3, 0.1, 1),    -- Udang 100g
(3, 4, 0.05, 1),   -- Cumi 50g
(3, 14, 0.05, 1),  -- Tomat 50g
(3, 11, 0.02, 2),  -- Bawang Merah 20g
(3, 12, 0.01, 2),  -- Bawang Putih 10g
(3, 13, 0.01, 2),  -- Cabai 10g
(3, 20, 0.005, 2); -- Garam 5g

-- =============================================
-- SUPPLIERS
-- =============================================

INSERT INTO suppliers (name, contact_person, phone, whatsapp, address) VALUES
('Toko Ikan Segar Pak Budi', 'Pak Budi', '0812-3456-7890', '0812-3456-7890', 'Pasar Ikan Klaten'),
('Distributor Daging Sapi Mas Joko', 'Mas Joko', '0856-7890-1234', '0856-7890-1234', 'Solo'),
('Sayur Segar Bu Ani', 'Bu Ani', '0878-9012-3456', '0878-9012-3456', 'Pasar Tradisional Polanharjo'),
('Minyak & Bumbu Berkah', 'Pak Harto', '0813-4567-8901', '0813-4567-8901', 'Grosir Bumbu Klaten'),
('Toko Minuman Segar', 'Mas Dwi', '0821-6789-0123', '0821-6789-0123', 'Distributor Minuman Klaten');

-- =============================================
-- EXPENSE CATEGORIES
-- =============================================

INSERT INTO expense_categories (name, description) VALUES
('Listrik', 'Biaya listrik bulanan'),
('Air', 'Biaya air bersih'),
('Gas', 'Gas memasak'),
('Internet', 'Biaya internet'),
('Maintenance', 'Perbaikan peralatan'),
('Transportasi', 'Biaya transportasi'),
('Kebersihan', 'Alat kebersihan'),
('Marketing', 'Biaya promosi'),
('Perlengkapan', 'Perlengkapan restoran'),
('Lainnya', 'Pengeluaran lainnya');

-- =============================================
-- EMPLOYEES
-- =============================================

INSERT INTO employees (employee_code, name, phone, position, join_date, status, basic_salary, salary_type) VALUES
('EMP-001', 'Andi Pratama', '0812-1111-2222', 'Kasir', '2025-01-15', 'active', 3500000, 'monthly'),
('EMP-002', 'Siti Rahayu', '0813-2222-3333', 'Koki', '2025-01-15', 'active', 4000000, 'monthly'),
('EMP-003', 'Budi Santoso', '0814-3333-4444', 'Waiter', '2025-02-01', 'active', 3000000, 'monthly'),
('EMP-004', 'Dewi Lestari', '0815-4444-5555', 'Koki', '2025-03-01', 'active', 3800000, 'monthly'),
('EMP-005', 'Eko Prasetyo', '0816-5555-6666', 'Admin Gudang', '2025-01-15', 'active', 3500000, 'monthly');

-- =============================================
-- CUSTOMERS
-- =============================================

INSERT INTO customers (name, phone, notes) VALUES
('Keluarga Wibowo', '0812-9999-1111', 'Pelanggan rutin, suka duduk area kolam koi'),
('Rombongan Anak SMAN 1 Klaten', '0813-8888-2222', 'Biasa datang Sabtu sore'),
('Pak Joko', '0814-7777-3333', 'Suka ikan bakar'),
('Bu Rina', '0815-6666-4444', 'Hobi memesan dessert'),
('Kantor Dinas Pendidikan', '0816-5555-5555', 'Order untuk acara kantor');

-- =============================================
-- SETTINGS
-- =============================================

INSERT INTO settings (setting_key, setting_value, setting_type, description) VALUES
('restaurant_name', 'Joglo Koi Restaurant', 'text', 'Nama restoran'),
('restaurant_address', 'Lembu, Jimus, Polanharjo, Klaten, Jawa Tengah', 'text', 'Alamat restoran'),
('restaurant_phone', '0878-1810-9887', 'text', 'Nomor telepon'),
('restaurant_instagram', '@joglokoirestaurant', 'text', 'Instagram'),
('tax_rate', '10', 'number', 'Persentase pajak (PPN)'),
('service_charge', '5', 'number', 'Persentase service charge'),
('currency', 'IDR', 'text', 'Mata uang'),
('timezone', 'Asia/Jakarta', 'text', 'Timezone'),
('receipt_footer', 'Terima kasih telah berkunjung ke Joglo Koi Restaurant!\nSelamat menikmati hidangan Anda.', 'text', 'Footer struk'),
('low_stock_threshold', '5', 'number', 'Batas minimum stok untuk alert'),
('opening_hours_monday', '10:00-22:00', 'text', 'Jam buka Senin'),
('opening_hours_tuesday', '10:00-22:00', 'text', 'Jam buka Selasa'),
('opening_hours_wednesday', '10:00-22:00', 'text', 'Jam buka Rabu'),
('opening_hours_thursday', '10:00-22:00', 'text', 'Jam buka Kamis'),
('opening_hours_friday', '10:00-22:00', 'text', 'Jam buka Jumat'),
('opening_hours_saturday', '10:00-23:00', 'text', 'Jam buka Sabtu'),
('opening_hours_sunday', '10:00-22:00', 'text', 'Jam buka Minggu');