From 8655b19eb699f9b6450808d3ba087bb336c27f0d Mon Sep 17 00:00:00 2001 From: Azka Nathan Date: Wed, 10 Dec 2025 11:07:10 +0700 Subject: revisi buffer stock --- fixco_custom/models/reordering_rule.py | 15 +++++++++++++-- 1 file changed, 13 insertions(+), 2 deletions(-) (limited to 'fixco_custom/models') diff --git a/fixco_custom/models/reordering_rule.py b/fixco_custom/models/reordering_rule.py index dad07b0..787875b 100644 --- a/fixco_custom/models/reordering_rule.py +++ b/fixco_custom/models/reordering_rule.py @@ -13,6 +13,8 @@ class ReorderingRule(models.Model): vendor_id = fields.Many2one('res.partner', string='Vendor', readonly=True) qty_onhand = fields.Float(string='Qty Onhand', readonly=True) qty_incoming = fields.Float(string='Qty Incoming') + stock_status = fields.Char('Stock Status',readonly=True) + diff_stock = fields.Float(string='Diff Stock') def create_automatic_purchase(self): if not self: @@ -82,13 +84,22 @@ class ReorderingRule(models.Model): vmsbm.buffer_stock, vmsbm.vendor_id, COALESCE(SUM(sq.quantity), 0.0) AS qty_onhand, - vmsbm.incoming_qty AS qty_incoming + vmsbm.incoming_qty AS qty_incoming, + vmsbm.diff_stock AS diff_stock, + vmsbm.stock_status AS stock_status FROM view_manage_stock_below_min vmsbm LEFT JOIN stock_quant sq ON sq.product_id = vmsbm.product_id AND sq.location_id = 55 GROUP BY - vmsbm.id, vmsbm.product_id, vmsbm.min_stock, vmsbm.buffer_stock, vmsbm.vendor_id, vmsbm.incoming_qty + vmsbm.id, + vmsbm.product_id, + vmsbm.min_stock, + vmsbm.buffer_stock, + vmsbm.vendor_id, + vmsbm.incoming_qty, + vmsbm.diff_stock, + vmsbm.stock_status ) """) -- cgit v1.2.3