Changes between Version 1 and Version 2 of UseCase4

Timestamp:

01/21/25 03:37:40 (10 days ago)

Author:

212054

Comment:

--

UseCase4

@@ -15 +15 @@
         o.Adresa AS Objekt_Address,
         vi.Budzet AS Objekt_Budget,
-        GROUP_CONCAT(n.Nadzor_Ime SEPARATOR ', ') AS Nadzor_Names
-    FROM 
-        Objekt o
-    LEFT JOIN 
-        Vo_Izgradba vi ON o.Objekt_ID = vi.Objekt_ID
-    LEFT JOIN 
-        Nadgleduva nd ON o.Objekt_ID = nd.Objekt_ID
-    LEFT JOIN 
-        Nadzor n ON nd.Nadzor_Ime = n.Nadzor_Ime
-    WHERE 
-        o.Objekt_ID = input_Objekt_ID
-    GROUP BY 
-        o.Objekt_ID;
+        n.Nadzor_Ime
+    FROM Objekt o
+    LEFT JOIN Vo_Izgradba vi ON o.Objekt_ID = vi.Objekt_ID
+    LEFT JOIN Nadgleduva nd ON o.Objekt_ID = nd.Objekt_ID
+    LEFT JOIN Nadzor n ON nd.Nadzor_Ime = n.Nadzor_Ime
+    WHERE o.Objekt_ID = input_Objekt_ID
+    GROUP BY o.Objekt_ID;
 
     -- Info za podizveduvacite koi rabotele na objektot
@@ -34 +28 @@
         TIMESTAMPDIFF(HOUR, FROM_UNIXTIME(rn.Od_vreme), FROM_UNIXTIME(rn.Do_vreme)) AS Total_Hours_Worked,
         TIMESTAMPDIFF(HOUR, FROM_UNIXTIME(rn.Od_vreme), FROM_UNIXTIME(rn.Do_vreme)) * pn.Saatnica AS Total_Cost
-    FROM 
-        Raboti_Na rn
-    JOIN 
-        Podizveduvac pn ON rn.Podizveduvac_Ime = pn.Podizveduvac_Ime
-    WHERE 
-        rn.Objekt_ID = input_Objekt_ID;
+    FROM Raboti_Na rn
+    JOIN Podizveduvac pn ON rn.Podizveduvac_Ime = pn.Podizveduvac_Ime
+    WHERE rn.Objekt_ID = input_Objekt_ID;
 
     -- Info za dobavuvachi
     SELECT 
         d.Dobavuvac_Ime,
-        SUM(n.Cena) AS Total_Spent
-    FROM 
-        Nabavka n
-    JOIN 
-        Nameneta_Za nz ON n.Nabavka_ID = nz.Nabavka_ID
-    JOIN 
-        Ispolnuva i ON n.Nabavka_ID = i.Nabavka_ID
-    JOIN 
-        Dobavuvac d ON i.Dobavuvac_Ime = d.Dobavuvac_Ime
-    WHERE 
-        nz.Objekt_ID = input_Objekt_ID
-    GROUP BY 
-        d.Dobavuvac_Ime;
+        SUM(n.Cena * n.Kolicina) AS Total_Spent
+    FROM Nabavka n
+    JOIN Nameneta_Za nz ON n.Nabavka_ID = nz.Nabavka_ID
+    JOIN Ispolnuva i ON n.Nabavka_ID = i.Nabavka_ID
+    JOIN Dobavuvac d ON i.Dobavuvac_Ime = d.Dobavuvac_Ime
+    WHERE nz.Objekt_ID = input_Objekt_ID
+    GROUP BY d.Dobavuvac_Ime;
 END
 }}}