Changes between Version 11 and Version 12 of AdvancedReports

Timestamp:

01/05/24 15:31:30 (22 months ago)

Author:

216049

Comment:

--

AdvancedReports

@@ -85 +85 @@
 
 ==== 6. Период од денот (интервали од 1 час) во кој најмногу се пишуваат казни
+
+==== 7. Вкупна заработувачка од билети и казни на претпријатието во минатата календарска година
+
+{{{#!div style="font-size: 80%"
+  {{{#!sql
+select
+CASE 
+  WHEN sum_kz IS NOT NULL AND sum_b IS NOT NULL THEN COALESCE(sum_kz::int, 0) + COALESCE(sum_b::int, 0)
+  WHEN sum_kz IS NOT NULL THEN COALESCE(sum_kz::int, 0)
+  WHEN sum_b IS NOT NULL THEN COALESCE(sum_b::int, 0)
+  ELSE 0
+END
+from (
+select 
+(
+select sum(kz_iznos)
+from kazna k
+where k.kz_plateno = true and (k.kz_datum between (make_date(extract(year from (now() - '1 years'::interval))::int, 1, 1)) and
+                                                                        (make_date(extract(year from (now() - '1 years'::interval))::int, 12, 31)))
+                                                                        and (k.kz_datum_plateno between (make_date(extract(year from (now() - '1 years'::interval))::int, 1, 1)) and
+                                                                        (make_date(extract(year from (now() - '1 years'::interval))::int, 12, 31)))
+)  sum_kz,
+(
+select sum(tb_cena)
+from bilet b 
+join tipbilet tb on tb.tb_id = b.tb_id 
+where b.b_datum_na_kupuvanje between (make_date(extract(year from (now() - '1 years'::interval))::int, 1, 1)) and
+                                                                        (make_date(extract(year from (now() - '1 years'::interval))::int, 12, 31))
+)  sum_b
+)
+
+  }}}
+}}}