Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

12/28/22 12:43:24 (3 years ago)

Author:

201084

Comment:

--

AdvancedReports

@@ -155 +155 @@
 
 }}}
+=== Извештај за деловите кои биле нарачани во последните 3 месеци, со нивни категории и производители и количината која била нарачана ===
+{{{#!sql
+select p.id_part, p.part_name, cat.category_name, pm.pm_name,
+       sum(ocp.quantity_order) as narachani_posledni_3_meseci
+from project.part as p
+join project.part_manufacturer as pm on p.id_part_manufacturer = pm.id_part_manufacturer
+join project.part_is_from_category as pifc on p.id_part = pifc.id_part
+join project.category as cat on pifc.id_category = cat.id_category
+join project.order_contains_part as ocp on p.id_part = ocp.id_part
+join project.order_table as o on ocp.id_order = o.id_order
+                                  and
+                              o.order_date between now()-interval'3 months' and now()
+group by p.id_part, p.part_name, cat.category_name, pm.pm_name
+}}}