Changes between Version 8 and Version 9 of AdvancedReports

Timestamp:

02/04/24 18:38:07 (8 months ago)

Author:

201171

Comment:

--

AdvancedReports

@@ -6 +6 @@
     count(order_table.order_id),
     product.product_name
-from order_table
-    left join order_table_contains_product on order_table_contains_product.order_id = order_table.order_id
-    left join product on product.product_id  = order_table_contains_product.product_id
-where order_table.order_status = 'Delivered' 
+from 
+    order_table
+left join order_table_contains_product on order_table_contains_product.order_id = order_table.order_id
+left join product on product.product_id  = order_table_contains_product.product_id
+where
+    order_table.order_status = 'Delivered' 
     and order_table.order_date between  now() - interval '3 months' and now()
-group by product.product_name
+group by 
+    product.product_name
 }}}
 
@@ -102 +105 @@
 join category on category.category_id = product_is_in_category.product_id
 }}}
+
+=== Извештај за сите доставувачи кои доставиле продукти, бројот на продукти кои ги доставиле и нивната вкупна вредност
+
+{{{
+select 
+    user_table.name_user,
+    count(delivery.delivery_id),
+    sum(product.product_price)
+from 
+    user_table
+join delivery_man on delivery_man.user_id = user_table.user_id
+join delivery on delivery.delivery_man_id = delivery_man.user_id
+join order_table on order_table.order_id = delivery.order_id 
+join order_table_contains_product on order_table_contains_product.order_id = order_table.order_id 
+join product on product.product_id = order_table_contains_product.product_id
+where
+    order_table.order_status = 'Delivered'
+group by 
+    user_table.name_user
+}}}