Changes between Version 1 and Version 2 of UseCase6


Ignore:
Timestamp:
02/10/25 01:10:49 (9 months ago)
Author:
215010
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UseCase6

    v1 v2  
    10104. Внесува детали за уплата.
    11115. Клиентот добива повратен одговор за успешно или неуспешно плаќање.
     12
     13{{{
     14SELECT SUM(r.price_per_night * DATEDIFF(res.end_date, res.start_date)) +
     15       COALESCE(SUM(s.service_price), 0) AS Total_Cost
     16FROM Reservation res
     17JOIN Room r ON res.room_number = r.room_number AND res.building_id = r.building_id
     18LEFT JOIN Service s ON res.room_number = s.room_number AND res.building_id = s.building_id
     19WHERE res.reservation_id = 3;
     20
     21INSERT INTO Payment (p_id, p_method, amount, p_date, reservation_id, customer_id)
     22VALUES (3, 'card', 500, CURDATE(), 3, 3);
     23}}}