Changes between Version 9 and Version 10 of UseCase4

Timestamp:

12/16/22 18:53:28 (3 years ago)

Author:

201101

Comment:

--

UseCase4

@@ -17 +17 @@
 '''Чекор 3''': Избира тип на резервација(соба, оброк, настан или активност) и добива филтрирани податоци
 
-[[Image(selected reservation.png)]]
+                           //На следната слика се прикажани филтрираните податоци за резервирани соби.//
+
+[[Image(reservation_for_rooms.png)]]
+
+{{{#!sql
+select  room_type, price, name, full_name, phone_number,  start_date, end_date, number_guests, adults, children
+from guests_make_reservation gmr 
+join user_table ut on
+        gmr.user_id = ut.user_id 
+join reservation r on
+        gmr.reservation_id = r.reservation_id 
+join rooms r2 on
+        r.room_id  = r2.room_id 
+join villa v on
+        r.villa_id = v.villa_id 
+order by start_date;
+}}}
 
 
-[[Image(reservation_for_events.png)]]
+                           //На следната слика се прикажани филтрираните податоци за резервирани оброци.//
 
+
+[[Image(reservation_for_meal.png)]]
+
+
+{{{#!sql
+select full_name, meal_type, quantity, price, number_guests, start_date
+from reservation_for_prepared_meal rfpm 
+join prepared_meal pm on
+ rfpm.prepared_meal_id  = pm.prepared_meal_id 
+join meal m on
+ rfpm.meal_id  = pm.meal_id 
+join reservation r on
+ rfpm.reservation_id = r.reservation_id 
+join guests_make_reservation gmr on
+ r.reservation_id = gmr.reservation_id 
+join user_table ut on
+ gmr.user_id  = ut.user_id 
+order by start_date;
+}}}
+
+                           //На следната слика се прикажани филтрираните податоци за резервирани пијалоци.//
+
+
+[[Image(service_for_beverages.png)]]
+
+{{{#!sql
+select full_name, service_type, beverage_type, b.price 
+from service_for_beverages sfb 
+join service s on
+sfb.service_id = s.service_id 
+join beverage b on
+sfb.beverage_id = b.beverage_id 
+join user_table ut on
+s.user_id  = ut.user_id ;
+}}}
+
+                           //На следната слика се прикажани филтрираните податоци за резервирани настани.//
+
+[[Image(resrvation_for_events.png)]]
+
+
+{{{#!sql
+select event_type, price, start_date, end_date, number_of_interested_guests
+from reservation_for_events rfe 
+join events e on
+        rfe.event_id = e.event_id 
+join reservation r on
+        rfe.reservation_id = r.reservation_id 
+order by start_date;
+}}}
+
+                           //На следната слика се прикажани филтрираните податоци за резервирани активности.//
+
+
+[[Image(resrvation_for_activity.png)]]
+
+{{{#!sql
+select activity_type, price, start_date, end_date, number_of_interested_guests, activity_location
+from reservation_for_activity rfa 
+join activities a  on
+        rfa.activity_id = a.activity_id 
+join reservation r on
+        rfa.reservation_id = r.reservation_id 
+order by start_date;
+}}}
+
+                     //На следната слика се прикажани филтрираните податоци за резервирани типови на услуга.//
+
+[[Image(resrvation_for_service.png)]]
+
+{{{#!sql
+select  full_name, service_type, price, start_date, end_date
+from reservation_for_service rfs 
+join service s on
+rfs.service_id = s.service_id 
+join reservation r on
+rfs.reservation_id = r.reservation_id 
+join user_table ut on
+s.user_id  = ut.user_id 
+}}}
+
+
+
+
+
+
+