1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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)
|
