Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

01/21/22 17:03:30 (2 years ago)

Author:

193230

Comment:

--

AdvancedReports

@@ -129 +129 @@
 }}}
 
+== Извештај за вкупно продадени продукти по категорија
+{{{#!sql
+create view kategorija_produkti as
 
+select distinct c.category_id, c.category_name,
+case when tabela.naracan_proizvod >= 1 then tabela.naracan_proizvod else 0 end as naracani_proizvodi
+from category as c
+join product as p on p.category_id=c2.category_id
+join product_in_store as pis on p.product_id=pis.product_id
+join orders as o on o.product_in_store_id=pis.product_in_store_id
+join(
+        select distinct c2.category_id, c2.category_name, count(o.product_in_store_id) as naracan_proizvod
+        from category as c2
+        join product as p on p.category_id=c2.category_id
+        join product_in_store as pis on p.product_id=pis.product_id
+        join orders as o on o.product_in_store_id=pis.product_in_store_id
+        group by 1, 2
+) as tabela on c.category_id=tabela.category_id
+}}}
+