Changes between Version 6 and Version 7 of AdvancedReports

Timestamp:

02/03/24 21:58:47 (8 months ago)

Author:

201171

Comment:

--

AdvancedReports

@@ -86 +86 @@
 limit 10;
 }}}
+
+=== Извештај за остатокот од гаранцијата во денови на купениот производ
+
+{{{
+select
+    category.category_name,
+    product.product_name,
+    order_table.order_id,
+    date_trunc('day', (order_table.order_date + interval '1 year' * product.product_warranty) - now()) as remaining_warranty
+from
+    order_table
+join order_table_contains_product on order_table.order_id = order_table_contains_product.order_id
+join product on order_table_contains_product.product_id = product.product_id
+join product_is_in_category on product_is_in_category.product_id = product.product_id
+join category on category.category_id = product_is_in_category.product_id
+}}}