use ztbd124942;

// 1. Kolekcja: Goście
db.guests.insertMany([
    {
        firstName: "Jan",
        lastName: "Kowalski",
        email: "jan.kowalski@email.com",
        phoneNumber: "+48123456789",
        address: {
            street: "Kwiatowa 12",
            city: "Warszawa",
            postalCode: "01-234",
            country: "Polska"
        },
        dateOfBirth: new Date("1985-05-15"),
        loyaltyPoints: 120,
        registrationDate: new Date("2020-03-10")
    },
    {
        firstName: "Anna",
        lastName: "Nowak",
        email: "anna.nowak@email.com",
        phoneNumber: "+48234567891",
        address: {
            street: "Polna 7",
            city: "Kraków",
            postalCode: "30-001",
            country: "Polska"
        },
        dateOfBirth: new Date("1990-11-22"),
        loyaltyPoints: 45,
        registrationDate: new Date("2021-01-15")
    },
    {
        firstName: "Thomas",
        lastName: "Schmidt",
        email: "thomas.schmidt@email.com",
        phoneNumber: "+49123456789",
        address: {
            street: "Hauptstrasse 8",
            city: "Berlin",
            postalCode: "10115",
            country: "Niemcy"
        },
        dateOfBirth: new Date("1978-07-30"),
        loyaltyPoints: 230,
        registrationDate: new Date("2019-06-20")
    },
    {
        firstName: "Maria",
        lastName: "Garcia",
        email: "maria.garcia@email.com",
        phoneNumber: "+34612345678",
        address: {
            street: "Calle Mayor 15",
            city: "Barcelona",
            postalCode: "08001",
            country: "Hiszpania"
        },
        dateOfBirth: new Date("1992-03-12"),
        loyaltyPoints: 85,
        registrationDate: new Date("2021-09-05")
    },
    {
        firstName: "John",
        lastName: "Smith",
        email: "john.smith@email.com",
        phoneNumber: "+441234567890",
        address: {
            street: "High Street 42",
            city: "London",
            postalCode: "SW1A 1AA",
            country: "Wielka Brytania"
        },
        dateOfBirth: new Date("1980-12-05"),
        loyaltyPoints: 175,
        registrationDate: new Date("2020-07-18")
    },
    {
        firstName: "Sophie",
        lastName: "Dubois",
        email: "sophie.dubois@email.com",
        phoneNumber: "+33123456789",
        address: {
            street: "Rue de la Paix 10",
            city: "Paris",
            postalCode: "75001",
            country: "Francja"
        },
        dateOfBirth: new Date("1987-09-14"),
        loyaltyPoints: 310,
        registrationDate: new Date("2019-11-12")
    },
    {
        firstName: "Marco",
        lastName: "Rossi",
        email: "marco.rossi@email.com",
        phoneNumber: "+39123456789",
        address: {
            street: "Via Roma 25",
            city: "Milano",
            postalCode: "20121",
            country: "Włochy"
        },
        dateOfBirth: new Date("1983-02-28"),
        loyaltyPoints: 95,
        registrationDate: new Date("2021-05-20")
    },
    {
        firstName: "Katarzyna",
        lastName: "Lewandowska",
        email: "katarzyna.lewandowska@email.com",
        phoneNumber: "+48345678912",
        address: {
            street: "Spacerowa 18",
            city: "Gdańsk",
            postalCode: "80-001",
            country: "Polska"
        },
        dateOfBirth: new Date("1995-06-11"),
        loyaltyPoints: 60,
        registrationDate: new Date("2022-02-10")
    },
    {
        firstName: "Erik",
        lastName: "Andersson",
        email: "erik.andersson@email.com",
        phoneNumber: "+46123456789",
        address: {
            street: "Storgatan 14",
            city: "Stockholm",
            postalCode: "11122",
            country: "Szwecja"
        },
        dateOfBirth: new Date("1989-04-18"),
        loyaltyPoints: 155,
        registrationDate: new Date("2020-08-30")
    },
    {
        firstName: "Isabella",
        lastName: "Rodriguez",
        email: "isabella.rodriguez@email.com",
        phoneNumber: "+52123456789",
        address: {
            street: "Avenida Reforma 100",
            city: "Mexico City",
            postalCode: "06600",
            country: "Meksyk"
        },
        dateOfBirth: new Date("1991-12-03"),
        loyaltyPoints: 205,
        registrationDate: new Date("2020-12-15")
    },
    {
        firstName: "Michał",
        lastName: "Wójcik",
        email: "michal.wojcik@email.com",
        phoneNumber: "+48456789123",
        address: {
            street: "Nadwiślańska 22",
            city: "Wrocław",
            postalCode: "50-266",
            country: "Polska"
        },
        dateOfBirth: new Date("1976-08-25"),
        loyaltyPoints: 340,
        registrationDate: new Date("2018-03-05")
    },
    {
        firstName: "Emma",
        lastName: "Johnson",
        email: "emma.johnson@email.com",
        phoneNumber: "+1234567890",
        address: {
            street: "Fifth Avenue 123",
            city: "New York",
            postalCode: "10001",
            country: "USA"
        },
        dateOfBirth: new Date("1988-01-17"),
        loyaltyPoints: 280,
        registrationDate: new Date("2019-07-22")
    },
    {
        firstName: "Aleksandr",
        lastName: "Petrov",
        email: "aleksandr.petrov@email.com",
        phoneNumber: "+7123456789",
        address: {
            street: "Nevsky Prospekt 50",
            city: "Sankt Petersburg",
            postalCode: "190000",
            country: "Rosja"
        },
        dateOfBirth: new Date("1982-10-08"),
        loyaltyPoints: 190,
        registrationDate: new Date("2020-04-18")
    },
    {
        firstName: "Yuki",
        lastName: "Tanaka",
        email: "yuki.tanaka@email.com",
        phoneNumber: "+81123456789",
        address: {
            street: "Shibuya 1-1-1",
            city: "Tokyo",
            postalCode: "150-0002",
            country: "Japonia"
        },
        dateOfBirth: new Date("1993-07-20"),
        loyaltyPoints: 75,
        registrationDate: new Date("2021-11-08")
    },
    {
        firstName: "Agnieszka",
        lastName: "Mazur",
        email: "agnieszka.mazur@email.com",
        phoneNumber: "+48567891234",
        address: {
            street: "Parkowa 5",
            city: "Poznań",
            postalCode: "61-001",
            country: "Polska"
        },
        dateOfBirth: new Date("1994-03-22"),
        loyaltyPoints: 110,
        registrationDate: new Date("2021-08-14")
    }
]);

