Changes between Version 1 and Version 2 of AdvancedApplicationDevelopment

Timestamp:

09/15/25 12:46:22 (3 days ago)

Author:

215010

Comment:

--

AdvancedApplicationDevelopment

@@ -40 +40 @@
 JOIN Staff st ON st.user_id = s.staff_id
 JOIN Hotel_User u ON u.user_id = st.user_id;
-}}}
-
-=== Преглед за динамичко пресметување на вкупната цена на резервацијата
-{{{#!sql
-CREATE OR REPLACE VIEW reservation_total AS
-SELECT r.reservation_id,
-       r.start_date,
-       r.end_date,
-       rm.price_per_night,
-       (EXTRACT(DAY FROM (r.end_date - r.start_date)) * rm.price_per_night) AS total_cost
-FROM Reservation r
-JOIN Room rm ON r.room_number = rm.room_number
-            AND r.building_id = rm.building_id;
 }}}