Changes between Version 13 and Version 14 of AdvancedApplicationDevelopment

Timestamp:

09/30/25 08:44:39 (2 weeks ago)

Author:

223270

Comment:

--

AdvancedApplicationDevelopment

@@ -212 +212 @@
 }}}
 
+3. Комплетна резервација за пакет во трансакција
+{{{
+CREATE OR REPLACE PROCEDURE create_package_reservation(
+    p_user INT,
+    p_package INT,
+    p_discount_amount NUMERIC DEFAULT 0
+)
+LANGUAGE plpgsql
+AS $$
+DECLARE
+    package_price NUMERIC(12,2);
+    new_reservation INT;
+BEGIN
+    SELECT price INTO package_price FROM package WHERE id_package = p_package;
+
+    IF package_price IS NULL THEN
+        RAISE EXCEPTION 'Package % not found', p_package;
+    END IF;
+
+    INSERT INTO reservation(id_user, time_point, premium_discount_applied, discount_amount, total_price)
+    VALUES (p_user, now(), CASE WHEN p_discount_amount > 0 THEN TRUE ELSE FALSE END, p_discount_amount, GREATEST(package_price - p_discount_amount, 0))
+    RETURNING id_reservation INTO new_reservation;
+
+    INSERT INTO package_reservation(id_package, id_reservation)
+    VALUES (p_package, new_reservation);
+END;
+$$;
+}}}
+
 === Линк до репозиториумот
 https://develop.finki.ukim.mk/git/travel_sage.git