Changes between Version 11 and Version 12 of AdvancedReports

Timestamp:

03/07/23 19:51:19 (22 months ago)

Author:

201045

Comment:

--

AdvancedReports

@@ -63 +63 @@
 {{{#!sql
 create view dostavuvac_dostavi_za_sekoe_prod_mesto as 
-        select k.ime,p.ime as ime_mesto,count(distinct n2.naracka_id) as broj_naracki,sum(n.iznos) as vkupna_suma 
+        select distinct k.ime,p.ime as ime_mesto,count(distinct n2.naracka_id) as broj_naracki,sum(n.iznos) as vkupna_suma 
         from korisnik k  join dostavuvac  d 
         on k.korisnik_id = d.korisnik_id
@@ -88 +88 @@
 {{{#!sql
 
-create view franshiza_promet_mesta_tri_meseci as select f.ime as ime_franshiza, p.ime as ime_prodaznomesto, sum(n2.iznos) as vkupen_promet
+create view franshiza_promet_mesta_tri_meseci as select distinct f.ime as ime_franshiza, p.ime as ime_prodaznomesto, sum(n2.iznos) as vkupen_promet
 from franshiza f join prodazhnomesto p on f.franshiza_id = p.franshiza_id 
 join naracka n on n.id_mesto  = p.id_mesto