===========================================
  JenQ RESTRO - Upload Guide
===========================================

LOGIN CREDENTIALS:
- URL: yourdomain.com/login
- Email: admin@jenq.com
- Password: password

ACCESS LINKS:
- Dashboard: yourdomain.com/admin
- POS: yourdomain.com/admin/pos
- KDS: yourdomain.com/admin/kds
- Tables: yourdomain.com/admin/tables
- Menu: yourdomain.com/admin/menu
- Reports: yourdomain.com/admin/reports

===========================================
  UPLOAD STEPS (cPanel)
===========================================

1. UPLOAD FILES:
   - Go to cPanel → File Manager → public_html
   - Upload all files from the ZIP
   - Extract the ZIP

2. CREATE DATABASE (cPanel):
   - MySQL Database Wizard
   - Create: jenq_restro
   - Create user & password
   - Grant ALL privileges

3. CONFIGURE .ENV:
   Edit the .env file in file manager:
   
   APP_NAME="JenQ Restro"
   APP_ENV=production
   APP_URL=https://yourdomain.com
   APP_DEBUG=false
   
   DB_CONNECTION=mysql
   DB_HOST=localhost
   DB_DATABASE=jenq_restro
   DB_USERNAME=your_db_username
   DB_PASSWORD=your_db_password

4. RUN SQL IN phpMyAdmin:
   - Go to cPanel → phpMyAdmin
   - Click jenq_restro database
   - Click SQL tab
   - Copy and paste the SQL below

===========================================
  DATABASE SQL - Copy Everything Below
===========================================

-- Add missing columns
ALTER TABLE payments ADD COLUMN outlet_id INT DEFAULT 1;
ALTER TABLE customers ADD COLUMN outlet_id BIGINT DEFAULT 1;
ALTER TABLE customers ADD COLUMN wallet_balance DECIMAL(10,2) DEFAULT 0;
ALTER TABLE tables ADD COLUMN reserved_by VARCHAR(255);
ALTER TABLE tables ADD COLUMN reserved_phone VARCHAR(50);
ALTER TABLE tables ADD COLUMN reservation_time VARCHAR(50);

-- Categories
INSERT INTO menu_categories (outlet_id, name, is_active, created_at) VALUES 
(1, 'Burgers', 1, NOW()),
(1, 'Pizza', 1, NOW()),
(1, 'Drinks', 1, NOW()),
(1, 'Desserts', 1, NOW());

-- Menu Items
INSERT INTO menu_items (outlet_id, category_id, name, price, is_available, created_at) VALUES 
(1, 1, 'Classic Burger', 8.99, 1, NOW()),
(1, 1, 'Cheese Burger', 9.99, 1, NOW()),
(1, 1, 'Bacon Burger', 11.99, 1, NOW()),
(1, 1, 'Chicken Burger', 10.99, 1, NOW()),
(1, 1, 'Veggie Burger', 9.49, 1, NOW()),
(1, 2, 'Margherita Pizza', 12.99, 1, NOW()),
(1, 2, 'Pepperoni Pizza', 14.99, 1, NOW()),
(1, 2, 'BBQ Chicken Pizza', 15.99, 1, NOW()),
(1, 2, 'Vegetarian Pizza', 13.99, 1, NOW()),
(1, 3, 'Cola', 2.50, 1, NOW()),
(1, 3, 'Diet Cola', 2.50, 1, NOW()),
(1, 3, 'Lemonade', 2.99, 1, NOW()),
(1, 3, 'Fresh Orange Juice', 3.99, 1, NOW()),
(1, 3, 'Coffee', 2.99, 1, NOW()),
(1, 3, 'Tea', 2.49, 1, NOW()),
(1, 4, 'Chocolate Cake', 5.99, 1, NOW()),
(1, 4, 'Cheesecake', 6.49, 1, NOW()),
(1, 4, 'Ice Cream', 3.99, 1, NOW());

-- Tables (1-12)
INSERT INTO tables (outlet_id, table_number, capacity, status, created_at) VALUES 
(1, 1, 2, 'available', NOW()),
(1, 2, 2, 'available', NOW()),
(1, 3, 4, 'available', NOW()),
(1, 4, 4, 'available', NOW()),
(1, 5, 4, 'available', NOW()),
(1, 6, 6, 'available', NOW()),
(1, 7, 6, 'available', NOW()),
(1, 8, 8, 'available', NOW()),
(1, 9, 8, 'available', NOW()),
(1, 10, 10, 'available', NOW()),
(1, 11, 10, 'available', NOW()),
(1, 12, 12, 'available', NOW());

-- Admin User (password: password)
INSERT INTO users (name, email, password, outlet_id, role, is_active, created_at) VALUES 
('Owner', 'admin@jenq.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 1, 'owner', 1, NOW());

-- Sample Outlet
INSERT INTO outlets (name, address, phone, is_active, created_at) VALUES 
('Main Restaurant', '123 Main Street', '0123456789', 1, NOW());

===========================================

5. TEST YOUR SITE:
   Visit: https://yourdomain.com/admin
   Login with: admin@jenq.com / password

===========================================
  UPLOAD COMPLETE!
===========================================