// 2. Kolekcja: Pokoje hotelowe
db.rooms.insertMany([
    {
        roomNumber: "101",
        floor: 1,
        type: "Standard",
        capacity: 2,
        pricePerNight: 250.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja"],
        status: "Dostępny",
        lastRenovation: new Date("2021-03-15")
    },
    {
        roomNumber: "102",
        floor: 1,
        type: "Standard",
        capacity: 2,
        pricePerNight: 250.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja"],
        status: "Dostępny",
        lastRenovation: new Date("2021-03-20")
    },
    {
        roomNumber: "103",
        floor: 1,
        type: "Standard",
        capacity: 2,
        pricePerNight: 250.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja"],
        status: "Zajęty",
        lastRenovation: new Date("2021-04-01")
    },
    {
        roomNumber: "104",
        floor: 1,
        type: "Standard Plus",
        capacity: 3,
        pricePerNight: 320.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja", "Sejf"],
        status: "Dostępny",
        lastRenovation: new Date("2021-04-15")
    },
    {
        roomNumber: "201",
        floor: 2,
        type: "Deluxe",
        capacity: 3,
        pricePerNight: 400.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja", "Sejf", "Ekspres do kawy"],
        status: "Zajęty",
        lastRenovation: new Date("2022-01-10")
    },
    {
        roomNumber: "202",
        floor: 2,
        type: "Deluxe",
        capacity: 3,
        pricePerNight: 400.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja", "Sejf", "Ekspres do kawy"],
        status: "Dostępny",
        lastRenovation: new Date("2022-01-15")
    },
    {
        roomNumber: "203",
        floor: 2,
        type: "Deluxe",
        capacity: 3,
        pricePerNight: 400.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja", "Sejf", "Ekspres do kawy"],
        status: "Serwis",
        lastRenovation: new Date("2022-01-20")
    },
    {
        roomNumber: "301",
        floor: 3,
        type: "Suite",
        capacity: 4,
        pricePerNight: 600.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja", "Sejf", "Ekspres do kawy", "Jacuzzi"],
        status: "Dostępny",
        lastRenovation: new Date("2022-02-15")
    },
    {
        roomNumber: "302",
        floor: 3,
        type: "Apartament",
        capacity: 5,
        pricePerNight: 900.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja", "Sejf", "Ekspres do kawy", "Jacuzzi", "Sauna"],
        status: "Dostępny",
        lastRenovation: new Date("2022-02-20")
    },
    {
        roomNumber: "303",
        floor: 3,
        type: "Suite",
        capacity: 4,
        pricePerNight: 600.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja", "Sejf", "Ekspres do kawy", "Jacuzzi"],
        status: "Zajęty",
        lastRenovation: new Date("2022-03-01")
    },
    {
        roomNumber: "401",
        floor: 4,
        type: "Penthouse",
        capacity: 6,
        pricePerNight: 1200.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja", "Sejf", "Ekspres do kawy", "Jacuzzi", "Sauna", "Taras"],
        status: "Dostępny",
        lastRenovation: new Date("2022-05-10")
    },
    {
        roomNumber: "402",
        floor: 4,
        type: "Penthouse",
        capacity: 6,
        pricePerNight: 1200.00,
        amenities: ["TV", "WiFi", "Minibar", "Klimatyzacja", "Sejf", "Ekspres do kawy", "Jacuzzi", "Sauna", "Taras"],
        status: "Dostępny",
        lastRenovation: new Date("2022-05-15")
    }
]);

