Changes between Version 6 and Version 7 of AdvancedReports

Timestamp:

01/04/23 10:10:08 (2 years ago)

Author:

201130

Comment:

--

AdvancedReports

@@ -7 +7 @@
 {{{
 select p.ime , 
+
 count(nsp) as broj_na_naracki_vo_koi_e_prisuten_produktot, 
+
 sum(nsp.kolicina) as kolicina_prodadeno_od_produktot, 
-(select avg(n4.vkupno_suma) from naracka n4 join naracka_sodrzi_produkt nsp4 on n4.id_naracka = nsp4.id_naracka  
-where n4.id_naracka =nsp4.id_naracka and p.id_produkt = nsp4.id_produkt and n4.datum between now() - interval '3months' and now())
+
+(select avg(n4.vkupno_suma) from naracka n4 
+join naracka_sodrzi_produkt nsp4 on n4.id_naracka = nsp4.id_naracka  
+where n4.id_naracka =nsp4.id_naracka and p.id_produkt = nsp4.id_produkt and n4.datum between now() - interval '3months' 
+and now())
 as prosecna_suma_na_naracka_vo_koja_se_sodrzi_produktot,
+
 (select count(n2) from naracka n2 join naracka_sodrzi_produkt nsp2 on n2.id_naracka = nsp2.id_naracka 
-where nsp2.id_produkt = p.id_produkt and n2.adresa like '/' and n2.datum between now() - interval '3months' and now())
+where nsp2.id_produkt = p.id_produkt and n2.adresa like '/' 
+and n2.datum between now() - interval '3months' and now())
 as broj_na_naracki_na_produktot_koi_korisnikot_sam_ke_gi_podigne,
-(select sum(nsp2.kolicina) from naracka n2 join naracka_sodrzi_produkt nsp2 on n2.id_naracka = nsp2.id_naracka 
-where nsp2.id_produkt = p.id_produkt and n2.adresa like '/' and n2.datum between now() - interval '3months' and now()) 
+
+(select sum(nsp2.kolicina) from naracka n2 
+join naracka_sodrzi_produkt nsp2 on n2.id_naracka = nsp2.id_naracka 
+where nsp2.id_produkt = p.id_produkt and n2.adresa like '/' 
+and n2.datum between now() - interval '3months' and now()) 
 as  kolicina_prodadena_na_produktot_bez_dostava,
-(select count(n3) from naracka n3 join naracka_sodrzi_produkt nsp3 on n3.id_naracka = nsp3.id_naracka 
+
+(select count(n3) from naracka n3 
+join naracka_sodrzi_produkt nsp3 on n3.id_naracka = nsp3.id_naracka 
 where nsp3.id_produkt = p.id_produkt and n3.adresa not like '/' and n3.datum between now() - interval '3months' and now())
 as broj_na_naracki_na_produktot_koi_ke_bidat_dostaveni_na_korisnikot,
-(select sum(nsp3.kolicina) from naracka n3 join naracka_sodrzi_produkt nsp3 on n3.id_naracka = nsp3.id_naracka
+
+(select sum(nsp3.kolicina) from naracka n3 
+join naracka_sodrzi_produkt nsp3 on n3.id_naracka = nsp3.id_naracka
 where nsp3.id_produkt = p.id_produkt and n3.adresa not like '/' and n3.datum between now() - interval '3months' and now())
 as kolicina_prodadena_na_produktot_preku_dostava
+
 from produkt p
 join naracka_sodrzi_produkt nsp on p.id_produkt = nsp.id_produkt 
@@ -39 +54 @@
 {{{
 select k.ime_prezime,
+
 (select count(n) from naracka n
 where n.id_korisnik  = k.id_korisnik)
 as vkupno_naracki, 
+
 (select avg(vkupno_suma) from naracka )
 as prosecna_suma_na_naracka_za_site_kupuvaci,
+
 (select sum(n3.vkupno_suma) from naracka n3 
 where k.id_korisnik = n3.id_korisnik) 
 as vkupno_suma_od_site_naracki_na_kupuvacot,
+
 (select count(n2) from naracka n2
 where k.id_korisnik = n2.id_korisnik 
@@ -52 +71 @@
 and n2.vkupno_suma > (select avg(vkupno_suma) from naracka) )
 as vkupno_naracki_nad_prosek_na_korisnikot,
+
 (select sum(n4.vkupno_suma) from naracka n4 
 where  k.id_korisnik = n4.id_korisnik 
@@ -57 +77 @@
 and n4.vkupno_suma > (select avg(vkupno_suma) from naracka) ) 
 as vkupno_suma_na_naracki_nad_prosek_za_korisnikot
+
 from korisnik k 
 join kupuvac k2 on k.id_korisnik = k2.id_korisnik