Changes between Version 6 and Version 7 of Trigger Functions

Timestamp:

05/18/26 14:32:45 (8 days ago)

Author:

193284

Comment:

--

Trigger Functions

@@ -15 +15 @@
 === SQL Code ===
 
-{{{
-#!sql
 CREATE OR REPLACE FUNCTION check_venue_booking_overlap()
 RETURNS TRIGGER AS $$
@@ -31 +29 @@
           AND vb.booking_id <> COALESCE(NEW.booking_id, -1)
           AND (
-                (NEW."date" + NEW.start_time) < (vb."date" + vb.end_time)
-            AND (NEW."date" + NEW.end_time)   > (vb."date" + vb.start_time)
+
+                ((NEW."date" + NEW.start_time) >= (vb."date" + vb.start_time)
+                 AND (NEW."date" + NEW.start_time) < (vb."date" + vb.end_time))
+
+                OR
+
+                ((NEW."date" + NEW.end_time) > (vb."date" + vb.start_time)
+                 AND (NEW."date" + NEW.end_time) <= (vb."date" + vb.end_time))
+
+                OR
+
+                ((NEW."date" + NEW.start_time) <= (vb."date" + vb.start_time)
+                 AND (NEW."date" + NEW.end_time) >= (vb."date" + vb.end_time))
+
+                OR
+
+                ((NEW."date" + NEW.start_time) >= (vb."date" + vb.start_time)
+                 AND (NEW."date" + NEW.end_time) <= (vb."date" + vb.end_time))
           )
     ) THEN
@@ -48 +62 @@
 FOR EACH ROW
 EXECUTE FUNCTION check_venue_booking_overlap();
-}}}
 
 == 2. Photographer Booking Conflict Prevention ==
@@ -58 +71 @@
 === SQL Code ===
 
-{{{
-#!sql
 CREATE OR REPLACE FUNCTION check_photographer_booking_overlap()
 RETURNS TRIGGER AS $$
@@ -74 +85 @@
           AND pb.booking_id <> COALESCE(NEW.booking_id, -1)
           AND (
-                (NEW."date" + NEW.start_time) < (pb."date" + pb.end_time)
-            AND (NEW."date" + NEW.end_time)   > (pb."date" + pb.start_time)
+
+                ((NEW."date" + NEW.start_time) >= (pb."date" + pb.start_time)
+                 AND (NEW."date" + NEW.start_time) < (pb."date" + pb.end_time))
+
+                OR
+
+                ((NEW."date" + NEW.end_time) > (pb."date" + pb.start_time)
+                 AND (NEW."date" + NEW.end_time) <= (pb."date" + pb.end_time))
+
+                OR
+
+                ((NEW."date" + NEW.start_time) <= (pb."date" + pb.start_time)
+                 AND (NEW."date" + NEW.end_time) >= (pb."date" + pb.end_time))
+
+                OR
+
+                ((NEW."date" + NEW.start_time) >= (pb."date" + pb.start_time)
+                 AND (NEW."date" + NEW.end_time) <= (pb."date" + pb.end_time))
           )
     ) THEN
@@ -91 +118 @@
 FOR EACH ROW
 EXECUTE FUNCTION check_photographer_booking_overlap();
-}}}
 
 == 3. Band Booking Conflict Prevention ==
@@ -101 +127 @@
 === SQL Code ===
 
-{{{
-#!sql
 CREATE OR REPLACE FUNCTION check_band_booking_overlap()
 RETURNS TRIGGER AS $$
@@ -117 +141 @@
           AND bb.booking_id <> COALESCE(NEW.booking_id, -1)
           AND (
-                (NEW."date" + NEW.start_time) < (bb."date" + bb.end_time)
-            AND (NEW."date" + NEW.end_time)   > (bb."date" + bb.start_time)
+
+                ((NEW."date" + NEW.start_time) >= (bb."date" + bb.start_time)
+                 AND (NEW."date" + NEW.start_time) < (bb."date" + bb.end_time))
+
+                OR
+
+                ((NEW."date" + NEW.end_time) > (bb."date" + bb.start_time)
+                 AND (NEW."date" + NEW.end_time) <= (bb."date" + bb.end_time))
+
+                OR
+
+                ((NEW."date" + NEW.start_time) <= (bb."date" + bb.start_time)
+                 AND (NEW."date" + NEW.end_time) >= (bb."date" + bb.end_time))
+
+                OR
+
+                ((NEW."date" + NEW.start_time) >= (bb."date" + bb.start_time)
+                 AND (NEW."date" + NEW.end_time) <= (bb."date" + bb.end_time))
           )
     ) THEN
@@ -134 +174 @@
 FOR EACH ROW
 EXECUTE FUNCTION check_band_booking_overlap();
-}}}
+
 
 == 4. Attendance Consistency Validation ==