// 3. Kolekcja: Usługi dodatkowe
db.services.insertMany([
    {
        name: "Śniadanie",
        description: "Bufet śniadaniowy w godzinach 7:00-10:00",
        price: 50.00,
        category: "Gastronomia",
        availability: ["Poniedziałek", "Wtorek", "Środa", "Czwartek", "Piątek", "Sobota", "Niedziela"],
        location: "Restauracja hotelowa",
        requiresReservation: false
    },
    {
        name: "Masaż relaksacyjny",
        description: "60-minutowy masaż relaksacyjny",
        price: 200.00,
        category: "SPA",
        availability: ["Poniedziałek", "Środa", "Piątek", "Sobota"],
        location: "Hotelowe SPA",
        requiresReservation: true
    },
    {
        name: "Transfer z lotniska",
        description: "Transport z lotniska do hotelu",
        price: 120.00,
        category: "Transport",
        availability: ["Poniedziałek", "Wtorek", "Środa", "Czwartek", "Piątek", "Sobota", "Niedziela"],
        location: "Lotnisko",
        requiresReservation: true
    },
    {
        name: "Wynajem roweru",
        description: "Wypożyczenie roweru na cały dzień",
        price: 50.00,
        category: "Rekreacja",
        availability: ["Poniedziałek", "Wtorek", "Środa", "Czwartek", "Piątek", "Sobota", "Niedziela"],
        location: "Recepcja",
        requiresReservation: false
    },
    {
        name: "Kolacja przy świecach",
        description: "Romantyczna kolacja dla dwojga",
        price: 300.00,
        category: "Gastronomia",
        availability: ["Piątek", "Sobota"],
        location: "Taras widokowy",
        requiresReservation: true
    },
    {
        name: "Sesja w saunie",
        description: "90-minutowa sesja w saunie z aromaterapią",
        price: 150.00,
        category: "SPA",
        availability: ["Wtorek", "Czwartek", "Sobota", "Niedziela"],
        location: "Hotelowe SPA",
        requiresReservation: true
    },
    {
        name: "Parking",
        description: "Miejsce parkingowe na dobę",
        price: 40.00,
        category: "Transport",
        availability: ["Poniedziałek", "Wtorek", "Środa", "Czwartek", "Piątek", "Sobota", "Niedziela"],
        location: "Parking hotelowy",
        requiresReservation: false
    },
    {
        name: "Kurs gotowania",
        description: "2-godzinny kurs gotowania regionalnych potraw",
        price: 250.00,
        category: "Rekreacja",
        availability: ["Środa", "Sobota"],
        location: "Kuchnia hotelowa",
        requiresReservation: true
    },
    {
        name: "Wycieczka po mieście",
        description: "4-godzinna zwiedzanie miasta z przewodnikiem",
        price: 180.00,
        category: "Rekreacja",
        availability: ["Wtorek", "Czwartek", "Sobota"],
        location: "Start z recepcji",
        requiresReservation: true
    },
    {
        name: "Pranie i prasowanie",
        description: "Usługa prania i prasowania odzieży",
        price: 30.00,
        category: "Dodatkowe",
        availability: ["Poniedziałek", "Wtorek", "Środa", "Czwartek", "Piątek"],
        location: "Pralnia hotelowa",
        requiresReservation: false
    }
]);

