Changes between Version 2 and Version 3 of UseCase6

Timestamp:

02/11/25 01:07:40 (3 weeks ago)

Author:

212054

Comment:

--

UseCase6

@@ -8 +8 @@
 {{{
 CREATE PROCEDURE GetDobavuvacDetails(IN input_Dobavuvac_Ime VARCHAR(50))
- BEGIN
-    SELECT d.Dobavuvac_Ime, d.Klasa AS Class, d.Tip AS Type, d.Poteklo AS Origin
+BEGIN
+    -- Basic info
+    SELECT 
+        d.Dobavuvac_Ime, 
+        d.Klasa AS Class, 
+        d.Tip AS Type, 
+        d.Poteklo AS Origin
     FROM Dobavuvac d
     WHERE d.Dobavuvac_Ime = input_Dobavuvac_Ime;
 
-    SELECT o.Objekt_ID, o.Tip AS Objekt_Type, o.Adresa AS Objekt_Address, n.Predmet AS Item_Supplied, n.Cena AS Item_Cost, n.Kolicina AS Quantity_Supplied
+    -- Object supply info
+    SELECT 
+        o.Objekt_ID, 
+        o.Tip AS Objekt_Type, 
+        o.Adresa AS Objekt_Address, 
+        n.Predmet AS Item_Supplied, 
+        n.Cena AS Item_Cost, 
+        n.Kolicina AS Quantity_Supplied
     FROM Ispolnuva i
     JOIN Nabavka n ON i.Nabavka_ID = n.Nabavka_ID
-    JOIN Objekt o ON n.Objekt_ID = o.Objekt_ID
+    JOIN Nameneta_Za nz ON n.Nabavka_ID = nz.Nabavka_ID
+    JOIN Objekt o ON nz.Objekt_ID = o.Objekt_ID
     WHERE i.Dobavuvac_Ime = input_Dobavuvac_Ime;
 
-    SELECT SUM(n.Cena * n.Kolicina) AS Total_Spent
+    -- Total spent
+    SELECT 
+        SUM(n.Cena * n.Kolicina) AS Total_Spent
     FROM Ispolnuva i
     JOIN Nabavka n ON i.Nabavka_ID = n.Nabavka_ID
     WHERE i.Dobavuvac_Ime = input_Dobavuvac_Ime;
- END
+END;
 }}}