Changes between Version 7 and Version 8 of AdvancedReports

Timestamp:

05/28/26 13:50:19 (2 weeks ago)

Author:

232012

Comment:

--

AdvancedReports

@@ -14 +14 @@
         op.product_id,
         SUM(op.quantity) AS total_sold_yearly,
-        
+
         SUM(op.quantity) / 365.0 AS daily_sales_velocity
     FROM project.ORDER_PRODUCTS op
     JOIN project.ORDERS o ON op.order_id = o.order_id
-    
+
     WHERE o.purchase_date >= CURRENT_DATE - INTERVAL '1 year'
       AND o.status IN ('PAID', 'SHIPPED', 'DELIVERED')
@@ -32 +32 @@
         psy.total_sold_yearly,
         psy.daily_sales_velocity,
-        
+
         CASE 
             WHEN psy.daily_sales_velocity > 0 THEN p.stock / psy.daily_sales_velocity
@@ -47 +47 @@
     stock AS current_stock,
     total_sold_yearly,
-    ROUND(daily_sales_velocity, 4) AS daily_velocity,
-    ROUND(days_until_out_of_stock, 1) AS days_left,
-    
+    ROUND(CAST(daily_sales_velocity AS NUMERIC), 4) AS daily_velocity,
+    ROUND(CAST(days_until_out_of_stock AS NUMERIC), 1) AS days_left,
+
     CEIL((daily_sales_velocity * 90) - stock) AS recommended_restock_quantity,
-    
-    ROUND(CEIL((daily_sales_velocity * 90) - stock) * price, 2) AS estimated_restock_cost
+
+    ROUND((CEIL((daily_sales_velocity * 90) - stock) * price)::numeric, 2) AS estimated_restock_cost
 FROM inventory_velocity
 WHERE days_until_out_of_stock < 30