// 4. Kolekcja: Pracownicy
db.employees.insertMany([
    {
        firstName: "Piotr",
        lastName: "Wiśniewski",
        position: "Recepcjonista",
        email: "piotr.wisniewski@hotel.com",
        phoneNumber: "+48765432109",
        dateOfBirth: new Date("1988-10-15"),
        hireDate: new Date("2019-04-01"),
        salary: 4500.00,
        department: "Recepcja",
        workSchedule: ["Poniedziałek", "Wtorek", "Środa", "Czwartek", "Piątek"],
        address: {
            street: "Jaśminowa 5",
            city: "Warszawa",
            postalCode: "02-123",
            country: "Polska"
        }
    },
    {
        firstName: "Marta",
        lastName: "Kowalczyk",
        position: "Pokojówka",
        email: "marta.kowalczyk@hotel.com",
        phoneNumber: "+48654321098",
        dateOfBirth: new Date("1992-05-22"),
        hireDate: new Date("2020-02-15"),
        salary: 3800.00,
        department: "Housekeeping",
        workSchedule: ["Wtorek", "Środa", "Czwartek", "Piątek", "Sobota"],
        address: {
            street: "Leśna 12",
            city: "Warszawa",
            postalCode: "03-456",
            country: "Polska"
        }
    },
    {
        firstName: "Tomasz",
        lastName: "Nowicki",
        position: "Szef kuchni",
        email: "tomasz.nowicki@hotel.com",
        phoneNumber: "+48567890123",
        dateOfBirth: new Date("1975-03-10"),
        hireDate: new Date("2018-06-01"),
        salary: 7500.00,
        department: "Restauracja",
        workSchedule: ["Poniedziałek", "Wtorek", "Środa", "Niedziela"],
        address: {
            street: "Słoneczna 8",
            city: "Pruszków",
            postalCode: "05-800",
            country: "Polska"
        }
    },
    {
        firstName: "Katarzyna",
        lastName: "Zielińska",
        position: "Manager",
        email: "katarzyna.zielinska@hotel.com",
        phoneNumber: "+48678901234",
        dateOfBirth: new Date("1982-11-28"),
        hireDate: new Date("2017-01-10"),
        salary: 9000.00,
        department: "Zarząd",
        workSchedule: ["Poniedziałek", "Wtorek", "Środa", "Czwartek", "Piątek"],
        address: {
            street: "Złota 20",
            city: "Warszawa",
            postalCode: "00-120",
            country: "Polska"
        }
    },
    {
        firstName: "Marek",
        lastName: "Jankowski",
        position: "Konserwator",
        email: "marek.jankowski@hotel.com",
        phoneNumber: "+48789012345",
        dateOfBirth: new Date("1970-07-15"),
        hireDate: new Date("2019-09-01"),
        salary: 4200.00,
        department: "Utrzymanie",
        workSchedule: ["Poniedziałek", "Wtorek", "Środa", "Czwartek", "Piątek"],
        address: {
            street: "Brzozowa 7",
            city: "Piaseczno",
            postalCode: "05-500",
            country: "Polska"
        }
    },
    {
        firstName: "Joanna",
        lastName: "Kamińska",
        position: "Recepcjonista",
        email: "joanna.kaminska@hotel.com",
        phoneNumber: "+48890123456",
        dateOfBirth: new Date("1990-02-08"),
        hireDate: new Date("2020-11-15"),
        salary: 4300.00,
        department: "Recepcja",
        workSchedule: ["Sobota", "Niedziela", "Poniedziałek", "Wtorek", "Środa"],
        address: {
            street: "Wiśniowa 15",
            city: "Warszawa",
            postalCode: "04-567",
            country: "Polska"
        }
    },
    {
        firstName: "Robert",
        lastName: "Kowalski",
        position: "Kucharz",
        email: "robert.kowalski@hotel.com",
        phoneNumber: "+48901234567",
        dateOfBirth: new Date("1985-12-20"),
        hireDate: new Date("2019-08-01"),
        salary: 5200.00,
        department: "Restauracja",
        workSchedule: ["Czwartek", "Piątek", "Sobota", "Niedziela"],
        address: {
            street: "Klonowa 3",
            city: "Warszawa",
            postalCode: "05-234",
            country: "Polska"
        }
    },
    {
        firstName: "Magdalena",
        lastName: "Wójcik",
        position: "Masażystka",
        email: "magdalena.wojcik@hotel.com",
        phoneNumber: "+48012345678",
        dateOfBirth: new Date("1987-06-18"),
        hireDate: new Date("2021-03-01"),
        salary: 5800.00,
        department: "SPA",
        workSchedule: ["Poniedziałek", "Środa", "Piątek", "Sobota"],
        address: {
            street: "Lipowa 9",
            city: "Otwock",
            postalCode: "05-400",
            country: "Polska"
        }
    }
]);

