Changes between Version 7 and Version 8 of AdvancedReports

Timestamp:

08/16/25 00:18:42 (4 days ago)

Author:

221071

Comment:

--

AdvancedReports

@@ -203 +203 @@
 === 5. Детален извештај за сервисни барања, стапка на завршување и просечно време на решавање по општина и град
 {{{
+SET search_path TO domify, public;
+
 WITH MaintenanceAnalysis AS (
     SELECT 
@@ -214 +216 @@
         AVG(CASE 
             WHEN sr.status = 'завршено' AND ml.maintenance_date IS NOT NULL 
-            THEN DATEDIFF(ml.maintenance_date, sr.request_date) 
+            THEN (ml.maintenance_date::date - sr.request_date::date)
         END) as avg_resolution_days
     FROM ServiceRequest sr