Changes between Version 12 and Version 13 of AdvancedReports

Timestamp:

06/05/26 16:30:07 (6 days ago)

Author:

232012

Comment:

--

AdvancedReports

@@ -176 +176 @@
   last_purchase_date := MAX(o.purchase_date)
 (
-  σ o.purchase_date >= NOW - 6 months
+  σ o.purchase_date >= CURRENT_DATE - 6 months
     ∧ o.status ∈ {PAID, SHIPPED, DELIVERED}
   (
@@ -190 +190 @@
 )
 
-DeadStockAnalysis <-
+JoinedData <-
+(
+  (
+    PRODUCTS p ⨝ (p.release_id = r.release_id) RELEASES r
+  )
+  ⟕ (p.product_id = ps.product_id) ProductSales6M ps
+  ⟕ (p.product_id = wc.product_id) WishlistCounts wc
+)
+
+Result <-
 π p.product_id,
-  r.title,
+  release_title := r.title,
   p.format,
   unsold_stock_quantity := p.stock,
   current_unit_price := p.price,
   frozen_capital := p.stock * p.price,
-  last_sold_date := COALESCE(ps.last_purchase_date, 'NEVER BOUGHT'),
+  last_sold_date := COALESCE(TO_CHAR(ps.last_purchase_date, 'YYYY-MM-DD'), 'NEVER BOUGHT'),
   times_on_wishlists := COALESCE(wc.wishlist_addition_count, 0),
   inventory_action_plan :=
@@ -206 +215 @@
     END
 (
-  (
-    PRODUCTS p ⨝ (p.release_id = r.release_id) RELEASES r
-  )
-  ⟕ ProductSales6M ps
-  ⟕ WishlistCounts wc
-)
-
-Result <-
-σ ps.product_id IS NULL ∧ p.stock > 0
-(
-  DeadStockAnalysis
-)
+  σ ps.product_id IS NULL ∧ p.stock > 0
+  (
+    JoinedData
+  )
+)
+
+τ frozen_capital ↓, times_on_wishlists ↓ (Result)
 }}}