Changes between Version 16 and Version 17 of AdvancedReports

Timestamp:

01/31/22 19:59:35 (3 years ago)

Author:

193288

Comment:

--

AdvancedReports

@@ -27 +27 @@
 == Прикажување на статистика кој паркинг носи најголема заработка
 {{{#!sql
-select lokacija,coalesce(sum(krajno_vreme-pocetno_vreme),0)*75 as vreme from ime_na_parking as inp
+select lokacija,
+coalesce(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
+group by inp.lokacija, rez.krajno_vreme, rez.pocetno_vreme
 order by vreme desc limit 1
   }}}