product monitoring

3 files changed, 41 insertions, 1 deletions

diff --git a/indoteknik_custom/models/__init__.py b/indoteknik_custom/models/__init__.py
index 95defed6..1133c3e7 100755
--- a/indoteknik_custom/models/__init__.py
+++ b/indoteknik_custom/models/__init__.py
@@ -88,4 +88,5 @@ from . import account_move_line
 from . import stock_scheduler_compute
 from . import promotion
 from . import sale_orders_multi_update
-from . import quotation_so_multi_update
\ No newline at end of file
+from . import quotation_so_multi_update
+from . import product_monitoring
\ No newline at end of file
diff --git a/indoteknik_custom/models/product_monitoring.py b/indoteknik_custom/models/product_monitoring.py
new file mode 100644
index 00000000..df9701ab
--- /dev/null
+++ b/indoteknik_custom/models/product_monitoring.py
@@ -0,0 +1,35 @@
+from odoo import models, fields, tools, api
+
+class ProductMonitoring(models.Model):
+    _name = 'product.monitoring'
+    _auto = False
+    _rec_name = 'product_id'
+
+    id = fields.Integer()
+    product_id = fields.Many2one('product.product', string='Product')
+    outgoing_qty = fields.Float(string="Outgoing", related='product_id.outgoing_qty')
+    incoming_qty = fields.Float(string="Incoming", related='product_id.incoming_qty')
+    qty_available = fields.Float(string="On Hand", related='product_id.qty_available')
+    qty_upcoming = fields.Float(string="Upcoming", related='product_id.qty_upcoming')
+    status_stock = fields.Selection([
+        ('outgoing_gt_stock', 'Outgoing > Stock'),
+        ('outgoing_lt_stock', 'Outgoing < Stock'),
+    ], string="Status Stock", compute='_compute_status_stock')
+
+    def _compute_status_stock(self):
+        for product in self:
+            product.status_stock = 'outgoing_lt_stock' if product.outgoing_qty <= product.qty_upcoming else 'outgoing_gt_stock'
+
+    def init(self):
+        tools.drop_view_if_exists(self.env.cr, self._table)
+        self.env.cr.execute("""
+            CREATE OR REPLACE VIEW %s AS (
+                SELECT 
+                    sm.product_id AS id,
+                    sm.product_id AS product_id
+                FROM stock_move sm
+                LEFT JOIN stock_picking sp ON sm.picking_id = sp.id
+                WHERE sp.state NOT IN ('cancel', 'done') AND sm.product_id IS NOT null
+                GROUP BY sm.product_id
+            )
+        """ % self._table)
\ No newline at end of file
diff --git a/indoteknik_custom/models/product_template.py b/indoteknik_custom/models/product_template.py
index fb8561e7..e69d6044 100755
--- a/indoteknik_custom/models/product_template.py
+++ b/indoteknik_custom/models/product_template.py
@@ -329,8 +329,12 @@ class ProductProduct(models.Model):
     material = fields.Char(string='Material')
     qty_onhand_bandengan = fields.Float(string='Qty Incoming Bandengan', compute='_get_qty_onhand_bandengan')
     qty_incoming_bandengan = fields.Float(string='Qty Incoming Bandengan', compute='_get_qty_incoming_bandengan')
+    qty_upcoming = fields.Float(string='Qty Upcoming', compute='_get_qty_upcoming')
     sla_version = fields.Integer(string="SLA Version", default=0)
     is_edited = fields.Boolean(string='Is Edited')
+    def _get_qty_upcoming(self):
+        for product in self:
+            product.qty_upcoming = product.incoming_qty + product.qty_available
 
     def day_product_to_edit(self):
         day_products = []