1 files changed, 31 insertions, 0 deletions
diff --git a/indoteknik_custom/models/sale_order_delay.py b/indoteknik_custom/models/sale_order_delay.py
new file mode 100644
index 00000000..dfd94650
--- /dev/null
+++ b/indoteknik_custom/models/sale_order_delay.py
@@ -0,0 +1,31 @@
+from odoo import api, fields, models
+
+
+class SaleOrderDelay(models.Model):
+    _name = 'sale.order.delay'
+    _description = 'Sale Order Delay'
+    _primary_key = 'so_number'
+    
+    so_number = fields.Char(string="SO Number", required=True)
+    days_delayed = fields.Integer(string="Day Delayed or Erly")
+    status = fields.Selection([
+        ('delayed', 'Delayed'),
+        ('on track', 'On Track'),
+        ('early', 'Early')
+    ], string='Status', required=True)
+    
+    _sql_constraints = [
+        ('unique_so_number', 'unique(so_number)', 'SO Number must be unique!')
+    ]
+    
+    def update_delay(self):
+        query = "SELECT check_so_delay();"
+        self.env.cr.execute(query)
+    
+    @api.model
+    def create(self, vals):
+        return super(SaleOrderDelay, self).create(vals)
+
+    def write(self, vals):
+        return super(SaleOrderDelay, self).write(vals)
+    
+\ No newline at end of file