Changes between Version 6 and Version 7 of AdvancedReports

Timestamp:

01/01/23 22:50:02 (3 years ago)

Author:

181213

Comment:

--

AdvancedReports

@@ -57 +57 @@
 order by broj_naracki desc
 }}}
-- Кој корисник колку има платено во секој ресторан подредено?
+- Кој корисник колку има платено во секој ресторан подредено
+{{{#!sql
+select k2.user_ime as ime, k2.user_prezime as prezime, r2.restoran_ime as restoran, q1.plateno as plateno from( 
+select ku.user_id, r.restoran_id, sum(sso.cena * sso.kolicina) as plateno
+from korisnik k
+join kupuvac as ku on k.user_id =ku.user_id 
+join naracka as n on ku.user_id =n.user_id_kupuvac 
+join se_sostoi_od as sso on n.naracka_id =sso.naracka_id 
+join obrok as o on sso.obrok_id =o.obrok_id 
+join meni as m on o.meni_id=m.meni_id 
+join restoran as r on m.restoran_id =r.restoran_id 
+group by  ku.user_id ,r.restoran_id)q1 join korisnik k2 on q1.user_id=k2.user_id  join restoran r2 on q1.restoran_id=r2.restoran_id
+order by plateno desc
+}}}