Skip to Content
This question has been flagged
pythonodoo10
1 Respondre
7428 Vistes
Avatar
omar ahmed

hello odoo community,,

i have field 'production date' , 'duration' field and i need calculate 'expiration date' 

this is my module 

from odoo import fields,models


class MyMarketProduct(models.Model):
    _name = 'market.products'

    def _compute_expiry(self):
        self.production_date+self.valid_durity

    name = fields.Char()
    product_country = fields.Char()
    image = fields.Binary()
    production_date = fields.Date()
    desc = fields.Char()
    valid_durity = fields.Date()
    expiration_date = fields.Date(compute=_compute_expiry)
Avatar
Descartar
Avatar
Emipro Technologies Pvt. Ltd.
Best Answer

Hello Omar,

You can calculate with new field for duration like how many month,week,year etc.. instead of date field for duration.

You can do it like following :

 duration = fields.Char('Duration')
    duration_unit = fields.Selection([('month','Month'),('week','Week'),('day','Day'),('year','Year')])

Your calculation should be like following :

from dateutil.relativedelta import relativedelta

class MyMarketProduct(models.Model):
    _name = 'market.products'

    def _compute_expiry(self):
        
	if self.duration_unit=='month':
	    expiry_date=self.production_date + relativedelta(months = int(self.duration))
        elif self.duration_unit=='week':
	    expiry_date=self.production_date + relativedelta(weeks = int(self.duration))
        elif self.duration_unit=='day'                     
            expiry_date=self.production_date + relativedelta(days = int(self.duration))
        elif self.duration_unit=='year'                     
            expiry_date=self.production_date + relativedelta(years = int(self.duration)) 
                                   
	self.expiration_date=expiry_date

Thanks,

Avatar
Descartar
Related Posts Respostes Vistes Activitat
error ConfigParser.ParsingError: File contains parsing errors
python odoo10
Avatar
0
de març 21
6628
how to pass parameters using with_context ? Solved
python odoo10
Avatar
Avatar
3
de jul. 20
20997
odoo/python invalidate_all() Solved
python odoo10
Avatar
Avatar
Avatar
2
de gen. 19
7122
Function Python for Odoo 10
python odoo10
Avatar
Avatar
1
de des. 18
3029
odoo10 error,i can't submit helpdesk ticket Ask Question in our own server
python odoo10
Avatar
Avatar
1
d’abr. 18
3811