Bulk Equipment Reservation

INSERT INTO equipment_reservation_block (user_id, dateCreated, lastUpdate)
VALUES (1, NOW(), NOW());

SET @block_id = LAST_INSERT_ID();

INSERT INTO equipment_reservation (user_id, equipment_id, startDate, endDate, title, description, run_id, dateApproved,
                                   dateCreated, lastUpdate, block_id, recurring_link_id, recurring, recurringEndDate,
                                   type, status, project_id, serviceEvent_id, room_id, rental_status,
                                   isDoubleReservation)
SELECT creator_id,
       id,
       STR_TO_DATE('12-05-2026 06:00:00', '%d-%m-%Y %H:%i:%s'),
       STR_TO_DATE('18-05-2026 22:00:00', '%d-%m-%Y %H:%i:%s'),
       CONCAT('Reservation for planned maintenance in May 2026'),
       'Reservation for planned maintenance in May 2026',
       NULL,
       NOW(),
       NOW(),
       NULL,
       @block_id,
       NULL,
       false,
       NULL,
       2,
       2,
       project_id,
       null,
       room_id,
       null,
       FALSE
FROM equipment_equipment
WHERE room_id IN (5, 13, 59, 14, 42, 18)
  AND JSON_TYPE(reservationOptions) = 'ARRAY'
  AND JSON_LENGTH(reservationOptions) > 0;;

INSERT INTO equipment_reservation_module (reservation_id, module_id)
SELECT equipment_reservation.id, equipment_module.id
FROM equipment_reservation
         INNER JOIN equipment_module ON equipment_reservation.equipment_id = equipment_module.equipment_id
WHERE block_id IS NOT NULL
  AND equipment_module.id NOT IN (SELECT module_id
                                  FROM equipment_reservation_module
                                  WHERE equipment_reservation_module.reservation_id = equipment_reservation.id);
11 May 2026