Changes between Version 8 and Version 9 of AdvancedReports

Timestamp:

02/12/26 03:54:16 (12 days ago)

Author:

221181

Comment:

--

AdvancedReports

@@ -18 +18 @@
 }}}
 
+'''Релациона алгебра:'''
+{{{
+τ total_stock_value (
+  γ warehouse_id, warehouse_name ; SUM(quantity_on_hand)->total_units, SUM(stock_value)->total_stock_value (
+    π warehouse_id, warehouse_name, quantity_on_hand, quantity_on_hand * unit_price -> stock_value (
+      (warehouse_stock ⋈ ρ name->warehouse_name (warehouse)) ⋈ ρ name->product_name (product)
+    )
+  )
+)
+}}}
+
 == 2. Приход од продажба по производ ==
 
@@ -32 +43 @@
 GROUP BY p.product_id, p.name
 ORDER BY total_revenue DESC;
+}}}
+
+'''Релациона алгебра:'''
+{{{
+τ total_revenue (
+  γ product_id, product_name ; SUM(quantity)->total_units_sold, SUM(revenue)->total_revenue (
+    π product_id, product_name, quantity, quantity * unit_price_at_sale -> revenue (
+      sale_item ⋈ ρ name->product_name (product)
+    )
+  )
+)
 }}}
 
@@ -52 +74 @@
 }}}
 
+'''Релациона алгебра:'''
+{{{
+τ po_id (
+  π po_id, status, product_name, quantity->ordered_quantity, received_quantity, quantity - received_quantity -> pending_quantity (
+    purchase_order ⋈ purchase_order_item ⋈ ρ name->product_name (product)
+  )
+)
+}}}
+
 == 4. Продажба по категорија ==
 
@@ -68 +99 @@
 }}}
 
+'''Релациона алгебра:'''
+{{{
+τ total_category_revenue (
+  γ category_id, category_name ; SUM(revenue)->total_category_revenue (
+    π category_id, category_name, quantity * unit_price_at_sale -> revenue (
+      sale_item ⋈ ρ name->product_name, description->product_desc (product) ⋈ ρ name->category_name, description->category_desc (category)
+    )
+  )
+)
+}}}
+
 == 5. Искористеност на капацитетот на магацините ==
 
@@ -81 +123 @@
 LEFT JOIN warehouse_stock ws ON w.warehouse_id = ws.warehouse_id
 GROUP BY w.warehouse_id, w.name, w.capacity;
+}}}
+
+'''Релациона алгебра:'''
+{{{
+τ occupancy_percentage (
+  π warehouse_name, capacity->total_unit_capacity, units_in_stock, (units_in_stock / capacity) * 100 -> occupancy_percentage (
+    γ warehouse_id, warehouse_name, capacity ; SUM(quantity_on_hand)->units_in_stock (
+      ρ name->warehouse_name (warehouse) ⟕ warehouse_stock
+    )
+  )
+)
 }}}
 
@@ -100 +153 @@
 HAVING MAX(s.date_time) < CURRENT_DATE - INTERVAL '90 days' OR MAX(s.date_time) IS NULL;
 }}}
+
+'''Релациона алгебра:'''
+{{{
+τ product_name (
+  π product_name, sku, quantity_on_hand (
+    (ρ name->product_name (product) ⋈ warehouse_stock)
+    -
+    π product_name, sku, quantity_on_hand (
+      ρ name->product_name (product) ⋈ warehouse_stock ⋈ sale_item
+    )
+  )
+)
+}}}