Changes between Version 6 and Version 7 of Stored Functions and Procedures

Timestamp:

05/13/26 20:36:50 (13 days ago)

Author:

193284

Comment:

--

Stored Functions and Procedures

@@ -10 +10 @@
 
 Calculates the total confirmed cost of a wedding using venue, photographer, and band bookings.
+
+The function calculates venue costs directly from booking prices and additionally computes photographer and band costs based on booked duration and hourly pricing.
 
 === SQL Code ===
@@ -59 +61 @@
 Checks whether a venue is available for a selected date and time interval.
 
+This implementation uses complete timestamp interval comparison instead of simple date equality checks in order to correctly detect all possible overlap scenarios.
+
 This function compares complete timestamp intervals by combining the booking date with start and end time. It does not only compare equal dates.
 
@@ -112 +116 @@
 Checks whether a photographer is available for a selected date and time interval.
 
+This implementation uses complete timestamp interval comparison instead of simple date equality checks in order to correctly detect all possible overlap scenarios.
+
+The function combines booking dates and times into complete timestamp intervals in order to correctly validate overlapping reservations.
+
 === SQL Code ===
 
@@ -148 +156 @@
 Checks whether a band is available for a selected date and time interval.
 
+This implementation uses complete timestamp interval comparison instead of simple date equality checks in order to correctly detect all possible overlap scenarios.
+
+The function validates overlapping booking intervals using complete timestamp comparison between requested and existing reservations.
+
 === SQL Code ===
 
@@ -184 +196 @@
 Returns RSVP statistics for a selected event.
 
+The procedure generates summarized RSVP information including accepted, declined, and pending responses for analytical and reporting purposes.
+
 === SQL Code ===