Changes between Version 18 and Version 19 of AdvancedApplicationDevelopment

Timestamp:

09/30/25 09:13:16 (4 weeks ago)

Author:

223270

Comment:

--

AdvancedApplicationDevelopment

@@ -269 +269 @@
 }}}
 
+4. Композитна метрика за дестинација: просечна оцена, процент на ефтини активности, број на резервации. Се користи за рангирање на дестинации.
+{{{
+CREATE OR REPLACE FUNCTION destination_score(p_dest INT)
+RETURNS FLOAT LANGUAGE plpgsql AS $$
+DECLARE
+    avg_rating FLOAT;
+    cheap_percent FLOAT;
+    total_reservations INT;
+    score FLOAT;
+BEGIN
+    SELECT AVG(quality) INTO avg_rating FROM review WHERE id_destination = p_dest;
+    SELECT COUNT(*) * 100.0 / NULLIF((SELECT COUNT(*) FROM activity WHERE id_destination = p_dest),0)
+        INTO cheap_percent FROM activity WHERE id_destination = p_dest AND amount < 500;
+    SELECT COUNT(*) INTO total_reservations FROM reservation WHERE id_destination = p_dest;
+
+    score := COALESCE(avg_rating,0)*0.5 + COALESCE(cheap_percent,0)*0.3 + COALESCE(total_reservations,0)*0.2;
+    RETURN score;
+END;
+$$;
+}}}
+
+
 === Релациска алгебра
 Најпопуларни дестинации по просечна оцена и број на резервации