Changes between Version 4 and Version 5 of AdvancedReports

Timestamp:

02/03/22 12:25:25 (3 years ago)

Author:

193021

Comment:

--

AdvancedReports

@@ -171 +171 @@
  where br.br_rezervacii = (select max(br_rezervacii) from vkbr_rez_vraboteni)
 }}}
+
+=== Извештај за секој салон со број на резервации на годишно ниво (моменталната година) по квартали
+
+{{{
+select distinct bc.salon_id ,
+        case when broj_na_rezervacii.kvartal = 1 then broj_na_rezervacii.broj_rezervacii else 0 end as Kvartal1_broj_rezervacii,
+        case when broj_na_rezervacii.kvartal = 2 then broj_na_rezervacii.broj_rezervacii else 0 end as Kvartal2_broj_rezervacii,
+        case when broj_na_rezervacii.kvartal = 3 then broj_na_rezervacii.broj_rezervacii else 0 end as Kvartal3_broj_rezervacii,
+        case when broj_na_rezervacii.kvartal = 4 then broj_na_rezervacii.broj_rezervacii else 0 end as Kvartal4_broj_rezervacii
+  
+  from beautycenter as bc 
+  left join vraboteni_beautycenter as v_bc on bc.salon_id = v_bc.salon_id
+  left join vraboteni as v on v_bc.user_id_vraboten = v.user_id
+  left join termini as t on v.user_id = t.user_id_vraboten
+  left join rezervacija as r on t.termin_id = r.termin_id
+
+left join(
+select bc.salon_id, extract (quarter from t.pocetok) as kvartal, count(r.br_rez) as broj_rezervacii
+  from beautycenter as bc 
+  left join vraboteni_beautycenter as v_bc on bc.salon_id = v_bc.salon_id
+  left join vraboteni as v on v_bc.user_id_vraboten = v.user_id
+  left join termini as t on v.user_id = t.user_id_vraboten
+  left join rezervacija as r on t.termin_id = r.termin_id
+ where extract (year from t.pocetok) = extract (year from current_date)
+     group by 1,2
+) as broj_na_rezervacii   on bc.salon_id = broj_na_rezervacii.salon_id
+}}}
+