// 5. Kolekcja: Rezerwacje
const jan_id = db.guests.findOne({firstName: "Jan", lastName: "Kowalski"})._id;
const anna_id = db.guests.findOne({firstName: "Anna", lastName: "Nowak"})._id;
const thomas_id = db.guests.findOne({firstName: "Thomas", lastName: "Schmidt"})._id;
const maria_id = db.guests.findOne({firstName: "Maria", lastName: "Garcia"})._id;
const john_id = db.guests.findOne({firstName: "John", lastName: "Smith"})._id;
const sophie_id = db.guests.findOne({firstName: "Sophie", lastName: "Dubois"})._id;
const marco_id = db.guests.findOne({firstName: "Marco", lastName: "Rossi"})._id;
const katarzyna_id = db.guests.findOne({firstName: "Katarzyna", lastName: "Lewandowska"})._id;
const erik_id = db.guests.findOne({firstName: "Erik", lastName: "Andersson"})._id;
const isabella_id = db.guests.findOne({firstName: "Isabella", lastName: "Rodriguez"})._id;

const room101_id = db.rooms.findOne({roomNumber: "101"})._id;
const room102_id = db.rooms.findOne({roomNumber: "102"})._id;
const room103_id = db.rooms.findOne({roomNumber: "103"})._id;
const room104_id = db.rooms.findOne({roomNumber: "104"})._id;
const room201_id = db.rooms.findOne({roomNumber: "201"})._id;
const room202_id = db.rooms.findOne({roomNumber: "202"})._id;
const room301_id = db.rooms.findOne({roomNumber: "301"})._id;
const room302_id = db.rooms.findOne({roomNumber: "302"})._id;
const room303_id = db.rooms.findOne({roomNumber: "303"})._id;
const room401_id = db.rooms.findOne({roomNumber: "401"})._id;

