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)