-- Seed roles and permissions (cPanel: no USE; run after schema_cpanel.sql)
-- In phpMyAdmin: select your database, then Import this file.

INSERT IGNORE INTO roles (name, description) VALUES
('Admin', 'Full system access'),
('POS User', 'Point of sale and sales'),
('Inventory Manager', 'Inventory, ingredients, purchases'),
('Production Manager', 'Manufacturing and production'),
('Finance', 'Accounting, reports, payments');

INSERT IGNORE INTO permissions (name, description) VALUES
('dashboard', 'View dashboard'),
('users', 'User management'),
('customers', 'Customer management'),
('suppliers', 'Supplier management'),
('products', 'Product management'),
('ingredients', 'Ingredient management'),
('recipes', 'Recipe management'),
('pos', 'Point of sale'),
('sales', 'Sales and invoices'),
('purchases', 'Purchases'),
('production', 'Production / manufacturing'),
('reports', 'Reports'),
('accounting', 'Accounting and ledger'),
('store', 'Online store settings'),
('payroll', 'Payroll and employees');

INSERT IGNORE INTO role_permissions (role_id, permission_id)
SELECT r.id, p.id FROM roles r CROSS JOIN permissions p WHERE r.name = 'Admin';

INSERT IGNORE INTO role_permissions (role_id, permission_id)
SELECT r.id, p.id FROM roles r JOIN permissions p ON p.name IN ('dashboard','pos','sales') WHERE r.name = 'POS User';

INSERT IGNORE INTO role_permissions (role_id, permission_id)
SELECT r.id, p.id FROM roles r JOIN permissions p ON p.name IN ('dashboard','customers','suppliers','products','ingredients','recipes','purchases') WHERE r.name = 'Inventory Manager';

INSERT IGNORE INTO role_permissions (role_id, permission_id)
SELECT r.id, p.id FROM roles r JOIN permissions p ON p.name IN ('dashboard','ingredients','recipes','production') WHERE r.name = 'Production Manager';

INSERT IGNORE INTO role_permissions (role_id, permission_id)
SELECT r.id, p.id FROM roles r JOIN permissions p ON p.name IN ('dashboard','customers','suppliers','sales','purchases','reports','accounting','payroll') WHERE r.name = 'Finance';