db.reservations.insertMany([
    {
        guestId: jan_id,
        roomId: room101_id,
        checkInDate: new Date("2023-05-10"),
        checkOutDate: new Date("2023-05-15"),
        numberOfGuests: 2,
        totalPrice: 1250.00,
        paymentStatus: "Opłacone",
        specialRequests: ["Późne zameldowanie", "Dodatkowa poduszka"],
        bookingDate: new Date("2023-04-15"),
        status: "Potwierdzona"
    },
    {
        guestId: anna_id,
        roomId: room201_id,
        checkInDate: new Date("2023-06-01"),
        checkOutDate: new Date("2023-06-10"),
        numberOfGuests: 3,
        totalPrice: 3600.00,
        paymentStatus: "Zaliczka",
        specialRequests: [],
        bookingDate: new Date("2023-05-01"),
        status: "Potwierdzona"
    },
    {
        guestId: thomas_id,
        roomId: room301_id,
        checkInDate: new Date("2023-05-20"),
        checkOutDate: new Date("2023-05-23"),
        numberOfGuests: 2,
        totalPrice: 1800.00,
        paymentStatus: "Oczekuje na płatność",
        specialRequests: ["Widok na miasto"],
        bookingDate: new Date("2023-05-05"),
        status: "Oczekująca"
    },
    {
        guestId: maria_id,
        roomId: room102_id,
        checkInDate: new Date("2023-07-15"),
        checkOutDate: new Date("2023-07-20"),
        numberOfGuests: 1,
        totalPrice: 1250.00,
        paymentStatus: "Opłacone",
        specialRequests: [],
        bookingDate: new Date("2023-05-20"),
        status: "Potwierdzona"
    },
    {
        guestId: john_id,
        roomId: room302_id,
        checkInDate: new Date("2023-06-15"),
        checkOutDate: new Date("2023-06-20"),
        numberOfGuests: 4,
        totalPrice: 4500.00,
        paymentStatus: "Zaliczka",
        specialRequests: ["Łóżeczko dla dziecka", "Późne wymeldowanie"],
        bookingDate: new Date("2023-05-10"),
        status: "Potwierdzona"
    },
    {
        guestId: sophie_id,
        roomId: room303_id,
        checkInDate: new Date("2023-08-01"),
        checkOutDate: new Date("2023-08-07"),
        numberOfGuests: 2,
        totalPrice: 3600.00,
        paymentStatus: "Opłacone",
        specialRequests: ["Champagne powitalny", "Kwiaty w pokoju"],
        bookingDate: new Date("2023-07-01"),
        status: "Potwierdzona"
    },
    {
        guestId: marco_id,
        roomId: room104_id,
        checkInDate: new Date("2023-09-10"),
        checkOutDate: new Date("2023-09-15"),
        numberOfGuests: 2,
        totalPrice: 1600.00,
        paymentStatus: "Zaliczka",
        specialRequests: ["Pokój dla niepalących"],
        bookingDate: new Date("2023-08-15"),
        status: "Potwierdzona"
    },
    {
        guestId: katarzyna_id,
        roomId: room202_id,
        checkInDate: new Date("2023-10-01"),
        checkOutDate: new Date("2023-10-05"),
        numberOfGuests: 1,
        totalPrice: 1600.00,
        paymentStatus: "Oczekuje na płatność",
        specialRequests: ["Cichy pokój"],
        bookingDate: new Date("2023-09-10"),
        status: "Oczekująca"
    },
    {
        guestId: erik_id,
        roomId: room401_id,
        checkInDate: new Date("2023-11-15"),
        checkOutDate: new Date("2023-11-20"),
        numberOfGuests: 4,
        totalPrice: 6000.00,
        paymentStatus: "Opłacone",
        specialRequests: ["Transfer z lotniska", "Kolacja welcome"],
        bookingDate: new Date("2023-10-01"),
        status: "Potwierdzona"
    },
    {
        guestId: isabella_id,
        roomId: room103_id,
        checkInDate: new Date("2023-12-20"),
        checkOutDate: new Date("2023-12-27"),
        numberOfGuests: 2,
        totalPrice: 1750.00,
        paymentStatus: "Zaliczka",
        specialRequests: ["Dekoracje świąteczne"],
        bookingDate: new Date("2023-11-15"),
        status: "Potwierdzona"
    }
]);

