Changes between Version 17 and Version 18 of AdvancedReports

Timestamp:

01/31/22 20:10:01 (3 years ago)

Author:

193288

Comment:

--

AdvancedReports

@@ -28 +28 @@
 {{{#!sql
 select lokacija,
-coalesce(date_part('hour',krajno_vreme-pocetno_vreme),'0')*75 as vreme
+coalesce(sum (date_part('hour',krajno_vreme-pocetno_vreme)),'0')*75 as vreme
 from ime_na_parking as inp
 left join zona as z on ime_na_parking_id_ime =id_ime
 left join parking_mesto as pm on id_zona= idzona
 left join rezervacija as rez on rez.broj_na_pmesta=pm.broj_na_pmesta
-group by inp.lokacija, rez.krajno_vreme, rez.pocetno_vreme
+group by inp.lokacija
 order by vreme desc limit 1
   }}}