From 8655b19eb699f9b6450808d3ba087bb336c27f0d Mon Sep 17 00:00:00 2001
From: Azka Nathan <darizkyfaz@gmail.com>
Date: Wed, 10 Dec 2025 11:07:10 +0700
Subject: revisi buffer stock

---
 fixco_custom/models/reordering_rule.py | 15 +++++++++++++--
 fixco_custom/views/reordering_rule.xml |  4 ++++
 2 files changed, 17 insertions(+), 2 deletions(-)

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
             )
         """)
diff --git a/fixco_custom/views/reordering_rule.xml b/fixco_custom/views/reordering_rule.xml
index dbc3e13..85249ad 100644
--- a/fixco_custom/views/reordering_rule.xml
+++ b/fixco_custom/views/reordering_rule.xml
@@ -11,6 +11,8 @@
                 <field name="qty_onhand"/>
                 <field name="qty_incoming"/>
                 <field name="vendor_id"/>
+                <field name="diff_stock"/>
+                <field name="stock_status"/>
             </tree>
         </field>
     </record>
@@ -29,6 +31,8 @@
                             <field name="qty_onhand"/>
                             <field name="qty_incoming"/>
                             <field name="vendor_id"/>
+                            <field name="diff_stock"/>
+                            <field name="stock_status"/>
                         </group>
                     </group>
                 </sheet>
-- 
cgit v1.2.3