Changes between Version 1 and Version 2 of UseCase5

Timestamp:

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

Author:

212054

Comment:

--

UseCase5

@@ -7 +7 @@
 
 {{{
-CREATE PROCEDURE GetPodizveduvacDetails(IN input_Podizveduvac_Ime VARCHAR(50))
+CREATE PROCEDURE GetPodizveduvacDetails(IN UID_p INT)
 BEGIN
     SELECT 
@@ -15 +15 @@
         p.Saatnica AS Hourly_Rate
     FROM Podizveduvac p
-    WHERE p.Podizveduvac_Ime = input_Podizveduvac_Ime;
+    WHERE p.UID_p = UID_p;
 
     SELECT 
@@ -23 +23 @@
     FROM Raboti_Za rz
     JOIN Rabotnik r ON rz.Maticen_br = r.Maticen_br
-    WHERE rz.Podizveduvac_Ime = input_Podizveduvac_Ime;
+    WHERE rz.UID_p = UID_p;
 
     SELECT 
@@ -29 +29 @@
         o.Tip AS Objekt_Type,
         o.Adresa AS Objekt_Address,
-        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)) * p.Saatnica AS Total_Payments
+        TIMESTAMPDIFF(HOUR, DATE_FORMAT(rn.Od_vreme, '%Y-%m-%d'), DATE_FORMAT(rn.Do_vreme, '%Y-%m-%d')) AS Total_Hours_Worked,
+        TIMESTAMPDIFF(HOUR, DATE_FORMAT(rn.Od_vreme, '%Y-%m-%d'), DATE_FORMAT(rn.Do_vreme, '%Y-%m-%d')) * p.Saatnica AS Total_Payments
     FROM Raboti_Na rn
     JOIN Objekt o ON rn.Objekt_ID = o.Objekt_ID
-    JOIN Podizveduvac p ON rn.Podizveduvac_Ime = p.Podizveduvac_Ime
-    WHERE rn.Podizveduvac_Ime = input_Podizveduvac_Ime;
+    JOIN Podizveduvac p ON rn.UID_p = p.UID
+    WHERE rn.UID_p = UID_p;
 
     SELECT 
         n.Nabavka_ID,
-        n.Datum AS Request_Date,
+        DATE_FORMAT(n.Datum, '%Y-%m-%d') AS Request_Date,
         n.Cena AS Cost,
         n.Kolicina AS Quantity,
@@ -44 +44 @@
     FROM Pobaruva pb
     JOIN Nabavka n ON pb.Nabavka_ID = n.Nabavka_ID
-    WHERE pb.Podizveduvac_Ime = input_Podizveduvac_Ime;
-END
+    WHERE pb.UID_p = UID_p;
+END;
 }}}