How to get latest date from a date field

python odoo9.0

6 Antwoorden

10842 Weergaven

amina

I want to get the latest date from a date field and show it in a new field of an other view so I used this function and it seems I'm doing something wrong what could it be?here is my code

def _get_latest_intervention(self, cr, uid, ids, latest, args, context=None):
       res = {}
       obj_intervention = self.pool.get('c.intervention'
       )for interv in self.browse(cr, uid, ids, context=context):
           intervention_ids = obj_intervention.search(cr, uid,    [('equipement_id' '=',, intervention_id)], order='date_intv'
           , context=context)if intervention_ids:
               res[intervention_id] = intervention_ids[-1:][0
           ]else False
       return:
               res[intervention_id] = res

to explain more this module is about management of technical centers of vehicul so I want to show the latest date of intervention of those technical centers in their form view in the field "latest" so I have created 3 menu items (centre,equipement,intervention) and I have put this function in the centre class

Lucio

You are looping (for _ in self.browse...) in elements of class intervention? I don't know, I'm just guessing from variable names. Is this method inside the class "Centre" ? What's the field that links togheter "centre" and "intervention"? What does equipement has to do with all this?

amina

Auteur

yes this methode is in the class"centre" ,I did this fault I wanted to wright 'centre_id' but I wrote 'equipement_id' so there is no equipements menchened in this function every centre has his equipements and all dates of intervention of equipments either it's a corrective maintenace or a preventive one so I want to add a new field in the centre form view named latest,which shows the latest added date in the intervention form view this classes are related of course with relational fields I will put all code to make it clearer

omar ahmed

see this maybe same idea

https://stackoverflow.com/questions/49748892/get-last-order-date-customer-in-odoo-partner-view

amina

Auteur

I changed somethings in my code so I want to show the date in the intervention_id field, here is my code

# -*- coding: utf-8 -*-
from openerp import models, fields, api
class centre(models.Model):
    _name = 'res.partner'
    _inherit = ['res.partner']
    def _get_latest_intervention(self, cr, uid, ids, field_name, args, context=None):
        res = {}
        obj_intervention = self.pool.get('c.intervention')
        for interv in self.browse(cr, uid, ids, context=context):
            intervention_ids = obj_intervention.search(cr, uid, [('centre_id', '=', intervention_id)], order='date_intv', context=context)
            if intervention_ids:
                res[intervention_id] = intervention_ids[-1:][0]
            else:
                res[intervention_id] = False
        return res
    rs_ctr = fields.Char(string='Réseau')
    nb_ligne = fields.Integer(string='Lignes')
    n_agr = fields.Integer(string='N° d\'agrèment')
    chef = fields.Char(string='Chef centre')
    prp = fields.Char(string='Propriétaire')
    equipement_id = fields.Many2one('product.template','Equipements',select=True)
    intervention_id = fields.Date(compute='_get_latest_intervention', type="Date", string='Derniére intervention')
  
    properties1 = fields.One2many('product.template','centre_id','Centres')
    
centre() 
class equipement(models.Model):
    _name = 'product.template'
    _inherit = ['product.template']
    
    name = fields.Char(string='Nom')
    num_ligne = fields.Integer(string='N° ligne')
    model_mat = fields.Char(string='Model de materiel')
    centre_id = fields.Many2one('res.partner','Centres',select=True) 
    properties2 = fields.One2many('c.maintenance','equipement_id','Equipements')
equipement()	

class maintenance(models.Model):
    _name = 'c.maintenance'
    _description = 'Maintenance'
    
    STATE_SELECTION =  [('c','Corrective'),('p','Préventive')]	
    type_int = fields.Selection(STATE_SELECTION,'Type d\'intervention')
    date_intv = fields.Date(string='Date d\'intervention')
    equipement_id = fields.Many2one('product.template','Equipements',select=True)  
     
    intervention_id = fields.Many2one('c.intervention','Interventions',select=True)
maintenance()		
class intervention(models.Model):
    _name = 'c.intervention'
    STATE_SELECTION =  [('c','Corrective'),('p','Préventive')]
    _description = 'Interventions'
    _inherits = {'res.partner':'centre_id'}
    _inherit = {'c.maintenance'}
    name = fields.Char(string='Nom')
    type_int = fields.Selection(STATE_SELECTION,'Type d\'intervention')
    properties4 = fields.One2many('c.maintenance','intervention_id','Interventions')
    centre_id = fields.Many2one('res.partner','Centres',select=True)
intervention()

what could be the right way to make this work please

Melvin

Is there anyway to record the intervention of a field in another field? like computing the field to store the intervention date of another field?

Priyesh Solanki

Hi,

Did you define intervention_id as a function field in another object in which you want to see latest intervention ?

amina

Auteur

no I definded field latest as the function field am I doing something wrong?

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
function get latest date python odoo9.0	1 jan. 16	5520
ir_attachment: IOError: [Errno 2] No such file or directory Opgelost python ir_attachment odoo9.0	1 aug. 21	65131
How to mention all channel user in Discuss using shortcuts? javascript python odoo9.0	1 sep. 20	6555
how to return value to javascript from python? Opgelost javascript python odoo9.0	3 apr. 18	34225
How to get a value from json? python json odoo9.0	0 jan. 16	5812

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!