// 6. Kolekcja: Zamówienia usług
const breakfast_id = db.services.findOne({name: "Śniadanie"})._id;
const massage_id = db.services.findOne({name: "Masaż relaksacyjny"})._id;
const transfer_id = db.services.findOne({name: "Transfer z lotniska"})._id;
const bike_id = db.services.findOne({name: "Wynajem roweru"})._id;
const dinner_id = db.services.findOne({name: "Kolacja przy świecach"})._id;
const sauna_id = db.services.findOne({name: "Sesja w saunie"})._id;
const parking_id = db.services.findOne({name: "Parking"})._id;
const cooking_id = db.services.findOne({name: "Kurs gotowania"})._id;
const tour_id = db.services.findOne({name: "Wycieczka po mieście"})._id;
const laundry_id = db.services.findOne({name: "Pranie i prasowanie"})._id;

const jan_res_id = db.reservations.findOne({guestId: jan_id})._id;
const anna_res_id = db.reservations.findOne({guestId: anna_id})._id;
const thomas_res_id = db.reservations.findOne({guestId: thomas_id})._id;
const maria_res_id = db.reservations.findOne({guestId: maria_id})._id;
const john_res_id = db.reservations.findOne({guestId: john_id})._id;
const sophie_res_id = db.reservations.findOne({guestId: sophie_id})._id;
const marco_res_id = db.reservations.findOne({guestId: marco_id})._id;
const katarzyna_res_id = db.reservations.findOne({guestId: katarzyna_id})._id;
const erik_res_id = db.reservations.findOne({guestId: erik_id})._id;
const isabella_res_id = db.reservations.findOne({guestId: isabella_id})._id;

