Changes between Version 7 and Version 8 of AdvancedReports

Timestamp:

01/25/22 20:22:29 (3 years ago)

Author:

193288

Comment:

--

AdvancedReports

@@ -8 +8 @@
 == Листа од прекшроци кој начесто се случуваат на ниво на сите паркинзи
 {{{#!sql
-    select z.Id_zona,  count(p.broj_na_pmesta) from zona as z
-  join parking_mesto as p on z.Id_zona=p.IdZona
-  group by z.id_zona
+    select lokacija,coalesce(sum(krajno_vreme-pocetno_vreme),0) 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
+order by vreme desc limit 1
   }}}
 
@@ -22 +25 @@
 == Прикажување на статистика кој паркинг носи најголема заработка
 {{{#!sql
-    select z.Id_zona,  count(p.broj_na_pmesta) from zona as z
-  join parking_mesto as p on z.Id_zona=p.IdZona
-  group by z.id_zona
+    select  tip_plakjanje , count( tip_plakjanje) as brpt from plakjanje
+group by tip_plakjanje
+order by brpt desc limit 1
   }}}