Changes between Version 3 and Version 4 of UseCaseZavrshenaNaracka

Timestamp:

09/04/24 22:19:36 (4 weeks ago)

Author:

201156

Comment:

--

UseCaseZavrshenaNaracka

@@ -14 +14 @@
 
 {{{
-DECLARE @NarackaID INT;
+CREATE OR REPLACE FUNCTION process_faktura_and_delete(
+    p_naracka_id INT,
+    p_iznos DECIMAL(10, 2),
+    p_broj VARCHAR(255),
+    p_datum DATE
+) RETURNS VOID AS $$
+DECLARE
+    v_faktura_id INT;
+BEGIN
+    -- Insert into Faktura
+    INSERT INTO Faktura (Datum, Iznos, Broj)
+    VALUES (p_datum, p_iznos, p_broj)
+    RETURNING FakturaID INTO v_faktura_id;
 
-DECLARE @Iznos DECIMAL;
+    -- Insert into Faktura_Naracka
+    INSERT INTO Faktura_Naracka (FakturaID, NarackaID)
+    VALUES (v_faktura_id, p_naracka_id);
 
-DECLARE @Broj VARCHAR(255);
+    -- Delete from Naracka_IzrabotkaPlan
+    DELETE FROM Naracka_IzrabotkaPlan
+    WHERE NarackaID = p_naracka_id;
+END;
+$$ LANGUAGE plpgsql;
 
-DECLARE @Datum DATE;
-
-
-INSERT INTO Faktura (Datum, Iznos, Broj)
-
-VALUES (@Datum, @Iznos, @Broj);
-
-
-DECLARE @FakturaID INT;
-
-SET @FakturaID = SCOPE_IDENTITY();
-
-
-INSERT INTO Faktura_Naracka (FakturaID, NarackaID)
-
-VALUES (@FakturaID, @NarackaID);
-
-
-DELETE FROM Naracka_IzrabotkaPlan
-
-WHERE NarackaID = @NarackaID;
 }}}