db.serviceOrders.insertMany([
    {
        guestId: jan_id,
        reservationId: jan_res_id,
        serviceId: breakfast_id,
        orderDate: new Date("2023-05-11"),
        quantity: 2,
        totalPrice: 100.00,
        status: "Zrealizowane",
        comments: "Śniadanie do pokoju"
    },
    {
        guestId: thomas_id,
        reservationId: thomas_res_id,
        serviceId: massage_id,
        orderDate: new Date("2023-05-21"),
        quantity: 1,
        totalPrice: 200.00,
        status: "Potwierdzone",
        comments: "Masaż na godzinę 15:00"
    },
    {
        guestId: anna_id,
        reservationId: anna_res_id,
        serviceId: transfer_id,
        orderDate: new Date("2023-06-01"),
        quantity: 1,
        totalPrice: 120.00,
        status: "Potwierdzone",
        comments: "Odbiór z lotniska o 14:30"
    },
    {
        guestId: maria_id,
        reservationId: maria_res_id,
        serviceId: bike_id,
        orderDate: new Date("2023-07-16"),
        quantity: 2,
        totalPrice: 100.00,
        status: "Oczekujące",
        comments: "Dwa rowery na cały dzień"
    },
    {
        guestId: john_id,
        reservationId: john_res_id,
        serviceId: dinner_id,
        orderDate: new Date("2023-06-18"),
        quantity: 1,
        totalPrice: 300.00,
        status: "Potwierdzone",
        comments: "Kolacja na 20:00, rocznica ślubu"
    },
    {
        guestId: sophie_id,
        reservationId: sophie_res_id,
        serviceId: sauna_id,
        orderDate: new Date("2023-08-03"),
        quantity: 1,
        totalPrice: 150.00,
        status: "Zrealizowane",
        comments: "Aromaterapia lawendowa"
    },
    {
        guestId: marco_id,
        reservationId: marco_res_id,
        serviceId: parking_id,
        orderDate: new Date("2023-09-10"),
        quantity: 5,
        totalPrice: 200.00,
        status: "Potwierdzone",
        comments: "Parking na cały pobyt"
    },
    {
        guestId: erik_id,
        reservationId: erik_res_id,
        serviceId: cooking_id,
        orderDate: new Date("2023-11-17"),
        quantity: 1,
        totalPrice: 250.00,
        status: "Potwierdzone",
        comments: "Kurs regionalnej kuchni polskiej"
    },
    {
        guestId: isabella_id,
        reservationId: isabella_res_id,
        serviceId: tour_id,
        orderDate: new Date("2023-12-22"),
        quantity: 1,
        totalPrice: 180.00,
        status: "Oczekujące",
        comments: "Wycieczka świąteczna po Starówce"
    },
    {
        guestId: jan_id,
        reservationId: jan_res_id,
        serviceId: laundry_id,
        orderDate: new Date("2023-05-12"),
        quantity: 3,
        totalPrice: 90.00,
        status: "Zrealizowane",
        comments: "Ekspresowe pranie"
    },
    {
        guestId: anna_id,
        reservationId: anna_res_id,
        serviceId: breakfast_id,
        orderDate: new Date("2023-06-02"),
        quantity: 9,
        totalPrice: 450.00,
        status: "Zrealizowane",
        comments: "Śniadania na cały pobyt"
    },
    {
        guestId: thomas_id,
        reservationId: thomas_res_id,
        serviceId: parking_id,
        orderDate: new Date("2023-05-20"),
        quantity: 3,
        totalPrice: 120.00,
        status: "Zrealizowane",
        comments: "Miejsce blisko wejścia"
    },
    {
        guestId: sophie_id,
        reservationId: sophie_res_id,
        serviceId: massage_id,
        orderDate: new Date("2023-08-04"),
        quantity: 2,
        totalPrice: 400.00,
        status: "Potwierdzone",
        comments: "Masaż dla pary"
    },
    {
        guestId: katarzyna_id,
        reservationId: katarzyna_res_id,
        serviceId: bike_id,
        orderDate: new Date("2023-10-02"),
        quantity: 1,
        totalPrice: 50.00,
        status: "Oczekujące",
        comments: "Rower damski"
    },
    {
        guestId: erik_id,
        reservationId: erik_res_id,
        serviceId: transfer_id,
        orderDate: new Date("2023-11-15"),
        quantity: 1,
        totalPrice: 120.00,
        status: "Potwierdzone",
        comments: "Transfer na lotnisko po pobycie"
    }
]);

// Indeksy
db.rooms.createIndex({ roomNumber: 1 }, { unique: true });
db.guests.createIndex({ lastName: 1, firstName: 1 });
db.reservations.createIndex({ checkInDate: 1, checkOutDate: 1 });
db.reservations.createIndex({ roomId: 1 });
db.reservations.createIndex({ guestId: 1 });
db.services.createIndex({ category: 1, price: 1 });
db.serviceOrders.createIndex({ serviceId: 1 });
db.employees.createIndex({ department: 1, position: 1 });