Skip to Content
This question has been flagged
pythondatesearchorderodoo12
1 Respondre
7603 Vistes
Avatar
Daniel Aguado

I have created a new model called project.phase, referenced on the project.project model from a one2many field (x_project_phaselist).

project.phase has the following fields: name, start_date, end_date, total_days, project_id

Working good. Now I need to get the overall for those phases to get the project totals.

I have managed to get the sum of total_days, using the following code:

for record in self:
    record['x_project_total_phases'] = sum(line['total_days'] for line in record['x_project_phaselist'])

Now I need to get the lowest start_date and the highest end_date, to be stored on two new fields on project.project. ​​With the following code, I've been able to get the lowest date but from all the project.phase on all the projects, not the ones referenced on the actual project, referenced by project_id

for record in self:
      recs = record['x_project_phaselist'].search([], order='start_date asc')          
      if recs:           
        record['x_project_min_date'] = recs[0].start_date

I need help to get only the phases for that project to be taken on account. Also I need help getting the higher end_date, as using the same but changing start_date for end_date and changing the asc for desc is not doing anything.

For info, I'm using the inbuilt editor, not coding new modules on .py but using the web builder, which I think is a very nice tool.


Avatar
Descartar
Avatar
Daniel Aguado
Autor Best Answer

Auto answering my question, just in case it can help someone. I fixed it with the following code:

for record in self:
    dates = [] #Declaring empty array
    for line in record['x_project_phaselist']: #foreach phase
       if isinstance(line.end_date, datetime.date): #if the date is set
          dates.append(line.end_date) #Add it to the array
    record['x_project_max_date'] = max(dates) #Get the max from that array

I need to create the array and check for the type so I don't get the unordenable error when empty dates are taken.

It's working for now.


Avatar
Descartar
Related Posts Respostes Vistes Activitat
Create Journal Entries whit code Solved
python odoo12
Avatar
Avatar
Avatar
2
d’ag. 25
7600
Two many2many fields related to each other inside one model Solved
python odoo12
Avatar
1
de juny 22
9461
how to make invoice date field readonly false for administrator after validating invoice in odoo12?
python odoo12
Avatar
Avatar
1
de set. 21
4150
Update tax in invoice line
python odoo12
Avatar
0
d’ag. 21
95
How do I find Average Cost Function?
python odoo12
Avatar
0
de jul. 21
172