-- =============================================
-- Sample Bookings for TODAY and TOMORROW
-- Shows all color types in the calendar
-- =============================================

USE rentygdu_boat_rental;

-- =============================================
-- TODAY's Bookings
-- =============================================

-- 🟢 GREEN - Paid with card (boat_id 1 - ARTEMIDE 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_email`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(1, CURDATE(), '09:00:00', 2.0, 'Marco Bianchi', 'marco@email.com', '+39 333 1234567', 4, 'paid', 'stripe', 120.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- ⚪ GRAY - Cash payment (boat_id 1 - ARTEMIDE 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_email`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(1, CURDATE(), '11:30:00', 1.5, 'Giuseppe Verdi', 'giuseppe@email.com', '+39 345 9876543', 3, 'cash', 'cash', 90.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- 🟡 YELLOW - Office booking (boat_id 2 - EDEN 18)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(2, CURDATE(), '10:00:00', 2.5, 'OFFICE-Francesco Rossi', '+39 338 5555555', 5, 'confirmed', 'office', 175.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- 🔵 BLUE - Admin booking (boat_id 2 - EDEN 18)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(2, CURDATE(), '15:00:00', 1.0, 'ADMIN-Gita Famiglia', '+39 338 5388693', 4, 'confirmed', 'admin', 70.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- 🟢 GREEN - Paid (boat_id 3 - FISHERMAN 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_email`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(3, CURDATE(), '08:30:00', 3.0, 'Andrea Conti', 'andrea@email.com', '+39 347 1112233', 2, 'paid', 'stripe', 195.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- ⚪ GRAY - Cash (boat_id 3 - FISHERMAN 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_email`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(3, CURDATE(), '14:00:00', 1.5, 'Luca Romano', 'luca@email.com', '+39 349 4445566', 3, 'cash', 'cash', 97.50, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- 🟡 YELLOW - Office (boat_id 4 - LADY 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(4, CURDATE(), '09:30:00', 2.0, 'OFFICE-Famiglia Colombo', '+39 335 7778899', 4, 'confirmed', 'office', 110.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- 🟢 GREEN - Paid (boat_id 4 - LADY 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_email`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(4, CURDATE(), '13:00:00', 1.0, 'Sofia Ferrari', 'sofia@email.com', '+39 340 9998877', 2, 'paid', 'stripe', 55.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- =============================================
-- TOMORROW's Bookings
-- =============================================

-- 🟢 GREEN (boat_id 1 - ARTEMIDE 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_email`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(1, DATE_ADD(CURDATE(), INTERVAL 1 DAY), '10:00:00', 2.0, 'Paolo Ricci', 'paolo@email.com', '+39 333 1231234', 3, 'paid', 'stripe', 120.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- 🔵 BLUE - Admin (boat_id 1 - ARTEMIDE 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(1, DATE_ADD(CURDATE(), INTERVAL 1 DAY), '14:00:00', 1.5, 'ADMIN-Uscita Amici', '+39 338 5388693', 5, 'confirmed', 'admin', 90.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- ⚪ GRAY - Cash (boat_id 2 - EDEN 18)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_email`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(2, DATE_ADD(CURDATE(), INTERVAL 1 DAY), '08:00:00', 3.0, 'Giulia Marino', 'giulia@email.com', '+39 345 5554444', 4, 'cash', 'cash', 210.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- 🟡 YELLOW - Office (boat_id 2 - EDEN 18)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(2, DATE_ADD(CURDATE(), INTERVAL 1 DAY), '12:00:00', 2.5, 'OFFICE-Gruppo Turisti', '+39 338 5555555', 7, 'confirmed', 'office', 175.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- 🟢 GREEN (boat_id 3 - FISHERMAN 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_email`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(3, DATE_ADD(CURDATE(), INTERVAL 1 DAY), '09:00:00', 1.5, 'Roberto Galli', 'roberto@email.com', '+39 347 3332222', 2, 'paid', 'stripe', 97.50, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- ⚪ GRAY - Cash (boat_id 3 - FISHERMAN 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_email`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(3, DATE_ADD(CURDATE(), INTERVAL 1 DAY), '15:30:00', 2.0, 'Elena Moretti', 'elena@email.com', '+39 349 6667777', 4, 'cash', 'cash', 130.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- 🟡 YELLOW - Office (boat_id 4 - LADY 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(4, DATE_ADD(CURDATE(), INTERVAL 1 DAY), '10:30:00', 1.0, 'OFFICE-Cliente Walk-in', '+39 335 8889999', 3, 'confirmed', 'office', 55.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- 🔵 BLUE - Admin (boat_id 4 - LADY 17)
INSERT INTO `bookings` (`boat_id`, `booking_date`, `start_time`, `duration`, `customer_name`, `customer_phone`, `passengers`, `payment_status`, `payment_method`, `total_amount`, `booking_reference`) VALUES
(4, DATE_ADD(CURDATE(), INTERVAL 1 DAY), '16:00:00', 2.0, 'ADMIN-Manutenzione Test', '+39 338 5388693', 2, 'confirmed', 'admin', 110.00, CONCAT('BOAT-', UNIX_TIMESTAMP(), '-', FLOOR(1000 + RAND() * 9000)));

-- =============================================
-- Summary
-- =============================================
-- TODAY: 8 bookings (2 paid, 2 cash, 2 office, 1 admin, 1 pending)
-- TOMORROW: 8 bookings (3 paid, 2 cash, 2 office, 2 admin)
-- Total: 16 test bookings covering all 4 boats
-- Shows all color types: GREEN, GRAY, YELLOW, BLUE
-- =============================================
