Changes between Version 21 and Version 22 of AdvancedReports

Timestamp:

02/01/22 14:10:18 (4 years ago)

Author:

193187

Comment:

--

AdvancedReports

@@ -47 +47 @@
 == Извештај за заработка на паркинзите во првите 6 месеци oд тековната година
 {{{#!sql
+select * 
+FROM
+  (
+  select lokacija,
+coalesce(sum (date_part('hour',krajno_vreme-pocetno_vreme)),'0')*75 as vreme_januari
+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
+where extract(month from pocetno_vreme)=1 and extract(year from pocetno_vreme)=extract(year from now()) 
+group by inp.lokacija
+order by vreme_januari desc 
+  ) as inp
+left join
+  (
+    select lokacija,
+coalesce(sum (date_part('hour',krajno_vreme-pocetno_vreme)),'0')*75 as vreme_februari
+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
+where extract(month from pocetno_vreme)=2
+group by inp.lokacija
+order by vreme_februari desc 
+  ) as inpp
+  ON
+      inp.lokacija = inpp.lokacija
+left join  (
+  select lokacija,
+coalesce(sum (date_part('hour',krajno_vreme-pocetno_vreme)),'0')*75 as vreme_mart
+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
+where extract(month from pocetno_vreme)=3
+group by inp.lokacija
+order by vreme_mart desc 
+  ) as inppp
+    ON
+      inpp.lokacija = inppp.lokacija 
+ left join  (
+  select lokacija,
+coalesce(sum (date_part('hour',krajno_vreme-pocetno_vreme)),'0')*75 as vreme_april
+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
+where extract(month from pocetno_vreme)=4
+group by inp.lokacija
+order by vreme_april desc 
+  ) as inp1
+    ON
+      inp1.lokacija = inppp.lokacija     
+     left join  (
+  select lokacija,
+coalesce(sum (date_part('hour',krajno_vreme-pocetno_vreme)),'0')*75 as vreme_maj
+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
+where extract(month from pocetno_vreme)=5
+group by inp.lokacija
+order by vreme_maj desc 
+  ) as inp2
+    ON
+      inp1.lokacija = inp2.lokacija 
+     left join  (
+  select lokacija,
+coalesce(sum (date_part('hour',krajno_vreme-pocetno_vreme)),'0')*75 as vreme_juni
+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
+where extract(month from pocetno_vreme)=6
+group by inp.lokacija
+order by vreme_juni desc 
+  ) as inp3
+    ON
+      inp2.lokacija = inp3.lokacija 
+