todo/updates

[eturbat]

from 10 July update:

• profs add by admin
• implement prof poll based on room avail

[eturbat]

from 11 July update:

• implement prof poll based on room avail
• update and implement UI components

• edit button on student appointment history

• admin panel => implement code for download student appointments from admin_panel.php

• login auth fix

• database update => check the timeslots that blocks out if one user already selected or booking at the moment

[eturbat]

timeslot problem faced on 12 July.

where multiple rooms are available at the same time slot and you want to allow different bookings for each room, you need to modify the logic in your system to handle room-specific availability. 



• Modify the Database Structure: Ensure that your database can store and retrieve room-specific availability. This might involve adjusting your bookings table to include a reference to the specific room.
• Update Room Availability Logic: When displaying available slots to professors in availability.php, you need to show room-specific slots. This means that each slot should be tied to a particular room.
• Booking Logic: When a student books a slot, the system should record not just the date and time but also the specific room. This way, if Room 202 is booked for a particular slot, Room 302 can still be available for booking at the same time.
• Display Available Slots: When showing available slots to students, you need to consider both the time slot and the room. If a slot in one room is booked, it should not affect the availability of the same slot in another room.

[eturbat]

from 8 July update:

---

• professor's availability is checked across all rooms for a given timeslot. If a professor is already booked in one room, they should not be available for booking in another room at the same time. So updated for checks if either of the selected professors (reader_one or reader_two) is already booked for the same timeslot on the given date

---

• displays the timeslots as "Selected professors unavailable" when one or more selected professors are already booked
• we first fetch all bookings for the selected professors on the chosen date. Then, for each timeslot, we check if it's booked in the room, or if it's a timeslot where one of the professors is already booked.

---

• checks the availability of professors regardless of whether they are selected as the first or second reader, the query now fetches bookings where either of the selected professors is booked as the first or second reader.