Changes between Version 8 and Version 9 of AdvancedReports

Timestamp:

08/16/25 00:22:42 (3 days ago)

Author:

221071

Comment:

--

AdvancedReports

@@ -250 +250 @@
 === 6.Анализа на пазарни трендови и изнајмувачка понуда по општина, град и тип на недвижност
 {{{
+SET search_path TO domify, public;
+
 WITH MarketTrends AS (
     SELECT 
@@ -290 +292 @@
     ROUND(total_interested_tenants / NULLIF(available_listings, 0), 2) as interest_ratio,
     CASE 
-        WHEN availability_rate > 75 THEN 'Висока понуда'
-        WHEN availability_rate > 50 THEN 'Умерена понуда'
-        WHEN availability_rate > 25 THEN 'Ограничена понуда'
+        WHEN ROUND((available_listings * 100.0 / NULLIF(total_listings, 0)), 2) > 75 THEN 'Висока понуда'
+        WHEN ROUND((available_listings * 100.0 / NULLIF(total_listings, 0)), 2) > 50 THEN 'Умерена понуда'
+        WHEN ROUND((available_listings * 100.0 / NULLIF(total_listings, 0)), 2) > 25 THEN 'Ограничена понуда'
         ELSE 'Ниска Понуда'
     END as market_availability_status